51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure dt_delete_dml
55: (p_rec in out nocopy per_asg_shd.g_rec_type,
56: p_effective_date in date,
57: p_datetrack_mode in varchar2,
58: p_validation_start_date in date,
59: p_validation_end_date in date) is
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
66: hr_utility.set_location(l_proc, 10);
67: per_asg_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Delete the where the effective start date is equal
70: -- to the validation end date.
71: --
72: delete from per_all_assignments_f
73: where assignment_id = p_rec.assignment_id
74: and effective_start_date = p_validation_start_date;
75: --
76: per_asg_shd.g_api_dml := false; -- Unset the api dml status
77: Else
78: hr_utility.set_location(l_proc, 15);
79: per_asg_shd.g_api_dml := true; -- Set the api dml status
80: --
75: --
76: per_asg_shd.g_api_dml := false; -- Unset the api dml status
77: Else
78: hr_utility.set_location(l_proc, 15);
79: per_asg_shd.g_api_dml := true; -- Set the api dml status
80: --
81: -- Delete the row(s) where the effective start date is greater than
82: -- or equal to the validation start date.
83: --
84: delete from per_all_assignments_f
85: where assignment_id = p_rec.assignment_id
86: and effective_start_date >= p_validation_start_date;
87: --
88: per_asg_shd.g_api_dml := false; -- Unset the api dml status
89: End If;
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: per_asg_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: End dt_delete_dml;
97: --
98: -- ----------------------------------------------------------------------------
98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy per_asg_shd.g_rec_type,
103: p_effective_date in date,
104: p_datetrack_mode in varchar2,
105: p_validation_start_date in date,
106: p_validation_end_date in date) is
152: --
153: -- {End Of Comments}
154: -- ----------------------------------------------------------------------------
155: Procedure dt_pre_delete
156: (p_rec in out nocopy per_asg_shd.g_rec_type,
157: p_effective_date in date,
158: p_datetrack_mode in varchar2,
159: p_validation_start_date in date,
160: p_validation_end_date in date) is
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := per_asg_shd.g_old_rec.effective_start_date;
170: --
171: If (p_datetrack_mode = 'DELETE') then
172: p_rec.effective_end_date := p_validation_start_date - 1;
173: Else
175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: per_asg_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date,
181: p_base_key_value => p_rec.assignment_id,
182: p_new_effective_end_date => p_rec.effective_end_date,
183: p_validation_start_date => p_validation_start_date,
229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out nocopy per_asg_shd.g_rec_type,
234: p_effective_date in date,
235: p_datetrack_mode in varchar2,
236: p_validation_start_date in date,
237: p_validation_end_date in date) is
308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure post_delete
312: (p_rec in per_asg_shd.g_rec_type,
313: p_effective_date in date,
314: p_datetrack_mode in varchar2,
315: p_validation_start_date in date,
316: p_validation_end_date in date,
399: ,p_org_now_no_manager_warning
400: => p_org_now_no_manager_warning
401: ,p_object_version_number => p_rec.object_version_number
402: ,p_effective_start_date_o
403: => per_asg_shd.g_old_rec.effective_start_date
404: ,p_effective_end_date_o
405: => per_asg_shd.g_old_rec.effective_end_date
406: ,p_business_group_id_o
407: => per_asg_shd.g_old_rec.business_group_id
401: ,p_object_version_number => p_rec.object_version_number
402: ,p_effective_start_date_o
403: => per_asg_shd.g_old_rec.effective_start_date
404: ,p_effective_end_date_o
405: => per_asg_shd.g_old_rec.effective_end_date
406: ,p_business_group_id_o
407: => per_asg_shd.g_old_rec.business_group_id
408: ,p_recruiter_id_o
409: => per_asg_shd.g_old_rec.recruiter_id
403: => per_asg_shd.g_old_rec.effective_start_date
404: ,p_effective_end_date_o
405: => per_asg_shd.g_old_rec.effective_end_date
406: ,p_business_group_id_o
407: => per_asg_shd.g_old_rec.business_group_id
408: ,p_recruiter_id_o
409: => per_asg_shd.g_old_rec.recruiter_id
410: ,p_grade_id_o
411: => per_asg_shd.g_old_rec.grade_id
405: => per_asg_shd.g_old_rec.effective_end_date
406: ,p_business_group_id_o
407: => per_asg_shd.g_old_rec.business_group_id
408: ,p_recruiter_id_o
409: => per_asg_shd.g_old_rec.recruiter_id
410: ,p_grade_id_o
411: => per_asg_shd.g_old_rec.grade_id
412: ,p_position_id_o
413: => per_asg_shd.g_old_rec.position_id
407: => per_asg_shd.g_old_rec.business_group_id
408: ,p_recruiter_id_o
409: => per_asg_shd.g_old_rec.recruiter_id
410: ,p_grade_id_o
411: => per_asg_shd.g_old_rec.grade_id
412: ,p_position_id_o
413: => per_asg_shd.g_old_rec.position_id
414: ,p_job_id_o
415: => per_asg_shd.g_old_rec.job_id
409: => per_asg_shd.g_old_rec.recruiter_id
410: ,p_grade_id_o
411: => per_asg_shd.g_old_rec.grade_id
412: ,p_position_id_o
413: => per_asg_shd.g_old_rec.position_id
414: ,p_job_id_o
415: => per_asg_shd.g_old_rec.job_id
416: ,p_assignment_status_type_id_o
417: => per_asg_shd.g_old_rec.assignment_status_type_id
411: => per_asg_shd.g_old_rec.grade_id
412: ,p_position_id_o
413: => per_asg_shd.g_old_rec.position_id
414: ,p_job_id_o
415: => per_asg_shd.g_old_rec.job_id
416: ,p_assignment_status_type_id_o
417: => per_asg_shd.g_old_rec.assignment_status_type_id
418: ,p_payroll_id_o
419: => per_asg_shd.g_old_rec.payroll_id
413: => per_asg_shd.g_old_rec.position_id
414: ,p_job_id_o
415: => per_asg_shd.g_old_rec.job_id
416: ,p_assignment_status_type_id_o
417: => per_asg_shd.g_old_rec.assignment_status_type_id
418: ,p_payroll_id_o
419: => per_asg_shd.g_old_rec.payroll_id
420: ,p_location_id_o
421: => per_asg_shd.g_old_rec.location_id
415: => per_asg_shd.g_old_rec.job_id
416: ,p_assignment_status_type_id_o
417: => per_asg_shd.g_old_rec.assignment_status_type_id
418: ,p_payroll_id_o
419: => per_asg_shd.g_old_rec.payroll_id
420: ,p_location_id_o
421: => per_asg_shd.g_old_rec.location_id
422: ,p_person_referred_by_id_o
423: => per_asg_shd.g_old_rec.person_referred_by_id
417: => per_asg_shd.g_old_rec.assignment_status_type_id
418: ,p_payroll_id_o
419: => per_asg_shd.g_old_rec.payroll_id
420: ,p_location_id_o
421: => per_asg_shd.g_old_rec.location_id
422: ,p_person_referred_by_id_o
423: => per_asg_shd.g_old_rec.person_referred_by_id
424: ,p_supervisor_id_o
425: => per_asg_shd.g_old_rec.supervisor_id
419: => per_asg_shd.g_old_rec.payroll_id
420: ,p_location_id_o
421: => per_asg_shd.g_old_rec.location_id
422: ,p_person_referred_by_id_o
423: => per_asg_shd.g_old_rec.person_referred_by_id
424: ,p_supervisor_id_o
425: => per_asg_shd.g_old_rec.supervisor_id
426: ,p_special_ceiling_step_id_o
427: => per_asg_shd.g_old_rec.special_ceiling_step_id
421: => per_asg_shd.g_old_rec.location_id
422: ,p_person_referred_by_id_o
423: => per_asg_shd.g_old_rec.person_referred_by_id
424: ,p_supervisor_id_o
425: => per_asg_shd.g_old_rec.supervisor_id
426: ,p_special_ceiling_step_id_o
427: => per_asg_shd.g_old_rec.special_ceiling_step_id
428: ,p_person_id_o
429: => per_asg_shd.g_old_rec.person_id
423: => per_asg_shd.g_old_rec.person_referred_by_id
424: ,p_supervisor_id_o
425: => per_asg_shd.g_old_rec.supervisor_id
426: ,p_special_ceiling_step_id_o
427: => per_asg_shd.g_old_rec.special_ceiling_step_id
428: ,p_person_id_o
429: => per_asg_shd.g_old_rec.person_id
430: ,p_recruitment_activity_id_o
431: => per_asg_shd.g_old_rec.recruitment_activity_id
425: => per_asg_shd.g_old_rec.supervisor_id
426: ,p_special_ceiling_step_id_o
427: => per_asg_shd.g_old_rec.special_ceiling_step_id
428: ,p_person_id_o
429: => per_asg_shd.g_old_rec.person_id
430: ,p_recruitment_activity_id_o
431: => per_asg_shd.g_old_rec.recruitment_activity_id
432: ,p_source_organization_id_o
433: => per_asg_shd.g_old_rec.source_organization_id
427: => per_asg_shd.g_old_rec.special_ceiling_step_id
428: ,p_person_id_o
429: => per_asg_shd.g_old_rec.person_id
430: ,p_recruitment_activity_id_o
431: => per_asg_shd.g_old_rec.recruitment_activity_id
432: ,p_source_organization_id_o
433: => per_asg_shd.g_old_rec.source_organization_id
434: ,p_organization_id_o
435: => per_asg_shd.g_old_rec.organization_id
429: => per_asg_shd.g_old_rec.person_id
430: ,p_recruitment_activity_id_o
431: => per_asg_shd.g_old_rec.recruitment_activity_id
432: ,p_source_organization_id_o
433: => per_asg_shd.g_old_rec.source_organization_id
434: ,p_organization_id_o
435: => per_asg_shd.g_old_rec.organization_id
436: ,p_people_group_id_o
437: => per_asg_shd.g_old_rec.people_group_id
431: => per_asg_shd.g_old_rec.recruitment_activity_id
432: ,p_source_organization_id_o
433: => per_asg_shd.g_old_rec.source_organization_id
434: ,p_organization_id_o
435: => per_asg_shd.g_old_rec.organization_id
436: ,p_people_group_id_o
437: => per_asg_shd.g_old_rec.people_group_id
438: ,p_soft_coding_keyflex_id_o
439: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
433: => per_asg_shd.g_old_rec.source_organization_id
434: ,p_organization_id_o
435: => per_asg_shd.g_old_rec.organization_id
436: ,p_people_group_id_o
437: => per_asg_shd.g_old_rec.people_group_id
438: ,p_soft_coding_keyflex_id_o
439: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
440: ,p_vacancy_id_o
441: => per_asg_shd.g_old_rec.vacancy_id
435: => per_asg_shd.g_old_rec.organization_id
436: ,p_people_group_id_o
437: => per_asg_shd.g_old_rec.people_group_id
438: ,p_soft_coding_keyflex_id_o
439: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
440: ,p_vacancy_id_o
441: => per_asg_shd.g_old_rec.vacancy_id
442: ,p_pay_basis_id_o
443: => per_asg_shd.g_old_rec.pay_basis_id
437: => per_asg_shd.g_old_rec.people_group_id
438: ,p_soft_coding_keyflex_id_o
439: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
440: ,p_vacancy_id_o
441: => per_asg_shd.g_old_rec.vacancy_id
442: ,p_pay_basis_id_o
443: => per_asg_shd.g_old_rec.pay_basis_id
444: ,p_assignment_sequence_o
445: => per_asg_shd.g_old_rec.assignment_sequence
439: => per_asg_shd.g_old_rec.soft_coding_keyflex_id
440: ,p_vacancy_id_o
441: => per_asg_shd.g_old_rec.vacancy_id
442: ,p_pay_basis_id_o
443: => per_asg_shd.g_old_rec.pay_basis_id
444: ,p_assignment_sequence_o
445: => per_asg_shd.g_old_rec.assignment_sequence
446: ,p_assignment_type_o
447: => per_asg_shd.g_old_rec.assignment_type
441: => per_asg_shd.g_old_rec.vacancy_id
442: ,p_pay_basis_id_o
443: => per_asg_shd.g_old_rec.pay_basis_id
444: ,p_assignment_sequence_o
445: => per_asg_shd.g_old_rec.assignment_sequence
446: ,p_assignment_type_o
447: => per_asg_shd.g_old_rec.assignment_type
448: ,p_primary_flag_o
449: => per_asg_shd.g_old_rec.primary_flag
443: => per_asg_shd.g_old_rec.pay_basis_id
444: ,p_assignment_sequence_o
445: => per_asg_shd.g_old_rec.assignment_sequence
446: ,p_assignment_type_o
447: => per_asg_shd.g_old_rec.assignment_type
448: ,p_primary_flag_o
449: => per_asg_shd.g_old_rec.primary_flag
450: ,p_application_id_o
451: => per_asg_shd.g_old_rec.application_id
445: => per_asg_shd.g_old_rec.assignment_sequence
446: ,p_assignment_type_o
447: => per_asg_shd.g_old_rec.assignment_type
448: ,p_primary_flag_o
449: => per_asg_shd.g_old_rec.primary_flag
450: ,p_application_id_o
451: => per_asg_shd.g_old_rec.application_id
452: ,p_assignment_number_o
453: => per_asg_shd.g_old_rec.assignment_number
447: => per_asg_shd.g_old_rec.assignment_type
448: ,p_primary_flag_o
449: => per_asg_shd.g_old_rec.primary_flag
450: ,p_application_id_o
451: => per_asg_shd.g_old_rec.application_id
452: ,p_assignment_number_o
453: => per_asg_shd.g_old_rec.assignment_number
454: ,p_change_reason_o
455: => per_asg_shd.g_old_rec.change_reason
449: => per_asg_shd.g_old_rec.primary_flag
450: ,p_application_id_o
451: => per_asg_shd.g_old_rec.application_id
452: ,p_assignment_number_o
453: => per_asg_shd.g_old_rec.assignment_number
454: ,p_change_reason_o
455: => per_asg_shd.g_old_rec.change_reason
456: ,p_comment_id_o
457: => per_asg_shd.g_old_rec.comment_id
451: => per_asg_shd.g_old_rec.application_id
452: ,p_assignment_number_o
453: => per_asg_shd.g_old_rec.assignment_number
454: ,p_change_reason_o
455: => per_asg_shd.g_old_rec.change_reason
456: ,p_comment_id_o
457: => per_asg_shd.g_old_rec.comment_id
458: ,p_date_probation_end_o
459: => per_asg_shd.g_old_rec.date_probation_end
453: => per_asg_shd.g_old_rec.assignment_number
454: ,p_change_reason_o
455: => per_asg_shd.g_old_rec.change_reason
456: ,p_comment_id_o
457: => per_asg_shd.g_old_rec.comment_id
458: ,p_date_probation_end_o
459: => per_asg_shd.g_old_rec.date_probation_end
460: ,p_default_code_comb_id_o
461: => per_asg_shd.g_old_rec.default_code_comb_id
455: => per_asg_shd.g_old_rec.change_reason
456: ,p_comment_id_o
457: => per_asg_shd.g_old_rec.comment_id
458: ,p_date_probation_end_o
459: => per_asg_shd.g_old_rec.date_probation_end
460: ,p_default_code_comb_id_o
461: => per_asg_shd.g_old_rec.default_code_comb_id
462: ,p_employment_category_o
463: => per_asg_shd.g_old_rec.employment_category
457: => per_asg_shd.g_old_rec.comment_id
458: ,p_date_probation_end_o
459: => per_asg_shd.g_old_rec.date_probation_end
460: ,p_default_code_comb_id_o
461: => per_asg_shd.g_old_rec.default_code_comb_id
462: ,p_employment_category_o
463: => per_asg_shd.g_old_rec.employment_category
464: ,p_frequency_o
465: => per_asg_shd.g_old_rec.frequency
459: => per_asg_shd.g_old_rec.date_probation_end
460: ,p_default_code_comb_id_o
461: => per_asg_shd.g_old_rec.default_code_comb_id
462: ,p_employment_category_o
463: => per_asg_shd.g_old_rec.employment_category
464: ,p_frequency_o
465: => per_asg_shd.g_old_rec.frequency
466: ,p_internal_address_line_o
467: => per_asg_shd.g_old_rec.internal_address_line
461: => per_asg_shd.g_old_rec.default_code_comb_id
462: ,p_employment_category_o
463: => per_asg_shd.g_old_rec.employment_category
464: ,p_frequency_o
465: => per_asg_shd.g_old_rec.frequency
466: ,p_internal_address_line_o
467: => per_asg_shd.g_old_rec.internal_address_line
468: ,p_manager_flag_o
469: => per_asg_shd.g_old_rec.manager_flag
463: => per_asg_shd.g_old_rec.employment_category
464: ,p_frequency_o
465: => per_asg_shd.g_old_rec.frequency
466: ,p_internal_address_line_o
467: => per_asg_shd.g_old_rec.internal_address_line
468: ,p_manager_flag_o
469: => per_asg_shd.g_old_rec.manager_flag
470: ,p_normal_hours_o
471: => per_asg_shd.g_old_rec.normal_hours
465: => per_asg_shd.g_old_rec.frequency
466: ,p_internal_address_line_o
467: => per_asg_shd.g_old_rec.internal_address_line
468: ,p_manager_flag_o
469: => per_asg_shd.g_old_rec.manager_flag
470: ,p_normal_hours_o
471: => per_asg_shd.g_old_rec.normal_hours
472: ,p_perf_review_period_o
473: => per_asg_shd.g_old_rec.perf_review_period
467: => per_asg_shd.g_old_rec.internal_address_line
468: ,p_manager_flag_o
469: => per_asg_shd.g_old_rec.manager_flag
470: ,p_normal_hours_o
471: => per_asg_shd.g_old_rec.normal_hours
472: ,p_perf_review_period_o
473: => per_asg_shd.g_old_rec.perf_review_period
474: ,p_perf_review_period_frequen_o
475: => per_asg_shd.g_old_rec.perf_review_period_frequency
469: => per_asg_shd.g_old_rec.manager_flag
470: ,p_normal_hours_o
471: => per_asg_shd.g_old_rec.normal_hours
472: ,p_perf_review_period_o
473: => per_asg_shd.g_old_rec.perf_review_period
474: ,p_perf_review_period_frequen_o
475: => per_asg_shd.g_old_rec.perf_review_period_frequency
476: ,p_period_of_service_id_o
477: => per_asg_shd.g_old_rec.period_of_service_id
471: => per_asg_shd.g_old_rec.normal_hours
472: ,p_perf_review_period_o
473: => per_asg_shd.g_old_rec.perf_review_period
474: ,p_perf_review_period_frequen_o
475: => per_asg_shd.g_old_rec.perf_review_period_frequency
476: ,p_period_of_service_id_o
477: => per_asg_shd.g_old_rec.period_of_service_id
478: ,p_probation_period_o
479: => per_asg_shd.g_old_rec.probation_period
473: => per_asg_shd.g_old_rec.perf_review_period
474: ,p_perf_review_period_frequen_o
475: => per_asg_shd.g_old_rec.perf_review_period_frequency
476: ,p_period_of_service_id_o
477: => per_asg_shd.g_old_rec.period_of_service_id
478: ,p_probation_period_o
479: => per_asg_shd.g_old_rec.probation_period
480: ,p_probation_unit_o
481: => per_asg_shd.g_old_rec.probation_unit
475: => per_asg_shd.g_old_rec.perf_review_period_frequency
476: ,p_period_of_service_id_o
477: => per_asg_shd.g_old_rec.period_of_service_id
478: ,p_probation_period_o
479: => per_asg_shd.g_old_rec.probation_period
480: ,p_probation_unit_o
481: => per_asg_shd.g_old_rec.probation_unit
482: ,p_sal_review_period_o
483: => per_asg_shd.g_old_rec.sal_review_period
477: => per_asg_shd.g_old_rec.period_of_service_id
478: ,p_probation_period_o
479: => per_asg_shd.g_old_rec.probation_period
480: ,p_probation_unit_o
481: => per_asg_shd.g_old_rec.probation_unit
482: ,p_sal_review_period_o
483: => per_asg_shd.g_old_rec.sal_review_period
484: ,p_sal_review_period_frequen_o
485: => per_asg_shd.g_old_rec.sal_review_period_frequency
479: => per_asg_shd.g_old_rec.probation_period
480: ,p_probation_unit_o
481: => per_asg_shd.g_old_rec.probation_unit
482: ,p_sal_review_period_o
483: => per_asg_shd.g_old_rec.sal_review_period
484: ,p_sal_review_period_frequen_o
485: => per_asg_shd.g_old_rec.sal_review_period_frequency
486: ,p_set_of_books_id_o
487: => per_asg_shd.g_old_rec.set_of_books_id
481: => per_asg_shd.g_old_rec.probation_unit
482: ,p_sal_review_period_o
483: => per_asg_shd.g_old_rec.sal_review_period
484: ,p_sal_review_period_frequen_o
485: => per_asg_shd.g_old_rec.sal_review_period_frequency
486: ,p_set_of_books_id_o
487: => per_asg_shd.g_old_rec.set_of_books_id
488: ,p_source_type_o
489: => per_asg_shd.g_old_rec.source_type
483: => per_asg_shd.g_old_rec.sal_review_period
484: ,p_sal_review_period_frequen_o
485: => per_asg_shd.g_old_rec.sal_review_period_frequency
486: ,p_set_of_books_id_o
487: => per_asg_shd.g_old_rec.set_of_books_id
488: ,p_source_type_o
489: => per_asg_shd.g_old_rec.source_type
490: ,p_time_normal_finish_o
491: => per_asg_shd.g_old_rec.time_normal_finish
485: => per_asg_shd.g_old_rec.sal_review_period_frequency
486: ,p_set_of_books_id_o
487: => per_asg_shd.g_old_rec.set_of_books_id
488: ,p_source_type_o
489: => per_asg_shd.g_old_rec.source_type
490: ,p_time_normal_finish_o
491: => per_asg_shd.g_old_rec.time_normal_finish
492: ,p_time_normal_start_o
493: => per_asg_shd.g_old_rec.time_normal_start
487: => per_asg_shd.g_old_rec.set_of_books_id
488: ,p_source_type_o
489: => per_asg_shd.g_old_rec.source_type
490: ,p_time_normal_finish_o
491: => per_asg_shd.g_old_rec.time_normal_finish
492: ,p_time_normal_start_o
493: => per_asg_shd.g_old_rec.time_normal_start
494: ,p_bargaining_unit_code_o
495: => per_asg_shd.g_old_rec.bargaining_unit_code
489: => per_asg_shd.g_old_rec.source_type
490: ,p_time_normal_finish_o
491: => per_asg_shd.g_old_rec.time_normal_finish
492: ,p_time_normal_start_o
493: => per_asg_shd.g_old_rec.time_normal_start
494: ,p_bargaining_unit_code_o
495: => per_asg_shd.g_old_rec.bargaining_unit_code
496: ,p_labour_union_member_flag_o
497: => per_asg_shd.g_old_rec.labour_union_member_flag
491: => per_asg_shd.g_old_rec.time_normal_finish
492: ,p_time_normal_start_o
493: => per_asg_shd.g_old_rec.time_normal_start
494: ,p_bargaining_unit_code_o
495: => per_asg_shd.g_old_rec.bargaining_unit_code
496: ,p_labour_union_member_flag_o
497: => per_asg_shd.g_old_rec.labour_union_member_flag
498: ,p_hourly_salaried_code_o
499: => per_asg_shd.g_old_rec.hourly_salaried_code
493: => per_asg_shd.g_old_rec.time_normal_start
494: ,p_bargaining_unit_code_o
495: => per_asg_shd.g_old_rec.bargaining_unit_code
496: ,p_labour_union_member_flag_o
497: => per_asg_shd.g_old_rec.labour_union_member_flag
498: ,p_hourly_salaried_code_o
499: => per_asg_shd.g_old_rec.hourly_salaried_code
500: ,p_request_id_o
501: => per_asg_shd.g_old_rec.request_id
495: => per_asg_shd.g_old_rec.bargaining_unit_code
496: ,p_labour_union_member_flag_o
497: => per_asg_shd.g_old_rec.labour_union_member_flag
498: ,p_hourly_salaried_code_o
499: => per_asg_shd.g_old_rec.hourly_salaried_code
500: ,p_request_id_o
501: => per_asg_shd.g_old_rec.request_id
502: ,p_program_application_id_o
503: => per_asg_shd.g_old_rec.program_application_id
497: => per_asg_shd.g_old_rec.labour_union_member_flag
498: ,p_hourly_salaried_code_o
499: => per_asg_shd.g_old_rec.hourly_salaried_code
500: ,p_request_id_o
501: => per_asg_shd.g_old_rec.request_id
502: ,p_program_application_id_o
503: => per_asg_shd.g_old_rec.program_application_id
504: ,p_program_id_o
505: => per_asg_shd.g_old_rec.program_id
499: => per_asg_shd.g_old_rec.hourly_salaried_code
500: ,p_request_id_o
501: => per_asg_shd.g_old_rec.request_id
502: ,p_program_application_id_o
503: => per_asg_shd.g_old_rec.program_application_id
504: ,p_program_id_o
505: => per_asg_shd.g_old_rec.program_id
506: ,p_program_update_date_o
507: => per_asg_shd.g_old_rec.program_update_date
501: => per_asg_shd.g_old_rec.request_id
502: ,p_program_application_id_o
503: => per_asg_shd.g_old_rec.program_application_id
504: ,p_program_id_o
505: => per_asg_shd.g_old_rec.program_id
506: ,p_program_update_date_o
507: => per_asg_shd.g_old_rec.program_update_date
508: ,p_ass_attribute_category_o
509: => per_asg_shd.g_old_rec.ass_attribute_category
503: => per_asg_shd.g_old_rec.program_application_id
504: ,p_program_id_o
505: => per_asg_shd.g_old_rec.program_id
506: ,p_program_update_date_o
507: => per_asg_shd.g_old_rec.program_update_date
508: ,p_ass_attribute_category_o
509: => per_asg_shd.g_old_rec.ass_attribute_category
510: ,p_ass_attribute1_o
511: => per_asg_shd.g_old_rec.ass_attribute1
505: => per_asg_shd.g_old_rec.program_id
506: ,p_program_update_date_o
507: => per_asg_shd.g_old_rec.program_update_date
508: ,p_ass_attribute_category_o
509: => per_asg_shd.g_old_rec.ass_attribute_category
510: ,p_ass_attribute1_o
511: => per_asg_shd.g_old_rec.ass_attribute1
512: ,p_ass_attribute2_o
513: => per_asg_shd.g_old_rec.ass_attribute2
507: => per_asg_shd.g_old_rec.program_update_date
508: ,p_ass_attribute_category_o
509: => per_asg_shd.g_old_rec.ass_attribute_category
510: ,p_ass_attribute1_o
511: => per_asg_shd.g_old_rec.ass_attribute1
512: ,p_ass_attribute2_o
513: => per_asg_shd.g_old_rec.ass_attribute2
514: ,p_ass_attribute3_o
515: => per_asg_shd.g_old_rec.ass_attribute3
509: => per_asg_shd.g_old_rec.ass_attribute_category
510: ,p_ass_attribute1_o
511: => per_asg_shd.g_old_rec.ass_attribute1
512: ,p_ass_attribute2_o
513: => per_asg_shd.g_old_rec.ass_attribute2
514: ,p_ass_attribute3_o
515: => per_asg_shd.g_old_rec.ass_attribute3
516: ,p_ass_attribute4_o
517: => per_asg_shd.g_old_rec.ass_attribute4
511: => per_asg_shd.g_old_rec.ass_attribute1
512: ,p_ass_attribute2_o
513: => per_asg_shd.g_old_rec.ass_attribute2
514: ,p_ass_attribute3_o
515: => per_asg_shd.g_old_rec.ass_attribute3
516: ,p_ass_attribute4_o
517: => per_asg_shd.g_old_rec.ass_attribute4
518: ,p_ass_attribute5_o
519: => per_asg_shd.g_old_rec.ass_attribute5
513: => per_asg_shd.g_old_rec.ass_attribute2
514: ,p_ass_attribute3_o
515: => per_asg_shd.g_old_rec.ass_attribute3
516: ,p_ass_attribute4_o
517: => per_asg_shd.g_old_rec.ass_attribute4
518: ,p_ass_attribute5_o
519: => per_asg_shd.g_old_rec.ass_attribute5
520: ,p_ass_attribute6_o
521: => per_asg_shd.g_old_rec.ass_attribute6
515: => per_asg_shd.g_old_rec.ass_attribute3
516: ,p_ass_attribute4_o
517: => per_asg_shd.g_old_rec.ass_attribute4
518: ,p_ass_attribute5_o
519: => per_asg_shd.g_old_rec.ass_attribute5
520: ,p_ass_attribute6_o
521: => per_asg_shd.g_old_rec.ass_attribute6
522: ,p_ass_attribute7_o
523: => per_asg_shd.g_old_rec.ass_attribute7
517: => per_asg_shd.g_old_rec.ass_attribute4
518: ,p_ass_attribute5_o
519: => per_asg_shd.g_old_rec.ass_attribute5
520: ,p_ass_attribute6_o
521: => per_asg_shd.g_old_rec.ass_attribute6
522: ,p_ass_attribute7_o
523: => per_asg_shd.g_old_rec.ass_attribute7
524: ,p_ass_attribute8_o
525: => per_asg_shd.g_old_rec.ass_attribute8
519: => per_asg_shd.g_old_rec.ass_attribute5
520: ,p_ass_attribute6_o
521: => per_asg_shd.g_old_rec.ass_attribute6
522: ,p_ass_attribute7_o
523: => per_asg_shd.g_old_rec.ass_attribute7
524: ,p_ass_attribute8_o
525: => per_asg_shd.g_old_rec.ass_attribute8
526: ,p_ass_attribute9_o
527: => per_asg_shd.g_old_rec.ass_attribute9
521: => per_asg_shd.g_old_rec.ass_attribute6
522: ,p_ass_attribute7_o
523: => per_asg_shd.g_old_rec.ass_attribute7
524: ,p_ass_attribute8_o
525: => per_asg_shd.g_old_rec.ass_attribute8
526: ,p_ass_attribute9_o
527: => per_asg_shd.g_old_rec.ass_attribute9
528: ,p_ass_attribute10_o
529: => per_asg_shd.g_old_rec.ass_attribute10
523: => per_asg_shd.g_old_rec.ass_attribute7
524: ,p_ass_attribute8_o
525: => per_asg_shd.g_old_rec.ass_attribute8
526: ,p_ass_attribute9_o
527: => per_asg_shd.g_old_rec.ass_attribute9
528: ,p_ass_attribute10_o
529: => per_asg_shd.g_old_rec.ass_attribute10
530: ,p_ass_attribute11_o
531: => per_asg_shd.g_old_rec.ass_attribute11
525: => per_asg_shd.g_old_rec.ass_attribute8
526: ,p_ass_attribute9_o
527: => per_asg_shd.g_old_rec.ass_attribute9
528: ,p_ass_attribute10_o
529: => per_asg_shd.g_old_rec.ass_attribute10
530: ,p_ass_attribute11_o
531: => per_asg_shd.g_old_rec.ass_attribute11
532: ,p_ass_attribute12_o
533: => per_asg_shd.g_old_rec.ass_attribute12
527: => per_asg_shd.g_old_rec.ass_attribute9
528: ,p_ass_attribute10_o
529: => per_asg_shd.g_old_rec.ass_attribute10
530: ,p_ass_attribute11_o
531: => per_asg_shd.g_old_rec.ass_attribute11
532: ,p_ass_attribute12_o
533: => per_asg_shd.g_old_rec.ass_attribute12
534: ,p_ass_attribute13_o
535: => per_asg_shd.g_old_rec.ass_attribute13
529: => per_asg_shd.g_old_rec.ass_attribute10
530: ,p_ass_attribute11_o
531: => per_asg_shd.g_old_rec.ass_attribute11
532: ,p_ass_attribute12_o
533: => per_asg_shd.g_old_rec.ass_attribute12
534: ,p_ass_attribute13_o
535: => per_asg_shd.g_old_rec.ass_attribute13
536: ,p_ass_attribute14_o
537: => per_asg_shd.g_old_rec.ass_attribute14
531: => per_asg_shd.g_old_rec.ass_attribute11
532: ,p_ass_attribute12_o
533: => per_asg_shd.g_old_rec.ass_attribute12
534: ,p_ass_attribute13_o
535: => per_asg_shd.g_old_rec.ass_attribute13
536: ,p_ass_attribute14_o
537: => per_asg_shd.g_old_rec.ass_attribute14
538: ,p_ass_attribute15_o
539: => per_asg_shd.g_old_rec.ass_attribute15
533: => per_asg_shd.g_old_rec.ass_attribute12
534: ,p_ass_attribute13_o
535: => per_asg_shd.g_old_rec.ass_attribute13
536: ,p_ass_attribute14_o
537: => per_asg_shd.g_old_rec.ass_attribute14
538: ,p_ass_attribute15_o
539: => per_asg_shd.g_old_rec.ass_attribute15
540: ,p_ass_attribute16_o
541: => per_asg_shd.g_old_rec.ass_attribute16
535: => per_asg_shd.g_old_rec.ass_attribute13
536: ,p_ass_attribute14_o
537: => per_asg_shd.g_old_rec.ass_attribute14
538: ,p_ass_attribute15_o
539: => per_asg_shd.g_old_rec.ass_attribute15
540: ,p_ass_attribute16_o
541: => per_asg_shd.g_old_rec.ass_attribute16
542: ,p_ass_attribute17_o
543: => per_asg_shd.g_old_rec.ass_attribute17
537: => per_asg_shd.g_old_rec.ass_attribute14
538: ,p_ass_attribute15_o
539: => per_asg_shd.g_old_rec.ass_attribute15
540: ,p_ass_attribute16_o
541: => per_asg_shd.g_old_rec.ass_attribute16
542: ,p_ass_attribute17_o
543: => per_asg_shd.g_old_rec.ass_attribute17
544: ,p_ass_attribute18_o
545: => per_asg_shd.g_old_rec.ass_attribute18
539: => per_asg_shd.g_old_rec.ass_attribute15
540: ,p_ass_attribute16_o
541: => per_asg_shd.g_old_rec.ass_attribute16
542: ,p_ass_attribute17_o
543: => per_asg_shd.g_old_rec.ass_attribute17
544: ,p_ass_attribute18_o
545: => per_asg_shd.g_old_rec.ass_attribute18
546: ,p_ass_attribute19_o
547: => per_asg_shd.g_old_rec.ass_attribute19
541: => per_asg_shd.g_old_rec.ass_attribute16
542: ,p_ass_attribute17_o
543: => per_asg_shd.g_old_rec.ass_attribute17
544: ,p_ass_attribute18_o
545: => per_asg_shd.g_old_rec.ass_attribute18
546: ,p_ass_attribute19_o
547: => per_asg_shd.g_old_rec.ass_attribute19
548: ,p_ass_attribute20_o
549: => per_asg_shd.g_old_rec.ass_attribute20
543: => per_asg_shd.g_old_rec.ass_attribute17
544: ,p_ass_attribute18_o
545: => per_asg_shd.g_old_rec.ass_attribute18
546: ,p_ass_attribute19_o
547: => per_asg_shd.g_old_rec.ass_attribute19
548: ,p_ass_attribute20_o
549: => per_asg_shd.g_old_rec.ass_attribute20
550: ,p_ass_attribute21_o
551: => per_asg_shd.g_old_rec.ass_attribute21
545: => per_asg_shd.g_old_rec.ass_attribute18
546: ,p_ass_attribute19_o
547: => per_asg_shd.g_old_rec.ass_attribute19
548: ,p_ass_attribute20_o
549: => per_asg_shd.g_old_rec.ass_attribute20
550: ,p_ass_attribute21_o
551: => per_asg_shd.g_old_rec.ass_attribute21
552: ,p_ass_attribute22_o
553: => per_asg_shd.g_old_rec.ass_attribute22
547: => per_asg_shd.g_old_rec.ass_attribute19
548: ,p_ass_attribute20_o
549: => per_asg_shd.g_old_rec.ass_attribute20
550: ,p_ass_attribute21_o
551: => per_asg_shd.g_old_rec.ass_attribute21
552: ,p_ass_attribute22_o
553: => per_asg_shd.g_old_rec.ass_attribute22
554: ,p_ass_attribute23_o
555: => per_asg_shd.g_old_rec.ass_attribute23
549: => per_asg_shd.g_old_rec.ass_attribute20
550: ,p_ass_attribute21_o
551: => per_asg_shd.g_old_rec.ass_attribute21
552: ,p_ass_attribute22_o
553: => per_asg_shd.g_old_rec.ass_attribute22
554: ,p_ass_attribute23_o
555: => per_asg_shd.g_old_rec.ass_attribute23
556: ,p_ass_attribute24_o
557: => per_asg_shd.g_old_rec.ass_attribute24
551: => per_asg_shd.g_old_rec.ass_attribute21
552: ,p_ass_attribute22_o
553: => per_asg_shd.g_old_rec.ass_attribute22
554: ,p_ass_attribute23_o
555: => per_asg_shd.g_old_rec.ass_attribute23
556: ,p_ass_attribute24_o
557: => per_asg_shd.g_old_rec.ass_attribute24
558: ,p_ass_attribute25_o
559: => per_asg_shd.g_old_rec.ass_attribute25
553: => per_asg_shd.g_old_rec.ass_attribute22
554: ,p_ass_attribute23_o
555: => per_asg_shd.g_old_rec.ass_attribute23
556: ,p_ass_attribute24_o
557: => per_asg_shd.g_old_rec.ass_attribute24
558: ,p_ass_attribute25_o
559: => per_asg_shd.g_old_rec.ass_attribute25
560: ,p_ass_attribute26_o
561: => per_asg_shd.g_old_rec.ass_attribute26
555: => per_asg_shd.g_old_rec.ass_attribute23
556: ,p_ass_attribute24_o
557: => per_asg_shd.g_old_rec.ass_attribute24
558: ,p_ass_attribute25_o
559: => per_asg_shd.g_old_rec.ass_attribute25
560: ,p_ass_attribute26_o
561: => per_asg_shd.g_old_rec.ass_attribute26
562: ,p_ass_attribute27_o
563: => per_asg_shd.g_old_rec.ass_attribute27
557: => per_asg_shd.g_old_rec.ass_attribute24
558: ,p_ass_attribute25_o
559: => per_asg_shd.g_old_rec.ass_attribute25
560: ,p_ass_attribute26_o
561: => per_asg_shd.g_old_rec.ass_attribute26
562: ,p_ass_attribute27_o
563: => per_asg_shd.g_old_rec.ass_attribute27
564: ,p_ass_attribute28_o
565: => per_asg_shd.g_old_rec.ass_attribute28
559: => per_asg_shd.g_old_rec.ass_attribute25
560: ,p_ass_attribute26_o
561: => per_asg_shd.g_old_rec.ass_attribute26
562: ,p_ass_attribute27_o
563: => per_asg_shd.g_old_rec.ass_attribute27
564: ,p_ass_attribute28_o
565: => per_asg_shd.g_old_rec.ass_attribute28
566: ,p_ass_attribute29_o
567: => per_asg_shd.g_old_rec.ass_attribute29
561: => per_asg_shd.g_old_rec.ass_attribute26
562: ,p_ass_attribute27_o
563: => per_asg_shd.g_old_rec.ass_attribute27
564: ,p_ass_attribute28_o
565: => per_asg_shd.g_old_rec.ass_attribute28
566: ,p_ass_attribute29_o
567: => per_asg_shd.g_old_rec.ass_attribute29
568: ,p_ass_attribute30_o
569: => per_asg_shd.g_old_rec.ass_attribute30
563: => per_asg_shd.g_old_rec.ass_attribute27
564: ,p_ass_attribute28_o
565: => per_asg_shd.g_old_rec.ass_attribute28
566: ,p_ass_attribute29_o
567: => per_asg_shd.g_old_rec.ass_attribute29
568: ,p_ass_attribute30_o
569: => per_asg_shd.g_old_rec.ass_attribute30
570: ,p_title_o
571: => per_asg_shd.g_old_rec.title
565: => per_asg_shd.g_old_rec.ass_attribute28
566: ,p_ass_attribute29_o
567: => per_asg_shd.g_old_rec.ass_attribute29
568: ,p_ass_attribute30_o
569: => per_asg_shd.g_old_rec.ass_attribute30
570: ,p_title_o
571: => per_asg_shd.g_old_rec.title
572: ,p_contract_id_o
573: => per_asg_shd.g_old_rec.contract_id
567: => per_asg_shd.g_old_rec.ass_attribute29
568: ,p_ass_attribute30_o
569: => per_asg_shd.g_old_rec.ass_attribute30
570: ,p_title_o
571: => per_asg_shd.g_old_rec.title
572: ,p_contract_id_o
573: => per_asg_shd.g_old_rec.contract_id
574: ,p_establishment_id_o
575: => per_asg_shd.g_old_rec.establishment_id
569: => per_asg_shd.g_old_rec.ass_attribute30
570: ,p_title_o
571: => per_asg_shd.g_old_rec.title
572: ,p_contract_id_o
573: => per_asg_shd.g_old_rec.contract_id
574: ,p_establishment_id_o
575: => per_asg_shd.g_old_rec.establishment_id
576: ,p_collective_agreement_id_o
577: => per_asg_shd.g_old_rec.collective_agreement_id
571: => per_asg_shd.g_old_rec.title
572: ,p_contract_id_o
573: => per_asg_shd.g_old_rec.contract_id
574: ,p_establishment_id_o
575: => per_asg_shd.g_old_rec.establishment_id
576: ,p_collective_agreement_id_o
577: => per_asg_shd.g_old_rec.collective_agreement_id
578: ,p_cagr_grade_def_id_o
579: => per_asg_shd.g_old_rec.cagr_grade_def_id
573: => per_asg_shd.g_old_rec.contract_id
574: ,p_establishment_id_o
575: => per_asg_shd.g_old_rec.establishment_id
576: ,p_collective_agreement_id_o
577: => per_asg_shd.g_old_rec.collective_agreement_id
578: ,p_cagr_grade_def_id_o
579: => per_asg_shd.g_old_rec.cagr_grade_def_id
580: ,p_cagr_id_flex_num_o
581: => per_asg_shd.g_old_rec.cagr_id_flex_num
575: => per_asg_shd.g_old_rec.establishment_id
576: ,p_collective_agreement_id_o
577: => per_asg_shd.g_old_rec.collective_agreement_id
578: ,p_cagr_grade_def_id_o
579: => per_asg_shd.g_old_rec.cagr_grade_def_id
580: ,p_cagr_id_flex_num_o
581: => per_asg_shd.g_old_rec.cagr_id_flex_num
582: ,p_object_version_number_o
583: => per_asg_shd.g_old_rec.object_version_number
577: => per_asg_shd.g_old_rec.collective_agreement_id
578: ,p_cagr_grade_def_id_o
579: => per_asg_shd.g_old_rec.cagr_grade_def_id
580: ,p_cagr_id_flex_num_o
581: => per_asg_shd.g_old_rec.cagr_id_flex_num
582: ,p_object_version_number_o
583: => per_asg_shd.g_old_rec.object_version_number
584: ,p_notice_period_o
585: => per_asg_shd.g_old_rec.notice_period
579: => per_asg_shd.g_old_rec.cagr_grade_def_id
580: ,p_cagr_id_flex_num_o
581: => per_asg_shd.g_old_rec.cagr_id_flex_num
582: ,p_object_version_number_o
583: => per_asg_shd.g_old_rec.object_version_number
584: ,p_notice_period_o
585: => per_asg_shd.g_old_rec.notice_period
586: ,p_notice_period_uom_o
587: => per_asg_shd.g_old_rec.notice_period_uom
581: => per_asg_shd.g_old_rec.cagr_id_flex_num
582: ,p_object_version_number_o
583: => per_asg_shd.g_old_rec.object_version_number
584: ,p_notice_period_o
585: => per_asg_shd.g_old_rec.notice_period
586: ,p_notice_period_uom_o
587: => per_asg_shd.g_old_rec.notice_period_uom
588: ,p_employee_category_o
589: => per_asg_shd.g_old_rec.employee_category
583: => per_asg_shd.g_old_rec.object_version_number
584: ,p_notice_period_o
585: => per_asg_shd.g_old_rec.notice_period
586: ,p_notice_period_uom_o
587: => per_asg_shd.g_old_rec.notice_period_uom
588: ,p_employee_category_o
589: => per_asg_shd.g_old_rec.employee_category
590: ,p_work_at_home_o
591: => per_asg_shd.g_old_rec.work_at_home
585: => per_asg_shd.g_old_rec.notice_period
586: ,p_notice_period_uom_o
587: => per_asg_shd.g_old_rec.notice_period_uom
588: ,p_employee_category_o
589: => per_asg_shd.g_old_rec.employee_category
590: ,p_work_at_home_o
591: => per_asg_shd.g_old_rec.work_at_home
592: ,p_job_post_source_name_o
593: => per_asg_shd.g_old_rec.job_post_source_name
587: => per_asg_shd.g_old_rec.notice_period_uom
588: ,p_employee_category_o
589: => per_asg_shd.g_old_rec.employee_category
590: ,p_work_at_home_o
591: => per_asg_shd.g_old_rec.work_at_home
592: ,p_job_post_source_name_o
593: => per_asg_shd.g_old_rec.job_post_source_name
594: ,p_posting_content_id_o
595: => per_asg_shd.g_old_rec.posting_content_id
589: => per_asg_shd.g_old_rec.employee_category
590: ,p_work_at_home_o
591: => per_asg_shd.g_old_rec.work_at_home
592: ,p_job_post_source_name_o
593: => per_asg_shd.g_old_rec.job_post_source_name
594: ,p_posting_content_id_o
595: => per_asg_shd.g_old_rec.posting_content_id
596: ,p_placement_date_start_o
597: => per_asg_shd.g_old_rec.period_of_placement_date_start
591: => per_asg_shd.g_old_rec.work_at_home
592: ,p_job_post_source_name_o
593: => per_asg_shd.g_old_rec.job_post_source_name
594: ,p_posting_content_id_o
595: => per_asg_shd.g_old_rec.posting_content_id
596: ,p_placement_date_start_o
597: => per_asg_shd.g_old_rec.period_of_placement_date_start
598: ,p_vendor_id_o
599: => per_asg_shd.g_old_rec.vendor_id
593: => per_asg_shd.g_old_rec.job_post_source_name
594: ,p_posting_content_id_o
595: => per_asg_shd.g_old_rec.posting_content_id
596: ,p_placement_date_start_o
597: => per_asg_shd.g_old_rec.period_of_placement_date_start
598: ,p_vendor_id_o
599: => per_asg_shd.g_old_rec.vendor_id
600: ,p_vendor_employee_number_o
601: => per_asg_shd.g_old_rec.vendor_employee_number
595: => per_asg_shd.g_old_rec.posting_content_id
596: ,p_placement_date_start_o
597: => per_asg_shd.g_old_rec.period_of_placement_date_start
598: ,p_vendor_id_o
599: => per_asg_shd.g_old_rec.vendor_id
600: ,p_vendor_employee_number_o
601: => per_asg_shd.g_old_rec.vendor_employee_number
602: ,p_vendor_assignment_number_o
603: => per_asg_shd.g_old_rec.vendor_assignment_number
597: => per_asg_shd.g_old_rec.period_of_placement_date_start
598: ,p_vendor_id_o
599: => per_asg_shd.g_old_rec.vendor_id
600: ,p_vendor_employee_number_o
601: => per_asg_shd.g_old_rec.vendor_employee_number
602: ,p_vendor_assignment_number_o
603: => per_asg_shd.g_old_rec.vendor_assignment_number
604: ,p_assignment_category_o
605: => per_asg_shd.g_old_rec.assignment_category
599: => per_asg_shd.g_old_rec.vendor_id
600: ,p_vendor_employee_number_o
601: => per_asg_shd.g_old_rec.vendor_employee_number
602: ,p_vendor_assignment_number_o
603: => per_asg_shd.g_old_rec.vendor_assignment_number
604: ,p_assignment_category_o
605: => per_asg_shd.g_old_rec.assignment_category
606: ,p_project_title_o
607: => per_asg_shd.g_old_rec.project_title
601: => per_asg_shd.g_old_rec.vendor_employee_number
602: ,p_vendor_assignment_number_o
603: => per_asg_shd.g_old_rec.vendor_assignment_number
604: ,p_assignment_category_o
605: => per_asg_shd.g_old_rec.assignment_category
606: ,p_project_title_o
607: => per_asg_shd.g_old_rec.project_title
608: ,p_applicant_rank_o
609: => per_asg_shd.g_old_rec.applicant_rank
603: => per_asg_shd.g_old_rec.vendor_assignment_number
604: ,p_assignment_category_o
605: => per_asg_shd.g_old_rec.assignment_category
606: ,p_project_title_o
607: => per_asg_shd.g_old_rec.project_title
608: ,p_applicant_rank_o
609: => per_asg_shd.g_old_rec.applicant_rank
610: ,p_grade_ladder_pgm_id_o
611: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
605: => per_asg_shd.g_old_rec.assignment_category
606: ,p_project_title_o
607: => per_asg_shd.g_old_rec.project_title
608: ,p_applicant_rank_o
609: => per_asg_shd.g_old_rec.applicant_rank
610: ,p_grade_ladder_pgm_id_o
611: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
612: ,p_supervisor_assignment_id_o
613: => per_asg_shd.g_old_rec.supervisor_assignment_id
607: => per_asg_shd.g_old_rec.project_title
608: ,p_applicant_rank_o
609: => per_asg_shd.g_old_rec.applicant_rank
610: ,p_grade_ladder_pgm_id_o
611: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
612: ,p_supervisor_assignment_id_o
613: => per_asg_shd.g_old_rec.supervisor_assignment_id
614: ,p_vendor_site_id_o
615: => per_asg_shd.g_old_rec.vendor_site_id
609: => per_asg_shd.g_old_rec.applicant_rank
610: ,p_grade_ladder_pgm_id_o
611: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
612: ,p_supervisor_assignment_id_o
613: => per_asg_shd.g_old_rec.supervisor_assignment_id
614: ,p_vendor_site_id_o
615: => per_asg_shd.g_old_rec.vendor_site_id
616: ,p_po_header_id_o
617: => per_asg_shd.g_old_rec.po_header_id
611: => per_asg_shd.g_old_rec.grade_ladder_pgm_id
612: ,p_supervisor_assignment_id_o
613: => per_asg_shd.g_old_rec.supervisor_assignment_id
614: ,p_vendor_site_id_o
615: => per_asg_shd.g_old_rec.vendor_site_id
616: ,p_po_header_id_o
617: => per_asg_shd.g_old_rec.po_header_id
618: ,p_po_line_id_o
619: => per_asg_shd.g_old_rec.po_line_id
613: => per_asg_shd.g_old_rec.supervisor_assignment_id
614: ,p_vendor_site_id_o
615: => per_asg_shd.g_old_rec.vendor_site_id
616: ,p_po_header_id_o
617: => per_asg_shd.g_old_rec.po_header_id
618: ,p_po_line_id_o
619: => per_asg_shd.g_old_rec.po_line_id
620: ,p_projected_assignment_end_o
621: => per_asg_shd.g_old_rec.projected_assignment_end
615: => per_asg_shd.g_old_rec.vendor_site_id
616: ,p_po_header_id_o
617: => per_asg_shd.g_old_rec.po_header_id
618: ,p_po_line_id_o
619: => per_asg_shd.g_old_rec.po_line_id
620: ,p_projected_assignment_end_o
621: => per_asg_shd.g_old_rec.projected_assignment_end
622: );
623: exception
617: => per_asg_shd.g_old_rec.po_header_id
618: ,p_po_line_id_o
619: => per_asg_shd.g_old_rec.po_line_id
620: ,p_projected_assignment_end_o
621: => per_asg_shd.g_old_rec.projected_assignment_end
622: );
623: exception
624: when hr_api.cannot_find_prog_unit then
625: hr_api.cannot_find_prog_unit_error
643: ,P_EFFECTIVE_END_DATE => p_rec.effective_end_date
644: ,P_EFFECTIVE_START_DATE => p_rec.effective_start_date
645: ,P_OBJECT_VERSION_NUMBER => p_rec.object_version_number
646: ,P_ORG_NOW_NO_MANAGER_WARNING => p_org_now_no_manager_warning
647: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
648: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
649: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
650: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
651: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
644: ,P_EFFECTIVE_START_DATE => p_rec.effective_start_date
645: ,P_OBJECT_VERSION_NUMBER => p_rec.object_version_number
646: ,P_ORG_NOW_NO_MANAGER_WARNING => p_org_now_no_manager_warning
647: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
648: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
649: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
650: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
651: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
652: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
645: ,P_OBJECT_VERSION_NUMBER => p_rec.object_version_number
646: ,P_ORG_NOW_NO_MANAGER_WARNING => p_org_now_no_manager_warning
647: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
648: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
649: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
650: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
651: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
652: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
653: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
646: ,P_ORG_NOW_NO_MANAGER_WARNING => p_org_now_no_manager_warning
647: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
648: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
649: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
650: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
651: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
652: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
653: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
654: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
647: ,P_APPLICANT_RANK_O => per_asg_shd.g_old_rec.applicant_rank
648: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
649: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
650: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
651: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
652: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
653: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
654: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
655: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
648: ,P_APPLICATION_ID_O => per_asg_shd.g_old_rec.application_id
649: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
650: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
651: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
652: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
653: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
654: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
655: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
656: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
649: ,P_ASSIGNMENT_CATEGORY_O => per_asg_shd.g_old_rec.assignment_category
650: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
651: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
652: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
653: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
654: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
655: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
656: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
657: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
650: ,P_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.assignment_number
651: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
652: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
653: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
654: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
655: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
656: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
657: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
658: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
651: ,P_ASSIGNMENT_SEQUENCE_O => per_asg_shd.g_old_rec.assignment_sequence
652: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
653: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
654: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
655: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
656: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
657: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
658: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
659: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
652: ,P_ASSIGNMENT_STATUS_TYPE_ID_O => per_asg_shd.g_old_rec.assignment_status_type_id
653: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
654: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
655: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
656: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
657: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
658: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
659: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
660: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
653: ,P_ASSIGNMENT_TYPE_O => per_asg_shd.g_old_rec.assignment_type
654: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
655: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
656: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
657: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
658: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
659: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
660: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
661: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
654: ,P_ASS_ATTRIBUTE1_O => per_asg_shd.g_old_rec.ass_attribute1
655: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
656: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
657: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
658: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
659: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
660: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
661: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
662: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
655: ,P_ASS_ATTRIBUTE10_O => per_asg_shd.g_old_rec.ass_attribute10
656: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
657: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
658: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
659: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
660: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
661: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
662: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
663: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
656: ,P_ASS_ATTRIBUTE11_O => per_asg_shd.g_old_rec.ass_attribute11
657: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
658: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
659: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
660: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
661: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
662: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
663: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
664: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
657: ,P_ASS_ATTRIBUTE12_O => per_asg_shd.g_old_rec.ass_attribute12
658: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
659: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
660: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
661: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
662: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
663: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
664: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
665: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
658: ,P_ASS_ATTRIBUTE13_O => per_asg_shd.g_old_rec.ass_attribute13
659: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
660: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
661: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
662: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
663: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
664: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
665: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
666: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
659: ,P_ASS_ATTRIBUTE14_O => per_asg_shd.g_old_rec.ass_attribute14
660: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
661: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
662: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
663: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
664: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
665: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
666: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
667: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
660: ,P_ASS_ATTRIBUTE15_O => per_asg_shd.g_old_rec.ass_attribute15
661: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
662: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
663: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
664: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
665: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
666: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
667: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
668: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
661: ,P_ASS_ATTRIBUTE16_O => per_asg_shd.g_old_rec.ass_attribute16
662: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
663: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
664: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
665: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
666: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
667: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
668: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
669: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
662: ,P_ASS_ATTRIBUTE17_O => per_asg_shd.g_old_rec.ass_attribute17
663: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
664: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
665: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
666: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
667: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
668: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
669: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
670: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
663: ,P_ASS_ATTRIBUTE18_O => per_asg_shd.g_old_rec.ass_attribute18
664: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
665: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
666: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
667: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
668: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
669: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
670: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
671: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
664: ,P_ASS_ATTRIBUTE19_O => per_asg_shd.g_old_rec.ass_attribute19
665: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
666: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
667: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
668: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
669: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
670: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
671: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
672: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
665: ,P_ASS_ATTRIBUTE2_O => per_asg_shd.g_old_rec.ass_attribute2
666: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
667: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
668: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
669: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
670: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
671: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
672: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
673: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
666: ,P_ASS_ATTRIBUTE20_O => per_asg_shd.g_old_rec.ass_attribute20
667: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
668: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
669: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
670: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
671: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
672: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
673: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
674: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
667: ,P_ASS_ATTRIBUTE21_O => per_asg_shd.g_old_rec.ass_attribute21
668: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
669: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
670: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
671: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
672: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
673: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
674: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
675: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
668: ,P_ASS_ATTRIBUTE22_O => per_asg_shd.g_old_rec.ass_attribute22
669: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
670: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
671: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
672: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
673: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
674: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
675: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
676: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
669: ,P_ASS_ATTRIBUTE23_O => per_asg_shd.g_old_rec.ass_attribute23
670: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
671: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
672: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
673: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
674: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
675: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
676: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
677: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
670: ,P_ASS_ATTRIBUTE24_O => per_asg_shd.g_old_rec.ass_attribute24
671: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
672: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
673: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
674: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
675: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
676: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
677: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
678: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
671: ,P_ASS_ATTRIBUTE25_O => per_asg_shd.g_old_rec.ass_attribute25
672: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
673: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
674: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
675: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
676: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
677: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
678: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
679: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
672: ,P_ASS_ATTRIBUTE26_O => per_asg_shd.g_old_rec.ass_attribute26
673: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
674: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
675: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
676: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
677: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
678: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
679: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
680: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
673: ,P_ASS_ATTRIBUTE27_O => per_asg_shd.g_old_rec.ass_attribute27
674: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
675: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
676: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
677: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
678: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
679: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
680: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
681: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
674: ,P_ASS_ATTRIBUTE28_O => per_asg_shd.g_old_rec.ass_attribute28
675: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
676: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
677: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
678: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
679: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
680: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
681: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
682: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
675: ,P_ASS_ATTRIBUTE29_O => per_asg_shd.g_old_rec.ass_attribute29
676: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
677: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
678: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
679: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
680: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
681: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
682: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
683: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
676: ,P_ASS_ATTRIBUTE3_O => per_asg_shd.g_old_rec.ass_attribute3
677: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
678: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
679: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
680: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
681: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
682: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
683: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
684: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
677: ,P_ASS_ATTRIBUTE30_O => per_asg_shd.g_old_rec.ass_attribute30
678: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
679: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
680: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
681: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
682: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
683: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
684: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
685: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
678: ,P_ASS_ATTRIBUTE4_O => per_asg_shd.g_old_rec.ass_attribute4
679: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
680: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
681: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
682: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
683: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
684: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
685: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
686: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
679: ,P_ASS_ATTRIBUTE5_O => per_asg_shd.g_old_rec.ass_attribute5
680: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
681: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
682: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
683: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
684: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
685: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
686: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
687: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
680: ,P_ASS_ATTRIBUTE6_O => per_asg_shd.g_old_rec.ass_attribute6
681: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
682: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
683: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
684: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
685: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
686: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
687: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
688: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
681: ,P_ASS_ATTRIBUTE7_O => per_asg_shd.g_old_rec.ass_attribute7
682: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
683: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
684: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
685: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
686: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
687: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
688: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
689: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
682: ,P_ASS_ATTRIBUTE8_O => per_asg_shd.g_old_rec.ass_attribute8
683: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
684: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
685: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
686: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
687: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
688: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
689: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
690: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
683: ,P_ASS_ATTRIBUTE9_O => per_asg_shd.g_old_rec.ass_attribute9
684: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
685: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
686: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
687: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
688: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
689: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
690: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
691: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
684: ,P_ASS_ATTRIBUTE_CATEGORY_O => per_asg_shd.g_old_rec.ass_attribute_category
685: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
686: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
687: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
688: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
689: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
690: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
691: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
692: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
685: ,P_BARGAINING_UNIT_CODE_O => per_asg_shd.g_old_rec.bargaining_unit_code
686: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
687: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
688: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
689: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
690: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
691: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
692: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
693: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end --fix for bug 5108658
686: ,P_BUSINESS_GROUP_ID_O => per_asg_shd.g_old_rec.business_group_id
687: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
688: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
689: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
690: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
691: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
692: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
693: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end --fix for bug 5108658
694: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
687: ,P_CAGR_GRADE_DEF_ID_O => per_asg_shd.g_old_rec.cagr_grade_def_id
688: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
689: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
690: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
691: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
692: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
693: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end --fix for bug 5108658
694: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
695: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
688: ,P_CAGR_ID_FLEX_NUM_O => per_asg_shd.g_old_rec.cagr_id_flex_num
689: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
690: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
691: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
692: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
693: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end --fix for bug 5108658
694: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
695: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
696: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
689: ,P_CHANGE_REASON_O => per_asg_shd.g_old_rec.change_reason
690: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
691: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
692: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
693: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end --fix for bug 5108658
694: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
695: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
696: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
697: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
690: ,P_COLLECTIVE_AGREEMENT_ID_O => per_asg_shd.g_old_rec.collective_agreement_id
691: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
692: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
693: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end --fix for bug 5108658
694: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
695: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
696: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
697: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
698: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
691: ,P_COMMENT_ID_O => per_asg_shd.g_old_rec.comment_id
692: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
693: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end --fix for bug 5108658
694: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
695: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
696: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
697: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
698: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
699: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
692: ,P_CONTRACT_ID_O => per_asg_shd.g_old_rec.contract_id
693: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end --fix for bug 5108658
694: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
695: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
696: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
697: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
698: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
699: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
700: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
693: ,P_DATE_PROBATION_END_O => per_asg_shd.g_old_rec.date_probation_end --fix for bug 5108658
694: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
695: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
696: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
697: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
698: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
699: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
700: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
701: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
694: ,P_DEFAULT_CODE_COMB_ID_O => per_asg_shd.g_old_rec.default_code_comb_id
695: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
696: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
697: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
698: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
699: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
700: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
701: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
702: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
695: ,P_EFFECTIVE_END_DATE_O => per_asg_shd.g_old_rec.effective_end_date
696: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
697: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
698: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
699: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
700: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
701: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
702: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
703: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
696: ,P_EFFECTIVE_START_DATE_O => per_asg_shd.g_old_rec.effective_start_date
697: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
698: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
699: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
700: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
701: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
702: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
703: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
704: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
697: ,P_EMPLOYEE_CATEGORY_O => per_asg_shd.g_old_rec.employee_category
698: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
699: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
700: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
701: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
702: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
703: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
704: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
705: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
698: ,P_EMPLOYMENT_CATEGORY_O => per_asg_shd.g_old_rec.employment_category
699: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
700: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
701: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
702: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
703: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
704: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
705: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
706: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
699: ,P_ESTABLISHMENT_ID_O => per_asg_shd.g_old_rec.establishment_id
700: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
701: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
702: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
703: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
704: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
705: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
706: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
707: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
700: ,P_FREQUENCY_O => per_asg_shd.g_old_rec.frequency
701: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
702: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
703: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
704: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
705: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
706: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
707: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
708: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
701: ,P_GRADE_ID_O => per_asg_shd.g_old_rec.grade_id
702: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
703: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
704: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
705: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
706: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
707: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
708: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
709: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
702: ,P_HOURLY_SALARIED_CODE_O => per_asg_shd.g_old_rec.hourly_salaried_code
703: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
704: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
705: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
706: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
707: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
708: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
709: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
710: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
703: ,P_INTERNAL_ADDRESS_LINE_O => per_asg_shd.g_old_rec.internal_address_line
704: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
705: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
706: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
707: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
708: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
709: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
710: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
711: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
704: ,P_JOB_ID_O => per_asg_shd.g_old_rec.job_id
705: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
706: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
707: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
708: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
709: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
710: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
711: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
712: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
705: ,P_JOB_POST_SOURCE_NAME_O => per_asg_shd.g_old_rec.job_post_source_name
706: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
707: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
708: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
709: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
710: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
711: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
712: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
713: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
706: ,P_LABOUR_UNION_MEMBER_FLAG_O => per_asg_shd.g_old_rec.labour_union_member_flag
707: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
708: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
709: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
710: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
711: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
712: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
713: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
714: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
707: ,P_LOCATION_ID_O => per_asg_shd.g_old_rec.location_id
708: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
709: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
710: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
711: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
712: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
713: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
714: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
715: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
708: ,P_MANAGER_FLAG_O => per_asg_shd.g_old_rec.manager_flag
709: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
710: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
711: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
712: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
713: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
714: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
715: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
716: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
709: ,P_NORMAL_HOURS_O => per_asg_shd.g_old_rec.normal_hours
710: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
711: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
712: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
713: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
714: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
715: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
716: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
717: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
710: ,P_NOTICE_PERIOD_O => per_asg_shd.g_old_rec.notice_period
711: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
712: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
713: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
714: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
715: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
716: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
717: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
718: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
711: ,P_NOTICE_PERIOD_UOM_O => per_asg_shd.g_old_rec.notice_period_uom
712: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
713: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
714: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
715: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
716: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
717: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
718: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
719: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
712: ,P_OBJECT_VERSION_NUMBER_O => per_asg_shd.g_old_rec.object_version_number
713: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
714: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
715: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
716: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
717: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
718: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
719: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
720: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
713: ,P_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.organization_id
714: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
715: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
716: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
717: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
718: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
719: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
720: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
721: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
714: ,P_PAYROLL_ID_O => per_asg_shd.g_old_rec.payroll_id
715: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
716: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
717: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
718: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
719: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
720: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
721: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
722: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
715: ,P_PAY_BASIS_ID_O => per_asg_shd.g_old_rec.pay_basis_id
716: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
717: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
718: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
719: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
720: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
721: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
722: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
723: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
716: ,P_PEOPLE_GROUP_ID_O => per_asg_shd.g_old_rec.people_group_id
717: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
718: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
719: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
720: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
721: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
722: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
723: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
724: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
717: ,P_PERF_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.perf_review_period
718: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
719: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
720: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
721: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
722: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
723: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
724: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
725: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
718: ,P_PERF_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.perf_review_period_frequency
719: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
720: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
721: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
722: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
723: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
724: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
725: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
726: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
719: ,P_PERIOD_OF_SERVICE_ID_O => per_asg_shd.g_old_rec.period_of_service_id
720: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
721: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
722: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
723: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
724: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
725: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
726: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
727: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
720: ,P_PERSON_ID_O => per_asg_shd.g_old_rec.person_id
721: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
722: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
723: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
724: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
725: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
726: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
727: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
728: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
721: ,P_PERSON_REFERRED_BY_ID_O => per_asg_shd.g_old_rec.person_referred_by_id
722: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
723: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
724: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
725: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
726: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
727: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
728: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
729: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
722: ,P_PLACEMENT_DATE_START_O => per_asg_shd.g_old_rec.period_of_placement_date_start
723: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
724: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
725: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
726: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
727: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
728: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
729: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
730: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
723: ,P_POSITION_ID_O => per_asg_shd.g_old_rec.position_id
724: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
725: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
726: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
727: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
728: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
729: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
730: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
731: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
724: ,P_POSTING_CONTENT_ID_O => per_asg_shd.g_old_rec.posting_content_id
725: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
726: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
727: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
728: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
729: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
730: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
731: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
732: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
725: ,P_PRIMARY_FLAG_O => per_asg_shd.g_old_rec.primary_flag
726: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
727: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
728: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
729: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
730: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
731: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
732: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
733: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
726: ,P_PROBATION_PERIOD_O => per_asg_shd.g_old_rec.probation_period
727: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
728: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
729: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
730: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
731: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
732: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
733: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
734: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
727: ,P_PROBATION_UNIT_O => per_asg_shd.g_old_rec.probation_unit
728: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
729: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
730: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
731: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
732: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
733: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
734: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
735: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
728: ,P_PROGRAM_APPLICATION_ID_O => per_asg_shd.g_old_rec.program_application_id
729: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
730: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
731: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
732: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
733: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
734: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
735: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
736: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
729: ,P_PROGRAM_ID_O => per_asg_shd.g_old_rec.program_id
730: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
731: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
732: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
733: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
734: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
735: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
736: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
737: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
730: ,P_PROGRAM_UPDATE_DATE_O => per_asg_shd.g_old_rec.program_update_date
731: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
732: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
733: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
734: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
735: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
736: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
737: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
738: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
731: ,P_PROJECT_TITLE_O => per_asg_shd.g_old_rec.project_title
732: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
733: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
734: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
735: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
736: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
737: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
738: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
739: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
732: ,P_RECRUITER_ID_O => per_asg_shd.g_old_rec.recruiter_id
733: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
734: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
735: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
736: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
737: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
738: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
739: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
740: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
733: ,P_RECRUITMENT_ACTIVITY_ID_O => per_asg_shd.g_old_rec.recruitment_activity_id
734: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
735: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
736: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
737: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
738: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
739: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
740: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
741: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
734: ,P_REQUEST_ID_O => per_asg_shd.g_old_rec.request_id
735: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
736: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
737: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
738: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
739: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
740: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
741: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
742: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
735: ,P_SAL_REVIEW_PERIOD_O => per_asg_shd.g_old_rec.sal_review_period
736: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
737: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
738: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
739: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
740: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
741: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
742: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
743: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
736: ,P_SAL_REVIEW_PERIOD_FREQUEN_O => per_asg_shd.g_old_rec.sal_review_period_frequency
737: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
738: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
739: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
740: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
741: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
742: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
743: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
744: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
737: ,P_SET_OF_BOOKS_ID_O => per_asg_shd.g_old_rec.set_of_books_id
738: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
739: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
740: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
741: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
742: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
743: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
744: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
745: ,P_TITLE_O => per_asg_shd.g_old_rec.title
738: ,P_SOFT_CODING_KEYFLEX_ID_O => per_asg_shd.g_old_rec.soft_coding_keyflex_id
739: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
740: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
741: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
742: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
743: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
744: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
745: ,P_TITLE_O => per_asg_shd.g_old_rec.title
746: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
739: ,P_SOURCE_ORGANIZATION_ID_O => per_asg_shd.g_old_rec.source_organization_id
740: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
741: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
742: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
743: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
744: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
745: ,P_TITLE_O => per_asg_shd.g_old_rec.title
746: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
747: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
740: ,P_SOURCE_TYPE_O => per_asg_shd.g_old_rec.source_type
741: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
742: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
743: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
744: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
745: ,P_TITLE_O => per_asg_shd.g_old_rec.title
746: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
747: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
748: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
741: ,P_SPECIAL_CEILING_STEP_ID_O => per_asg_shd.g_old_rec.special_ceiling_step_id
742: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
743: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
744: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
745: ,P_TITLE_O => per_asg_shd.g_old_rec.title
746: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
747: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
748: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
749: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
742: ,P_SUPERVISOR_ID_O => per_asg_shd.g_old_rec.supervisor_id
743: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
744: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
745: ,P_TITLE_O => per_asg_shd.g_old_rec.title
746: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
747: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
748: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
749: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
750: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
743: ,P_TIME_NORMAL_FINISH_O => per_asg_shd.g_old_rec.time_normal_finish
744: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
745: ,P_TITLE_O => per_asg_shd.g_old_rec.title
746: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
747: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
748: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
749: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
750: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
751: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
744: ,P_TIME_NORMAL_START_O => per_asg_shd.g_old_rec.time_normal_start
745: ,P_TITLE_O => per_asg_shd.g_old_rec.title
746: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
747: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
748: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
749: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
750: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
751: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
752: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
745: ,P_TITLE_O => per_asg_shd.g_old_rec.title
746: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
747: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
748: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
749: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
750: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
751: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
752: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
753: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
746: ,P_VACANCY_ID_O => per_asg_shd.g_old_rec.vacancy_id
747: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
748: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
749: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
750: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
751: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
752: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
753: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
754: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
747: ,P_VENDOR_ASSIGNMENT_NUMBER_O => per_asg_shd.g_old_rec.vendor_assignment_number
748: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
749: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
750: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
751: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
752: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
753: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
754: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
755: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
748: ,P_VENDOR_EMPLOYEE_NUMBER_O => per_asg_shd.g_old_rec.vendor_employee_number
749: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
750: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
751: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
752: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
753: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
754: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
755: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
756: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
749: ,P_VENDOR_ID_O => per_asg_shd.g_old_rec.vendor_id
750: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
751: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
752: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
753: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
754: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
755: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
756: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
757: );
750: ,P_WORK_AT_HOME_O => per_asg_shd.g_old_rec.work_at_home
751: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
752: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
753: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
754: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
755: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
756: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
757: );
758: -- Call to Workflow Sync Procedure For Assignments
751: ,P_GRADE_LADDER_PGM_ID_O => per_asg_shd.g_old_rec.grade_ladder_pgm_id
752: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
753: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
754: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
755: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
756: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
757: );
758: -- Call to Workflow Sync Procedure For Assignments
759: per_pqh_shr.per_asg_wf_sync('POST_DELETE',
752: ,P_SUPERVISOR_ASSIGNMENT_ID_O => per_asg_shd.g_old_rec.supervisor_assignment_id
753: ,P_VENDOR_SITE_ID_O => per_asg_shd.g_old_rec.vendor_site_id
754: ,P_PO_HEADER_ID_O => per_asg_shd.g_old_rec.po_header_id
755: ,P_PO_LINE_ID_O => per_asg_shd.g_old_rec.po_line_id
756: ,P_PROJECTED_ASSIGNMENT_END_O => per_asg_shd.g_old_rec.projected_assignment_end
757: );
758: -- Call to Workflow Sync Procedure For Assignments
759: per_pqh_shr.per_asg_wf_sync('POST_DELETE',
760: p_rec,
757: );
758: -- Call to Workflow Sync Procedure For Assignments
759: per_pqh_shr.per_asg_wf_sync('POST_DELETE',
760: p_rec,
761: per_asg_shd.g_old_rec.position_id,
762: p_effective_date,
763: p_validation_start_date,
764: p_validation_end_date,
765: p_datetrack_mode);
773: -- |---------------------------------< del >----------------------------------|
774: -- ----------------------------------------------------------------------------
775: Procedure del
776: (
777: p_rec in out nocopy per_asg_shd.g_rec_type,
778: p_effective_date in date,
779: p_effective_start_date OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE,
780: p_effective_end_date OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE,
781: -- p_validation_start_date out nocopy date,
837: End If;
838: --
839: -- We must lock the row which we need to delete.
840: --
841: per_asg_shd.lck
842: (p_effective_date => p_effective_date,
843: p_datetrack_mode => p_datetrack_mode,
844: p_assignment_id => p_rec.assignment_id,
845: p_object_version_number => p_rec.object_version_number,
983: ,p_cobra_coverage_elements OUT NOCOPY Boolean
984: ,p_assgt_term_elements OUT NOCOPY Boolean
985: ) is
986: --
987: l_rec per_asg_shd.g_rec_type;
988: l_proc varchar2(72) := g_package||'del';
989: --
990: Begin
991: hr_utility.set_location('Entering:'||l_proc, 5);
1027: -- 4888485
1028: p_object_version_number := l_rec.object_version_number;
1029: p_effective_start_date := l_rec.effective_start_date;
1030: p_effective_end_date := l_rec.effective_end_date;
1031: -- p_business_group_id := per_asg_shd.g_old_rec.business_group_id;
1032: --
1033: hr_utility.set_location(' Leaving:'||l_proc, 10);
1034: End del;
1035: --
1050: p_validate in boolean default false,
1051: p_org_now_no_manager_warning out nocopy boolean
1052: ) is
1053: --
1054: l_rec per_asg_shd.g_rec_type;
1055: l_proc varchar2(72) := g_package||'del';
1056: l_loc_change_tax_issues boolean;
1057: l_delete_asg_budgets boolean; -- addded the new loc vars -- 4888485
1058: l_element_salary_warning boolean;
1088: --
1089: p_validation_start_date := p_effective_start_date;
1090: p_validation_end_date := p_effective_end_date;
1091: --Added for 5012244
1092: p_business_group_id := per_asg_shd.g_old_rec.business_group_id;
1093: --
1094: hr_utility.set_location('Leaving'||l_proc, 25);
1095: End del;
1096: --