Tuesday 18 September 2012

Oracle HRMS Job Requirement & Hierarchy Element &positions


--Create_Hierarchy_Element
--
BEGIN
hr_hierarchy_element_api.create_hierarchy_element
( p_validate => TRUE
,p_effective_date => TRUNC(SYSDATE)
,p_organization_id_parent => org_hier_rec.parent_org_id
,p_org_structure_version_id => l_org_structure_version_id
,p_organization_id_child => org_hier_rec.child_org_id
,p_business_group_id => p_business_group_id
,p_pos_control_enabled_flag => 'N'
,p_inactive_org_warning => l_inactive_org_warning
,p_org_structure_element_id => l_org_structure_element_id
,p_object_version_number => l_object_version_number
);
END;
--Create_Job_Requirement
--
BEGIN
hr_job_requirement_api.create_job_requirement
( p_validate => TRUE
,p_id_flex_num => l_id_flex_num
,p_job_id => job_req_rec.job_id
,p_segment1 => job_req_rec.qualification_level
,p_segment2 => job_req_rec.discipline
,p_segment3 => job_req_rec.exp_yrs
,p_job_requirement_id => l_job_requirement_id
,p_object_version_number => l_object_version_number
,p_analysis_criteria_id => l_analysis_criteria_id
);
END;
-- positions
--
BEGIN
hr_position_api.create_position
( p_position_id => l_position_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_position_definition_id => l_position_definition_id
,p_name => l_name
,p_object_version_number => l_object_version_number
,p_job_id => position_rec.job_id
,p_organization_id => position_rec.org_id
,p_effective_date => position_rec.from_date
,p_date_effective => position_rec.from_date
,p_validate => TRUE
,p_availability_status_id => 1
,p_business_group_id => p_business_group_id
,p_location_id => position_rec.location_id
,p_max_persons => position_rec.head_count
,p_permanent_temporary_flag => position_rec.on_chart
,p_seasonal_flag => position_rec.off_chart
,p_position_type => 'NONE'
,p_segment1 => position_rec.job_name
,p_segment2 => position_rec.org_name
,p_attribute1 => position_rec.position_name_ar
) ;
END;

No comments:

Post a Comment