Forum Stats

  • 3,851,682 Users
  • 2,264,012 Discussions
  • 7,904,817 Comments

Discussions

hr_sit_api.update_sit is not working

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

Tagged: