Wednesday, 20 February 2013

How to create element entries and value in Payroll using API

1) API for creating element entries is PAY_ELEMENT_ENTRY_API.create_element_entry.
2) The procedure has lot of parameters, it mainly depends from project to project which all parameters value have to be passed.
3) There are few mandatory parameters which can be found in the PAY_ELEMENT_ENTRY_API spec.

4) Below is the example API for creating element entry with out any value.

         PAY_ELEMENT_ENTRY_API.create_element_entry
                           (p_validate                    => FALSE
                           ,p_effective_date              => to_date('01-JAN-2013','DD/MM/YYYY')--trunc('01-JAN-2013')
                           ,p_business_group_id           => emp_rec.business_group_id
                           ,p_assignment_id               => emp_rec.assignment_id
                           ,p_element_link_id             => element_rec.element_link_id
                           ,p_entry_type                  => 'E'
                           ,p_input_value_id1             => element_rec.input_value_id
                           ,p_entry_value1                => NULL
                           ,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              => lc_create_warning
                            );

5) Also refer the table pay_element_types_f  ,pay_element_links_f   ,pay_input_values_f   for much understanding about the element entries.

No comments:

Post a Comment