API to Rehire Employee

DECLARE

ln_per_object_version_number     PER_ALL_PEOPLE_F.OBJECT_VERSION_NUMBER%TYPE        := 5;

ln_assg_object_version_number   PER_ALL_ASSIGNMENTS_F.OBJECT_VERSION_NUMBER%TYPE;

ln_assignment_id                          PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_ID%TYPE;

ld_per_effective_start_date           PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE%TYPE;

ld_per_effective_end_date            PER_ALL_PEOPLE_F.EFFECTIVE_END_DATE%TYPE;

ln_assignment_sequence            PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_SEQUENCE%TYPE;

lb_assign_payroll_warning          BOOLEAN;

lc_assignment_number              PER_ALL_ASSIGNMENTS_F.ASSIGNMENT_NUMBER%TYPE;

BEGIN

hr_employee_api.re_hire_ex_employee

(    — Input data elements

p_hire_date            => TO_DATE(’28-JUN-2011′),

p_person_id           => 32979,

p_rehire_reason     => NULL,

        — Output data elements

p_assignment_id   => ln_assignment_id,

p_per_object_version_number    => ln_per_object_version_number,

p_asg_object_version_number    => ln_assg_object_version_number,

p_per_effective_start_date         => ld_per_effective_start_date,

p_per_effective_end_date         => ld_per_effective_end_date,

p_assignment_sequence          => ln_assignment_sequence,

p_assignment_number            => lc_assignment_number,

p_assign_payroll_warning       => lb_assign_payroll_warning

);

COMMIT;

EXCEPTION

WHEN OTHERS THEN

ROLLBACK;

dbms_output.put_line(SQLERRM);

END;

/

SHOW ERR;

Before Execution of API

After Execution of API

Leave a Reply

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