[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT p.per_system_status
FROM per_assignment_status_types p
WHERE p.assignment_status_type_id = p_assignment_status_type_id;
Select information22
from pqh_copy_entity_attribs
Where information22 IS NOT NULL
And row_type_cd = 'CRITERIA'
And copy_entity_txn_id = pqh_gen_form.g_txn_id;
Select ppt.system_person_type
From per_person_types ppt
Where ppt.person_type_id = p_person_type_id;
Select information22
from pqh_copy_entity_attribs
Where information22 IS NOT NULL
And row_type_cd = 'CRITERIA'
And copy_entity_txn_id = pqh_gen_form.g_txn_id;
Select ppt.system_person_type
From per_person_types ppt
Where ppt.person_type_id = p_person_type_id;
Select NVL(check_information1,'N'),
NVL(check_information2,'N'),
NVL(check_information3,'N')
from pqh_copy_entity_attribs
Where (check_information1 IS NOT NULL OR
check_information2 IS NOT NULL OR
check_information3 IS NOT NULL)
and row_type_cd = 'CRITERIA'
And copy_entity_txn_id = pqh_gen_form.g_txn_id;
Select ppt.system_person_type
From per_person_types ppt
Where ppt.person_type_id = p_person_type_id;
Select information22
from pqh_copy_entity_attribs
Where information22 IS NOT NULL
And row_type_cd = 'CRITERIA'
And copy_entity_txn_id = pqh_gen_form.g_txn_id;
Select 'x'
From per_person_types ppt
Where ppt.system_person_type = p_system_person_type
and ppt.person_type_id = p_person_type_id;
Select ppt.system_person_type
From per_person_types ppt
Where ppt.person_type_id = p_person_type_id;
Select posvv.org_structure_version_id version_id
From per_organization_structures_v posv,
per_org_structure_versions_v posvv,
fnd_sessions fs
Where posvv.organization_structure_id = posv.organization_structure_id
and fs.effective_date Between posvv.date_from
and NVL(posvv.date_to,hr_general.end_of_time)
And posv.organization_structure_id = p_organization_structure_id
And fs.session_id = userenv('sessionid');
select posev.organization_id_parent org_id
from per_org_structure_elements posev
where posev.org_Structure_version_id = p_version_id
UNION
select posev.organization_id_child org_id
from per_org_structure_elements posev
where posev.org_Structure_version_id = p_version_id;
Select to_number(information2),
to_number(information3)
from pqh_copy_entity_attribs
Where information2 IS NOT NULL
And row_type_cd = 'CRITERIA'
And copy_entity_txn_id = pqh_gen_form.g_txn_id;
select organization_id_parent
from per_org_structure_elements ose,
per_org_structure_versions osv
where osv.organization_structure_id = p_org_hierarchy_id
and hr_general.effective_date between osv.date_from
and nvl(osv.date_to,hr_general.end_of_time)
and osv.org_structure_version_id = ose.org_structure_version_id
and not exists
(select 'X'
from per_org_structure_elements ose2
where ose.organization_id_parent = ose2.organization_id_child
and osv.org_structure_version_id=ose2.org_structure_version_id);
** has been entered for this mass update.
*/
Open c_is_field_populated;
select 'X'
into l_dummy
from dual
where g_org_hierarchy_root in (
SELECT o.organization_id_parent
FROM per_org_structure_elements o
CONNECT BY o.organization_id_child = PRIOR o.organization_id_parent
AND o.org_structure_version_id = PRIOR o.org_structure_version_id
START WITH o.organization_id_child = p_search_org_id
AND o.org_structure_version_id =
(SELECT v.org_structure_version_id
FROM per_org_structure_versions v
WHERE v.organization_structure_id = g_org_hierarchy_id
AND hr_general.effective_date BETWEEN v.date_from
AND NVL(v.date_to, hr_general.end_of_time)));
select 'X'
into l_dummy
from dual
where g_org_starting_node in (
SELECT o.organization_id_parent
FROM per_org_structure_elements o
CONNECT BY o.organization_id_child = PRIOR o.organization_id_parent
AND o.org_structure_version_id = PRIOR o.org_structure_version_id
START WITH o.organization_id_child = p_search_org_id
AND o.org_structure_version_id =
(SELECT v.org_structure_version_id
FROM per_org_structure_versions v
WHERE v.organization_structure_id = g_org_hierarchy_id
AND hr_general.effective_date BETWEEN v.date_from
AND NVL(v.date_to, hr_general.end_of_time)));
Select ppsvv.pos_structure_version_id version_id
From per_position_structures_v ppsv,
per_pos_structure_versions_v ppsvv
Where ppsvv.position_structure_id = ppsv.position_structure_id
And ppsv.position_structure_id = p_position_structure_id
and p_effective_date between to_date(date_from,'DD/MM/YYYY') and
NVL(to_date(date_to,'DD/MM/YYYY'),p_effective_date);
select ppsev.parent_position_id pos_id
from per_pos_structure_elements ppsev
where ppsev.pos_structure_version_id = p_version_id
UNION
select ppsev.subordinate_position_id pos_id
from per_pos_structure_elements ppsev
where ppsev.pos_structure_version_id = p_version_id;
select parent_position_id
from per_pos_structure_elements ose,
per_pos_structure_versions osv
where osv.position_structure_id = p_pos_hierarchy_id
and hr_general.effective_date between osv.date_from
and nvl(osv.date_to,hr_general.end_of_time)
and osv.pos_structure_version_id = ose.pos_structure_version_id
and not exists
(select 'X'
from per_pos_structure_elements ose2
where ose.parent_position_id= ose2.subordinate_position_id
and osv.pos_structure_version_id=ose2.pos_structure_version_id);
Select to_number(information8),
to_number(information9)
from pqh_copy_entity_attribs
Where information8 IS NOT NULL
And row_type_cd = 'CRITERIA'
And copy_entity_txn_id = pqh_gen_form.g_txn_id;
select 'X'
into l_dummy
from dual
where g_pos_hierarchy_root in (
SELECT o.parent_position_id
FROM per_pos_structure_elements o
CONNECT BY o.subordinate_position_id = PRIOR o.parent_position_id
AND o.pos_structure_version_id = PRIOR o.pos_structure_version_id
START WITH o.subordinate_position_id = p_search_pos_id
AND o.pos_structure_version_id =
(SELECT v.pos_structure_version_id
FROM per_pos_structure_versions v
WHERE v.position_structure_id = g_pos_hierarchy_id
AND hr_general.effective_date BETWEEN v.date_from
AND NVL(v.date_to, hr_general.end_of_time)));
select 'X'
into l_dummy
from dual
where g_pos_starting_node in (
SELECT o.parent_position_id
FROM per_pos_structure_elements o
CONNECT BY o.subordinate_position_id = PRIOR o.parent_position_id
AND o.pos_structure_version_id = PRIOR o.pos_structure_version_id
START WITH o.subordinate_position_id = p_search_pos_id
AND o.pos_structure_version_id =
(SELECT v.pos_structure_version_id
FROM per_pos_structure_versions v
WHERE v.position_structure_id = g_pos_hierarchy_id
AND hr_general.effective_date BETWEEN v.date_from
AND NVL(v.date_to, hr_general.end_of_time)));
p_SPP_DELETE_WARNING OUT NOCOPY BOOLEAN ,
p_TAX_DISTRICT_CHANGED_WARNING OUT NOCOPY BOOLEAN ,
p_CAG_SEGMENT1 IN VARCHAR2 ,
p_CAG_SEGMENT10 IN VARCHAR2 ,
p_CAG_SEGMENT11 IN VARCHAR2 ,
p_CAG_SEGMENT12 IN VARCHAR2 ,
p_CAG_SEGMENT13 IN VARCHAR2 ,
p_CAG_SEGMENT14 IN VARCHAR2 ,
p_CAG_SEGMENT15 IN VARCHAR2 ,
p_CAG_SEGMENT16 IN VARCHAR2 ,
p_CAG_SEGMENT17 IN VARCHAR2 ,
p_CAG_SEGMENT18 IN VARCHAR2 ,
p_CAG_SEGMENT19 IN VARCHAR2 ,
p_CAG_SEGMENT2 IN VARCHAR2 ,
p_CAG_SEGMENT20 IN VARCHAR2 ,
p_CAG_SEGMENT3 IN VARCHAR2 ,
p_CAG_SEGMENT4 IN VARCHAR2 ,
p_CAG_SEGMENT5 IN VARCHAR2 ,
p_CAG_SEGMENT6 IN VARCHAR2 ,
p_CAG_SEGMENT7 IN VARCHAR2 ,
p_CAG_SEGMENT8 IN VARCHAR2 ,
p_CAG_SEGMENT9 IN VARCHAR2 ,
p_CAGR_CONCATENATED_SEGMENTS OUT NOCOPY VARCHAR2 ,
p_COMMENTS IN VARCHAR2 ,
p_CONCAT_SEGMENTS IN VARCHAR2 ,
p_CONCATENATED_SEGMENTS IN OUT NOCOPY VARCHAR2 ,
p_DATETRACK_UPDATE_MODE IN VARCHAR2 ,
p_EFFECTIVE_DATE IN DATE ,
p_EFFECTIVE_END_DATE OUT NOCOPY DATE ,
p_EFFECTIVE_START_DATE OUT NOCOPY DATE ,
p_NO_MANAGERS_WARNING OUT NOCOPY BOOLEAN ,
p_OTHER_MANAGER_WARNING OUT NOCOPY BOOLEAN ,
p_GSP_POST_PROCESS_WARNING OUT NOCOPY VARCHAR2 ,
p_SEGMENT1 IN VARCHAR2 ,
p_SEGMENT10 IN VARCHAR2 ,
p_SEGMENT11 IN VARCHAR2 ,
p_SEGMENT12 IN VARCHAR2 ,
p_SEGMENT13 IN VARCHAR2 ,
p_SEGMENT14 IN VARCHAR2 ,
p_SEGMENT15 IN VARCHAR2 ,
p_SEGMENT16 IN VARCHAR2 ,
p_SEGMENT17 IN VARCHAR2 ,
p_SEGMENT18 IN VARCHAR2 ,
p_SEGMENT19 IN VARCHAR2 ,
p_SEGMENT2 IN VARCHAR2 ,
p_SEGMENT20 IN VARCHAR2 ,
p_SEGMENT21 IN VARCHAR2 ,
p_SEGMENT22 IN VARCHAR2 ,
p_SEGMENT23 IN VARCHAR2 ,
p_SEGMENT24 IN VARCHAR2 ,
p_SEGMENT25 IN VARCHAR2 ,
p_SEGMENT26 IN VARCHAR2 ,
p_SEGMENT27 IN VARCHAR2 ,
p_SEGMENT28 IN VARCHAR2 ,
p_SEGMENT29 IN VARCHAR2 ,
p_SEGMENT3 IN VARCHAR2 ,
p_SEGMENT30 IN VARCHAR2 ,
p_SEGMENT4 IN VARCHAR2 ,
p_SEGMENT5 IN VARCHAR2 ,
p_SEGMENT6 IN VARCHAR2 ,
p_SEGMENT7 IN VARCHAR2 ,
p_SEGMENT8 IN VARCHAR2 ,
p_SEGMENT9 IN VARCHAR2 ,
p_SCL_SEGMENT1 IN VARCHAR2 ,
p_SCL_SEGMENT10 IN VARCHAR2 ,
p_SCL_SEGMENT11 IN VARCHAR2 ,
p_SCL_SEGMENT12 IN VARCHAR2 ,
p_SCL_SEGMENT13 IN VARCHAR2 ,
p_SCL_SEGMENT14 IN VARCHAR2 ,
p_SCL_SEGMENT15 IN VARCHAR2 ,
p_SCL_SEGMENT16 IN VARCHAR2 ,
p_SCL_SEGMENT17 IN VARCHAR2 ,
p_SCL_SEGMENT18 IN VARCHAR2 ,
p_SCL_SEGMENT19 IN VARCHAR2 ,
p_SCL_SEGMENT2 IN VARCHAR2 ,
p_SCL_SEGMENT20 IN VARCHAR2 ,
p_SCL_SEGMENT21 IN VARCHAR2 ,
p_SCL_SEGMENT22 IN VARCHAR2 ,
p_SCL_SEGMENT23 IN VARCHAR2 ,
p_SCL_SEGMENT24 IN VARCHAR2 ,
p_SCL_SEGMENT25 IN VARCHAR2 ,
p_SCL_SEGMENT26 IN VARCHAR2 ,
p_SCL_SEGMENT27 IN VARCHAR2 ,
p_SCL_SEGMENT28 IN VARCHAR2 ,
p_SCL_SEGMENT29 IN VARCHAR2 ,
p_SCL_SEGMENT3 IN VARCHAR2 ,
p_SCL_SEGMENT30 IN VARCHAR2 ,
p_SCL_SEGMENT4 IN VARCHAR2 ,
p_SCL_SEGMENT5 IN VARCHAR2 ,
p_SCL_SEGMENT6 IN VARCHAR2 ,
p_SCL_SEGMENT7 IN VARCHAR2 ,
p_SCL_SEGMENT8 IN VARCHAR2 ,
p_SCL_SEGMENT9 IN VARCHAR2 ,
p_GRADE_LADDER_PGM_ID IN NUMBER ,
p_VALIDATE IN BOOLEAN ) IS
--
cursor csr_check_estab is
select count(organization_id)
from hr_organization_information hoi_estab
where hoi_estab.organization_id = p_organization_id
and hoi_estab.org_information_context || '' = 'CLASS'
and hoi_estab.org_information1 = 'FR_ETABLISSEMENT'
and hoi_estab.org_information2= 'Y';
select organization_id
from per_all_assignments_f
where assignment_id = p_assignment_id
and p_effective_date between effective_start_date and effective_end_date;
hr_utility.set_location('Assignment already updated'||l_proc, 5);
hr_assignment_api.update_emp_asg (
P_VALIDATE => P_VALIDATE ,
P_EFFECTIVE_DATE => L_EFFECTIVE_DATE ,
P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE ,
P_ASSIGNMENT_ID => P_ASSIGNMENT_ID ,
P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER ,
P_SUPERVISOR_ID => P_SUPERVISOR_ID ,
P_SUPERVISOR_ASSIGNMENT_ID => P_SUPERVISOR_ASSIGNMENT_ID ,
P_ASSIGNMENT_NUMBER => P_ASSIGNMENT_NUMBER ,
P_CHANGE_REASON => P_CHANGE_REASON ,
P_COMMENTS => P_COMMENTS ,
P_DATE_PROBATION_END => P_DATE_PROBATION_END ,
P_DEFAULT_CODE_COMB_ID => P_DEFAULT_CODE_COMB_ID ,
P_FREQUENCY => P_FREQUENCY ,
P_INTERNAL_ADDRESS_LINE => P_INTERNAL_ADDRESS_LINE ,
P_MANAGER_FLAG => P_MANAGER_FLAG ,
P_NORMAL_HOURS => P_NORMAL_HOURS ,
P_PERF_REVIEW_PERIOD => P_PERF_REVIEW_PERIOD ,
P_PERF_REVIEW_PERIOD_FREQUENCY => P_PERF_REVIEW_PERIOD_FREQUENCY ,
P_PROBATION_PERIOD => P_PROBATION_PERIOD ,
P_PROBATION_UNIT => P_PROBATION_UNIT ,
P_SAL_REVIEW_PERIOD => P_SAL_REVIEW_PERIOD ,
P_SAL_REVIEW_PERIOD_FREQUENCY => P_SAL_REVIEW_PERIOD_FREQUENCY ,
P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID ,
P_SOURCE_TYPE => P_SOURCE_TYPE ,
P_TIME_NORMAL_FINISH => P_TIME_NORMAL_FINISH ,
P_TIME_NORMAL_START => P_TIME_NORMAL_START ,
P_BARGAINING_UNIT_CODE => P_BARGAINING_UNIT_CODE ,
P_LABOUR_UNION_MEMBER_FLAG => P_LABOUR_UNION_MEMBER_FLAG ,
P_HOURLY_SALARIED_CODE => P_HOURLY_SALARIED_CODE ,
P_ASS_ATTRIBUTE_CATEGORY => P_ASS_ATTRIBUTE_CATEGORY ,
P_ASS_ATTRIBUTE1 => P_ASS_ATTRIBUTE1 ,
P_ASS_ATTRIBUTE2 => P_ASS_ATTRIBUTE2 ,
P_ASS_ATTRIBUTE3 => P_ASS_ATTRIBUTE3 ,
P_ASS_ATTRIBUTE4 => P_ASS_ATTRIBUTE4 ,
P_ASS_ATTRIBUTE5 => P_ASS_ATTRIBUTE5 ,
P_ASS_ATTRIBUTE6 => P_ASS_ATTRIBUTE6 ,
P_ASS_ATTRIBUTE7 => P_ASS_ATTRIBUTE7 ,
P_ASS_ATTRIBUTE8 => P_ASS_ATTRIBUTE8 ,
P_ASS_ATTRIBUTE9 => P_ASS_ATTRIBUTE9 ,
P_ASS_ATTRIBUTE10 => P_ASS_ATTRIBUTE10 ,
P_ASS_ATTRIBUTE11 => P_ASS_ATTRIBUTE11 ,
P_ASS_ATTRIBUTE12 => P_ASS_ATTRIBUTE12 ,
P_ASS_ATTRIBUTE13 => P_ASS_ATTRIBUTE13 ,
P_ASS_ATTRIBUTE14 => P_ASS_ATTRIBUTE14 ,
P_ASS_ATTRIBUTE15 => P_ASS_ATTRIBUTE15 ,
P_ASS_ATTRIBUTE16 => P_ASS_ATTRIBUTE16 ,
P_ASS_ATTRIBUTE17 => P_ASS_ATTRIBUTE17 ,
P_ASS_ATTRIBUTE18 => P_ASS_ATTRIBUTE18 ,
P_ASS_ATTRIBUTE19 => P_ASS_ATTRIBUTE19 ,
P_ASS_ATTRIBUTE20 => P_ASS_ATTRIBUTE20 ,
P_ASS_ATTRIBUTE21 => P_ASS_ATTRIBUTE21 ,
P_ASS_ATTRIBUTE22 => P_ASS_ATTRIBUTE22 ,
P_ASS_ATTRIBUTE23 => P_ASS_ATTRIBUTE23 ,
P_ASS_ATTRIBUTE24 => P_ASS_ATTRIBUTE24 ,
P_ASS_ATTRIBUTE25 => P_ASS_ATTRIBUTE25 ,
P_ASS_ATTRIBUTE26 => P_ASS_ATTRIBUTE26 ,
P_ASS_ATTRIBUTE27 => P_ASS_ATTRIBUTE27 ,
P_ASS_ATTRIBUTE28 => P_ASS_ATTRIBUTE28 ,
P_ASS_ATTRIBUTE29 => P_ASS_ATTRIBUTE29 ,
P_ASS_ATTRIBUTE30 => P_ASS_ATTRIBUTE30 ,
P_TITLE => P_TITLE ,
P_SEGMENT1 => P_SCL_SEGMENT1 ,
P_SEGMENT2 => P_SCL_SEGMENT2 ,
P_SEGMENT3 => P_SCL_SEGMENT3 ,
P_SEGMENT4 => P_SCL_SEGMENT4 ,
P_SEGMENT5 => P_SCL_SEGMENT5 ,
P_SEGMENT6 => P_SCL_SEGMENT6 ,
P_SEGMENT7 => P_SCL_SEGMENT7 ,
P_SEGMENT8 => P_SCL_SEGMENT8 ,
P_SEGMENT9 => P_SCL_SEGMENT9 ,
P_SEGMENT10 => P_SCL_SEGMENT10 ,
P_SEGMENT11 => P_SCL_SEGMENT11 ,
P_SEGMENT12 => P_SCL_SEGMENT12 ,
P_SEGMENT13 => P_SCL_SEGMENT13 ,
P_SEGMENT14 => P_SCL_SEGMENT14 ,
P_SEGMENT15 => P_SCL_SEGMENT15 ,
P_SEGMENT16 => P_SCL_SEGMENT16 ,
P_SEGMENT17 => P_SCL_SEGMENT17 ,
P_SEGMENT18 => P_SCL_SEGMENT18 ,
P_SEGMENT19 => P_SCL_SEGMENT19 ,
P_SEGMENT20 => P_SCL_SEGMENT20 ,
P_SEGMENT21 => P_SCL_SEGMENT21 ,
P_SEGMENT22 => P_SCL_SEGMENT22 ,
P_SEGMENT23 => P_SCL_SEGMENT23 ,
P_SEGMENT24 => P_SCL_SEGMENT24 ,
P_SEGMENT25 => P_SCL_SEGMENT25 ,
P_SEGMENT26 => P_SCL_SEGMENT26 ,
P_SEGMENT27 => P_SCL_SEGMENT27 ,
P_SEGMENT28 => P_SCL_SEGMENT28 ,
P_SEGMENT29 => P_SCL_SEGMENT29 ,
P_SEGMENT30 => P_SCL_SEGMENT30 ,
P_CONCAT_SEGMENTS => L_CONCAT_SEGMENTS ,
--P_CONTRACT_ID => P_CONTRACT_ID ,
P_ESTABLISHMENT_ID => l_establishment_id ,
P_COLLECTIVE_AGREEMENT_ID => P_COLLECTIVE_AGREEMENT_ID ,
--P_CAGR_ID_FLEX_NUM => P_CAGR_ID_FLEX_NUM ,
P_CAG_SEGMENT1 => P_CAG_SEGMENT1 ,
P_CAG_SEGMENT2 => P_CAG_SEGMENT2 ,
P_CAG_SEGMENT3 => P_CAG_SEGMENT3 ,
P_CAG_SEGMENT4 => P_CAG_SEGMENT4 ,
P_CAG_SEGMENT5 => P_CAG_SEGMENT5 ,
P_CAG_SEGMENT6 => P_CAG_SEGMENT6 ,
P_CAG_SEGMENT7 => P_CAG_SEGMENT7 ,
P_CAG_SEGMENT8 => P_CAG_SEGMENT8 ,
P_CAG_SEGMENT9 => P_CAG_SEGMENT9 ,
P_CAG_SEGMENT10 => P_CAG_SEGMENT10 ,
P_CAG_SEGMENT11 => P_CAG_SEGMENT11 ,
P_CAG_SEGMENT12 => P_CAG_SEGMENT12 ,
P_CAG_SEGMENT13 => P_CAG_SEGMENT13 ,
P_CAG_SEGMENT14 => P_CAG_SEGMENT14 ,
P_CAG_SEGMENT15 => P_CAG_SEGMENT15 ,
P_CAG_SEGMENT16 => P_CAG_SEGMENT16 ,
P_CAG_SEGMENT17 => P_CAG_SEGMENT17 ,
P_CAG_SEGMENT18 => P_CAG_SEGMENT18 ,
P_CAG_SEGMENT19 => P_CAG_SEGMENT19 ,
P_CAG_SEGMENT20 => P_CAG_SEGMENT20 ,
P_CAGR_GRADE_DEF_ID => L_CAGR_GRADE_DEF_ID ,
P_CAGR_CONCATENATED_SEGMENTS => P_CAGR_CONCATENATED_SEGMENTS ,
P_CONCATENATED_SEGMENTS => P_CONCATENATED_SEGMENTS ,
P_SOFT_CODING_KEYFLEX_ID => P_SOFT_CODING_KEYFLEX_ID ,
P_COMMENT_ID => P_COMMENT_ID ,
P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE ,
P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE ,
P_NO_MANAGERS_WARNING => P_NO_MANAGERS_WARNING ,
P_OTHER_MANAGER_WARNING => P_OTHER_MANAGER_WARNING ,
P_HOURLY_SALARIED_WARNING => l_dummy_b ,
P_GSP_POST_PROCESS_WARNING => P_GSP_POST_PROCESS_WARNING );
hr_assignment_api.update_emp_asg_criteria (
P_VALIDATE => P_VALIDATE ,
P_EFFECTIVE_DATE => L_EFFECTIVE_DATE ,
P_DATETRACK_UPDATE_MODE => P_DATETRACK_UPDATE_MODE ,
P_CALLED_FROM_MASS_UPDATE => TRUE ,
P_ASSIGNMENT_ID => P_ASSIGNMENT_ID ,
P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER ,
P_GRADE_ID => P_GRADE_ID ,
P_POSITION_ID => P_POSITION_ID ,
P_JOB_ID => P_JOB_ID ,
P_PAYROLL_ID => P_PAYROLL_ID ,
P_LOCATION_ID => P_LOCATION_ID ,
P_SPECIAL_CEILING_STEP_ID => P_SPECIAL_CEILING_STEP_ID ,
P_ORGANIZATION_ID => l_organization_id ,
P_PAY_BASIS_ID => P_PAY_BASIS_ID ,
P_SEGMENT1 => P_SEGMENT1 ,
P_SEGMENT2 => P_SEGMENT2 ,
P_SEGMENT3 => P_SEGMENT3 ,
P_SEGMENT4 => P_SEGMENT4 ,
P_SEGMENT5 => P_SEGMENT5 ,
P_SEGMENT6 => P_SEGMENT6 ,
P_SEGMENT7 => P_SEGMENT7 ,
P_SEGMENT8 => P_SEGMENT8 ,
P_SEGMENT9 => P_SEGMENT9 ,
P_SEGMENT10 => P_SEGMENT10 ,
P_SEGMENT11 => P_SEGMENT11 ,
P_SEGMENT12 => P_SEGMENT12 ,
P_SEGMENT13 => P_SEGMENT13 ,
P_SEGMENT14 => P_SEGMENT14 ,
P_SEGMENT15 => P_SEGMENT15 ,
P_SEGMENT16 => P_SEGMENT16 ,
P_SEGMENT17 => P_SEGMENT17 ,
P_SEGMENT18 => P_SEGMENT18 ,
P_SEGMENT19 => P_SEGMENT19 ,
P_SEGMENT20 => P_SEGMENT20 ,
P_SEGMENT21 => P_SEGMENT21 ,
P_SEGMENT22 => P_SEGMENT22 ,
P_SEGMENT23 => P_SEGMENT23 ,
P_SEGMENT24 => P_SEGMENT24 ,
P_SEGMENT25 => P_SEGMENT25 ,
P_SEGMENT26 => P_SEGMENT26 ,
P_SEGMENT27 => P_SEGMENT27 ,
P_SEGMENT28 => P_SEGMENT28 ,
P_SEGMENT29 => P_SEGMENT29 ,
P_SEGMENT30 => P_SEGMENT30 ,
P_CONCAT_SEGMENTS => P_CONCAT_SEGMENTS ,
P_GROUP_NAME => P_GROUP_NAME ,
P_EMPLOYMENT_CATEGORY => P_EMPLOYMENT_CATEGORY ,
P_EFFECTIVE_START_DATE => P_EFFECTIVE_START_DATE ,
P_EFFECTIVE_END_DATE => P_EFFECTIVE_END_DATE ,
P_PEOPLE_GROUP_ID => P_PEOPLE_GROUP_ID ,
P_GRADE_LADDER_PGM_ID => P_GRADE_LADDER_PGM_ID ,
P_ORG_NOW_NO_MANAGER_WARNING => P_ORG_NOW_NO_MANAGER_WARNING ,
P_OTHER_MANAGER_WARNING => P_OTHER_MANAGER_WARNING ,
P_SPP_DELETE_WARNING => P_SPP_DELETE_WARNING ,
P_ENTRIES_CHANGED_WARNING => P_ENTRIES_CHANGED_WARNING ,
P_TAX_DISTRICT_CHANGED_WARNING => P_TAX_DISTRICT_CHANGED_WARNING ,
P_SOFT_CODING_KEYFLEX_ID => l_dummy_n ,
P_CONCATENATED_SEGMENTS => l_dummy_v ,
P_GSP_POST_PROCESS_WARNING => P_GSP_POST_PROCESS_WARNING );
If p_spp_delete_warning = TRUE Then
--
hr_utility.set_message(800,'HR_289826_SPP_DELETE_WARN_API');
,p_datetrack_update_mode => 'CORRECTION' --p_datetrack_update_mode
,p_assignment_id => p_assignment_id
,p_change_reason => p_change_reason
,p_object_version_number => p_object_version_number
,p_assignment_status_type_id => p_assignment_status_type_id
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date);
,p_datetrack_update_mode => 'CORRECTION' --p_datetrack_update_mode
,p_assignment_id => p_assignment_id
,p_change_reason => p_change_reason
,p_object_version_number => p_object_version_number
,p_assignment_status_type_id => p_assignment_status_type_id
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date);
p_SPP_DELETE_WARNING := null;
PROCEDURE update_applicant_asg
(p_validate in boolean default false
,p_effective_date in date
,p_datetrack_update_mode in varchar2
,p_assignment_id in number
,p_object_version_number in out nocopy number
,p_recruiter_id in number default hr_api.g_number
,p_grade_id in number default hr_api.g_number
,p_position_id in number default hr_api.g_number
,p_job_id in number default hr_api.g_number
,p_payroll_id in number default hr_api.g_number
,p_location_id in number default hr_api.g_number
,p_person_referred_by_id in number default hr_api.g_number
,p_assignment_status_type_id in number default hr_api.g_number
,p_supervisor_id in number default hr_api.g_number
,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
,p_special_ceiling_step_id in number default hr_api.g_number
,p_recruitment_activity_id in number default hr_api.g_number
,p_source_organization_id in number default hr_api.g_number
,p_organization_id in number default hr_api.g_number
,p_vacancy_id in number default hr_api.g_number
,p_pay_basis_id in number default hr_api.g_number
,p_application_id in number default hr_api.g_number
,p_change_reason in varchar2 default hr_api.g_varchar2
,p_comments in varchar2 default hr_api.g_varchar2
,p_date_probation_end in date default hr_api.g_date
,p_default_code_comb_id in number default hr_api.g_number
,p_employment_category in varchar2 default hr_api.g_varchar2
,p_frequency in varchar2 default hr_api.g_varchar2
,p_internal_address_line in varchar2 default hr_api.g_varchar2
,p_manager_flag in varchar2 default hr_api.g_varchar2
,p_normal_hours in number default hr_api.g_number
,p_perf_review_period in number default hr_api.g_number
,p_perf_review_period_frequency in varchar2 default hr_api.g_varchar2
,p_probation_period in number default hr_api.g_number
,p_probation_unit in varchar2 default hr_api.g_varchar2
,p_sal_review_period in number default hr_api.g_number
,p_sal_review_period_frequency in varchar2 default hr_api.g_varchar2
,p_set_of_books_id in number default hr_api.g_number
,p_source_type in varchar2 default hr_api.g_varchar2
,p_time_normal_finish in varchar2 default hr_api.g_varchar2
,p_time_normal_start in varchar2 default hr_api.g_varchar2
,p_bargaining_unit_code in varchar2 default hr_api.g_varchar2
,p_ass_attribute_category in varchar2 default hr_api.g_varchar2
,p_ass_attribute1 in varchar2 default hr_api.g_varchar2
,p_ass_attribute2 in varchar2 default hr_api.g_varchar2
,p_ass_attribute3 in varchar2 default hr_api.g_varchar2
,p_ass_attribute4 in varchar2 default hr_api.g_varchar2
,p_ass_attribute5 in varchar2 default hr_api.g_varchar2
,p_ass_attribute6 in varchar2 default hr_api.g_varchar2
,p_ass_attribute7 in varchar2 default hr_api.g_varchar2
,p_ass_attribute8 in varchar2 default hr_api.g_varchar2
,p_ass_attribute9 in varchar2 default hr_api.g_varchar2
,p_ass_attribute10 in varchar2 default hr_api.g_varchar2
,p_ass_attribute11 in varchar2 default hr_api.g_varchar2
,p_ass_attribute12 in varchar2 default hr_api.g_varchar2
,p_ass_attribute13 in varchar2 default hr_api.g_varchar2
,p_ass_attribute14 in varchar2 default hr_api.g_varchar2
,p_ass_attribute15 in varchar2 default hr_api.g_varchar2
,p_ass_attribute16 in varchar2 default hr_api.g_varchar2
,p_ass_attribute17 in varchar2 default hr_api.g_varchar2
,p_ass_attribute18 in varchar2 default hr_api.g_varchar2
,p_ass_attribute19 in varchar2 default hr_api.g_varchar2
,p_ass_attribute20 in varchar2 default hr_api.g_varchar2
,p_ass_attribute21 in varchar2 default hr_api.g_varchar2
,p_ass_attribute22 in varchar2 default hr_api.g_varchar2
,p_ass_attribute23 in varchar2 default hr_api.g_varchar2
,p_ass_attribute24 in varchar2 default hr_api.g_varchar2
,p_ass_attribute25 in varchar2 default hr_api.g_varchar2
,p_ass_attribute26 in varchar2 default hr_api.g_varchar2
,p_ass_attribute27 in varchar2 default hr_api.g_varchar2
,p_ass_attribute28 in varchar2 default hr_api.g_varchar2
,p_ass_attribute29 in varchar2 default hr_api.g_varchar2
,p_ass_attribute30 in varchar2 default hr_api.g_varchar2
,p_title in varchar2 default hr_api.g_varchar2
,p_scl_segment1 in varchar2 default hr_api.g_varchar2
,p_scl_segment2 in varchar2 default hr_api.g_varchar2
,p_scl_segment3 in varchar2 default hr_api.g_varchar2
,p_scl_segment4 in varchar2 default hr_api.g_varchar2
,p_scl_segment5 in varchar2 default hr_api.g_varchar2
,p_scl_segment6 in varchar2 default hr_api.g_varchar2
,p_scl_segment7 in varchar2 default hr_api.g_varchar2
,p_scl_segment8 in varchar2 default hr_api.g_varchar2
,p_scl_segment9 in varchar2 default hr_api.g_varchar2
,p_scl_segment10 in varchar2 default hr_api.g_varchar2
,p_scl_segment11 in varchar2 default hr_api.g_varchar2
,p_scl_segment12 in varchar2 default hr_api.g_varchar2
,p_scl_segment13 in varchar2 default hr_api.g_varchar2
,p_scl_segment14 in varchar2 default hr_api.g_varchar2
,p_scl_segment15 in varchar2 default hr_api.g_varchar2
,p_scl_segment16 in varchar2 default hr_api.g_varchar2
,p_scl_segment17 in varchar2 default hr_api.g_varchar2
,p_scl_segment18 in varchar2 default hr_api.g_varchar2
,p_scl_segment19 in varchar2 default hr_api.g_varchar2
,p_scl_segment20 in varchar2 default hr_api.g_varchar2
,p_scl_segment21 in varchar2 default hr_api.g_varchar2
,p_scl_segment22 in varchar2 default hr_api.g_varchar2
,p_scl_segment23 in varchar2 default hr_api.g_varchar2
,p_scl_segment24 in varchar2 default hr_api.g_varchar2
,p_scl_segment25 in varchar2 default hr_api.g_varchar2
,p_scl_segment26 in varchar2 default hr_api.g_varchar2
,p_scl_segment27 in varchar2 default hr_api.g_varchar2
,p_scl_segment28 in varchar2 default hr_api.g_varchar2
,p_scl_segment29 in varchar2 default hr_api.g_varchar2
,p_scl_segment30 in varchar2 default hr_api.g_varchar2
,p_concatenated_segments in out nocopy varchar2
,p_pgp_segment1 in varchar2 default hr_api.g_varchar2
,p_pgp_segment2 in varchar2 default hr_api.g_varchar2
,p_pgp_segment3 in varchar2 default hr_api.g_varchar2
,p_pgp_segment4 in varchar2 default hr_api.g_varchar2
,p_pgp_segment5 in varchar2 default hr_api.g_varchar2
,p_pgp_segment6 in varchar2 default hr_api.g_varchar2
,p_pgp_segment7 in varchar2 default hr_api.g_varchar2
,p_pgp_segment8 in varchar2 default hr_api.g_varchar2
,p_pgp_segment9 in varchar2 default hr_api.g_varchar2
,p_pgp_segment10 in varchar2 default hr_api.g_varchar2
,p_pgp_segment11 in varchar2 default hr_api.g_varchar2
,p_pgp_segment12 in varchar2 default hr_api.g_varchar2
,p_pgp_segment13 in varchar2 default hr_api.g_varchar2
,p_pgp_segment14 in varchar2 default hr_api.g_varchar2
,p_pgp_segment15 in varchar2 default hr_api.g_varchar2
,p_pgp_segment16 in varchar2 default hr_api.g_varchar2
,p_pgp_segment17 in varchar2 default hr_api.g_varchar2
,p_pgp_segment18 in varchar2 default hr_api.g_varchar2
,p_pgp_segment19 in varchar2 default hr_api.g_varchar2
,p_pgp_segment20 in varchar2 default hr_api.g_varchar2
,p_pgp_segment21 in varchar2 default hr_api.g_varchar2
,p_pgp_segment22 in varchar2 default hr_api.g_varchar2
,p_pgp_segment23 in varchar2 default hr_api.g_varchar2
,p_pgp_segment24 in varchar2 default hr_api.g_varchar2
,p_pgp_segment25 in varchar2 default hr_api.g_varchar2
,p_pgp_segment26 in varchar2 default hr_api.g_varchar2
,p_pgp_segment27 in varchar2 default hr_api.g_varchar2
,p_pgp_segment28 in varchar2 default hr_api.g_varchar2
,p_pgp_segment29 in varchar2 default hr_api.g_varchar2
,p_pgp_segment30 in varchar2 default hr_api.g_varchar2
,p_concat_segments in varchar2 default hr_api.g_varchar2
,p_contract_id in number default hr_api.g_number
,p_establishment_id in number default hr_api.g_number
,p_collective_agreement_id in number default hr_api.g_number
,p_cagr_id_flex_num in number default hr_api.g_number
,p_cag_segment1 in varchar2 default hr_api.g_varchar2
,p_cag_segment2 in varchar2 default hr_api.g_varchar2
,p_cag_segment3 in varchar2 default hr_api.g_varchar2
,p_cag_segment4 in varchar2 default hr_api.g_varchar2
,p_cag_segment5 in varchar2 default hr_api.g_varchar2
,p_cag_segment6 in varchar2 default hr_api.g_varchar2
,p_cag_segment7 in varchar2 default hr_api.g_varchar2
,p_cag_segment8 in varchar2 default hr_api.g_varchar2
,p_cag_segment9 in varchar2 default hr_api.g_varchar2
,p_cag_segment10 in varchar2 default hr_api.g_varchar2
,p_cag_segment11 in varchar2 default hr_api.g_varchar2
,p_cag_segment12 in varchar2 default hr_api.g_varchar2
,p_cag_segment13 in varchar2 default hr_api.g_varchar2
,p_cag_segment14 in varchar2 default hr_api.g_varchar2
,p_cag_segment15 in varchar2 default hr_api.g_varchar2
,p_cag_segment16 in varchar2 default hr_api.g_varchar2
,p_cag_segment17 in varchar2 default hr_api.g_varchar2
,p_cag_segment18 in varchar2 default hr_api.g_varchar2
,p_cag_segment19 in varchar2 default hr_api.g_varchar2
,p_cag_segment20 in varchar2 default hr_api.g_varchar2
,p_grade_ladder_pgm_id in number default hr_api.g_number
,p_cagr_grade_def_id in out nocopy number
,p_cagr_concatenated_segments out nocopy varchar2
,p_group_name out nocopy varchar2
,p_comment_id out nocopy number
,p_people_group_id out nocopy number
,p_soft_coding_keyflex_id out nocopy number
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date ) is
--
-- Procedure Return Variables
--
l_group_name varchar2(240) := NULL;
l_proc varchar2(72) := g_package||'Update_Applicant_Asg';
hr_assignment_api.update_apl_asg
(p_validate => p_validate
,p_effective_date => l_effective_date
,p_datetrack_update_mode => p_datetrack_update_mode
,p_assignment_id => p_assignment_id
,p_object_version_number => p_object_version_number
,p_recruiter_id => p_recruiter_id
,p_grade_id => p_grade_id
,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
,p_position_id => p_position_id
,p_job_id => p_job_id
,p_payroll_id => p_payroll_id
,p_location_id => p_location_id
,p_person_referred_by_id => p_person_referred_by_id
,p_supervisor_id => p_supervisor_id
,p_supervisor_assignment_id => p_supervisor_assignment_id
,p_special_ceiling_step_id => p_special_ceiling_step_id
,p_recruitment_activity_id => p_recruitment_activity_id
,p_source_organization_id => p_source_organization_id
,p_organization_id => p_organization_id
,p_vacancy_id => p_vacancy_id
,p_pay_basis_id => p_pay_basis_id
,p_application_id => p_application_id
,p_change_reason => p_change_reason
,p_comments => p_comments
,p_date_probation_end => p_date_probation_end
,p_default_code_comb_id => p_default_code_comb_id
,p_employment_category => p_employment_category
,p_frequency => p_frequency
,p_internal_address_line => p_internal_address_line
,p_manager_flag => p_manager_flag
,p_normal_hours => p_normal_hours
,p_perf_review_period => p_perf_review_period
,p_perf_review_period_frequency => p_perf_review_period_frequency
,p_probation_period => p_probation_period
,p_probation_unit => p_probation_unit
,p_sal_review_period => p_sal_review_period
,p_sal_review_period_frequency => p_sal_review_period_frequency
,p_set_of_books_id => p_set_of_books_id
,p_source_type => p_source_type
,p_time_normal_finish => p_time_normal_finish
,p_time_normal_start => p_time_normal_start
,p_bargaining_unit_code => p_bargaining_unit_code
,p_ass_attribute_category => p_ass_attribute_category
,p_ass_attribute1 => p_ass_attribute1
,p_ass_attribute2 => p_ass_attribute2
,p_ass_attribute3 => p_ass_attribute3
,p_ass_attribute4 => p_ass_attribute4
,p_ass_attribute5 => p_ass_attribute5
,p_ass_attribute6 => p_ass_attribute6
,p_ass_attribute7 => p_ass_attribute7
,p_ass_attribute8 => p_ass_attribute8
,p_ass_attribute9 => p_ass_attribute9
,p_ass_attribute10 => p_ass_attribute10
,p_ass_attribute11 => p_ass_attribute11
,p_ass_attribute12 => p_ass_attribute12
,p_ass_attribute13 => p_ass_attribute13
,p_ass_attribute14 => p_ass_attribute14
,p_ass_attribute15 => p_ass_attribute15
,p_ass_attribute16 => p_ass_attribute16
,p_ass_attribute17 => p_ass_attribute17
,p_ass_attribute18 => p_ass_attribute18
,p_ass_attribute19 => p_ass_attribute19
,p_ass_attribute20 => p_ass_attribute20
,p_ass_attribute21 => p_ass_attribute21
,p_ass_attribute22 => p_ass_attribute22
,p_ass_attribute23 => p_ass_attribute23
,p_ass_attribute24 => p_ass_attribute24
,p_ass_attribute25 => p_ass_attribute25
,p_ass_attribute26 => p_ass_attribute26
,p_ass_attribute27 => p_ass_attribute27
,p_ass_attribute28 => p_ass_attribute28
,p_ass_attribute29 => p_ass_attribute29
,p_ass_attribute30 => p_ass_attribute30
,p_title => p_title
,p_scl_segment1 => p_scl_segment1
,p_scl_segment2 => p_scl_segment2
,p_scl_segment3 => p_scl_segment3
,p_scl_segment4 => p_scl_segment4
,p_scl_segment5 => p_scl_segment5
,p_scl_segment6 => p_scl_segment6
,p_scl_segment7 => p_scl_segment7
,p_scl_segment8 => p_scl_segment8
,p_scl_segment9 => p_scl_segment9
,p_scl_segment10 => p_scl_segment10
,p_scl_segment11 => p_scl_segment11
,p_scl_segment12 => p_scl_segment12
,p_scl_segment13 => p_scl_segment13
,p_scl_segment14 => p_scl_segment14
,p_scl_segment15 => p_scl_segment15
,p_scl_segment16 => p_scl_segment16
,p_scl_segment17 => p_scl_segment17
,p_scl_segment18 => p_scl_segment18
,p_scl_segment19 => p_scl_segment19
,p_scl_segment20 => p_scl_segment20
,p_scl_segment21 => p_scl_segment21
,p_scl_segment22 => p_scl_segment22
,p_scl_segment23 => p_scl_segment23
,p_scl_segment24 => p_scl_segment24
,p_scl_segment25 => p_scl_segment25
,p_scl_segment26 => p_scl_segment26
,p_scl_segment27 => p_scl_segment27
,p_scl_segment28 => p_scl_segment28
,p_scl_segment29 => p_scl_segment29
,p_scl_segment30 => p_scl_segment30
,p_scl_concat_segments => l_scl_concat_segments
,p_concatenated_segments => p_concatenated_segments
,p_pgp_segment1 => p_pgp_segment1
,p_pgp_segment2 => p_pgp_segment2
,p_pgp_segment3 => p_pgp_segment3
,p_pgp_segment4 => p_pgp_segment4
,p_pgp_segment5 => p_pgp_segment5
,p_pgp_segment6 => p_pgp_segment6
,p_pgp_segment7 => p_pgp_segment7
,p_pgp_segment8 => p_pgp_segment8
,p_pgp_segment9 => p_pgp_segment9
,p_pgp_segment10 => p_pgp_segment10
,p_pgp_segment11 => p_pgp_segment11
,p_pgp_segment12 => p_pgp_segment12
,p_pgp_segment13 => p_pgp_segment13
,p_pgp_segment14 => p_pgp_segment14
,p_pgp_segment15 => p_pgp_segment15
,p_pgp_segment16 => p_pgp_segment16
,p_pgp_segment17 => p_pgp_segment17
,p_pgp_segment18 => p_pgp_segment18
,p_pgp_segment19 => p_pgp_segment19
,p_pgp_segment20 => p_pgp_segment20
,p_pgp_segment21 => p_pgp_segment21
,p_pgp_segment22 => p_pgp_segment22
,p_pgp_segment23 => p_pgp_segment23
,p_pgp_segment24 => p_pgp_segment24
,p_pgp_segment25 => p_pgp_segment25
,p_pgp_segment26 => p_pgp_segment26
,p_pgp_segment27 => p_pgp_segment27
,p_pgp_segment28 => p_pgp_segment28
,p_pgp_segment29 => p_pgp_segment29
,p_pgp_segment30 => p_pgp_segment30
,p_concat_segments => p_concat_segments
--,p_contract_id => p_contract_id
,p_establishment_id => p_establishment_id
--,p_collective_agreement_id => p_collective_agreement_id
--,p_cagr_id_flex_num => p_cagr_id_flex_num
,p_cag_segment1 => p_cag_segment1
,p_cag_segment2 => p_cag_segment2
,p_cag_segment3 => p_cag_segment3
,p_cag_segment4 => p_cag_segment4
,p_cag_segment5 => p_cag_segment5
,p_cag_segment6 => p_cag_segment6
,p_cag_segment7 => p_cag_segment7
,p_cag_segment8 => p_cag_segment8
,p_cag_segment9 => p_cag_segment9
,p_cag_segment10 => p_cag_segment10
,p_cag_segment11 => p_cag_segment11
,p_cag_segment12 => p_cag_segment12
,p_cag_segment13 => p_cag_segment13
,p_cag_segment14 => p_cag_segment14
,p_cag_segment15 => p_cag_segment15
,p_cag_segment16 => p_cag_segment16
,p_cag_segment17 => p_cag_segment17
,p_cag_segment18 => p_cag_segment18
,p_cag_segment19 => p_cag_segment19
,p_cag_segment20 => p_cag_segment20
,p_cagr_grade_def_id => l_cagr_grade_def_id
,p_cagr_concatenated_segments => p_cagr_concatenated_segments
,p_group_name => p_group_name
,p_comment_id => p_comment_id
,p_people_group_id => p_people_group_id
,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date);
,p_datetrack_update_mode => 'CORRECTION'
,p_assignment_id => p_assignment_id
,p_object_version_number => p_object_version_number
,p_assignment_status_type_id => p_assignment_status_type_id
,p_change_reason => p_change_reason
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date
);
,p_datetrack_update_mode => 'CORRECTION'
,p_assignment_id => p_assignment_id
,p_object_version_number => p_object_version_number
,p_assignment_status_type_id => p_assignment_status_type_id
,p_change_reason => p_change_reason
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date);
,p_datetrack_update_mode => 'CORRECTION'
,p_assignment_id => p_assignment_id
,p_object_version_number => p_object_version_number
,p_assignment_status_type_id => p_assignment_status_type_id
,p_change_reason => p_change_reason
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date);
hr_assignment_internal.update_status_type_apl_asg
(p_effective_date => l_effective_date
,p_datetrack_update_mode => 'CORRECTION'
,p_assignment_id => p_assignment_id
,p_object_version_number => p_object_version_number
,p_expected_system_status => l_assignment_status
,p_assignment_status_type_id => p_assignment_status_type_id
,p_change_reason => p_change_reason
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date);
END update_applicant_asg;
PROCEDURE update_cwk_assignment
(p_validate IN BOOLEAN DEFAULT FALSE
,p_effective_date IN DATE DEFAULT hr_api.g_date
,p_datetrack_update_mode IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
,p_object_version_number IN OUT NOCOPY NUMBER
,p_assignment_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
,p_project_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_vendor_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_vendor_employee_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
,p_vendor_site_id IN NUMBER DEFAULT hr_api.g_number
,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
--,p_grade_id IN NUMBER DEFAULT hr_api.g_number
,p_position_id IN NUMBER DEFAULT hr_api.g_number
,p_job_id IN NUMBER DEFAULT hr_api.g_number
,p_location_id IN NUMBER DEFAULT hr_api.g_number
,p_organization_id IN NUMBER DEFAULT hr_api.g_number
,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_projected_assignment_end IN DATE DEFAULT hr_api.g_date
,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
,p_effective_start_date OUT NOCOPY DATE
,p_effective_end_date OUT NOCOPY DATE
,p_comment_id OUT NOCOPY NUMBER
,p_no_managers_warning OUT NOCOPY BOOLEAN
,p_other_manager_warning OUT NOCOPY BOOLEAN
,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
,p_concatenated_segments OUT NOCOPY VARCHAR2
,p_hourly_salaried_warning OUT NOCOPY BOOLEAN
,p_scl_concat_segments OUT NOCOPY VARCHAR2
,p_people_group_name OUT NOCOPY VARCHAR2
,p_people_group_id OUT NOCOPY NUMBER
,p_spp_delete_warning OUT NOCOPY BOOLEAN
,p_entries_changed_warning OUT NOCOPY VARCHAR2
,p_tax_district_changed_warning OUT NOCOPY BOOLEAN) IS
--
-- Define Local Variables
--
l_proc VARCHAR2(72) := g_package||'update_cwk_assignment';
l_spp_delete_warning BOOLEAN;
SAVEPOINT update_cwk_assignment;
hr_assignment_api.update_cwk_asg
(p_validate => p_validate
,p_effective_date => p_effective_date
,p_datetrack_update_mode => p_datetrack_update_mode
,p_assignment_id => p_assignment_id
,p_object_version_number => l_object_version_number
,p_assignment_category => p_assignment_category
,p_assignment_number => p_assignment_number
,p_change_reason => p_change_reason
,p_comments => p_comments
,p_default_code_comb_id => p_default_code_comb_id
,p_establishment_id => p_establishment_id
,p_frequency => p_frequency
,p_internal_address_line => p_internal_address_line
,p_labour_union_member_flag => p_labour_union_member_flag
,p_manager_flag => p_manager_flag
,p_normal_hours => p_normal_hours
,p_project_title => p_project_title
,p_set_of_books_id => p_set_of_books_id
,p_source_type => p_source_type
,p_supervisor_id => p_supervisor_id
,p_supervisor_assignment_id => p_supervisor_assignment_id
,p_time_normal_finish => p_time_normal_finish
,p_time_normal_start => p_time_normal_start
,p_title => p_title
,p_vendor_assignment_number => p_vendor_assignment_number
,p_vendor_employee_number => p_vendor_employee_number
,p_vendor_id => p_vendor_id
,p_vendor_site_id => p_vendor_site_id
,p_assignment_status_type_id => p_assignment_status_type_id
,p_concat_segments => p_concat_segments
,p_attribute_category => p_attribute_category
,p_attribute1 => p_attribute1
,p_attribute2 => p_attribute2
,p_attribute3 => p_attribute3
,p_attribute4 => p_attribute4
,p_attribute5 => p_attribute5
,p_attribute6 => p_attribute6
,p_attribute7 => p_attribute7
,p_attribute8 => p_attribute8
,p_attribute9 => p_attribute9
,p_attribute10 => p_attribute10
,p_attribute11 => p_attribute11
,p_attribute12 => p_attribute12
,p_attribute13 => p_attribute13
,p_attribute14 => p_attribute14
,p_attribute15 => p_attribute15
,p_attribute16 => p_attribute16
,p_attribute17 => p_attribute17
,p_attribute18 => p_attribute18
,p_attribute19 => p_attribute19
,p_attribute20 => p_attribute20
,p_attribute21 => p_attribute21
,p_attribute22 => p_attribute22
,p_attribute23 => p_attribute23
,p_attribute24 => p_attribute24
,p_attribute25 => p_attribute25
,p_attribute26 => p_attribute26
,p_attribute27 => p_attribute27
,p_attribute28 => p_attribute28
,p_attribute29 => p_attribute29
,p_attribute30 => p_attribute30
,p_scl_segment1 => p_scl_segment1
,p_scl_segment2 => p_scl_segment2
,p_scl_segment3 => p_scl_segment3
,p_scl_segment4 => p_scl_segment4
,p_scl_segment5 => p_scl_segment5
,p_scl_segment6 => p_scl_segment6
,p_scl_segment7 => p_scl_segment7
,p_scl_segment8 => p_scl_segment8
,p_scl_segment9 => p_scl_segment9
,p_scl_segment10 => p_scl_segment10
,p_scl_segment11 => p_scl_segment11
,p_scl_segment12 => p_scl_segment12
,p_scl_segment13 => p_scl_segment13
,p_scl_segment14 => p_scl_segment14
,p_scl_segment15 => p_scl_segment15
,p_scl_segment16 => p_scl_segment16
,p_scl_segment17 => p_scl_segment17
,p_scl_segment18 => p_scl_segment18
,p_scl_segment19 => p_scl_segment19
,p_scl_segment20 => p_scl_segment20
,p_scl_segment21 => p_scl_segment21
,p_scl_segment22 => p_scl_segment22
,p_scl_segment23 => p_scl_segment23
,p_scl_segment24 => p_scl_segment24
,p_scl_segment25 => p_scl_segment25
,p_scl_segment26 => p_scl_segment26
,p_scl_segment27 => p_scl_segment27
,p_scl_segment28 => p_scl_segment28
,p_scl_segment29 => p_scl_segment29
,p_scl_segment30 => p_scl_segment30
,p_projected_assignment_end => p_projected_assignment_end
,p_org_now_no_manager_warning => l_org_now_no_manager_warning
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_comment_id => l_comment_id
,p_no_managers_warning => l_no_managers_warning
,p_other_manager_warning => l_other_manager_warning
,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
,p_concatenated_segments => l_concatenated_segments
,p_hourly_salaried_warning => l_hourly_salaried_warning);
hr_assignment_api.update_cwk_asg_criteria
(p_validate => p_validate
,p_effective_date => p_effective_date
,p_datetrack_update_mode => p_datetrack_update_mode
,p_assignment_id => p_assignment_id
,p_called_from_mass_update => TRUE
,p_object_version_number => l_object_version_number
-- ,p_grade_id => p_grade_id
,p_position_id => p_position_id
,p_job_id => p_job_id
,p_location_id => p_location_id
,p_organization_id => p_organization_id
--
-- p_pay_basis_id for future phases of cwk
--
--,p_pay_basis_id => NULL
,p_segment1 => p_segment1
,p_segment2 => p_segment2
,p_segment3 => p_segment3
,p_segment4 => p_segment4
,p_segment5 => p_segment5
,p_segment6 => p_segment6
,p_segment7 => p_segment7
,p_segment8 => p_segment8
,p_segment9 => p_segment9
,p_segment10 => p_segment10
,p_segment11 => p_segment11
,p_segment12 => p_segment12
,p_segment13 => p_segment13
,p_segment14 => p_segment14
,p_segment15 => p_segment15
,p_segment16 => p_segment16
,p_segment17 => p_segment17
,p_segment18 => p_segment18
,p_segment19 => p_segment19
,p_segment20 => p_segment20
,p_segment21 => p_segment21
,p_segment22 => p_segment22
,p_segment23 => p_segment23
,p_segment24 => p_segment24
,p_segment25 => p_segment25
,p_segment26 => p_segment26
,p_segment27 => p_segment27
,p_segment28 => p_segment28
,p_segment29 => p_segment29
,p_segment30 => p_segment30
,p_concat_segments => l_scl_concat_segments
,p_people_group_name => l_people_group_name
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_people_group_id => l_people_group_id
,p_org_now_no_manager_warning => l_org_now_no_manager_warning
,p_other_manager_warning => l_other_manager_warning
,p_spp_delete_warning => l_spp_delete_warning
,p_entries_changed_warning => l_entries_changed_warning
,p_tax_district_changed_warning => l_tax_district_changed_warning);
ELSIF l_spp_delete_warning = TRUE THEN
--
hr_utility.set_message(800,'HR_289826_SPP_DELETE_WARN_API');
p_spp_delete_warning := l_spp_delete_warning;
ROLLBACK TO update_cwk_asg;
p_spp_delete_warning := l_spp_delete_warning;
ROLLBACK TO update_cwk_asg;
p_spp_delete_warning := NULL;
END update_cwk_assignment;
PROCEDURE update_assignment
(p_validate IN BOOLEAN DEFAULT FALSE
,p_datetrack_update_mode IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_object_version_number IN OUT NOCOPY NUMBER
,p_ass_attribute_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_ass_attribute9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_assignment_id IN NUMBER DEFAULT hr_api.g_number
,p_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_assignment_status_type_id IN NUMBER DEFAULT hr_api.g_number
,p_bargaining_unit_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cagr_id_flex_num IN NUMBER DEFAULT hr_api.g_number
,p_change_reason IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_collective_agreement_id IN NUMBER DEFAULT hr_api.g_number
,p_contract_id IN NUMBER DEFAULT hr_api.g_number
,p_date_probation_end IN DATE DEFAULT hr_api.g_date
,p_default_code_comb_id IN NUMBER DEFAULT hr_api.g_number
,p_establishment_id IN NUMBER DEFAULT hr_api.g_number
,p_employment_category IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_grade_id IN NUMBER DEFAULT hr_api.g_number
,p_hourly_salaried_code IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_internal_address_line IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_job_id IN NUMBER DEFAULT hr_api.g_number
,p_labour_union_member_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_location_id IN NUMBER DEFAULT hr_api.g_number
,p_manager_flag IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_normal_hours IN NUMBER DEFAULT hr_api.g_number
,p_pay_basis_id IN NUMBER DEFAULT hr_api.g_number
,p_payroll_id IN NUMBER DEFAULT hr_api.g_number
,p_perf_review_period IN NUMBER DEFAULT hr_api.g_number
,p_perf_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_position_id IN NUMBER DEFAULT hr_api.g_number
,p_probation_period IN NUMBER DEFAULT hr_api.g_number
,p_probation_unit IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_sal_review_period IN NUMBER DEFAULT hr_api.g_number
,p_sal_review_period_frequency IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_set_of_books_id IN NUMBER DEFAULT hr_api.g_number
,p_source_type IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_supervisor_id IN NUMBER DEFAULT hr_api.g_number
,p_supervisor_assignment_id IN NUMBER DEFAULT hr_api.g_number
,p_time_normal_finish IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_time_normal_start IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_cag_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_comments IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_concat_segments IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_effective_date IN DATE DEFAULT hr_api.g_date
,p_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment1 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment10 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment11 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment12 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment13 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment14 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment15 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment16 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment17 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment18 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment19 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment2 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment20 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment21 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment22 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment23 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment24 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment25 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment26 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment27 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment28 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment29 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment3 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment30 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment4 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment5 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment6 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment7 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment8 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_scl_segment9 IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_grade_ladder_pgm_id IN NUMBER DEFAULT hr_api.g_number
,p_recruiter_id IN NUMBER DEFAULT hr_api.g_number
,p_person_referred_by_id IN NUMBER DEFAULT hr_api.g_number
,p_recruitment_activity_id IN NUMBER DEFAULT hr_api.g_number
,p_source_organization_id IN NUMBER DEFAULT hr_api.g_number
,p_vacancy_id IN NUMBER DEFAULT hr_api.g_number
,p_application_id IN NUMBER DEFAULT hr_api.g_number
,p_vendor_assignment_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_vendor_employee_number IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_vendor_id IN NUMBER DEFAULT hr_api.g_number
,p_vendor_site_id IN NUMBER DEFAULT hr_api.g_number
,p_project_title IN VARCHAR2 DEFAULT hr_api.g_varchar2
,p_projected_assignment_end IN DATE DEFAULT hr_api.g_date
,p_organization_id IN OUT NOCOPY NUMBER
,p_concatenated_segments IN OUT NOCOPY VARCHAR2
,p_special_ceiling_step_id IN OUT NOCOPY NUMBER
,p_cagr_grade_def_id IN OUT NOCOPY NUMBER
,p_comment_id OUT NOCOPY NUMBER
,p_cagr_concatenated_segments OUT NOCOPY VARCHAR2
,p_effective_end_date OUT NOCOPY DATE
,p_effective_start_date OUT NOCOPY DATE
,p_no_managers_warning OUT NOCOPY BOOLEAN
,p_other_manager_warning OUT NOCOPY BOOLEAN
,p_gsp_post_process_warning OUT NOCOPY VARCHAR2
,p_soft_coding_keyflex_id OUT NOCOPY NUMBER
,p_entries_changed_warning OUT NOCOPY VARCHAR2
,p_group_name OUT NOCOPY VARCHAR2
,p_org_now_no_manager_warning OUT NOCOPY BOOLEAN
,p_people_group_id OUT NOCOPY NUMBER
,p_spp_delete_warning OUT NOCOPY BOOLEAN
,p_tax_district_changed_warning OUT NOCOPY BOOLEAN ) IS
--
l_log_message VARCHAR2(255);
l_proc VARCHAR2(72) := g_package||'update_assignment';
l_spp_delete_warning BOOLEAN;
SELECT assignment_type
FROM per_assignments_f paf
WHERE paf.assignment_id = p_assignment_id
AND l_effective_date BETWEEN paf.effective_start_Date
AND paf.effective_end_date;
,p_datetrack_update_mode => p_datetrack_update_mode
,p_effective_date => p_effective_date
,p_segment1 => p_segment1
,p_segment10 => p_segment10
,p_segment11 => p_segment11
,p_segment12 => p_segment12
,p_segment13 => p_segment13
,p_segment14 => p_segment14
,p_segment15 => p_segment15
,p_segment16 => p_segment16
,p_segment17 => p_segment17
,p_segment18 => p_segment18
,p_segment19 => p_segment19
,p_segment2 => p_segment2
,p_segment20 => p_segment20
,p_segment21 => p_segment21
,p_segment22 => p_segment22
,p_segment23 => p_segment23
,p_segment24 => p_segment24
,p_segment25 => p_segment25
,p_segment26 => p_segment26
,p_segment27 => p_segment27
,p_segment28 => p_segment28
,p_segment29 => p_segment29
,p_segment3 => p_segment3
,p_segment30 => p_segment30
,p_segment4 => p_segment4
,p_segment5 => p_segment5
,p_segment6 => p_segment6
,p_segment7 => p_segment7
,p_segment8 => p_segment8
,p_segment9 => p_segment9
,p_scl_segment1 => p_scl_segment1
,p_scl_segment10 => p_scl_segment10
,p_scl_segment11 => p_scl_segment11
,p_scl_segment12 => p_scl_segment12
,p_scl_segment13 => p_scl_segment13
,p_scl_segment14 => p_scl_segment14
,p_scl_segment15 => p_scl_segment15
,p_scl_segment16 => p_scl_segment16
,p_scl_segment17 => p_scl_segment17
,p_scl_segment18 => p_scl_segment18
,p_scl_segment19 => p_scl_segment19
,p_scl_segment2 => p_scl_segment2
,p_scl_segment20 => p_scl_segment20
,p_scl_segment21 => p_scl_segment21
,p_scl_segment22 => p_scl_segment22
,p_scl_segment23 => p_scl_segment23
,p_scl_segment24 => p_scl_segment24
,p_scl_segment25 => p_scl_segment25
,p_scl_segment26 => p_scl_segment26
,p_scl_segment27 => p_scl_segment27
,p_scl_segment28 => p_scl_segment28
,p_scl_segment29 => p_scl_segment29
,p_scl_segment3 => p_scl_segment3
,p_scl_segment30 => p_scl_segment30
,p_scl_segment4 => p_scl_segment4
,p_scl_segment5 => p_scl_segment5
,p_scl_segment6 => p_scl_segment6
,p_scl_segment7 => p_scl_segment7
,p_scl_segment8 => p_scl_segment8
,p_scl_segment9 => p_scl_segment9
,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
,p_validate => p_validate
,p_cagr_grade_def_id => l_cagr_grade_def_id
,p_concatenated_segments => l_concatenated_segments
,p_cagr_concatenated_segments => p_cagr_concatenated_segments
,p_effective_end_date => p_effective_end_date
,p_effective_start_date => p_effective_start_date
,p_no_managers_warning => p_no_managers_warning
,p_other_manager_warning => p_other_manager_warning
,p_gsp_post_process_warning => p_gsp_post_process_warning
,p_special_ceiling_step_id => l_special_ceiling_step_id
,p_entries_changed_warning => p_entries_changed_warning
,p_group_name => p_group_name
,p_org_now_no_manager_warning => p_org_now_no_manager_warning
,p_people_group_id => p_people_group_id
,p_spp_delete_warning => p_spp_delete_warning
,p_tax_district_changed_warning => p_tax_district_changed_warning
,p_comment_id => p_comment_id
,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
,p_object_version_number => l_object_version_number
,p_organization_id => l_organization_id);
update_applicant_asg
(p_validate => p_validate
,p_effective_date => p_effective_date
,p_datetrack_update_mode => p_datetrack_update_mode
,p_assignment_id => p_assignment_id
,p_object_version_number => p_object_version_number
,p_recruiter_id => p_recruiter_id
,p_grade_id => p_grade_id
,p_position_id => p_position_id
,p_job_id => p_job_id
,p_payroll_id => p_payroll_id
,p_location_id => p_location_id
,p_person_referred_by_id => p_person_referred_by_id
,p_assignment_status_type_id => p_assignment_status_type_id
,p_supervisor_id => p_supervisor_id
,p_special_ceiling_step_id => p_special_ceiling_step_id
,p_recruitment_activity_id => p_recruitment_activity_id
,p_source_organization_id => p_source_organization_id
,p_organization_id => p_organization_id
,p_vacancy_id => p_vacancy_id
,p_pay_basis_id => p_pay_basis_id
,p_application_id => p_application_id
,p_change_reason => p_change_reason
,p_comments => p_comments
,p_date_probation_end => p_date_probation_end
,p_default_code_comb_id => p_default_code_comb_id
,p_employment_category => p_employment_category
,p_frequency => p_frequency
,p_internal_address_line => p_internal_address_line
,p_manager_flag => p_manager_flag
,p_normal_hours => p_normal_hours
,p_perf_review_period => p_perf_review_period
,p_perf_review_period_frequency => p_perf_review_period_frequency
,p_probation_period => p_probation_period
,p_probation_unit => p_probation_unit
,p_sal_review_period => p_sal_review_period
,p_sal_review_period_frequency => p_sal_review_period_frequency
,p_set_of_books_id => p_set_of_books_id
,p_source_type => p_source_type
,p_time_normal_finish => p_time_normal_finish
,p_time_normal_start => p_time_normal_start
,p_bargaining_unit_code => p_bargaining_unit_code
,p_ass_attribute_category => p_ass_attribute_category
,p_ass_attribute1 => p_ass_attribute1
,p_ass_attribute2 => p_ass_attribute2
,p_ass_attribute3 => p_ass_attribute3
,p_ass_attribute4 => p_ass_attribute4
,p_ass_attribute5 => p_ass_attribute5
,p_ass_attribute6 => p_ass_attribute6
,p_ass_attribute7 => p_ass_attribute7
,p_ass_attribute8 => p_ass_attribute8
,p_ass_attribute9 => p_ass_attribute9
,p_ass_attribute10 => p_ass_attribute10
,p_ass_attribute11 => p_ass_attribute11
,p_ass_attribute12 => p_ass_attribute12
,p_ass_attribute13 => p_ass_attribute13
,p_ass_attribute14 => p_ass_attribute14
,p_ass_attribute15 => p_ass_attribute15
,p_ass_attribute16 => p_ass_attribute16
,p_ass_attribute17 => p_ass_attribute17
,p_ass_attribute18 => p_ass_attribute18
,p_ass_attribute19 => p_ass_attribute19
,p_ass_attribute20 => p_ass_attribute20
,p_ass_attribute21 => p_ass_attribute21
,p_ass_attribute22 => p_ass_attribute22
,p_ass_attribute23 => p_ass_attribute23
,p_ass_attribute24 => p_ass_attribute24
,p_ass_attribute25 => p_ass_attribute25
,p_ass_attribute26 => p_ass_attribute26
,p_ass_attribute27 => p_ass_attribute27
,p_ass_attribute28 => p_ass_attribute28
,p_ass_attribute29 => p_ass_attribute29
,p_ass_attribute30 => p_ass_attribute30
,p_title => p_title
,p_scl_segment1 => p_scl_segment1
,p_scl_segment2 => p_scl_segment2
,p_scl_segment3 => p_scl_segment3
,p_scl_segment4 => p_scl_segment4
,p_scl_segment5 => p_scl_segment5
,p_scl_segment6 => p_scl_segment6
,p_scl_segment7 => p_scl_segment7
,p_scl_segment8 => p_scl_segment8
,p_scl_segment9 => p_scl_segment9
,p_scl_segment10 => p_scl_segment10
,p_scl_segment11 => p_scl_segment11
,p_scl_segment12 => p_scl_segment12
,p_scl_segment13 => p_scl_segment13
,p_scl_segment14 => p_scl_segment14
,p_scl_segment15 => p_scl_segment15
,p_scl_segment16 => p_scl_segment16
,p_scl_segment17 => p_scl_segment17
,p_scl_segment18 => p_scl_segment18
,p_scl_segment19 => p_scl_segment19
,p_scl_segment20 => p_scl_segment20
,p_scl_segment21 => p_scl_segment21
,p_scl_segment22 => p_scl_segment22
,p_scl_segment23 => p_scl_segment23
,p_scl_segment24 => p_scl_segment24
,p_scl_segment25 => p_scl_segment25
,p_scl_segment26 => p_scl_segment26
,p_scl_segment27 => p_scl_segment27
,p_scl_segment28 => p_scl_segment28
,p_scl_segment29 => p_scl_segment29
,p_scl_segment30 => p_scl_segment30
,p_concatenated_segments => p_concatenated_segments
,p_pgp_segment1 => p_segment1
,p_pgp_segment2 => p_segment2
,p_pgp_segment3 => p_segment3
,p_pgp_segment4 => p_segment4
,p_pgp_segment5 => p_segment5
,p_pgp_segment6 => p_segment6
,p_pgp_segment7 => p_segment7
,p_pgp_segment8 => p_segment8
,p_pgp_segment9 => p_segment9
,p_pgp_segment10 => p_segment10
,p_pgp_segment11 => p_segment11
,p_pgp_segment12 => p_segment12
,p_pgp_segment13 => p_segment13
,p_pgp_segment14 => p_segment14
,p_pgp_segment15 => p_segment15
,p_pgp_segment16 => p_segment16
,p_pgp_segment17 => p_segment17
,p_pgp_segment18 => p_segment18
,p_pgp_segment19 => p_segment19
,p_pgp_segment20 => p_segment20
,p_pgp_segment21 => p_segment21
,p_pgp_segment22 => p_segment22
,p_pgp_segment23 => p_segment23
,p_pgp_segment24 => p_segment24
,p_pgp_segment25 => p_segment25
,p_pgp_segment26 => p_segment26
,p_pgp_segment27 => p_segment27
,p_pgp_segment28 => p_segment28
,p_pgp_segment29 => p_segment29
,p_pgp_segment30 => p_segment30
,p_concat_segments => p_concat_segments
,p_contract_id => p_contract_id
,p_establishment_id => p_establishment_id
,p_collective_agreement_id => p_collective_agreement_id
,p_cagr_id_flex_num => p_cagr_id_flex_num
,p_cag_segment1 => p_cag_segment1
,p_cag_segment2 => p_cag_segment2
,p_cag_segment3 => p_cag_segment3
,p_cag_segment4 => p_cag_segment4
,p_cag_segment5 => p_cag_segment5
,p_cag_segment6 => p_cag_segment6
,p_cag_segment7 => p_cag_segment7
,p_cag_segment8 => p_cag_segment8
,p_cag_segment9 => p_cag_segment9
,p_cag_segment10 => p_cag_segment10
,p_cag_segment11 => p_cag_segment11
,p_cag_segment12 => p_cag_segment12
,p_cag_segment13 => p_cag_segment13
,p_cag_segment14 => p_cag_segment14
,p_cag_segment15 => p_cag_segment15
,p_cag_segment16 => p_cag_segment16
,p_cag_segment17 => p_cag_segment17
,p_cag_segment18 => p_cag_segment18
,p_cag_segment19 => p_cag_segment19
,p_cag_segment20 => p_cag_segment20
,p_grade_ladder_pgm_id => p_grade_ladder_pgm_id
,p_cagr_grade_def_id => l_cagr_grade_def_id
,p_cagr_concatenated_segments => p_cagr_concatenated_segments
,p_group_name => p_group_name
,p_comment_id => p_comment_id
,p_people_group_id => p_people_group_id
,p_soft_coding_keyflex_id => p_soft_coding_keyflex_id
,p_effective_start_date => p_effective_start_date
,p_effective_end_date => p_effective_end_date);
update_cwk_assignment
(p_validate => p_validate
,p_effective_date => p_effective_date
,p_datetrack_update_mode => p_datetrack_update_mode
,p_assignment_id => p_assignment_id
,p_object_version_number => l_object_version_number
,p_assignment_category => p_employment_category
,p_assignment_number => p_assignment_number
,p_change_reason => p_change_reason
,p_comments => p_comments
,p_default_code_comb_id => p_default_code_comb_id
,p_establishment_id => p_establishment_id
,p_frequency => p_frequency
,p_internal_address_line => p_internal_address_line
,p_labour_union_member_flag => p_labour_union_member_flag
,p_manager_flag => p_manager_flag
,p_normal_hours => p_normal_hours
,p_project_title => p_project_title
,p_set_of_books_id => p_set_of_books_id
,p_source_type => p_source_type
,p_supervisor_id => p_supervisor_id
,p_supervisor_assignment_id => p_supervisor_assignment_id
,p_time_normal_finish => p_time_normal_finish
,p_time_normal_start => p_time_normal_start
,p_title => p_title
,p_vendor_assignment_number => p_vendor_assignment_number
,p_vendor_employee_number => p_vendor_employee_number
,p_vendor_id => p_vendor_id
,p_vendor_site_id => p_vendor_site_id
,p_assignment_status_type_id => p_assignment_status_type_id
,p_concat_segments => p_concat_segments
,p_attribute_category => p_ass_attribute_category
,p_attribute1 => p_ass_attribute1
,p_attribute2 => p_ass_attribute2
,p_attribute3 => p_ass_attribute3
,p_attribute4 => p_ass_attribute4
,p_attribute5 => p_ass_attribute5
,p_attribute6 => p_ass_attribute6
,p_attribute7 => p_ass_attribute7
,p_attribute8 => p_ass_attribute8
,p_attribute9 => p_ass_attribute9
,p_attribute10 => p_ass_attribute10
,p_attribute11 => p_ass_attribute11
,p_attribute12 => p_ass_attribute12
,p_attribute13 => p_ass_attribute13
,p_attribute14 => p_ass_attribute14
,p_attribute15 => p_ass_attribute15
,p_attribute16 => p_ass_attribute16
,p_attribute17 => p_ass_attribute17
,p_attribute18 => p_ass_attribute18
,p_attribute19 => p_ass_attribute19
,p_attribute20 => p_ass_attribute20
,p_attribute21 => p_ass_attribute21
,p_attribute22 => p_ass_attribute22
,p_attribute23 => p_ass_attribute23
,p_attribute24 => p_ass_attribute24
,p_attribute25 => p_ass_attribute25
,p_attribute26 => p_ass_attribute26
,p_attribute27 => p_ass_attribute27
,p_attribute28 => p_ass_attribute28
,p_attribute29 => p_ass_attribute29
,p_attribute30 => p_ass_attribute30
,p_scl_segment1 => p_scl_segment1
,p_scl_segment2 => p_scl_segment2
,p_scl_segment3 => p_scl_segment3
,p_scl_segment4 => p_scl_segment4
,p_scl_segment5 => p_scl_segment5
,p_scl_segment6 => p_scl_segment6
,p_scl_segment7 => p_scl_segment7
,p_scl_segment8 => p_scl_segment8
,p_scl_segment9 => p_scl_segment9
,p_scl_segment10 => p_scl_segment10
,p_scl_segment11 => p_scl_segment11
,p_scl_segment12 => p_scl_segment12
,p_scl_segment13 => p_scl_segment13
,p_scl_segment14 => p_scl_segment14
,p_scl_segment15 => p_scl_segment15
,p_scl_segment16 => p_scl_segment16
,p_scl_segment17 => p_scl_segment17
,p_scl_segment18 => p_scl_segment18
,p_scl_segment19 => p_scl_segment19
,p_scl_segment20 => p_scl_segment20
,p_scl_segment21 => p_scl_segment21
,p_scl_segment22 => p_scl_segment22
,p_scl_segment23 => p_scl_segment23
,p_scl_segment24 => p_scl_segment24
,p_scl_segment25 => p_scl_segment25
,p_scl_segment26 => p_scl_segment26
,p_scl_segment27 => p_scl_segment27
,p_scl_segment28 => p_scl_segment28
,p_scl_segment29 => p_scl_segment29
,p_scl_segment30 => p_scl_segment30
-- ,p_grade_id => p_grade_id
,p_position_id => p_position_id
,p_job_id => p_job_id
,p_location_id => p_location_id
,p_organization_id => p_organization_id
,p_segment1 => p_segment1
,p_segment2 => p_segment2
,p_segment3 => p_segment3
,p_segment4 => p_segment4
,p_segment5 => p_segment5
,p_segment6 => p_segment6
,p_segment7 => p_segment7
,p_segment8 => p_segment8
,p_segment9 => p_segment9
,p_segment10 => p_segment10
,p_segment11 => p_segment11
,p_segment12 => p_segment12
,p_segment13 => p_segment13
,p_segment14 => p_segment14
,p_segment15 => p_segment15
,p_segment16 => p_segment16
,p_segment17 => p_segment17
,p_segment18 => p_segment18
,p_segment19 => p_segment19
,p_segment20 => p_segment20
,p_segment21 => p_segment21
,p_segment22 => p_segment22
,p_segment23 => p_segment23
,p_segment24 => p_segment24
,p_segment25 => p_segment25
,p_segment26 => p_segment26
,p_segment27 => p_segment27
,p_segment28 => p_segment28
,p_segment29 => p_segment29
,p_segment30 => p_segment30
,p_projected_assignment_end => p_projected_assignment_end
,p_org_now_no_manager_warning => l_org_now_no_manager_warning
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_comment_id => l_comment_id
,p_no_managers_warning => l_no_managers_warning
,p_other_manager_warning => l_other_manager_warning
,p_soft_coding_keyflex_id => l_soft_coding_keyflex_id
,p_concatenated_segments => l_concatenated_segments
,p_hourly_salaried_warning => l_hourly_salaried_warning
,p_scl_concat_segments => l_scl_concat_segments
,p_people_group_name => l_people_group_name
,p_people_group_id => l_people_group_id
,p_spp_delete_warning => l_spp_delete_warning
,p_entries_changed_warning => l_entries_changed_warning
,p_tax_district_changed_warning => l_tax_district_changed_warning);
END update_assignment;