Tuesday 7 May 2013

Update Salary Basis for HR employee

Salary Basis is required for employee before running the payroll,once the payroll basis is assigned to an employee the data will be stored in the table per_pay_proposals.

The link between per_pay_proposals and per_all_assignments_f is based on the assignment_id.

Below is the API(with sample parameters) for updating or creating the salary basis for an employee.

  hr_maintain_proposal_api.insert_salary_proposal (
    p_pay_proposal_id              => l_proposal_id,
    p_assignment_id                => i.assignment_id,
    p_business_group_id           => i.business_group_id,
    p_object_version_number    => l_object_version_number,
    p_multiple_components             => 'N',
    p_change_date                  =>  to_date('01-JAN-2013','DD/MM/YYYY'),--l_effective_date , --to_date('01-JAN-2013','DD/MM/YYYY'), --
    p_proposal_reason  => i.reason,
    p_proposed_salary_n        => i.salary,
    p_approved                            => i.approved,
    p_element_entry_id                 => l_element_entry_id,
    p_validate                    => l_validate,
    p_inv_next_sal_date_warning =>   l_inv_next_sal_date_warning,
    p_proposed_salary_warning => l_proposed_salary_warning,
    p_approved_warning => l_approved_warning,
    p_payroll_warning        => l_payroll_warning);

No comments:

Post a Comment