Description:
The Hierarchy Diagrammer, included with Oracle HRMS, enables you to create your position hierarchies graphically, and make intuitive drag-and-drop changes to them.
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 to 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
Summary:
This Post described the script for Create Position Hierarchy by Using APIs in oracle EBS.
Queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
