ERPstuff - Oracle EBS Community

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

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,

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.

Dear Eng Ahmed,

I mean do we have an API for this?

Thanks in advance.

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

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.