Friday, March 23, 2018
API to create Employee Positions in Oracle Apps R12 – HR_POSITION_API.CREATE_POSITION
In this post, we have given a sample script to create a position.
API: HR_POSITION_API.CREATE_POSITION
Tested Instance:
R12.2.4
Version 1: This
can be used for instances where HRMS is fully licensed and employee positions
can be date tracked
DECLARE
lv_position_name VARCHAR2(500);
ld_effective_start_date DATE;
ld_effective_end_date DATE;
ln_position_definition_id NUMBER;
ln_object_version_number NUMBER;
ln_position_id NUMBER;
BEGIN
lv_position_name := NULL;
ld_effective_start_date := NULL;
ld_effective_end_date := NULL;
ln_position_definition_id := NULL;
ln_object_version_number := NULL;
ln_position_id := NULL;
hr_position_api.create_position
( p_validate => FALSE, -- If it was set as true, only validation will happen.
p_job_id => 78, -- Job id
p_organization_id => 81, -- Business Group id
p_date_effective => '01-JAN-2001',
p_segment1 => 'TEST',
p_segment2 => 'POSITION1',
p_status => 'VALID',
p_fte => NULL,
p_max_persons => NULL,
p_position_id => ln_position_id,
p_object_version_number => ln_object_version_number,
p_position_definition_id => ln_position_definition_id,
p_name => lv_position_name,
p_effective_start_date => ld_effective_start_date,
p_effective_end_date => ld_effective_end_date
);
END;
Version 2: This
can be used for instances where HRMS is available on shared basis. In this
case, the employee positions can’t be date tracked.
SET SERVEROUTPUT ON;
DECLARE
lv_position_name VARCHAR2(500);
ld_effective_start_date DATE;
ld_effective_end_date DATE;
ln_position_definition_id NUMBER;
ln_object_version_number NUMBER;
ln_position_id NUMBER;
BEGIN
lv_position_name := 'TEST.POSITION1';
ld_effective_start_date := NULL;
ld_effective_end_date := NULL;
ln_position_definition_id := NULL;
ln_object_version_number := NULL;
ln_position_id := NULL;
hr_position_api.create_position
( p_validate => FALSE,
p_job_id => 78, -- Job id
p_organization_id => 81, -- Business Group id
p_date_effective => '01-JAN-1990',
p_segment1 => 'TEST',
p_segment2 => 'POSITION3',
p_status => 'VALID',
p_position_id => ln_position_id,
p_object_version_number => ln_object_version_number,
p_position_definition_id => ln_position_definition_id,
p_name => lv_position_name
);
DBMS_OUTPUT.PUT_LINE(ln_position_id);
END;
Hope this helps!!
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “API to create Employee Positions in Oracle Apps R12 – HR_POSITION_API.CREATE_POSITION”
Post a Comment