ERPstuff - Oracle EBS Community

Version R12/11i? = 11i
Instance PROD/TEST/VIS? = PROD
Module? = HRMS
OS? = LINUX


Dear All,

this is the knowledge sharing that how to update the special information of the employee in HRMS module using API.


DECLARE
v_pea_object_ver_number number := 6;
v_analysis_crit_id number:= 367353;
v_person_analysis_id number := 49328;
n_segment1 varchar2(50) := 34334813;
n_segment2 varchar2(50) := 1622011;
n_segment3 date := sysdate;
n_segment4 date := sysdate;
n_segment5 varchar2(50) := 'XYZ';
BEGIN
hr_sit_api.update_sit(
p_validate =>FALSE ,
p_person_analysis_id => v_person_analysis_id,
p_pea_object_version_number => v_pea_object_ver_number
,p_segment1 => n_segment1
,p_segment2 => n_segment2
,p_segment3 => n_segment3
,p_segment4 => n_segment4
,p_segment5 => n_segment5,
p_segment6 => '1000809989898'
,p_segment7 => '989898'
,p_analysis_criteria_id => v_analysis_crit_id);
dbms_output.put_line('Migrated PersonCode and CompanyCode');

COMMIT;

END;


If you have any query or want to know that how to INSERT / DELETE the SIT information using API, feel free to contact me..


Regards,
Muzamil Khan
Dubai.