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;
603: --
604: -- {End Of Comments}
605: -- ----------------------------------------------------------------------------
606: Procedure post_update
607: (p_rec in per_asg_shd.g_rec_type,
608: p_effective_date in date,
609: p_datetrack_mode in varchar2,
610: p_validation_start_date in date,
611: p_validation_end_date in date,
741: ,p_po_header_id => p_rec.po_header_id
742: ,p_po_line_id => p_rec.po_line_id
743: ,p_projected_assignment_end => p_rec.projected_assignment_end
744: ,p_effective_start_date_o
745: => per_asg_shd.g_old_rec.effective_start_date
746: ,p_effective_end_date_o
747: => per_asg_shd.g_old_rec.effective_end_date
748: ,p_business_group_id_o
749: => per_asg_shd.g_old_rec.business_group_id
743: ,p_projected_assignment_end => p_rec.projected_assignment_end
744: ,p_effective_start_date_o
745: => per_asg_shd.g_old_rec.effective_start_date
746: ,p_effective_end_date_o
747: => per_asg_shd.g_old_rec.effective_end_date
748: ,p_business_group_id_o
749: => per_asg_shd.g_old_rec.business_group_id
750: ,p_recruiter_id_o
751: => per_asg_shd.g_old_rec.recruiter_id
745: => per_asg_shd.g_old_rec.effective_start_date
746: ,p_effective_end_date_o
747: => per_asg_shd.g_old_rec.effective_end_date
748: ,p_business_group_id_o
749: => per_asg_shd.g_old_rec.business_group_id
750: ,p_recruiter_id_o
751: => per_asg_shd.g_old_rec.recruiter_id
752: ,p_grade_id_o
753: => per_asg_shd.g_old_rec.grade_id
747: => per_asg_shd.g_old_rec.effective_end_date
748: ,p_business_group_id_o
749: => per_asg_shd.g_old_rec.business_group_id
750: ,p_recruiter_id_o
751: => per_asg_shd.g_old_rec.recruiter_id
752: ,p_grade_id_o
753: => per_asg_shd.g_old_rec.grade_id
754: ,p_position_id_o
755: => per_asg_shd.g_old_rec.position_id
749: => per_asg_shd.g_old_rec.business_group_id
750: ,p_recruiter_id_o
751: => per_asg_shd.g_old_rec.recruiter_id
752: ,p_grade_id_o
753: => per_asg_shd.g_old_rec.grade_id
754: ,p_position_id_o
755: => per_asg_shd.g_old_rec.position_id
756: ,p_job_id_o
757: => per_asg_shd.g_old_rec.job_id
751: => per_asg_shd.g_old_rec.recruiter_id
752: ,p_grade_id_o
753: => per_asg_shd.g_old_rec.grade_id
754: ,p_position_id_o
755: => per_asg_shd.g_old_rec.position_id
756: ,p_job_id_o
757: => per_asg_shd.g_old_rec.job_id
758: ,p_assignment_status_type_id_o
759: => per_asg_shd.g_old_rec.assignment_status_type_id
753: => per_asg_shd.g_old_rec.grade_id
754: ,p_position_id_o
755: => per_asg_shd.g_old_rec.position_id
756: ,p_job_id_o
757: => per_asg_shd.g_old_rec.job_id
758: ,p_assignment_status_type_id_o
759: => per_asg_shd.g_old_rec.assignment_status_type_id
760: ,p_payroll_id_o
761: => per_asg_shd.g_old_rec.payroll_id
755: => per_asg_shd.g_old_rec.position_id
756: ,p_job_id_o
757: => per_asg_shd.g_old_rec.job_id
758: ,p_assignment_status_type_id_o
759: => per_asg_shd.g_old_rec.assignment_status_type_id
760: ,p_payroll_id_o
761: => per_asg_shd.g_old_rec.payroll_id
762: ,p_location_id_o
763: => per_asg_shd.g_old_rec.location_id
757: => per_asg_shd.g_old_rec.job_id
758: ,p_assignment_status_type_id_o
759: => per_asg_shd.g_old_rec.assignment_status_type_id
760: ,p_payroll_id_o
761: => per_asg_shd.g_old_rec.payroll_id
762: ,p_location_id_o
763: => per_asg_shd.g_old_rec.location_id
764: ,p_person_referred_by_id_o
765: => per_asg_shd.g_old_rec.person_referred_by_id
759: => per_asg_shd.g_old_rec.assignment_status_type_id
760: ,p_payroll_id_o
761: => per_asg_shd.g_old_rec.payroll_id
762: ,p_location_id_o
763: => per_asg_shd.g_old_rec.location_id
764: ,p_person_referred_by_id_o
765: => per_asg_shd.g_old_rec.person_referred_by_id
766: ,p_supervisor_id_o
767: => per_asg_shd.g_old_rec.supervisor_id
761: => per_asg_shd.g_old_rec.payroll_id
762: ,p_location_id_o
763: => per_asg_shd.g_old_rec.location_id
764: ,p_person_referred_by_id_o
765: => per_asg_shd.g_old_rec.person_referred_by_id
766: ,p_supervisor_id_o
767: => per_asg_shd.g_old_rec.supervisor_id
768: ,p_special_ceiling_step_id_o
769: => per_asg_shd.g_old_rec.special_ceiling_step_id
763: => per_asg_shd.g_old_rec.location_id
764: ,p_person_referred_by_id_o
765: => per_asg_shd.g_old_rec.person_referred_by_id
766: ,p_supervisor_id_o
767: => per_asg_shd.g_old_rec.supervisor_id
768: ,p_special_ceiling_step_id_o
769: => per_asg_shd.g_old_rec.special_ceiling_step_id
770: ,p_person_id_o
771: => per_asg_shd.g_old_rec.person_id
765: => per_asg_shd.g_old_rec.person_referred_by_id
766: ,p_supervisor_id_o
767: => per_asg_shd.g_old_rec.supervisor_id
768: ,p_special_ceiling_step_id_o
769: => per_asg_shd.g_old_rec.special_ceiling_step_id
770: ,p_person_id_o
771: => per_asg_shd.g_old_rec.person_id
772: ,p_recruitment_activity_id_o
773: => per_asg_shd.g_old_rec.recruitment_activity_id
767: => per_asg_shd.g_old_rec.supervisor_id
768: ,p_special_ceiling_step_id_o
769: => per_asg_shd.g_old_rec.special_ceiling_step_id
770: ,p_person_id_o
771: => per_asg_shd.g_old_rec.person_id
772: ,p_recruitment_activity_id_o
773: => per_asg_shd.g_old_rec.recruitment_activity_id
774: ,p_source_organization_id_o
775: => per_asg_shd.g_old_rec.source_organization_id
769: => per_asg_shd.g_old_rec.special_ceiling_step_id
770: ,p_person_id_o
771: => per_asg_shd.g_old_rec.person_id
772: ,p_recruitment_activity_id_o
773: => per_asg_shd.g_old_rec.recruitment_activity_id
774: ,p_source_organization_id_o
775: => per_asg_shd.g_old_rec.source_organization_id
776: ,p_organization_id_o
777: => per_asg_shd.g_old_rec.organization_id
771: => per_asg_shd.g_old_rec.person_id
772: ,p_recruitment_activity_id_o
773: => per_asg_shd.g_old_rec.recruitment_activity_id
774: ,p_source_organization_id_o
775: => per_asg_shd.g_old_rec.source_organization_id
776: ,p_organization_id_o
777: => per_asg_shd.g_old_rec.organization_id
778: ,p_people_group_id_o
779: => per_asg_shd.g_old_rec.people_group_id
773: => per_asg_shd.g_old_rec.recruitment_activity_id
774: ,p_source_organization_id_o
775: => per_asg_shd.g_old_rec.source_organization_id
776: ,p_organization_id_o
777: => per_asg_shd.g_old_rec.organization_id
778: ,p_people_group_id_o
779: => per_asg_shd.g_old_rec.people_group_id
780: ,p_soft_coding_keyflex_id_o
781: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
775: => per_asg_shd.g_old_rec.source_organization_id
776: ,p_organization_id_o
777: => per_asg_shd.g_old_rec.organization_id
778: ,p_people_group_id_o
779: => per_asg_shd.g_old_rec.people_group_id
780: ,p_soft_coding_keyflex_id_o
781: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
782: ,p_vacancy_id_o
783: => per_asg_shd.g_old_rec.vacancy_id
777: => per_asg_shd.g_old_rec.organization_id
778: ,p_people_group_id_o
779: => per_asg_shd.g_old_rec.people_group_id
780: ,p_soft_coding_keyflex_id_o
781: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
782: ,p_vacancy_id_o
783: => per_asg_shd.g_old_rec.vacancy_id
784: ,p_assignment_sequence_o
785: => per_asg_shd.g_old_rec.assignment_sequence
779: => per_asg_shd.g_old_rec.people_group_id
780: ,p_soft_coding_keyflex_id_o
781: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
782: ,p_vacancy_id_o
783: => per_asg_shd.g_old_rec.vacancy_id
784: ,p_assignment_sequence_o
785: => per_asg_shd.g_old_rec.assignment_sequence
786: ,p_pay_basis_id_o
787: => per_asg_shd.g_old_rec.pay_basis_id
781: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
782: ,p_vacancy_id_o
783: => per_asg_shd.g_old_rec.vacancy_id
784: ,p_assignment_sequence_o
785: => per_asg_shd.g_old_rec.assignment_sequence
786: ,p_pay_basis_id_o
787: => per_asg_shd.g_old_rec.pay_basis_id
788: ,p_assignment_type_o
789: => per_asg_shd.g_old_rec.assignment_type
783: => per_asg_shd.g_old_rec.vacancy_id
784: ,p_assignment_sequence_o
785: => per_asg_shd.g_old_rec.assignment_sequence
786: ,p_pay_basis_id_o
787: => per_asg_shd.g_old_rec.pay_basis_id
788: ,p_assignment_type_o
789: => per_asg_shd.g_old_rec.assignment_type
790: ,p_primary_flag_o
791: => per_asg_shd.g_old_rec.primary_flag
785: => per_asg_shd.g_old_rec.assignment_sequence
786: ,p_pay_basis_id_o
787: => per_asg_shd.g_old_rec.pay_basis_id
788: ,p_assignment_type_o
789: => per_asg_shd.g_old_rec.assignment_type
790: ,p_primary_flag_o
791: => per_asg_shd.g_old_rec.primary_flag
792: ,p_application_id_o
793: => per_asg_shd.g_old_rec.application_id
787: => per_asg_shd.g_old_rec.pay_basis_id
788: ,p_assignment_type_o
789: => per_asg_shd.g_old_rec.assignment_type
790: ,p_primary_flag_o
791: => per_asg_shd.g_old_rec.primary_flag
792: ,p_application_id_o
793: => per_asg_shd.g_old_rec.application_id
794: ,p_assignment_number_o
795: => per_asg_shd.g_old_rec.assignment_number
789: => per_asg_shd.g_old_rec.assignment_type
790: ,p_primary_flag_o
791: => per_asg_shd.g_old_rec.primary_flag
792: ,p_application_id_o
793: => per_asg_shd.g_old_rec.application_id
794: ,p_assignment_number_o
795: => per_asg_shd.g_old_rec.assignment_number
796: ,p_change_reason_o
797: => per_asg_shd.g_old_rec.change_reason
791: => per_asg_shd.g_old_rec.primary_flag
792: ,p_application_id_o
793: => per_asg_shd.g_old_rec.application_id
794: ,p_assignment_number_o
795: => per_asg_shd.g_old_rec.assignment_number
796: ,p_change_reason_o
797: => per_asg_shd.g_old_rec.change_reason
798: ,p_comment_id_o
799: => per_asg_shd.g_old_rec.comment_id
793: => per_asg_shd.g_old_rec.application_id
794: ,p_assignment_number_o
795: => per_asg_shd.g_old_rec.assignment_number
796: ,p_change_reason_o
797: => per_asg_shd.g_old_rec.change_reason
798: ,p_comment_id_o
799: => per_asg_shd.g_old_rec.comment_id
800: ,p_date_probation_end_o
801: => per_asg_shd.g_old_rec.date_probation_end
795: => per_asg_shd.g_old_rec.assignment_number
796: ,p_change_reason_o
797: => per_asg_shd.g_old_rec.change_reason
798: ,p_comment_id_o
799: => per_asg_shd.g_old_rec.comment_id
800: ,p_date_probation_end_o
801: => per_asg_shd.g_old_rec.date_probation_end
802: ,p_default_code_comb_id_o
803: => per_asg_shd.g_old_rec.default_code_comb_id
797: => per_asg_shd.g_old_rec.change_reason
798: ,p_comment_id_o
799: => per_asg_shd.g_old_rec.comment_id
800: ,p_date_probation_end_o
801: => per_asg_shd.g_old_rec.date_probation_end
802: ,p_default_code_comb_id_o
803: => per_asg_shd.g_old_rec.default_code_comb_id
804: ,p_employment_category_o
805: => per_asg_shd.g_old_rec.employment_category
799: => per_asg_shd.g_old_rec.comment_id
800: ,p_date_probation_end_o
801: => per_asg_shd.g_old_rec.date_probation_end
802: ,p_default_code_comb_id_o
803: => per_asg_shd.g_old_rec.default_code_comb_id
804: ,p_employment_category_o
805: => per_asg_shd.g_old_rec.employment_category
806: ,p_frequency_o
807: => per_asg_shd.g_old_rec.frequency
801: => per_asg_shd.g_old_rec.date_probation_end
802: ,p_default_code_comb_id_o
803: => per_asg_shd.g_old_rec.default_code_comb_id
804: ,p_employment_category_o
805: => per_asg_shd.g_old_rec.employment_category
806: ,p_frequency_o
807: => per_asg_shd.g_old_rec.frequency
808: ,p_internal_address_line_o
809: => per_asg_shd.g_old_rec.internal_address_line
803: => per_asg_shd.g_old_rec.default_code_comb_id
804: ,p_employment_category_o
805: => per_asg_shd.g_old_rec.employment_category
806: ,p_frequency_o
807: => per_asg_shd.g_old_rec.frequency
808: ,p_internal_address_line_o
809: => per_asg_shd.g_old_rec.internal_address_line
810: ,p_manager_flag_o
811: => per_asg_shd.g_old_rec.manager_flag
805: => per_asg_shd.g_old_rec.employment_category
806: ,p_frequency_o
807: => per_asg_shd.g_old_rec.frequency
808: ,p_internal_address_line_o
809: => per_asg_shd.g_old_rec.internal_address_line
810: ,p_manager_flag_o
811: => per_asg_shd.g_old_rec.manager_flag
812: ,p_normal_hours_o
813: => per_asg_shd.g_old_rec.normal_hours
807: => per_asg_shd.g_old_rec.frequency
808: ,p_internal_address_line_o
809: => per_asg_shd.g_old_rec.internal_address_line
810: ,p_manager_flag_o
811: => per_asg_shd.g_old_rec.manager_flag
812: ,p_normal_hours_o
813: => per_asg_shd.g_old_rec.normal_hours
814: ,p_perf_review_period_o
815: => per_asg_shd.g_old_rec.perf_review_period
809: => per_asg_shd.g_old_rec.internal_address_line
810: ,p_manager_flag_o
811: => per_asg_shd.g_old_rec.manager_flag
812: ,p_normal_hours_o
813: => per_asg_shd.g_old_rec.normal_hours
814: ,p_perf_review_period_o
815: => per_asg_shd.g_old_rec.perf_review_period
816: ,p_perf_review_period_frequen_o
817: => per_asg_shd.g_old_rec.perf_review_period_frequency
811: => per_asg_shd.g_old_rec.manager_flag
812: ,p_normal_hours_o
813: => per_asg_shd.g_old_rec.normal_hours
814: ,p_perf_review_period_o
815: => per_asg_shd.g_old_rec.perf_review_period
816: ,p_perf_review_period_frequen_o
817: => per_asg_shd.g_old_rec.perf_review_period_frequency
818: ,p_period_of_service_id_o
819: => per_asg_shd.g_old_rec.period_of_service_id
813: => per_asg_shd.g_old_rec.normal_hours
814: ,p_perf_review_period_o
815: => per_asg_shd.g_old_rec.perf_review_period
816: ,p_perf_review_period_frequen_o
817: => per_asg_shd.g_old_rec.perf_review_period_frequency
818: ,p_period_of_service_id_o
819: => per_asg_shd.g_old_rec.period_of_service_id
820: ,p_probation_period_o
821: => per_asg_shd.g_old_rec.probation_period
815: => per_asg_shd.g_old_rec.perf_review_period
816: ,p_perf_review_period_frequen_o
817: => per_asg_shd.g_old_rec.perf_review_period_frequency
818: ,p_period_of_service_id_o
819: => per_asg_shd.g_old_rec.period_of_service_id
820: ,p_probation_period_o
821: => per_asg_shd.g_old_rec.probation_period
822: ,p_probation_unit_o
823: => per_asg_shd.g_old_rec.probation_unit
817: => per_asg_shd.g_old_rec.perf_review_period_frequency
818: ,p_period_of_service_id_o
819: => per_asg_shd.g_old_rec.period_of_service_id
820: ,p_probation_period_o
821: => per_asg_shd.g_old_rec.probation_period
822: ,p_probation_unit_o
823: => per_asg_shd.g_old_rec.probation_unit
824: ,p_sal_review_period_o
825: => per_asg_shd.g_old_rec.sal_review_period
819: => per_asg_shd.g_old_rec.period_of_service_id
820: ,p_probation_period_o
821: => per_asg_shd.g_old_rec.probation_period
822: ,p_probation_unit_o
823: => per_asg_shd.g_old_rec.probation_unit
824: ,p_sal_review_period_o
825: => per_asg_shd.g_old_rec.sal_review_period
826: ,p_sal_review_period_frequen_o
827: => per_asg_shd.g_old_rec.sal_review_period_frequency
821: => per_asg_shd.g_old_rec.probation_period
822: ,p_probation_unit_o
823: => per_asg_shd.g_old_rec.probation_unit
824: ,p_sal_review_period_o
825: => per_asg_shd.g_old_rec.sal_review_period
826: ,p_sal_review_period_frequen_o
827: => per_asg_shd.g_old_rec.sal_review_period_frequency
828: ,p_set_of_books_id_o
829: => per_asg_shd.g_old_rec.set_of_books_id
823: => per_asg_shd.g_old_rec.probation_unit
824: ,p_sal_review_period_o
825: => per_asg_shd.g_old_rec.sal_review_period
826: ,p_sal_review_period_frequen_o
827: => per_asg_shd.g_old_rec.sal_review_period_frequency
828: ,p_set_of_books_id_o
829: => per_asg_shd.g_old_rec.set_of_books_id
830: ,p_source_type_o
831: => per_asg_shd.g_old_rec.source_type
825: => per_asg_shd.g_old_rec.sal_review_period
826: ,p_sal_review_period_frequen_o
827: => per_asg_shd.g_old_rec.sal_review_period_frequency
828: ,p_set_of_books_id_o
829: => per_asg_shd.g_old_rec.set_of_books_id
830: ,p_source_type_o
831: => per_asg_shd.g_old_rec.source_type
832: ,p_time_normal_finish_o
833: => per_asg_shd.g_old_rec.time_normal_finish
827: => per_asg_shd.g_old_rec.sal_review_period_frequency
828: ,p_set_of_books_id_o
829: => per_asg_shd.g_old_rec.set_of_books_id
830: ,p_source_type_o
831: => per_asg_shd.g_old_rec.source_type
832: ,p_time_normal_finish_o
833: => per_asg_shd.g_old_rec.time_normal_finish
834: ,p_time_normal_start_o
835: => per_asg_shd.g_old_rec.time_normal_start
829: => per_asg_shd.g_old_rec.set_of_books_id
830: ,p_source_type_o
831: => per_asg_shd.g_old_rec.source_type
832: ,p_time_normal_finish_o
833: => per_asg_shd.g_old_rec.time_normal_finish
834: ,p_time_normal_start_o
835: => per_asg_shd.g_old_rec.time_normal_start
836: ,p_bargaining_unit_code_o
837: => per_asg_shd.g_old_rec.bargaining_unit_code
831: => per_asg_shd.g_old_rec.source_type
832: ,p_time_normal_finish_o
833: => per_asg_shd.g_old_rec.time_normal_finish
834: ,p_time_normal_start_o
835: => per_asg_shd.g_old_rec.time_normal_start
836: ,p_bargaining_unit_code_o
837: => per_asg_shd.g_old_rec.bargaining_unit_code
838: ,p_labour_union_member_flag_o
839: => per_asg_shd.g_old_rec.labour_union_member_flag
833: => per_asg_shd.g_old_rec.time_normal_finish
834: ,p_time_normal_start_o
835: => per_asg_shd.g_old_rec.time_normal_start
836: ,p_bargaining_unit_code_o
837: => per_asg_shd.g_old_rec.bargaining_unit_code
838: ,p_labour_union_member_flag_o
839: => per_asg_shd.g_old_rec.labour_union_member_flag
840: ,p_hourly_salaried_code_o
841: => per_asg_shd.g_old_rec.hourly_salaried_code
835: => per_asg_shd.g_old_rec.time_normal_start
836: ,p_bargaining_unit_code_o
837: => per_asg_shd.g_old_rec.bargaining_unit_code
838: ,p_labour_union_member_flag_o
839: => per_asg_shd.g_old_rec.labour_union_member_flag
840: ,p_hourly_salaried_code_o
841: => per_asg_shd.g_old_rec.hourly_salaried_code
842: ,p_request_id_o
843: => per_asg_shd.g_old_rec.request_id
837: => per_asg_shd.g_old_rec.bargaining_unit_code
838: ,p_labour_union_member_flag_o
839: => per_asg_shd.g_old_rec.labour_union_member_flag
840: ,p_hourly_salaried_code_o
841: => per_asg_shd.g_old_rec.hourly_salaried_code
842: ,p_request_id_o
843: => per_asg_shd.g_old_rec.request_id
844: ,p_program_application_id_o
845: => per_asg_shd.g_old_rec.program_application_id
839: => per_asg_shd.g_old_rec.labour_union_member_flag
840: ,p_hourly_salaried_code_o
841: => per_asg_shd.g_old_rec.hourly_salaried_code
842: ,p_request_id_o
843: => per_asg_shd.g_old_rec.request_id
844: ,p_program_application_id_o
845: => per_asg_shd.g_old_rec.program_application_id
846: ,p_program_id_o
847: => per_asg_shd.g_old_rec.program_id
841: => per_asg_shd.g_old_rec.hourly_salaried_code
842: ,p_request_id_o
843: => per_asg_shd.g_old_rec.request_id
844: ,p_program_application_id_o
845: => per_asg_shd.g_old_rec.program_application_id
846: ,p_program_id_o
847: => per_asg_shd.g_old_rec.program_id
848: ,p_program_update_date_o
849: => per_asg_shd.g_old_rec.program_update_date
843: => per_asg_shd.g_old_rec.request_id
844: ,p_program_application_id_o
845: => per_asg_shd.g_old_rec.program_application_id
846: ,p_program_id_o
847: => per_asg_shd.g_old_rec.program_id
848: ,p_program_update_date_o
849: => per_asg_shd.g_old_rec.program_update_date
850: ,p_ass_attribute_category_o
851: => per_asg_shd.g_old_rec.ass_attribute_category
845: => per_asg_shd.g_old_rec.program_application_id
846: ,p_program_id_o
847: => per_asg_shd.g_old_rec.program_id
848: ,p_program_update_date_o
849: => per_asg_shd.g_old_rec.program_update_date
850: ,p_ass_attribute_category_o
851: => per_asg_shd.g_old_rec.ass_attribute_category
852: ,p_ass_attribute1_o
853: => per_asg_shd.g_old_rec.ass_attribute1
847: => per_asg_shd.g_old_rec.program_id
848: ,p_program_update_date_o
849: => per_asg_shd.g_old_rec.program_update_date
850: ,p_ass_attribute_category_o
851: => per_asg_shd.g_old_rec.ass_attribute_category
852: ,p_ass_attribute1_o
853: => per_asg_shd.g_old_rec.ass_attribute1
854: ,p_ass_attribute2_o
855: => per_asg_shd.g_old_rec.ass_attribute2
849: => per_asg_shd.g_old_rec.program_update_date
850: ,p_ass_attribute_category_o
851: => per_asg_shd.g_old_rec.ass_attribute_category
852: ,p_ass_attribute1_o
853: => per_asg_shd.g_old_rec.ass_attribute1
854: ,p_ass_attribute2_o
855: => per_asg_shd.g_old_rec.ass_attribute2
856: ,p_ass_attribute3_o
857: => per_asg_shd.g_old_rec.ass_attribute3
851: => per_asg_shd.g_old_rec.ass_attribute_category
852: ,p_ass_attribute1_o
853: => per_asg_shd.g_old_rec.ass_attribute1
854: ,p_ass_attribute2_o
855: => per_asg_shd.g_old_rec.ass_attribute2
856: ,p_ass_attribute3_o
857: => per_asg_shd.g_old_rec.ass_attribute3
858: ,p_ass_attribute4_o
859: => per_asg_shd.g_old_rec.ass_attribute4
853: => per_asg_shd.g_old_rec.ass_attribute1
854: ,p_ass_attribute2_o
855: => per_asg_shd.g_old_rec.ass_attribute2
856: ,p_ass_attribute3_o
857: => per_asg_shd.g_old_rec.ass_attribute3
858: ,p_ass_attribute4_o
859: => per_asg_shd.g_old_rec.ass_attribute4
860: ,p_ass_attribute5_o
861: => per_asg_shd.g_old_rec.ass_attribute5
855: => per_asg_shd.g_old_rec.ass_attribute2
856: ,p_ass_attribute3_o
857: => per_asg_shd.g_old_rec.ass_attribute3
858: ,p_ass_attribute4_o
859: => per_asg_shd.g_old_rec.ass_attribute4
860: ,p_ass_attribute5_o
861: => per_asg_shd.g_old_rec.ass_attribute5
862: ,p_ass_attribute6_o
863: => per_asg_shd.g_old_rec.ass_attribute6
857: => per_asg_shd.g_old_rec.ass_attribute3
858: ,p_ass_attribute4_o
859: => per_asg_shd.g_old_rec.ass_attribute4
860: ,p_ass_attribute5_o
861: => per_asg_shd.g_old_rec.ass_attribute5
862: ,p_ass_attribute6_o
863: => per_asg_shd.g_old_rec.ass_attribute6
864: ,p_ass_attribute7_o
865: => per_asg_shd.g_old_rec.ass_attribute7
859: => per_asg_shd.g_old_rec.ass_attribute4
860: ,p_ass_attribute5_o
861: => per_asg_shd.g_old_rec.ass_attribute5
862: ,p_ass_attribute6_o
863: => per_asg_shd.g_old_rec.ass_attribute6
864: ,p_ass_attribute7_o
865: => per_asg_shd.g_old_rec.ass_attribute7
866: ,p_ass_attribute8_o
867: => per_asg_shd.g_old_rec.ass_attribute8
861: => per_asg_shd.g_old_rec.ass_attribute5
862: ,p_ass_attribute6_o
863: => per_asg_shd.g_old_rec.ass_attribute6
864: ,p_ass_attribute7_o
865: => per_asg_shd.g_old_rec.ass_attribute7
866: ,p_ass_attribute8_o
867: => per_asg_shd.g_old_rec.ass_attribute8
868: ,p_ass_attribute9_o
869: => per_asg_shd.g_old_rec.ass_attribute9
863: => per_asg_shd.g_old_rec.ass_attribute6
864: ,p_ass_attribute7_o
865: => per_asg_shd.g_old_rec.ass_attribute7
866: ,p_ass_attribute8_o
867: => per_asg_shd.g_old_rec.ass_attribute8
868: ,p_ass_attribute9_o
869: => per_asg_shd.g_old_rec.ass_attribute9
870: ,p_ass_attribute10_o
871: => per_asg_shd.g_old_rec.ass_attribute10
865: => per_asg_shd.g_old_rec.ass_attribute7
866: ,p_ass_attribute8_o
867: => per_asg_shd.g_old_rec.ass_attribute8
868: ,p_ass_attribute9_o
869: => per_asg_shd.g_old_rec.ass_attribute9
870: ,p_ass_attribute10_o
871: => per_asg_shd.g_old_rec.ass_attribute10
872: ,p_ass_attribute11_o
873: => per_asg_shd.g_old_rec.ass_attribute11
867: => per_asg_shd.g_old_rec.ass_attribute8
868: ,p_ass_attribute9_o
869: => per_asg_shd.g_old_rec.ass_attribute9
870: ,p_ass_attribute10_o
871: => per_asg_shd.g_old_rec.ass_attribute10
872: ,p_ass_attribute11_o
873: => per_asg_shd.g_old_rec.ass_attribute11
874: ,p_ass_attribute12_o
875: => per_asg_shd.g_old_rec.ass_attribute12
869: => per_asg_shd.g_old_rec.ass_attribute9
870: ,p_ass_attribute10_o
871: => per_asg_shd.g_old_rec.ass_attribute10
872: ,p_ass_attribute11_o
873: => per_asg_shd.g_old_rec.ass_attribute11
874: ,p_ass_attribute12_o
875: => per_asg_shd.g_old_rec.ass_attribute12
876: ,p_ass_attribute13_o
877: => per_asg_shd.g_old_rec.ass_attribute13
871: => per_asg_shd.g_old_rec.ass_attribute10
872: ,p_ass_attribute11_o
873: => per_asg_shd.g_old_rec.ass_attribute11
874: ,p_ass_attribute12_o
875: => per_asg_shd.g_old_rec.ass_attribute12
876: ,p_ass_attribute13_o
877: => per_asg_shd.g_old_rec.ass_attribute13
878: ,p_ass_attribute14_o
879: => per_asg_shd.g_old_rec.ass_attribute14
873: => per_asg_shd.g_old_rec.ass_attribute11
874: ,p_ass_attribute12_o
875: => per_asg_shd.g_old_rec.ass_attribute12
876: ,p_ass_attribute13_o
877: => per_asg_shd.g_old_rec.ass_attribute13
878: ,p_ass_attribute14_o
879: => per_asg_shd.g_old_rec.ass_attribute14
880: ,p_ass_attribute15_o
881: => per_asg_shd.g_old_rec.ass_attribute15
875: => per_asg_shd.g_old_rec.ass_attribute12
876: ,p_ass_attribute13_o
877: => per_asg_shd.g_old_rec.ass_attribute13
878: ,p_ass_attribute14_o
879: => per_asg_shd.g_old_rec.ass_attribute14
880: ,p_ass_attribute15_o
881: => per_asg_shd.g_old_rec.ass_attribute15
882: ,p_ass_attribute16_o
883: => per_asg_shd.g_old_rec.ass_attribute16
877: => per_asg_shd.g_old_rec.ass_attribute13
878: ,p_ass_attribute14_o
879: => per_asg_shd.g_old_rec.ass_attribute14
880: ,p_ass_attribute15_o
881: => per_asg_shd.g_old_rec.ass_attribute15
882: ,p_ass_attribute16_o
883: => per_asg_shd.g_old_rec.ass_attribute16
884: ,p_ass_attribute17_o
885: => per_asg_shd.g_old_rec.ass_attribute17
879: => per_asg_shd.g_old_rec.ass_attribute14
880: ,p_ass_attribute15_o
881: => per_asg_shd.g_old_rec.ass_attribute15
882: ,p_ass_attribute16_o
883: => per_asg_shd.g_old_rec.ass_attribute16
884: ,p_ass_attribute17_o
885: => per_asg_shd.g_old_rec.ass_attribute17
886: ,p_ass_attribute18_o
887: => per_asg_shd.g_old_rec.ass_attribute18
881: => per_asg_shd.g_old_rec.ass_attribute15
882: ,p_ass_attribute16_o
883: => per_asg_shd.g_old_rec.ass_attribute16
884: ,p_ass_attribute17_o
885: => per_asg_shd.g_old_rec.ass_attribute17
886: ,p_ass_attribute18_o
887: => per_asg_shd.g_old_rec.ass_attribute18
888: ,p_ass_attribute19_o
889: => per_asg_shd.g_old_rec.ass_attribute19
883: => per_asg_shd.g_old_rec.ass_attribute16
884: ,p_ass_attribute17_o
885: => per_asg_shd.g_old_rec.ass_attribute17
886: ,p_ass_attribute18_o
887: => per_asg_shd.g_old_rec.ass_attribute18
888: ,p_ass_attribute19_o
889: => per_asg_shd.g_old_rec.ass_attribute19
890: ,p_ass_attribute20_o
891: => per_asg_shd.g_old_rec.ass_attribute20
885: => per_asg_shd.g_old_rec.ass_attribute17
886: ,p_ass_attribute18_o
887: => per_asg_shd.g_old_rec.ass_attribute18
888: ,p_ass_attribute19_o
889: => per_asg_shd.g_old_rec.ass_attribute19
890: ,p_ass_attribute20_o
891: => per_asg_shd.g_old_rec.ass_attribute20
892: ,p_ass_attribute21_o
893: => per_asg_shd.g_old_rec.ass_attribute21
887: => per_asg_shd.g_old_rec.ass_attribute18
888: ,p_ass_attribute19_o
889: => per_asg_shd.g_old_rec.ass_attribute19
890: ,p_ass_attribute20_o
891: => per_asg_shd.g_old_rec.ass_attribute20
892: ,p_ass_attribute21_o
893: => per_asg_shd.g_old_rec.ass_attribute21
894: ,p_ass_attribute22_o
895: => per_asg_shd.g_old_rec.ass_attribute22
889: => per_asg_shd.g_old_rec.ass_attribute19
890: ,p_ass_attribute20_o
891: => per_asg_shd.g_old_rec.ass_attribute20
892: ,p_ass_attribute21_o
893: => per_asg_shd.g_old_rec.ass_attribute21
894: ,p_ass_attribute22_o
895: => per_asg_shd.g_old_rec.ass_attribute22
896: ,p_ass_attribute23_o
897: => per_asg_shd.g_old_rec.ass_attribute23
891: => per_asg_shd.g_old_rec.ass_attribute20
892: ,p_ass_attribute21_o
893: => per_asg_shd.g_old_rec.ass_attribute21
894: ,p_ass_attribute22_o
895: => per_asg_shd.g_old_rec.ass_attribute22
896: ,p_ass_attribute23_o
897: => per_asg_shd.g_old_rec.ass_attribute23
898: ,p_ass_attribute24_o
899: => per_asg_shd.g_old_rec.ass_attribute24
893: => per_asg_shd.g_old_rec.ass_attribute21
894: ,p_ass_attribute22_o
895: => per_asg_shd.g_old_rec.ass_attribute22
896: ,p_ass_attribute23_o
897: => per_asg_shd.g_old_rec.ass_attribute23
898: ,p_ass_attribute24_o
899: => per_asg_shd.g_old_rec.ass_attribute24
900: ,p_ass_attribute25_o
901: => per_asg_shd.g_old_rec.ass_attribute25
895: => per_asg_shd.g_old_rec.ass_attribute22
896: ,p_ass_attribute23_o
897: => per_asg_shd.g_old_rec.ass_attribute23
898: ,p_ass_attribute24_o
899: => per_asg_shd.g_old_rec.ass_attribute24
900: ,p_ass_attribute25_o
901: => per_asg_shd.g_old_rec.ass_attribute25
902: ,p_ass_attribute26_o
903: => per_asg_shd.g_old_rec.ass_attribute26
897: => per_asg_shd.g_old_rec.ass_attribute23
898: ,p_ass_attribute24_o
899: => per_asg_shd.g_old_rec.ass_attribute24
900: ,p_ass_attribute25_o
901: => per_asg_shd.g_old_rec.ass_attribute25
902: ,p_ass_attribute26_o
903: => per_asg_shd.g_old_rec.ass_attribute26
904: ,p_ass_attribute27_o
905: => per_asg_shd.g_old_rec.ass_attribute27
899: => per_asg_shd.g_old_rec.ass_attribute24
900: ,p_ass_attribute25_o
901: => per_asg_shd.g_old_rec.ass_attribute25
902: ,p_ass_attribute26_o
903: => per_asg_shd.g_old_rec.ass_attribute26
904: ,p_ass_attribute27_o
905: => per_asg_shd.g_old_rec.ass_attribute27
906: ,p_ass_attribute28_o
907: => per_asg_shd.g_old_rec.ass_attribute28
901: => per_asg_shd.g_old_rec.ass_attribute25
902: ,p_ass_attribute26_o
903: => per_asg_shd.g_old_rec.ass_attribute26
904: ,p_ass_attribute27_o
905: => per_asg_shd.g_old_rec.ass_attribute27
906: ,p_ass_attribute28_o
907: => per_asg_shd.g_old_rec.ass_attribute28
908: ,p_ass_attribute29_o
909: => per_asg_shd.g_old_rec.ass_attribute29
903: => per_asg_shd.g_old_rec.ass_attribute26
904: ,p_ass_attribute27_o
905: => per_asg_shd.g_old_rec.ass_attribute27
906: ,p_ass_attribute28_o
907: => per_asg_shd.g_old_rec.ass_attribute28
908: ,p_ass_attribute29_o
909: => per_asg_shd.g_old_rec.ass_attribute29
910: ,p_ass_attribute30_o
911: => per_asg_shd.g_old_rec.ass_attribute30
905: => per_asg_shd.g_old_rec.ass_attribute27
906: ,p_ass_attribute28_o
907: => per_asg_shd.g_old_rec.ass_attribute28
908: ,p_ass_attribute29_o
909: => per_asg_shd.g_old_rec.ass_attribute29
910: ,p_ass_attribute30_o
911: => per_asg_shd.g_old_rec.ass_attribute30
912: ,p_title_o
913: => per_asg_shd.g_old_rec.title
907: => per_asg_shd.g_old_rec.ass_attribute28
908: ,p_ass_attribute29_o
909: => per_asg_shd.g_old_rec.ass_attribute29
910: ,p_ass_attribute30_o
911: => per_asg_shd.g_old_rec.ass_attribute30
912: ,p_title_o
913: => per_asg_shd.g_old_rec.title
914: ,p_contract_id_o
915: => per_asg_shd.g_old_rec.contract_id
909: => per_asg_shd.g_old_rec.ass_attribute29
910: ,p_ass_attribute30_o
911: => per_asg_shd.g_old_rec.ass_attribute30
912: ,p_title_o
913: => per_asg_shd.g_old_rec.title
914: ,p_contract_id_o
915: => per_asg_shd.g_old_rec.contract_id
916: ,p_establishment_id_o
917: => per_asg_shd.g_old_rec.establishment_id
911: => per_asg_shd.g_old_rec.ass_attribute30
912: ,p_title_o
913: => per_asg_shd.g_old_rec.title
914: ,p_contract_id_o
915: => per_asg_shd.g_old_rec.contract_id
916: ,p_establishment_id_o
917: => per_asg_shd.g_old_rec.establishment_id
918: ,p_collective_agreement_id_o
919: => per_asg_shd.g_old_rec.collective_agreement_id
913: => per_asg_shd.g_old_rec.title
914: ,p_contract_id_o
915: => per_asg_shd.g_old_rec.contract_id
916: ,p_establishment_id_o
917: => per_asg_shd.g_old_rec.establishment_id
918: ,p_collective_agreement_id_o
919: => per_asg_shd.g_old_rec.collective_agreement_id
920: ,p_cagr_grade_def_id_o
921: => per_asg_shd.g_old_rec.cagr_grade_def_id
915: => per_asg_shd.g_old_rec.contract_id
916: ,p_establishment_id_o
917: => per_asg_shd.g_old_rec.establishment_id
918: ,p_collective_agreement_id_o
919: => per_asg_shd.g_old_rec.collective_agreement_id
920: ,p_cagr_grade_def_id_o
921: => per_asg_shd.g_old_rec.cagr_grade_def_id
922: ,p_cagr_id_flex_num_o
923: => per_asg_shd.g_old_rec.cagr_id_flex_num
917: => per_asg_shd.g_old_rec.establishment_id
918: ,p_collective_agreement_id_o
919: => per_asg_shd.g_old_rec.collective_agreement_id
920: ,p_cagr_grade_def_id_o
921: => per_asg_shd.g_old_rec.cagr_grade_def_id
922: ,p_cagr_id_flex_num_o
923: => per_asg_shd.g_old_rec.cagr_id_flex_num
924: ,p_object_version_number_o
925: => per_asg_shd.g_old_rec.object_version_number
919: => per_asg_shd.g_old_rec.collective_agreement_id
920: ,p_cagr_grade_def_id_o
921: => per_asg_shd.g_old_rec.cagr_grade_def_id
922: ,p_cagr_id_flex_num_o
923: => per_asg_shd.g_old_rec.cagr_id_flex_num
924: ,p_object_version_number_o
925: => per_asg_shd.g_old_rec.object_version_number
926: ,p_notice_period_o
927: => per_asg_shd.g_old_rec.notice_period
921: => per_asg_shd.g_old_rec.cagr_grade_def_id
922: ,p_cagr_id_flex_num_o
923: => per_asg_shd.g_old_rec.cagr_id_flex_num
924: ,p_object_version_number_o
925: => per_asg_shd.g_old_rec.object_version_number
926: ,p_notice_period_o
927: => per_asg_shd.g_old_rec.notice_period
928: ,p_notice_period_uom_o
929: => per_asg_shd.g_old_rec.notice_period_uom
923: => per_asg_shd.g_old_rec.cagr_id_flex_num
924: ,p_object_version_number_o
925: => per_asg_shd.g_old_rec.object_version_number
926: ,p_notice_period_o
927: => per_asg_shd.g_old_rec.notice_period
928: ,p_notice_period_uom_o
929: => per_asg_shd.g_old_rec.notice_period_uom
930: ,p_employee_category_o
931: => per_asg_shd.g_old_rec.employee_category
925: => per_asg_shd.g_old_rec.object_version_number
926: ,p_notice_period_o
927: => per_asg_shd.g_old_rec.notice_period
928: ,p_notice_period_uom_o
929: => per_asg_shd.g_old_rec.notice_period_uom
930: ,p_employee_category_o
931: => per_asg_shd.g_old_rec.employee_category
932: ,p_work_at_home_o
933: => per_asg_shd.g_old_rec.work_at_home
927: => per_asg_shd.g_old_rec.notice_period
928: ,p_notice_period_uom_o
929: => per_asg_shd.g_old_rec.notice_period_uom
930: ,p_employee_category_o
931: => per_asg_shd.g_old_rec.employee_category
932: ,p_work_at_home_o
933: => per_asg_shd.g_old_rec.work_at_home
934: ,p_job_post_source_name_o
935: => per_asg_shd.g_old_rec.job_post_source_name
929: => per_asg_shd.g_old_rec.notice_period_uom
930: ,p_employee_category_o
931: => per_asg_shd.g_old_rec.employee_category
932: ,p_work_at_home_o
933: => per_asg_shd.g_old_rec.work_at_home
934: ,p_job_post_source_name_o
935: => per_asg_shd.g_old_rec.job_post_source_name
936: ,p_posting_content_id_o
937: => per_asg_shd.g_old_rec.posting_content_id
931: => per_asg_shd.g_old_rec.employee_category
932: ,p_work_at_home_o
933: => per_asg_shd.g_old_rec.work_at_home
934: ,p_job_post_source_name_o
935: => per_asg_shd.g_old_rec.job_post_source_name
936: ,p_posting_content_id_o
937: => per_asg_shd.g_old_rec.posting_content_id
938: ,p_placement_date_start_o
939: => per_asg_shd.g_old_rec.period_of_placement_date_start
933: => per_asg_shd.g_old_rec.work_at_home
934: ,p_job_post_source_name_o
935: => per_asg_shd.g_old_rec.job_post_source_name
936: ,p_posting_content_id_o
937: => per_asg_shd.g_old_rec.posting_content_id
938: ,p_placement_date_start_o
939: => per_asg_shd.g_old_rec.period_of_placement_date_start
940: ,p_vendor_id_o
941: => per_asg_shd.g_old_rec.vendor_id
935: => per_asg_shd.g_old_rec.job_post_source_name
936: ,p_posting_content_id_o
937: => per_asg_shd.g_old_rec.posting_content_id
938: ,p_placement_date_start_o
939: => per_asg_shd.g_old_rec.period_of_placement_date_start
940: ,p_vendor_id_o
941: => per_asg_shd.g_old_rec.vendor_id
942: ,p_vendor_employee_number_o
943: => per_asg_shd.g_old_rec.vendor_employee_number
937: => per_asg_shd.g_old_rec.posting_content_id
938: ,p_placement_date_start_o
939: => per_asg_shd.g_old_rec.period_of_placement_date_start
940: ,p_vendor_id_o
941: => per_asg_shd.g_old_rec.vendor_id
942: ,p_vendor_employee_number_o
943: => per_asg_shd.g_old_rec.vendor_employee_number
944: ,p_vendor_assignment_number_o
945: => per_asg_shd.g_old_rec.vendor_assignment_number
939: => per_asg_shd.g_old_rec.period_of_placement_date_start
940: ,p_vendor_id_o
941: => per_asg_shd.g_old_rec.vendor_id
942: ,p_vendor_employee_number_o
943: => per_asg_shd.g_old_rec.vendor_employee_number
944: ,p_vendor_assignment_number_o
945: => per_asg_shd.g_old_rec.vendor_assignment_number
946: ,p_assignment_category_o
947: => per_asg_shd.g_old_rec.assignment_category
941: => per_asg_shd.g_old_rec.vendor_id
942: ,p_vendor_employee_number_o
943: => per_asg_shd.g_old_rec.vendor_employee_number
944: ,p_vendor_assignment_number_o
945: => per_asg_shd.g_old_rec.vendor_assignment_number
946: ,p_assignment_category_o
947: => per_asg_shd.g_old_rec.assignment_category
948: ,p_project_title_o
949: => per_asg_shd.g_old_rec.project_title
943: => per_asg_shd.g_old_rec.vendor_employee_number
944: ,p_vendor_assignment_number_o
945: => per_asg_shd.g_old_rec.vendor_assignment_number
946: ,p_assignment_category_o
947: => per_asg_shd.g_old_rec.assignment_category
948: ,p_project_title_o
949: => per_asg_shd.g_old_rec.project_title
950: ,p_applicant_rank_o
951: => per_asg_shd.g_old_rec.applicant_rank
945: => per_asg_shd.g_old_rec.vendor_assignment_number
946: ,p_assignment_category_o
947: => per_asg_shd.g_old_rec.assignment_category
948: ,p_project_title_o
949: => per_asg_shd.g_old_rec.project_title
950: ,p_applicant_rank_o
951: => per_asg_shd.g_old_rec.applicant_rank
952: ,p_grade_ladder_pgm_id_o
953: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
947: => per_asg_shd.g_old_rec.assignment_category
948: ,p_project_title_o
949: => per_asg_shd.g_old_rec.project_title
950: ,p_applicant_rank_o
951: => per_asg_shd.g_old_rec.applicant_rank
952: ,p_grade_ladder_pgm_id_o
953: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
954: ,p_supervisor_assignment_id_o
955: => per_asg_shd.g_old_rec.supervisor_assignment_id
949: => per_asg_shd.g_old_rec.project_title
950: ,p_applicant_rank_o
951: => per_asg_shd.g_old_rec.applicant_rank
952: ,p_grade_ladder_pgm_id_o
953: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
954: ,p_supervisor_assignment_id_o
955: => per_asg_shd.g_old_rec.supervisor_assignment_id
956: ,p_vendor_site_id_o
957: => per_asg_shd.g_old_rec.vendor_site_id
951: => per_asg_shd.g_old_rec.applicant_rank
952: ,p_grade_ladder_pgm_id_o
953: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
954: ,p_supervisor_assignment_id_o
955: => per_asg_shd.g_old_rec.supervisor_assignment_id
956: ,p_vendor_site_id_o
957: => per_asg_shd.g_old_rec.vendor_site_id
958: ,p_po_header_id_o
959: => per_asg_shd.g_old_rec.po_header_id
953: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
954: ,p_supervisor_assignment_id_o
955: => per_asg_shd.g_old_rec.supervisor_assignment_id
956: ,p_vendor_site_id_o
957: => per_asg_shd.g_old_rec.vendor_site_id
958: ,p_po_header_id_o
959: => per_asg_shd.g_old_rec.po_header_id
960: ,p_po_line_id_o
961: => per_asg_shd.g_old_rec.po_line_id
955: => per_asg_shd.g_old_rec.supervisor_assignment_id
956: ,p_vendor_site_id_o
957: => per_asg_shd.g_old_rec.vendor_site_id
958: ,p_po_header_id_o
959: => per_asg_shd.g_old_rec.po_header_id
960: ,p_po_line_id_o
961: => per_asg_shd.g_old_rec.po_line_id
962: ,p_projected_assignment_end_o
963: => per_asg_shd.g_old_rec.projected_assignment_end
957: => per_asg_shd.g_old_rec.vendor_site_id
958: ,p_po_header_id_o
959: => per_asg_shd.g_old_rec.po_header_id
960: ,p_po_line_id_o
961: => per_asg_shd.g_old_rec.po_line_id
962: ,p_projected_assignment_end_o
963: => per_asg_shd.g_old_rec.projected_assignment_end
964: );
965: exception
959: => per_asg_shd.g_old_rec.po_header_id
960: ,p_po_line_id_o
961: => per_asg_shd.g_old_rec.po_line_id
962: ,p_projected_assignment_end_o
963: => per_asg_shd.g_old_rec.projected_assignment_end
964: );
965: exception
966: when hr_api.cannot_find_prog_unit then
967: hr_api.cannot_find_prog_unit_error
1093: ,P_VENDOR_SITE_ID => p_rec.vendor_site_id
1094: ,P_PO_HEADER_ID => p_rec.po_header_id
1095: ,P_PO_LINE_ID => p_rec.po_line_id
1096: ,P_PROJECTED_ASSIGNMENT_END => p_rec.projected_assignment_end
1097: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1098: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1099: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1100: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1101: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1094: ,P_PO_HEADER_ID => p_rec.po_header_id
1095: ,P_PO_LINE_ID => p_rec.po_line_id
1096: ,P_PROJECTED_ASSIGNMENT_END => p_rec.projected_assignment_end
1097: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1098: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1099: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1100: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1101: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1102: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1095: ,P_PO_LINE_ID => p_rec.po_line_id
1096: ,P_PROJECTED_ASSIGNMENT_END => p_rec.projected_assignment_end
1097: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1098: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1099: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1100: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1101: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1102: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1103: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1096: ,P_PROJECTED_ASSIGNMENT_END => p_rec.projected_assignment_end
1097: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1098: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1099: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1100: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1101: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1102: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1103: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1104: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1097: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
1098: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1099: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1100: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1101: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1102: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1103: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1104: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1105: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1098: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
1099: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1100: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1101: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1102: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1103: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1104: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1105: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1106: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1099: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
1100: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1101: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1102: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1103: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1104: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1105: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1106: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1107: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1100: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
1101: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1102: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1103: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1104: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1105: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1106: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1107: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1108: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1101: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
1102: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1103: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1104: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1105: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1106: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1107: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1108: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1109: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1102: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
1103: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1104: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1105: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1106: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1107: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1108: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1109: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1110: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1103: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
1104: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1105: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1106: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1107: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1108: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1109: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1110: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1111: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1104: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
1105: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1106: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1107: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1108: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1109: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1110: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1111: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1112: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1105: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
1106: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1107: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1108: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1109: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1110: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1111: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1112: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1113: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1106: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
1107: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1108: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1109: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1110: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1111: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1112: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1113: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1114: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1107: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
1108: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1109: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1110: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1111: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1112: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1113: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1114: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1115: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1108: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
1109: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1110: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1111: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1112: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1113: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1114: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1115: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1116: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1109: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
1110: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1111: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1112: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1113: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1114: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1115: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1116: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1117: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1110: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
1111: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1112: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1113: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1114: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1115: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1116: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1117: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1118: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1111: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
1112: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1113: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1114: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1115: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1116: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1117: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1118: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1119: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1112: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
1113: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1114: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1115: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1116: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1117: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1118: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1119: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1120: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1113: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
1114: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1115: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1116: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1117: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1118: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1119: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1120: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1121: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1114: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
1115: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1116: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1117: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1118: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1119: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1120: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1121: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1122: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1115: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
1116: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1117: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1118: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1119: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1120: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1121: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1122: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1123: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1116: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
1117: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1118: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1119: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1120: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1121: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1122: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1123: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1124: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1117: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
1118: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1119: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1120: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1121: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1122: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1123: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1124: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1125: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1118: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
1119: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1120: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1121: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1122: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1123: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1124: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1125: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1126: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1119: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
1120: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1121: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1122: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1123: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1124: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1125: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1126: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1127: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1120: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
1121: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1122: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1123: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1124: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1125: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1126: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1127: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1128: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1121: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
1122: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1123: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1124: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1125: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1126: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1127: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1128: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1129: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1122: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
1123: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1124: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1125: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1126: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1127: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1128: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1129: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1130: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1123: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
1124: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1125: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1126: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1127: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1128: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1129: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1130: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1131: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1124: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
1125: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1126: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1127: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1128: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1129: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1130: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1131: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1132: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1125: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
1126: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1127: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1128: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1129: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1130: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1131: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1132: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1133: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1126: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
1127: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1128: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1129: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1130: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1131: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1132: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1133: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1134: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1127: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
1128: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1129: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1130: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1131: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1132: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1133: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1134: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1135: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1128: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
1129: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1130: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1131: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1132: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1133: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1134: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1135: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1136: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1129: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
1130: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1131: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1132: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1133: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1134: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1135: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1136: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1137: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1130: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
1131: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1132: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1133: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1134: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1135: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1136: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1137: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1138: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1131: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
1132: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1133: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1134: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1135: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1136: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1137: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1138: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1139: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1132: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
1133: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1134: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1135: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1136: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1137: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1138: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1139: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1140: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1133: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
1134: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1135: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1136: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1137: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1138: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1139: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1140: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1141: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1134: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
1135: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1136: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1137: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1138: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1139: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1140: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1141: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1142: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1135: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
1136: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1137: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1138: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1139: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1140: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1141: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1142: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1143: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1136: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
1137: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1138: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1139: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1140: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1141: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1142: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1143: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1144: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1137: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
1138: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1139: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1140: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1141: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1142: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1143: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1144: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1145: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1138: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
1139: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1140: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1141: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1142: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1143: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1144: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1145: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1146: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1139: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
1140: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1141: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1142: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1143: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1144: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1145: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1146: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1147: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1140: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
1141: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1142: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1143: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1144: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1145: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1146: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1147: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1148: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1141: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
1142: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1143: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1144: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1145: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1146: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1147: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1148: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1149: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1142: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
1143: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1144: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1145: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1146: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1147: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1148: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1149: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1150: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1143: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end
1144: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1145: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1146: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1147: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1148: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1149: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1150: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1151: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1144: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
1145: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1146: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1147: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1148: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1149: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1150: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1151: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1152: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1145: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
1146: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1147: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1148: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1149: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1150: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1151: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1152: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1153: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1146: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
1147: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1148: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1149: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1150: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1151: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1152: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1153: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1154: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1147: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
1148: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1149: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1150: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1151: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1152: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1153: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1154: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1155: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1148: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
1149: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1150: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1151: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1152: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1153: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1154: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1155: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1156: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1149: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
1150: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1151: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1152: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1153: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1154: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1155: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1156: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1157: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1150: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
1151: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1152: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1153: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1154: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1155: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1156: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1157: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1158: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1151: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
1152: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1153: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1154: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1155: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1156: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1157: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1158: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1159: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1152: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
1153: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1154: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1155: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1156: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1157: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1158: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1159: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1160: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1153: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
1154: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1155: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1156: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1157: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1158: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1159: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1160: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1161: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1154: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
1155: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1156: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1157: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1158: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1159: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1160: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1161: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1162: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1155: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
1156: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1157: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1158: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1159: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1160: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1161: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1162: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1163: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1156: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
1157: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1158: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1159: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1160: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1161: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1162: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1163: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1164: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1157: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
1158: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1159: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1160: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1161: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1162: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1163: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1164: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1165: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1158: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
1159: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1160: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1161: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1162: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1163: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1164: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1165: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1166: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1159: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
1160: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1161: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1162: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1163: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1164: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1165: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1166: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1167: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1160: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
1161: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1162: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1163: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1164: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1165: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1166: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1167: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1168: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1161: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
1162: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1163: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1164: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1165: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1166: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1167: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1168: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1169: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1162: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
1163: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1164: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1165: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1166: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1167: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1168: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1169: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1170: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1163: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
1164: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1165: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1166: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1167: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1168: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1169: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1170: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1171: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1164: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
1165: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1166: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1167: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1168: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1169: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1170: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1171: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1172: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1165: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
1166: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1167: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1168: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1169: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1170: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1171: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1172: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1173: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1166: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
1167: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1168: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1169: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1170: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1171: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1172: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1173: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1174: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1167: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
1168: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1169: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1170: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1171: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1172: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1173: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1174: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1175: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1168: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
1169: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1170: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1171: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1172: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1173: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1174: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1175: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1176: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1169: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
1170: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1171: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1172: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1173: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1174: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1175: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1176: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1177: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1170: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
1171: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1172: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1173: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1174: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1175: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1176: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1177: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1178: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1171: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
1172: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1173: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1174: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1175: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1176: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1177: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1178: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1179: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1172: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
1173: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1174: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1175: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1176: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1177: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1178: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1179: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1180: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1173: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
1174: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1175: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1176: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1177: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1178: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1179: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1180: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1181: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1174: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
1175: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1176: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1177: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1178: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1179: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1180: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1181: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1182: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1175: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
1176: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1177: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1178: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1179: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1180: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1181: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1182: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1183: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1176: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
1177: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1178: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1179: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1180: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1181: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1182: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1183: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1184: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1177: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
1178: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1179: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1180: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1181: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1182: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1183: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1184: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1185: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1178: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
1179: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1180: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1181: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1182: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1183: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1184: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1185: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1186: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1179: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
1180: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1181: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1182: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1183: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1184: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1185: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1186: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1187: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1180: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
1181: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1182: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1183: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1184: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1185: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1186: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1187: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1188: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1181: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
1182: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1183: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1184: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1185: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1186: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1187: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1188: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1189: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1182: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
1183: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1184: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1185: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1186: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1187: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1188: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1189: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1190: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1183: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
1184: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1185: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1186: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1187: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1188: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1189: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1190: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1191: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1184: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
1185: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1186: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1187: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1188: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1189: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1190: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1191: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1192: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1185: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
1186: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1187: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1188: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1189: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1190: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1191: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1192: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1193: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1186: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
1187: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1188: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1189: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1190: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1191: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1192: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1193: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1194: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1187: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
1188: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1189: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1190: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1191: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1192: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1193: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1194: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1195: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1188: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
1189: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1190: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1191: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1192: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1193: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1194: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1195: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1196: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1189: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
1190: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1191: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1192: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1193: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1194: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1195: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1196: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1197: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1190: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
1191: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1192: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1193: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1194: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1195: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1196: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1197: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1198: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1191: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
1192: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1193: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1194: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1195: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1196: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1197: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1198: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1199: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1192: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
1193: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1194: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1195: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1196: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1197: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1198: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1199: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1200: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1193: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
1194: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1195: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1196: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1197: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1198: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1199: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1200: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1201: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1194: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
1195: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1196: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1197: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1198: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1199: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1200: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1201: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1202: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1195: ,P_TITLE_O => per_asg_shd.g_old_rec.title
1196: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1197: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1198: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1199: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1200: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1201: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1202: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1203: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1196: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
1197: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1198: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1199: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1200: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1201: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1202: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1203: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1204: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1197: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
1198: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1199: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1200: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1201: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1202: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1203: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1204: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1205: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1198: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
1199: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1200: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1201: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1202: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1203: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1204: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1205: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1206: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1199: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
1200: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1201: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1202: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1203: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1204: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1205: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1206: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1207: );
1200: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
1201: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1202: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1203: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1204: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1205: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1206: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1207: );
1208: --
1201: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
1202: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1203: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1204: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1205: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1206: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1207: );
1208: --
1209: -- Call to Workflow Sync Procedure For Assignments
1202: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
1203: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
1204: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
1205: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
1206: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
1207: );
1208: --
1209: -- Call to Workflow Sync Procedure For Assignments
1210: per_pqh_shr.per_asg_wf_sync('POST_UPDATE',
1208: --
1209: -- Call to Workflow Sync Procedure For Assignments
1210: per_pqh_shr.per_asg_wf_sync('POST_UPDATE',
1211: p_rec,
1212: per_asg_shd.g_old_rec.position_id,
1213: p_effective_date,
1214: p_validation_start_date,
1215: p_validation_end_date,
1216: p_datetrack_mode);
1263: -- Internal Table Handler Use Only.
1264: --
1265: -- {End Of Comments}
1266: -- ----------------------------------------------------------------------------
1267: Procedure convert_defs(p_rec in out nocopy per_asg_shd.g_rec_type) is
1268: --
1269: l_proc varchar2(72) := g_package||'convert_defs';
1270: --
1271: Begin
1278: -- is being used then we must set to the 'current' argument value.
1279: --
1280: If (p_rec.business_group_id = hr_api.g_number) then
1281: p_rec.business_group_id :=
1282: per_asg_shd.g_old_rec.business_group_id;
1283: End If;
1284: If (p_rec.recruiter_id = hr_api.g_number) then
1285: p_rec.recruiter_id :=
1286: per_asg_shd.g_old_rec.recruiter_id;
1282: per_asg_shd.g_old_rec.business_group_id;
1283: End If;
1284: If (p_rec.recruiter_id = hr_api.g_number) then
1285: p_rec.recruiter_id :=
1286: per_asg_shd.g_old_rec.recruiter_id;
1287: End If;
1288: If (p_rec.grade_id = hr_api.g_number) then
1289: p_rec.grade_id :=
1290: per_asg_shd.g_old_rec.grade_id;
1286: per_asg_shd.g_old_rec.recruiter_id;
1287: End If;
1288: If (p_rec.grade_id = hr_api.g_number) then
1289: p_rec.grade_id :=
1290: per_asg_shd.g_old_rec.grade_id;
1291: End If;
1292: If (p_rec.position_id = hr_api.g_number) then
1293: p_rec.position_id :=
1294: per_asg_shd.g_old_rec.position_id;
1290: per_asg_shd.g_old_rec.grade_id;
1291: End If;
1292: If (p_rec.position_id = hr_api.g_number) then
1293: p_rec.position_id :=
1294: per_asg_shd.g_old_rec.position_id;
1295: End If;
1296: If (p_rec.job_id = hr_api.g_number) then
1297: p_rec.job_id :=
1298: per_asg_shd.g_old_rec.job_id;
1294: per_asg_shd.g_old_rec.position_id;
1295: End If;
1296: If (p_rec.job_id = hr_api.g_number) then
1297: p_rec.job_id :=
1298: per_asg_shd.g_old_rec.job_id;
1299: End If;
1300: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1301: p_rec.assignment_status_type_id :=
1302: per_asg_shd.g_old_rec.assignment_status_type_id;
1298: per_asg_shd.g_old_rec.job_id;
1299: End If;
1300: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1301: p_rec.assignment_status_type_id :=
1302: per_asg_shd.g_old_rec.assignment_status_type_id;
1303: End If;
1304: If (p_rec.payroll_id = hr_api.g_number) then
1305: p_rec.payroll_id :=
1306: per_asg_shd.g_old_rec.payroll_id;
1302: per_asg_shd.g_old_rec.assignment_status_type_id;
1303: End If;
1304: If (p_rec.payroll_id = hr_api.g_number) then
1305: p_rec.payroll_id :=
1306: per_asg_shd.g_old_rec.payroll_id;
1307: End If;
1308: If (p_rec.location_id = hr_api.g_number) then
1309: p_rec.location_id :=
1310: per_asg_shd.g_old_rec.location_id;
1306: per_asg_shd.g_old_rec.payroll_id;
1307: End If;
1308: If (p_rec.location_id = hr_api.g_number) then
1309: p_rec.location_id :=
1310: per_asg_shd.g_old_rec.location_id;
1311: End If;
1312: If (p_rec.person_referred_by_id = hr_api.g_number) then
1313: p_rec.person_referred_by_id :=
1314: per_asg_shd.g_old_rec.person_referred_by_id;
1310: per_asg_shd.g_old_rec.location_id;
1311: End If;
1312: If (p_rec.person_referred_by_id = hr_api.g_number) then
1313: p_rec.person_referred_by_id :=
1314: per_asg_shd.g_old_rec.person_referred_by_id;
1315: End If;
1316: If (p_rec.supervisor_id = hr_api.g_number) then
1317: p_rec.supervisor_id :=
1318: per_asg_shd.g_old_rec.supervisor_id;
1314: per_asg_shd.g_old_rec.person_referred_by_id;
1315: End If;
1316: If (p_rec.supervisor_id = hr_api.g_number) then
1317: p_rec.supervisor_id :=
1318: per_asg_shd.g_old_rec.supervisor_id;
1319: End If;
1320: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1321: p_rec.special_ceiling_step_id :=
1322: per_asg_shd.g_old_rec.special_ceiling_step_id;
1318: per_asg_shd.g_old_rec.supervisor_id;
1319: End If;
1320: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1321: p_rec.special_ceiling_step_id :=
1322: per_asg_shd.g_old_rec.special_ceiling_step_id;
1323: End If;
1324: If (p_rec.person_id = hr_api.g_number) then
1325: p_rec.person_id :=
1326: per_asg_shd.g_old_rec.person_id;
1322: per_asg_shd.g_old_rec.special_ceiling_step_id;
1323: End If;
1324: If (p_rec.person_id = hr_api.g_number) then
1325: p_rec.person_id :=
1326: per_asg_shd.g_old_rec.person_id;
1327: End If;
1328: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1329: p_rec.recruitment_activity_id :=
1330: per_asg_shd.g_old_rec.recruitment_activity_id;
1326: per_asg_shd.g_old_rec.person_id;
1327: End If;
1328: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1329: p_rec.recruitment_activity_id :=
1330: per_asg_shd.g_old_rec.recruitment_activity_id;
1331: End If;
1332: If (p_rec.source_organization_id = hr_api.g_number) then
1333: p_rec.source_organization_id :=
1334: per_asg_shd.g_old_rec.source_organization_id;
1330: per_asg_shd.g_old_rec.recruitment_activity_id;
1331: End If;
1332: If (p_rec.source_organization_id = hr_api.g_number) then
1333: p_rec.source_organization_id :=
1334: per_asg_shd.g_old_rec.source_organization_id;
1335: End If;
1336: If (p_rec.organization_id = hr_api.g_number) then
1337: p_rec.organization_id :=
1338: per_asg_shd.g_old_rec.organization_id;
1334: per_asg_shd.g_old_rec.source_organization_id;
1335: End If;
1336: If (p_rec.organization_id = hr_api.g_number) then
1337: p_rec.organization_id :=
1338: per_asg_shd.g_old_rec.organization_id;
1339: End If;
1340: If (p_rec.people_group_id = hr_api.g_number) then
1341: p_rec.people_group_id :=
1342: per_asg_shd.g_old_rec.people_group_id;
1338: per_asg_shd.g_old_rec.organization_id;
1339: End If;
1340: If (p_rec.people_group_id = hr_api.g_number) then
1341: p_rec.people_group_id :=
1342: per_asg_shd.g_old_rec.people_group_id;
1343: End If;
1344: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1345: p_rec.soft_coding_keyflex_id :=
1346: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1342: per_asg_shd.g_old_rec.people_group_id;
1343: End If;
1344: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1345: p_rec.soft_coding_keyflex_id :=
1346: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1347: End If;
1348: If (p_rec.vacancy_id = hr_api.g_number) then
1349: p_rec.vacancy_id :=
1350: per_asg_shd.g_old_rec.vacancy_id;
1346: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1347: End If;
1348: If (p_rec.vacancy_id = hr_api.g_number) then
1349: p_rec.vacancy_id :=
1350: per_asg_shd.g_old_rec.vacancy_id;
1351: End If;
1352: If (p_rec.pay_basis_id = hr_api.g_number) then
1353: p_rec.pay_basis_id :=
1354: per_asg_shd.g_old_rec.pay_basis_id;
1350: per_asg_shd.g_old_rec.vacancy_id;
1351: End If;
1352: If (p_rec.pay_basis_id = hr_api.g_number) then
1353: p_rec.pay_basis_id :=
1354: per_asg_shd.g_old_rec.pay_basis_id;
1355: End If;
1356: If (p_rec.assignment_sequence = hr_api.g_number) then
1357: p_rec.assignment_sequence :=
1358: per_asg_shd.g_old_rec.assignment_sequence;
1354: per_asg_shd.g_old_rec.pay_basis_id;
1355: End If;
1356: If (p_rec.assignment_sequence = hr_api.g_number) then
1357: p_rec.assignment_sequence :=
1358: per_asg_shd.g_old_rec.assignment_sequence;
1359: End If;
1360: If (p_rec.assignment_type = hr_api.g_varchar2) then
1361: p_rec.assignment_type :=
1362: per_asg_shd.g_old_rec.assignment_type;
1358: per_asg_shd.g_old_rec.assignment_sequence;
1359: End If;
1360: If (p_rec.assignment_type = hr_api.g_varchar2) then
1361: p_rec.assignment_type :=
1362: per_asg_shd.g_old_rec.assignment_type;
1363: End If;
1364: If (p_rec.primary_flag = hr_api.g_varchar2) then
1365: p_rec.primary_flag :=
1366: per_asg_shd.g_old_rec.primary_flag;
1362: per_asg_shd.g_old_rec.assignment_type;
1363: End If;
1364: If (p_rec.primary_flag = hr_api.g_varchar2) then
1365: p_rec.primary_flag :=
1366: per_asg_shd.g_old_rec.primary_flag;
1367: End If;
1368: If (p_rec.application_id = hr_api.g_number) then
1369: p_rec.application_id :=
1370: per_asg_shd.g_old_rec.application_id;
1366: per_asg_shd.g_old_rec.primary_flag;
1367: End If;
1368: If (p_rec.application_id = hr_api.g_number) then
1369: p_rec.application_id :=
1370: per_asg_shd.g_old_rec.application_id;
1371: End If;
1372: If (p_rec.assignment_number = hr_api.g_varchar2) then
1373: p_rec.assignment_number :=
1374: per_asg_shd.g_old_rec.assignment_number;
1370: per_asg_shd.g_old_rec.application_id;
1371: End If;
1372: If (p_rec.assignment_number = hr_api.g_varchar2) then
1373: p_rec.assignment_number :=
1374: per_asg_shd.g_old_rec.assignment_number;
1375: End If;
1376: If (p_rec.change_reason = hr_api.g_varchar2) then
1377: p_rec.change_reason :=
1378: per_asg_shd.g_old_rec.change_reason;
1374: per_asg_shd.g_old_rec.assignment_number;
1375: End If;
1376: If (p_rec.change_reason = hr_api.g_varchar2) then
1377: p_rec.change_reason :=
1378: per_asg_shd.g_old_rec.change_reason;
1379: End If;
1380: If (p_rec.comment_id = hr_api.g_number) then
1381: p_rec.comment_id :=
1382: per_asg_shd.g_old_rec.comment_id;
1378: per_asg_shd.g_old_rec.change_reason;
1379: End If;
1380: If (p_rec.comment_id = hr_api.g_number) then
1381: p_rec.comment_id :=
1382: per_asg_shd.g_old_rec.comment_id;
1383: End If;
1384: If (p_rec.comment_text = hr_api.g_varchar2) then
1385: p_rec.comment_text :=
1386: per_asg_shd.g_old_rec.comment_text;
1382: per_asg_shd.g_old_rec.comment_id;
1383: End If;
1384: If (p_rec.comment_text = hr_api.g_varchar2) then
1385: p_rec.comment_text :=
1386: per_asg_shd.g_old_rec.comment_text;
1387: End If;
1388: If (p_rec.date_probation_end = hr_api.g_date) then
1389: p_rec.date_probation_end :=
1390: per_asg_shd.g_old_rec.date_probation_end;
1386: per_asg_shd.g_old_rec.comment_text;
1387: End If;
1388: If (p_rec.date_probation_end = hr_api.g_date) then
1389: p_rec.date_probation_end :=
1390: per_asg_shd.g_old_rec.date_probation_end;
1391: End If;
1392: If (p_rec.default_code_comb_id = hr_api.g_number) then
1393: p_rec.default_code_comb_id :=
1394: per_asg_shd.g_old_rec.default_code_comb_id;
1390: per_asg_shd.g_old_rec.date_probation_end;
1391: End If;
1392: If (p_rec.default_code_comb_id = hr_api.g_number) then
1393: p_rec.default_code_comb_id :=
1394: per_asg_shd.g_old_rec.default_code_comb_id;
1395: End If;
1396: If (p_rec.employment_category = hr_api.g_varchar2) then
1397: p_rec.employment_category :=
1398: per_asg_shd.g_old_rec.employment_category;
1394: per_asg_shd.g_old_rec.default_code_comb_id;
1395: End If;
1396: If (p_rec.employment_category = hr_api.g_varchar2) then
1397: p_rec.employment_category :=
1398: per_asg_shd.g_old_rec.employment_category;
1399: End If;
1400: If (p_rec.frequency = hr_api.g_varchar2) then
1401: p_rec.frequency :=
1402: per_asg_shd.g_old_rec.frequency;
1398: per_asg_shd.g_old_rec.employment_category;
1399: End If;
1400: If (p_rec.frequency = hr_api.g_varchar2) then
1401: p_rec.frequency :=
1402: per_asg_shd.g_old_rec.frequency;
1403: End If;
1404: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1405: p_rec.internal_address_line :=
1406: per_asg_shd.g_old_rec.internal_address_line;
1402: per_asg_shd.g_old_rec.frequency;
1403: End If;
1404: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1405: p_rec.internal_address_line :=
1406: per_asg_shd.g_old_rec.internal_address_line;
1407: End If;
1408: If (p_rec.manager_flag = hr_api.g_varchar2) then
1409: p_rec.manager_flag :=
1410: per_asg_shd.g_old_rec.manager_flag;
1406: per_asg_shd.g_old_rec.internal_address_line;
1407: End If;
1408: If (p_rec.manager_flag = hr_api.g_varchar2) then
1409: p_rec.manager_flag :=
1410: per_asg_shd.g_old_rec.manager_flag;
1411: End If;
1412: If (p_rec.normal_hours = hr_api.g_number) then
1413: p_rec.normal_hours :=
1414: per_asg_shd.g_old_rec.normal_hours;
1410: per_asg_shd.g_old_rec.manager_flag;
1411: End If;
1412: If (p_rec.normal_hours = hr_api.g_number) then
1413: p_rec.normal_hours :=
1414: per_asg_shd.g_old_rec.normal_hours;
1415: End If;
1416: If (p_rec.perf_review_period = hr_api.g_number) then
1417: p_rec.perf_review_period :=
1418: per_asg_shd.g_old_rec.perf_review_period;
1414: per_asg_shd.g_old_rec.normal_hours;
1415: End If;
1416: If (p_rec.perf_review_period = hr_api.g_number) then
1417: p_rec.perf_review_period :=
1418: per_asg_shd.g_old_rec.perf_review_period;
1419: End If;
1420: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1421: p_rec.perf_review_period_frequency :=
1422: per_asg_shd.g_old_rec.perf_review_period_frequency;
1418: per_asg_shd.g_old_rec.perf_review_period;
1419: End If;
1420: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1421: p_rec.perf_review_period_frequency :=
1422: per_asg_shd.g_old_rec.perf_review_period_frequency;
1423: End If;
1424: If (p_rec.period_of_service_id = hr_api.g_number) then
1425: p_rec.period_of_service_id :=
1426: per_asg_shd.g_old_rec.period_of_service_id;
1422: per_asg_shd.g_old_rec.perf_review_period_frequency;
1423: End If;
1424: If (p_rec.period_of_service_id = hr_api.g_number) then
1425: p_rec.period_of_service_id :=
1426: per_asg_shd.g_old_rec.period_of_service_id;
1427: End If;
1428: If (p_rec.probation_period = hr_api.g_number) then
1429: p_rec.probation_period :=
1430: per_asg_shd.g_old_rec.probation_period;
1426: per_asg_shd.g_old_rec.period_of_service_id;
1427: End If;
1428: If (p_rec.probation_period = hr_api.g_number) then
1429: p_rec.probation_period :=
1430: per_asg_shd.g_old_rec.probation_period;
1431: End If;
1432: If (p_rec.probation_unit = hr_api.g_varchar2) then
1433: p_rec.probation_unit :=
1434: per_asg_shd.g_old_rec.probation_unit;
1430: per_asg_shd.g_old_rec.probation_period;
1431: End If;
1432: If (p_rec.probation_unit = hr_api.g_varchar2) then
1433: p_rec.probation_unit :=
1434: per_asg_shd.g_old_rec.probation_unit;
1435: End If;
1436: If (p_rec.sal_review_period = hr_api.g_number) then
1437: p_rec.sal_review_period :=
1438: per_asg_shd.g_old_rec.sal_review_period;
1434: per_asg_shd.g_old_rec.probation_unit;
1435: End If;
1436: If (p_rec.sal_review_period = hr_api.g_number) then
1437: p_rec.sal_review_period :=
1438: per_asg_shd.g_old_rec.sal_review_period;
1439: End If;
1440: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1441: p_rec.sal_review_period_frequency :=
1442: per_asg_shd.g_old_rec.sal_review_period_frequency;
1438: per_asg_shd.g_old_rec.sal_review_period;
1439: End If;
1440: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1441: p_rec.sal_review_period_frequency :=
1442: per_asg_shd.g_old_rec.sal_review_period_frequency;
1443: End If;
1444: If (p_rec.set_of_books_id = hr_api.g_number) then
1445: p_rec.set_of_books_id :=
1446: per_asg_shd.g_old_rec.set_of_books_id;
1442: per_asg_shd.g_old_rec.sal_review_period_frequency;
1443: End If;
1444: If (p_rec.set_of_books_id = hr_api.g_number) then
1445: p_rec.set_of_books_id :=
1446: per_asg_shd.g_old_rec.set_of_books_id;
1447: End If;
1448: If (p_rec.source_type = hr_api.g_varchar2) then
1449: p_rec.source_type :=
1450: per_asg_shd.g_old_rec.source_type;
1446: per_asg_shd.g_old_rec.set_of_books_id;
1447: End If;
1448: If (p_rec.source_type = hr_api.g_varchar2) then
1449: p_rec.source_type :=
1450: per_asg_shd.g_old_rec.source_type;
1451: End If;
1452: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1453: p_rec.time_normal_finish :=
1454: per_asg_shd.g_old_rec.time_normal_finish;
1450: per_asg_shd.g_old_rec.source_type;
1451: End If;
1452: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1453: p_rec.time_normal_finish :=
1454: per_asg_shd.g_old_rec.time_normal_finish;
1455: End If;
1456: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1457: p_rec.time_normal_start :=
1458: per_asg_shd.g_old_rec.time_normal_start;
1454: per_asg_shd.g_old_rec.time_normal_finish;
1455: End If;
1456: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1457: p_rec.time_normal_start :=
1458: per_asg_shd.g_old_rec.time_normal_start;
1459: End If;
1460: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1461: p_rec.bargaining_unit_code :=
1462: per_asg_shd.g_old_rec.bargaining_unit_code;
1458: per_asg_shd.g_old_rec.time_normal_start;
1459: End If;
1460: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1461: p_rec.bargaining_unit_code :=
1462: per_asg_shd.g_old_rec.bargaining_unit_code;
1463: End If;
1464: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1465: p_rec.labour_union_member_flag :=
1466: per_asg_shd.g_old_rec.labour_union_member_flag;
1462: per_asg_shd.g_old_rec.bargaining_unit_code;
1463: End If;
1464: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1465: p_rec.labour_union_member_flag :=
1466: per_asg_shd.g_old_rec.labour_union_member_flag;
1467: End If;
1468: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1469: p_rec.hourly_salaried_code :=
1470: per_asg_shd.g_old_rec.hourly_salaried_code;
1466: per_asg_shd.g_old_rec.labour_union_member_flag;
1467: End If;
1468: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1469: p_rec.hourly_salaried_code :=
1470: per_asg_shd.g_old_rec.hourly_salaried_code;
1471: End If;
1472: If (p_rec.request_id = hr_api.g_number) then
1473: p_rec.request_id :=
1474: per_asg_shd.g_old_rec.request_id;
1470: per_asg_shd.g_old_rec.hourly_salaried_code;
1471: End If;
1472: If (p_rec.request_id = hr_api.g_number) then
1473: p_rec.request_id :=
1474: per_asg_shd.g_old_rec.request_id;
1475: End If;
1476: If (p_rec.program_application_id = hr_api.g_number) then
1477: p_rec.program_application_id :=
1478: per_asg_shd.g_old_rec.program_application_id;
1474: per_asg_shd.g_old_rec.request_id;
1475: End If;
1476: If (p_rec.program_application_id = hr_api.g_number) then
1477: p_rec.program_application_id :=
1478: per_asg_shd.g_old_rec.program_application_id;
1479: End If;
1480: If (p_rec.program_id = hr_api.g_number) then
1481: p_rec.program_id :=
1482: per_asg_shd.g_old_rec.program_id;
1478: per_asg_shd.g_old_rec.program_application_id;
1479: End If;
1480: If (p_rec.program_id = hr_api.g_number) then
1481: p_rec.program_id :=
1482: per_asg_shd.g_old_rec.program_id;
1483: End If;
1484: If (p_rec.program_update_date = hr_api.g_date) then
1485: p_rec.program_update_date :=
1486: per_asg_shd.g_old_rec.program_update_date;
1482: per_asg_shd.g_old_rec.program_id;
1483: End If;
1484: If (p_rec.program_update_date = hr_api.g_date) then
1485: p_rec.program_update_date :=
1486: per_asg_shd.g_old_rec.program_update_date;
1487: End If;
1488: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1489: p_rec.ass_attribute_category :=
1490: per_asg_shd.g_old_rec.ass_attribute_category;
1486: per_asg_shd.g_old_rec.program_update_date;
1487: End If;
1488: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1489: p_rec.ass_attribute_category :=
1490: per_asg_shd.g_old_rec.ass_attribute_category;
1491: End If;
1492: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1493: p_rec.ass_attribute1 :=
1494: per_asg_shd.g_old_rec.ass_attribute1;
1490: per_asg_shd.g_old_rec.ass_attribute_category;
1491: End If;
1492: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1493: p_rec.ass_attribute1 :=
1494: per_asg_shd.g_old_rec.ass_attribute1;
1495: End If;
1496: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1497: p_rec.ass_attribute2 :=
1498: per_asg_shd.g_old_rec.ass_attribute2;
1494: per_asg_shd.g_old_rec.ass_attribute1;
1495: End If;
1496: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1497: p_rec.ass_attribute2 :=
1498: per_asg_shd.g_old_rec.ass_attribute2;
1499: End If;
1500: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1501: p_rec.ass_attribute3 :=
1502: per_asg_shd.g_old_rec.ass_attribute3;
1498: per_asg_shd.g_old_rec.ass_attribute2;
1499: End If;
1500: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1501: p_rec.ass_attribute3 :=
1502: per_asg_shd.g_old_rec.ass_attribute3;
1503: End If;
1504: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1505: p_rec.ass_attribute4 :=
1506: per_asg_shd.g_old_rec.ass_attribute4;
1502: per_asg_shd.g_old_rec.ass_attribute3;
1503: End If;
1504: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1505: p_rec.ass_attribute4 :=
1506: per_asg_shd.g_old_rec.ass_attribute4;
1507: End If;
1508: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1509: p_rec.ass_attribute5 :=
1510: per_asg_shd.g_old_rec.ass_attribute5;
1506: per_asg_shd.g_old_rec.ass_attribute4;
1507: End If;
1508: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1509: p_rec.ass_attribute5 :=
1510: per_asg_shd.g_old_rec.ass_attribute5;
1511: End If;
1512: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1513: p_rec.ass_attribute6 :=
1514: per_asg_shd.g_old_rec.ass_attribute6;
1510: per_asg_shd.g_old_rec.ass_attribute5;
1511: End If;
1512: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1513: p_rec.ass_attribute6 :=
1514: per_asg_shd.g_old_rec.ass_attribute6;
1515: End If;
1516: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1517: p_rec.ass_attribute7 :=
1518: per_asg_shd.g_old_rec.ass_attribute7;
1514: per_asg_shd.g_old_rec.ass_attribute6;
1515: End If;
1516: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1517: p_rec.ass_attribute7 :=
1518: per_asg_shd.g_old_rec.ass_attribute7;
1519: End If;
1520: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1521: p_rec.ass_attribute8 :=
1522: per_asg_shd.g_old_rec.ass_attribute8;
1518: per_asg_shd.g_old_rec.ass_attribute7;
1519: End If;
1520: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1521: p_rec.ass_attribute8 :=
1522: per_asg_shd.g_old_rec.ass_attribute8;
1523: End If;
1524: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1525: p_rec.ass_attribute9 :=
1526: per_asg_shd.g_old_rec.ass_attribute9;
1522: per_asg_shd.g_old_rec.ass_attribute8;
1523: End If;
1524: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1525: p_rec.ass_attribute9 :=
1526: per_asg_shd.g_old_rec.ass_attribute9;
1527: End If;
1528: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1529: p_rec.ass_attribute10 :=
1530: per_asg_shd.g_old_rec.ass_attribute10;
1526: per_asg_shd.g_old_rec.ass_attribute9;
1527: End If;
1528: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1529: p_rec.ass_attribute10 :=
1530: per_asg_shd.g_old_rec.ass_attribute10;
1531: End If;
1532: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1533: p_rec.ass_attribute11 :=
1534: per_asg_shd.g_old_rec.ass_attribute11;
1530: per_asg_shd.g_old_rec.ass_attribute10;
1531: End If;
1532: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1533: p_rec.ass_attribute11 :=
1534: per_asg_shd.g_old_rec.ass_attribute11;
1535: End If;
1536: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1537: p_rec.ass_attribute12 :=
1538: per_asg_shd.g_old_rec.ass_attribute12;
1534: per_asg_shd.g_old_rec.ass_attribute11;
1535: End If;
1536: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1537: p_rec.ass_attribute12 :=
1538: per_asg_shd.g_old_rec.ass_attribute12;
1539: End If;
1540: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1541: p_rec.ass_attribute13 :=
1542: per_asg_shd.g_old_rec.ass_attribute13;
1538: per_asg_shd.g_old_rec.ass_attribute12;
1539: End If;
1540: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1541: p_rec.ass_attribute13 :=
1542: per_asg_shd.g_old_rec.ass_attribute13;
1543: End If;
1544: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1545: p_rec.ass_attribute14 :=
1546: per_asg_shd.g_old_rec.ass_attribute14;
1542: per_asg_shd.g_old_rec.ass_attribute13;
1543: End If;
1544: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1545: p_rec.ass_attribute14 :=
1546: per_asg_shd.g_old_rec.ass_attribute14;
1547: End If;
1548: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1549: p_rec.ass_attribute15 :=
1550: per_asg_shd.g_old_rec.ass_attribute15;
1546: per_asg_shd.g_old_rec.ass_attribute14;
1547: End If;
1548: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1549: p_rec.ass_attribute15 :=
1550: per_asg_shd.g_old_rec.ass_attribute15;
1551: End If;
1552: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1553: p_rec.ass_attribute16 :=
1554: per_asg_shd.g_old_rec.ass_attribute16;
1550: per_asg_shd.g_old_rec.ass_attribute15;
1551: End If;
1552: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1553: p_rec.ass_attribute16 :=
1554: per_asg_shd.g_old_rec.ass_attribute16;
1555: End If;
1556: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1557: p_rec.ass_attribute17 :=
1558: per_asg_shd.g_old_rec.ass_attribute17;
1554: per_asg_shd.g_old_rec.ass_attribute16;
1555: End If;
1556: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1557: p_rec.ass_attribute17 :=
1558: per_asg_shd.g_old_rec.ass_attribute17;
1559: End If;
1560: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1561: p_rec.ass_attribute18 :=
1562: per_asg_shd.g_old_rec.ass_attribute18;
1558: per_asg_shd.g_old_rec.ass_attribute17;
1559: End If;
1560: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1561: p_rec.ass_attribute18 :=
1562: per_asg_shd.g_old_rec.ass_attribute18;
1563: End If;
1564: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1565: p_rec.ass_attribute19 :=
1566: per_asg_shd.g_old_rec.ass_attribute19;
1562: per_asg_shd.g_old_rec.ass_attribute18;
1563: End If;
1564: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1565: p_rec.ass_attribute19 :=
1566: per_asg_shd.g_old_rec.ass_attribute19;
1567: End If;
1568: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1569: p_rec.ass_attribute20 :=
1570: per_asg_shd.g_old_rec.ass_attribute20;
1566: per_asg_shd.g_old_rec.ass_attribute19;
1567: End If;
1568: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1569: p_rec.ass_attribute20 :=
1570: per_asg_shd.g_old_rec.ass_attribute20;
1571: End If;
1572: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute21 :=
1574: per_asg_shd.g_old_rec.ass_attribute21;
1570: per_asg_shd.g_old_rec.ass_attribute20;
1571: End If;
1572: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1573: p_rec.ass_attribute21 :=
1574: per_asg_shd.g_old_rec.ass_attribute21;
1575: End If;
1576: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute22 :=
1578: per_asg_shd.g_old_rec.ass_attribute22;
1574: per_asg_shd.g_old_rec.ass_attribute21;
1575: End If;
1576: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1577: p_rec.ass_attribute22 :=
1578: per_asg_shd.g_old_rec.ass_attribute22;
1579: End If;
1580: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute23 :=
1582: per_asg_shd.g_old_rec.ass_attribute23;
1578: per_asg_shd.g_old_rec.ass_attribute22;
1579: End If;
1580: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1581: p_rec.ass_attribute23 :=
1582: per_asg_shd.g_old_rec.ass_attribute23;
1583: End If;
1584: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute24 :=
1586: per_asg_shd.g_old_rec.ass_attribute24;
1582: per_asg_shd.g_old_rec.ass_attribute23;
1583: End If;
1584: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1585: p_rec.ass_attribute24 :=
1586: per_asg_shd.g_old_rec.ass_attribute24;
1587: End If;
1588: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute25 :=
1590: per_asg_shd.g_old_rec.ass_attribute25;
1586: per_asg_shd.g_old_rec.ass_attribute24;
1587: End If;
1588: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1589: p_rec.ass_attribute25 :=
1590: per_asg_shd.g_old_rec.ass_attribute25;
1591: End If;
1592: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute26 :=
1594: per_asg_shd.g_old_rec.ass_attribute26;
1590: per_asg_shd.g_old_rec.ass_attribute25;
1591: End If;
1592: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1593: p_rec.ass_attribute26 :=
1594: per_asg_shd.g_old_rec.ass_attribute26;
1595: End If;
1596: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute27 :=
1598: per_asg_shd.g_old_rec.ass_attribute27;
1594: per_asg_shd.g_old_rec.ass_attribute26;
1595: End If;
1596: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1597: p_rec.ass_attribute27 :=
1598: per_asg_shd.g_old_rec.ass_attribute27;
1599: End If;
1600: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute28 :=
1602: per_asg_shd.g_old_rec.ass_attribute28;
1598: per_asg_shd.g_old_rec.ass_attribute27;
1599: End If;
1600: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1601: p_rec.ass_attribute28 :=
1602: per_asg_shd.g_old_rec.ass_attribute28;
1603: End If;
1604: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute29 :=
1606: per_asg_shd.g_old_rec.ass_attribute29;
1602: per_asg_shd.g_old_rec.ass_attribute28;
1603: End If;
1604: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1605: p_rec.ass_attribute29 :=
1606: per_asg_shd.g_old_rec.ass_attribute29;
1607: End If;
1608: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute30 :=
1610: per_asg_shd.g_old_rec.ass_attribute30;
1606: per_asg_shd.g_old_rec.ass_attribute29;
1607: End If;
1608: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1609: p_rec.ass_attribute30 :=
1610: per_asg_shd.g_old_rec.ass_attribute30;
1611: End If;
1612: If (p_rec.title = hr_api.g_varchar2) then
1613: p_rec.title :=
1614: per_asg_shd.g_old_rec.title;
1610: per_asg_shd.g_old_rec.ass_attribute30;
1611: End If;
1612: If (p_rec.title = hr_api.g_varchar2) then
1613: p_rec.title :=
1614: per_asg_shd.g_old_rec.title;
1615: End If;
1616: If (p_rec.contract_id = hr_api.g_number) then
1617: p_rec.contract_id :=
1618: per_asg_shd.g_old_rec.contract_id;
1614: per_asg_shd.g_old_rec.title;
1615: End If;
1616: If (p_rec.contract_id = hr_api.g_number) then
1617: p_rec.contract_id :=
1618: per_asg_shd.g_old_rec.contract_id;
1619: End If;
1620: If (p_rec.establishment_id = hr_api.g_number) then
1621: p_rec.establishment_id :=
1622: per_asg_shd.g_old_rec.establishment_id;
1618: per_asg_shd.g_old_rec.contract_id;
1619: End If;
1620: If (p_rec.establishment_id = hr_api.g_number) then
1621: p_rec.establishment_id :=
1622: per_asg_shd.g_old_rec.establishment_id;
1623: End If;
1624: If (p_rec.collective_agreement_id = hr_api.g_number) then
1625: p_rec.collective_agreement_id :=
1626: per_asg_shd.g_old_rec.collective_agreement_id;
1622: per_asg_shd.g_old_rec.establishment_id;
1623: End If;
1624: If (p_rec.collective_agreement_id = hr_api.g_number) then
1625: p_rec.collective_agreement_id :=
1626: per_asg_shd.g_old_rec.collective_agreement_id;
1627: End If;
1628: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1629: p_rec.cagr_grade_def_id :=
1630: per_asg_shd.g_old_rec.cagr_grade_def_id;
1626: per_asg_shd.g_old_rec.collective_agreement_id;
1627: End If;
1628: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1629: p_rec.cagr_grade_def_id :=
1630: per_asg_shd.g_old_rec.cagr_grade_def_id;
1631: End If;
1632: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1633: p_rec.cagr_id_flex_num :=
1634: per_asg_shd.g_old_rec.cagr_id_flex_num;
1630: per_asg_shd.g_old_rec.cagr_grade_def_id;
1631: End If;
1632: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1633: p_rec.cagr_id_flex_num :=
1634: per_asg_shd.g_old_rec.cagr_id_flex_num;
1635: End If;
1636: If (p_rec.notice_period = hr_api.g_number) then
1637: p_rec.notice_period :=
1638: per_asg_shd.g_old_rec.notice_period;
1634: per_asg_shd.g_old_rec.cagr_id_flex_num;
1635: End If;
1636: If (p_rec.notice_period = hr_api.g_number) then
1637: p_rec.notice_period :=
1638: per_asg_shd.g_old_rec.notice_period;
1639: End If;
1640: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1641: p_rec.notice_period_uom :=
1642: per_asg_shd.g_old_rec.notice_period_uom;
1638: per_asg_shd.g_old_rec.notice_period;
1639: End If;
1640: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1641: p_rec.notice_period_uom :=
1642: per_asg_shd.g_old_rec.notice_period_uom;
1643: End If;
1644: If (p_rec.employee_category = hr_api.g_varchar2) then
1645: p_rec.employee_category :=
1646: per_asg_shd.g_old_rec.employee_category;
1642: per_asg_shd.g_old_rec.notice_period_uom;
1643: End If;
1644: If (p_rec.employee_category = hr_api.g_varchar2) then
1645: p_rec.employee_category :=
1646: per_asg_shd.g_old_rec.employee_category;
1647: End If;
1648: If (p_rec.work_at_home = hr_api.g_varchar2) then
1649: p_rec.work_at_home :=
1650: per_asg_shd.g_old_rec.work_at_home;
1646: per_asg_shd.g_old_rec.employee_category;
1647: End If;
1648: If (p_rec.work_at_home = hr_api.g_varchar2) then
1649: p_rec.work_at_home :=
1650: per_asg_shd.g_old_rec.work_at_home;
1651: End If;
1652: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1653: p_rec.job_post_source_name :=
1654: per_asg_shd.g_old_rec.job_post_source_name;
1650: per_asg_shd.g_old_rec.work_at_home;
1651: End If;
1652: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1653: p_rec.job_post_source_name :=
1654: per_asg_shd.g_old_rec.job_post_source_name;
1655: End If;
1656: If (p_rec.posting_content_id = hr_api.g_number) then
1657: p_rec.posting_content_id :=
1658: per_asg_shd.g_old_rec.posting_content_id;
1654: per_asg_shd.g_old_rec.job_post_source_name;
1655: End If;
1656: If (p_rec.posting_content_id = hr_api.g_number) then
1657: p_rec.posting_content_id :=
1658: per_asg_shd.g_old_rec.posting_content_id;
1659: End If;
1660: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1661: p_rec.period_of_placement_date_start :=
1662: per_asg_shd.g_old_rec.period_of_placement_date_start;
1658: per_asg_shd.g_old_rec.posting_content_id;
1659: End If;
1660: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1661: p_rec.period_of_placement_date_start :=
1662: per_asg_shd.g_old_rec.period_of_placement_date_start;
1663: End If;
1664: If (p_rec.vendor_id = hr_api.g_number) then
1665: p_rec.vendor_id :=
1666: per_asg_shd.g_old_rec.vendor_id;
1662: per_asg_shd.g_old_rec.period_of_placement_date_start;
1663: End If;
1664: If (p_rec.vendor_id = hr_api.g_number) then
1665: p_rec.vendor_id :=
1666: per_asg_shd.g_old_rec.vendor_id;
1667: End If;
1668: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1669: p_rec.vendor_employee_number :=
1670: per_asg_shd.g_old_rec.vendor_employee_number;
1666: per_asg_shd.g_old_rec.vendor_id;
1667: End If;
1668: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1669: p_rec.vendor_employee_number :=
1670: per_asg_shd.g_old_rec.vendor_employee_number;
1671: End If;
1672: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1673: p_rec.vendor_assignment_number :=
1674: per_asg_shd.g_old_rec.vendor_assignment_number;
1670: per_asg_shd.g_old_rec.vendor_employee_number;
1671: End If;
1672: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1673: p_rec.vendor_assignment_number :=
1674: per_asg_shd.g_old_rec.vendor_assignment_number;
1675: End If;
1676: If (p_rec.assignment_category = hr_api.g_varchar2) then
1677: p_rec.assignment_category :=
1678: per_asg_shd.g_old_rec.assignment_category;
1674: per_asg_shd.g_old_rec.vendor_assignment_number;
1675: End If;
1676: If (p_rec.assignment_category = hr_api.g_varchar2) then
1677: p_rec.assignment_category :=
1678: per_asg_shd.g_old_rec.assignment_category;
1679: End If;
1680: If (p_rec.project_title = hr_api.g_varchar2) then
1681: p_rec.project_title :=
1682: per_asg_shd.g_old_rec.project_title;
1678: per_asg_shd.g_old_rec.assignment_category;
1679: End If;
1680: If (p_rec.project_title = hr_api.g_varchar2) then
1681: p_rec.project_title :=
1682: per_asg_shd.g_old_rec.project_title;
1683: End If;
1684: If (p_rec.applicant_rank = hr_api.g_number) then
1685: p_rec.applicant_rank :=
1686: per_asg_shd.g_old_rec.applicant_rank;
1682: per_asg_shd.g_old_rec.project_title;
1683: End If;
1684: If (p_rec.applicant_rank = hr_api.g_number) then
1685: p_rec.applicant_rank :=
1686: per_asg_shd.g_old_rec.applicant_rank;
1687: End If;
1688: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1689: p_rec.grade_ladder_pgm_id :=
1690: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1686: per_asg_shd.g_old_rec.applicant_rank;
1687: End If;
1688: If (p_rec.grade_ladder_pgm_id = hr_api.g_number) then
1689: p_rec.grade_ladder_pgm_id :=
1690: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1691: End If;
1692: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1693: p_rec.supervisor_assignment_id :=
1694: per_asg_shd.g_old_rec.supervisor_assignment_id;
1690: per_asg_shd.g_old_rec.grade_ladder_pgm_id;
1691: End If;
1692: If (p_rec.supervisor_assignment_id = hr_api.g_number) then
1693: p_rec.supervisor_assignment_id :=
1694: per_asg_shd.g_old_rec.supervisor_assignment_id;
1695: End If;
1696: If (p_rec.vendor_site_id = hr_api.g_number) then
1697: p_rec.vendor_site_id :=
1698: per_asg_shd.g_old_rec.vendor_site_id;
1694: per_asg_shd.g_old_rec.supervisor_assignment_id;
1695: End If;
1696: If (p_rec.vendor_site_id = hr_api.g_number) then
1697: p_rec.vendor_site_id :=
1698: per_asg_shd.g_old_rec.vendor_site_id;
1699: End If;
1700: If (p_rec.po_header_id = hr_api.g_number) then
1701: p_rec.po_header_id :=
1702: per_asg_shd.g_old_rec.po_header_id;
1698: per_asg_shd.g_old_rec.vendor_site_id;
1699: End If;
1700: If (p_rec.po_header_id = hr_api.g_number) then
1701: p_rec.po_header_id :=
1702: per_asg_shd.g_old_rec.po_header_id;
1703: End If;
1704: If (p_rec.po_line_id = hr_api.g_number) then
1705: p_rec.po_line_id :=
1706: per_asg_shd.g_old_rec.po_line_id;
1702: per_asg_shd.g_old_rec.po_header_id;
1703: End If;
1704: If (p_rec.po_line_id = hr_api.g_number) then
1705: p_rec.po_line_id :=
1706: per_asg_shd.g_old_rec.po_line_id;
1707: End If;
1708: If (p_rec.projected_assignment_end = hr_api.g_date) then
1709: p_rec.projected_assignment_end :=
1710: per_asg_shd.g_old_rec.projected_assignment_end;
1706: per_asg_shd.g_old_rec.po_line_id;
1707: End If;
1708: If (p_rec.projected_assignment_end = hr_api.g_date) then
1709: p_rec.projected_assignment_end :=
1710: per_asg_shd.g_old_rec.projected_assignment_end;
1711: End If;
1712: --
1713: hr_utility.set_location(' Leaving:'||l_proc, 10);
1714: --
1718: -- |---------------------------------< upd >----------------------------------|
1719: -- ----------------------------------------------------------------------------
1720: Procedure upd
1721: (
1722: p_rec in out nocopy per_asg_shd.g_rec_type,
1723: p_effective_date in date,
1724: p_datetrack_mode in varchar2,
1725: p_validation_start_date out nocopy date,
1726: p_validation_end_date out nocopy date,
1760: End If;
1761: --
1762: -- We must lock the row which we need to update.
1763: --
1764: per_asg_shd.lck
1765: (p_effective_date => p_effective_date,
1766: p_datetrack_mode => p_datetrack_mode,
1767: p_assignment_id => p_rec.assignment_id,
1768: p_object_version_number => p_rec.object_version_number,
1989: p_datetrack_mode in varchar2,
1990: p_validate in boolean default false
1991: ) is
1992: --
1993: l_rec per_asg_shd.g_rec_type;
1994:
1995: l_proc varchar2(72) := g_package||'upd';
1996: --
1997: Begin
2000: -- Call conversion function to turn arguments into the
2001: -- l_rec structure.
2002: --
2003: l_rec :=
2004: per_asg_shd.convert_args
2005: (
2006: p_assignment_id,
2007: null,
2008: