1)Creating SIT in oracle apps Using API
declare
v_count INTEGER := 0;
n_object_version_number INTEGER;
n_analysis_criteria_id INTEGER;
n_person_analysis_id INTEGER;
n_pea_object_version_number INTEGER;
begin
SELECT fi.id_flex_num
INTO n_id_flex_num
FROM fnd_id_flex_structures_vl fi
WHERE (fi.id_flex_structure_code = 'Shift Employee Offdays')
AND (application_id = 800)
AND (id_flex_code = 'PEA');
use cursor loop to load data
hr_sit_api.create_sit(
p_person_id => xx_person_id
,p_business_group_id => fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')
,p_id_flex_num => n_id_flex_num
,p_effective_date => SYSDATE
,p_date_from => v_rec.start_date
,p_date_to => v_rec.end_date
,p_segment1 => var3
,p_segment2 => var4
,p_segment3 => var5
,p_segment4 => var6
,p_segment5 => var7
,p_segment6 => var8
,p_segment7 => var9
,p_segment8 => var10
,p_segment9 => var11
,p_segment10 => var12
,p_segment11 => var13
,p_segment12 => var14
,p_analysis_criteria_id => n_analysis_criteria_id
,p_person_analysis_id => n_person_analysis_id
,p_pea_object_version_number => n_pea_object_version_number
);
end cursor loop
COMMIT;
end;
navigation to check whether SIT created or Not
goes to responsibility HRMS SUPER USER=>ENTER AND MAINTAIN =>SPECIAL INFORMATION TYPE=>SELECT ANY SIT AND CLICK ON DETAILS TO SEE WHETHER THE DATA HAS BEEN LOADED OR NOT
2)Delete SIT
declare
begin
hr_sit_api.delete_sit(false,5070,1);
end;
*)first parameter is always false
*)find the proper person_analysis_id by using following query
SELECT person_analysis_id FROM PER_PERSON_ANALYSES
*)object version is always 1
3)Upadating SIT
hr_sit_api.update_sit
(i have not tried the update sit API if i will use this one then will put the details on the same ...)