44: --
45: -- {End Of Comments}
46: -- ----------------------------------------------------------------------------
47: Procedure dt_delete_dml
48: (p_rec in out nocopy hr_psf_shd.g_rec_type,
49: p_effective_date in date,
50: p_datetrack_mode in varchar2,
51: p_validation_start_date in date,
52: p_validation_end_date in date) is
96: -- ----------------------------------------------------------------------------
97: -- |------------------------------< delete_dml >------------------------------|
98: -- ----------------------------------------------------------------------------
99: Procedure delete_dml
100: (p_rec in out nocopy hr_psf_shd.g_rec_type,
101: p_effective_date in date,
102: p_datetrack_mode in varchar2,
103: p_validation_start_date in date,
104: p_validation_end_date in date) is
156: --
157: -- {End Of Comments}
158: -- ----------------------------------------------------------------------------
159: Procedure dt_pre_delete
160: (p_rec in out nocopy hr_psf_shd.g_rec_type,
161: p_effective_date in date,
162: p_datetrack_mode in varchar2,
163: p_validation_start_date in date,
164: p_validation_end_date in date) is
172: end if;
173: --
174: If (p_datetrack_mode <> 'ZAP') then
175: --
176: p_rec.effective_start_date := hr_psf_shd.g_old_rec.effective_start_date;
177: --
178: If (p_datetrack_mode = 'DELETE') then
179: p_rec.effective_end_date := p_validation_start_date - 1;
180: Else
182: End If;
183: --
184: -- Update the current effective end date record
185: --
186: hr_psf_shd.upd_effective_end_date
187: (p_effective_date => p_effective_date,
188: p_base_key_value => p_rec.position_id,
189: p_new_effective_end_date => p_rec.effective_end_date,
190: p_validation_start_date => p_validation_start_date,
542: --
543: -- {End Of Comments}
544: -- ----------------------------------------------------------------------------
545: Procedure pre_delete
546: (p_rec in out nocopy hr_psf_shd.g_rec_type,
547: p_effective_date in date,
548: p_datetrack_mode in varchar2,
549: p_validation_start_date in date,
550: p_validation_end_date in date) is
632: --
633: -- {End Of Comments}
634: -- ----------------------------------------------------------------------------
635: Procedure post_delete
636: (p_rec in hr_psf_shd.g_rec_type,
637: p_effective_date in date,
638: p_datetrack_mode in varchar2,
639: p_validation_start_date in date,
640: p_validation_end_date in date) is
653: Begin
654: hr_psf_rkd.after_delete(
655: p_position_id => p_rec.position_id ,
656: p_effective_date => p_effective_date ,
657: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
658: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
659: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
660: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
661: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
654: hr_psf_rkd.after_delete(
655: p_position_id => p_rec.position_id ,
656: p_effective_date => p_effective_date ,
657: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
658: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
659: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
660: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
661: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
662: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
655: p_position_id => p_rec.position_id ,
656: p_effective_date => p_effective_date ,
657: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
658: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
659: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
660: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
661: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
662: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
663: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
656: p_effective_date => p_effective_date ,
657: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
658: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
659: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
660: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
661: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
662: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
663: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
664: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
657: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
658: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
659: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
660: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
661: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
662: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
663: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
664: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
665: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
658: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
659: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
660: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
661: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
662: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
663: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
664: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
665: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
666: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
659: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
660: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
661: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
662: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
663: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
664: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
665: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
666: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
667: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
660: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
661: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
662: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
663: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
664: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
665: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
666: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
667: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
668: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
661: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
662: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
663: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
664: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
665: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
666: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
667: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
668: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
669: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
662: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
663: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
664: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
665: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
666: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
667: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
668: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
669: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
670: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
663: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
664: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
665: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
666: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
667: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
668: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
669: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
670: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
671: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
664: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
665: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
666: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
667: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
668: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
669: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
670: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
671: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
672: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
665: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
666: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
667: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
668: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
669: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
670: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
671: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
672: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
673: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
666: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
667: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
668: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
669: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
670: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
671: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
672: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
673: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
674: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
667: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
668: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
669: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
670: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
671: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
672: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
673: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
674: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
675: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
668: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
669: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
670: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
671: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
672: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
673: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
674: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
675: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
676: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
669: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
670: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
671: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
672: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
673: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
674: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
675: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
676: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
677: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
670: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
671: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
672: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
673: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
674: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
675: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
676: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
677: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
678: p_comments_o => hr_psf_shd.g_old_rec.comments ,
671: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
672: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
673: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
674: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
675: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
676: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
677: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
678: p_comments_o => hr_psf_shd.g_old_rec.comments ,
679: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
672: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
673: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
674: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
675: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
676: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
677: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
678: p_comments_o => hr_psf_shd.g_old_rec.comments ,
679: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
680: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
673: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
674: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
675: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
676: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
677: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
678: p_comments_o => hr_psf_shd.g_old_rec.comments ,
679: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
680: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
681: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
674: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
675: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
676: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
677: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
678: p_comments_o => hr_psf_shd.g_old_rec.comments ,
679: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
680: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
681: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
682: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
675: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
676: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
677: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
678: p_comments_o => hr_psf_shd.g_old_rec.comments ,
679: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
680: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
681: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
682: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
683: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
676: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
677: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
678: p_comments_o => hr_psf_shd.g_old_rec.comments ,
679: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
680: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
681: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
682: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
683: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
684: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
677: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
678: p_comments_o => hr_psf_shd.g_old_rec.comments ,
679: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
680: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
681: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
682: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
683: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
684: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
685: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
678: p_comments_o => hr_psf_shd.g_old_rec.comments ,
679: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
680: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
681: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
682: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
683: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
684: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
685: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
686: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
679: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
680: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
681: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
682: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
683: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
684: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
685: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
686: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
687: p_fte_o => hr_psf_shd.g_old_rec.fte ,
680: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
681: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
682: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
683: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
684: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
685: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
686: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
687: p_fte_o => hr_psf_shd.g_old_rec.fte ,
688: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
681: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
682: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
683: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
684: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
685: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
686: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
687: p_fte_o => hr_psf_shd.g_old_rec.fte ,
688: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
689: p_name_o => hr_psf_shd.g_old_rec.name ,
682: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
683: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
684: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
685: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
686: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
687: p_fte_o => hr_psf_shd.g_old_rec.fte ,
688: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
689: p_name_o => hr_psf_shd.g_old_rec.name ,
690: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
683: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
684: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
685: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
686: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
687: p_fte_o => hr_psf_shd.g_old_rec.fte ,
688: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
689: p_name_o => hr_psf_shd.g_old_rec.name ,
690: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
691: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
684: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
685: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
686: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
687: p_fte_o => hr_psf_shd.g_old_rec.fte ,
688: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
689: p_name_o => hr_psf_shd.g_old_rec.name ,
690: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
691: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
692: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
685: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
686: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
687: p_fte_o => hr_psf_shd.g_old_rec.fte ,
688: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
689: p_name_o => hr_psf_shd.g_old_rec.name ,
690: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
691: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
692: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
693: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
686: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
687: p_fte_o => hr_psf_shd.g_old_rec.fte ,
688: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
689: p_name_o => hr_psf_shd.g_old_rec.name ,
690: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
691: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
692: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
693: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
694: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
687: p_fte_o => hr_psf_shd.g_old_rec.fte ,
688: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
689: p_name_o => hr_psf_shd.g_old_rec.name ,
690: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
691: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
692: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
693: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
694: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
695: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
688: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
689: p_name_o => hr_psf_shd.g_old_rec.name ,
690: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
691: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
692: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
693: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
694: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
695: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
696: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
689: p_name_o => hr_psf_shd.g_old_rec.name ,
690: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
691: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
692: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
693: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
694: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
695: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
696: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
697: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
690: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
691: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
692: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
693: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
694: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
695: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
696: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
697: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
698: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
691: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
692: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
693: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
694: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
695: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
696: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
697: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
698: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
699: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
692: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
693: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
694: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
695: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
696: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
697: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
698: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
699: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
700: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
693: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
694: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
695: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
696: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
697: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
698: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
699: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
700: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
701: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
694: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
695: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
696: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
697: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
698: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
699: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
700: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
701: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
702: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
695: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
696: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
697: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
698: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
699: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
700: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
701: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
702: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
703: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
696: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
697: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
698: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
699: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
700: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
701: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
702: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
703: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
704: p_status_o => hr_psf_shd.g_old_rec.status ,
697: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
698: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
699: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
700: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
701: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
702: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
703: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
704: p_status_o => hr_psf_shd.g_old_rec.status ,
705: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
698: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
699: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
700: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
701: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
702: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
703: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
704: p_status_o => hr_psf_shd.g_old_rec.status ,
705: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
706: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
699: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
700: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
701: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
702: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
703: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
704: p_status_o => hr_psf_shd.g_old_rec.status ,
705: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
706: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
707: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
700: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
701: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
702: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
703: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
704: p_status_o => hr_psf_shd.g_old_rec.status ,
705: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
706: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
707: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
708: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
701: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
702: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
703: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
704: p_status_o => hr_psf_shd.g_old_rec.status ,
705: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
706: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
707: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
708: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
709: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
702: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
703: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
704: p_status_o => hr_psf_shd.g_old_rec.status ,
705: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
706: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
707: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
708: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
709: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
710: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
703: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
704: p_status_o => hr_psf_shd.g_old_rec.status ,
705: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
706: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
707: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
708: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
709: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
710: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
711: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
704: p_status_o => hr_psf_shd.g_old_rec.status ,
705: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
706: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
707: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
708: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
709: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
710: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
711: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
712: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
705: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
706: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
707: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
708: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
709: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
710: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
711: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
712: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
713: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
706: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
707: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
708: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
709: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
710: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
711: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
712: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
713: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
714: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
707: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
708: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
709: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
710: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
711: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
712: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
713: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
714: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
715: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
708: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
709: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
710: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
711: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
712: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
713: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
714: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
715: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
716: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
709: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
710: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
711: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
712: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
713: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
714: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
715: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
716: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
717: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
710: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
711: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
712: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
713: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
714: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
715: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
716: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
717: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
718: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
711: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
712: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
713: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
714: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
715: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
716: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
717: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
718: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
719: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
712: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
713: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
714: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
715: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
716: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
717: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
718: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
719: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
720: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
713: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
714: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
715: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
716: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
717: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
718: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
719: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
720: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
721: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
714: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
715: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
716: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
717: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
718: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
719: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
720: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
721: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
722: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
715: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
716: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
717: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
718: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
719: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
720: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
721: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
722: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
723: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
716: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
717: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
718: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
719: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
720: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
721: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
722: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
723: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
724: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
717: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
718: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
719: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
720: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
721: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
722: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
723: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
724: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
725: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
718: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
719: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
720: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
721: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
722: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
723: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
724: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
725: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
726: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
719: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
720: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
721: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
722: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
723: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
724: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
725: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
726: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
727: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
720: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
721: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
722: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
723: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
724: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
725: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
726: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
727: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
728: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
721: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
722: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
723: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
724: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
725: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
726: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
727: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
728: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
729: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
722: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
723: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
724: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
725: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
726: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
727: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
728: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
729: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
730: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
723: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
724: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
725: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
726: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
727: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
728: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
729: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
730: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
731: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
724: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
725: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
726: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
727: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
728: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
729: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
730: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
731: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
732: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
725: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
726: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
727: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
728: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
729: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
730: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
731: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
732: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
733: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
726: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
727: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
728: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
729: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
730: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
731: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
732: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
733: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
734: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
727: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
728: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
729: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
730: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
731: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
732: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
733: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
734: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
735: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
728: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
729: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
730: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
731: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
732: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
733: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
734: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
735: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
736: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
729: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
730: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
731: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
732: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
733: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
734: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
735: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
736: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
737: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
730: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
731: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
732: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
733: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
734: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
735: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
736: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
737: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
738: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
731: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
732: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
733: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
734: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
735: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
736: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
737: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
738: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
739: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
732: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
733: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
734: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
735: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
736: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
737: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
738: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
739: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
740: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
733: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
734: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
735: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
736: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
737: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
738: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
739: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
740: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
741: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
734: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
735: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
736: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
737: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
738: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
739: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
740: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
741: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
742: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
735: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
736: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
737: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
738: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
739: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
740: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
741: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
742: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
743: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
736: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
737: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
738: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
739: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
740: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
741: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
742: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
743: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
744: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
737: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
738: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
739: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
740: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
741: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
742: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
743: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
744: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
745: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
738: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
739: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
740: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
741: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
742: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
743: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
744: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
745: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
746: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
739: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
740: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
741: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
742: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
743: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
744: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
745: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
746: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
747: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
740: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
741: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
742: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
743: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
744: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
745: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
746: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
747: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
748: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
741: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
742: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
743: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
744: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
745: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
746: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
747: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
748: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
749: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
742: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
743: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
744: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
745: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
746: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
747: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
748: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
749: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
750: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
743: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
744: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
745: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
746: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
747: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
748: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
749: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
750: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
751: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
744: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
745: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
746: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
747: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
748: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
749: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
750: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
751: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
752: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
745: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
746: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
747: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
748: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
749: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
750: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
751: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
752: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
753: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
746: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
747: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
748: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
749: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
750: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
751: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
752: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
753: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
754: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
747: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
748: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
749: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
750: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
751: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
752: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
753: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
754: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
755: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
748: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
749: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
750: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
751: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
752: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
753: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
754: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
755: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
756: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
749: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
750: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
751: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
752: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
753: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
754: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
755: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
756: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
757: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
750: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
751: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
752: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
753: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
754: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
755: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
756: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
757: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
758: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
751: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
752: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
753: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
754: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
755: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
756: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
757: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
758: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
759: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
752: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
753: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
754: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
755: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
756: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
757: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
758: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
759: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
760: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
753: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
754: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
755: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
756: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
757: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
758: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
759: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
760: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
761: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
754: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
755: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
756: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
757: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
758: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
759: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
760: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
761: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
762: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
755: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
756: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
757: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
758: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
759: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
760: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
761: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
762: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
763: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
756: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
757: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
758: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
759: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
760: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
761: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
762: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
763: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
764: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
757: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
758: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
759: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
760: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
761: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
762: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
763: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
764: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
765: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
758: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
759: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
760: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
761: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
762: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
763: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
764: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
765: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
766: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
759: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
760: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
761: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
762: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
763: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
764: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
765: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
766: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
767: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
760: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
761: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
762: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
763: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
764: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
765: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
766: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
767: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
768: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
761: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
762: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
763: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
764: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
765: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
766: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
767: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
768: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
769: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
762: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
763: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
764: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
765: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
766: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
767: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
768: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
769: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
770: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
763: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
764: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
765: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
766: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
767: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
768: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
769: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
770: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
771: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
764: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
765: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
766: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
767: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
768: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
769: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
770: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
771: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
772: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
765: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
766: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
767: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
768: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
769: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
770: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
771: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
772: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
773: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
766: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
767: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
768: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
769: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
770: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
771: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
772: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
773: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
774: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
767: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
768: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
769: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
770: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
771: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
772: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
773: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
774: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
775: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
768: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
769: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
770: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
771: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
772: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
773: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
774: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
775: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
776: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
769: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
770: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
771: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
772: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
773: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
774: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
775: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
776: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
777: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
770: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
771: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
772: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
773: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
774: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
775: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
776: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
777: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
778: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
771: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
772: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
773: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
774: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
775: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
776: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
777: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
778: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
779: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
772: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
773: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
774: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
775: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
776: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
777: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
778: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
779: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
780: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
773: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
774: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
775: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
776: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
777: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
778: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
779: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
780: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
781: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
774: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
775: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
776: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
777: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
778: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
779: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
780: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
781: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
782: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
775: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
776: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
777: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
778: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
779: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
780: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
781: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
782: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
783: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
776: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
777: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
778: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
779: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
780: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
781: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
782: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
783: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
784: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
777: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
778: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
779: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
780: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
781: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
782: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
783: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
784: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
785: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
778: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
779: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
780: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
781: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
782: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
783: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
784: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
785: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
786: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
779: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
780: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
781: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
782: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
783: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
784: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
785: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
786: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
787: --
780: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
781: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
782: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
783: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
784: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
785: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
786: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
787: --
788: exception
781: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
782: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
783: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
784: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
785: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
786: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
787: --
788: exception
789: when hr_api.cannot_find_prog_unit then
782: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
783: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
784: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
785: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
786: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
787: --
788: exception
789: when hr_api.cannot_find_prog_unit then
790: hr_api.cannot_find_prog_unit_error
792: ,p_hook_type => 'AD'
793: );
794: end;
795: --
796: --hr_psf_shd.position_wf_sync(p_rec.position_id , p_validation_start_date);
797: hr_psf_shd.position_wf_sync(p_position_id => p_rec.position_id
798: , p_effective_date => p_validation_start_date
799: , p_action => 'DELETE'
800: , p_eff_start_date => p_rec.effective_start_date
793: );
794: end;
795: --
796: --hr_psf_shd.position_wf_sync(p_rec.position_id , p_validation_start_date);
797: hr_psf_shd.position_wf_sync(p_position_id => p_rec.position_id
798: , p_effective_date => p_validation_start_date
799: , p_action => 'DELETE'
800: , p_eff_start_date => p_rec.effective_start_date
801: , p_eff_end_date => p_rec.effective_end_date );
809: -- |---------------------------------< del >----------------------------------|
810: -- ----------------------------------------------------------------------------
811: Procedure del
812: (
813: p_rec in out nocopy hr_psf_shd.g_rec_type,
814: p_effective_date in date,
815: p_datetrack_mode in varchar2,
816: p_validate in boolean default false
817: ) is
847: --
848: SAVEPOINT del_per_per;
849: End If;
850: --
851: hr_psf_shd.lck
852: (p_effective_date => p_effective_date,
853: p_datetrack_mode => p_datetrack_mode,
854: p_position_id => p_rec.position_id,
855: p_object_version_number => p_rec.object_version_number,
933: p_validate in boolean default false,
934: p_security_profile_id in number default hr_security.get_security_profile
935: ) is
936: --
937: l_rec hr_psf_shd.g_rec_type;
938: l_proc varchar2(72);
939: --
940: Begin
941: g_debug := hr_utility.debug_enabled;