-- Following is a sample code
to create/populate HR Jobs in Oracle HRMS module
-- API Name:
HR_JOB_API.CREATE_JOB
-- Parameters:
-- p_bg_id - Business_Group_Id
-- p_job_code - Job Code populated into
Segment1 of Job Key Flexfield
-- p_job_code - Job Title populated into
Segment2 of Job Key Flexfield
DECLARE
op_job_id NUMBER;
op_object_version_number NUMBER;
x_job_definition_id NUMBER;
op_name VARCHAR2 (1000);
lv_job_group_id per_job_groups.job_group_id%TYPE;
lv_business_group_id NUMBER := &p_bg_id;
lv_job_code VARCHAR2 (60) := '&p_job_code';
lv_job_title VARCHAR2 (60) := '&p_job_title';
BEGIN
---------------------------------------------------
-->> JOB GROUP ID
<<--
---------------------------------------------------
SELECT job_group_id
INTO lv_job_group_id
FROM per_job_groups
WHERE 1=1
AND displayed_name LIKE 'Setup Business Group'
AND internal_name = 'HR_81';
hr_job_api.create_job (
p_business_group_id => lv_business_group_id,
p_date_from => '01-JAN-1950',
p_job_group_id => lv_job_group_id,
p_segment1 => lv_job_code, --JOB_CODE
p_segment2 => lv_job_title, --JOB_TITLE
p_job_id => op_job_id,
p_object_version_number => op_object_version_number,
p_job_definition_id => x_job_definition_id,
p_job_information_category => 'US',
p_name => op_name);
DBMS_OUTPUT.PUT_LINE
('OUTPUT JOB NAME CREATED : ' || op_name);
DBMS_OUTPUT.PUT_LINE
('OUTPUT JOB ID CREATED : ' || op_job_id);
EXCEPTION
WHEN OTHERS
THEN
DBMS_OUTPUT.PUT_LINE
('Error Message Is: ' || SQLERRM);
END;
No comments:
Post a Comment