Dear All,
Please suggest me that my HRMS API is not working in Instance.
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
Code of API:
declare
cursor c1 is
select nvl (ppa.object_version_number, 1) object_version_number,
ppa.analysis_criteria_id, max (ppa.person_analysis_id) person_analysis_id,
pac.segment7,ppa.person_id
from per_person_analyses ppa
,per_analysis_criteria pac
,fnd_id_flex_structures_vl flex
where ppa.analysis_criteria_id=pac.analysis_criteria_id
and pac.id_flex_num=flex.id_flex_num
and segment4 is null
and flex.id_flex_structure_name = 'Accommodation Allocation'
and pac.segment18 in ('NMC Royal Hospital (Workers village)')
and ppa.person_id = 27495
group by nvl (ppa.object_version_number, 1),
ppa.analysis_criteria_id,ppa.analysis_criteria_id,pac.segment7,ppa.person_id;
begin
for r1 in c1 loop
hr_sit_api.update_sit
(p_validate => false,
p_person_analysis_id => r1.person_analysis_id,
p_pea_object_version_number => r1.object_version_number,
p_segment7 => null,
p_segment10 => 'Test',
p_analysis_criteria_id => r1.analysis_criteria_id
);
dbms_output.put_line ('Successfully Updated the records '||r1.person_id) ;
commit;
end loop;
commit;
end;
Thanks,
SIvaprasad