[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy per_asg_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is
80: (p_base_table_name => 'per_all_assignments_f',
81: p_base_key_column => 'assignment_id',
82: p_base_key_value => p_rec.assignment_id);
83: --
84: per_asg_shd.g_api_dml := true; -- Set the api dml status
85: --
86: -- Update the per_all_assignments_f Row
87: --
88: update per_all_assignments_f
195: and effective_end_date = p_validation_end_date;
196: --
197:
198: -- Start of fix 518655
199: if nvl(per_asg_shd.g_old_rec.assignment_number, hr_api.g_varchar2) <>
200: nvl(p_rec.assignment_number, hr_api.g_varchar2) then
201: --
202: l_object_version_number := dt_api.get_object_version_number
203: (p_base_table_name => 'per_all_assignments_f',
207: update per_all_assignments_f paaf
208: set paaf.assignment_number = p_rec.assignment_number,
209: paaf.object_version_number = l_object_version_number
210: where paaf.assignment_id = p_rec.assignment_id
211: and paaf.person_id = per_asg_shd.g_old_rec.person_id
212: and (paaf.effective_start_date < p_validation_start_date
213: or paaf.effective_end_date > p_validation_end_date);
214: --
215: end if;
214: --
215: end if;
216: -- End of fix 518655
217:
218: per_asg_shd.g_api_dml := false; -- Unset the api dml status
219: --
220: -- Set the effective start and end dates
221: --
222: p_rec.effective_start_date := p_validation_start_date;
226: hr_utility.set_location(' Leaving:'||l_proc, 15);
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: per_asg_shd.g_api_dml := false; -- Unset the api dml status
231: per_asg_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
227: Exception
228: When hr_api.check_integrity_violated Then
229: -- A check constraint has been violated
230: per_asg_shd.g_api_dml := false; -- Unset the api dml status
231: per_asg_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: per_asg_shd.g_api_dml := false; -- Unset the api dml status
231: per_asg_shd.constraint_error
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: per_asg_shd.g_api_dml := false; -- Unset the api dml status
236: per_asg_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When Others Then
239: per_asg_shd.g_api_dml := false; -- Unset the api dml status
232: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
233: When hr_api.unique_integrity_violated Then
234: -- Unique integrity has been violated
235: per_asg_shd.g_api_dml := false; -- Unset the api dml status
236: per_asg_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When Others Then
239: per_asg_shd.g_api_dml := false; -- Unset the api dml status
240: Raise;
235: per_asg_shd.g_api_dml := false; -- Unset the api dml status
236: per_asg_shd.constraint_error
237: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
238: When Others Then
239: per_asg_shd.g_api_dml := false; -- Unset the api dml status
240: Raise;
241: End dt_update_dml;
242: --
243: -- ----------------------------------------------------------------------------
271: --
272: -- {End Of Comments}
273: -- ----------------------------------------------------------------------------
274: Procedure update_dml
275: (p_rec in out nocopy per_asg_shd.g_rec_type,
276: p_effective_date in date,
277: p_datetrack_mode in varchar2,
278: p_validation_start_date in date,
279: p_validation_end_date in date) is
335: --
336: -- {End Of Comments}
337: -- ----------------------------------------------------------------------------
338: Procedure dt_pre_update
339: (p_rec in out nocopy per_asg_shd.g_rec_type,
340: p_effective_date in date,
341: p_datetrack_mode in varchar2,
342: p_validation_start_date in date,
343: p_validation_end_date in date) is
351: hr_utility.set_location(l_proc, 10);
352: --
353: -- Update the current effective end date
354: --
355: per_asg_shd.upd_effective_end_date
356: (p_effective_date => p_effective_date,
357: p_base_key_value => p_rec.assignment_id,
358: p_new_effective_end_date => (p_validation_start_date - 1),
359: p_validation_start_date => p_validation_start_date,
420: --
421: -- {End Of Comments}
422: -- ----------------------------------------------------------------------------
423: Procedure pre_update
424: (p_rec in out nocopy per_asg_shd.g_rec_type,
425: p_effective_date in date,
426: p_datetrack_mode in varchar2,
427: p_validation_start_date in date,
428: p_validation_end_date in date) is
456: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
457: p_comment_text => p_rec.comment_text);
458: -- Update the comments if they have changed
459: ElsIf (p_rec.comment_id is not null and p_rec.comment_text <>
460: per_asg_shd.g_old_rec.comment_text) then
461: hr_comm_api.upd(p_comment_id => p_rec.comment_id,
462: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
463: p_comment_text => p_rec.comment_text);
464: End If;
501: -- Desc: Call the BEN proc for change log event.
502: if p_datetrack_mode <> 'CORRECTION' then
503: ben_ext_chlg.log_asg_chg
504: (p_event => 'UPDATE',
505: p_old_rec => per_asg_shd.g_old_rec,
506: p_new_rec => p_rec
507: );
508: end if;
509: -- Bug 9092938 Ends
617: --
618: -- {End Of Comments}
619: -- ----------------------------------------------------------------------------
620: Procedure post_update
621: (p_rec in per_asg_shd.g_rec_type,
622: p_old_rec in per_asg_shd.g_rec_type, -- Added for bug 13059935
623: p_old_rowid in rowid, -- Added for bug 13059935
624: p_effective_date in date,
625: p_datetrack_mode in varchar2,
618: -- {End Of Comments}
619: -- ----------------------------------------------------------------------------
620: Procedure post_update
621: (p_rec in per_asg_shd.g_rec_type,
622: p_old_rec in per_asg_shd.g_rec_type, -- Added for bug 13059935
623: p_old_rowid in rowid, -- Added for bug 13059935
624: p_effective_date in date,
625: p_datetrack_mode in varchar2,
626: p_validation_start_date in date,
821: ,p_po_header_id => p_rec.po_header_id
822: ,p_po_line_id => p_rec.po_line_id
823: ,p_projected_assignment_end => p_rec.projected_assignment_end
824: ,p_effective_start_date_o
825: => per_asg_shd.g_old_rec.effective_start_date
826: ,p_effective_end_date_o
827: => per_asg_shd.g_old_rec.effective_end_date
828: ,p_business_group_id_o
829: => per_asg_shd.g_old_rec.business_group_id
823: ,p_projected_assignment_end => p_rec.projected_assignment_end
824: ,p_effective_start_date_o
825: => per_asg_shd.g_old_rec.effective_start_date
826: ,p_effective_end_date_o
827: => per_asg_shd.g_old_rec.effective_end_date
828: ,p_business_group_id_o
829: => per_asg_shd.g_old_rec.business_group_id
830: ,p_recruiter_id_o
831: => per_asg_shd.g_old_rec.recruiter_id
825: => per_asg_shd.g_old_rec.effective_start_date
826: ,p_effective_end_date_o
827: => per_asg_shd.g_old_rec.effective_end_date
828: ,p_business_group_id_o
829: => per_asg_shd.g_old_rec.business_group_id
830: ,p_recruiter_id_o
831: => per_asg_shd.g_old_rec.recruiter_id
832: ,p_grade_id_o
833: => per_asg_shd.g_old_rec.grade_id
827: => per_asg_shd.g_old_rec.effective_end_date
828: ,p_business_group_id_o
829: => per_asg_shd.g_old_rec.business_group_id
830: ,p_recruiter_id_o
831: => per_asg_shd.g_old_rec.recruiter_id
832: ,p_grade_id_o
833: => per_asg_shd.g_old_rec.grade_id
834: ,p_position_id_o
835: => per_asg_shd.g_old_rec.position_id
829: => per_asg_shd.g_old_rec.business_group_id
830: ,p_recruiter_id_o
831: => per_asg_shd.g_old_rec.recruiter_id
832: ,p_grade_id_o
833: => per_asg_shd.g_old_rec.grade_id
834: ,p_position_id_o
835: => per_asg_shd.g_old_rec.position_id
836: ,p_job_id_o
837: => per_asg_shd.g_old_rec.job_id
831: => per_asg_shd.g_old_rec.recruiter_id
832: ,p_grade_id_o
833: => per_asg_shd.g_old_rec.grade_id
834: ,p_position_id_o
835: => per_asg_shd.g_old_rec.position_id
836: ,p_job_id_o
837: => per_asg_shd.g_old_rec.job_id
838: ,p_assignment_status_type_id_o
839: => per_asg_shd.g_old_rec.assignment_status_type_id
833: => per_asg_shd.g_old_rec.grade_id
834: ,p_position_id_o
835: => per_asg_shd.g_old_rec.position_id
836: ,p_job_id_o
837: => per_asg_shd.g_old_rec.job_id
838: ,p_assignment_status_type_id_o
839: => per_asg_shd.g_old_rec.assignment_status_type_id
840: ,p_payroll_id_o
841: => per_asg_shd.g_old_rec.payroll_id
835: => per_asg_shd.g_old_rec.position_id
836: ,p_job_id_o
837: => per_asg_shd.g_old_rec.job_id
838: ,p_assignment_status_type_id_o
839: => per_asg_shd.g_old_rec.assignment_status_type_id
840: ,p_payroll_id_o
841: => per_asg_shd.g_old_rec.payroll_id
842: ,p_location_id_o
843: => per_asg_shd.g_old_rec.location_id
837: => per_asg_shd.g_old_rec.job_id
838: ,p_assignment_status_type_id_o
839: => per_asg_shd.g_old_rec.assignment_status_type_id
840: ,p_payroll_id_o
841: => per_asg_shd.g_old_rec.payroll_id
842: ,p_location_id_o
843: => per_asg_shd.g_old_rec.location_id
844: ,p_person_referred_by_id_o
845: => per_asg_shd.g_old_rec.person_referred_by_id
839: => per_asg_shd.g_old_rec.assignment_status_type_id
840: ,p_payroll_id_o
841: => per_asg_shd.g_old_rec.payroll_id
842: ,p_location_id_o
843: => per_asg_shd.g_old_rec.location_id
844: ,p_person_referred_by_id_o
845: => per_asg_shd.g_old_rec.person_referred_by_id
846: ,p_supervisor_id_o
847: => per_asg_shd.g_old_rec.supervisor_id
841: => per_asg_shd.g_old_rec.payroll_id
842: ,p_location_id_o
843: => per_asg_shd.g_old_rec.location_id
844: ,p_person_referred_by_id_o
845: => per_asg_shd.g_old_rec.person_referred_by_id
846: ,p_supervisor_id_o
847: => per_asg_shd.g_old_rec.supervisor_id
848: ,p_special_ceiling_step_id_o
849: => per_asg_shd.g_old_rec.special_ceiling_step_id
843: => per_asg_shd.g_old_rec.location_id
844: ,p_person_referred_by_id_o
845: => per_asg_shd.g_old_rec.person_referred_by_id
846: ,p_supervisor_id_o
847: => per_asg_shd.g_old_rec.supervisor_id
848: ,p_special_ceiling_step_id_o
849: => per_asg_shd.g_old_rec.special_ceiling_step_id
850: ,p_person_id_o
851: => per_asg_shd.g_old_rec.person_id
845: => per_asg_shd.g_old_rec.person_referred_by_id
846: ,p_supervisor_id_o
847: => per_asg_shd.g_old_rec.supervisor_id
848: ,p_special_ceiling_step_id_o
849: => per_asg_shd.g_old_rec.special_ceiling_step_id
850: ,p_person_id_o
851: => per_asg_shd.g_old_rec.person_id
852: ,p_recruitment_activity_id_o
853: => per_asg_shd.g_old_rec.recruitment_activity_id
847: => per_asg_shd.g_old_rec.supervisor_id
848: ,p_special_ceiling_step_id_o
849: => per_asg_shd.g_old_rec.special_ceiling_step_id
850: ,p_person_id_o
851: => per_asg_shd.g_old_rec.person_id
852: ,p_recruitment_activity_id_o
853: => per_asg_shd.g_old_rec.recruitment_activity_id
854: ,p_source_organization_id_o
855: => per_asg_shd.g_old_rec.source_organization_id
849: => per_asg_shd.g_old_rec.special_ceiling_step_id
850: ,p_person_id_o
851: => per_asg_shd.g_old_rec.person_id
852: ,p_recruitment_activity_id_o
853: => per_asg_shd.g_old_rec.recruitment_activity_id
854: ,p_source_organization_id_o
855: => per_asg_shd.g_old_rec.source_organization_id
856: ,p_organization_id_o
857: => per_asg_shd.g_old_rec.organization_id
851: => per_asg_shd.g_old_rec.person_id
852: ,p_recruitment_activity_id_o
853: => per_asg_shd.g_old_rec.recruitment_activity_id
854: ,p_source_organization_id_o
855: => per_asg_shd.g_old_rec.source_organization_id
856: ,p_organization_id_o
857: => per_asg_shd.g_old_rec.organization_id
858: ,p_people_group_id_o
859: => per_asg_shd.g_old_rec.people_group_id
853: => per_asg_shd.g_old_rec.recruitment_activity_id
854: ,p_source_organization_id_o
855: => per_asg_shd.g_old_rec.source_organization_id
856: ,p_organization_id_o
857: => per_asg_shd.g_old_rec.organization_id
858: ,p_people_group_id_o
859: => per_asg_shd.g_old_rec.people_group_id
860: ,p_soft_coding_keyflex_id_o
861: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
855: => per_asg_shd.g_old_rec.source_organization_id
856: ,p_organization_id_o
857: => per_asg_shd.g_old_rec.organization_id
858: ,p_people_group_id_o
859: => per_asg_shd.g_old_rec.people_group_id
860: ,p_soft_coding_keyflex_id_o
861: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
862: ,p_vacancy_id_o
863: => per_asg_shd.g_old_rec.vacancy_id
857: => per_asg_shd.g_old_rec.organization_id
858: ,p_people_group_id_o
859: => per_asg_shd.g_old_rec.people_group_id
860: ,p_soft_coding_keyflex_id_o
861: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
862: ,p_vacancy_id_o
863: => per_asg_shd.g_old_rec.vacancy_id
864: ,p_assignment_sequence_o
865: => per_asg_shd.g_old_rec.assignment_sequence
859: => per_asg_shd.g_old_rec.people_group_id
860: ,p_soft_coding_keyflex_id_o
861: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
862: ,p_vacancy_id_o
863: => per_asg_shd.g_old_rec.vacancy_id
864: ,p_assignment_sequence_o
865: => per_asg_shd.g_old_rec.assignment_sequence
866: ,p_pay_basis_id_o
867: => per_asg_shd.g_old_rec.pay_basis_id
861: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
862: ,p_vacancy_id_o
863: => per_asg_shd.g_old_rec.vacancy_id
864: ,p_assignment_sequence_o
865: => per_asg_shd.g_old_rec.assignment_sequence
866: ,p_pay_basis_id_o
867: => per_asg_shd.g_old_rec.pay_basis_id
868: ,p_assignment_type_o
869: => per_asg_shd.g_old_rec.assignment_type
863: => per_asg_shd.g_old_rec.vacancy_id
864: ,p_assignment_sequence_o
865: => per_asg_shd.g_old_rec.assignment_sequence
866: ,p_pay_basis_id_o
867: => per_asg_shd.g_old_rec.pay_basis_id
868: ,p_assignment_type_o
869: => per_asg_shd.g_old_rec.assignment_type
870: ,p_primary_flag_o
871: => per_asg_shd.g_old_rec.primary_flag
865: => per_asg_shd.g_old_rec.assignment_sequence
866: ,p_pay_basis_id_o
867: => per_asg_shd.g_old_rec.pay_basis_id
868: ,p_assignment_type_o
869: => per_asg_shd.g_old_rec.assignment_type
870: ,p_primary_flag_o
871: => per_asg_shd.g_old_rec.primary_flag
872: ,p_application_id_o
873: => per_asg_shd.g_old_rec.application_id
867: => per_asg_shd.g_old_rec.pay_basis_id
868: ,p_assignment_type_o
869: => per_asg_shd.g_old_rec.assignment_type
870: ,p_primary_flag_o
871: => per_asg_shd.g_old_rec.primary_flag
872: ,p_application_id_o
873: => per_asg_shd.g_old_rec.application_id
874: ,p_assignment_number_o
875: => per_asg_shd.g_old_rec.assignment_number
869: => per_asg_shd.g_old_rec.assignment_type
870: ,p_primary_flag_o
871: => per_asg_shd.g_old_rec.primary_flag
872: ,p_application_id_o
873: => per_asg_shd.g_old_rec.application_id
874: ,p_assignment_number_o
875: => per_asg_shd.g_old_rec.assignment_number
876: ,p_change_reason_o
877: => per_asg_shd.g_old_rec.change_reason
871: => per_asg_shd.g_old_rec.primary_flag
872: ,p_application_id_o
873: => per_asg_shd.g_old_rec.application_id
874: ,p_assignment_number_o
875: => per_asg_shd.g_old_rec.assignment_number
876: ,p_change_reason_o
877: => per_asg_shd.g_old_rec.change_reason
878: ,p_comment_id_o
879: => per_asg_shd.g_old_rec.comment_id
873: => per_asg_shd.g_old_rec.application_id
874: ,p_assignment_number_o
875: => per_asg_shd.g_old_rec.assignment_number
876: ,p_change_reason_o
877: => per_asg_shd.g_old_rec.change_reason
878: ,p_comment_id_o
879: => per_asg_shd.g_old_rec.comment_id
880: ,p_date_probation_end_o
881: => per_asg_shd.g_old_rec.date_probation_end
875: => per_asg_shd.g_old_rec.assignment_number
876: ,p_change_reason_o
877: => per_asg_shd.g_old_rec.change_reason
878: ,p_comment_id_o
879: => per_asg_shd.g_old_rec.comment_id
880: ,p_date_probation_end_o
881: => per_asg_shd.g_old_rec.date_probation_end
882: ,p_default_code_comb_id_o
883: => per_asg_shd.g_old_rec.default_code_comb_id
877: => per_asg_shd.g_old_rec.change_reason
878: ,p_comment_id_o
879: => per_asg_shd.g_old_rec.comment_id
880: ,p_date_probation_end_o
881: => per_asg_shd.g_old_rec.date_probation_end
882: ,p_default_code_comb_id_o
883: => per_asg_shd.g_old_rec.default_code_comb_id
884: ,p_employment_category_o
885: => per_asg_shd.g_old_rec.employment_category
879: => per_asg_shd.g_old_rec.comment_id
880: ,p_date_probation_end_o
881: => per_asg_shd.g_old_rec.date_probation_end
882: ,p_default_code_comb_id_o
883: => per_asg_shd.g_old_rec.default_code_comb_id
884: ,p_employment_category_o
885: => per_asg_shd.g_old_rec.employment_category
886: ,p_frequency_o
887: => per_asg_shd.g_old_rec.frequency
881: => per_asg_shd.g_old_rec.date_probation_end
882: ,p_default_code_comb_id_o
883: => per_asg_shd.g_old_rec.default_code_comb_id
884: ,p_employment_category_o
885: => per_asg_shd.g_old_rec.employment_category
886: ,p_frequency_o
887: => per_asg_shd.g_old_rec.frequency
888: ,p_internal_address_line_o
889: => per_asg_shd.g_old_rec.internal_address_line
883: => per_asg_shd.g_old_rec.default_code_comb_id
884: ,p_employment_category_o
885: => per_asg_shd.g_old_rec.employment_category
886: ,p_frequency_o
887: => per_asg_shd.g_old_rec.frequency
888: ,p_internal_address_line_o
889: => per_asg_shd.g_old_rec.internal_address_line
890: ,p_manager_flag_o
891: => per_asg_shd.g_old_rec.manager_flag
885: => per_asg_shd.g_old_rec.employment_category
886: ,p_frequency_o
887: => per_asg_shd.g_old_rec.frequency
888: ,p_internal_address_line_o
889: => per_asg_shd.g_old_rec.internal_address_line
890: ,p_manager_flag_o
891: => per_asg_shd.g_old_rec.manager_flag
892: ,p_normal_hours_o
893: => per_asg_shd.g_old_rec.normal_hours
887: => per_asg_shd.g_old_rec.frequency
888: ,p_internal_address_line_o
889: => per_asg_shd.g_old_rec.internal_address_line
890: ,p_manager_flag_o
891: => per_asg_shd.g_old_rec.manager_flag
892: ,p_normal_hours_o
893: => per_asg_shd.g_old_rec.normal_hours
894: ,p_perf_review_period_o
895: => per_asg_shd.g_old_rec.perf_review_period
889: => per_asg_shd.g_old_rec.internal_address_line
890: ,p_manager_flag_o
891: => per_asg_shd.g_old_rec.manager_flag
892: ,p_normal_hours_o
893: => per_asg_shd.g_old_rec.normal_hours
894: ,p_perf_review_period_o
895: => per_asg_shd.g_old_rec.perf_review_period
896: ,p_perf_review_period_frequen_o
897: => per_asg_shd.g_old_rec.perf_review_period_frequency
891: => per_asg_shd.g_old_rec.manager_flag
892: ,p_normal_hours_o
893: => per_asg_shd.g_old_rec.normal_hours
894: ,p_perf_review_period_o
895: => per_asg_shd.g_old_rec.perf_review_period
896: ,p_perf_review_period_frequen_o
897: => per_asg_shd.g_old_rec.perf_review_period_frequency
898: ,p_period_of_service_id_o
899: => per_asg_shd.g_old_rec.period_of_service_id
893: => per_asg_shd.g_old_rec.normal_hours
894: ,p_perf_review_period_o
895: => per_asg_shd.g_old_rec.perf_review_period
896: ,p_perf_review_period_frequen_o
897: => per_asg_shd.g_old_rec.perf_review_period_frequency
898: ,p_period_of_service_id_o
899: => per_asg_shd.g_old_rec.period_of_service_id
900: ,p_probation_period_o
901: => per_asg_shd.g_old_rec.probation_period
895: => per_asg_shd.g_old_rec.perf_review_period
896: ,p_perf_review_period_frequen_o
897: => per_asg_shd.g_old_rec.perf_review_period_frequency
898: ,p_period_of_service_id_o
899: => per_asg_shd.g_old_rec.period_of_service_id
900: ,p_probation_period_o
901: => per_asg_shd.g_old_rec.probation_period
902: ,p_probation_unit_o
903: => per_asg_shd.g_old_rec.probation_unit
897: => per_asg_shd.g_old_rec.perf_review_period_frequency
898: ,p_period_of_service_id_o
899: => per_asg_shd.g_old_rec.period_of_service_id
900: ,p_probation_period_o
901: => per_asg_shd.g_old_rec.probation_period
902: ,p_probation_unit_o
903: => per_asg_shd.g_old_rec.probation_unit
904: ,p_sal_review_period_o
905: => per_asg_shd.g_old_rec.sal_review_period
899: => per_asg_shd.g_old_rec.period_of_service_id
900: ,p_probation_period_o
901: => per_asg_shd.g_old_rec.probation_period
902: ,p_probation_unit_o
903: => per_asg_shd.g_old_rec.probation_unit
904: ,p_sal_review_period_o
905: => per_asg_shd.g_old_rec.sal_review_period
906: ,p_sal_review_period_frequen_o
907: => per_asg_shd.g_old_rec.sal_review_period_frequency
901: => per_asg_shd.g_old_rec.probation_period
902: ,p_probation_unit_o
903: => per_asg_shd.g_old_rec.probation_unit
904: ,p_sal_review_period_o
905: => per_asg_shd.g_old_rec.sal_review_period
906: ,p_sal_review_period_frequen_o
907: => per_asg_shd.g_old_rec.sal_review_period_frequency
908: ,p_set_of_books_id_o
909: => per_asg_shd.g_old_rec.set_of_books_id
903: => per_asg_shd.g_old_rec.probation_unit
904: ,p_sal_review_period_o
905: => per_asg_shd.g_old_rec.sal_review_period
906: ,p_sal_review_period_frequen_o
907: => per_asg_shd.g_old_rec.sal_review_period_frequency
908: ,p_set_of_books_id_o
909: => per_asg_shd.g_old_rec.set_of_books_id
910: ,p_source_type_o
911: => per_asg_shd.g_old_rec.source_type
905: => per_asg_shd.g_old_rec.sal_review_period
906: ,p_sal_review_period_frequen_o
907: => per_asg_shd.g_old_rec.sal_review_period_frequency
908: ,p_set_of_books_id_o
909: => per_asg_shd.g_old_rec.set_of_books_id
910: ,p_source_type_o
911: => per_asg_shd.g_old_rec.source_type
912: ,p_time_normal_finish_o
913: => per_asg_shd.g_old_rec.time_normal_finish
907: => per_asg_shd.g_old_rec.sal_review_period_frequency
908: ,p_set_of_books_id_o
909: => per_asg_shd.g_old_rec.set_of_books_id
910: ,p_source_type_o
911: => per_asg_shd.g_old_rec.source_type
912: ,p_time_normal_finish_o
913: => per_asg_shd.g_old_rec.time_normal_finish
914: ,p_time_normal_start_o
915: => per_asg_shd.g_old_rec.time_normal_start
909: => per_asg_shd.g_old_rec.set_of_books_id
910: ,p_source_type_o
911: => per_asg_shd.g_old_rec.source_type
912: ,p_time_normal_finish_o
913: => per_asg_shd.g_old_rec.time_normal_finish
914: ,p_time_normal_start_o
915: => per_asg_shd.g_old_rec.time_normal_start
916: ,p_bargaining_unit_code_o
917: => per_asg_shd.g_old_rec.bargaining_unit_code
911: => per_asg_shd.g_old_rec.source_type
912: ,p_time_normal_finish_o
913: => per_asg_shd.g_old_rec.time_normal_finish
914: ,p_time_normal_start_o
915: => per_asg_shd.g_old_rec.time_normal_start
916: ,p_bargaining_unit_code_o
917: => per_asg_shd.g_old_rec.bargaining_unit_code
918: ,p_labour_union_member_flag_o
919: => per_asg_shd.g_old_rec.labour_union_member_flag
913: => per_asg_shd.g_old_rec.time_normal_finish
914: ,p_time_normal_start_o
915: => per_asg_shd.g_old_rec.time_normal_start
916: ,p_bargaining_unit_code_o
917: => per_asg_shd.g_old_rec.bargaining_unit_code
918: ,p_labour_union_member_flag_o
919: => per_asg_shd.g_old_rec.labour_union_member_flag
920: ,p_hourly_salaried_code_o
921: => per_asg_shd.g_old_rec.hourly_salaried_code
915: => per_asg_shd.g_old_rec.time_normal_start
916: ,p_bargaining_unit_code_o
917: => per_asg_shd.g_old_rec.bargaining_unit_code
918: ,p_labour_union_member_flag_o
919: => per_asg_shd.g_old_rec.labour_union_member_flag
920: ,p_hourly_salaried_code_o
921: => per_asg_shd.g_old_rec.hourly_salaried_code
922: ,p_request_id_o
923: => per_asg_shd.g_old_rec.request_id
917: => per_asg_shd.g_old_rec.bargaining_unit_code
918: ,p_labour_union_member_flag_o
919: => per_asg_shd.g_old_rec.labour_union_member_flag
920: ,p_hourly_salaried_code_o
921: => per_asg_shd.g_old_rec.hourly_salaried_code
922: ,p_request_id_o
923: => per_asg_shd.g_old_rec.request_id
924: ,p_program_application_id_o
925: => per_asg_shd.g_old_rec.program_application_id
919: => per_asg_shd.g_old_rec.labour_union_member_flag
920: ,p_hourly_salaried_code_o
921: => per_asg_shd.g_old_rec.hourly_salaried_code
922: ,p_request_id_o
923: => per_asg_shd.g_old_rec.request_id
924: ,p_program_application_id_o
925: => per_asg_shd.g_old_rec.program_application_id
926: ,p_program_id_o
927: => per_asg_shd.g_old_rec.program_id
921: => per_asg_shd.g_old_rec.hourly_salaried_code
922: ,p_request_id_o
923: => per_asg_shd.g_old_rec.request_id
924: ,p_program_application_id_o
925: => per_asg_shd.g_old_rec.program_application_id
926: ,p_program_id_o
927: => per_asg_shd.g_old_rec.program_id
928: ,p_program_update_date_o
929: => per_asg_shd.g_old_rec.program_update_date
923: => per_asg_shd.g_old_rec.request_id
924: ,p_program_application_id_o
925: => per_asg_shd.g_old_rec.program_application_id
926: ,p_program_id_o
927: => per_asg_shd.g_old_rec.program_id
928: ,p_program_update_date_o
929: => per_asg_shd.g_old_rec.program_update_date
930: ,p_ass_attribute_category_o
931: => per_asg_shd.g_old_rec.ass_attribute_category
925: => per_asg_shd.g_old_rec.program_application_id
926: ,p_program_id_o
927: => per_asg_shd.g_old_rec.program_id
928: ,p_program_update_date_o
929: => per_asg_shd.g_old_rec.program_update_date
930: ,p_ass_attribute_category_o
931: => per_asg_shd.g_old_rec.ass_attribute_category
932: ,p_ass_attribute1_o
933: => per_asg_shd.g_old_rec.ass_attribute1
927: => per_asg_shd.g_old_rec.program_id
928: ,p_program_update_date_o
929: => per_asg_shd.g_old_rec.program_update_date
930: ,p_ass_attribute_category_o
931: => per_asg_shd.g_old_rec.ass_attribute_category
932: ,p_ass_attribute1_o
933: => per_asg_shd.g_old_rec.ass_attribute1
934: ,p_ass_attribute2_o
935: => per_asg_shd.g_old_rec.ass_attribute2
929: => per_asg_shd.g_old_rec.program_update_date
930: ,p_ass_attribute_category_o
931: => per_asg_shd.g_old_rec.ass_attribute_category
932: ,p_ass_attribute1_o
933: => per_asg_shd.g_old_rec.ass_attribute1
934: ,p_ass_attribute2_o
935: => per_asg_shd.g_old_rec.ass_attribute2
936: ,p_ass_attribute3_o
937: => per_asg_shd.g_old_rec.ass_attribute3
931: => per_asg_shd.g_old_rec.ass_attribute_category
932: ,p_ass_attribute1_o
933: => per_asg_shd.g_old_rec.ass_attribute1
934: ,p_ass_attribute2_o
935: => per_asg_shd.g_old_rec.ass_attribute2
936: ,p_ass_attribute3_o
937: => per_asg_shd.g_old_rec.ass_attribute3
938: ,p_ass_attribute4_o
939: => per_asg_shd.g_old_rec.ass_attribute4
933: => per_asg_shd.g_old_rec.ass_attribute1
934: ,p_ass_attribute2_o
935: => per_asg_shd.g_old_rec.ass_attribute2
936: ,p_ass_attribute3_o
937: => per_asg_shd.g_old_rec.ass_attribute3
938: ,p_ass_attribute4_o
939: => per_asg_shd.g_old_rec.ass_attribute4
940: ,p_ass_attribute5_o
941: => per_asg_shd.g_old_rec.ass_attribute5
935: => per_asg_shd.g_old_rec.ass_attribute2
936: ,p_ass_attribute3_o
937: => per_asg_shd.g_old_rec.ass_attribute3
938: ,p_ass_attribute4_o
939: => per_asg_shd.g_old_rec.ass_attribute4
940: ,p_ass_attribute5_o
941: => per_asg_shd.g_old_rec.ass_attribute5
942: ,p_ass_attribute6_o
943: => per_asg_shd.g_old_rec.ass_attribute6
937: => per_asg_shd.g_old_rec.ass_attribute3
938: ,p_ass_attribute4_o
939: => per_asg_shd.g_old_rec.ass_attribute4
940: ,p_ass_attribute5_o
941: => per_asg_shd.g_old_rec.ass_attribute5
942: ,p_ass_attribute6_o
943: => per_asg_shd.g_old_rec.ass_attribute6
944: ,p_ass_attribute7_o
945: => per_asg_shd.g_old_rec.ass_attribute7
939: => per_asg_shd.g_old_rec.ass_attribute4
940: ,p_ass_attribute5_o
941: => per_asg_shd.g_old_rec.ass_attribute5
942: ,p_ass_attribute6_o
943: => per_asg_shd.g_old_rec.ass_attribute6
944: ,p_ass_attribute7_o
945: => per_asg_shd.g_old_rec.ass_attribute7
946: ,p_ass_attribute8_o
947: => per_asg_shd.g_old_rec.ass_attribute8
941: => per_asg_shd.g_old_rec.ass_attribute5
942: ,p_ass_attribute6_o
943: => per_asg_shd.g_old_rec.ass_attribute6
944: ,p_ass_attribute7_o
945: => per_asg_shd.g_old_rec.ass_attribute7
946: ,p_ass_attribute8_o
947: => per_asg_shd.g_old_rec.ass_attribute8
948: ,p_ass_attribute9_o
949: => per_asg_shd.g_old_rec.ass_attribute9
943: => per_asg_shd.g_old_rec.ass_attribute6
944: ,p_ass_attribute7_o
945: => per_asg_shd.g_old_rec.ass_attribute7
946: ,p_ass_attribute8_o
947: => per_asg_shd.g_old_rec.ass_attribute8
948: ,p_ass_attribute9_o
949: => per_asg_shd.g_old_rec.ass_attribute9
950: ,p_ass_attribute10_o
951: => per_asg_shd.g_old_rec.ass_attribute10
945: => per_asg_shd.g_old_rec.ass_attribute7
946: ,p_ass_attribute8_o
947: => per_asg_shd.g_old_rec.ass_attribute8
948: ,p_ass_attribute9_o
949: => per_asg_shd.g_old_rec.ass_attribute9
950: ,p_ass_attribute10_o
951: => per_asg_shd.g_old_rec.ass_attribute10
952: ,p_ass_attribute11_o
953: => per_asg_shd.g_old_rec.ass_attribute11
947: => per_asg_shd.g_old_rec.ass_attribute8
948: ,p_ass_attribute9_o
949: => per_asg_shd.g_old_rec.ass_attribute9
950: ,p_ass_attribute10_o
951: => per_asg_shd.g_old_rec.ass_attribute10
952: ,p_ass_attribute11_o
953: => per_asg_shd.g_old_rec.ass_attribute11
954: ,p_ass_attribute12_o
955: => per_asg_shd.g_old_rec.ass_attribute12
949: => per_asg_shd.g_old_rec.ass_attribute9
950: ,p_ass_attribute10_o
951: => per_asg_shd.g_old_rec.ass_attribute10
952: ,p_ass_attribute11_o
953: => per_asg_shd.g_old_rec.ass_attribute11
954: ,p_ass_attribute12_o
955: => per_asg_shd.g_old_rec.ass_attribute12
956: ,p_ass_attribute13_o
957: => per_asg_shd.g_old_rec.ass_attribute13
951: => per_asg_shd.g_old_rec.ass_attribute10
952: ,p_ass_attribute11_o
953: => per_asg_shd.g_old_rec.ass_attribute11
954: ,p_ass_attribute12_o
955: => per_asg_shd.g_old_rec.ass_attribute12
956: ,p_ass_attribute13_o
957: => per_asg_shd.g_old_rec.ass_attribute13
958: ,p_ass_attribute14_o
959: => per_asg_shd.g_old_rec.ass_attribute14
953: => per_asg_shd.g_old_rec.ass_attribute11
954: ,p_ass_attribute12_o
955: => per_asg_shd.g_old_rec.ass_attribute12
956: ,p_ass_attribute13_o
957: => per_asg_shd.g_old_rec.ass_attribute13
958: ,p_ass_attribute14_o
959: => per_asg_shd.g_old_rec.ass_attribute14
960: ,p_ass_attribute15_o
961: => per_asg_shd.g_old_rec.ass_attribute15
955: => per_asg_shd.g_old_rec.ass_attribute12
956: ,p_ass_attribute13_o
957: => per_asg_shd.g_old_rec.ass_attribute13
958: ,p_ass_attribute14_o
959: => per_asg_shd.g_old_rec.ass_attribute14
960: ,p_ass_attribute15_o
961: => per_asg_shd.g_old_rec.ass_attribute15
962: ,p_ass_attribute16_o
963: => per_asg_shd.g_old_rec.ass_attribute16
957: => per_asg_shd.g_old_rec.ass_attribute13
958: ,p_ass_attribute14_o
959: => per_asg_shd.g_old_rec.ass_attribute14
960: ,p_ass_attribute15_o
961: => per_asg_shd.g_old_rec.ass_attribute15
962: ,p_ass_attribute16_o
963: => per_asg_shd.g_old_rec.ass_attribute16
964: ,p_ass_attribute17_o
965: => per_asg_shd.g_old_rec.ass_attribute17
959: => per_asg_shd.g_old_rec.ass_attribute14
960: ,p_ass_attribute15_o
961: => per_asg_shd.g_old_rec.ass_attribute15
962: ,p_ass_attribute16_o
963: => per_asg_shd.g_old_rec.ass_attribute16
964: ,p_ass_attribute17_o
965: => per_asg_shd.g_old_rec.ass_attribute17
966: ,p_ass_attribute18_o
967: => per_asg_shd.g_old_rec.ass_attribute18
961: => per_asg_shd.g_old_rec.ass_attribute15
962: ,p_ass_attribute16_o
963: => per_asg_shd.g_old_rec.ass_attribute16
964: ,p_ass_attribute17_o
965: => per_asg_shd.g_old_rec.ass_attribute17
966: ,p_ass_attribute18_o
967: => per_asg_shd.g_old_rec.ass_attribute18
968: ,p_ass_attribute19_o
969: => per_asg_shd.g_old_rec.ass_attribute19
963: => per_asg_shd.g_old_rec.ass_attribute16
964: ,p_ass_attribute17_o
965: => per_asg_shd.g_old_rec.ass_attribute17
966: ,p_ass_attribute18_o
967: => per_asg_shd.g_old_rec.ass_attribute18
968: ,p_ass_attribute19_o
969: => per_asg_shd.g_old_rec.ass_attribute19
970: ,p_ass_attribute20_o
971: => per_asg_shd.g_old_rec.ass_attribute20
965: => per_asg_shd.g_old_rec.ass_attribute17
966: ,p_ass_attribute18_o
967: => per_asg_shd.g_old_rec.ass_attribute18
968: ,p_ass_attribute19_o
969: => per_asg_shd.g_old_rec.ass_attribute19
970: ,p_ass_attribute20_o
971: => per_asg_shd.g_old_rec.ass_attribute20
972: ,p_ass_attribute21_o
973: => per_asg_shd.g_old_rec.ass_attribute21
967: => per_asg_shd.g_old_rec.ass_attribute18
968: ,p_ass_attribute19_o
969: => per_asg_shd.g_old_rec.ass_attribute19
970: ,p_ass_attribute20_o
971: => per_asg_shd.g_old_rec.ass_attribute20
972: ,p_ass_attribute21_o
973: => per_asg_shd.g_old_rec.ass_attribute21
974: ,p_ass_attribute22_o
975: => per_asg_shd.g_old_rec.ass_attribute22
969: => per_asg_shd.g_old_rec.ass_attribute19
970: ,p_ass_attribute20_o
971: => per_asg_shd.g_old_rec.ass_attribute20
972: ,p_ass_attribute21_o
973: => per_asg_shd.g_old_rec.ass_attribute21
974: ,p_ass_attribute22_o
975: => per_asg_shd.g_old_rec.ass_attribute22
976: ,p_ass_attribute23_o
977: => per_asg_shd.g_old_rec.ass_attribute23
971: => per_asg_shd.g_old_rec.ass_attribute20
972: ,p_ass_attribute21_o
973: => per_asg_shd.g_old_rec.ass_attribute21
974: ,p_ass_attribute22_o
975: => per_asg_shd.g_old_rec.ass_attribute22
976: ,p_ass_attribute23_o
977: => per_asg_shd.g_old_rec.ass_attribute23
978: ,p_ass_attribute24_o
979: => per_asg_shd.g_old_rec.ass_attribute24
973: => per_asg_shd.g_old_rec.ass_attribute21
974: ,p_ass_attribute22_o
975: => per_asg_shd.g_old_rec.ass_attribute22
976: ,p_ass_attribute23_o
977: => per_asg_shd.g_old_rec.ass_attribute23
978: ,p_ass_attribute24_o
979: => per_asg_shd.g_old_rec.ass_attribute24
980: ,p_ass_attribute25_o
981: => per_asg_shd.g_old_rec.ass_attribute25
975: => per_asg_shd.g_old_rec.ass_attribute22
976: ,p_ass_attribute23_o
977: => per_asg_shd.g_old_rec.ass_attribute23
978: ,p_ass_attribute24_o
979: => per_asg_shd.g_old_rec.ass_attribute24
980: ,p_ass_attribute25_o
981: => per_asg_shd.g_old_rec.ass_attribute25
982: ,p_ass_attribute26_o
983: => per_asg_shd.g_old_rec.ass_attribute26
977: => per_asg_shd.g_old_rec.ass_attribute23
978: ,p_ass_attribute24_o
979: => per_asg_shd.g_old_rec.ass_attribute24
980: ,p_ass_attribute25_o
981: => per_asg_shd.g_old_rec.ass_attribute25
982: ,p_ass_attribute26_o
983: => per_asg_shd.g_old_rec.ass_attribute26
984: ,p_ass_attribute27_o
985: => per_asg_shd.g_old_rec.ass_attribute27
979: => per_asg_shd.g_old_rec.ass_attribute24
980: ,p_ass_attribute25_o
981: => per_asg_shd.g_old_rec.ass_attribute25
982: ,p_ass_attribute26_o
983: => per_asg_shd.g_old_rec.ass_attribute26
984: ,p_ass_attribute27_o
985: => per_asg_shd.g_old_rec.ass_attribute27
986: ,p_ass_attribute28_o
987: => per_asg_shd.g_old_rec.ass_attribute28
981: => per_asg_shd.g_old_rec.ass_attribute25
982: ,p_ass_attribute26_o
983: => per_asg_shd.g_old_rec.ass_attribute26
984: ,p_ass_attribute27_o
985: => per_asg_shd.g_old_rec.ass_attribute27
986: ,p_ass_attribute28_o
987: => per_asg_shd.g_old_rec.ass_attribute28
988: ,p_ass_attribute29_o
989: => per_asg_shd.g_old_rec.ass_attribute29
983: => per_asg_shd.g_old_rec.ass_attribute26
984: ,p_ass_attribute27_o
985: => per_asg_shd.g_old_rec.ass_attribute27
986: ,p_ass_attribute28_o
987: => per_asg_shd.g_old_rec.ass_attribute28
988: ,p_ass_attribute29_o
989: => per_asg_shd.g_old_rec.ass_attribute29
990: ,p_ass_attribute30_o
991: => per_asg_shd.g_old_rec.ass_attribute30
985: => per_asg_shd.g_old_rec.ass_attribute27
986: ,p_ass_attribute28_o
987: => per_asg_shd.g_old_rec.ass_attribute28
988: ,p_ass_attribute29_o
989: => per_asg_shd.g_old_rec.ass_attribute29
990: ,p_ass_attribute30_o
991: => per_asg_shd.g_old_rec.ass_attribute30
992: ,p_title_o
993: => per_asg_shd.g_old_rec.title
987: => per_asg_shd.g_old_rec.ass_attribute28
988: ,p_ass_attribute29_o
989: => per_asg_shd.g_old_rec.ass_attribute29
990: ,p_ass_attribute30_o
991: => per_asg_shd.g_old_rec.ass_attribute30
992: ,p_title_o
993: => per_asg_shd.g_old_rec.title
994: ,p_contract_id_o
995: => per_asg_shd.g_old_rec.contract_id
989: => per_asg_shd.g_old_rec.ass_attribute29
990: ,p_ass_attribute30_o
991: => per_asg_shd.g_old_rec.ass_attribute30
992: ,p_title_o
993: => per_asg_shd.g_old_rec.title
994: ,p_contract_id_o
995: => per_asg_shd.g_old_rec.contract_id
996: ,p_establishment_id_o
997: => per_asg_shd.g_old_rec.establishment_id
991: => per_asg_shd.g_old_rec.ass_attribute30
992: ,p_title_o
993: => per_asg_shd.g_old_rec.title
994: ,p_contract_id_o
995: => per_asg_shd.g_old_rec.contract_id
996: ,p_establishment_id_o
997: => per_asg_shd.g_old_rec.establishment_id
998: ,p_collective_agreement_id_o
999: => per_asg_shd.g_old_rec.collective_agreement_id
993: => per_asg_shd.g_old_rec.title
994: ,p_contract_id_o
995: => per_asg_shd.g_old_rec.contract_id
996: ,p_establishment_id_o
997: => per_asg_shd.g_old_rec.establishment_id
998: ,p_collective_agreement_id_o
999: => per_asg_shd.g_old_rec.collective_agreement_id
1000: ,p_cagr_grade_def_id_o
1001: => per_asg_shd.g_old_rec.cagr_grade_def_id
995: => per_asg_shd.g_old_rec.contract_id
996: ,p_establishment_id_o
997: => per_asg_shd.g_old_rec.establishment_id
998: ,p_collective_agreement_id_o
999: => per_asg_shd.g_old_rec.collective_agreement_id
1000: ,p_cagr_grade_def_id_o
1001: => per_asg_shd.g_old_rec.cagr_grade_def_id
1002: ,p_cagr_id_flex_num_o
1003: => per_asg_shd.g_old_rec.cagr_id_flex_num
997: => per_asg_shd.g_old_rec.establishment_id
998: ,p_collective_agreement_id_o
999: => per_asg_shd.g_old_rec.collective_agreement_id
1000: ,p_cagr_grade_def_id_o
1001: => per_asg_shd.g_old_rec.cagr_grade_def_id
1002: ,p_cagr_id_flex_num_o
1003: => per_asg_shd.g_old_rec.cagr_id_flex_num
1004: ,p_object_version_number_o
1005: => per_asg_shd.g_old_rec.object_version_number
999: => per_asg_shd.g_old_rec.collective_agreement_id
1000: ,p_cagr_grade_def_id_o
1001: => per_asg_shd.g_old_rec.cagr_grade_def_id
1002: ,p_cagr_id_flex_num_o
1003: => per_asg_shd.g_old_rec.cagr_id_flex_num
1004: ,p_object_version_number_o
1005: => per_asg_shd.g_old_rec.object_version_number
1006: ,p_notice_period_o
1007: => per_asg_shd.g_old_rec.notice_period
1001: => per_asg_shd.g_old_rec.cagr_grade_def_id
1002: ,p_cagr_id_flex_num_o
1003: => per_asg_shd.g_old_rec.cagr_id_flex_num
1004: ,p_object_version_number_o
1005: => per_asg_shd.g_old_rec.object_version_number
1006: ,p_notice_period_o
1007: => per_asg_shd.g_old_rec.notice_period
1008: ,p_notice_period_uom_o
1009: => per_asg_shd.g_old_rec.notice_period_uom
1003: => per_asg_shd.g_old_rec.cagr_id_flex_num
1004: ,p_object_version_number_o
1005: => per_asg_shd.g_old_rec.object_version_number
1006: ,p_notice_period_o
1007: => per_asg_shd.g_old_rec.notice_period
1008: ,p_notice_period_uom_o
1009: => per_asg_shd.g_old_rec.notice_period_uom
1010: ,p_employee_category_o
1011: => per_asg_shd.g_old_rec.employee_category
1005: => per_asg_shd.g_old_rec.object_version_number
1006: ,p_notice_period_o
1007: => per_asg_shd.g_old_rec.notice_period
1008: ,p_notice_period_uom_o
1009: => per_asg_shd.g_old_rec.notice_period_uom
1010: ,p_employee_category_o
1011: => per_asg_shd.g_old_rec.employee_category
1012: ,p_work_at_home_o
1013: => per_asg_shd.g_old_rec.work_at_home
1007: => per_asg_shd.g_old_rec.notice_period
1008: ,p_notice_period_uom_o
1009: => per_asg_shd.g_old_rec.notice_period_uom
1010: ,p_employee_category_o
1011: => per_asg_shd.g_old_rec.employee_category
1012: ,p_work_at_home_o
1013: => per_asg_shd.g_old_rec.work_at_home
1014: ,p_job_post_source_name_o
1015: => per_asg_shd.g_old_rec.job_post_source_name
1009: => per_asg_shd.g_old_rec.notice_period_uom
1010: ,p_employee_category_o
1011: => per_asg_shd.g_old_rec.employee_category
1012: ,p_work_at_home_o
1013: => per_asg_shd.g_old_rec.work_at_home
1014: ,p_job_post_source_name_o
1015: => per_asg_shd.g_old_rec.job_post_source_name
1016: ,p_posting_content_id_o
1017: => per_asg_shd.g_old_rec.posting_content_id
1011: => per_asg_shd.g_old_rec.employee_category
1012: ,p_work_at_home_o
1013: => per_asg_shd.g_old_rec.work_at_home
1014: ,p_job_post_source_name_o
1015: => per_asg_shd.g_old_rec.job_post_source_name
1016: ,p_posting_content_id_o
1017: => per_asg_shd.g_old_rec.posting_content_id
1018: ,p_placement_date_start_o
1019: => per_asg_shd.g_old_rec.period_of_placement_date_start
1013: => per_asg_shd.g_old_rec.work_at_home
1014: ,p_job_post_source_name_o
1015: => per_asg_shd.g_old_rec.job_post_source_name
1016: ,p_posting_content_id_o
1017: => per_asg_shd.g_old_rec.posting_content_id
1018: ,p_placement_date_start_o
1019: => per_asg_shd.g_old_rec.period_of_placement_date_start
1020: ,p_vendor_id_o
1021: => per_asg_shd.g_old_rec.vendor_id
1015: => per_asg_shd.g_old_rec.job_post_source_name
1016: ,p_posting_content_id_o
1017: => per_asg_shd.g_old_rec.posting_content_id
1018: ,p_placement_date_start_o
1019: => per_asg_shd.g_old_rec.period_of_placement_date_start
1020: ,p_vendor_id_o
1021: => per_asg_shd.g_old_rec.vendor_id
1022: ,p_vendor_employee_number_o
1023: => per_asg_shd.g_old_rec.vendor_employee_number
1017: => per_asg_shd.g_old_rec.posting_content_id
1018: ,p_placement_date_start_o
1019: => per_asg_shd.g_old_rec.period_of_placement_date_start
1020: ,p_vendor_id_o
1021: => per_asg_shd.g_old_rec.vendor_id
1022: ,p_vendor_employee_number_o
1023: => per_asg_shd.g_old_rec.vendor_employee_number
1024: ,p_vendor_assignment_number_o
1025: => per_asg_shd.g_old_rec.vendor_assignment_number
1019: => per_asg_shd.g_old_rec.period_of_placement_date_start
1020: ,p_vendor_id_o
1021: => per_asg_shd.g_old_rec.vendor_id
1022: ,p_vendor_employee_number_o
1023: => per_asg_shd.g_old_rec.vendor_employee_number
1024: ,p_vendor_assignment_number_o
1025: => per_asg_shd.g_old_rec.vendor_assignment_number
1026: ,p_assignment_category_o
1027: => per_asg_shd.g_old_rec.assignment_category
1021: => per_asg_shd.g_old_rec.vendor_id
1022: ,p_vendor_employee_number_o
1023: => per_asg_shd.g_old_rec.vendor_employee_number
1024: ,p_vendor_assignment_number_o
1025: => per_asg_shd.g_old_rec.vendor_assignment_number
1026: ,p_assignment_category_o
1027: => per_asg_shd.g_old_rec.assignment_category
1028: ,p_project_title_o
1029: => per_asg_shd.g_old_rec.project_title
1023: => per_asg_shd.g_old_rec.vendor_employee_number
1024: ,p_vendor_assignment_number_o
1025: => per_asg_shd.g_old_rec.vendor_assignment_number
1026: ,p_assignment_category_o
1027: => per_asg_shd.g_old_rec.assignment_category
1028: ,p_project_title_o
1029: => per_asg_shd.g_old_rec.project_title
1030: ,p_applicant_rank_o
1031: => per_asg_shd.g_old_rec.applicant_rank
1025: => per_asg_shd.g_old_rec.vendor_assignment_number
1026: ,p_assignment_category_o
1027: => per_asg_shd.g_old_rec.assignment_category
1028: ,p_project_title_o
1029: => per_asg_shd.g_old_rec.project_title
1030: ,p_applicant_rank_o
1031: => per_asg_shd.g_old_rec.applicant_rank
1032: ,p_grade_ladder_pgm_id_o
1033: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1027: => per_asg_shd.g_old_rec.assignment_category
1028: ,p_project_title_o
1029: => per_asg_shd.g_old_rec.project_title
1030: ,p_applicant_rank_o
1031: => per_asg_shd.g_old_rec.applicant_rank
1032: ,p_grade_ladder_pgm_id_o
1033: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1034: ,p_supervisor_assignment_id_o
1035: => per_asg_shd.g_old_rec.supervisor_assignment_id
1029: => per_asg_shd.g_old_rec.project_title
1030: ,p_applicant_rank_o
1031: => per_asg_shd.g_old_rec.applicant_rank
1032: ,p_grade_ladder_pgm_id_o
1033: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1034: ,p_supervisor_assignment_id_o
1035: => per_asg_shd.g_old_rec.supervisor_assignment_id
1036: ,p_vendor_site_id_o
1037: => per_asg_shd.g_old_rec.vendor_site_id
1031: => per_asg_shd.g_old_rec.applicant_rank
1032: ,p_grade_ladder_pgm_id_o
1033: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1034: ,p_supervisor_assignment_id_o
1035: => per_asg_shd.g_old_rec.supervisor_assignment_id
1036: ,p_vendor_site_id_o
1037: => per_asg_shd.g_old_rec.vendor_site_id
1038: ,p_po_header_id_o
1039: => per_asg_shd.g_old_rec.po_header_id
1033: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1034: ,p_supervisor_assignment_id_o
1035: => per_asg_shd.g_old_rec.supervisor_assignment_id
1036: ,p_vendor_site_id_o
1037: => per_asg_shd.g_old_rec.vendor_site_id
1038: ,p_po_header_id_o
1039: => per_asg_shd.g_old_rec.po_header_id
1040: ,p_po_line_id_o
1041: => per_asg_shd.g_old_rec.po_line_id
1035: => per_asg_shd.g_old_rec.supervisor_assignment_id
1036: ,p_vendor_site_id_o
1037: => per_asg_shd.g_old_rec.vendor_site_id
1038: ,p_po_header_id_o
1039: => per_asg_shd.g_old_rec.po_header_id
1040: ,p_po_line_id_o
1041: => per_asg_shd.g_old_rec.po_line_id
1042: ,p_projected_assignment_end_o
1043: => per_asg_shd.g_old_rec.projected_assignment_end
1037: => per_asg_shd.g_old_rec.vendor_site_id
1038: ,p_po_header_id_o
1039: => per_asg_shd.g_old_rec.po_header_id
1040: ,p_po_line_id_o
1041: => per_asg_shd.g_old_rec.po_line_id
1042: ,p_projected_assignment_end_o
1043: => per_asg_shd.g_old_rec.projected_assignment_end
1044: );
1045: exception
1039: => per_asg_shd.g_old_rec.po_header_id
1040: ,p_po_line_id_o
1041: => per_asg_shd.g_old_rec.po_line_id
1042: ,p_projected_assignment_end_o
1043: => per_asg_shd.g_old_rec.projected_assignment_end
1044: );
1045: exception
1046: when hr_api.cannot_find_prog_unit then
1047: hr_api.cannot_find_prog_unit_error
1173: ,P_VENDOR_SITE_ID => p_rec.vendor_site_id
1174: ,P_PO_HEADER_ID => p_rec.po_header_id
1175: ,P_PO_LINE_ID => p_rec.po_line_id
1176: ,P_PROJECTED_ASSIGNMENT_END => p_rec.projected_assignment_end
1177: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1178: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1179: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1180: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1181: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1174: ,P_PO_HEADER_ID => p_rec.po_header_id
1175: ,P_PO_LINE_ID => p_rec.po_line_id
1176: ,P_PROJECTED_ASSIGNMENT_END => p_rec.projected_assignment_end
1177: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1178: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1179: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1180: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1181: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1182: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1175: ,P_PO_LINE_ID => p_rec.po_line_id
1176: ,P_PROJECTED_ASSIGNMENT_END => p_rec.projected_assignment_end
1177: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1178: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1179: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1180: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1181: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1182: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1183: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1176: ,P_PROJECTED_ASSIGNMENT_END => p_rec.projected_assignment_end
1177: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1178: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1179: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1180: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1181: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1182: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1183: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1184: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1177: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1178: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1179: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1180: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1181: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1182: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1183: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1184: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1185: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1178: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1179: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1180: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1181: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1182: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1183: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1184: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1185: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1186: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1179: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1180: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1181: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1182: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1183: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1184: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1185: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1186: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1187: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1180: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1181: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1182: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1183: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1184: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1185: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1186: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1187: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1188: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1181: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1182: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1183: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1184: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1185: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1186: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1187: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1188: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1189: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1182: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1183: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1184: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1185: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1186: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1187: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1188: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1189: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1190: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1183: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1184: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1185: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1186: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1187: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1188: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1189: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1190: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1191: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1184: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1185: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1186: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1187: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1188: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1189: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1190: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1191: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1192: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1185: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1186: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1187: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1188: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1189: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1190: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1191: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1192: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1193: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1186: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1187: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1188: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1189: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1190: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1191: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1192: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1193: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1194: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1187: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1188: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1189: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1190: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1191: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1192: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1193: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1194: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1195: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1188: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1189: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1190: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1191: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1192: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1193: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1194: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1195: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1196: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1189: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1190: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1191: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1192: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1193: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1194: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1195: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1196: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1197: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1190: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1191: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1192: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1193: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1194: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1195: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1196: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1197: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1198: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1191: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1192: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1193: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1194: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1195: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1196: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1197: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1198: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1199: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1192: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1193: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1194: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1195: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1196: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1197: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1198: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1199: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1200: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1193: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1194: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1195: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1196: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1197: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1198: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1199: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1200: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1201: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1194: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1195: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1196: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1197: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1198: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1199: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1200: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1201: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1202: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1195: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1196: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1197: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1198: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1199: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1200: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1201: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1202: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1203: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1196: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1197: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1198: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1199: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1200: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1201: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1202: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1203: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1204: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1197: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1198: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1199: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1200: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1201: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1202: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1203: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1204: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1205: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1198: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1199: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1200: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1201: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1202: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1203: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1204: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1205: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1206: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1199: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1200: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1201: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1202: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1203: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1204: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1205: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1206: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1207: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1200: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1201: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1202: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1203: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1204: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1205: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1206: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1207: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1208: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1201: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1202: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1203: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1204: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1205: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1206: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1207: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1208: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1209: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1202: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1203: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1204: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1205: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1206: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1207: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1208: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1209: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1210: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1203: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1204: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1205: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1206: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1207: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1208: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1209: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1210: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1211: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1204: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1205: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1206: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1207: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1208: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1209: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1210: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1211: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1212: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1205: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1206: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1207: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1208: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1209: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1210: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1211: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1212: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1213: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1206: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1207: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1208: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1209: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1210: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1211: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1212: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1213: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1214: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1207: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1208: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1209: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1210: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1211: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1212: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1213: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1214: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1215: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1208: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1209: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1210: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1211: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1212: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1213: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1214: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1215: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1216: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1209: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1210: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1211: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1212: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1213: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1214: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1215: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1216: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1217: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1210: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1211: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1212: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1213: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1214: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1215: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1216: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1217: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1218: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1211: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1212: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1213: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1214: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1215: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1216: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1217: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1218: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1219: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1212: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1213: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1214: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1215: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1216: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1217: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1218: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1219: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1220: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1213: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1214: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1215: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1216: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1217: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1218: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1219: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1220: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1221: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1214: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1215: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1216: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1217: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1218: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1219: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1220: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1221: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1222: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1215: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1216: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1217: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1218: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1219: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1220: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1221: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1222: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1223: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1216: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1217: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1218: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1219: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1220: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1221: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1222: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1223: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1224: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1217: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1218: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1219: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1220: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1221: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1222: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1223: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1224: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1225: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1218: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1219: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1220: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1221: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1222: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1223: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1224: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1225: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1226: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1219: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1220: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1221: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1222: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1223: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1224: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1225: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1226: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1227: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1220: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1221: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1222: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1223: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1224: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1225: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1226: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1227: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1228: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1221: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1222: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1223: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1224: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1225: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1226: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1227: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1228: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1229: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1222: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1223: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1224: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1225: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1226: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1227: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1228: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1229: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1230: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1223: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1224: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1225: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1226: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1227: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1228: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1229: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1230: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1231: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1224: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1225: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1226: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1227: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1228: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1229: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1230: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1231: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1232: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1225: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1226: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1227: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1228: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1229: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1230: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1231: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1232: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1233: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1226: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1227: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1228: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1229: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1230: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1231: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1232: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1233: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1234: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1227: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1228: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1229: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1230: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1231: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1232: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1233: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1234: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1235: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1228: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1229: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1230: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1231: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1232: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1233: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1234: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1235: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1236: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1229: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1230: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1231: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1232: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1233: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1234: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1235: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1236: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1237: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1230: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1231: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1232: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1233: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1234: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1235: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1236: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1237: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1238: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1231: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1232: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1233: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1234: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1235: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1236: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1237: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1238: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1239: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1232: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1233: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1234: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1235: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1236: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1237: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1238: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1239: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1240: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1233: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1234: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1235: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1236: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1237: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1238: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1239: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1240: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1241: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1234: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1235: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1236: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1237: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1238: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1239: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1240: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1241: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1242: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1235: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1236: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1237: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1238: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1239: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1240: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1241: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1242: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1243: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1236: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1237: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1238: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1239: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1240: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1241: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1242: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1243: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1244: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1237: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1238: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1239: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1240: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1241: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1242: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1243: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1244: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1245: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1238: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1239: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1240: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1241: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1242: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1243: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1244: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1245: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1246: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1239: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1240: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1241: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1242: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1243: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1244: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1245: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1246: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1247: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1240: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1241: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1242: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1243: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1244: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1245: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1246: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1247: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1248: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1241: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1242: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1243: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1244: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1245: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1246: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1247: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1248: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1249: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1242: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1243: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1244: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1245: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1246: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1247: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1248: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1249: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1250: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1243: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1244: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1245: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1246: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1247: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1248: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1249: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1250: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1251: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1244: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1245: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1246: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1247: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1248: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1249: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1250: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1251: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1252: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1245: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1246: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1247: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1248: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1249: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1250: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1251: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1252: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1253: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1246: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1247: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1248: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1249: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1250: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1251: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1252: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1253: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1254: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1247: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1248: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1249: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1250: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1251: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1252: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1253: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1254: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1255: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1248: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1249: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1250: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1251: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1252: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1253: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1254: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1255: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1256: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1249: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1250: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1251: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1252: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1253: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1254: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1255: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1256: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1257: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1250: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1251: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1252: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1253: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1254: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1255: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1256: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1257: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1258: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1251: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1252: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1253: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1254: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1255: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1256: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1257: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1258: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1259: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1252: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1253: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1254: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1255: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1256: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1257: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1258: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1259: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1260: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1253: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1254: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1255: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1256: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1257: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1258: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1259: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1260: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1261: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1254: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1255: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1256: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1257: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1258: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1259: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1260: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1261: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1262: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1255: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1256: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1257: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1258: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1259: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1260: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1261: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1262: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1263: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1256: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1257: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1258: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1259: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1260: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1261: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1262: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1263: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1264: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1257: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1258: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1259: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1260: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1261: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1262: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1263: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1264: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1265: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1258: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1259: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1260: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1261: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1262: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1263: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1264: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1265: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1266: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1259: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1260: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1261: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1262: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1263: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1264: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1265: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1266: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1267: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1260: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1261: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1262: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1263: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1264: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1265: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1266: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1267: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1268: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1261: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1262: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1263: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1264: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1265: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1266: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1267: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1268: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1269: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1262: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1263: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1264: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1265: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1266: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1267: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1268: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1269: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1270: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1263: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1264: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1265: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1266: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1267: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1268: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1269: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1270: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1271: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1264: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1265: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1266: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1267: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1268: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1269: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1270: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1271: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1272: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1265: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1266: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1267: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1268: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1269: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1270: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1271: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1272: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1273: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1266: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1267: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1268: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1269: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1270: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1271: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1272: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1273: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1274: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1267: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1268: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1269: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1270: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1271: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1272: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1273: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1274: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1275: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1268: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1269: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1270: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1271: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1272: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1273: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1274: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1275: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1276: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1269: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1270: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1271: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1272: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1273: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1274: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1275: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1276: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1277: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1270: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1271: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1272: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1273: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1274: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1275: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1276: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1277: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1278: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1271: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1272: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1273: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1274: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1275: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1276: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1277: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1278: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1279: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1272: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1273: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1274: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1275: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1276: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1277: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1278: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1279: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1280: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1273: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1274: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1275: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1276: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1277: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1278: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1279: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1280: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1281: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1274: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1275: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1276: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1277: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1278: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1279: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1280: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1281: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1282: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1275: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1276: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1277: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1278: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1279: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1280: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1281: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1282: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1283: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1276: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1277: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1278: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1279: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1280: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1281: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1282: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1283: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1284: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1277: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1278: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1279: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1280: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1281: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1282: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1283: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1284: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1285: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1278: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1279: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1280: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1281: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1282: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1283: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1284: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1285: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1286: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1279: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1280: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1281: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1282: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1283: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1284: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1285: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1286: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1287: );
1280: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1281: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1282: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1283: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1284: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1285: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1286: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1287: );
1288: --
1281: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1282: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1283: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1284: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1285: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1286: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1287: );
1288: --
1289: -- Call to Workflow Sync Procedure For Assignments
1282: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1283: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1284: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1285: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1286: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1287: );
1288: --
1289: -- Call to Workflow Sync Procedure For Assignments
1290: per_pqh_shr.per_asg_wf_sync('POST_UPDATE',
1288: --
1289: -- Call to Workflow Sync Procedure For Assignments
1290: per_pqh_shr.per_asg_wf_sync('POST_UPDATE',
1291: p_rec,
1292: per_asg_shd.g_old_rec.position_id,
1293: p_effective_date,
1294: p_validation_start_date,
1295: p_validation_end_date,
1296: p_datetrack_mode);
1343: -- Internal Table Handler Use Only.
1344: --
1345: -- {End Of Comments}
1346: -- ----------------------------------------------------------------------------
1347: Procedure convert_defs(p_rec in out nocopy per_asg_shd.g_rec_type) is
1348: --
1349: l_proc varchar2(72) := g_package||'convert_defs';
1350: --
1351: Begin
1358: -- is being used then we must set to the 'current' argument value.
1359: --
1360: If (p_rec.business_group_id = hr_api.g_number) then
1361: p_rec.business_group_id :=
1362: per_asg_shd.g_old_rec.business_group_id;
1363: End If;
1364: If (p_rec.recruiter_id = hr_api.g_number) then
1365: p_rec.recruiter_id :=
1366: per_asg_shd.g_old_rec.recruiter_id;
1362: per_asg_shd.g_old_rec.business_group_id;
1363: End If;
1364: If (p_rec.recruiter_id = hr_api.g_number) then
1365: p_rec.recruiter_id :=
1366: per_asg_shd.g_old_rec.recruiter_id;
1367: End If;
1368: If (p_rec.grade_id = hr_api.g_number) then
1369: p_rec.grade_id :=
1370: per_asg_shd.g_old_rec.grade_id;
1366: per_asg_shd.g_old_rec.recruiter_id;
1367: End If;
1368: If (p_rec.grade_id = hr_api.g_number) then
1369: p_rec.grade_id :=
1370: per_asg_shd.g_old_rec.grade_id;
1371: End If;
1372: If (p_rec.position_id = hr_api.g_number) then
1373: p_rec.position_id :=
1374: per_asg_shd.g_old_rec.position_id;
1370: per_asg_shd.g_old_rec.grade_id;
1371: End If;
1372: If (p_rec.position_id = hr_api.g_number) then
1373: p_rec.position_id :=
1374: per_asg_shd.g_old_rec.position_id;
1375: End If;
1376: If (p_rec.job_id = hr_api.g_number) then
1377: p_rec.job_id :=
1378: per_asg_shd.g_old_rec.job_id;
1374: per_asg_shd.g_old_rec.position_id;
1375: End If;
1376: If (p_rec.job_id = hr_api.g_number) then
1377: p_rec.job_id :=
1378: per_asg_shd.g_old_rec.job_id;
1379: End If;
1380: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1381: p_rec.assignment_status_type_id :=
1382: per_asg_shd.g_old_rec.assignment_status_type_id;
1378: per_asg_shd.g_old_rec.job_id;
1379: End If;
1380: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1381: p_rec.assignment_status_type_id :=
1382: per_asg_shd.g_old_rec.assignment_status_type_id;
1383: End If;
1384: If (p_rec.payroll_id = hr_api.g_number) then
1385: p_rec.payroll_id :=
1386: per_asg_shd.g_old_rec.payroll_id;
1382: per_asg_shd.g_old_rec.assignment_status_type_id;
1383: End If;
1384: If (p_rec.payroll_id = hr_api.g_number) then
1385: p_rec.payroll_id :=
1386: per_asg_shd.g_old_rec.payroll_id;
1387: End If;
1388: If (p_rec.location_id = hr_api.g_number) then
1389: p_rec.location_id :=
1390: per_asg_shd.g_old_rec.location_id;
1386: per_asg_shd.g_old_rec.payroll_id;
1387: End If;
1388: If (p_rec.location_id = hr_api.g_number) then
1389: p_rec.location_id :=
1390: per_asg_shd.g_old_rec.location_id;
1391: End If;
1392: If (p_rec.person_referred_by_id = hr_api.g_number) then
1393: p_rec.person_referred_by_id :=
1394: per_asg_shd.g_old_rec.person_referred_by_id;
1390: per_asg_shd.g_old_rec.location_id;
1391: End If;
1392: If (p_rec.person_referred_by_id = hr_api.g_number) then
1393: p_rec.person_referred_by_id :=
1394: per_asg_shd.g_old_rec.person_referred_by_id;
1395: End If;
1396: If (p_rec.supervisor_id = hr_api.g_number) then
1397: p_rec.supervisor_id :=
1398: per_asg_shd.g_old_rec.supervisor_id;
1394: per_asg_shd.g_old_rec.person_referred_by_id;
1395: End If;
1396: If (p_rec.supervisor_id = hr_api.g_number) then
1397: p_rec.supervisor_id :=
1398: per_asg_shd.g_old_rec.supervisor_id;
1399: End If;
1400: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1401: p_rec.special_ceiling_step_id :=
1402: per_asg_shd.g_old_rec.special_ceiling_step_id;
1398: per_asg_shd.g_old_rec.supervisor_id;
1399: End If;
1400: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1401: p_rec.special_ceiling_step_id :=
1402: per_asg_shd.g_old_rec.special_ceiling_step_id;
1403: End If;
1404: If (p_rec.person_id = hr_api.g_number) then
1405: p_rec.person_id :=
1406: per_asg_shd.g_old_rec.person_id;
1402: per_asg_shd.g_old_rec.special_ceiling_step_id;
1403: End If;
1404: If (p_rec.person_id = hr_api.g_number) then
1405: p_rec.person_id :=
1406: per_asg_shd.g_old_rec.person_id;
1407: End If;
1408: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1409: p_rec.recruitment_activity_id :=
1410: per_asg_shd.g_old_rec.recruitment_activity_id;
1406: per_asg_shd.g_old_rec.person_id;
1407: End If;
1408: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1409: p_rec.recruitment_activity_id :=
1410: per_asg_shd.g_old_rec.recruitment_activity_id;
1411: End If;
1412: If (p_rec.source_organization_id = hr_api.g_number) then
1413: p_rec.source_organization_id :=
1414: per_asg_shd.g_old_rec.source_organization_id;
1410: per_asg_shd.g_old_rec.recruitment_activity_id;
1411: End If;
1412: If (p_rec.source_organization_id = hr_api.g_number) then
1413: p_rec.source_organization_id :=
1414: per_asg_shd.g_old_rec.source_organization_id;
1415: End If;
1416: If (p_rec.organization_id = hr_api.g_number) then
1417: p_rec.organization_id :=
1418: per_asg_shd.g_old_rec.organization_id;
1414: per_asg_shd.g_old_rec.source_organization_id;
1415: End If;
1416: If (p_rec.organization_id = hr_api.g_number) then
1417: p_rec.organization_id :=
1418: per_asg_shd.g_old_rec.organization_id;
1419: End If;
1420: If (p_rec.people_group_id = hr_api.g_number) then
1421: p_rec.people_group_id :=
1422: per_asg_shd.g_old_rec.people_group_id;
1418: per_asg_shd.g_old_rec.organization_id;
1419: End If;
1420: If (p_rec.people_group_id = hr_api.g_number) then
1421: p_rec.people_group_id :=
1422: per_asg_shd.g_old_rec.people_group_id;
1423: End If;
1424: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1425: p_rec.soft_coding_keyflex_id :=
1426: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1422: per_asg_shd.g_old_rec.people_group_id;
1423: End If;
1424: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1425: p_rec.soft_coding_keyflex_id :=
1426: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1427: End If;
1428: If (p_rec.vacancy_id = hr_api.g_number) then
1429: p_rec.vacancy_id :=
1430: per_asg_shd.g_old_rec.vacancy_id;
1426: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1427: End If;
1428: If (p_rec.vacancy_id = hr_api.g_number) then
1429: p_rec.vacancy_id :=
1430: per_asg_shd.g_old_rec.vacancy_id;
1431: End If;
1432: If (p_rec.pay_basis_id = hr_api.g_number) then
1433: p_rec.pay_basis_id :=
1434: per_asg_shd.g_old_rec.pay_basis_id;
1430: per_asg_shd.g_old_rec.vacancy_id;
1431: End If;
1432: If (p_rec.pay_basis_id = hr_api.g_number) then
1433: p_rec.pay_basis_id :=
1434: per_asg_shd.g_old_rec.pay_basis_id;
1435: End If;
1436: If (p_rec.assignment_sequence = hr_api.g_number) then
1437: p_rec.assignment_sequence :=
1438: per_asg_shd.g_old_rec.assignment_sequence;
1434: per_asg_shd.g_old_rec.pay_basis_id;
1435: End If;
1436: If (p_rec.assignment_sequence = hr_api.g_number) then
1437: p_rec.assignment_sequence :=
1438: per_asg_shd.g_old_rec.assignment_sequence;
1439: End If;
1440: If (p_rec.assignment_type = hr_api.g_varchar2) then
1441: p_rec.assignment_type :=
1442: per_asg_shd.g_old_rec.assignment_type;
1438: per_asg_shd.g_old_rec.assignment_sequence;
1439: End If;
1440: If (p_rec.assignment_type = hr_api.g_varchar2) then
1441: p_rec.assignment_type :=
1442: per_asg_shd.g_old_rec.assignment_type;
1443: End If;
1444: If (p_rec.primary_flag = hr_api.g_varchar2) then
1445: p_rec.primary_flag :=
1446: per_asg_shd.g_old_rec.primary_flag;
1442: per_asg_shd.g_old_rec.assignment_type;
1443: End If;
1444: If (p_rec.primary_flag = hr_api.g_varchar2) then
1445: p_rec.primary_flag :=
1446: per_asg_shd.g_old_rec.primary_flag;
1447: End If;
1448: If (p_rec.application_id = hr_api.g_number) then
1449: p_rec.application_id :=
1450: per_asg_shd.g_old_rec.application_id;
1446: per_asg_shd.g_old_rec.primary_flag;
1447: End If;
1448: If (p_rec.application_id = hr_api.g_number) then
1449: p_rec.application_id :=
1450: per_asg_shd.g_old_rec.application_id;
1451: End If;
1452: If (p_rec.assignment_number = hr_api.g_varchar2) then
1453: p_rec.assignment_number :=
1454: per_asg_shd.g_old_rec.assignment_number;
1450: per_asg_shd.g_old_rec.application_id;
1451: End If;
1452: If (p_rec.assignment_number = hr_api.g_varchar2) then
1453: p_rec.assignment_number :=
1454: per_asg_shd.g_old_rec.assignment_number;
1455: End If;
1456: If (p_rec.change_reason = hr_api.g_varchar2) then
1457: p_rec.change_reason :=
1458: per_asg_shd.g_old_rec.change_reason;
1454: per_asg_shd.g_old_rec.assignment_number;
1455: End If;
1456: If (p_rec.change_reason = hr_api.g_varchar2) then
1457: p_rec.change_reason :=
1458: per_asg_shd.g_old_rec.change_reason;
1459: End If;
1460: If (p_rec.comment_id = hr_api.g_number) then
1461: p_rec.comment_id :=
1462: per_asg_shd.g_old_rec.comment_id;
1458: per_asg_shd.g_old_rec.change_reason;
1459: End If;
1460: If (p_rec.comment_id = hr_api.g_number) then
1461: p_rec.comment_id :=
1462: per_asg_shd.g_old_rec.comment_id;
1463: End If;
1464: If (p_rec.comment_text = hr_api.g_varchar2) then
1465: p_rec.comment_text :=
1466: per_asg_shd.g_old_rec.comment_text;
1462: per_asg_shd.g_old_rec.comment_id;
1463: End If;
1464: If (p_rec.comment_text = hr_api.g_varchar2) then
1465: p_rec.comment_text :=
1466: per_asg_shd.g_old_rec.comment_text;
1467: End If;
1468: If (p_rec.date_probation_end = hr_api.g_date) then
1469: p_rec.date_probation_end :=
1470: per_asg_shd.g_old_rec.date_probation_end;
1466: per_asg_shd.g_old_rec.comment_text;
1467: End If;
1468: If (p_rec.date_probation_end = hr_api.g_date) then
1469: p_rec.date_probation_end :=
1470: per_asg_shd.g_old_rec.date_probation_end;
1471: End If;
1472: If (p_rec.default_code_comb_id = hr_api.g_number) then
1473: p_rec.default_code_comb_id :=
1474: per_asg_shd.g_old_rec.default_code_comb_id;
1470: per_asg_shd.g_old_rec.date_probation_end;
1471: End If;
1472: If (p_rec.default_code_comb_id = hr_api.g_number) then
1473: p_rec.default_code_comb_id :=
1474: per_asg_shd.g_old_rec.default_code_comb_id;
1475: End If;
1476: If (p_rec.employment_category = hr_api.g_varchar2) then
1477: p_rec.employment_category :=
1478: per_asg_shd.g_old_rec.employment_category;
1474: per_asg_shd.g_old_rec.default_code_comb_id;
1475: End If;
1476: If (p_rec.employment_category = hr_api.g_varchar2) then
1477: p_rec.employment_category :=
1478: per_asg_shd.g_old_rec.employment_category;
1479: End If;
1480: If (p_rec.frequency = hr_api.g_varchar2) then
1481: p_rec.frequency :=
1482: per_asg_shd.g_old_rec.frequency;
1478: per_asg_shd.g_old_rec.employment_category;
1479: End If;
1480: If (p_rec.frequency = hr_api.g_varchar2) then
1481: p_rec.frequency :=
1482: per_asg_shd.g_old_rec.frequency;
1483: End If;
1484: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1485: p_rec.internal_address_line :=
1486: per_asg_shd.g_old_rec.internal_address_line;
1482: per_asg_shd.g_old_rec.frequency;
1483: End If;
1484: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1485: p_rec.internal_address_line :=
1486: per_asg_shd.g_old_rec.internal_address_line;
1487: End If;
1488: If (p_rec.manager_flag = hr_api.g_varchar2) then
1489: p_rec.manager_flag :=
1490: per_asg_shd.g_old_rec.manager_flag;
1486: per_asg_shd.g_old_rec.internal_address_line;
1487: End If;
1488: If (p_rec.manager_flag = hr_api.g_varchar2) then
1489: p_rec.manager_flag :=
1490: per_asg_shd.g_old_rec.manager_flag;
1491: End If;
1492: If (p_rec.normal_hours = hr_api.g_number) then
1493: p_rec.normal_hours :=
1494: per_asg_shd.g_old_rec.normal_hours;
1490: per_asg_shd.g_old_rec.manager_flag;
1491: End If;
1492: If (p_rec.normal_hours = hr_api.g_number) then
1493: p_rec.normal_hours :=
1494: per_asg_shd.g_old_rec.normal_hours;
1495: End If;
1496: If (p_rec.perf_review_period = hr_api.g_number) then
1497: p_rec.perf_review_period :=
1498: per_asg_shd.g_old_rec.perf_review_period;
1494: per_asg_shd.g_old_rec.normal_hours;
1495: End If;
1496: If (p_rec.perf_review_period = hr_api.g_number) then
1497: p_rec.perf_review_period :=
1498: per_asg_shd.g_old_rec.perf_review_period;
1499: End If;
1500: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1501: p_rec.perf_review_period_frequency :=
1502: per_asg_shd.g_old_rec.perf_review_period_frequency;
1498: per_asg_shd.g_old_rec.perf_review_period;
1499: End If;
1500: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1501: p_rec.perf_review_period_frequency :=
1502: per_asg_shd.g_old_rec.perf_review_period_frequency;
1503: End If;
1504: If (p_rec.period_of_service_id = hr_api.g_number) then
1505: p_rec.period_of_service_id :=
1506: per_asg_shd.g_old_rec.period_of_service_id;
1502: per_asg_shd.g_old_rec.perf_review_period_frequency;
1503: End If;
1504: If (p_rec.period_of_service_id = hr_api.g_number) then
1505: p_rec.period_of_service_id :=
1506: per_asg_shd.g_old_rec.period_of_service_id;
1507: End If;
1508: If (p_rec.probation_period = hr_api.g_number) then
1509: p_rec.probation_period :=
1510: per_asg_shd.g_old_rec.probation_period;
1506: per_asg_shd.g_old_rec.period_of_service_id;
1507: End If;
1508: If (p_rec.probation_period = hr_api.g_number) then
1509: p_rec.probation_period :=
1510: per_asg_shd.g_old_rec.probation_period;
1511: End If;
1512: If (p_rec.probation_unit = hr_api.g_varchar2) then
1513: p_rec.probation_unit :=
1514: per_asg_shd.g_old_rec.probation_unit;
1510: per_asg_shd.g_old_rec.probation_period;
1511: End If;
1512: If (p_rec.probation_unit = hr_api.g_varchar2) then
1513: p_rec.probation_unit :=
1514: per_asg_shd.g_old_rec.probation_unit;
1515: End If;
1516: If (p_rec.sal_review_period = hr_api.g_number) then
1517: p_rec.sal_review_period :=
1518: per_asg_shd.g_old_rec.sal_review_period;
1514: per_asg_shd.g_old_rec.probation_unit;
1515: End If;
1516: If (p_rec.sal_review_period = hr_api.g_number) then
1517: p_rec.sal_review_period :=
1518: per_asg_shd.g_old_rec.sal_review_period;
1519: End If;
1520: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1521: p_rec.sal_review_period_frequency :=
1522: per_asg_shd.g_old_rec.sal_review_period_frequency;
1518: per_asg_shd.g_old_rec.sal_review_period;
1519: End If;
1520: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1521: p_rec.sal_review_period_frequency :=
1522: per_asg_shd.g_old_rec.sal_review_period_frequency;
1523: End If;
1524: If (p_rec.set_of_books_id = hr_api.g_number) then
1525: p_rec.set_of_books_id :=
1526: per_asg_shd.g_old_rec.set_of_books_id;
1522: per_asg_shd.g_old_rec.sal_review_period_frequency;
1523: End If;
1524: If (p_rec.set_of_books_id = hr_api.g_number) then
1525: p_rec.set_of_books_id :=
1526: per_asg_shd.g_old_rec.set_of_books_id;
1527: End If;
1528: If (p_rec.source_type = hr_api.g_varchar2) then
1529: p_rec.source_type :=
1530: per_asg_shd.g_old_rec.source_type;
1526: per_asg_shd.g_old_rec.set_of_books_id;
1527: End If;
1528: If (p_rec.source_type = hr_api.g_varchar2) then
1529: p_rec.source_type :=
1530: per_asg_shd.g_old_rec.source_type;
1531: End If;
1532: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1533: p_rec.time_normal_finish :=
1534: per_asg_shd.g_old_rec.time_normal_finish;
1530: per_asg_shd.g_old_rec.source_type;
1531: End If;
1532: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1533: p_rec.time_normal_finish :=
1534: per_asg_shd.g_old_rec.time_normal_finish;
1535: End If;
1536: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1537: p_rec.time_normal_start :=
1538: per_asg_shd.g_old_rec.time_normal_start;
1534: per_asg_shd.g_old_rec.time_normal_finish;
1535: End If;
1536: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1537: p_rec.time_normal_start :=
1538: per_asg_shd.g_old_rec.time_normal_start;
1539: End If;
1540: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1541: p_rec.bargaining_unit_code :=
1542: per_asg_shd.g_old_rec.bargaining_unit_code;
1538: per_asg_shd.g_old_rec.time_normal_start;
1539: End If;
1540: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1541: p_rec.bargaining_unit_code :=
1542: per_asg_shd.g_old_rec.bargaining_unit_code;
1543: End If;
1544: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1545: p_rec.labour_union_member_flag :=
1546: per_asg_shd.g_old_rec.labour_union_member_flag;
1542: per_asg_shd.g_old_rec.bargaining_unit_code;
1543: End If;
1544: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1545: p_rec.labour_union_member_flag :=
1546: per_asg_shd.g_old_rec.labour_union_member_flag;
1547: End If;
1548: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1549: p_rec.hourly_salaried_code :=
1550: per_asg_shd.g_old_rec.hourly_salaried_code;
1546: per_asg_shd.g_old_rec.labour_union_member_flag;
1547: End If;
1548: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1549: p_rec.hourly_salaried_code :=
1550: per_asg_shd.g_old_rec.hourly_salaried_code;
1551: End If;
1552: If (p_rec.request_id = hr_api.g_number) then
1553: p_rec.request_id :=
1554: per_asg_shd.g_old_rec.request_id;
1550: per_asg_shd.g_old_rec.hourly_salaried_code;
1551: End If;
1552: If (p_rec.request_id = hr_api.g_number) then
1553: p_rec.request_id :=
1554: per_asg_shd.g_old_rec.request_id;
1555: End If;
1556: If (p_rec.program_application_id = hr_api.g_number) then
1557: p_rec.program_application_id :=
1558: per_asg_shd.g_old_rec.program_application_id;
1554: per_asg_shd.g_old_rec.request_id;
1555: End If;
1556: If (p_rec.program_application_id = hr_api.g_number) then
1557: p_rec.program_application_id :=
1558: per_asg_shd.g_old_rec.program_application_id;
1559: End If;
1560: If (p_rec.program_id = hr_api.g_number) then
1561: p_rec.program_id :=
1562: per_asg_shd.g_old_rec.program_id;
1558: per_asg_shd.g_old_rec.program_application_id;
1559: End If;
1560: If (p_rec.program_id = hr_api.g_number) then
1561: p_rec.program_id :=
1562: per_asg_shd.g_old_rec.program_id;
1563: End If;
1564: If (p_rec.program_update_date = hr_api.g_date) then
1565: p_rec.program_update_date :=
1566: per_asg_shd.g_old_rec.program_update_date;
1562: per_asg_shd.g_old_rec.program_id;
1563: End If;
1564: If (p_rec.program_update_date = hr_api.g_date) then
1565: p_rec.program_update_date :=
1566: per_asg_shd.g_old_rec.program_update_date;
1567: End If;
1568: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1569: p_rec.ass_attribute_category :=
1570: per_asg_shd.g_old_rec.ass_attribute_category;
1566: per_asg_shd.g_old_rec.program_update_date;
1567: End If;
1568: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1569: p_rec.ass_attribute_category :=
1570: per_asg_shd.g_old_rec.ass_attribute_category;
1571: End If;
1572: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute1 :=
1574: per_asg_shd.g_old_rec.ass_attribute1;
1570: per_asg_shd.g_old_rec.ass_attribute_category;
1571: End If;
1572: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute1 :=
1574: per_asg_shd.g_old_rec.ass_attribute1;
1575: End If;
1576: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute2 :=
1578: per_asg_shd.g_old_rec.ass_attribute2;
1574: per_asg_shd.g_old_rec.ass_attribute1;
1575: End If;
1576: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute2 :=
1578: per_asg_shd.g_old_rec.ass_attribute2;
1579: End If;
1580: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute3 :=
1582: per_asg_shd.g_old_rec.ass_attribute3;
1578: per_asg_shd.g_old_rec.ass_attribute2;
1579: End If;
1580: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute3 :=
1582: per_asg_shd.g_old_rec.ass_attribute3;
1583: End If;
1584: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute4 :=
1586: per_asg_shd.g_old_rec.ass_attribute4;
1582: per_asg_shd.g_old_rec.ass_attribute3;
1583: End If;
1584: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute4 :=
1586: per_asg_shd.g_old_rec.ass_attribute4;
1587: End If;
1588: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute5 :=
1590: per_asg_shd.g_old_rec.ass_attribute5;
1586: per_asg_shd.g_old_rec.ass_attribute4;
1587: End If;
1588: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute5 :=
1590: per_asg_shd.g_old_rec.ass_attribute5;
1591: End If;
1592: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute6 :=
1594: per_asg_shd.g_old_rec.ass_attribute6;
1590: per_asg_shd.g_old_rec.ass_attribute5;
1591: End If;
1592: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute6 :=
1594: per_asg_shd.g_old_rec.ass_attribute6;
1595: End If;
1596: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute7 :=
1598: per_asg_shd.g_old_rec.ass_attribute7;
1594: per_asg_shd.g_old_rec.ass_attribute6;
1595: End If;
1596: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute7 :=
1598: per_asg_shd.g_old_rec.ass_attribute7;
1599: End If;
1600: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute8 :=
1602: per_asg_shd.g_old_rec.ass_attribute8;
1598: per_asg_shd.g_old_rec.ass_attribute7;
1599: End If;
1600: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute8 :=
1602: per_asg_shd.g_old_rec.ass_attribute8;
1603: End If;
1604: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute9 :=
1606: per_asg_shd.g_old_rec.ass_attribute9;
1602: per_asg_shd.g_old_rec.ass_attribute8;
1603: End If;
1604: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute9 :=
1606: per_asg_shd.g_old_rec.ass_attribute9;
1607: End If;
1608: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute10 :=
1610: per_asg_shd.g_old_rec.ass_attribute10;
1606: per_asg_shd.g_old_rec.ass_attribute9;
1607: End If;
1608: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute10 :=
1610: per_asg_shd.g_old_rec.ass_attribute10;
1611: End If;
1612: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1613: p_rec.ass_attribute11 :=
1614: per_asg_shd.g_old_rec.ass_attribute11;
1610: per_asg_shd.g_old_rec.ass_attribute10;
1611: End If;
1612: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1613: p_rec.ass_attribute11 :=
1614: per_asg_shd.g_old_rec.ass_attribute11;
1615: End If;
1616: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1617: p_rec.ass_attribute12 :=
1618: per_asg_shd.g_old_rec.ass_attribute12;
1614: per_asg_shd.g_old_rec.ass_attribute11;
1615: End If;
1616: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1617: p_rec.ass_attribute12 :=
1618: per_asg_shd.g_old_rec.ass_attribute12;
1619: End If;
1620: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1621: p_rec.ass_attribute13 :=
1622: per_asg_shd.g_old_rec.ass_attribute13;
1618: per_asg_shd.g_old_rec.ass_attribute12;
1619: End If;
1620: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1621: p_rec.ass_attribute13 :=
1622: per_asg_shd.g_old_rec.ass_attribute13;
1623: End If;
1624: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1625: p_rec.ass_attribute14 :=
1626: per_asg_shd.g_old_rec.ass_attribute14;
1622: per_asg_shd.g_old_rec.ass_attribute13;
1623: End If;
1624: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1625: p_rec.ass_attribute14 :=
1626: per_asg_shd.g_old_rec.ass_attribute14;
1627: End If;
1628: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1629: p_rec.ass_attribute15 :=
1630: per_asg_shd.g_old_rec.ass_attribute15;
1626: per_asg_shd.g_old_rec.ass_attribute14;
1627: End If;
1628: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1629: p_rec.ass_attribute15 :=
1630: per_asg_shd.g_old_rec.ass_attribute15;
1631: End If;
1632: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1633: p_rec.ass_attribute16 :=
1634: per_asg_shd.g_old_rec.ass_attribute16;
1630: per_asg_shd.g_old_rec.ass_attribute15;
1631: End If;
1632: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1633: p_rec.ass_attribute16 :=
1634: per_asg_shd.g_old_rec.ass_attribute16;
1635: End If;
1636: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1637: p_rec.ass_attribute17 :=
1638: per_asg_shd.g_old_rec.ass_attribute17;
1634: per_asg_shd.g_old_rec.ass_attribute16;
1635: End If;
1636: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1637: p_rec.ass_attribute17 :=
1638: per_asg_shd.g_old_rec.ass_attribute17;
1639: End If;
1640: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1641: p_rec.ass_attribute18 :=
1642: per_asg_shd.g_old_rec.ass_attribute18;
1638: per_asg_shd.g_old_rec.ass_attribute17;
1639: End If;
1640: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1641: p_rec.ass_attribute18 :=
1642: per_asg_shd.g_old_rec.ass_attribute18;
1643: End If;
1644: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1645: p_rec.ass_attribute19 :=
1646: per_asg_shd.g_old_rec.ass_attribute19;
1642: per_asg_shd.g_old_rec.ass_attribute18;
1643: End If;
1644: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1645: p_rec.ass_attribute19 :=
1646: per_asg_shd.g_old_rec.ass_attribute19;
1647: End If;
1648: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1649: p_rec.ass_attribute20 :=
1650: per_asg_shd.g_old_rec.ass_attribute20;
1646: per_asg_shd.g_old_rec.ass_attribute19;
1647: End If;
1648: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1649: p_rec.ass_attribute20 :=
1650: per_asg_shd.g_old_rec.ass_attribute20;
1651: End If;
1652: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1653: p_rec.ass_attribute21 :=
1654: per_asg_shd.g_old_rec.ass_attribute21;
1650: per_asg_shd.g_old_rec.ass_attribute20;
1651: End If;
1652: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1653: p_rec.ass_attribute21 :=
1654: per_asg_shd.g_old_rec.ass_attribute21;
1655: End If;
1656: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1657: p_rec.ass_attribute22 :=
1658: per_asg_shd.g_old_rec.ass_attribute22;
1654: per_asg_shd.g_old_rec.ass_attribute21;
1655: End If;
1656: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1657: p_rec.ass_attribute22 :=
1658: per_asg_shd.g_old_rec.ass_attribute22;
1659: End If;
1660: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1661: p_rec.ass_attribute23 :=
1662: per_asg_shd.g_old_rec.ass_attribute23;
1658: per_asg_shd.g_old_rec.ass_attribute22;
1659: End If;
1660: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1661: p_rec.ass_attribute23 :=
1662: per_asg_shd.g_old_rec.ass_attribute23;
1663: End If;
1664: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1665: p_rec.ass_attribute24 :=
1666: per_asg_shd.g_old_rec.ass_attribute24;
1662: per_asg_shd.g_old_rec.ass_attribute23;
1663: End If;
1664: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1665: p_rec.ass_attribute24 :=
1666: per_asg_shd.g_old_rec.ass_attribute24;
1667: End If;
1668: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1669: p_rec.ass_attribute25 :=
1670: per_asg_shd.g_old_rec.ass_attribute25;
1666: per_asg_shd.g_old_rec.ass_attribute24;
1667: End If;
1668: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1669: p_rec.ass_attribute25 :=
1670: per_asg_shd.g_old_rec.ass_attribute25;
1671: End If;
1672: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1673: p_rec.ass_attribute26 :=
1674: per_asg_shd.g_old_rec.ass_attribute26;
1670: per_asg_shd.g_old_rec.ass_attribute25;
1671: End If;
1672: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1673: p_rec.ass_attribute26 :=
1674: per_asg_shd.g_old_rec.ass_attribute26;
1675: End If;
1676: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1677: p_rec.ass_attribute27 :=
1678: per_asg_shd.g_old_rec.ass_attribute27;
1674: per_asg_shd.g_old_rec.ass_attribute26;
1675: End If;
1676: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1677: p_rec.ass_attribute27 :=
1678: per_asg_shd.g_old_rec.ass_attribute27;
1679: End If;
1680: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1681: p_rec.ass_attribute28 :=
1682: per_asg_shd.g_old_rec.ass_attribute28;
1678: per_asg_shd.g_old_rec.ass_attribute27;
1679: End If;
1680: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1681: p_rec.ass_attribute28 :=
1682: per_asg_shd.g_old_rec.ass_attribute28;
1683: End If;
1684: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1685: p_rec.ass_attribute29 :=
1686: per_asg_shd.g_old_rec.ass_attribute29;
1682: per_asg_shd.g_old_rec.ass_attribute28;
1683: End If;
1684: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1685: p_rec.ass_attribute29 :=
1686: per_asg_shd.g_old_rec.ass_attribute29;
1687: End If;
1688: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1689: p_rec.ass_attribute30 :=
1690: per_asg_shd.g_old_rec.ass_attribute30;
1686: per_asg_shd.g_old_rec.ass_attribute29;
1687: End If;
1688: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1689: p_rec.ass_attribute30 :=
1690: per_asg_shd.g_old_rec.ass_attribute30;
1691: End If;
1692: If (p_rec.title = hr_api.g_varchar2) then
1693: p_rec.title :=
1694: per_asg_shd.g_old_rec.title;
1690: per_asg_shd.g_old_rec.ass_attribute30;
1691: End If;
1692: If (p_rec.title = hr_api.g_varchar2) then
1693: p_rec.title :=
1694: per_asg_shd.g_old_rec.title;
1695: End If;
1696: If (p_rec.contract_id = hr_api.g_number) then
1697: p_rec.contract_id :=
1698: per_asg_shd.g_old_rec.contract_id;
1694: per_asg_shd.g_old_rec.title;
1695: End If;
1696: If (p_rec.contract_id = hr_api.g_number) then
1697: p_rec.contract_id :=
1698: per_asg_shd.g_old_rec.contract_id;
1699: End If;
1700: If (p_rec.establishment_id = hr_api.g_number) then
1701: p_rec.establishment_id :=
1702: per_asg_shd.g_old_rec.establishment_id;
1698: per_asg_shd.g_old_rec.contract_id;
1699: End If;
1700: If (p_rec.establishment_id = hr_api.g_number) then
1701: p_rec.establishment_id :=
1702: per_asg_shd.g_old_rec.establishment_id;
1703: End If;
1704: If (p_rec.collective_agreement_id = hr_api.g_number) then
1705: p_rec.collective_agreement_id :=
1706: per_asg_shd.g_old_rec.collective_agreement_id;
1702: per_asg_shd.g_old_rec.establishment_id;
1703: End If;
1704: If (p_rec.collective_agreement_id = hr_api.g_number) then
1705: p_rec.collective_agreement_id :=
1706: per_asg_shd.g_old_rec.collective_agreement_id;
1707: End If;
1708: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1709: p_rec.cagr_grade_def_id :=
1710: per_asg_shd.g_old_rec.cagr_grade_def_id;
1706: per_asg_shd.g_old_rec.collective_agreement_id;
1707: End If;
1708: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1709: p_rec.cagr_grade_def_id :=
1710: per_asg_shd.g_old_rec.cagr_grade_def_id;
1711: End If;
1712: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1713: p_rec.cagr_id_flex_num :=
1714: per_asg_shd.g_old_rec.cagr_id_flex_num;
1710: per_asg_shd.g_old_rec.cagr_grade_def_id;
1711: End If;
1712: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1713: p_rec.cagr_id_flex_num :=
1714: per_asg_shd.g_old_rec.cagr_id_flex_num;
1715: End If;
1716: If (p_rec.notice_period = hr_api.g_number) then
1717: p_rec.notice_period :=
1718: per_asg_shd.g_old_rec.notice_period;
1714: per_asg_shd.g_old_rec.cagr_id_flex_num;
1715: End If;
1716: If (p_rec.notice_period = hr_api.g_number) then
1717: p_rec.notice_period :=
1718: per_asg_shd.g_old_rec.notice_period;
1719: End If;
1720: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1721: p_rec.notice_period_uom :=
1722: per_asg_shd.g_old_rec.notice_period_uom;
1718: per_asg_shd.g_old_rec.notice_period;
1719: End If;
1720: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1721: p_rec.notice_period_uom :=
1722: per_asg_shd.g_old_rec.notice_period_uom;
1723: End If;
1724: If (p_rec.employee_category = hr_api.g_varchar2) then
1725: p_rec.employee_category :=
1726: per_asg_shd.g_old_rec.employee_category;
1722: per_asg_shd.g_old_rec.notice_period_uom;
1723: End If;
1724: If (p_rec.employee_category = hr_api.g_varchar2) then
1725: p_rec.employee_category :=
1726: per_asg_shd.g_old_rec.employee_category;
1727: End If;
1728: If (p_rec.work_at_home = hr_api.g_varchar2) then
1729: p_rec.work_at_home :=
1730: per_asg_shd.g_old_rec.work_at_home;
1726: per_asg_shd.g_old_rec.employee_category;
1727: End If;
1728: If (p_rec.work_at_home = hr_api.g_varchar2) then
1729: p_rec.work_at_home :=
1730: per_asg_shd.g_old_rec.work_at_home;
1731: End If;
1732: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1733: p_rec.job_post_source_name :=
1734: per_asg_shd.g_old_rec.job_post_source_name;
1730: per_asg_shd.g_old_rec.work_at_home;
1731: End If;
1732: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1733: p_rec.job_post_source_name :=
1734: per_asg_shd.g_old_rec.job_post_source_name;
1735: End If;
1736: If (p_rec.posting_content_id = hr_api.g_number) then
1737: p_rec.posting_content_id :=
1738: per_asg_shd.g_old_rec.posting_content_id;
1734: per_asg_shd.g_old_rec.job_post_source_name;
1735: End If;
1736: If (p_rec.posting_content_id = hr_api.g_number) then
1737: p_rec.posting_content_id :=
1738: per_asg_shd.g_old_rec.posting_content_id;
1739: End If;
1740: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1741: p_rec.period_of_placement_date_start :=
1742: per_asg_shd.g_old_rec.period_of_placement_date_start;
1738: per_asg_shd.g_old_rec.posting_content_id;
1739: End If;
1740: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1741: p_rec.period_of_placement_date_start :=
1742: per_asg_shd.g_old_rec.period_of_placement_date_start;
1743: End If;
1744: If (p_rec.vendor_id = hr_api.g_number) then
1745: p_rec.vendor_id :=
1746: per_asg_shd.g_old_rec.vendor_id;
1742: per_asg_shd.g_old_rec.period_of_placement_date_start;
1743: End If;
1744: If (p_rec.vendor_id = hr_api.g_number) then
1745: p_rec.vendor_id :=
1746: per_asg_shd.g_old_rec.vendor_id;
1747: End If;
1748: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1749: p_rec.vendor_employee_number :=
1750: per_asg_shd.g_old_rec.vendor_employee_number;
1746: per_asg_shd.g_old_rec.vendor_id;
1747: End If;
1748: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1749: p_rec.vendor_employee_number :=
1750: per_asg_shd.g_old_rec.vendor_employee_number;
1751: End If;
1752: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1753: p_rec.vendor_assignment_number :=
1754: per_asg_shd.g_old_rec.vendor_assignment_number;
1750: per_asg_shd.g_old_rec.vendor_employee_number;
1751: End If;
1752: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1753: p_rec.vendor_assignment_number :=
1754: per_asg_shd.g_old_rec.vendor_assignment_number;
1755: End If;
1756: If (p_rec.assignment_category = hr_api.g_varchar2) then
1757: p_rec.assignment_category :=
1758: per_asg_shd.g_old_rec.assignment_category;
1754: per_asg_shd.g_old_rec.vendor_assignment_number;
1755: End If;
1756: If (p_rec.assignment_category = hr_api.g_varchar2) then
1757: p_rec.assignment_category :=
1758: per_asg_shd.g_old_rec.assignment_category;
1759: End If;
1760: If (p_rec.project_title = hr_api.g_varchar2) then
1761: p_rec.project_title :=
1762: per_asg_shd.g_old_rec.project_title;
1758: per_asg_shd.g_old_rec.assignment_category;
1759: End If;
1760: If (p_rec.project_title = hr_api.g_varchar2) then
1761: p_rec.project_title :=
1762: per_asg_shd.g_old_rec.project_title;
1763: End If;
1764: If (p_rec.applicant_rank = hr_api.g_number) then
1765: p_rec.applicant_rank :=
1766: per_asg_shd.g_old_rec.applicant_rank;
1762: per_asg_shd.g_old_rec.project_title;
1763: End If;
1764: If (p_rec.applicant_rank = hr_api.g_number) then
1765: p_rec.applicant_rank :=
1766: per_asg_shd.g_old_rec.applicant_rank;
1767: End If;
1768: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1769: p_rec.grade_ladder_pgm_id :=
1770: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1766: per_asg_shd.g_old_rec.applicant_rank;
1767: End If;
1768: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1769: p_rec.grade_ladder_pgm_id :=
1770: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1771: End If;
1772: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1773: p_rec.supervisor_assignment_id :=
1774: per_asg_shd.g_old_rec.supervisor_assignment_id;
1770: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1771: End If;
1772: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1773: p_rec.supervisor_assignment_id :=
1774: per_asg_shd.g_old_rec.supervisor_assignment_id;
1775: End If;
1776: If (p_rec.vendor_site_id = hr_api.g_number) then
1777: p_rec.vendor_site_id :=
1778: per_asg_shd.g_old_rec.vendor_site_id;
1774: per_asg_shd.g_old_rec.supervisor_assignment_id;
1775: End If;
1776: If (p_rec.vendor_site_id = hr_api.g_number) then
1777: p_rec.vendor_site_id :=
1778: per_asg_shd.g_old_rec.vendor_site_id;
1779: End If;
1780: If (p_rec.po_header_id = hr_api.g_number) then
1781: p_rec.po_header_id :=
1782: per_asg_shd.g_old_rec.po_header_id;
1778: per_asg_shd.g_old_rec.vendor_site_id;
1779: End If;
1780: If (p_rec.po_header_id = hr_api.g_number) then
1781: p_rec.po_header_id :=
1782: per_asg_shd.g_old_rec.po_header_id;
1783: End If;
1784: If (p_rec.po_line_id = hr_api.g_number) then
1785: p_rec.po_line_id :=
1786: per_asg_shd.g_old_rec.po_line_id;
1782: per_asg_shd.g_old_rec.po_header_id;
1783: End If;
1784: If (p_rec.po_line_id = hr_api.g_number) then
1785: p_rec.po_line_id :=
1786: per_asg_shd.g_old_rec.po_line_id;
1787: End If;
1788: If (p_rec.projected_assignment_end = hr_api.g_date) then
1789: p_rec.projected_assignment_end :=
1790: per_asg_shd.g_old_rec.projected_assignment_end;
1786: per_asg_shd.g_old_rec.po_line_id;
1787: End If;
1788: If (p_rec.projected_assignment_end = hr_api.g_date) then
1789: p_rec.projected_assignment_end :=
1790: per_asg_shd.g_old_rec.projected_assignment_end;
1791: End If;
1792: --
1793: hr_utility.set_location(' Leaving:'||l_proc, 10);
1794: --
1798: -- |---------------------------------< upd >----------------------------------|
1799: -- ----------------------------------------------------------------------------
1800: Procedure upd
1801: (
1802: p_rec in out nocopy per_asg_shd.g_rec_type,
1803: p_effective_date in date,
1804: p_datetrack_mode in varchar2,
1805: p_validation_start_date out nocopy date,
1806: p_validation_end_date out nocopy date,
1948: where assignment_id = p_rec.assignment_id
1949: and p_effective_date between effective_start_date
1950: and effective_end_date;
1951:
1952: l_old_rec per_asg_shd.g_old_rec%type;
1953: l_old_rowid rowid;
1954: -- End changes for bug 13059935
1955: --
1956: Begin
1971: End If;
1972: --
1973: -- We must lock the row which we need to update.
1974: --
1975: per_asg_shd.lck
1976: (p_effective_date => p_effective_date,
1977: p_datetrack_mode => p_datetrack_mode,
1978: p_assignment_id => p_rec.assignment_id,
1979: p_object_version_number => p_rec.object_version_number,
2224: p_datetrack_mode in varchar2,
2225: p_validate in boolean default false
2226: ) is
2227: --
2228: l_rec per_asg_shd.g_rec_type;
2229:
2230: l_proc varchar2(72) := g_package||'upd';
2231: --
2232: Begin
2235: -- Call conversion function to turn arguments into the
2236: -- l_rec structure.
2237: --
2238: l_rec :=
2239: per_asg_shd.convert_args
2240: (
2241: p_assignment_id,
2242: null,
2243: