API to Create and Update Employee Salary

DECLARE

lb_inv_next_sal_date_warning    BOOLEAN;

lb_proposed_salary_warning     BOOLEAN;

lb_approved_warning                BOOLEAN;

lb_payroll_warning                    BOOLEAN;

ln_pay_proposal_id                    NUMBER;

ln_object_version_number         NUMBER;

BEGIN

hr_maintain_proposal_api.cre_or_upd_salary_proposal

(    — Input data elements

p_business_group_id        => fnd_profile.value(‘PER_BUSINESS_GROUP_ID’),

p_assignment_id              => 33561,

p_change_date                 => TO_DATE(’13-JUN-2011′),

p_proposed_salary_n      => 1000,

p_approved                       => ‘Y’,

        — Output data elements

p_pay_proposal_id                    => ln_pay_proposal_id,

p_object_version_number         => ln_object_version_number,

p_inv_next_sal_date_warning    => lb_inv_next_sal_date_warning,

p_proposed_salary_warning     => lb_proposed_salary_warning,

p_approved_warning                => lb_approved_warning,

p_payroll_warning                    => lb_payroll_warning

);

COMMIT;

EXCEPTION

WHEN OTHERS THEN

ROLLBACK;

dbms_output.put_line(SQLERRM);

END;

/

SHOW ERR;

Leave a Reply

Your email address will not be published. Required fields are marked *