Oracle HRMS Org Manager & job evaluations APIs

--Create Org Manager
--
BEGIN
hr_organization_api.create_org_manager
( p_validate => TRUE
,p_effective_date => org_mgrs_rec.from_date
,p_organization_id => org_mgrs_rec.org_id
,p_org_info_type_code => 'Organization Name Alias'
,p_org_information1 => org_mgrs_rec.org_designation
,p_org_information2 => org_mgrs_rec.person_id
,p_org_information3 => TO_CHAR(org_mgrs_rec.from_date,'YYYY/MM/DD HH24:MI:SS')
,p_org_information4 => TO_CHAR(org_mgrs_rec.to_date,'YYYY/MM/DD HH24:MI:SS')
,p_org_information_id => l_org_information_id
,p_object_version_number => l_object_version_number
,p_warning => l_warning );
END;
--job_evaluations
--
BEGIN
into per_job_evaluations ( JOB_EVALUATION_ID ,
BUSINESS_GROUP_ID ,
DATE_EVALUATED ,
JOB_ID ,
MEASURED_IN ,
OVERALL_SCORE ,
POSITION_ID ,
SYSTEM ,
ATTRIBUTE_CATEGORY ,
ATTRIBUTE1 ,
ATTRIBUTE2 ,
ATTRIBUTE3 ,
ATTRIBUTE4 ,
ATTRIBUTE5 ,
ATTRIBUTE6 ,
ATTRIBUTE7 ,
ATTRIBUTE8 ,
LAST_UPDATE_DATE ,
LAST_UPDATED_BY ,
LAST_UPDATE_LOGIN ,
CREATED_BY ,
CREATION_DATE ,
COMMENTS )
values
(l_seq_num,
p_business_group_id,
l_date_from,
l_job_id,
'',
to_number(nvl(TRIM(r_job_evaluation.KNOW_HOW_SCORE),0))+
to_number(nvl(TRIM(r_job_evaluation.PROB_SOL_SCORE),0))+
to_number(nvl(TRIM(r_job_evaluation.ACCOUNT_SCORE),0)),
'',
'HAY',
'',
r_job_evaluation.KNOW_HOW_SLOT,
r_job_evaluation.KNOW_HOW_SCORE ,
r_job_evaluation.PROB_SOL_SLOT ,
r_job_evaluation.PROB_SOL_PERC ,
r_job_evaluation.PROB_SOL_SCORE ,
r_job_evaluation.ACCOUNT_SLOT ,
r_job_evaluation.ACCOUNT_SCORE ,
r_job_evaluation.PROFILE ,
sysdate,
p_user_id,
p_last_update_login,
p_user_id,
sysdate,
'');
END;