Dear Friends,
I need the Procedure that will create the Sick Leave Element by providing the following parameters details using the standards Oracle Create_Element_API.
xxmmt_create_leave_element(o_errbuf OUT NOCOPY VARCHAR2,
o_retcode OUT NOCOPY NUMBER,
p_effective_start_date in DATE,
p_effective_end_date in DATE, p_element_name in varchar2, p_emp_no in number)
the sick leave element should be created automatically with the input values.?
If you need further details about my requirement then let me know.
Kind Regards,
Muzamil Khan
muzzamil.khan[@]gmail.com
Procedure For Creating Sick Leave Element - API
-
- Posts: 41
- Joined: Tue May 05, 2009 5:19 am
- Location: Pakistan
-
- Posts: 258
- Joined: Sun Oct 12, 2008 1:50 pm
- Location: Saudi Arabia
- Contact:
-
- Posts: 41
- Joined: Tue May 05, 2009 5:19 am
- Location: Pakistan
Dear All,
I got the solution by using the follwoing API in my procedure:
Pay_Element_Entry_Api.create_element_entry
(p_effective_date => ld_effective_date
,p_business_group_id => ln_bg_id
,p_assignment_id => ln_assignment_id--p_assignment_id
,p_element_link_id => ln_ot_link_id
,p_entry_type => 'E' --For Entry
,p_input_value_id1 => ln_input_value_ot --Input Value ID for Hours
,p_entry_value1 => ln_ot_hrs
,p_effective_start_date => ld_effective_start_date
,p_effective_end_date => ld_effective_end_date
,p_element_entry_id => ln_element_entry_id
,p_object_version_number=> ln_object_version_number
,p_create_warning => lb_create_warning
);
If you need the whole code then let me know
Regards,
Muzamil Khan
I got the solution by using the follwoing API in my procedure:
Pay_Element_Entry_Api.create_element_entry
(p_effective_date => ld_effective_date
,p_business_group_id => ln_bg_id
,p_assignment_id => ln_assignment_id--p_assignment_id
,p_element_link_id => ln_ot_link_id
,p_entry_type => 'E' --For Entry
,p_input_value_id1 => ln_input_value_ot --Input Value ID for Hours
,p_entry_value1 => ln_ot_hrs
,p_effective_start_date => ld_effective_start_date
,p_effective_end_date => ld_effective_end_date
,p_element_entry_id => ln_element_entry_id
,p_object_version_number=> ln_object_version_number
,p_create_warning => lb_create_warning
);
If you need the whole code then let me know
Regards,
Muzamil Khan
-
- Posts: 258
- Joined: Sun Oct 12, 2008 1:50 pm
- Location: Saudi Arabia
- Contact:
Who is online
Users browsing this forum: No registered users and 2 guests