[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy per_asg_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is
77: (p_base_table_name => 'per_all_assignments_f',
78: p_base_key_column => 'assignment_id',
79: p_base_key_value => p_rec.assignment_id);
80: --
81: per_asg_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the per_all_assignments_f Row
84: --
85: update per_all_assignments_f
184: where assignment_id = p_rec.assignment_id
185: and effective_start_date = p_validation_start_date
186: and effective_end_date = p_validation_end_date;
187: --
188: per_asg_shd.g_api_dml := false; -- Unset the api dml status
189: --
190: -- Set the effective start and end dates
191: --
192: p_rec.effective_start_date := p_validation_start_date;
196: hr_utility.set_location(' Leaving:'||l_proc, 15);
197: Exception
198: When hr_api.check_integrity_violated Then
199: -- A check constraint has been violated
200: per_asg_shd.g_api_dml := false; -- Unset the api dml status
201: per_asg_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
197: Exception
198: When hr_api.check_integrity_violated Then
199: -- A check constraint has been violated
200: per_asg_shd.g_api_dml := false; -- Unset the api dml status
201: per_asg_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
205: per_asg_shd.g_api_dml := false; -- Unset the api dml status
201: per_asg_shd.constraint_error
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
205: per_asg_shd.g_api_dml := false; -- Unset the api dml status
206: per_asg_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: per_asg_shd.g_api_dml := false; -- Unset the api dml status
202: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
203: When hr_api.unique_integrity_violated Then
204: -- Unique integrity has been violated
205: per_asg_shd.g_api_dml := false; -- Unset the api dml status
206: per_asg_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: per_asg_shd.g_api_dml := false; -- Unset the api dml status
210: Raise;
205: per_asg_shd.g_api_dml := false; -- Unset the api dml status
206: per_asg_shd.constraint_error
207: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
208: When Others Then
209: per_asg_shd.g_api_dml := false; -- Unset the api dml status
210: Raise;
211: End dt_update_dml;
212: --
213: -- ----------------------------------------------------------------------------
241: --
242: -- {End Of Comments}
243: -- ----------------------------------------------------------------------------
244: Procedure update_dml
245: (p_rec in out nocopy per_asg_shd.g_rec_type,
246: p_effective_date in date,
247: p_datetrack_mode in varchar2,
248: p_validation_start_date in date,
249: p_validation_end_date in date) is
305: --
306: -- {End Of Comments}
307: -- ----------------------------------------------------------------------------
308: Procedure dt_pre_update
309: (p_rec in out nocopy per_asg_shd.g_rec_type,
310: p_effective_date in date,
311: p_datetrack_mode in varchar2,
312: p_validation_start_date in date,
313: p_validation_end_date in date) is
321: hr_utility.set_location(l_proc, 10);
322: --
323: -- Update the current effective end date
324: --
325: per_asg_shd.upd_effective_end_date
326: (p_effective_date => p_effective_date,
327: p_base_key_value => p_rec.assignment_id,
328: p_new_effective_end_date => (p_validation_start_date - 1),
329: p_validation_start_date => p_validation_start_date,
390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure pre_update
394: (p_rec in out nocopy per_asg_shd.g_rec_type,
395: p_effective_date in date,
396: p_datetrack_mode in varchar2,
397: p_validation_start_date in date,
398: p_validation_end_date in date) is
426: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
427: p_comment_text => p_rec.comment_text);
428: -- Update the comments if they have changed
429: ElsIf (p_rec.comment_id is not null and p_rec.comment_text <>
430: per_asg_shd.g_old_rec.comment_text) then
431: hr_comm_api.upd(p_comment_id => p_rec.comment_id,
432: p_source_table_name => 'PER_ALL_ASSIGNMENTS_F',
433: p_comment_text => p_rec.comment_text);
434: End If;
574: --
575: -- {End Of Comments}
576: -- ----------------------------------------------------------------------------
577: Procedure post_update
578: (p_rec in per_asg_shd.g_rec_type,
579: p_effective_date in date,
580: p_datetrack_mode in varchar2,
581: p_validation_start_date in date,
582: p_validation_end_date in date,
712: ,p_po_header_id => p_rec.po_header_id
713: ,p_po_line_id => p_rec.po_line_id
714: ,p_projected_assignment_end => p_rec.projected_assignment_end
715: ,p_effective_start_date_o
716: => per_asg_shd.g_old_rec.effective_start_date
717: ,p_effective_end_date_o
718: => per_asg_shd.g_old_rec.effective_end_date
719: ,p_business_group_id_o
720: => per_asg_shd.g_old_rec.business_group_id
714: ,p_projected_assignment_end => p_rec.projected_assignment_end
715: ,p_effective_start_date_o
716: => per_asg_shd.g_old_rec.effective_start_date
717: ,p_effective_end_date_o
718: => per_asg_shd.g_old_rec.effective_end_date
719: ,p_business_group_id_o
720: => per_asg_shd.g_old_rec.business_group_id
721: ,p_recruiter_id_o
722: => per_asg_shd.g_old_rec.recruiter_id
716: => per_asg_shd.g_old_rec.effective_start_date
717: ,p_effective_end_date_o
718: => per_asg_shd.g_old_rec.effective_end_date
719: ,p_business_group_id_o
720: => per_asg_shd.g_old_rec.business_group_id
721: ,p_recruiter_id_o
722: => per_asg_shd.g_old_rec.recruiter_id
723: ,p_grade_id_o
724: => per_asg_shd.g_old_rec.grade_id
718: => per_asg_shd.g_old_rec.effective_end_date
719: ,p_business_group_id_o
720: => per_asg_shd.g_old_rec.business_group_id
721: ,p_recruiter_id_o
722: => per_asg_shd.g_old_rec.recruiter_id
723: ,p_grade_id_o
724: => per_asg_shd.g_old_rec.grade_id
725: ,p_position_id_o
726: => per_asg_shd.g_old_rec.position_id
720: => per_asg_shd.g_old_rec.business_group_id
721: ,p_recruiter_id_o
722: => per_asg_shd.g_old_rec.recruiter_id
723: ,p_grade_id_o
724: => per_asg_shd.g_old_rec.grade_id
725: ,p_position_id_o
726: => per_asg_shd.g_old_rec.position_id
727: ,p_job_id_o
728: => per_asg_shd.g_old_rec.job_id
722: => per_asg_shd.g_old_rec.recruiter_id
723: ,p_grade_id_o
724: => per_asg_shd.g_old_rec.grade_id
725: ,p_position_id_o
726: => per_asg_shd.g_old_rec.position_id
727: ,p_job_id_o
728: => per_asg_shd.g_old_rec.job_id
729: ,p_assignment_status_type_id_o
730: => per_asg_shd.g_old_rec.assignment_status_type_id
724: => per_asg_shd.g_old_rec.grade_id
725: ,p_position_id_o
726: => per_asg_shd.g_old_rec.position_id
727: ,p_job_id_o
728: => per_asg_shd.g_old_rec.job_id
729: ,p_assignment_status_type_id_o
730: => per_asg_shd.g_old_rec.assignment_status_type_id
731: ,p_payroll_id_o
732: => per_asg_shd.g_old_rec.payroll_id
726: => per_asg_shd.g_old_rec.position_id
727: ,p_job_id_o
728: => per_asg_shd.g_old_rec.job_id
729: ,p_assignment_status_type_id_o
730: => per_asg_shd.g_old_rec.assignment_status_type_id
731: ,p_payroll_id_o
732: => per_asg_shd.g_old_rec.payroll_id
733: ,p_location_id_o
734: => per_asg_shd.g_old_rec.location_id
728: => per_asg_shd.g_old_rec.job_id
729: ,p_assignment_status_type_id_o
730: => per_asg_shd.g_old_rec.assignment_status_type_id
731: ,p_payroll_id_o
732: => per_asg_shd.g_old_rec.payroll_id
733: ,p_location_id_o
734: => per_asg_shd.g_old_rec.location_id
735: ,p_person_referred_by_id_o
736: => per_asg_shd.g_old_rec.person_referred_by_id
730: => per_asg_shd.g_old_rec.assignment_status_type_id
731: ,p_payroll_id_o
732: => per_asg_shd.g_old_rec.payroll_id
733: ,p_location_id_o
734: => per_asg_shd.g_old_rec.location_id
735: ,p_person_referred_by_id_o
736: => per_asg_shd.g_old_rec.person_referred_by_id
737: ,p_supervisor_id_o
738: => per_asg_shd.g_old_rec.supervisor_id
732: => per_asg_shd.g_old_rec.payroll_id
733: ,p_location_id_o
734: => per_asg_shd.g_old_rec.location_id
735: ,p_person_referred_by_id_o
736: => per_asg_shd.g_old_rec.person_referred_by_id
737: ,p_supervisor_id_o
738: => per_asg_shd.g_old_rec.supervisor_id
739: ,p_special_ceiling_step_id_o
740: => per_asg_shd.g_old_rec.special_ceiling_step_id
734: => per_asg_shd.g_old_rec.location_id
735: ,p_person_referred_by_id_o
736: => per_asg_shd.g_old_rec.person_referred_by_id
737: ,p_supervisor_id_o
738: => per_asg_shd.g_old_rec.supervisor_id
739: ,p_special_ceiling_step_id_o
740: => per_asg_shd.g_old_rec.special_ceiling_step_id
741: ,p_person_id_o
742: => per_asg_shd.g_old_rec.person_id
736: => per_asg_shd.g_old_rec.person_referred_by_id
737: ,p_supervisor_id_o
738: => per_asg_shd.g_old_rec.supervisor_id
739: ,p_special_ceiling_step_id_o
740: => per_asg_shd.g_old_rec.special_ceiling_step_id
741: ,p_person_id_o
742: => per_asg_shd.g_old_rec.person_id
743: ,p_recruitment_activity_id_o
744: => per_asg_shd.g_old_rec.recruitment_activity_id
738: => per_asg_shd.g_old_rec.supervisor_id
739: ,p_special_ceiling_step_id_o
740: => per_asg_shd.g_old_rec.special_ceiling_step_id
741: ,p_person_id_o
742: => per_asg_shd.g_old_rec.person_id
743: ,p_recruitment_activity_id_o
744: => per_asg_shd.g_old_rec.recruitment_activity_id
745: ,p_source_organization_id_o
746: => per_asg_shd.g_old_rec.source_organization_id
740: => per_asg_shd.g_old_rec.special_ceiling_step_id
741: ,p_person_id_o
742: => per_asg_shd.g_old_rec.person_id
743: ,p_recruitment_activity_id_o
744: => per_asg_shd.g_old_rec.recruitment_activity_id
745: ,p_source_organization_id_o
746: => per_asg_shd.g_old_rec.source_organization_id
747: ,p_organization_id_o
748: => per_asg_shd.g_old_rec.organization_id
742: => per_asg_shd.g_old_rec.person_id
743: ,p_recruitment_activity_id_o
744: => per_asg_shd.g_old_rec.recruitment_activity_id
745: ,p_source_organization_id_o
746: => per_asg_shd.g_old_rec.source_organization_id
747: ,p_organization_id_o
748: => per_asg_shd.g_old_rec.organization_id
749: ,p_people_group_id_o
750: => per_asg_shd.g_old_rec.people_group_id
744: => per_asg_shd.g_old_rec.recruitment_activity_id
745: ,p_source_organization_id_o
746: => per_asg_shd.g_old_rec.source_organization_id
747: ,p_organization_id_o
748: => per_asg_shd.g_old_rec.organization_id
749: ,p_people_group_id_o
750: => per_asg_shd.g_old_rec.people_group_id
751: ,p_soft_coding_keyflex_id_o
752: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
746: => per_asg_shd.g_old_rec.source_organization_id
747: ,p_organization_id_o
748: => per_asg_shd.g_old_rec.organization_id
749: ,p_people_group_id_o
750: => per_asg_shd.g_old_rec.people_group_id
751: ,p_soft_coding_keyflex_id_o
752: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
753: ,p_vacancy_id_o
754: => per_asg_shd.g_old_rec.vacancy_id
748: => per_asg_shd.g_old_rec.organization_id
749: ,p_people_group_id_o
750: => per_asg_shd.g_old_rec.people_group_id
751: ,p_soft_coding_keyflex_id_o
752: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
753: ,p_vacancy_id_o
754: => per_asg_shd.g_old_rec.vacancy_id
755: ,p_assignment_sequence_o
756: => per_asg_shd.g_old_rec.assignment_sequence
750: => per_asg_shd.g_old_rec.people_group_id
751: ,p_soft_coding_keyflex_id_o
752: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
753: ,p_vacancy_id_o
754: => per_asg_shd.g_old_rec.vacancy_id
755: ,p_assignment_sequence_o
756: => per_asg_shd.g_old_rec.assignment_sequence
757: ,p_pay_basis_id_o
758: => per_asg_shd.g_old_rec.pay_basis_id
752: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
753: ,p_vacancy_id_o
754: => per_asg_shd.g_old_rec.vacancy_id
755: ,p_assignment_sequence_o
756: => per_asg_shd.g_old_rec.assignment_sequence
757: ,p_pay_basis_id_o
758: => per_asg_shd.g_old_rec.pay_basis_id
759: ,p_assignment_type_o
760: => per_asg_shd.g_old_rec.assignment_type
754: => per_asg_shd.g_old_rec.vacancy_id
755: ,p_assignment_sequence_o
756: => per_asg_shd.g_old_rec.assignment_sequence
757: ,p_pay_basis_id_o
758: => per_asg_shd.g_old_rec.pay_basis_id
759: ,p_assignment_type_o
760: => per_asg_shd.g_old_rec.assignment_type
761: ,p_primary_flag_o
762: => per_asg_shd.g_old_rec.primary_flag
756: => per_asg_shd.g_old_rec.assignment_sequence
757: ,p_pay_basis_id_o
758: => per_asg_shd.g_old_rec.pay_basis_id
759: ,p_assignment_type_o
760: => per_asg_shd.g_old_rec.assignment_type
761: ,p_primary_flag_o
762: => per_asg_shd.g_old_rec.primary_flag
763: ,p_application_id_o
764: => per_asg_shd.g_old_rec.application_id
758: => per_asg_shd.g_old_rec.pay_basis_id
759: ,p_assignment_type_o
760: => per_asg_shd.g_old_rec.assignment_type
761: ,p_primary_flag_o
762: => per_asg_shd.g_old_rec.primary_flag
763: ,p_application_id_o
764: => per_asg_shd.g_old_rec.application_id
765: ,p_assignment_number_o
766: => per_asg_shd.g_old_rec.assignment_number
760: => per_asg_shd.g_old_rec.assignment_type
761: ,p_primary_flag_o
762: => per_asg_shd.g_old_rec.primary_flag
763: ,p_application_id_o
764: => per_asg_shd.g_old_rec.application_id
765: ,p_assignment_number_o
766: => per_asg_shd.g_old_rec.assignment_number
767: ,p_change_reason_o
768: => per_asg_shd.g_old_rec.change_reason
762: => per_asg_shd.g_old_rec.primary_flag
763: ,p_application_id_o
764: => per_asg_shd.g_old_rec.application_id
765: ,p_assignment_number_o
766: => per_asg_shd.g_old_rec.assignment_number
767: ,p_change_reason_o
768: => per_asg_shd.g_old_rec.change_reason
769: ,p_comment_id_o
770: => per_asg_shd.g_old_rec.comment_id
764: => per_asg_shd.g_old_rec.application_id
765: ,p_assignment_number_o
766: => per_asg_shd.g_old_rec.assignment_number
767: ,p_change_reason_o
768: => per_asg_shd.g_old_rec.change_reason
769: ,p_comment_id_o
770: => per_asg_shd.g_old_rec.comment_id
771: ,p_date_probation_end_o
772: => per_asg_shd.g_old_rec.date_probation_end
766: => per_asg_shd.g_old_rec.assignment_number
767: ,p_change_reason_o
768: => per_asg_shd.g_old_rec.change_reason
769: ,p_comment_id_o
770: => per_asg_shd.g_old_rec.comment_id
771: ,p_date_probation_end_o
772: => per_asg_shd.g_old_rec.date_probation_end
773: ,p_default_code_comb_id_o
774: => per_asg_shd.g_old_rec.default_code_comb_id
768: => per_asg_shd.g_old_rec.change_reason
769: ,p_comment_id_o
770: => per_asg_shd.g_old_rec.comment_id
771: ,p_date_probation_end_o
772: => per_asg_shd.g_old_rec.date_probation_end
773: ,p_default_code_comb_id_o
774: => per_asg_shd.g_old_rec.default_code_comb_id
775: ,p_employment_category_o
776: => per_asg_shd.g_old_rec.employment_category
770: => per_asg_shd.g_old_rec.comment_id
771: ,p_date_probation_end_o
772: => per_asg_shd.g_old_rec.date_probation_end
773: ,p_default_code_comb_id_o
774: => per_asg_shd.g_old_rec.default_code_comb_id
775: ,p_employment_category_o
776: => per_asg_shd.g_old_rec.employment_category
777: ,p_frequency_o
778: => per_asg_shd.g_old_rec.frequency
772: => per_asg_shd.g_old_rec.date_probation_end
773: ,p_default_code_comb_id_o
774: => per_asg_shd.g_old_rec.default_code_comb_id
775: ,p_employment_category_o
776: => per_asg_shd.g_old_rec.employment_category
777: ,p_frequency_o
778: => per_asg_shd.g_old_rec.frequency
779: ,p_internal_address_line_o
780: => per_asg_shd.g_old_rec.internal_address_line
774: => per_asg_shd.g_old_rec.default_code_comb_id
775: ,p_employment_category_o
776: => per_asg_shd.g_old_rec.employment_category
777: ,p_frequency_o
778: => per_asg_shd.g_old_rec.frequency
779: ,p_internal_address_line_o
780: => per_asg_shd.g_old_rec.internal_address_line
781: ,p_manager_flag_o
782: => per_asg_shd.g_old_rec.manager_flag
776: => per_asg_shd.g_old_rec.employment_category
777: ,p_frequency_o
778: => per_asg_shd.g_old_rec.frequency
779: ,p_internal_address_line_o
780: => per_asg_shd.g_old_rec.internal_address_line
781: ,p_manager_flag_o
782: => per_asg_shd.g_old_rec.manager_flag
783: ,p_normal_hours_o
784: => per_asg_shd.g_old_rec.normal_hours
778: => per_asg_shd.g_old_rec.frequency
779: ,p_internal_address_line_o
780: => per_asg_shd.g_old_rec.internal_address_line
781: ,p_manager_flag_o
782: => per_asg_shd.g_old_rec.manager_flag
783: ,p_normal_hours_o
784: => per_asg_shd.g_old_rec.normal_hours
785: ,p_perf_review_period_o
786: => per_asg_shd.g_old_rec.perf_review_period
780: => per_asg_shd.g_old_rec.internal_address_line
781: ,p_manager_flag_o
782: => per_asg_shd.g_old_rec.manager_flag
783: ,p_normal_hours_o
784: => per_asg_shd.g_old_rec.normal_hours
785: ,p_perf_review_period_o
786: => per_asg_shd.g_old_rec.perf_review_period
787: ,p_perf_review_period_frequen_o
788: => per_asg_shd.g_old_rec.perf_review_period_frequency
782: => per_asg_shd.g_old_rec.manager_flag
783: ,p_normal_hours_o
784: => per_asg_shd.g_old_rec.normal_hours
785: ,p_perf_review_period_o
786: => per_asg_shd.g_old_rec.perf_review_period
787: ,p_perf_review_period_frequen_o
788: => per_asg_shd.g_old_rec.perf_review_period_frequency
789: ,p_period_of_service_id_o
790: => per_asg_shd.g_old_rec.period_of_service_id
784: => per_asg_shd.g_old_rec.normal_hours
785: ,p_perf_review_period_o
786: => per_asg_shd.g_old_rec.perf_review_period
787: ,p_perf_review_period_frequen_o
788: => per_asg_shd.g_old_rec.perf_review_period_frequency
789: ,p_period_of_service_id_o
790: => per_asg_shd.g_old_rec.period_of_service_id
791: ,p_probation_period_o
792: => per_asg_shd.g_old_rec.probation_period
786: => per_asg_shd.g_old_rec.perf_review_period
787: ,p_perf_review_period_frequen_o
788: => per_asg_shd.g_old_rec.perf_review_period_frequency
789: ,p_period_of_service_id_o
790: => per_asg_shd.g_old_rec.period_of_service_id
791: ,p_probation_period_o
792: => per_asg_shd.g_old_rec.probation_period
793: ,p_probation_unit_o
794: => per_asg_shd.g_old_rec.probation_unit
788: => per_asg_shd.g_old_rec.perf_review_period_frequency
789: ,p_period_of_service_id_o
790: => per_asg_shd.g_old_rec.period_of_service_id
791: ,p_probation_period_o
792: => per_asg_shd.g_old_rec.probation_period
793: ,p_probation_unit_o
794: => per_asg_shd.g_old_rec.probation_unit
795: ,p_sal_review_period_o
796: => per_asg_shd.g_old_rec.sal_review_period
790: => per_asg_shd.g_old_rec.period_of_service_id
791: ,p_probation_period_o
792: => per_asg_shd.g_old_rec.probation_period
793: ,p_probation_unit_o
794: => per_asg_shd.g_old_rec.probation_unit
795: ,p_sal_review_period_o
796: => per_asg_shd.g_old_rec.sal_review_period
797: ,p_sal_review_period_frequen_o
798: => per_asg_shd.g_old_rec.sal_review_period_frequency
792: => per_asg_shd.g_old_rec.probation_period
793: ,p_probation_unit_o
794: => per_asg_shd.g_old_rec.probation_unit
795: ,p_sal_review_period_o
796: => per_asg_shd.g_old_rec.sal_review_period
797: ,p_sal_review_period_frequen_o
798: => per_asg_shd.g_old_rec.sal_review_period_frequency
799: ,p_set_of_books_id_o
800: => per_asg_shd.g_old_rec.set_of_books_id
794: => per_asg_shd.g_old_rec.probation_unit
795: ,p_sal_review_period_o
796: => per_asg_shd.g_old_rec.sal_review_period
797: ,p_sal_review_period_frequen_o
798: => per_asg_shd.g_old_rec.sal_review_period_frequency
799: ,p_set_of_books_id_o
800: => per_asg_shd.g_old_rec.set_of_books_id
801: ,p_source_type_o
802: => per_asg_shd.g_old_rec.source_type
796: => per_asg_shd.g_old_rec.sal_review_period
797: ,p_sal_review_period_frequen_o
798: => per_asg_shd.g_old_rec.sal_review_period_frequency
799: ,p_set_of_books_id_o
800: => per_asg_shd.g_old_rec.set_of_books_id
801: ,p_source_type_o
802: => per_asg_shd.g_old_rec.source_type
803: ,p_time_normal_finish_o
804: => per_asg_shd.g_old_rec.time_normal_finish
798: => per_asg_shd.g_old_rec.sal_review_period_frequency
799: ,p_set_of_books_id_o
800: => per_asg_shd.g_old_rec.set_of_books_id
801: ,p_source_type_o
802: => per_asg_shd.g_old_rec.source_type
803: ,p_time_normal_finish_o
804: => per_asg_shd.g_old_rec.time_normal_finish
805: ,p_time_normal_start_o
806: => per_asg_shd.g_old_rec.time_normal_start
800: => per_asg_shd.g_old_rec.set_of_books_id
801: ,p_source_type_o
802: => per_asg_shd.g_old_rec.source_type
803: ,p_time_normal_finish_o
804: => per_asg_shd.g_old_rec.time_normal_finish
805: ,p_time_normal_start_o
806: => per_asg_shd.g_old_rec.time_normal_start
807: ,p_bargaining_unit_code_o
808: => per_asg_shd.g_old_rec.bargaining_unit_code
802: => per_asg_shd.g_old_rec.source_type
803: ,p_time_normal_finish_o
804: => per_asg_shd.g_old_rec.time_normal_finish
805: ,p_time_normal_start_o
806: => per_asg_shd.g_old_rec.time_normal_start
807: ,p_bargaining_unit_code_o
808: => per_asg_shd.g_old_rec.bargaining_unit_code
809: ,p_labour_union_member_flag_o
810: => per_asg_shd.g_old_rec.labour_union_member_flag
804: => per_asg_shd.g_old_rec.time_normal_finish
805: ,p_time_normal_start_o
806: => per_asg_shd.g_old_rec.time_normal_start
807: ,p_bargaining_unit_code_o
808: => per_asg_shd.g_old_rec.bargaining_unit_code
809: ,p_labour_union_member_flag_o
810: => per_asg_shd.g_old_rec.labour_union_member_flag
811: ,p_hourly_salaried_code_o
812: => per_asg_shd.g_old_rec.hourly_salaried_code
806: => per_asg_shd.g_old_rec.time_normal_start
807: ,p_bargaining_unit_code_o
808: => per_asg_shd.g_old_rec.bargaining_unit_code
809: ,p_labour_union_member_flag_o
810: => per_asg_shd.g_old_rec.labour_union_member_flag
811: ,p_hourly_salaried_code_o
812: => per_asg_shd.g_old_rec.hourly_salaried_code
813: ,p_request_id_o
814: => per_asg_shd.g_old_rec.request_id
808: => per_asg_shd.g_old_rec.bargaining_unit_code
809: ,p_labour_union_member_flag_o
810: => per_asg_shd.g_old_rec.labour_union_member_flag
811: ,p_hourly_salaried_code_o
812: => per_asg_shd.g_old_rec.hourly_salaried_code
813: ,p_request_id_o
814: => per_asg_shd.g_old_rec.request_id
815: ,p_program_application_id_o
816: => per_asg_shd.g_old_rec.program_application_id
810: => per_asg_shd.g_old_rec.labour_union_member_flag
811: ,p_hourly_salaried_code_o
812: => per_asg_shd.g_old_rec.hourly_salaried_code
813: ,p_request_id_o
814: => per_asg_shd.g_old_rec.request_id
815: ,p_program_application_id_o
816: => per_asg_shd.g_old_rec.program_application_id
817: ,p_program_id_o
818: => per_asg_shd.g_old_rec.program_id
812: => per_asg_shd.g_old_rec.hourly_salaried_code
813: ,p_request_id_o
814: => per_asg_shd.g_old_rec.request_id
815: ,p_program_application_id_o
816: => per_asg_shd.g_old_rec.program_application_id
817: ,p_program_id_o
818: => per_asg_shd.g_old_rec.program_id
819: ,p_program_update_date_o
820: => per_asg_shd.g_old_rec.program_update_date
814: => per_asg_shd.g_old_rec.request_id
815: ,p_program_application_id_o
816: => per_asg_shd.g_old_rec.program_application_id
817: ,p_program_id_o
818: => per_asg_shd.g_old_rec.program_id
819: ,p_program_update_date_o
820: => per_asg_shd.g_old_rec.program_update_date
821: ,p_ass_attribute_category_o
822: => per_asg_shd.g_old_rec.ass_attribute_category
816: => per_asg_shd.g_old_rec.program_application_id
817: ,p_program_id_o
818: => per_asg_shd.g_old_rec.program_id
819: ,p_program_update_date_o
820: => per_asg_shd.g_old_rec.program_update_date
821: ,p_ass_attribute_category_o
822: => per_asg_shd.g_old_rec.ass_attribute_category
823: ,p_ass_attribute1_o
824: => per_asg_shd.g_old_rec.ass_attribute1
818: => per_asg_shd.g_old_rec.program_id
819: ,p_program_update_date_o
820: => per_asg_shd.g_old_rec.program_update_date
821: ,p_ass_attribute_category_o
822: => per_asg_shd.g_old_rec.ass_attribute_category
823: ,p_ass_attribute1_o
824: => per_asg_shd.g_old_rec.ass_attribute1
825: ,p_ass_attribute2_o
826: => per_asg_shd.g_old_rec.ass_attribute2
820: => per_asg_shd.g_old_rec.program_update_date
821: ,p_ass_attribute_category_o
822: => per_asg_shd.g_old_rec.ass_attribute_category
823: ,p_ass_attribute1_o
824: => per_asg_shd.g_old_rec.ass_attribute1
825: ,p_ass_attribute2_o
826: => per_asg_shd.g_old_rec.ass_attribute2
827: ,p_ass_attribute3_o
828: => per_asg_shd.g_old_rec.ass_attribute3
822: => per_asg_shd.g_old_rec.ass_attribute_category
823: ,p_ass_attribute1_o
824: => per_asg_shd.g_old_rec.ass_attribute1
825: ,p_ass_attribute2_o
826: => per_asg_shd.g_old_rec.ass_attribute2
827: ,p_ass_attribute3_o
828: => per_asg_shd.g_old_rec.ass_attribute3
829: ,p_ass_attribute4_o
830: => per_asg_shd.g_old_rec.ass_attribute4
824: => per_asg_shd.g_old_rec.ass_attribute1
825: ,p_ass_attribute2_o
826: => per_asg_shd.g_old_rec.ass_attribute2
827: ,p_ass_attribute3_o
828: => per_asg_shd.g_old_rec.ass_attribute3
829: ,p_ass_attribute4_o
830: => per_asg_shd.g_old_rec.ass_attribute4
831: ,p_ass_attribute5_o
832: => per_asg_shd.g_old_rec.ass_attribute5
826: => per_asg_shd.g_old_rec.ass_attribute2
827: ,p_ass_attribute3_o
828: => per_asg_shd.g_old_rec.ass_attribute3
829: ,p_ass_attribute4_o
830: => per_asg_shd.g_old_rec.ass_attribute4
831: ,p_ass_attribute5_o
832: => per_asg_shd.g_old_rec.ass_attribute5
833: ,p_ass_attribute6_o
834: => per_asg_shd.g_old_rec.ass_attribute6
828: => per_asg_shd.g_old_rec.ass_attribute3
829: ,p_ass_attribute4_o
830: => per_asg_shd.g_old_rec.ass_attribute4
831: ,p_ass_attribute5_o
832: => per_asg_shd.g_old_rec.ass_attribute5
833: ,p_ass_attribute6_o
834: => per_asg_shd.g_old_rec.ass_attribute6
835: ,p_ass_attribute7_o
836: => per_asg_shd.g_old_rec.ass_attribute7
830: => per_asg_shd.g_old_rec.ass_attribute4
831: ,p_ass_attribute5_o
832: => per_asg_shd.g_old_rec.ass_attribute5
833: ,p_ass_attribute6_o
834: => per_asg_shd.g_old_rec.ass_attribute6
835: ,p_ass_attribute7_o
836: => per_asg_shd.g_old_rec.ass_attribute7
837: ,p_ass_attribute8_o
838: => per_asg_shd.g_old_rec.ass_attribute8
832: => per_asg_shd.g_old_rec.ass_attribute5
833: ,p_ass_attribute6_o
834: => per_asg_shd.g_old_rec.ass_attribute6
835: ,p_ass_attribute7_o
836: => per_asg_shd.g_old_rec.ass_attribute7
837: ,p_ass_attribute8_o
838: => per_asg_shd.g_old_rec.ass_attribute8
839: ,p_ass_attribute9_o
840: => per_asg_shd.g_old_rec.ass_attribute9
834: => per_asg_shd.g_old_rec.ass_attribute6
835: ,p_ass_attribute7_o
836: => per_asg_shd.g_old_rec.ass_attribute7
837: ,p_ass_attribute8_o
838: => per_asg_shd.g_old_rec.ass_attribute8
839: ,p_ass_attribute9_o
840: => per_asg_shd.g_old_rec.ass_attribute9
841: ,p_ass_attribute10_o
842: => per_asg_shd.g_old_rec.ass_attribute10
836: => per_asg_shd.g_old_rec.ass_attribute7
837: ,p_ass_attribute8_o
838: => per_asg_shd.g_old_rec.ass_attribute8
839: ,p_ass_attribute9_o
840: => per_asg_shd.g_old_rec.ass_attribute9
841: ,p_ass_attribute10_o
842: => per_asg_shd.g_old_rec.ass_attribute10
843: ,p_ass_attribute11_o
844: => per_asg_shd.g_old_rec.ass_attribute11
838: => per_asg_shd.g_old_rec.ass_attribute8
839: ,p_ass_attribute9_o
840: => per_asg_shd.g_old_rec.ass_attribute9
841: ,p_ass_attribute10_o
842: => per_asg_shd.g_old_rec.ass_attribute10
843: ,p_ass_attribute11_o
844: => per_asg_shd.g_old_rec.ass_attribute11
845: ,p_ass_attribute12_o
846: => per_asg_shd.g_old_rec.ass_attribute12
840: => per_asg_shd.g_old_rec.ass_attribute9
841: ,p_ass_attribute10_o
842: => per_asg_shd.g_old_rec.ass_attribute10
843: ,p_ass_attribute11_o
844: => per_asg_shd.g_old_rec.ass_attribute11
845: ,p_ass_attribute12_o
846: => per_asg_shd.g_old_rec.ass_attribute12
847: ,p_ass_attribute13_o
848: => per_asg_shd.g_old_rec.ass_attribute13
842: => per_asg_shd.g_old_rec.ass_attribute10
843: ,p_ass_attribute11_o
844: => per_asg_shd.g_old_rec.ass_attribute11
845: ,p_ass_attribute12_o
846: => per_asg_shd.g_old_rec.ass_attribute12
847: ,p_ass_attribute13_o
848: => per_asg_shd.g_old_rec.ass_attribute13
849: ,p_ass_attribute14_o
850: => per_asg_shd.g_old_rec.ass_attribute14
844: => per_asg_shd.g_old_rec.ass_attribute11
845: ,p_ass_attribute12_o
846: => per_asg_shd.g_old_rec.ass_attribute12
847: ,p_ass_attribute13_o
848: => per_asg_shd.g_old_rec.ass_attribute13
849: ,p_ass_attribute14_o
850: => per_asg_shd.g_old_rec.ass_attribute14
851: ,p_ass_attribute15_o
852: => per_asg_shd.g_old_rec.ass_attribute15
846: => per_asg_shd.g_old_rec.ass_attribute12
847: ,p_ass_attribute13_o
848: => per_asg_shd.g_old_rec.ass_attribute13
849: ,p_ass_attribute14_o
850: => per_asg_shd.g_old_rec.ass_attribute14
851: ,p_ass_attribute15_o
852: => per_asg_shd.g_old_rec.ass_attribute15
853: ,p_ass_attribute16_o
854: => per_asg_shd.g_old_rec.ass_attribute16
848: => per_asg_shd.g_old_rec.ass_attribute13
849: ,p_ass_attribute14_o
850: => per_asg_shd.g_old_rec.ass_attribute14
851: ,p_ass_attribute15_o
852: => per_asg_shd.g_old_rec.ass_attribute15
853: ,p_ass_attribute16_o
854: => per_asg_shd.g_old_rec.ass_attribute16
855: ,p_ass_attribute17_o
856: => per_asg_shd.g_old_rec.ass_attribute17
850: => per_asg_shd.g_old_rec.ass_attribute14
851: ,p_ass_attribute15_o
852: => per_asg_shd.g_old_rec.ass_attribute15
853: ,p_ass_attribute16_o
854: => per_asg_shd.g_old_rec.ass_attribute16
855: ,p_ass_attribute17_o
856: => per_asg_shd.g_old_rec.ass_attribute17
857: ,p_ass_attribute18_o
858: => per_asg_shd.g_old_rec.ass_attribute18
852: => per_asg_shd.g_old_rec.ass_attribute15
853: ,p_ass_attribute16_o
854: => per_asg_shd.g_old_rec.ass_attribute16
855: ,p_ass_attribute17_o
856: => per_asg_shd.g_old_rec.ass_attribute17
857: ,p_ass_attribute18_o
858: => per_asg_shd.g_old_rec.ass_attribute18
859: ,p_ass_attribute19_o
860: => per_asg_shd.g_old_rec.ass_attribute19
854: => per_asg_shd.g_old_rec.ass_attribute16
855: ,p_ass_attribute17_o
856: => per_asg_shd.g_old_rec.ass_attribute17
857: ,p_ass_attribute18_o
858: => per_asg_shd.g_old_rec.ass_attribute18
859: ,p_ass_attribute19_o
860: => per_asg_shd.g_old_rec.ass_attribute19
861: ,p_ass_attribute20_o
862: => per_asg_shd.g_old_rec.ass_attribute20
856: => per_asg_shd.g_old_rec.ass_attribute17
857: ,p_ass_attribute18_o
858: => per_asg_shd.g_old_rec.ass_attribute18
859: ,p_ass_attribute19_o
860: => per_asg_shd.g_old_rec.ass_attribute19
861: ,p_ass_attribute20_o
862: => per_asg_shd.g_old_rec.ass_attribute20
863: ,p_ass_attribute21_o
864: => per_asg_shd.g_old_rec.ass_attribute21
858: => per_asg_shd.g_old_rec.ass_attribute18
859: ,p_ass_attribute19_o
860: => per_asg_shd.g_old_rec.ass_attribute19
861: ,p_ass_attribute20_o
862: => per_asg_shd.g_old_rec.ass_attribute20
863: ,p_ass_attribute21_o
864: => per_asg_shd.g_old_rec.ass_attribute21
865: ,p_ass_attribute22_o
866: => per_asg_shd.g_old_rec.ass_attribute22
860: => per_asg_shd.g_old_rec.ass_attribute19
861: ,p_ass_attribute20_o
862: => per_asg_shd.g_old_rec.ass_attribute20
863: ,p_ass_attribute21_o
864: => per_asg_shd.g_old_rec.ass_attribute21
865: ,p_ass_attribute22_o
866: => per_asg_shd.g_old_rec.ass_attribute22
867: ,p_ass_attribute23_o
868: => per_asg_shd.g_old_rec.ass_attribute23
862: => per_asg_shd.g_old_rec.ass_attribute20
863: ,p_ass_attribute21_o
864: => per_asg_shd.g_old_rec.ass_attribute21
865: ,p_ass_attribute22_o
866: => per_asg_shd.g_old_rec.ass_attribute22
867: ,p_ass_attribute23_o
868: => per_asg_shd.g_old_rec.ass_attribute23
869: ,p_ass_attribute24_o
870: => per_asg_shd.g_old_rec.ass_attribute24
864: => per_asg_shd.g_old_rec.ass_attribute21
865: ,p_ass_attribute22_o
866: => per_asg_shd.g_old_rec.ass_attribute22
867: ,p_ass_attribute23_o
868: => per_asg_shd.g_old_rec.ass_attribute23
869: ,p_ass_attribute24_o
870: => per_asg_shd.g_old_rec.ass_attribute24
871: ,p_ass_attribute25_o
872: => per_asg_shd.g_old_rec.ass_attribute25
866: => per_asg_shd.g_old_rec.ass_attribute22
867: ,p_ass_attribute23_o
868: => per_asg_shd.g_old_rec.ass_attribute23
869: ,p_ass_attribute24_o
870: => per_asg_shd.g_old_rec.ass_attribute24
871: ,p_ass_attribute25_o
872: => per_asg_shd.g_old_rec.ass_attribute25
873: ,p_ass_attribute26_o
874: => per_asg_shd.g_old_rec.ass_attribute26
868: => per_asg_shd.g_old_rec.ass_attribute23
869: ,p_ass_attribute24_o
870: => per_asg_shd.g_old_rec.ass_attribute24
871: ,p_ass_attribute25_o
872: => per_asg_shd.g_old_rec.ass_attribute25
873: ,p_ass_attribute26_o
874: => per_asg_shd.g_old_rec.ass_attribute26
875: ,p_ass_attribute27_o
876: => per_asg_shd.g_old_rec.ass_attribute27
870: => per_asg_shd.g_old_rec.ass_attribute24
871: ,p_ass_attribute25_o
872: => per_asg_shd.g_old_rec.ass_attribute25
873: ,p_ass_attribute26_o
874: => per_asg_shd.g_old_rec.ass_attribute26
875: ,p_ass_attribute27_o
876: => per_asg_shd.g_old_rec.ass_attribute27
877: ,p_ass_attribute28_o
878: => per_asg_shd.g_old_rec.ass_attribute28
872: => per_asg_shd.g_old_rec.ass_attribute25
873: ,p_ass_attribute26_o
874: => per_asg_shd.g_old_rec.ass_attribute26
875: ,p_ass_attribute27_o
876: => per_asg_shd.g_old_rec.ass_attribute27
877: ,p_ass_attribute28_o
878: => per_asg_shd.g_old_rec.ass_attribute28
879: ,p_ass_attribute29_o
880: => per_asg_shd.g_old_rec.ass_attribute29
874: => per_asg_shd.g_old_rec.ass_attribute26
875: ,p_ass_attribute27_o
876: => per_asg_shd.g_old_rec.ass_attribute27
877: ,p_ass_attribute28_o
878: => per_asg_shd.g_old_rec.ass_attribute28
879: ,p_ass_attribute29_o
880: => per_asg_shd.g_old_rec.ass_attribute29
881: ,p_ass_attribute30_o
882: => per_asg_shd.g_old_rec.ass_attribute30
876: => per_asg_shd.g_old_rec.ass_attribute27
877: ,p_ass_attribute28_o
878: => per_asg_shd.g_old_rec.ass_attribute28
879: ,p_ass_attribute29_o
880: => per_asg_shd.g_old_rec.ass_attribute29
881: ,p_ass_attribute30_o
882: => per_asg_shd.g_old_rec.ass_attribute30
883: ,p_title_o
884: => per_asg_shd.g_old_rec.title
878: => per_asg_shd.g_old_rec.ass_attribute28
879: ,p_ass_attribute29_o
880: => per_asg_shd.g_old_rec.ass_attribute29
881: ,p_ass_attribute30_o
882: => per_asg_shd.g_old_rec.ass_attribute30
883: ,p_title_o
884: => per_asg_shd.g_old_rec.title
885: ,p_contract_id_o
886: => per_asg_shd.g_old_rec.contract_id
880: => per_asg_shd.g_old_rec.ass_attribute29
881: ,p_ass_attribute30_o
882: => per_asg_shd.g_old_rec.ass_attribute30
883: ,p_title_o
884: => per_asg_shd.g_old_rec.title
885: ,p_contract_id_o
886: => per_asg_shd.g_old_rec.contract_id
887: ,p_establishment_id_o
888: => per_asg_shd.g_old_rec.establishment_id
882: => per_asg_shd.g_old_rec.ass_attribute30
883: ,p_title_o
884: => per_asg_shd.g_old_rec.title
885: ,p_contract_id_o
886: => per_asg_shd.g_old_rec.contract_id
887: ,p_establishment_id_o
888: => per_asg_shd.g_old_rec.establishment_id
889: ,p_collective_agreement_id_o
890: => per_asg_shd.g_old_rec.collective_agreement_id
884: => per_asg_shd.g_old_rec.title
885: ,p_contract_id_o
886: => per_asg_shd.g_old_rec.contract_id
887: ,p_establishment_id_o
888: => per_asg_shd.g_old_rec.establishment_id
889: ,p_collective_agreement_id_o
890: => per_asg_shd.g_old_rec.collective_agreement_id
891: ,p_cagr_grade_def_id_o
892: => per_asg_shd.g_old_rec.cagr_grade_def_id
886: => per_asg_shd.g_old_rec.contract_id
887: ,p_establishment_id_o
888: => per_asg_shd.g_old_rec.establishment_id
889: ,p_collective_agreement_id_o
890: => per_asg_shd.g_old_rec.collective_agreement_id
891: ,p_cagr_grade_def_id_o
892: => per_asg_shd.g_old_rec.cagr_grade_def_id
893: ,p_cagr_id_flex_num_o
894: => per_asg_shd.g_old_rec.cagr_id_flex_num
888: => per_asg_shd.g_old_rec.establishment_id
889: ,p_collective_agreement_id_o
890: => per_asg_shd.g_old_rec.collective_agreement_id
891: ,p_cagr_grade_def_id_o
892: => per_asg_shd.g_old_rec.cagr_grade_def_id
893: ,p_cagr_id_flex_num_o
894: => per_asg_shd.g_old_rec.cagr_id_flex_num
895: ,p_object_version_number_o
896: => per_asg_shd.g_old_rec.object_version_number
890: => per_asg_shd.g_old_rec.collective_agreement_id
891: ,p_cagr_grade_def_id_o
892: => per_asg_shd.g_old_rec.cagr_grade_def_id
893: ,p_cagr_id_flex_num_o
894: => per_asg_shd.g_old_rec.cagr_id_flex_num
895: ,p_object_version_number_o
896: => per_asg_shd.g_old_rec.object_version_number
897: ,p_notice_period_o
898: => per_asg_shd.g_old_rec.notice_period
892: => per_asg_shd.g_old_rec.cagr_grade_def_id
893: ,p_cagr_id_flex_num_o
894: => per_asg_shd.g_old_rec.cagr_id_flex_num
895: ,p_object_version_number_o
896: => per_asg_shd.g_old_rec.object_version_number
897: ,p_notice_period_o
898: => per_asg_shd.g_old_rec.notice_period
899: ,p_notice_period_uom_o
900: => per_asg_shd.g_old_rec.notice_period_uom
894: => per_asg_shd.g_old_rec.cagr_id_flex_num
895: ,p_object_version_number_o
896: => per_asg_shd.g_old_rec.object_version_number
897: ,p_notice_period_o
898: => per_asg_shd.g_old_rec.notice_period
899: ,p_notice_period_uom_o
900: => per_asg_shd.g_old_rec.notice_period_uom
901: ,p_employee_category_o
902: => per_asg_shd.g_old_rec.employee_category
896: => per_asg_shd.g_old_rec.object_version_number
897: ,p_notice_period_o
898: => per_asg_shd.g_old_rec.notice_period
899: ,p_notice_period_uom_o
900: => per_asg_shd.g_old_rec.notice_period_uom
901: ,p_employee_category_o
902: => per_asg_shd.g_old_rec.employee_category
903: ,p_work_at_home_o
904: => per_asg_shd.g_old_rec.work_at_home
898: => per_asg_shd.g_old_rec.notice_period
899: ,p_notice_period_uom_o
900: => per_asg_shd.g_old_rec.notice_period_uom
901: ,p_employee_category_o
902: => per_asg_shd.g_old_rec.employee_category
903: ,p_work_at_home_o
904: => per_asg_shd.g_old_rec.work_at_home
905: ,p_job_post_source_name_o
906: => per_asg_shd.g_old_rec.job_post_source_name
900: => per_asg_shd.g_old_rec.notice_period_uom
901: ,p_employee_category_o
902: => per_asg_shd.g_old_rec.employee_category
903: ,p_work_at_home_o
904: => per_asg_shd.g_old_rec.work_at_home
905: ,p_job_post_source_name_o
906: => per_asg_shd.g_old_rec.job_post_source_name
907: ,p_posting_content_id_o
908: => per_asg_shd.g_old_rec.posting_content_id
902: => per_asg_shd.g_old_rec.employee_category
903: ,p_work_at_home_o
904: => per_asg_shd.g_old_rec.work_at_home
905: ,p_job_post_source_name_o
906: => per_asg_shd.g_old_rec.job_post_source_name
907: ,p_posting_content_id_o
908: => per_asg_shd.g_old_rec.posting_content_id
909: ,p_placement_date_start_o
910: => per_asg_shd.g_old_rec.period_of_placement_date_start
904: => per_asg_shd.g_old_rec.work_at_home
905: ,p_job_post_source_name_o
906: => per_asg_shd.g_old_rec.job_post_source_name
907: ,p_posting_content_id_o
908: => per_asg_shd.g_old_rec.posting_content_id
909: ,p_placement_date_start_o
910: => per_asg_shd.g_old_rec.period_of_placement_date_start
911: ,p_vendor_id_o
912: => per_asg_shd.g_old_rec.vendor_id
906: => per_asg_shd.g_old_rec.job_post_source_name
907: ,p_posting_content_id_o
908: => per_asg_shd.g_old_rec.posting_content_id
909: ,p_placement_date_start_o
910: => per_asg_shd.g_old_rec.period_of_placement_date_start
911: ,p_vendor_id_o
912: => per_asg_shd.g_old_rec.vendor_id
913: ,p_vendor_employee_number_o
914: => per_asg_shd.g_old_rec.vendor_employee_number
908: => per_asg_shd.g_old_rec.posting_content_id
909: ,p_placement_date_start_o
910: => per_asg_shd.g_old_rec.period_of_placement_date_start
911: ,p_vendor_id_o
912: => per_asg_shd.g_old_rec.vendor_id
913: ,p_vendor_employee_number_o
914: => per_asg_shd.g_old_rec.vendor_employee_number
915: ,p_vendor_assignment_number_o
916: => per_asg_shd.g_old_rec.vendor_assignment_number
910: => per_asg_shd.g_old_rec.period_of_placement_date_start
911: ,p_vendor_id_o
912: => per_asg_shd.g_old_rec.vendor_id
913: ,p_vendor_employee_number_o
914: => per_asg_shd.g_old_rec.vendor_employee_number
915: ,p_vendor_assignment_number_o
916: => per_asg_shd.g_old_rec.vendor_assignment_number
917: ,p_assignment_category_o
918: => per_asg_shd.g_old_rec.assignment_category
912: => per_asg_shd.g_old_rec.vendor_id
913: ,p_vendor_employee_number_o
914: => per_asg_shd.g_old_rec.vendor_employee_number
915: ,p_vendor_assignment_number_o
916: => per_asg_shd.g_old_rec.vendor_assignment_number
917: ,p_assignment_category_o
918: => per_asg_shd.g_old_rec.assignment_category
919: ,p_project_title_o
920: => per_asg_shd.g_old_rec.project_title
914: => per_asg_shd.g_old_rec.vendor_employee_number
915: ,p_vendor_assignment_number_o
916: => per_asg_shd.g_old_rec.vendor_assignment_number
917: ,p_assignment_category_o
918: => per_asg_shd.g_old_rec.assignment_category
919: ,p_project_title_o
920: => per_asg_shd.g_old_rec.project_title
921: ,p_applicant_rank_o
922: => per_asg_shd.g_old_rec.applicant_rank
916: => per_asg_shd.g_old_rec.vendor_assignment_number
917: ,p_assignment_category_o
918: => per_asg_shd.g_old_rec.assignment_category
919: ,p_project_title_o
920: => per_asg_shd.g_old_rec.project_title
921: ,p_applicant_rank_o
922: => per_asg_shd.g_old_rec.applicant_rank
923: ,p_grade_ladder_pgm_id_o
924: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
918: => per_asg_shd.g_old_rec.assignment_category
919: ,p_project_title_o
920: => per_asg_shd.g_old_rec.project_title
921: ,p_applicant_rank_o
922: => per_asg_shd.g_old_rec.applicant_rank
923: ,p_grade_ladder_pgm_id_o
924: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
925: ,p_supervisor_assignment_id_o
926: => per_asg_shd.g_old_rec.supervisor_assignment_id /*Bug 2976136*/
920: => per_asg_shd.g_old_rec.project_title
921: ,p_applicant_rank_o
922: => per_asg_shd.g_old_rec.applicant_rank
923: ,p_grade_ladder_pgm_id_o
924: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
925: ,p_supervisor_assignment_id_o
926: => per_asg_shd.g_old_rec.supervisor_assignment_id /*Bug 2976136*/
927: ,p_vendor_site_id_o => per_asg_shd.g_old_rec.vendor_site_id
928: ,p_po_header_id_o => per_asg_shd.g_old_rec.po_header_id
922: => per_asg_shd.g_old_rec.applicant_rank
923: ,p_grade_ladder_pgm_id_o
924: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
925: ,p_supervisor_assignment_id_o
926: => per_asg_shd.g_old_rec.supervisor_assignment_id /*Bug 2976136*/
927: ,p_vendor_site_id_o => per_asg_shd.g_old_rec.vendor_site_id
928: ,p_po_header_id_o => per_asg_shd.g_old_rec.po_header_id
929: ,p_po_line_id_o => per_asg_shd.g_old_rec.po_line_id
930: ,p_projected_assignment_end_o => per_asg_shd.g_old_rec.projected_assignment_end
923: ,p_grade_ladder_pgm_id_o
924: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
925: ,p_supervisor_assignment_id_o
926: => per_asg_shd.g_old_rec.supervisor_assignment_id /*Bug 2976136*/
927: ,p_vendor_site_id_o => per_asg_shd.g_old_rec.vendor_site_id
928: ,p_po_header_id_o => per_asg_shd.g_old_rec.po_header_id
929: ,p_po_line_id_o => per_asg_shd.g_old_rec.po_line_id
930: ,p_projected_assignment_end_o => per_asg_shd.g_old_rec.projected_assignment_end
931:
924: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
925: ,p_supervisor_assignment_id_o
926: => per_asg_shd.g_old_rec.supervisor_assignment_id /*Bug 2976136*/
927: ,p_vendor_site_id_o => per_asg_shd.g_old_rec.vendor_site_id
928: ,p_po_header_id_o => per_asg_shd.g_old_rec.po_header_id
929: ,p_po_line_id_o => per_asg_shd.g_old_rec.po_line_id
930: ,p_projected_assignment_end_o => per_asg_shd.g_old_rec.projected_assignment_end
931:
932: );
925: ,p_supervisor_assignment_id_o
926: => per_asg_shd.g_old_rec.supervisor_assignment_id /*Bug 2976136*/
927: ,p_vendor_site_id_o => per_asg_shd.g_old_rec.vendor_site_id
928: ,p_po_header_id_o => per_asg_shd.g_old_rec.po_header_id
929: ,p_po_line_id_o => per_asg_shd.g_old_rec.po_line_id
930: ,p_projected_assignment_end_o => per_asg_shd.g_old_rec.projected_assignment_end
931:
932: );
933: exception
926: => per_asg_shd.g_old_rec.supervisor_assignment_id /*Bug 2976136*/
927: ,p_vendor_site_id_o => per_asg_shd.g_old_rec.vendor_site_id
928: ,p_po_header_id_o => per_asg_shd.g_old_rec.po_header_id
929: ,p_po_line_id_o => per_asg_shd.g_old_rec.po_line_id
930: ,p_projected_assignment_end_o => per_asg_shd.g_old_rec.projected_assignment_end
931:
932: );
933: exception
934: when hr_api.cannot_find_prog_unit then
984: -- Internal Table Handler Use Only.
985: --
986: -- {End Of Comments}
987: -- ----------------------------------------------------------------------------
988: Procedure convert_defs(p_rec in out nocopy per_asg_shd.g_rec_type) is
989: --
990: l_proc varchar2(72) := g_package||'convert_defs';
991: --
992: Begin
999: -- is being used then we must set to the 'current' argument value.
1000: --
1001: If (p_rec.business_group_id = hr_api.g_number) then
1002: p_rec.business_group_id :=
1003: per_asg_shd.g_old_rec.business_group_id;
1004: End If;
1005: If (p_rec.recruiter_id = hr_api.g_number) then
1006: p_rec.recruiter_id :=
1007: per_asg_shd.g_old_rec.recruiter_id;
1003: per_asg_shd.g_old_rec.business_group_id;
1004: End If;
1005: If (p_rec.recruiter_id = hr_api.g_number) then
1006: p_rec.recruiter_id :=
1007: per_asg_shd.g_old_rec.recruiter_id;
1008: End If;
1009: If (p_rec.grade_id = hr_api.g_number) then
1010: p_rec.grade_id :=
1011: per_asg_shd.g_old_rec.grade_id;
1007: per_asg_shd.g_old_rec.recruiter_id;
1008: End If;
1009: If (p_rec.grade_id = hr_api.g_number) then
1010: p_rec.grade_id :=
1011: per_asg_shd.g_old_rec.grade_id;
1012: End If;
1013: If (p_rec.position_id = hr_api.g_number) then
1014: p_rec.position_id :=
1015: per_asg_shd.g_old_rec.position_id;
1011: per_asg_shd.g_old_rec.grade_id;
1012: End If;
1013: If (p_rec.position_id = hr_api.g_number) then
1014: p_rec.position_id :=
1015: per_asg_shd.g_old_rec.position_id;
1016: End If;
1017: If (p_rec.job_id = hr_api.g_number) then
1018: p_rec.job_id :=
1019: per_asg_shd.g_old_rec.job_id;
1015: per_asg_shd.g_old_rec.position_id;
1016: End If;
1017: If (p_rec.job_id = hr_api.g_number) then
1018: p_rec.job_id :=
1019: per_asg_shd.g_old_rec.job_id;
1020: End If;
1021: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1022: p_rec.assignment_status_type_id :=
1023: per_asg_shd.g_old_rec.assignment_status_type_id;
1019: per_asg_shd.g_old_rec.job_id;
1020: End If;
1021: If (p_rec.assignment_status_type_id = hr_api.g_number) then
1022: p_rec.assignment_status_type_id :=
1023: per_asg_shd.g_old_rec.assignment_status_type_id;
1024: End If;
1025: If (p_rec.payroll_id = hr_api.g_number) then
1026: p_rec.payroll_id :=
1027: per_asg_shd.g_old_rec.payroll_id;
1023: per_asg_shd.g_old_rec.assignment_status_type_id;
1024: End If;
1025: If (p_rec.payroll_id = hr_api.g_number) then
1026: p_rec.payroll_id :=
1027: per_asg_shd.g_old_rec.payroll_id;
1028: End If;
1029: If (p_rec.location_id = hr_api.g_number) then
1030: p_rec.location_id :=
1031: per_asg_shd.g_old_rec.location_id;
1027: per_asg_shd.g_old_rec.payroll_id;
1028: End If;
1029: If (p_rec.location_id = hr_api.g_number) then
1030: p_rec.location_id :=
1031: per_asg_shd.g_old_rec.location_id;
1032: End If;
1033: If (p_rec.person_referred_by_id = hr_api.g_number) then
1034: p_rec.person_referred_by_id :=
1035: per_asg_shd.g_old_rec.person_referred_by_id;
1031: per_asg_shd.g_old_rec.location_id;
1032: End If;
1033: If (p_rec.person_referred_by_id = hr_api.g_number) then
1034: p_rec.person_referred_by_id :=
1035: per_asg_shd.g_old_rec.person_referred_by_id;
1036: End If;
1037: If (p_rec.supervisor_id = hr_api.g_number) then
1038: p_rec.supervisor_id :=
1039: per_asg_shd.g_old_rec.supervisor_id;
1035: per_asg_shd.g_old_rec.person_referred_by_id;
1036: End If;
1037: If (p_rec.supervisor_id = hr_api.g_number) then
1038: p_rec.supervisor_id :=
1039: per_asg_shd.g_old_rec.supervisor_id;
1040: End If;
1041: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1042: p_rec.special_ceiling_step_id :=
1043: per_asg_shd.g_old_rec.special_ceiling_step_id;
1039: per_asg_shd.g_old_rec.supervisor_id;
1040: End If;
1041: If (p_rec.special_ceiling_step_id = hr_api.g_number) then
1042: p_rec.special_ceiling_step_id :=
1043: per_asg_shd.g_old_rec.special_ceiling_step_id;
1044: End If;
1045: If (p_rec.person_id = hr_api.g_number) then
1046: p_rec.person_id :=
1047: per_asg_shd.g_old_rec.person_id;
1043: per_asg_shd.g_old_rec.special_ceiling_step_id;
1044: End If;
1045: If (p_rec.person_id = hr_api.g_number) then
1046: p_rec.person_id :=
1047: per_asg_shd.g_old_rec.person_id;
1048: End If;
1049: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1050: p_rec.recruitment_activity_id :=
1051: per_asg_shd.g_old_rec.recruitment_activity_id;
1047: per_asg_shd.g_old_rec.person_id;
1048: End If;
1049: If (p_rec.recruitment_activity_id = hr_api.g_number) then
1050: p_rec.recruitment_activity_id :=
1051: per_asg_shd.g_old_rec.recruitment_activity_id;
1052: End If;
1053: If (p_rec.source_organization_id = hr_api.g_number) then
1054: p_rec.source_organization_id :=
1055: per_asg_shd.g_old_rec.source_organization_id;
1051: per_asg_shd.g_old_rec.recruitment_activity_id;
1052: End If;
1053: If (p_rec.source_organization_id = hr_api.g_number) then
1054: p_rec.source_organization_id :=
1055: per_asg_shd.g_old_rec.source_organization_id;
1056: End If;
1057: If (p_rec.organization_id = hr_api.g_number) then
1058: p_rec.organization_id :=
1059: per_asg_shd.g_old_rec.organization_id;
1055: per_asg_shd.g_old_rec.source_organization_id;
1056: End If;
1057: If (p_rec.organization_id = hr_api.g_number) then
1058: p_rec.organization_id :=
1059: per_asg_shd.g_old_rec.organization_id;
1060: End If;
1061: If (p_rec.people_group_id = hr_api.g_number) then
1062: p_rec.people_group_id :=
1063: per_asg_shd.g_old_rec.people_group_id;
1059: per_asg_shd.g_old_rec.organization_id;
1060: End If;
1061: If (p_rec.people_group_id = hr_api.g_number) then
1062: p_rec.people_group_id :=
1063: per_asg_shd.g_old_rec.people_group_id;
1064: End If;
1065: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1066: p_rec.soft_coding_keyflex_id :=
1067: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1063: per_asg_shd.g_old_rec.people_group_id;
1064: End If;
1065: If (p_rec.soft_coding_keyflex_id = hr_api.g_number) then
1066: p_rec.soft_coding_keyflex_id :=
1067: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1068: End If;
1069: If (p_rec.vacancy_id = hr_api.g_number) then
1070: p_rec.vacancy_id :=
1071: per_asg_shd.g_old_rec.vacancy_id;
1067: per_asg_shd.g_old_rec.soft_coding_keyflex_id;
1068: End If;
1069: If (p_rec.vacancy_id = hr_api.g_number) then
1070: p_rec.vacancy_id :=
1071: per_asg_shd.g_old_rec.vacancy_id;
1072: End If;
1073: If (p_rec.pay_basis_id = hr_api.g_number) then
1074: p_rec.pay_basis_id :=
1075: per_asg_shd.g_old_rec.pay_basis_id;
1071: per_asg_shd.g_old_rec.vacancy_id;
1072: End If;
1073: If (p_rec.pay_basis_id = hr_api.g_number) then
1074: p_rec.pay_basis_id :=
1075: per_asg_shd.g_old_rec.pay_basis_id;
1076: End If;
1077: If (p_rec.assignment_sequence = hr_api.g_number) then
1078: p_rec.assignment_sequence :=
1079: per_asg_shd.g_old_rec.assignment_sequence;
1075: per_asg_shd.g_old_rec.pay_basis_id;
1076: End If;
1077: If (p_rec.assignment_sequence = hr_api.g_number) then
1078: p_rec.assignment_sequence :=
1079: per_asg_shd.g_old_rec.assignment_sequence;
1080: End If;
1081: If (p_rec.assignment_type = hr_api.g_varchar2) then
1082: p_rec.assignment_type :=
1083: per_asg_shd.g_old_rec.assignment_type;
1079: per_asg_shd.g_old_rec.assignment_sequence;
1080: End If;
1081: If (p_rec.assignment_type = hr_api.g_varchar2) then
1082: p_rec.assignment_type :=
1083: per_asg_shd.g_old_rec.assignment_type;
1084: End If;
1085: If (p_rec.primary_flag = hr_api.g_varchar2) then
1086: p_rec.primary_flag :=
1087: per_asg_shd.g_old_rec.primary_flag;
1083: per_asg_shd.g_old_rec.assignment_type;
1084: End If;
1085: If (p_rec.primary_flag = hr_api.g_varchar2) then
1086: p_rec.primary_flag :=
1087: per_asg_shd.g_old_rec.primary_flag;
1088: End If;
1089: If (p_rec.application_id = hr_api.g_number) then
1090: p_rec.application_id :=
1091: per_asg_shd.g_old_rec.application_id;
1087: per_asg_shd.g_old_rec.primary_flag;
1088: End If;
1089: If (p_rec.application_id = hr_api.g_number) then
1090: p_rec.application_id :=
1091: per_asg_shd.g_old_rec.application_id;
1092: End If;
1093: If (p_rec.assignment_number = hr_api.g_varchar2) then
1094: p_rec.assignment_number :=
1095: per_asg_shd.g_old_rec.assignment_number;
1091: per_asg_shd.g_old_rec.application_id;
1092: End If;
1093: If (p_rec.assignment_number = hr_api.g_varchar2) then
1094: p_rec.assignment_number :=
1095: per_asg_shd.g_old_rec.assignment_number;
1096: End If;
1097: If (p_rec.change_reason = hr_api.g_varchar2) then
1098: p_rec.change_reason :=
1099: per_asg_shd.g_old_rec.change_reason;
1095: per_asg_shd.g_old_rec.assignment_number;
1096: End If;
1097: If (p_rec.change_reason = hr_api.g_varchar2) then
1098: p_rec.change_reason :=
1099: per_asg_shd.g_old_rec.change_reason;
1100: End If;
1101: If (p_rec.comment_id = hr_api.g_number) then
1102: p_rec.comment_id :=
1103: per_asg_shd.g_old_rec.comment_id;
1099: per_asg_shd.g_old_rec.change_reason;
1100: End If;
1101: If (p_rec.comment_id = hr_api.g_number) then
1102: p_rec.comment_id :=
1103: per_asg_shd.g_old_rec.comment_id;
1104: End If;
1105: If (p_rec.comment_text = hr_api.g_varchar2) then
1106: p_rec.comment_text :=
1107: per_asg_shd.g_old_rec.comment_text;
1103: per_asg_shd.g_old_rec.comment_id;
1104: End If;
1105: If (p_rec.comment_text = hr_api.g_varchar2) then
1106: p_rec.comment_text :=
1107: per_asg_shd.g_old_rec.comment_text;
1108: End If;
1109: If (p_rec.date_probation_end = hr_api.g_date) then
1110: p_rec.date_probation_end :=
1111: per_asg_shd.g_old_rec.date_probation_end;
1107: per_asg_shd.g_old_rec.comment_text;
1108: End If;
1109: If (p_rec.date_probation_end = hr_api.g_date) then
1110: p_rec.date_probation_end :=
1111: per_asg_shd.g_old_rec.date_probation_end;
1112: End If;
1113: If (p_rec.default_code_comb_id = hr_api.g_number) then
1114: p_rec.default_code_comb_id :=
1115: per_asg_shd.g_old_rec.default_code_comb_id;
1111: per_asg_shd.g_old_rec.date_probation_end;
1112: End If;
1113: If (p_rec.default_code_comb_id = hr_api.g_number) then
1114: p_rec.default_code_comb_id :=
1115: per_asg_shd.g_old_rec.default_code_comb_id;
1116: End If;
1117: If (p_rec.employment_category = hr_api.g_varchar2) then
1118: p_rec.employment_category :=
1119: per_asg_shd.g_old_rec.employment_category;
1115: per_asg_shd.g_old_rec.default_code_comb_id;
1116: End If;
1117: If (p_rec.employment_category = hr_api.g_varchar2) then
1118: p_rec.employment_category :=
1119: per_asg_shd.g_old_rec.employment_category;
1120: End If;
1121: If (p_rec.frequency = hr_api.g_varchar2) then
1122: p_rec.frequency :=
1123: per_asg_shd.g_old_rec.frequency;
1119: per_asg_shd.g_old_rec.employment_category;
1120: End If;
1121: If (p_rec.frequency = hr_api.g_varchar2) then
1122: p_rec.frequency :=
1123: per_asg_shd.g_old_rec.frequency;
1124: End If;
1125: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1126: p_rec.internal_address_line :=
1127: per_asg_shd.g_old_rec.internal_address_line;
1123: per_asg_shd.g_old_rec.frequency;
1124: End If;
1125: If (p_rec.internal_address_line = hr_api.g_varchar2) then
1126: p_rec.internal_address_line :=
1127: per_asg_shd.g_old_rec.internal_address_line;
1128: End If;
1129: If (p_rec.manager_flag = hr_api.g_varchar2) then
1130: p_rec.manager_flag :=
1131: per_asg_shd.g_old_rec.manager_flag;
1127: per_asg_shd.g_old_rec.internal_address_line;
1128: End If;
1129: If (p_rec.manager_flag = hr_api.g_varchar2) then
1130: p_rec.manager_flag :=
1131: per_asg_shd.g_old_rec.manager_flag;
1132: End If;
1133: If (p_rec.normal_hours = hr_api.g_number) then
1134: p_rec.normal_hours :=
1135: per_asg_shd.g_old_rec.normal_hours;
1131: per_asg_shd.g_old_rec.manager_flag;
1132: End If;
1133: If (p_rec.normal_hours = hr_api.g_number) then
1134: p_rec.normal_hours :=
1135: per_asg_shd.g_old_rec.normal_hours;
1136: End If;
1137: If (p_rec.perf_review_period = hr_api.g_number) then
1138: p_rec.perf_review_period :=
1139: per_asg_shd.g_old_rec.perf_review_period;
1135: per_asg_shd.g_old_rec.normal_hours;
1136: End If;
1137: If (p_rec.perf_review_period = hr_api.g_number) then
1138: p_rec.perf_review_period :=
1139: per_asg_shd.g_old_rec.perf_review_period;
1140: End If;
1141: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1142: p_rec.perf_review_period_frequency :=
1143: per_asg_shd.g_old_rec.perf_review_period_frequency;
1139: per_asg_shd.g_old_rec.perf_review_period;
1140: End If;
1141: If (p_rec.perf_review_period_frequency = hr_api.g_varchar2) then
1142: p_rec.perf_review_period_frequency :=
1143: per_asg_shd.g_old_rec.perf_review_period_frequency;
1144: End If;
1145: If (p_rec.period_of_service_id = hr_api.g_number) then
1146: p_rec.period_of_service_id :=
1147: per_asg_shd.g_old_rec.period_of_service_id;
1143: per_asg_shd.g_old_rec.perf_review_period_frequency;
1144: End If;
1145: If (p_rec.period_of_service_id = hr_api.g_number) then
1146: p_rec.period_of_service_id :=
1147: per_asg_shd.g_old_rec.period_of_service_id;
1148: End If;
1149: If (p_rec.probation_period = hr_api.g_number) then
1150: p_rec.probation_period :=
1151: per_asg_shd.g_old_rec.probation_period;
1147: per_asg_shd.g_old_rec.period_of_service_id;
1148: End If;
1149: If (p_rec.probation_period = hr_api.g_number) then
1150: p_rec.probation_period :=
1151: per_asg_shd.g_old_rec.probation_period;
1152: End If;
1153: If (p_rec.probation_unit = hr_api.g_varchar2) then
1154: p_rec.probation_unit :=
1155: per_asg_shd.g_old_rec.probation_unit;
1151: per_asg_shd.g_old_rec.probation_period;
1152: End If;
1153: If (p_rec.probation_unit = hr_api.g_varchar2) then
1154: p_rec.probation_unit :=
1155: per_asg_shd.g_old_rec.probation_unit;
1156: End If;
1157: If (p_rec.sal_review_period = hr_api.g_number) then
1158: p_rec.sal_review_period :=
1159: per_asg_shd.g_old_rec.sal_review_period;
1155: per_asg_shd.g_old_rec.probation_unit;
1156: End If;
1157: If (p_rec.sal_review_period = hr_api.g_number) then
1158: p_rec.sal_review_period :=
1159: per_asg_shd.g_old_rec.sal_review_period;
1160: End If;
1161: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1162: p_rec.sal_review_period_frequency :=
1163: per_asg_shd.g_old_rec.sal_review_period_frequency;
1159: per_asg_shd.g_old_rec.sal_review_period;
1160: End If;
1161: If (p_rec.sal_review_period_frequency = hr_api.g_varchar2) then
1162: p_rec.sal_review_period_frequency :=
1163: per_asg_shd.g_old_rec.sal_review_period_frequency;
1164: End If;
1165: If (p_rec.set_of_books_id = hr_api.g_number) then
1166: p_rec.set_of_books_id :=
1167: per_asg_shd.g_old_rec.set_of_books_id;
1163: per_asg_shd.g_old_rec.sal_review_period_frequency;
1164: End If;
1165: If (p_rec.set_of_books_id = hr_api.g_number) then
1166: p_rec.set_of_books_id :=
1167: per_asg_shd.g_old_rec.set_of_books_id;
1168: End If;
1169: If (p_rec.source_type = hr_api.g_varchar2) then
1170: p_rec.source_type :=
1171: per_asg_shd.g_old_rec.source_type;
1167: per_asg_shd.g_old_rec.set_of_books_id;
1168: End If;
1169: If (p_rec.source_type = hr_api.g_varchar2) then
1170: p_rec.source_type :=
1171: per_asg_shd.g_old_rec.source_type;
1172: End If;
1173: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1174: p_rec.time_normal_finish :=
1175: per_asg_shd.g_old_rec.time_normal_finish;
1171: per_asg_shd.g_old_rec.source_type;
1172: End If;
1173: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1174: p_rec.time_normal_finish :=
1175: per_asg_shd.g_old_rec.time_normal_finish;
1176: End If;
1177: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1178: p_rec.time_normal_start :=
1179: per_asg_shd.g_old_rec.time_normal_start;
1175: per_asg_shd.g_old_rec.time_normal_finish;
1176: End If;
1177: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1178: p_rec.time_normal_start :=
1179: per_asg_shd.g_old_rec.time_normal_start;
1180: End If;
1181: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1182: p_rec.bargaining_unit_code :=
1183: per_asg_shd.g_old_rec.bargaining_unit_code;
1179: per_asg_shd.g_old_rec.time_normal_start;
1180: End If;
1181: If (p_rec.bargaining_unit_code = hr_api.g_varchar2) then
1182: p_rec.bargaining_unit_code :=
1183: per_asg_shd.g_old_rec.bargaining_unit_code;
1184: End If;
1185: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1186: p_rec.labour_union_member_flag :=
1187: per_asg_shd.g_old_rec.labour_union_member_flag;
1183: per_asg_shd.g_old_rec.bargaining_unit_code;
1184: End If;
1185: If (p_rec.labour_union_member_flag = hr_api.g_varchar2) then
1186: p_rec.labour_union_member_flag :=
1187: per_asg_shd.g_old_rec.labour_union_member_flag;
1188: End If;
1189: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1190: p_rec.hourly_salaried_code :=
1191: per_asg_shd.g_old_rec.hourly_salaried_code;
1187: per_asg_shd.g_old_rec.labour_union_member_flag;
1188: End If;
1189: If (p_rec.hourly_salaried_code = hr_api.g_varchar2) then
1190: p_rec.hourly_salaried_code :=
1191: per_asg_shd.g_old_rec.hourly_salaried_code;
1192: End If;
1193: If (p_rec.request_id = hr_api.g_number) then
1194: p_rec.request_id :=
1195: per_asg_shd.g_old_rec.request_id;
1191: per_asg_shd.g_old_rec.hourly_salaried_code;
1192: End If;
1193: If (p_rec.request_id = hr_api.g_number) then
1194: p_rec.request_id :=
1195: per_asg_shd.g_old_rec.request_id;
1196: End If;
1197: If (p_rec.program_application_id = hr_api.g_number) then
1198: p_rec.program_application_id :=
1199: per_asg_shd.g_old_rec.program_application_id;
1195: per_asg_shd.g_old_rec.request_id;
1196: End If;
1197: If (p_rec.program_application_id = hr_api.g_number) then
1198: p_rec.program_application_id :=
1199: per_asg_shd.g_old_rec.program_application_id;
1200: End If;
1201: If (p_rec.program_id = hr_api.g_number) then
1202: p_rec.program_id :=
1203: per_asg_shd.g_old_rec.program_id;
1199: per_asg_shd.g_old_rec.program_application_id;
1200: End If;
1201: If (p_rec.program_id = hr_api.g_number) then
1202: p_rec.program_id :=
1203: per_asg_shd.g_old_rec.program_id;
1204: End If;
1205: If (p_rec.program_update_date = hr_api.g_date) then
1206: p_rec.program_update_date :=
1207: per_asg_shd.g_old_rec.program_update_date;
1203: per_asg_shd.g_old_rec.program_id;
1204: End If;
1205: If (p_rec.program_update_date = hr_api.g_date) then
1206: p_rec.program_update_date :=
1207: per_asg_shd.g_old_rec.program_update_date;
1208: End If;
1209: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1210: p_rec.ass_attribute_category :=
1211: per_asg_shd.g_old_rec.ass_attribute_category;
1207: per_asg_shd.g_old_rec.program_update_date;
1208: End If;
1209: If (p_rec.ass_attribute_category = hr_api.g_varchar2) then
1210: p_rec.ass_attribute_category :=
1211: per_asg_shd.g_old_rec.ass_attribute_category;
1212: End If;
1213: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1214: p_rec.ass_attribute1 :=
1215: per_asg_shd.g_old_rec.ass_attribute1;
1211: per_asg_shd.g_old_rec.ass_attribute_category;
1212: End If;
1213: If (p_rec.ass_attribute1 = hr_api.g_varchar2) then
1214: p_rec.ass_attribute1 :=
1215: per_asg_shd.g_old_rec.ass_attribute1;
1216: End If;
1217: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1218: p_rec.ass_attribute2 :=
1219: per_asg_shd.g_old_rec.ass_attribute2;
1215: per_asg_shd.g_old_rec.ass_attribute1;
1216: End If;
1217: If (p_rec.ass_attribute2 = hr_api.g_varchar2) then
1218: p_rec.ass_attribute2 :=
1219: per_asg_shd.g_old_rec.ass_attribute2;
1220: End If;
1221: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1222: p_rec.ass_attribute3 :=
1223: per_asg_shd.g_old_rec.ass_attribute3;
1219: per_asg_shd.g_old_rec.ass_attribute2;
1220: End If;
1221: If (p_rec.ass_attribute3 = hr_api.g_varchar2) then
1222: p_rec.ass_attribute3 :=
1223: per_asg_shd.g_old_rec.ass_attribute3;
1224: End If;
1225: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1226: p_rec.ass_attribute4 :=
1227: per_asg_shd.g_old_rec.ass_attribute4;
1223: per_asg_shd.g_old_rec.ass_attribute3;
1224: End If;
1225: If (p_rec.ass_attribute4 = hr_api.g_varchar2) then
1226: p_rec.ass_attribute4 :=
1227: per_asg_shd.g_old_rec.ass_attribute4;
1228: End If;
1229: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1230: p_rec.ass_attribute5 :=
1231: per_asg_shd.g_old_rec.ass_attribute5;
1227: per_asg_shd.g_old_rec.ass_attribute4;
1228: End If;
1229: If (p_rec.ass_attribute5 = hr_api.g_varchar2) then
1230: p_rec.ass_attribute5 :=
1231: per_asg_shd.g_old_rec.ass_attribute5;
1232: End If;
1233: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1234: p_rec.ass_attribute6 :=
1235: per_asg_shd.g_old_rec.ass_attribute6;
1231: per_asg_shd.g_old_rec.ass_attribute5;
1232: End If;
1233: If (p_rec.ass_attribute6 = hr_api.g_varchar2) then
1234: p_rec.ass_attribute6 :=
1235: per_asg_shd.g_old_rec.ass_attribute6;
1236: End If;
1237: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1238: p_rec.ass_attribute7 :=
1239: per_asg_shd.g_old_rec.ass_attribute7;
1235: per_asg_shd.g_old_rec.ass_attribute6;
1236: End If;
1237: If (p_rec.ass_attribute7 = hr_api.g_varchar2) then
1238: p_rec.ass_attribute7 :=
1239: per_asg_shd.g_old_rec.ass_attribute7;
1240: End If;
1241: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1242: p_rec.ass_attribute8 :=
1243: per_asg_shd.g_old_rec.ass_attribute8;
1239: per_asg_shd.g_old_rec.ass_attribute7;
1240: End If;
1241: If (p_rec.ass_attribute8 = hr_api.g_varchar2) then
1242: p_rec.ass_attribute8 :=
1243: per_asg_shd.g_old_rec.ass_attribute8;
1244: End If;
1245: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1246: p_rec.ass_attribute9 :=
1247: per_asg_shd.g_old_rec.ass_attribute9;
1243: per_asg_shd.g_old_rec.ass_attribute8;
1244: End If;
1245: If (p_rec.ass_attribute9 = hr_api.g_varchar2) then
1246: p_rec.ass_attribute9 :=
1247: per_asg_shd.g_old_rec.ass_attribute9;
1248: End If;
1249: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1250: p_rec.ass_attribute10 :=
1251: per_asg_shd.g_old_rec.ass_attribute10;
1247: per_asg_shd.g_old_rec.ass_attribute9;
1248: End If;
1249: If (p_rec.ass_attribute10 = hr_api.g_varchar2) then
1250: p_rec.ass_attribute10 :=
1251: per_asg_shd.g_old_rec.ass_attribute10;
1252: End If;
1253: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1254: p_rec.ass_attribute11 :=
1255: per_asg_shd.g_old_rec.ass_attribute11;
1251: per_asg_shd.g_old_rec.ass_attribute10;
1252: End If;
1253: If (p_rec.ass_attribute11 = hr_api.g_varchar2) then
1254: p_rec.ass_attribute11 :=
1255: per_asg_shd.g_old_rec.ass_attribute11;
1256: End If;
1257: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1258: p_rec.ass_attribute12 :=
1259: per_asg_shd.g_old_rec.ass_attribute12;
1255: per_asg_shd.g_old_rec.ass_attribute11;
1256: End If;
1257: If (p_rec.ass_attribute12 = hr_api.g_varchar2) then
1258: p_rec.ass_attribute12 :=
1259: per_asg_shd.g_old_rec.ass_attribute12;
1260: End If;
1261: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1262: p_rec.ass_attribute13 :=
1263: per_asg_shd.g_old_rec.ass_attribute13;
1259: per_asg_shd.g_old_rec.ass_attribute12;
1260: End If;
1261: If (p_rec.ass_attribute13 = hr_api.g_varchar2) then
1262: p_rec.ass_attribute13 :=
1263: per_asg_shd.g_old_rec.ass_attribute13;
1264: End If;
1265: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1266: p_rec.ass_attribute14 :=
1267: per_asg_shd.g_old_rec.ass_attribute14;
1263: per_asg_shd.g_old_rec.ass_attribute13;
1264: End If;
1265: If (p_rec.ass_attribute14 = hr_api.g_varchar2) then
1266: p_rec.ass_attribute14 :=
1267: per_asg_shd.g_old_rec.ass_attribute14;
1268: End If;
1269: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1270: p_rec.ass_attribute15 :=
1271: per_asg_shd.g_old_rec.ass_attribute15;
1267: per_asg_shd.g_old_rec.ass_attribute14;
1268: End If;
1269: If (p_rec.ass_attribute15 = hr_api.g_varchar2) then
1270: p_rec.ass_attribute15 :=
1271: per_asg_shd.g_old_rec.ass_attribute15;
1272: End If;
1273: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1274: p_rec.ass_attribute16 :=
1275: per_asg_shd.g_old_rec.ass_attribute16;
1271: per_asg_shd.g_old_rec.ass_attribute15;
1272: End If;
1273: If (p_rec.ass_attribute16 = hr_api.g_varchar2) then
1274: p_rec.ass_attribute16 :=
1275: per_asg_shd.g_old_rec.ass_attribute16;
1276: End If;
1277: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1278: p_rec.ass_attribute17 :=
1279: per_asg_shd.g_old_rec.ass_attribute17;
1275: per_asg_shd.g_old_rec.ass_attribute16;
1276: End If;
1277: If (p_rec.ass_attribute17 = hr_api.g_varchar2) then
1278: p_rec.ass_attribute17 :=
1279: per_asg_shd.g_old_rec.ass_attribute17;
1280: End If;
1281: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1282: p_rec.ass_attribute18 :=
1283: per_asg_shd.g_old_rec.ass_attribute18;
1279: per_asg_shd.g_old_rec.ass_attribute17;
1280: End If;
1281: If (p_rec.ass_attribute18 = hr_api.g_varchar2) then
1282: p_rec.ass_attribute18 :=
1283: per_asg_shd.g_old_rec.ass_attribute18;
1284: End If;
1285: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1286: p_rec.ass_attribute19 :=
1287: per_asg_shd.g_old_rec.ass_attribute19;
1283: per_asg_shd.g_old_rec.ass_attribute18;
1284: End If;
1285: If (p_rec.ass_attribute19 = hr_api.g_varchar2) then
1286: p_rec.ass_attribute19 :=
1287: per_asg_shd.g_old_rec.ass_attribute19;
1288: End If;
1289: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1290: p_rec.ass_attribute20 :=
1291: per_asg_shd.g_old_rec.ass_attribute20;
1287: per_asg_shd.g_old_rec.ass_attribute19;
1288: End If;
1289: If (p_rec.ass_attribute20 = hr_api.g_varchar2) then
1290: p_rec.ass_attribute20 :=
1291: per_asg_shd.g_old_rec.ass_attribute20;
1292: End If;
1293: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1294: p_rec.ass_attribute21 :=
1295: per_asg_shd.g_old_rec.ass_attribute21;
1291: per_asg_shd.g_old_rec.ass_attribute20;
1292: End If;
1293: If (p_rec.ass_attribute21 = hr_api.g_varchar2) then
1294: p_rec.ass_attribute21 :=
1295: per_asg_shd.g_old_rec.ass_attribute21;
1296: End If;
1297: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1298: p_rec.ass_attribute22 :=
1299: per_asg_shd.g_old_rec.ass_attribute22;
1295: per_asg_shd.g_old_rec.ass_attribute21;
1296: End If;
1297: If (p_rec.ass_attribute22 = hr_api.g_varchar2) then
1298: p_rec.ass_attribute22 :=
1299: per_asg_shd.g_old_rec.ass_attribute22;
1300: End If;
1301: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1302: p_rec.ass_attribute23 :=
1303: per_asg_shd.g_old_rec.ass_attribute23;
1299: per_asg_shd.g_old_rec.ass_attribute22;
1300: End If;
1301: If (p_rec.ass_attribute23 = hr_api.g_varchar2) then
1302: p_rec.ass_attribute23 :=
1303: per_asg_shd.g_old_rec.ass_attribute23;
1304: End If;
1305: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1306: p_rec.ass_attribute24 :=
1307: per_asg_shd.g_old_rec.ass_attribute24;
1303: per_asg_shd.g_old_rec.ass_attribute23;
1304: End If;
1305: If (p_rec.ass_attribute24 = hr_api.g_varchar2) then
1306: p_rec.ass_attribute24 :=
1307: per_asg_shd.g_old_rec.ass_attribute24;
1308: End If;
1309: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1310: p_rec.ass_attribute25 :=
1311: per_asg_shd.g_old_rec.ass_attribute25;
1307: per_asg_shd.g_old_rec.ass_attribute24;
1308: End If;
1309: If (p_rec.ass_attribute25 = hr_api.g_varchar2) then
1310: p_rec.ass_attribute25 :=
1311: per_asg_shd.g_old_rec.ass_attribute25;
1312: End If;
1313: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1314: p_rec.ass_attribute26 :=
1315: per_asg_shd.g_old_rec.ass_attribute26;
1311: per_asg_shd.g_old_rec.ass_attribute25;
1312: End If;
1313: If (p_rec.ass_attribute26 = hr_api.g_varchar2) then
1314: p_rec.ass_attribute26 :=
1315: per_asg_shd.g_old_rec.ass_attribute26;
1316: End If;
1317: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1318: p_rec.ass_attribute27 :=
1319: per_asg_shd.g_old_rec.ass_attribute27;
1315: per_asg_shd.g_old_rec.ass_attribute26;
1316: End If;
1317: If (p_rec.ass_attribute27 = hr_api.g_varchar2) then
1318: p_rec.ass_attribute27 :=
1319: per_asg_shd.g_old_rec.ass_attribute27;
1320: End If;
1321: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1322: p_rec.ass_attribute28 :=
1323: per_asg_shd.g_old_rec.ass_attribute28;
1319: per_asg_shd.g_old_rec.ass_attribute27;
1320: End If;
1321: If (p_rec.ass_attribute28 = hr_api.g_varchar2) then
1322: p_rec.ass_attribute28 :=
1323: per_asg_shd.g_old_rec.ass_attribute28;
1324: End If;
1325: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1326: p_rec.ass_attribute29 :=
1327: per_asg_shd.g_old_rec.ass_attribute29;
1323: per_asg_shd.g_old_rec.ass_attribute28;
1324: End If;
1325: If (p_rec.ass_attribute29 = hr_api.g_varchar2) then
1326: p_rec.ass_attribute29 :=
1327: per_asg_shd.g_old_rec.ass_attribute29;
1328: End If;
1329: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1330: p_rec.ass_attribute30 :=
1331: per_asg_shd.g_old_rec.ass_attribute30;
1327: per_asg_shd.g_old_rec.ass_attribute29;
1328: End If;
1329: If (p_rec.ass_attribute30 = hr_api.g_varchar2) then
1330: p_rec.ass_attribute30 :=
1331: per_asg_shd.g_old_rec.ass_attribute30;
1332: End If;
1333: If (p_rec.title = hr_api.g_varchar2) then
1334: p_rec.title :=
1335: per_asg_shd.g_old_rec.title;
1331: per_asg_shd.g_old_rec.ass_attribute30;
1332: End If;
1333: If (p_rec.title = hr_api.g_varchar2) then
1334: p_rec.title :=
1335: per_asg_shd.g_old_rec.title;
1336: End If;
1337: If (p_rec.contract_id = hr_api.g_number) then
1338: p_rec.contract_id :=
1339: per_asg_shd.g_old_rec.contract_id;
1335: per_asg_shd.g_old_rec.title;
1336: End If;
1337: If (p_rec.contract_id = hr_api.g_number) then
1338: p_rec.contract_id :=
1339: per_asg_shd.g_old_rec.contract_id;
1340: End If;
1341: If (p_rec.establishment_id = hr_api.g_number) then
1342: p_rec.establishment_id :=
1343: per_asg_shd.g_old_rec.establishment_id;
1339: per_asg_shd.g_old_rec.contract_id;
1340: End If;
1341: If (p_rec.establishment_id = hr_api.g_number) then
1342: p_rec.establishment_id :=
1343: per_asg_shd.g_old_rec.establishment_id;
1344: End If;
1345: If (p_rec.collective_agreement_id = hr_api.g_number) then
1346: p_rec.collective_agreement_id :=
1347: per_asg_shd.g_old_rec.collective_agreement_id;
1343: per_asg_shd.g_old_rec.establishment_id;
1344: End If;
1345: If (p_rec.collective_agreement_id = hr_api.g_number) then
1346: p_rec.collective_agreement_id :=
1347: per_asg_shd.g_old_rec.collective_agreement_id;
1348: End If;
1349: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1350: p_rec.cagr_grade_def_id :=
1351: per_asg_shd.g_old_rec.cagr_grade_def_id;
1347: per_asg_shd.g_old_rec.collective_agreement_id;
1348: End If;
1349: If (p_rec.cagr_grade_def_id = hr_api.g_number) then
1350: p_rec.cagr_grade_def_id :=
1351: per_asg_shd.g_old_rec.cagr_grade_def_id;
1352: End If;
1353: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1354: p_rec.cagr_id_flex_num :=
1355: per_asg_shd.g_old_rec.cagr_id_flex_num;
1351: per_asg_shd.g_old_rec.cagr_grade_def_id;
1352: End If;
1353: If (p_rec.cagr_id_flex_num = hr_api.g_number) then
1354: p_rec.cagr_id_flex_num :=
1355: per_asg_shd.g_old_rec.cagr_id_flex_num;
1356: End If;
1357: If (p_rec.notice_period = hr_api.g_number) then
1358: p_rec.notice_period :=
1359: per_asg_shd.g_old_rec.notice_period;
1355: per_asg_shd.g_old_rec.cagr_id_flex_num;
1356: End If;
1357: If (p_rec.notice_period = hr_api.g_number) then
1358: p_rec.notice_period :=
1359: per_asg_shd.g_old_rec.notice_period;
1360: End If;
1361: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1362: p_rec.notice_period_uom :=
1363: per_asg_shd.g_old_rec.notice_period_uom;
1359: per_asg_shd.g_old_rec.notice_period;
1360: End If;
1361: If (p_rec.notice_period_uom = hr_api.g_varchar2) then
1362: p_rec.notice_period_uom :=
1363: per_asg_shd.g_old_rec.notice_period_uom;
1364: End If;
1365: If (p_rec.employee_category = hr_api.g_varchar2) then
1366: p_rec.employee_category :=
1367: per_asg_shd.g_old_rec.employee_category;
1363: per_asg_shd.g_old_rec.notice_period_uom;
1364: End If;
1365: If (p_rec.employee_category = hr_api.g_varchar2) then
1366: p_rec.employee_category :=
1367: per_asg_shd.g_old_rec.employee_category;
1368: End If;
1369: If (p_rec.work_at_home = hr_api.g_varchar2) then
1370: p_rec.work_at_home :=
1371: per_asg_shd.g_old_rec.work_at_home;
1367: per_asg_shd.g_old_rec.employee_category;
1368: End If;
1369: If (p_rec.work_at_home = hr_api.g_varchar2) then
1370: p_rec.work_at_home :=
1371: per_asg_shd.g_old_rec.work_at_home;
1372: End If;
1373: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1374: p_rec.job_post_source_name :=
1375: per_asg_shd.g_old_rec.job_post_source_name;
1371: per_asg_shd.g_old_rec.work_at_home;
1372: End If;
1373: If (p_rec.job_post_source_name = hr_api.g_varchar2) then
1374: p_rec.job_post_source_name :=
1375: per_asg_shd.g_old_rec.job_post_source_name;
1376: End If;
1377: If (p_rec.posting_content_id = hr_api.g_number) then
1378: p_rec.posting_content_id :=
1379: per_asg_shd.g_old_rec.posting_content_id;
1375: per_asg_shd.g_old_rec.job_post_source_name;
1376: End If;
1377: If (p_rec.posting_content_id = hr_api.g_number) then
1378: p_rec.posting_content_id :=
1379: per_asg_shd.g_old_rec.posting_content_id;
1380: End If;
1381: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1382: p_rec.period_of_placement_date_start :=
1383: per_asg_shd.g_old_rec.period_of_placement_date_start;
1379: per_asg_shd.g_old_rec.posting_content_id;
1380: End If;
1381: If (p_rec.period_of_placement_date_start = hr_api.g_date) then
1382: p_rec.period_of_placement_date_start :=
1383: per_asg_shd.g_old_rec.period_of_placement_date_start;
1384: End If;
1385: If (p_rec.vendor_id = hr_api.g_number) then
1386: p_rec.vendor_id :=
1387: per_asg_shd.g_old_rec.vendor_id;
1383: per_asg_shd.g_old_rec.period_of_placement_date_start;
1384: End If;
1385: If (p_rec.vendor_id = hr_api.g_number) then
1386: p_rec.vendor_id :=
1387: per_asg_shd.g_old_rec.vendor_id;
1388: End If;
1389: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1390: p_rec.vendor_employee_number :=
1391: per_asg_shd.g_old_rec.vendor_employee_number;
1387: per_asg_shd.g_old_rec.vendor_id;
1388: End If;
1389: If (p_rec.vendor_employee_number = hr_api.g_varchar2) then
1390: p_rec.vendor_employee_number :=
1391: per_asg_shd.g_old_rec.vendor_employee_number;
1392: End If;
1393: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1394: p_rec.vendor_assignment_number :=
1395: per_asg_shd.g_old_rec.vendor_assignment_number;
1391: per_asg_shd.g_old_rec.vendor_employee_number;
1392: End If;
1393: If (p_rec.vendor_assignment_number = hr_api.g_varchar2) then
1394: p_rec.vendor_assignment_number :=
1395: per_asg_shd.g_old_rec.vendor_assignment_number;
1396: End If;
1397: If (p_rec.assignment_category = hr_api.g_varchar2) then
1398: p_rec.assignment_category :=
1399: per_asg_shd.g_old_rec.assignment_category;
1395: per_asg_shd.g_old_rec.vendor_assignment_number;
1396: End If;
1397: If (p_rec.assignment_category = hr_api.g_varchar2) then
1398: p_rec.assignment_category :=
1399: per_asg_shd.g_old_rec.assignment_category;
1400: End If;
1401: If (p_rec.project_title = hr_api.g_varchar2) then
1402: p_rec.project_title :=
1403: per_asg_shd.g_old_rec.project_title;
1399: per_asg_shd.g_old_rec.assignment_category;
1400: End If;
1401: If (p_rec.project_title = hr_api.g_varchar2) then
1402: p_rec.project_title :=
1403: per_asg_shd.g_old_rec.project_title;
1404: End If;
1405:
1406: If (p_rec.applicant_rank = hr_api.g_number) then
1407: p_rec.applicant_rank :=
1404: End If;
1405:
1406: If (p_rec.applicant_rank = hr_api.g_number) then
1407: p_rec.applicant_rank :=
1408: per_asg_shd.g_old_rec.applicant_rank;
1409: End If;
1410: --
1411:
1412: hr_utility.set_location(' Leaving:'||l_proc, 10);
1417: -- |---------------------------------< upd >----------------------------------|
1418: -- ----------------------------------------------------------------------------
1419: Procedure upd
1420: (
1421: p_rec in out nocopy per_asg_shd.g_rec_type,
1422: p_effective_date in date,
1423: p_datetrack_mode in varchar2,
1424: p_validation_start_date out nocopy date,
1425: p_validation_end_date out nocopy date,
1459: End If;
1460: --
1461: -- We must lock the row which we need to update.
1462: --
1463: per_asg_shd.lck
1464: (p_effective_date => p_effective_date,
1465: p_datetrack_mode => p_datetrack_mode,
1466: p_assignment_id => p_rec.assignment_id,
1467: p_object_version_number => p_rec.object_version_number,
1701: p_datetrack_mode in varchar2,
1702: p_validate in boolean default false
1703: ) is
1704: --
1705: l_rec per_asg_shd.g_rec_type;
1706:
1707: l_proc varchar2(72) := g_package||'upd';
1708: --
1709: Begin
1712: -- Call conversion function to turn arguments into the
1713: -- l_rec structure.
1714: --
1715: l_rec :=
1716: per_asg_shd.convert_args
1717: (
1718: p_assignment_id,
1719: null,
1720: