[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure dt_update_dml
(p_rec in out nocopy per_asg_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'dt_update_dml';
update per_all_assignments_f
set
assignment_id = p_rec.assignment_id,
recruiter_id = p_rec.recruiter_id,
grade_id = p_rec.grade_id,
position_id = p_rec.position_id,
job_id = p_rec.job_id,
assignment_status_type_id = p_rec.assignment_status_type_id,
payroll_id = p_rec.payroll_id,
location_id = p_rec.location_id,
person_referred_by_id = p_rec.person_referred_by_id,
supervisor_id = p_rec.supervisor_id,
special_ceiling_step_id = p_rec.special_ceiling_step_id,
recruitment_activity_id = p_rec.recruitment_activity_id,
source_organization_id = p_rec.source_organization_id,
organization_id = p_rec.organization_id,
people_group_id = p_rec.people_group_id,
soft_coding_keyflex_id = p_rec.soft_coding_keyflex_id,
vacancy_id = p_rec.vacancy_id,
pay_basis_id = p_rec.pay_basis_id,
application_id = p_rec.application_id,
assignment_number = p_rec.assignment_number,
change_reason = p_rec.change_reason,
comment_id = p_rec.comment_id,
date_probation_end = p_rec.date_probation_end,
default_code_comb_id = p_rec.default_code_comb_id,
employment_category = p_rec.employment_category,
frequency = p_rec.frequency,
internal_address_line = p_rec.internal_address_line,
manager_flag = p_rec.manager_flag,
normal_hours = p_rec.normal_hours,
perf_review_period = p_rec.perf_review_period,
perf_review_period_frequency = p_rec.perf_review_period_frequency,
probation_period = p_rec.probation_period,
probation_unit = p_rec.probation_unit,
sal_review_period = p_rec.sal_review_period,
sal_review_period_frequency = p_rec.sal_review_period_frequency,
set_of_books_id = p_rec.set_of_books_id,
source_type = p_rec.source_type,
time_normal_finish = p_rec.time_normal_finish,
time_normal_start = p_rec.time_normal_start,
bargaining_unit_code = p_rec.bargaining_unit_code,
labour_union_member_flag = p_rec.labour_union_member_flag,
hourly_salaried_code = p_rec.hourly_salaried_code,
request_id = p_rec.request_id,
program_application_id = p_rec.program_application_id,
program_id = p_rec.program_id,
program_update_date = p_rec.program_update_date,
ass_attribute_category = p_rec.ass_attribute_category,
ass_attribute1 = p_rec.ass_attribute1,
ass_attribute2 = p_rec.ass_attribute2,
ass_attribute3 = p_rec.ass_attribute3,
ass_attribute4 = p_rec.ass_attribute4,
ass_attribute5 = p_rec.ass_attribute5,
ass_attribute6 = p_rec.ass_attribute6,
ass_attribute7 = p_rec.ass_attribute7,
ass_attribute8 = p_rec.ass_attribute8,
ass_attribute9 = p_rec.ass_attribute9,
ass_attribute10 = p_rec.ass_attribute10,
ass_attribute11 = p_rec.ass_attribute11,
ass_attribute12 = p_rec.ass_attribute12,
ass_attribute13 = p_rec.ass_attribute13,
ass_attribute14 = p_rec.ass_attribute14,
ass_attribute15 = p_rec.ass_attribute15,
ass_attribute16 = p_rec.ass_attribute16,
ass_attribute17 = p_rec.ass_attribute17,
ass_attribute18 = p_rec.ass_attribute18,
ass_attribute19 = p_rec.ass_attribute19,
ass_attribute20 = p_rec.ass_attribute20,
ass_attribute21 = p_rec.ass_attribute21,
ass_attribute22 = p_rec.ass_attribute22,
ass_attribute23 = p_rec.ass_attribute23,
ass_attribute24 = p_rec.ass_attribute24,
ass_attribute25 = p_rec.ass_attribute25,
ass_attribute26 = p_rec.ass_attribute26,
ass_attribute27 = p_rec.ass_attribute27,
ass_attribute28 = p_rec.ass_attribute28,
ass_attribute29 = p_rec.ass_attribute29,
ass_attribute30 = p_rec.ass_attribute30,
title = p_rec.title,
object_version_number = p_rec.object_version_number ,
contract_id = p_rec.contract_id,
establishment_id = p_rec.establishment_id,
collective_agreement_id = p_rec.collective_agreement_id,
cagr_grade_def_id = p_rec.cagr_grade_def_id,
cagr_id_flex_num = p_rec.cagr_id_flex_num,
notice_period = p_rec.notice_period,
notice_period_uom = p_rec.notice_period_uom,
employee_category = p_rec.employee_category,
work_at_home = p_rec.work_at_home,
job_post_source_name = p_rec.job_post_source_name,
posting_content_id = p_rec.posting_content_id,
period_of_placement_date_start = p_rec.period_of_placement_date_start,
vendor_id = p_rec.vendor_id,
vendor_employee_number = p_rec.vendor_employee_number,
vendor_assignment_number = p_rec.vendor_assignment_number,
assignment_category = p_rec.assignment_category,
project_title = p_rec.project_title,
applicant_rank = p_rec.applicant_rank
where assignment_id = p_rec.assignment_id
and effective_start_date = p_validation_start_date
and effective_end_date = p_validation_end_date;
End dt_update_dml;
Procedure update_dml
(p_rec in out nocopy per_asg_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'update_dml';
dt_update_dml(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End update_dml;
Procedure dt_pre_update
(p_rec in out nocopy per_asg_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'dt_pre_update';
If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
hr_utility.set_location(l_proc, 15);
per_asg_del.delete_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
ben_asg_ins.insert_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End dt_pre_update;
Procedure pre_update
(p_rec in out nocopy per_asg_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date) is
--
l_proc varchar2(72) := g_package||'pre_update';
select rowid, effective_start_date, effective_end_date
from per_all_assignments_f
where assignment_id = p_rec.assignment_id
and p_effective_date between
effective_start_date and effective_end_date;
select rowid
from per_all_assignments_f
where assignment_id = p_rec.assignment_id
and p_effective_date -1 between
effective_start_date and effective_end_date;
dt_pre_update
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => p_validation_start_date,
p_validation_end_date => p_validation_end_date);
End pre_update;
Procedure post_update
(p_rec in per_asg_shd.g_rec_type,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validation_start_date in date,
p_validation_end_date in date,
p_payroll_id_updated in boolean,
p_other_manager_warning in boolean,
p_hourly_salaried_warning in boolean,
p_no_managers_warning in boolean,
p_org_now_no_manager_warning in boolean) is
--
l_proc varchar2(72) := g_package||'post_update';
per_asg_rku.after_update
(p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_validation_start_date => p_validation_start_date
,p_validation_end_date => p_validation_end_date
,p_assignment_id => p_rec.assignment_id
,p_effective_start_date => p_rec.effective_start_date
,p_effective_end_date => p_rec.effective_end_date
,p_recruiter_id => p_rec.recruiter_id
,p_grade_id => p_rec.grade_id
,p_position_id => p_rec.position_id
,p_job_id => p_rec.job_id
,p_assignment_status_type_id => p_rec.assignment_status_type_id
,p_payroll_id => p_rec.payroll_id
,p_location_id => p_rec.location_id
,p_person_referred_by_id => p_rec.person_referred_by_id
,p_supervisor_id => p_rec.supervisor_id
,p_special_ceiling_step_id => p_rec.special_ceiling_step_id
,p_recruitment_activity_id => p_rec.recruitment_activity_id
,p_source_organization_id => p_rec.source_organization_id
,p_organization_id => p_rec.organization_id
,p_people_group_id => p_rec.people_group_id
,p_soft_coding_keyflex_id => p_rec.soft_coding_keyflex_id
,p_vacancy_id => p_rec.vacancy_id
,p_pay_basis_id => p_rec.pay_basis_id
,p_assignment_type => p_rec.assignment_type
,p_primary_flag => p_rec.primary_flag
,p_application_id => p_rec.application_id
,p_assignment_number => p_rec.assignment_number
,p_change_reason => p_rec.change_reason
,p_comment_id => p_rec.comment_id
,p_comments => p_rec.comment_text
,p_date_probation_end => p_rec.date_probation_end
,p_default_code_comb_id => p_rec.default_code_comb_id
,p_employment_category => p_rec.employment_category
,p_frequency => p_rec.frequency
,p_internal_address_line => p_rec.internal_address_line
,p_manager_flag => p_rec.manager_flag
,p_normal_hours => p_rec.normal_hours
,p_perf_review_period => p_rec.perf_review_period
,p_perf_review_period_frequen => p_rec.perf_review_period_frequency
,p_period_of_service_id => p_rec.period_of_service_id
,p_probation_period => p_rec.probation_period
,p_probation_unit => p_rec.probation_unit
,p_sal_review_period => p_rec.sal_review_period
,p_sal_review_period_frequen => p_rec.sal_review_period_frequency
,p_set_of_books_id => p_rec.set_of_books_id
,p_source_type => p_rec.source_type
,p_time_normal_finish => p_rec.time_normal_finish
,p_time_normal_start => p_rec.time_normal_start
,p_bargaining_unit_code => p_rec.bargaining_unit_code
,p_labour_union_member_flag => p_rec.labour_union_member_flag
,p_hourly_salaried_code => p_rec.hourly_salaried_code
,p_request_id => p_rec.request_id
,p_program_application_id => p_rec.program_application_id
,p_program_id => p_rec.program_id
,p_program_update_date => p_rec.program_update_date
,p_ass_attribute_category => p_rec.ass_attribute_category
,p_ass_attribute1 => p_rec.ass_attribute1
,p_ass_attribute2 => p_rec.ass_attribute2
,p_ass_attribute3 => p_rec.ass_attribute3
,p_ass_attribute4 => p_rec.ass_attribute4
,p_ass_attribute5 => p_rec.ass_attribute5
,p_ass_attribute6 => p_rec.ass_attribute6
,p_ass_attribute7 => p_rec.ass_attribute7
,p_ass_attribute8 => p_rec.ass_attribute8
,p_ass_attribute9 => p_rec.ass_attribute9
,p_ass_attribute10 => p_rec.ass_attribute10
,p_ass_attribute11 => p_rec.ass_attribute11
,p_ass_attribute12 => p_rec.ass_attribute12
,p_ass_attribute13 => p_rec.ass_attribute13
,p_ass_attribute14 => p_rec.ass_attribute14
,p_ass_attribute15 => p_rec.ass_attribute15
,p_ass_attribute16 => p_rec.ass_attribute16
,p_ass_attribute17 => p_rec.ass_attribute17
,p_ass_attribute18 => p_rec.ass_attribute18
,p_ass_attribute19 => p_rec.ass_attribute19
,p_ass_attribute20 => p_rec.ass_attribute20
,p_ass_attribute21 => p_rec.ass_attribute21
,p_ass_attribute22 => p_rec.ass_attribute22
,p_ass_attribute23 => p_rec.ass_attribute23
,p_ass_attribute24 => p_rec.ass_attribute24
,p_ass_attribute25 => p_rec.ass_attribute25
,p_ass_attribute26 => p_rec.ass_attribute26
,p_ass_attribute27 => p_rec.ass_attribute27
,p_ass_attribute28 => p_rec.ass_attribute28
,p_ass_attribute29 => p_rec.ass_attribute29
,p_ass_attribute30 => p_rec.ass_attribute30
,p_title => p_rec.title
,p_contract_id => p_rec.contract_id
,p_establishment_id => p_rec.establishment_id
,p_collective_agreement_id => p_rec.collective_agreement_id
,p_cagr_grade_def_id => p_rec.cagr_grade_def_id
,p_cagr_id_flex_num => p_rec.cagr_id_flex_num
,p_object_version_number => p_rec.object_version_number
,p_payroll_id_updated => p_payroll_id_updated
,p_other_manager_warning => p_other_manager_warning
,p_hourly_salaried_warning => p_hourly_salaried_warning
,p_no_managers_warning => p_no_managers_warning
,p_org_now_no_manager_warning => p_org_now_no_manager_warning
,p_notice_period => p_rec.notice_period
,p_notice_period_uom => p_rec.notice_period_uom
,p_employee_category => p_rec.employee_category
,p_work_at_home => p_rec.work_at_home
,p_job_post_source_name => p_rec.job_post_source_name
,p_posting_content_id => p_rec.posting_content_id
,p_placement_date_start => p_rec.period_of_placement_date_start
,p_vendor_id => p_rec.vendor_id
,p_vendor_employee_number => p_rec.vendor_employee_number
,p_vendor_assignment_number => p_rec.vendor_assignment_number
,p_assignment_category => p_rec.assignment_category
,p_project_title => p_rec.project_title
,p_applicant_rank => p_rec.applicant_rank
,p_grade_ladder_pgm_id => p_rec.grade_ladder_pgm_id
,p_supervisor_assignment_id => p_rec.supervisor_assignment_id /*Bug 2976136*/
,p_vendor_site_id => p_rec.vendor_site_id
,p_po_header_id => p_rec.po_header_id
,p_po_line_id => p_rec.po_line_id
,p_projected_assignment_end => p_rec.projected_assignment_end
,p_effective_start_date_o
=> per_asg_shd.g_old_rec.effective_start_date
,p_effective_end_date_o
=> per_asg_shd.g_old_rec.effective_end_date
,p_business_group_id_o
=> per_asg_shd.g_old_rec.business_group_id
,p_recruiter_id_o
=> per_asg_shd.g_old_rec.recruiter_id
,p_grade_id_o
=> per_asg_shd.g_old_rec.grade_id
,p_position_id_o
=> per_asg_shd.g_old_rec.position_id
,p_job_id_o
=> per_asg_shd.g_old_rec.job_id
,p_assignment_status_type_id_o
=> per_asg_shd.g_old_rec.assignment_status_type_id
,p_payroll_id_o
=> per_asg_shd.g_old_rec.payroll_id
,p_location_id_o
=> per_asg_shd.g_old_rec.location_id
,p_person_referred_by_id_o
=> per_asg_shd.g_old_rec.person_referred_by_id
,p_supervisor_id_o
=> per_asg_shd.g_old_rec.supervisor_id
,p_special_ceiling_step_id_o
=> per_asg_shd.g_old_rec.special_ceiling_step_id
,p_person_id_o
=> per_asg_shd.g_old_rec.person_id
,p_recruitment_activity_id_o
=> per_asg_shd.g_old_rec.recruitment_activity_id
,p_source_organization_id_o
=> per_asg_shd.g_old_rec.source_organization_id
,p_organization_id_o
=> per_asg_shd.g_old_rec.organization_id
,p_people_group_id_o
=> per_asg_shd.g_old_rec.people_group_id
,p_soft_coding_keyflex_id_o
=> per_asg_shd.g_old_rec.soft_coding_keyflex_id
,p_vacancy_id_o
=> per_asg_shd.g_old_rec.vacancy_id
,p_assignment_sequence_o
=> per_asg_shd.g_old_rec.assignment_sequence
,p_pay_basis_id_o
=> per_asg_shd.g_old_rec.pay_basis_id
,p_assignment_type_o
=> per_asg_shd.g_old_rec.assignment_type
,p_primary_flag_o
=> per_asg_shd.g_old_rec.primary_flag
,p_application_id_o
=> per_asg_shd.g_old_rec.application_id
,p_assignment_number_o
=> per_asg_shd.g_old_rec.assignment_number
,p_change_reason_o
=> per_asg_shd.g_old_rec.change_reason
,p_comment_id_o
=> per_asg_shd.g_old_rec.comment_id
,p_date_probation_end_o
=> per_asg_shd.g_old_rec.date_probation_end
,p_default_code_comb_id_o
=> per_asg_shd.g_old_rec.default_code_comb_id
,p_employment_category_o
=> per_asg_shd.g_old_rec.employment_category
,p_frequency_o
=> per_asg_shd.g_old_rec.frequency
,p_internal_address_line_o
=> per_asg_shd.g_old_rec.internal_address_line
,p_manager_flag_o
=> per_asg_shd.g_old_rec.manager_flag
,p_normal_hours_o
=> per_asg_shd.g_old_rec.normal_hours
,p_perf_review_period_o
=> per_asg_shd.g_old_rec.perf_review_period
,p_perf_review_period_frequen_o
=> per_asg_shd.g_old_rec.perf_review_period_frequency
,p_period_of_service_id_o
=> per_asg_shd.g_old_rec.period_of_service_id
,p_probation_period_o
=> per_asg_shd.g_old_rec.probation_period
,p_probation_unit_o
=> per_asg_shd.g_old_rec.probation_unit
,p_sal_review_period_o
=> per_asg_shd.g_old_rec.sal_review_period
,p_sal_review_period_frequen_o
=> per_asg_shd.g_old_rec.sal_review_period_frequency
,p_set_of_books_id_o
=> per_asg_shd.g_old_rec.set_of_books_id
,p_source_type_o
=> per_asg_shd.g_old_rec.source_type
,p_time_normal_finish_o
=> per_asg_shd.g_old_rec.time_normal_finish
,p_time_normal_start_o
=> per_asg_shd.g_old_rec.time_normal_start
,p_bargaining_unit_code_o
=> per_asg_shd.g_old_rec.bargaining_unit_code
,p_labour_union_member_flag_o
=> per_asg_shd.g_old_rec.labour_union_member_flag
,p_hourly_salaried_code_o
=> per_asg_shd.g_old_rec.hourly_salaried_code
,p_request_id_o
=> per_asg_shd.g_old_rec.request_id
,p_program_application_id_o
=> per_asg_shd.g_old_rec.program_application_id
,p_program_id_o
=> per_asg_shd.g_old_rec.program_id
,p_program_update_date_o
=> per_asg_shd.g_old_rec.program_update_date
,p_ass_attribute_category_o
=> per_asg_shd.g_old_rec.ass_attribute_category
,p_ass_attribute1_o
=> per_asg_shd.g_old_rec.ass_attribute1
,p_ass_attribute2_o
=> per_asg_shd.g_old_rec.ass_attribute2
,p_ass_attribute3_o
=> per_asg_shd.g_old_rec.ass_attribute3
,p_ass_attribute4_o
=> per_asg_shd.g_old_rec.ass_attribute4
,p_ass_attribute5_o
=> per_asg_shd.g_old_rec.ass_attribute5
,p_ass_attribute6_o
=> per_asg_shd.g_old_rec.ass_attribute6
,p_ass_attribute7_o
=> per_asg_shd.g_old_rec.ass_attribute7
,p_ass_attribute8_o
=> per_asg_shd.g_old_rec.ass_attribute8
,p_ass_attribute9_o
=> per_asg_shd.g_old_rec.ass_attribute9
,p_ass_attribute10_o
=> per_asg_shd.g_old_rec.ass_attribute10
,p_ass_attribute11_o
=> per_asg_shd.g_old_rec.ass_attribute11
,p_ass_attribute12_o
=> per_asg_shd.g_old_rec.ass_attribute12
,p_ass_attribute13_o
=> per_asg_shd.g_old_rec.ass_attribute13
,p_ass_attribute14_o
=> per_asg_shd.g_old_rec.ass_attribute14
,p_ass_attribute15_o
=> per_asg_shd.g_old_rec.ass_attribute15
,p_ass_attribute16_o
=> per_asg_shd.g_old_rec.ass_attribute16
,p_ass_attribute17_o
=> per_asg_shd.g_old_rec.ass_attribute17
,p_ass_attribute18_o
=> per_asg_shd.g_old_rec.ass_attribute18
,p_ass_attribute19_o
=> per_asg_shd.g_old_rec.ass_attribute19
,p_ass_attribute20_o
=> per_asg_shd.g_old_rec.ass_attribute20
,p_ass_attribute21_o
=> per_asg_shd.g_old_rec.ass_attribute21
,p_ass_attribute22_o
=> per_asg_shd.g_old_rec.ass_attribute22
,p_ass_attribute23_o
=> per_asg_shd.g_old_rec.ass_attribute23
,p_ass_attribute24_o
=> per_asg_shd.g_old_rec.ass_attribute24
,p_ass_attribute25_o
=> per_asg_shd.g_old_rec.ass_attribute25
,p_ass_attribute26_o
=> per_asg_shd.g_old_rec.ass_attribute26
,p_ass_attribute27_o
=> per_asg_shd.g_old_rec.ass_attribute27
,p_ass_attribute28_o
=> per_asg_shd.g_old_rec.ass_attribute28
,p_ass_attribute29_o
=> per_asg_shd.g_old_rec.ass_attribute29
,p_ass_attribute30_o
=> per_asg_shd.g_old_rec.ass_attribute30
,p_title_o
=> per_asg_shd.g_old_rec.title
,p_contract_id_o
=> per_asg_shd.g_old_rec.contract_id
,p_establishment_id_o
=> per_asg_shd.g_old_rec.establishment_id
,p_collective_agreement_id_o
=> per_asg_shd.g_old_rec.collective_agreement_id
,p_cagr_grade_def_id_o
=> per_asg_shd.g_old_rec.cagr_grade_def_id
,p_cagr_id_flex_num_o
=> per_asg_shd.g_old_rec.cagr_id_flex_num
,p_object_version_number_o
=> per_asg_shd.g_old_rec.object_version_number
,p_notice_period_o
=> per_asg_shd.g_old_rec.notice_period
,p_notice_period_uom_o
=> per_asg_shd.g_old_rec.notice_period_uom
,p_employee_category_o
=> per_asg_shd.g_old_rec.employee_category
,p_work_at_home_o
=> per_asg_shd.g_old_rec.work_at_home
,p_job_post_source_name_o
=> per_asg_shd.g_old_rec.job_post_source_name
,p_posting_content_id_o
=> per_asg_shd.g_old_rec.posting_content_id
,p_placement_date_start_o
=> per_asg_shd.g_old_rec.period_of_placement_date_start
,p_vendor_id_o
=> per_asg_shd.g_old_rec.vendor_id
,p_vendor_employee_number_o
=> per_asg_shd.g_old_rec.vendor_employee_number
,p_vendor_assignment_number_o
=> per_asg_shd.g_old_rec.vendor_assignment_number
,p_assignment_category_o
=> per_asg_shd.g_old_rec.assignment_category
,p_project_title_o
=> per_asg_shd.g_old_rec.project_title
,p_applicant_rank_o
=> per_asg_shd.g_old_rec.applicant_rank
,p_grade_ladder_pgm_id_o
=> per_asg_shd.g_old_rec.grade_ladder_pgm_id
,p_supervisor_assignment_id_o
=> per_asg_shd.g_old_rec.supervisor_assignment_id /*Bug 2976136*/
,p_vendor_site_id_o => per_asg_shd.g_old_rec.vendor_site_id
,p_po_header_id_o => per_asg_shd.g_old_rec.po_header_id
,p_po_line_id_o => per_asg_shd.g_old_rec.po_line_id
,p_projected_assignment_end_o => per_asg_shd.g_old_rec.projected_assignment_end
);
End post_update;
If (p_rec.program_update_date = hr_api.g_date) then
p_rec.program_update_date :=
per_asg_shd.g_old_rec.program_update_date;
p_payroll_id_updated out nocopy boolean,
p_other_manager_warning out nocopy boolean,
p_hourly_salaried_warning out nocopy boolean,
p_no_managers_warning out nocopy boolean,
p_org_now_no_manager_warning out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'upd';
l_payroll_id_updated boolean;
per_asg_bus1.update_validate
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date,
p_payroll_id_updated => l_payroll_id_updated,
p_other_manager_warning => p_other_manager_warning,
p_hourly_salaried_warning => p_hourly_salaried_warning,
p_no_managers_warning => p_no_managers_warning,
p_org_now_no_manager_warning => p_org_now_no_manager_warning,
p_inv_pos_grade_warning => l_inv_pos_grade_warning);
pre_update
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
update_dml
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date);
post_update
(p_rec => p_rec,
p_effective_date => p_effective_date,
p_datetrack_mode => p_datetrack_mode,
p_validation_start_date => l_validation_start_date,
p_validation_end_date => l_validation_end_date,
p_payroll_id_updated => l_payroll_id_updated,
p_other_manager_warning => l_other_manager_warning,
p_hourly_salaried_warning => l_hourly_salaried_warning,
p_no_managers_warning => l_no_managers_warning,
p_org_now_no_manager_warning => l_org_now_no_manager_warning);
p_payroll_id_updated := l_payroll_id_updated;
p_program_update_date in date default hr_api.g_date,
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_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_grade_def_id in number default hr_api.g_number,
p_cagr_id_flex_num in number default hr_api.g_number,
p_object_version_number in out nocopy number,
p_notice_period in number default hr_api.g_number,
p_notice_period_uom in varchar2 default hr_api.g_varchar2,
p_employee_category in varchar2 default hr_api.g_varchar2,
p_work_at_home in varchar2 default hr_api.g_varchar2,
p_job_post_source_name in varchar2 default hr_api.g_varchar2,
p_posting_content_id in number default hr_api.g_number,
p_placement_date_start in date default hr_api.g_date,
p_vendor_id in number default hr_api.g_number,
p_vendor_employee_number in varchar2 default hr_api.g_varchar2,
p_vendor_assignment_number in varchar2 default hr_api.g_varchar2,
p_assignment_category in varchar2 default hr_api.g_varchar2,
p_project_title in varchar2 default hr_api.g_varchar2,
p_applicant_rank in number default hr_api.g_number,
p_payroll_id_updated out nocopy boolean,
p_other_manager_warning out nocopy boolean,
p_hourly_salaried_warning out nocopy boolean,
p_no_managers_warning out nocopy boolean,
p_org_now_no_manager_warning out nocopy boolean,
p_validation_start_date out nocopy date,
p_validation_end_date out nocopy date,
p_effective_date in date,
p_datetrack_mode in varchar2,
p_validate in boolean default false
) is
--
l_rec per_asg_shd.g_rec_type;
p_program_update_date,
p_ass_attribute_category,
p_ass_attribute1,
p_ass_attribute2,
p_ass_attribute3,
p_ass_attribute4,
p_ass_attribute5,
p_ass_attribute6,
p_ass_attribute7,
p_ass_attribute8,
p_ass_attribute9,
p_ass_attribute10,
p_ass_attribute11,
p_ass_attribute12,
p_ass_attribute13,
p_ass_attribute14,
p_ass_attribute15,
p_ass_attribute16,
p_ass_attribute17,
p_ass_attribute18,
p_ass_attribute19,
p_ass_attribute20,
p_ass_attribute21,
p_ass_attribute22,
p_ass_attribute23,
p_ass_attribute24,
p_ass_attribute25,
p_ass_attribute26,
p_ass_attribute27,
p_ass_attribute28,
p_ass_attribute29,
p_ass_attribute30,
p_title,
p_object_version_number,
p_contract_id,
p_establishment_id,
p_collective_agreement_id,
p_cagr_grade_def_id,
p_cagr_id_flex_num,
p_notice_period,
p_notice_period_uom,
p_employee_category,
p_work_at_home,
p_job_post_source_name,
p_posting_content_id,
p_placement_date_start,
p_vendor_id,
p_vendor_employee_number,
p_vendor_assignment_number,
p_assignment_category,
p_project_title,
p_applicant_rank,
null,
null, /*Bug 2976136*/
null, --- p_vendor_site_id
null, --- p_po_header_id
null, --- p_po_line_id
null --- p_projected_assignment_end
);
p_payroll_id_updated,
p_other_manager_warning,
p_hourly_salaried_warning,
p_no_managers_warning,
p_org_now_no_manager_warning);