HRMS API :Create Position Hierarchy by Using API…



HRMS API :Create Position Hierarchy by Using APIs (hr_pos_hierarchy_ele_api.create_pos_hierarchy_ele) 

 


Hierarchy Name Checking query
===========================
select * from per_position_structures where name=’Sample Hierarchy’
Parent Position Name Checking Query
===================================
select * from hr_all_positions_f where position_id=3950 –1001.Operations Vice President
Subordinate Position Name Checking Query
==========================================
select * from hr_all_positions_f where position_id=60
Create Position Hierarchy by Using API

SELECT position_structure_id
           –INTO v_position_structure_id
           FROM per_position_structures
          WHERE NAME = ‘Sample Hierarchy’
            AND business_group_id =202— i.business_group_id;
    
      
         SELECT pos_structure_version_id
         —  INTO l_pos_structure_version_id
           FROM per_pos_structure_versions
          WHERE position_structure_id = 24127
            AND business_group_id = 202;


declare
   v_position_structure_id      NUMBER;
   l_pos_structure_version_id   NUMBER;
   v_pos_structure_element_id   NUMBER;
   v_object_version_number      NUMBER;
   BEGIN
         BEGIN
            hr_pos_hierarchy_ele_api.create_pos_hierarchy_ele
                   (p_parent_position_id            =>5,— parent_pos_id,
                    p_pos_structure_version_id      => 27230,–Hierarchy id
                    p_subordinate_position_id       => 24,–sub ordinate pos_id,
                    p_business_group_id             => 202,–business_group_id,
                    p_hr_installed                  => NULL,
                    p_effective_date                => ’20-jul-2018′,–l_effective_date,
                    p_pos_structure_element_id      => v_pos_structure_element_id,
                    p_object_version_number         => v_object_version_number
                   );
            DBMS_OUTPUT.put_line (   ‘v_pos_structure_element_id = ‘
                                  || v_pos_structure_element_id
                                 );
            DBMS_OUTPUT.put_line (   ‘v_object_version_number = ‘
                                  || v_object_version_number
                                 );
         END;
   COMMIT;
END;
output of API STRUCTURE ELEMENT ID checking query
in this query we need get all the details like (Hierarchy id,Parent Position id ,Subordinate Position id)
select * from per_pos_structure_elements where POS_STRUCTURE_ELEMENT_ID=45005–45002
  • September 20, 2018 | 26 views
  • Comments