Procedure For Creating Sick Leave Element - API

Oracle Human Resource (Core HR), Payroll, Time & Labor, Self Service HR, Advance Benefit, Talent Management (Performance Management, Competency Management, Performance Appraisal, Goal Management), iRecruitment, Compensation Workbench
Post Reply
m_muzamil_khan
Posts: 41
Joined: Tue May 05, 2009 5:19 am
Location: Pakistan

Procedure For Creating Sick Leave Element - API

Post by m_muzamil_khan »

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)




Image

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
eng_ahmad_2007
Posts: 258
Joined: Sun Oct 12, 2008 1:50 pm
Location: Saudi Arabia
Contact:

Post by eng_ahmad_2007 »

Dear Muzamil,

Do you mean you want the API that creates this element? and are you going to implement it through external request (procedure).
Also, why do you need this? for element loading?
And did you create an absence type for this element?

Best Regards,
Maham
Posts: 13
Joined: Thu Jun 11, 2009 11:50 pm
Location: Pakistan

Post by Maham »

No activity on this topic.

OK, If i am to create leave element automatically without using element definition forms.

Will i be able to do?

Kindly guide me. (Also if any severe problems can be?)

Thank you.
Maham
Posts: 13
Joined: Thu Jun 11, 2009 11:50 pm
Location: Pakistan

Post by Maham »

Dear Eng Ahmed,

I mean do we have an API for this?

Thanks in advance.
m_muzamil_khan
Posts: 41
Joined: Tue May 05, 2009 5:19 am
Location: Pakistan

Post by m_muzamil_khan »

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
eng_ahmad_2007
Posts: 258
Joined: Sun Oct 12, 2008 1:50 pm
Location: Saudi Arabia
Contact:

Post by eng_ahmad_2007 »

Dear Muzamil,

Thanks for sharing the code.

Dear Maham,

You can use the code that Muzamil provided. This will create the API automatically. Just be careful to pass the correct parameters.

If you need any help regarding this topic, feel free to ask.
Post Reply

Who is online

Users browsing this forum: No registered users and 2 guests