HRMS API

Using API For inbound:

****************Points To Note*********************
Hr_assignment_api

In Parameters: p_assignment_id,p_effective_date
Required Parameters:
P_Validate: Boolean-> If remains true then data base value will not be changed,If false then assignment is updated.Default value is false.
P_Effective_Date->in Param
P_DateTrack_Update_mode->Correction or Update,In Param
P_Object_Version_Number->In,Out,Copy Param.Remains 1 for new assignment,gets increamented by one to each update.
P_Assignment_Status_type_id->in
P_Change_Reason->Explicitly set to null if no change needed.

************************************************
To change the status of a employee.the status should be active before modifying.


Change the status to suspend and run this script.

Now again status will be changed to active.

Pkg used is hr_assignment_api.activate_emp_asg

Base tables : per_assignments_f

declare

l_object_version_number number:=7;

l_effective_start_date date;

l_effective_end_date date;

begin

hr_assignment_api.activate_emp_asg

(p_validate =>false

,p_effective_date =>'1-JAN-2009'

,p_datetrack_update_mode =>'CORRECTION'

,p_assignment_id =>12854

,p_change_reason =>hr_api.g_varchar2

,p_object_version_number =>l_object_version_number

,p_assignment_status_type_id =>hr_api.g_number

,p_effective_start_date =>l_effective_start_date

,p_effective_end_date =>l_effective_end_date

);

dbms_output.put_line('Object Version Number ' l_object_version_number);

commit;

end;

/

To activate for contract employees

Create a contract employee first.

declare

l_object_version_number number:=5;

l_effective_start_date date;

l_effective_end_date date;

begin

hr_assignment_api.activate_cwk_asg

(p_validate =>false

,p_effective_date =>'1-JAN-2009'

,p_datetrack_update_mode =>'CORRECTION'

,p_assignment_id =>12894

,p_change_reason =>hr_api.g_varchar2

,p_object_version_number =>l_object_version_number

,p_assignment_status_type_id =>hr_api.g_number

,p_effective_start_date =>l_effective_start_date

,p_effective_end_date =>l_effective_end_date

);

dbms_output.put_line('Object Version Number ' l_object_version_number);

commit;

end;

/