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
Recommended Posts
