Tuesday 18 September 2012

Oracle HRMS Grade&JOB APIs

-- Create JOB
--
BEGIN
hr_job_api.create_job
( p_validate => TRUE
,p_business_group_id => p_business_group_id
,p_date_from => job_rec.from_date
,p_job_group_id => l_job_group_id
,p_attribute1 => job_rec.job_craft
,p_attribute2 => job_rec.job_category
,p_attribute3 => job_rec.job_class
,p_attribute4 => job_rec.job_rank
,p_attribute5 => job_rec.job_name_ar
,p_segment1 => job_rec.job_name
,p_job_id => l_job_id
,p_object_version_number => l_object_version_number
,p_job_definition_id => l_job_definition_id
,p_name => l_name
);
END;
-- Update JOB
-- .
BEGIN
hr_job_api.update_job
( p_validate => FALSE
,p_job_id => job_upd_rec.job_id
,p_object_version_number => l_object_version_number
,p_job_definition_id => l_job_definition_id
,p_attribute5 => job_upd_rec.job_name_ar
,p_name => l_name
,p_valid_grades_changed_warning => l_valid_grades_changed_warning
,p_effective_date => l_effective_date
);
END;
--Create valid Grade
--
BEGIN
hr_valid_grade_api.create_valid_grade
( p_validate => FALSE
,p_grade_id => val_grade_rec.grade_id
,p_date_from => '01-JAN-1971'
,p_effective_date => '01-JAN-1971'
,p_job_id => val_grade_rec.job_id
,p_valid_grade_id => l_valid_grade_id
,p_object_version_number => l_object_version_number
);
END;

8 comments:

  1. hi Anil,pls tell me in detail how to create api for grade .
    iam new in this field and not able understand in the above code how can i give grade name..pls help needed urgently

    ReplyDelete
    Replies
    1. Use hr_grade_api.create_grade to create grades, You can pass the grade name in p_name. Before that please enable the Key flexfields for Grade.

      Delete
  2. Tried lot but none...can u do an favour of writing the whole code in detail of create grade...where to write flexfield id,gr_def_id

    ReplyDelete
  3. Hi anil, not able to do flexgrid error but i cant find the parameter in the func to include flexgrid in create_grade api....

    ReplyDelete
  4. i am not clear, You can write a email with detail @ anilmca02@gmail.com

    ReplyDelete
  5. Dear Anil
    how can i update or remove valid grade using API.
    Thanks for your efforts

    ReplyDelete
  6. CAN ANY ONE TELL ,HOW CAN I UPDATE VALID GRADES AGAINST JOB

    ReplyDelete