API to rehire employee in oracle hrms

API to rehire employee in oracle hrms

In this post , We will be discuss about API to rehire employee in oracle HRMS. If we want to rehire the employees from backend in oracle hrms , then oracle has given the API to rehire the employee in oracle hrms. We do use this API , when we want to do the rehire of mass employees or we are trying to develop the employee integration to rehire the employees automatically from the integration. Oracle has provided the API to rehire employee in oracle hrms. I would like to share the detail script , using this API to rehire employee in oracle hrms. 

API to rehire employee in oracle hrms

Names of the API to rehire Employee in Oracle HRMS

hr_employee_api.re_hire_ex_employee

Detail Script using API to rehire employees in Oracle HRMS

To get the Object Version Use the Table per_all_people_f and get the Latest Record OBJECT_VERSION_NUMBER.

DECLARE

ln_per_object_version_number  PER_ALL_PEOPLE_F.OBJECT_VERSION_NUMBER%TYPE        := 2;

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

     ( 

         p_hire_date                                          => TO_DATE('28-MAR-2019'),

         p_person_id                                         => 45677,

         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;

/

As above is the complete script using API to rehire the employee in Oracle HRMS.

API to rehire employee in oracle hrms

API to rehire employee in oracle hrms