48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure dt_update_dml
52: (p_rec in out nocopy hr_psf_shd.g_rec_type,
53: p_effective_date in date,
54: p_datetrack_mode in varchar2,
55: p_validation_start_date in date,
56: p_validation_end_date in date) is
281: end if;
282: Exception
283: When hr_api.check_integrity_violated Then
284: -- A check constraint has been violated
285: hr_psf_shd.constraint_error
286: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
287: When hr_api.unique_integrity_violated Then
288: -- Unique integrity has been violated
289: hr_psf_shd.constraint_error
285: hr_psf_shd.constraint_error
286: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
287: When hr_api.unique_integrity_violated Then
288: -- Unique integrity has been violated
289: hr_psf_shd.constraint_error
290: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
291: When Others Then
292: Raise;
293: End dt_update_dml;
323: --
324: -- {End Of Comments}
325: -- ----------------------------------------------------------------------------
326: Procedure update_dml
327: (p_rec in out nocopy hr_psf_shd.g_rec_type,
328: p_effective_date in date,
329: p_datetrack_mode in varchar2,
330: p_validation_start_date in date,
331: p_validation_end_date in date) is
393: --
394: -- {End Of Comments}
395: -- ----------------------------------------------------------------------------
396: Procedure dt_pre_update
397: (p_rec in out nocopy hr_psf_shd.g_rec_type,
398: p_effective_date in date,
399: p_datetrack_mode in varchar2,
400: p_validation_start_date in date,
401: p_validation_end_date in date) is
414: end if;
415: --
416: -- Update the current effective end date
417: --
418: hr_psf_shd.upd_effective_end_date
419: (p_effective_date => p_effective_date,
420: p_base_key_value => p_rec.position_id,
421: p_new_effective_end_date => (p_validation_start_date - 1),
422: p_validation_start_date => p_validation_start_date,
457: -- because many validations are dependent on date_effective and when date_effective
458: -- is going to be changed then validation should happen later only.
459: --
460: procedure update_date_effective
461: (p_rec in out nocopy hr_psf_shd.g_rec_type
462: ,p_datetrack_mode in varchar2
463: ,p_effective_date in date
464: ,p_validation_start_date in out nocopy date
465: ,p_validation_end_date in date)
504: select effective_start_date
505: from hr_All_positions_f pos
506: where position_id = p_rec.position_id
507: and effective_start_date > p_effective_date
508: and hr_psf_shd.get_availability_status(pos.availability_status_id
509: ,p_rec.business_group_id ) = 'ACTIVE'
510: order by effective_start_date ;
511: -- cursor to update the current row in database as effective start date is not passed to api
512: cursor current_row (p_effective_start_date date) is
526: if g_debug then
527: l_proc := g_package||'update_date_effective' ;
528: hr_utility.set_location('entering'||l_proc,5);
529: end if;
530: if p_rec.date_effective <> hr_psf_shd.g_old_rec.date_effective then
531: -- user has changed date effective in this record
532: if g_debug then
533: hr_utility.set_location('date effective has been changed'||l_proc,10);
534: end if;
537: hr_utility.set_location('datetrack mode correction '||l_proc,20);
538: end if;
539: hr_psf_bus.DE_Update_properties(
540: p_position_id => p_rec.position_id,
541: p_effective_Start_Date => hr_psf_shd.g_old_rec.effective_start_date,
542: p_updateable => l_updateable,
543: p_lower_limit => l_ll,
544: p_upper_limit => l_ul);
545: if l_updateable and p_rec.date_effective between l_ll and l_ul then
590: end if;
591: close pos_prev_row;
592:
593: -- current row effective_start_date is changed to date_effective
594: open current_row(hr_psf_shd.g_old_rec.effective_start_date);
595: fetch current_row into l_old_esd;
596: if l_old_esd is not null then
597: p_rec.effective_start_date := p_rec.date_effective;
598: update hr_all_positions_f
621: if g_debug then
622: hr_utility.set_location('user has not changed date effective'||l_proc,164);
623: end if;
624: end if;
625: if p_rec.availability_status_id <> hr_psf_shd.g_old_rec.availability_status_id then
626: -- user has changed availability_status_id in this record
627: if g_debug then
628: hr_utility.set_location('Avail_stat changed '||l_proc,60);
629: end if;
634: ,p_availability_status_id => p_rec.availability_status_id
635: ,p_effective_date => p_effective_date
636: ,p_date_effective => p_rec.date_effective
637: ,p_object_version_number => p_rec.object_version_number
638: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id
639: );
640: if g_debug then
641: hr_utility.set_location('after chk_avail_stat '||l_proc, 70);
642: end if;
639: );
640: if g_debug then
641: hr_utility.set_location('after chk_avail_stat '||l_proc, 70);
642: end if;
643: l_present_stat := hr_psf_shd.get_availability_status(p_rec.availability_status_id,
644: p_rec.business_group_id);
645: l_prev_stat := hr_psf_shd.get_availability_status(
646: hr_psf_shd.g_old_rec.availability_status_id,
647: p_rec.business_group_id);
641: hr_utility.set_location('after chk_avail_stat '||l_proc, 70);
642: end if;
643: l_present_stat := hr_psf_shd.get_availability_status(p_rec.availability_status_id,
644: p_rec.business_group_id);
645: l_prev_stat := hr_psf_shd.get_availability_status(
646: hr_psf_shd.g_old_rec.availability_status_id,
647: p_rec.business_group_id);
648: if (hr_psf_bus.all_proposed_only_position(p_rec.position_id))
649: and l_present_stat = 'ACTIVE' then
642: end if;
643: l_present_stat := hr_psf_shd.get_availability_status(p_rec.availability_status_id,
644: p_rec.business_group_id);
645: l_prev_stat := hr_psf_shd.get_availability_status(
646: hr_psf_shd.g_old_rec.availability_status_id,
647: p_rec.business_group_id);
648: if (hr_psf_bus.all_proposed_only_position(p_rec.position_id))
649: and l_present_stat = 'ACTIVE' then
650: if g_debug then
672: hr_utility.set_message(800,'PER_DE_EQ_ED_UPD');
673: hr_utility.raise_error;
674: end if;
675: end if;
676: elsif (hr_psf_bus.first_active_position_row(p_rec.position_id,hr_psf_shd.g_old_rec.effective_start_date)) then
677: -- find out the ESD of next active row and make that as Date_effective and the same
678: -- is to be done for all the records of that position
679: if g_debug then
680: hr_utility.set_location('first_active_position'||l_proc, 80);
680: hr_utility.set_location('first_active_position'||l_proc, 80);
681: end if;
682:
683: -- Bug Fix : 3381555
684: if (hr_psf_shd.get_availability_status(p_rec.availability_status_id
685: ,p_rec.business_group_id ) <> 'ELIMINATED' ) then
686: --
687: -- Proposed change is not for eliminate, then get the next active row's esd for the
688: -- given validation_start_date.
775: --
776: -- {End Of Comments}
777: -- ----------------------------------------------------------------------------
778: Procedure pre_update
779: (p_rec in out nocopy hr_psf_shd.g_rec_type,
780: p_effective_date in date,
781: p_datetrack_mode in varchar2,
782: p_validation_start_date in out nocopy date,
783: p_validation_end_date in out nocopy date) is
805: cursor pos_prev is
806: select effective_start_date,effective_end_date
807: from hr_all_positions_f
808: where position_id = p_rec.position_id and
809: effective_end_date = hr_psf_shd.g_old_rec.effective_start_date - 1
810: for update of effective_start_date,effective_end_date;
811:
812: -- cursor to fetch the first row
813: cursor pos_first(p_min_esd date) is
827: select count(*)
828: from hr_all_positions_f pos
829: where pos.position_id = p_position_id
830: and pos.effective_start_date < p_effective_start_date
831: and hr_psf_shd.get_availability_status(pos.availability_status_id
832: ,p_rec.business_group_id ) = 'ACTIVE';
833: Begin
834:
835: if g_debug then
855: if g_debug then
856: hr_utility.set_location('performing validation '||l_proc, 10);
857: end if;
858: /*
859: if p_rec.date_effective <> hr_psf_shd.g_old_rec.date_effective then
860: --
861: -- check the date_track mode, if it is not correction then
862: -- change in date_effective is not allowed
863: --
889:
890: l_proposed := hr_psf_bus.all_proposed_only_position(p_rec.position_id);
891:
892: if l_proposed = false then
893: l_current_row_stat := hr_psf_shd.get_availability_status(p_rec.availability_status_id
894: ,p_rec.business_group_id ) ;
895: if l_current_row_stat = 'ACTIVE' then
896: --
897: -- update effective start date of current row
898: --
899: update hr_all_positions_f
900: set effective_Start_date = p_rec.date_effective
901: where position_id = p_rec.position_id and
902: effective_start_date = hr_psf_shd.g_old_rec.effective_start_date;
903: if sql%rowcount = 0 then
904: hr_utility.set_message(800, 'HR_6153_ALL_PROCEDURE_FAIL');
905: hr_utility.set_message_token('PROCEDURE', l_proc);
906: hr_utility.set_message_token('STEP','5');
1002: --
1003: -- {End Of Comments}
1004: -- ----------------------------------------------------------------------------
1005: Procedure post_update
1006: (p_rec in hr_psf_shd.g_rec_type,
1007: p_effective_date in date,
1008: p_datetrack_mode in varchar2,
1009: p_validation_start_date in date,
1010: p_validation_end_date in date) is
1152: p_program_update_date => p_rec.program_update_date ,
1153: p_object_version_number => p_rec.object_version_number ,
1154: p_effective_date => p_effective_date ,
1155: p_datetrack_mode => p_datetrack_mode ,
1156: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
1157: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
1158: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
1159: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
1153: p_object_version_number => p_rec.object_version_number ,
1154: p_effective_date => p_effective_date ,
1155: p_datetrack_mode => p_datetrack_mode ,
1156: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
1157: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
1158: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
1159: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
1154: p_effective_date => p_effective_date ,
1155: p_datetrack_mode => p_datetrack_mode ,
1156: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
1157: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
1158: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
1159: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
1162: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
1155: p_datetrack_mode => p_datetrack_mode ,
1156: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
1157: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
1158: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
1159: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
1162: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
1163: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
1156: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,
1157: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
1158: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
1159: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
1162: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
1163: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
1157: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_date ,
1158: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
1159: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
1162: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
1163: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
1158: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_id ,
1159: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
1162: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
1163: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
1159: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_id ,
1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
1162: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
1163: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_id ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
1162: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
1163: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,
1162: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
1163: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
1162: p_job_id_o => hr_psf_shd.g_old_rec.job_id ,
1163: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
1163: p_location_id_o => hr_psf_shd.g_old_rec.location_id ,
1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_id ,
1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_id ,
1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_id ,
1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_id ,
1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_position_id ,
1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_position_id ,
1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,
1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_id ,
1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,
1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_id ,
1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,
1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_id ,
1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,
1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,
1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,
1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,
1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,
1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,
1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,
1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_date ,
1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,
1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,
1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_date,
1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,
1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,
1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,
1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,
1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_date ,
1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,
1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_date ,
1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,
1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,
1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,
1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,
1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,
1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,
1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,
1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,
1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,
1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,
1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,
1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,
1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,
1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,
1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,
1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,
1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,
1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,
1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,
1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,
1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_flag ,
1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,
1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,
1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,
1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,
1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,
1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,
1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,
1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,
1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_cd ,
1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,
1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,
1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_cd ,
1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,
1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,
1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,
1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,
1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_cd ,
1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,
1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,
1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,
1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,
1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,
1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,
1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,
1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,
1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,
1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,
1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,
1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,
1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,
1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,
1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,
1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,
1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,
1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,
1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,
1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,
1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,
1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,
1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,
1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,
1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,
1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,
1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,
1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,
1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,
1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,
1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,
1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,
1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,
1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,
1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,
1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,
1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,
1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,
1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,
1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,
1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,
1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,
1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,
1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,
1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,
1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,
1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,
1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,
1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,
1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,
1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,
1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,
1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,
1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,
1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,
1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,
1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,
1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,
1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,
1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,
1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
1282: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,
1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
1282: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
1283: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,
1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
1282: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
1283: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
1284: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,
1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
1282: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
1283: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
1284: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
1285: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,
1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
1282: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
1283: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
1284: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
1285: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
1286: --
1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,
1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
1282: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
1283: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
1284: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
1285: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
1286: --
1287: exception
1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,
1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
1282: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
1283: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
1284: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
1285: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
1286: --
1287: exception
1288: when hr_api.cannot_find_prog_unit then
1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,
1282: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,
1283: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,
1284: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,
1285: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );
1286: --
1287: exception
1288: when hr_api.cannot_find_prog_unit then
1289: hr_api.cannot_find_prog_unit_error
1291: ,p_hook_type => 'AU'
1292: );
1293: End;
1294: --
1295: --hr_psf_shd.position_wf_sync(p_rec.position_id , p_validation_start_date);
1296: hr_psf_shd.position_wf_sync(p_position_id => p_rec.position_id
1297: , p_effective_date => p_validation_start_date
1298: , p_action => 'UPDATE'
1299: , p_eff_start_date => p_rec.effective_start_date
1292: );
1293: End;
1294: --
1295: --hr_psf_shd.position_wf_sync(p_rec.position_id , p_validation_start_date);
1296: hr_psf_shd.position_wf_sync(p_position_id => p_rec.position_id
1297: , p_effective_date => p_validation_start_date
1298: , p_action => 'UPDATE'
1299: , p_eff_start_date => p_rec.effective_start_date
1300: , p_eff_end_date => p_rec.effective_end_date );
1347: -- Internal Row Handler Use Only.
1348: --
1349: -- {End Of Comments}
1350: -- ----------------------------------------------------------------------------
1351: Procedure convert_defs(p_rec in out nocopy hr_psf_shd.g_rec_type) is
1352: --
1353: l_proc varchar2(72) ;
1354: --
1355: Begin
1365: -- is being used then we must set to the 'current' argument value.
1366: --
1367: If (p_rec.availability_status_id = hr_api.g_number) then
1368: p_rec.availability_status_id :=
1369: hr_psf_shd.g_old_rec.availability_status_id;
1370: End If;
1371: If (p_rec.business_group_id = hr_api.g_number) then
1372: p_rec.business_group_id :=
1373: hr_psf_shd.g_old_rec.business_group_id;
1369: hr_psf_shd.g_old_rec.availability_status_id;
1370: End If;
1371: If (p_rec.business_group_id = hr_api.g_number) then
1372: p_rec.business_group_id :=
1373: hr_psf_shd.g_old_rec.business_group_id;
1374: End If;
1375: If (p_rec.entry_step_id = hr_api.g_number) then
1376: p_rec.entry_step_id :=
1377: hr_psf_shd.g_old_rec.entry_step_id;
1373: hr_psf_shd.g_old_rec.business_group_id;
1374: End If;
1375: If (p_rec.entry_step_id = hr_api.g_number) then
1376: p_rec.entry_step_id :=
1377: hr_psf_shd.g_old_rec.entry_step_id;
1378: End If;
1379: If (p_rec.entry_grade_rule_id = hr_api.g_number) then
1380: p_rec.entry_grade_rule_id :=
1381: hr_psf_shd.g_old_rec.entry_grade_rule_id;
1377: hr_psf_shd.g_old_rec.entry_step_id;
1378: End If;
1379: If (p_rec.entry_grade_rule_id = hr_api.g_number) then
1380: p_rec.entry_grade_rule_id :=
1381: hr_psf_shd.g_old_rec.entry_grade_rule_id;
1382: End If;
1383: If (p_rec.job_id = hr_api.g_number) then
1384: p_rec.job_id :=
1385: hr_psf_shd.g_old_rec.job_id;
1381: hr_psf_shd.g_old_rec.entry_grade_rule_id;
1382: End If;
1383: If (p_rec.job_id = hr_api.g_number) then
1384: p_rec.job_id :=
1385: hr_psf_shd.g_old_rec.job_id;
1386: End If;
1387: If (p_rec.location_id = hr_api.g_number) then
1388: p_rec.location_id :=
1389: hr_psf_shd.g_old_rec.location_id;
1385: hr_psf_shd.g_old_rec.job_id;
1386: End If;
1387: If (p_rec.location_id = hr_api.g_number) then
1388: p_rec.location_id :=
1389: hr_psf_shd.g_old_rec.location_id;
1390: End If;
1391: If (p_rec.organization_id = hr_api.g_number) then
1392: p_rec.organization_id :=
1393: hr_psf_shd.g_old_rec.organization_id;
1389: hr_psf_shd.g_old_rec.location_id;
1390: End If;
1391: If (p_rec.organization_id = hr_api.g_number) then
1392: p_rec.organization_id :=
1393: hr_psf_shd.g_old_rec.organization_id;
1394: End If;
1395: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then
1396: p_rec.pay_freq_payroll_id :=
1397: hr_psf_shd.g_old_rec.pay_freq_payroll_id;
1393: hr_psf_shd.g_old_rec.organization_id;
1394: End If;
1395: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then
1396: p_rec.pay_freq_payroll_id :=
1397: hr_psf_shd.g_old_rec.pay_freq_payroll_id;
1398: End If;
1399: If (p_rec.position_definition_id = hr_api.g_number) then
1400: p_rec.position_definition_id :=
1401: hr_psf_shd.g_old_rec.position_definition_id;
1397: hr_psf_shd.g_old_rec.pay_freq_payroll_id;
1398: End If;
1399: If (p_rec.position_definition_id = hr_api.g_number) then
1400: p_rec.position_definition_id :=
1401: hr_psf_shd.g_old_rec.position_definition_id;
1402: End If;
1403: If (p_rec.position_transaction_id = hr_api.g_number) then
1404: p_rec.position_transaction_id :=
1405: hr_psf_shd.g_old_rec.position_transaction_id;
1401: hr_psf_shd.g_old_rec.position_definition_id;
1402: End If;
1403: If (p_rec.position_transaction_id = hr_api.g_number) then
1404: p_rec.position_transaction_id :=
1405: hr_psf_shd.g_old_rec.position_transaction_id;
1406: End If;
1407: If (p_rec.prior_position_id = hr_api.g_number) then
1408: p_rec.prior_position_id :=
1409: hr_psf_shd.g_old_rec.prior_position_id;
1405: hr_psf_shd.g_old_rec.position_transaction_id;
1406: End If;
1407: If (p_rec.prior_position_id = hr_api.g_number) then
1408: p_rec.prior_position_id :=
1409: hr_psf_shd.g_old_rec.prior_position_id;
1410: End If;
1411: If (p_rec.relief_position_id = hr_api.g_number) then
1412: p_rec.relief_position_id :=
1413: hr_psf_shd.g_old_rec.relief_position_id;
1409: hr_psf_shd.g_old_rec.prior_position_id;
1410: End If;
1411: If (p_rec.relief_position_id = hr_api.g_number) then
1412: p_rec.relief_position_id :=
1413: hr_psf_shd.g_old_rec.relief_position_id;
1414: End If;
1415: If (p_rec.entry_grade_id = hr_api.g_number) then
1416: p_rec.entry_grade_id :=
1417: hr_psf_shd.g_old_rec.entry_grade_id;
1413: hr_psf_shd.g_old_rec.relief_position_id;
1414: End If;
1415: If (p_rec.entry_grade_id = hr_api.g_number) then
1416: p_rec.entry_grade_id :=
1417: hr_psf_shd.g_old_rec.entry_grade_id;
1418: End If;
1419: If (p_rec.successor_position_id = hr_api.g_number) then
1420: p_rec.successor_position_id :=
1421: hr_psf_shd.g_old_rec.successor_position_id;
1417: hr_psf_shd.g_old_rec.entry_grade_id;
1418: End If;
1419: If (p_rec.successor_position_id = hr_api.g_number) then
1420: p_rec.successor_position_id :=
1421: hr_psf_shd.g_old_rec.successor_position_id;
1422: End If;
1423: If (p_rec.supervisor_position_id = hr_api.g_number) then
1424: p_rec.supervisor_position_id :=
1425: hr_psf_shd.g_old_rec.supervisor_position_id;
1421: hr_psf_shd.g_old_rec.successor_position_id;
1422: End If;
1423: If (p_rec.supervisor_position_id = hr_api.g_number) then
1424: p_rec.supervisor_position_id :=
1425: hr_psf_shd.g_old_rec.supervisor_position_id;
1426: End If;
1427: If (p_rec.amendment_date = hr_api.g_date) then
1428: p_rec.amendment_date :=
1429: hr_psf_shd.g_old_rec.amendment_date;
1425: hr_psf_shd.g_old_rec.supervisor_position_id;
1426: End If;
1427: If (p_rec.amendment_date = hr_api.g_date) then
1428: p_rec.amendment_date :=
1429: hr_psf_shd.g_old_rec.amendment_date;
1430: End If;
1431: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then
1432: p_rec.amendment_recommendation :=
1433: hr_psf_shd.g_old_rec.amendment_recommendation;
1429: hr_psf_shd.g_old_rec.amendment_date;
1430: End If;
1431: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then
1432: p_rec.amendment_recommendation :=
1433: hr_psf_shd.g_old_rec.amendment_recommendation;
1434: End If;
1435: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then
1436: p_rec.amendment_ref_number :=
1437: hr_psf_shd.g_old_rec.amendment_ref_number;
1433: hr_psf_shd.g_old_rec.amendment_recommendation;
1434: End If;
1435: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then
1436: p_rec.amendment_ref_number :=
1437: hr_psf_shd.g_old_rec.amendment_ref_number;
1438: End If;
1439: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then
1440: p_rec.bargaining_unit_cd :=
1441: hr_psf_shd.g_old_rec.bargaining_unit_cd;
1437: hr_psf_shd.g_old_rec.amendment_ref_number;
1438: End If;
1439: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then
1440: p_rec.bargaining_unit_cd :=
1441: hr_psf_shd.g_old_rec.bargaining_unit_cd;
1442: End If;
1443: If (p_rec.comments = hr_api.g_varchar2) then
1444: p_rec.comments :=
1445: hr_psf_shd.g_old_rec.comments;
1441: hr_psf_shd.g_old_rec.bargaining_unit_cd;
1442: End If;
1443: If (p_rec.comments = hr_api.g_varchar2) then
1444: p_rec.comments :=
1445: hr_psf_shd.g_old_rec.comments;
1446: End If;
1447: If (p_rec.current_job_prop_end_date = hr_api.g_date) then
1448: p_rec.current_job_prop_end_date :=
1449: hr_psf_shd.g_old_rec.current_job_prop_end_date;
1445: hr_psf_shd.g_old_rec.comments;
1446: End If;
1447: If (p_rec.current_job_prop_end_date = hr_api.g_date) then
1448: p_rec.current_job_prop_end_date :=
1449: hr_psf_shd.g_old_rec.current_job_prop_end_date;
1450: End If;
1451: If (p_rec.current_org_prop_end_date = hr_api.g_date) then
1452: p_rec.current_org_prop_end_date :=
1453: hr_psf_shd.g_old_rec.current_org_prop_end_date;
1449: hr_psf_shd.g_old_rec.current_job_prop_end_date;
1450: End If;
1451: If (p_rec.current_org_prop_end_date = hr_api.g_date) then
1452: p_rec.current_org_prop_end_date :=
1453: hr_psf_shd.g_old_rec.current_org_prop_end_date;
1454: End If;
1455: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then
1456: p_rec.avail_status_prop_end_date :=
1457: hr_psf_shd.g_old_rec.avail_status_prop_end_date;
1453: hr_psf_shd.g_old_rec.current_org_prop_end_date;
1454: End If;
1455: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then
1456: p_rec.avail_status_prop_end_date :=
1457: hr_psf_shd.g_old_rec.avail_status_prop_end_date;
1458: End If;
1459: If (p_rec.date_effective = hr_api.g_date) then
1460: p_rec.date_effective :=
1461: hr_psf_shd.g_old_rec.date_effective;
1457: hr_psf_shd.g_old_rec.avail_status_prop_end_date;
1458: End If;
1459: If (p_rec.date_effective = hr_api.g_date) then
1460: p_rec.date_effective :=
1461: hr_psf_shd.g_old_rec.date_effective;
1462: End If;
1463: If (p_rec.date_end = hr_api.g_date) then
1464: p_rec.date_end :=
1465: hr_psf_shd.g_old_rec.date_end;
1461: hr_psf_shd.g_old_rec.date_effective;
1462: End If;
1463: If (p_rec.date_end = hr_api.g_date) then
1464: p_rec.date_end :=
1465: hr_psf_shd.g_old_rec.date_end;
1466: End If;
1467: If (p_rec.earliest_hire_date = hr_api.g_date) then
1468: p_rec.earliest_hire_date :=
1469: hr_psf_shd.g_old_rec.earliest_hire_date;
1465: hr_psf_shd.g_old_rec.date_end;
1466: End If;
1467: If (p_rec.earliest_hire_date = hr_api.g_date) then
1468: p_rec.earliest_hire_date :=
1469: hr_psf_shd.g_old_rec.earliest_hire_date;
1470: End If;
1471: If (p_rec.fill_by_date = hr_api.g_date) then
1472: p_rec.fill_by_date :=
1473: hr_psf_shd.g_old_rec.fill_by_date;
1469: hr_psf_shd.g_old_rec.earliest_hire_date;
1470: End If;
1471: If (p_rec.fill_by_date = hr_api.g_date) then
1472: p_rec.fill_by_date :=
1473: hr_psf_shd.g_old_rec.fill_by_date;
1474: End If;
1475: If (p_rec.frequency = hr_api.g_varchar2) then
1476: p_rec.frequency :=
1477: hr_psf_shd.g_old_rec.frequency;
1473: hr_psf_shd.g_old_rec.fill_by_date;
1474: End If;
1475: If (p_rec.frequency = hr_api.g_varchar2) then
1476: p_rec.frequency :=
1477: hr_psf_shd.g_old_rec.frequency;
1478: End If;
1479: If (p_rec.fte = hr_api.g_number) then
1480: p_rec.fte :=
1481: hr_psf_shd.g_old_rec.fte;
1477: hr_psf_shd.g_old_rec.frequency;
1478: End If;
1479: If (p_rec.fte = hr_api.g_number) then
1480: p_rec.fte :=
1481: hr_psf_shd.g_old_rec.fte;
1482: End If;
1483: If (p_rec.max_persons = hr_api.g_number) then
1484: p_rec.max_persons :=
1485: hr_psf_shd.g_old_rec.max_persons;
1481: hr_psf_shd.g_old_rec.fte;
1482: End If;
1483: If (p_rec.max_persons = hr_api.g_number) then
1484: p_rec.max_persons :=
1485: hr_psf_shd.g_old_rec.max_persons;
1486: End If;
1487: If (p_rec.name = hr_api.g_varchar2) then
1488: p_rec.name :=
1489: hr_psf_shd.g_old_rec.name;
1485: hr_psf_shd.g_old_rec.max_persons;
1486: End If;
1487: If (p_rec.name = hr_api.g_varchar2) then
1488: p_rec.name :=
1489: hr_psf_shd.g_old_rec.name;
1490: End If;
1491: If (p_rec.overlap_period = hr_api.g_number) then
1492: p_rec.overlap_period :=
1493: hr_psf_shd.g_old_rec.overlap_period;
1489: hr_psf_shd.g_old_rec.name;
1490: End If;
1491: If (p_rec.overlap_period = hr_api.g_number) then
1492: p_rec.overlap_period :=
1493: hr_psf_shd.g_old_rec.overlap_period;
1494: End If;
1495: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then
1496: p_rec.overlap_unit_cd :=
1497: hr_psf_shd.g_old_rec.overlap_unit_cd;
1493: hr_psf_shd.g_old_rec.overlap_period;
1494: End If;
1495: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then
1496: p_rec.overlap_unit_cd :=
1497: hr_psf_shd.g_old_rec.overlap_unit_cd;
1498: End If;
1499: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then
1500: p_rec.pay_term_end_day_cd :=
1501: hr_psf_shd.g_old_rec.pay_term_end_day_cd;
1497: hr_psf_shd.g_old_rec.overlap_unit_cd;
1498: End If;
1499: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then
1500: p_rec.pay_term_end_day_cd :=
1501: hr_psf_shd.g_old_rec.pay_term_end_day_cd;
1502: End If;
1503: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then
1504: p_rec.pay_term_end_month_cd :=
1505: hr_psf_shd.g_old_rec.pay_term_end_month_cd;
1501: hr_psf_shd.g_old_rec.pay_term_end_day_cd;
1502: End If;
1503: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then
1504: p_rec.pay_term_end_month_cd :=
1505: hr_psf_shd.g_old_rec.pay_term_end_month_cd;
1506: End If;
1507: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then
1508: p_rec.permanent_temporary_flag :=
1509: hr_psf_shd.g_old_rec.permanent_temporary_flag;
1505: hr_psf_shd.g_old_rec.pay_term_end_month_cd;
1506: End If;
1507: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then
1508: p_rec.permanent_temporary_flag :=
1509: hr_psf_shd.g_old_rec.permanent_temporary_flag;
1510: End If;
1511: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then
1512: p_rec.permit_recruitment_flag :=
1513: hr_psf_shd.g_old_rec.permit_recruitment_flag;
1509: hr_psf_shd.g_old_rec.permanent_temporary_flag;
1510: End If;
1511: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then
1512: p_rec.permit_recruitment_flag :=
1513: hr_psf_shd.g_old_rec.permit_recruitment_flag;
1514: End If;
1515: If (p_rec.position_type = hr_api.g_varchar2) then
1516: p_rec.position_type :=
1517: hr_psf_shd.g_old_rec.position_type;
1513: hr_psf_shd.g_old_rec.permit_recruitment_flag;
1514: End If;
1515: If (p_rec.position_type = hr_api.g_varchar2) then
1516: p_rec.position_type :=
1517: hr_psf_shd.g_old_rec.position_type;
1518: End If;
1519: If (p_rec.posting_description = hr_api.g_varchar2) then
1520: p_rec.posting_description :=
1521: hr_psf_shd.g_old_rec.posting_description;
1517: hr_psf_shd.g_old_rec.position_type;
1518: End If;
1519: If (p_rec.posting_description = hr_api.g_varchar2) then
1520: p_rec.posting_description :=
1521: hr_psf_shd.g_old_rec.posting_description;
1522: End If;
1523: If (p_rec.probation_period = hr_api.g_number) then
1524: p_rec.probation_period :=
1525: hr_psf_shd.g_old_rec.probation_period;
1521: hr_psf_shd.g_old_rec.posting_description;
1522: End If;
1523: If (p_rec.probation_period = hr_api.g_number) then
1524: p_rec.probation_period :=
1525: hr_psf_shd.g_old_rec.probation_period;
1526: End If;
1527: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then
1528: p_rec.probation_period_unit_cd :=
1529: hr_psf_shd.g_old_rec.probation_period_unit_cd;
1525: hr_psf_shd.g_old_rec.probation_period;
1526: End If;
1527: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then
1528: p_rec.probation_period_unit_cd :=
1529: hr_psf_shd.g_old_rec.probation_period_unit_cd;
1530: End If;
1531: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
1532: p_rec.replacement_required_flag :=
1533: hr_psf_shd.g_old_rec.replacement_required_flag;
1529: hr_psf_shd.g_old_rec.probation_period_unit_cd;
1530: End If;
1531: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
1532: p_rec.replacement_required_flag :=
1533: hr_psf_shd.g_old_rec.replacement_required_flag;
1534: End If;
1535: If (p_rec.review_flag = hr_api.g_varchar2) then
1536: p_rec.review_flag :=
1537: hr_psf_shd.g_old_rec.review_flag;
1533: hr_psf_shd.g_old_rec.replacement_required_flag;
1534: End If;
1535: If (p_rec.review_flag = hr_api.g_varchar2) then
1536: p_rec.review_flag :=
1537: hr_psf_shd.g_old_rec.review_flag;
1538: End If;
1539: If (p_rec.seasonal_flag = hr_api.g_varchar2) then
1540: p_rec.seasonal_flag :=
1541: hr_psf_shd.g_old_rec.seasonal_flag;
1537: hr_psf_shd.g_old_rec.review_flag;
1538: End If;
1539: If (p_rec.seasonal_flag = hr_api.g_varchar2) then
1540: p_rec.seasonal_flag :=
1541: hr_psf_shd.g_old_rec.seasonal_flag;
1542: End If;
1543: If (p_rec.security_requirements = hr_api.g_varchar2) then
1544: p_rec.security_requirements :=
1545: hr_psf_shd.g_old_rec.security_requirements;
1541: hr_psf_shd.g_old_rec.seasonal_flag;
1542: End If;
1543: If (p_rec.security_requirements = hr_api.g_varchar2) then
1544: p_rec.security_requirements :=
1545: hr_psf_shd.g_old_rec.security_requirements;
1546: End If;
1547: If (p_rec.status = hr_api.g_varchar2) then
1548: p_rec.status :=
1549: hr_psf_shd.g_old_rec.status;
1545: hr_psf_shd.g_old_rec.security_requirements;
1546: End If;
1547: If (p_rec.status = hr_api.g_varchar2) then
1548: p_rec.status :=
1549: hr_psf_shd.g_old_rec.status;
1550: End If;
1551: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then
1552: p_rec.term_start_day_cd :=
1553: hr_psf_shd.g_old_rec.term_start_day_cd;
1549: hr_psf_shd.g_old_rec.status;
1550: End If;
1551: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then
1552: p_rec.term_start_day_cd :=
1553: hr_psf_shd.g_old_rec.term_start_day_cd;
1554: End If;
1555: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then
1556: p_rec.term_start_month_cd :=
1557: hr_psf_shd.g_old_rec.term_start_month_cd;
1553: hr_psf_shd.g_old_rec.term_start_day_cd;
1554: End If;
1555: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then
1556: p_rec.term_start_month_cd :=
1557: hr_psf_shd.g_old_rec.term_start_month_cd;
1558: End If;
1559: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1560: p_rec.time_normal_finish :=
1561: hr_psf_shd.g_old_rec.time_normal_finish;
1557: hr_psf_shd.g_old_rec.term_start_month_cd;
1558: End If;
1559: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1560: p_rec.time_normal_finish :=
1561: hr_psf_shd.g_old_rec.time_normal_finish;
1562: End If;
1563: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1564: p_rec.time_normal_start :=
1565: hr_psf_shd.g_old_rec.time_normal_start;
1561: hr_psf_shd.g_old_rec.time_normal_finish;
1562: End If;
1563: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1564: p_rec.time_normal_start :=
1565: hr_psf_shd.g_old_rec.time_normal_start;
1566: End If;
1567: If (p_rec.update_source_cd = hr_api.g_varchar2) then
1568: p_rec.update_source_cd :=
1569: hr_psf_shd.g_old_rec.update_source_cd;
1565: hr_psf_shd.g_old_rec.time_normal_start;
1566: End If;
1567: If (p_rec.update_source_cd = hr_api.g_varchar2) then
1568: p_rec.update_source_cd :=
1569: hr_psf_shd.g_old_rec.update_source_cd;
1570: End If;
1571: If (p_rec.working_hours = hr_api.g_number) then
1572: p_rec.working_hours :=
1573: hr_psf_shd.g_old_rec.working_hours;
1569: hr_psf_shd.g_old_rec.update_source_cd;
1570: End If;
1571: If (p_rec.working_hours = hr_api.g_number) then
1572: p_rec.working_hours :=
1573: hr_psf_shd.g_old_rec.working_hours;
1574: End If;
1575: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then
1576: p_rec.works_council_approval_flag :=
1577: hr_psf_shd.g_old_rec.works_council_approval_flag;
1573: hr_psf_shd.g_old_rec.working_hours;
1574: End If;
1575: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then
1576: p_rec.works_council_approval_flag :=
1577: hr_psf_shd.g_old_rec.works_council_approval_flag;
1578: End If;
1579: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then
1580: p_rec.work_period_type_cd :=
1581: hr_psf_shd.g_old_rec.work_period_type_cd;
1577: hr_psf_shd.g_old_rec.works_council_approval_flag;
1578: End If;
1579: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then
1580: p_rec.work_period_type_cd :=
1581: hr_psf_shd.g_old_rec.work_period_type_cd;
1582: End If;
1583: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then
1584: p_rec.work_term_end_day_cd :=
1585: hr_psf_shd.g_old_rec.work_term_end_day_cd;
1581: hr_psf_shd.g_old_rec.work_period_type_cd;
1582: End If;
1583: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then
1584: p_rec.work_term_end_day_cd :=
1585: hr_psf_shd.g_old_rec.work_term_end_day_cd;
1586: End If;
1587: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then
1588: p_rec.work_term_end_month_cd :=
1589: hr_psf_shd.g_old_rec.work_term_end_month_cd;
1585: hr_psf_shd.g_old_rec.work_term_end_day_cd;
1586: End If;
1587: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then
1588: p_rec.work_term_end_month_cd :=
1589: hr_psf_shd.g_old_rec.work_term_end_month_cd;
1590: End If;
1591: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then
1592: p_rec.proposed_fte_for_layoff :=
1593: hr_psf_shd.g_old_rec.proposed_fte_for_layoff;
1589: hr_psf_shd.g_old_rec.work_term_end_month_cd;
1590: End If;
1591: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then
1592: p_rec.proposed_fte_for_layoff :=
1593: hr_psf_shd.g_old_rec.proposed_fte_for_layoff;
1594: End If;
1595: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then
1596: p_rec.proposed_date_for_layoff :=
1597: hr_psf_shd.g_old_rec.proposed_date_for_layoff;
1593: hr_psf_shd.g_old_rec.proposed_fte_for_layoff;
1594: End If;
1595: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then
1596: p_rec.proposed_date_for_layoff :=
1597: hr_psf_shd.g_old_rec.proposed_date_for_layoff;
1598: End If;
1599: If (p_rec.pay_basis_id = hr_api.g_number) then
1600: p_rec.pay_basis_id :=
1601: hr_psf_shd.g_old_rec.pay_basis_id;
1597: hr_psf_shd.g_old_rec.proposed_date_for_layoff;
1598: End If;
1599: If (p_rec.pay_basis_id = hr_api.g_number) then
1600: p_rec.pay_basis_id :=
1601: hr_psf_shd.g_old_rec.pay_basis_id;
1602: End If;
1603: If (p_rec.supervisor_id = hr_api.g_number) then
1604: p_rec.supervisor_id :=
1605: hr_psf_shd.g_old_rec.supervisor_id;
1601: hr_psf_shd.g_old_rec.pay_basis_id;
1602: End If;
1603: If (p_rec.supervisor_id = hr_api.g_number) then
1604: p_rec.supervisor_id :=
1605: hr_psf_shd.g_old_rec.supervisor_id;
1606: End If;
1607: If (p_rec.copied_to_old_table_flag = hr_api.g_varchar2) then
1608: p_rec.copied_to_old_table_flag :=
1609: hr_psf_shd.g_old_rec.copied_to_old_table_flag;
1605: hr_psf_shd.g_old_rec.supervisor_id;
1606: End If;
1607: If (p_rec.copied_to_old_table_flag = hr_api.g_varchar2) then
1608: p_rec.copied_to_old_table_flag :=
1609: hr_psf_shd.g_old_rec.copied_to_old_table_flag;
1610: End If;
1611: If (p_rec.information1 = hr_api.g_varchar2) then
1612: p_rec.information1 :=
1613: hr_psf_shd.g_old_rec.information1;
1609: hr_psf_shd.g_old_rec.copied_to_old_table_flag;
1610: End If;
1611: If (p_rec.information1 = hr_api.g_varchar2) then
1612: p_rec.information1 :=
1613: hr_psf_shd.g_old_rec.information1;
1614: End If;
1615: If (p_rec.information2 = hr_api.g_varchar2) then
1616: p_rec.information2 :=
1617: hr_psf_shd.g_old_rec.information2;
1613: hr_psf_shd.g_old_rec.information1;
1614: End If;
1615: If (p_rec.information2 = hr_api.g_varchar2) then
1616: p_rec.information2 :=
1617: hr_psf_shd.g_old_rec.information2;
1618: End If;
1619: If (p_rec.information3 = hr_api.g_varchar2) then
1620: p_rec.information3 :=
1621: hr_psf_shd.g_old_rec.information3;
1617: hr_psf_shd.g_old_rec.information2;
1618: End If;
1619: If (p_rec.information3 = hr_api.g_varchar2) then
1620: p_rec.information3 :=
1621: hr_psf_shd.g_old_rec.information3;
1622: End If;
1623: If (p_rec.information4 = hr_api.g_varchar2) then
1624: p_rec.information4 :=
1625: hr_psf_shd.g_old_rec.information4;
1621: hr_psf_shd.g_old_rec.information3;
1622: End If;
1623: If (p_rec.information4 = hr_api.g_varchar2) then
1624: p_rec.information4 :=
1625: hr_psf_shd.g_old_rec.information4;
1626: End If;
1627: If (p_rec.information5 = hr_api.g_varchar2) then
1628: p_rec.information5 :=
1629: hr_psf_shd.g_old_rec.information5;
1625: hr_psf_shd.g_old_rec.information4;
1626: End If;
1627: If (p_rec.information5 = hr_api.g_varchar2) then
1628: p_rec.information5 :=
1629: hr_psf_shd.g_old_rec.information5;
1630: End If;
1631: If (p_rec.information6 = hr_api.g_varchar2) then
1632: p_rec.information6 :=
1633: hr_psf_shd.g_old_rec.information6;
1629: hr_psf_shd.g_old_rec.information5;
1630: End If;
1631: If (p_rec.information6 = hr_api.g_varchar2) then
1632: p_rec.information6 :=
1633: hr_psf_shd.g_old_rec.information6;
1634: End If;
1635: If (p_rec.information7 = hr_api.g_varchar2) then
1636: p_rec.information7 :=
1637: hr_psf_shd.g_old_rec.information7;
1633: hr_psf_shd.g_old_rec.information6;
1634: End If;
1635: If (p_rec.information7 = hr_api.g_varchar2) then
1636: p_rec.information7 :=
1637: hr_psf_shd.g_old_rec.information7;
1638: End If;
1639: If (p_rec.information8 = hr_api.g_varchar2) then
1640: p_rec.information8 :=
1641: hr_psf_shd.g_old_rec.information8;
1637: hr_psf_shd.g_old_rec.information7;
1638: End If;
1639: If (p_rec.information8 = hr_api.g_varchar2) then
1640: p_rec.information8 :=
1641: hr_psf_shd.g_old_rec.information8;
1642: End If;
1643: If (p_rec.information9 = hr_api.g_varchar2) then
1644: p_rec.information9 :=
1645: hr_psf_shd.g_old_rec.information9;
1641: hr_psf_shd.g_old_rec.information8;
1642: End If;
1643: If (p_rec.information9 = hr_api.g_varchar2) then
1644: p_rec.information9 :=
1645: hr_psf_shd.g_old_rec.information9;
1646: End If;
1647: If (p_rec.information10 = hr_api.g_varchar2) then
1648: p_rec.information10 :=
1649: hr_psf_shd.g_old_rec.information10;
1645: hr_psf_shd.g_old_rec.information9;
1646: End If;
1647: If (p_rec.information10 = hr_api.g_varchar2) then
1648: p_rec.information10 :=
1649: hr_psf_shd.g_old_rec.information10;
1650: End If;
1651: If (p_rec.information11 = hr_api.g_varchar2) then
1652: p_rec.information11 :=
1653: hr_psf_shd.g_old_rec.information11;
1649: hr_psf_shd.g_old_rec.information10;
1650: End If;
1651: If (p_rec.information11 = hr_api.g_varchar2) then
1652: p_rec.information11 :=
1653: hr_psf_shd.g_old_rec.information11;
1654: End If;
1655: If (p_rec.information12 = hr_api.g_varchar2) then
1656: p_rec.information12 :=
1657: hr_psf_shd.g_old_rec.information12;
1653: hr_psf_shd.g_old_rec.information11;
1654: End If;
1655: If (p_rec.information12 = hr_api.g_varchar2) then
1656: p_rec.information12 :=
1657: hr_psf_shd.g_old_rec.information12;
1658: End If;
1659: If (p_rec.information13 = hr_api.g_varchar2) then
1660: p_rec.information13 :=
1661: hr_psf_shd.g_old_rec.information13;
1657: hr_psf_shd.g_old_rec.information12;
1658: End If;
1659: If (p_rec.information13 = hr_api.g_varchar2) then
1660: p_rec.information13 :=
1661: hr_psf_shd.g_old_rec.information13;
1662: End If;
1663: If (p_rec.information14 = hr_api.g_varchar2) then
1664: p_rec.information14 :=
1665: hr_psf_shd.g_old_rec.information14;
1661: hr_psf_shd.g_old_rec.information13;
1662: End If;
1663: If (p_rec.information14 = hr_api.g_varchar2) then
1664: p_rec.information14 :=
1665: hr_psf_shd.g_old_rec.information14;
1666: End If;
1667: If (p_rec.information15 = hr_api.g_varchar2) then
1668: p_rec.information15 :=
1669: hr_psf_shd.g_old_rec.information15;
1665: hr_psf_shd.g_old_rec.information14;
1666: End If;
1667: If (p_rec.information15 = hr_api.g_varchar2) then
1668: p_rec.information15 :=
1669: hr_psf_shd.g_old_rec.information15;
1670: End If;
1671: If (p_rec.information16 = hr_api.g_varchar2) then
1672: p_rec.information16 :=
1673: hr_psf_shd.g_old_rec.information16;
1669: hr_psf_shd.g_old_rec.information15;
1670: End If;
1671: If (p_rec.information16 = hr_api.g_varchar2) then
1672: p_rec.information16 :=
1673: hr_psf_shd.g_old_rec.information16;
1674: End If;
1675: If (p_rec.information17 = hr_api.g_varchar2) then
1676: p_rec.information17 :=
1677: hr_psf_shd.g_old_rec.information17;
1673: hr_psf_shd.g_old_rec.information16;
1674: End If;
1675: If (p_rec.information17 = hr_api.g_varchar2) then
1676: p_rec.information17 :=
1677: hr_psf_shd.g_old_rec.information17;
1678: End If;
1679: If (p_rec.information18 = hr_api.g_varchar2) then
1680: p_rec.information18 :=
1681: hr_psf_shd.g_old_rec.information18;
1677: hr_psf_shd.g_old_rec.information17;
1678: End If;
1679: If (p_rec.information18 = hr_api.g_varchar2) then
1680: p_rec.information18 :=
1681: hr_psf_shd.g_old_rec.information18;
1682: End If;
1683: If (p_rec.information19 = hr_api.g_varchar2) then
1684: p_rec.information19 :=
1685: hr_psf_shd.g_old_rec.information19;
1681: hr_psf_shd.g_old_rec.information18;
1682: End If;
1683: If (p_rec.information19 = hr_api.g_varchar2) then
1684: p_rec.information19 :=
1685: hr_psf_shd.g_old_rec.information19;
1686: End If;
1687: If (p_rec.information20 = hr_api.g_varchar2) then
1688: p_rec.information20 :=
1689: hr_psf_shd.g_old_rec.information20;
1685: hr_psf_shd.g_old_rec.information19;
1686: End If;
1687: If (p_rec.information20 = hr_api.g_varchar2) then
1688: p_rec.information20 :=
1689: hr_psf_shd.g_old_rec.information20;
1690: End If;
1691: If (p_rec.information21 = hr_api.g_varchar2) then
1692: p_rec.information21 :=
1693: hr_psf_shd.g_old_rec.information21;
1689: hr_psf_shd.g_old_rec.information20;
1690: End If;
1691: If (p_rec.information21 = hr_api.g_varchar2) then
1692: p_rec.information21 :=
1693: hr_psf_shd.g_old_rec.information21;
1694: End If;
1695: If (p_rec.information22 = hr_api.g_varchar2) then
1696: p_rec.information22 :=
1697: hr_psf_shd.g_old_rec.information22;
1693: hr_psf_shd.g_old_rec.information21;
1694: End If;
1695: If (p_rec.information22 = hr_api.g_varchar2) then
1696: p_rec.information22 :=
1697: hr_psf_shd.g_old_rec.information22;
1698: End If;
1699: If (p_rec.information23 = hr_api.g_varchar2) then
1700: p_rec.information23 :=
1701: hr_psf_shd.g_old_rec.information23;
1697: hr_psf_shd.g_old_rec.information22;
1698: End If;
1699: If (p_rec.information23 = hr_api.g_varchar2) then
1700: p_rec.information23 :=
1701: hr_psf_shd.g_old_rec.information23;
1702: End If;
1703: If (p_rec.information24 = hr_api.g_varchar2) then
1704: p_rec.information24 :=
1705: hr_psf_shd.g_old_rec.information24;
1701: hr_psf_shd.g_old_rec.information23;
1702: End If;
1703: If (p_rec.information24 = hr_api.g_varchar2) then
1704: p_rec.information24 :=
1705: hr_psf_shd.g_old_rec.information24;
1706: End If;
1707: If (p_rec.information25 = hr_api.g_varchar2) then
1708: p_rec.information25 :=
1709: hr_psf_shd.g_old_rec.information25;
1705: hr_psf_shd.g_old_rec.information24;
1706: End If;
1707: If (p_rec.information25 = hr_api.g_varchar2) then
1708: p_rec.information25 :=
1709: hr_psf_shd.g_old_rec.information25;
1710: End If;
1711: If (p_rec.information26 = hr_api.g_varchar2) then
1712: p_rec.information26 :=
1713: hr_psf_shd.g_old_rec.information26;
1709: hr_psf_shd.g_old_rec.information25;
1710: End If;
1711: If (p_rec.information26 = hr_api.g_varchar2) then
1712: p_rec.information26 :=
1713: hr_psf_shd.g_old_rec.information26;
1714: End If;
1715: If (p_rec.information27 = hr_api.g_varchar2) then
1716: p_rec.information27 :=
1717: hr_psf_shd.g_old_rec.information27;
1713: hr_psf_shd.g_old_rec.information26;
1714: End If;
1715: If (p_rec.information27 = hr_api.g_varchar2) then
1716: p_rec.information27 :=
1717: hr_psf_shd.g_old_rec.information27;
1718: End If;
1719: If (p_rec.information28 = hr_api.g_varchar2) then
1720: p_rec.information28 :=
1721: hr_psf_shd.g_old_rec.information28;
1717: hr_psf_shd.g_old_rec.information27;
1718: End If;
1719: If (p_rec.information28 = hr_api.g_varchar2) then
1720: p_rec.information28 :=
1721: hr_psf_shd.g_old_rec.information28;
1722: End If;
1723: If (p_rec.information29 = hr_api.g_varchar2) then
1724: p_rec.information29 :=
1725: hr_psf_shd.g_old_rec.information29;
1721: hr_psf_shd.g_old_rec.information28;
1722: End If;
1723: If (p_rec.information29 = hr_api.g_varchar2) then
1724: p_rec.information29 :=
1725: hr_psf_shd.g_old_rec.information29;
1726: End If;
1727: If (p_rec.information30 = hr_api.g_varchar2) then
1728: p_rec.information30 :=
1729: hr_psf_shd.g_old_rec.information30;
1725: hr_psf_shd.g_old_rec.information29;
1726: End If;
1727: If (p_rec.information30 = hr_api.g_varchar2) then
1728: p_rec.information30 :=
1729: hr_psf_shd.g_old_rec.information30;
1730: End If;
1731: If (p_rec.information_category = hr_api.g_varchar2) then
1732: p_rec.information_category :=
1733: hr_psf_shd.g_old_rec.information_category;
1729: hr_psf_shd.g_old_rec.information30;
1730: End If;
1731: If (p_rec.information_category = hr_api.g_varchar2) then
1732: p_rec.information_category :=
1733: hr_psf_shd.g_old_rec.information_category;
1734: End If;
1735: If (p_rec.attribute1 = hr_api.g_varchar2) then
1736: p_rec.attribute1 :=
1737: hr_psf_shd.g_old_rec.attribute1;
1733: hr_psf_shd.g_old_rec.information_category;
1734: End If;
1735: If (p_rec.attribute1 = hr_api.g_varchar2) then
1736: p_rec.attribute1 :=
1737: hr_psf_shd.g_old_rec.attribute1;
1738: End If;
1739: If (p_rec.attribute2 = hr_api.g_varchar2) then
1740: p_rec.attribute2 :=
1741: hr_psf_shd.g_old_rec.attribute2;
1737: hr_psf_shd.g_old_rec.attribute1;
1738: End If;
1739: If (p_rec.attribute2 = hr_api.g_varchar2) then
1740: p_rec.attribute2 :=
1741: hr_psf_shd.g_old_rec.attribute2;
1742: End If;
1743: If (p_rec.attribute3 = hr_api.g_varchar2) then
1744: p_rec.attribute3 :=
1745: hr_psf_shd.g_old_rec.attribute3;
1741: hr_psf_shd.g_old_rec.attribute2;
1742: End If;
1743: If (p_rec.attribute3 = hr_api.g_varchar2) then
1744: p_rec.attribute3 :=
1745: hr_psf_shd.g_old_rec.attribute3;
1746: End If;
1747: If (p_rec.attribute4 = hr_api.g_varchar2) then
1748: p_rec.attribute4 :=
1749: hr_psf_shd.g_old_rec.attribute4;
1745: hr_psf_shd.g_old_rec.attribute3;
1746: End If;
1747: If (p_rec.attribute4 = hr_api.g_varchar2) then
1748: p_rec.attribute4 :=
1749: hr_psf_shd.g_old_rec.attribute4;
1750: End If;
1751: If (p_rec.attribute5 = hr_api.g_varchar2) then
1752: p_rec.attribute5 :=
1753: hr_psf_shd.g_old_rec.attribute5;
1749: hr_psf_shd.g_old_rec.attribute4;
1750: End If;
1751: If (p_rec.attribute5 = hr_api.g_varchar2) then
1752: p_rec.attribute5 :=
1753: hr_psf_shd.g_old_rec.attribute5;
1754: End If;
1755: If (p_rec.attribute6 = hr_api.g_varchar2) then
1756: p_rec.attribute6 :=
1757: hr_psf_shd.g_old_rec.attribute6;
1753: hr_psf_shd.g_old_rec.attribute5;
1754: End If;
1755: If (p_rec.attribute6 = hr_api.g_varchar2) then
1756: p_rec.attribute6 :=
1757: hr_psf_shd.g_old_rec.attribute6;
1758: End If;
1759: If (p_rec.attribute7 = hr_api.g_varchar2) then
1760: p_rec.attribute7 :=
1761: hr_psf_shd.g_old_rec.attribute7;
1757: hr_psf_shd.g_old_rec.attribute6;
1758: End If;
1759: If (p_rec.attribute7 = hr_api.g_varchar2) then
1760: p_rec.attribute7 :=
1761: hr_psf_shd.g_old_rec.attribute7;
1762: End If;
1763: If (p_rec.attribute8 = hr_api.g_varchar2) then
1764: p_rec.attribute8 :=
1765: hr_psf_shd.g_old_rec.attribute8;
1761: hr_psf_shd.g_old_rec.attribute7;
1762: End If;
1763: If (p_rec.attribute8 = hr_api.g_varchar2) then
1764: p_rec.attribute8 :=
1765: hr_psf_shd.g_old_rec.attribute8;
1766: End If;
1767: If (p_rec.attribute9 = hr_api.g_varchar2) then
1768: p_rec.attribute9 :=
1769: hr_psf_shd.g_old_rec.attribute9;
1765: hr_psf_shd.g_old_rec.attribute8;
1766: End If;
1767: If (p_rec.attribute9 = hr_api.g_varchar2) then
1768: p_rec.attribute9 :=
1769: hr_psf_shd.g_old_rec.attribute9;
1770: End If;
1771: If (p_rec.attribute10 = hr_api.g_varchar2) then
1772: p_rec.attribute10 :=
1773: hr_psf_shd.g_old_rec.attribute10;
1769: hr_psf_shd.g_old_rec.attribute9;
1770: End If;
1771: If (p_rec.attribute10 = hr_api.g_varchar2) then
1772: p_rec.attribute10 :=
1773: hr_psf_shd.g_old_rec.attribute10;
1774: End If;
1775: If (p_rec.attribute11 = hr_api.g_varchar2) then
1776: p_rec.attribute11 :=
1777: hr_psf_shd.g_old_rec.attribute11;
1773: hr_psf_shd.g_old_rec.attribute10;
1774: End If;
1775: If (p_rec.attribute11 = hr_api.g_varchar2) then
1776: p_rec.attribute11 :=
1777: hr_psf_shd.g_old_rec.attribute11;
1778: End If;
1779: If (p_rec.attribute12 = hr_api.g_varchar2) then
1780: p_rec.attribute12 :=
1781: hr_psf_shd.g_old_rec.attribute12;
1777: hr_psf_shd.g_old_rec.attribute11;
1778: End If;
1779: If (p_rec.attribute12 = hr_api.g_varchar2) then
1780: p_rec.attribute12 :=
1781: hr_psf_shd.g_old_rec.attribute12;
1782: End If;
1783: If (p_rec.attribute13 = hr_api.g_varchar2) then
1784: p_rec.attribute13 :=
1785: hr_psf_shd.g_old_rec.attribute13;
1781: hr_psf_shd.g_old_rec.attribute12;
1782: End If;
1783: If (p_rec.attribute13 = hr_api.g_varchar2) then
1784: p_rec.attribute13 :=
1785: hr_psf_shd.g_old_rec.attribute13;
1786: End If;
1787: If (p_rec.attribute14 = hr_api.g_varchar2) then
1788: p_rec.attribute14 :=
1789: hr_psf_shd.g_old_rec.attribute14;
1785: hr_psf_shd.g_old_rec.attribute13;
1786: End If;
1787: If (p_rec.attribute14 = hr_api.g_varchar2) then
1788: p_rec.attribute14 :=
1789: hr_psf_shd.g_old_rec.attribute14;
1790: End If;
1791: If (p_rec.attribute15 = hr_api.g_varchar2) then
1792: p_rec.attribute15 :=
1793: hr_psf_shd.g_old_rec.attribute15;
1789: hr_psf_shd.g_old_rec.attribute14;
1790: End If;
1791: If (p_rec.attribute15 = hr_api.g_varchar2) then
1792: p_rec.attribute15 :=
1793: hr_psf_shd.g_old_rec.attribute15;
1794: End If;
1795: If (p_rec.attribute16 = hr_api.g_varchar2) then
1796: p_rec.attribute16 :=
1797: hr_psf_shd.g_old_rec.attribute16;
1793: hr_psf_shd.g_old_rec.attribute15;
1794: End If;
1795: If (p_rec.attribute16 = hr_api.g_varchar2) then
1796: p_rec.attribute16 :=
1797: hr_psf_shd.g_old_rec.attribute16;
1798: End If;
1799: If (p_rec.attribute17 = hr_api.g_varchar2) then
1800: p_rec.attribute17 :=
1801: hr_psf_shd.g_old_rec.attribute17;
1797: hr_psf_shd.g_old_rec.attribute16;
1798: End If;
1799: If (p_rec.attribute17 = hr_api.g_varchar2) then
1800: p_rec.attribute17 :=
1801: hr_psf_shd.g_old_rec.attribute17;
1802: End If;
1803: If (p_rec.attribute18 = hr_api.g_varchar2) then
1804: p_rec.attribute18 :=
1805: hr_psf_shd.g_old_rec.attribute18;
1801: hr_psf_shd.g_old_rec.attribute17;
1802: End If;
1803: If (p_rec.attribute18 = hr_api.g_varchar2) then
1804: p_rec.attribute18 :=
1805: hr_psf_shd.g_old_rec.attribute18;
1806: End If;
1807: If (p_rec.attribute19 = hr_api.g_varchar2) then
1808: p_rec.attribute19 :=
1809: hr_psf_shd.g_old_rec.attribute19;
1805: hr_psf_shd.g_old_rec.attribute18;
1806: End If;
1807: If (p_rec.attribute19 = hr_api.g_varchar2) then
1808: p_rec.attribute19 :=
1809: hr_psf_shd.g_old_rec.attribute19;
1810: End If;
1811: If (p_rec.attribute20 = hr_api.g_varchar2) then
1812: p_rec.attribute20 :=
1813: hr_psf_shd.g_old_rec.attribute20;
1809: hr_psf_shd.g_old_rec.attribute19;
1810: End If;
1811: If (p_rec.attribute20 = hr_api.g_varchar2) then
1812: p_rec.attribute20 :=
1813: hr_psf_shd.g_old_rec.attribute20;
1814: End If;
1815: If (p_rec.attribute21 = hr_api.g_varchar2) then
1816: p_rec.attribute21 :=
1817: hr_psf_shd.g_old_rec.attribute21;
1813: hr_psf_shd.g_old_rec.attribute20;
1814: End If;
1815: If (p_rec.attribute21 = hr_api.g_varchar2) then
1816: p_rec.attribute21 :=
1817: hr_psf_shd.g_old_rec.attribute21;
1818: End If;
1819: If (p_rec.attribute22 = hr_api.g_varchar2) then
1820: p_rec.attribute22 :=
1821: hr_psf_shd.g_old_rec.attribute22;
1817: hr_psf_shd.g_old_rec.attribute21;
1818: End If;
1819: If (p_rec.attribute22 = hr_api.g_varchar2) then
1820: p_rec.attribute22 :=
1821: hr_psf_shd.g_old_rec.attribute22;
1822: End If;
1823: If (p_rec.attribute23 = hr_api.g_varchar2) then
1824: p_rec.attribute23 :=
1825: hr_psf_shd.g_old_rec.attribute23;
1821: hr_psf_shd.g_old_rec.attribute22;
1822: End If;
1823: If (p_rec.attribute23 = hr_api.g_varchar2) then
1824: p_rec.attribute23 :=
1825: hr_psf_shd.g_old_rec.attribute23;
1826: End If;
1827: If (p_rec.attribute24 = hr_api.g_varchar2) then
1828: p_rec.attribute24 :=
1829: hr_psf_shd.g_old_rec.attribute24;
1825: hr_psf_shd.g_old_rec.attribute23;
1826: End If;
1827: If (p_rec.attribute24 = hr_api.g_varchar2) then
1828: p_rec.attribute24 :=
1829: hr_psf_shd.g_old_rec.attribute24;
1830: End If;
1831: If (p_rec.attribute25 = hr_api.g_varchar2) then
1832: p_rec.attribute25 :=
1833: hr_psf_shd.g_old_rec.attribute25;
1829: hr_psf_shd.g_old_rec.attribute24;
1830: End If;
1831: If (p_rec.attribute25 = hr_api.g_varchar2) then
1832: p_rec.attribute25 :=
1833: hr_psf_shd.g_old_rec.attribute25;
1834: End If;
1835: If (p_rec.attribute26 = hr_api.g_varchar2) then
1836: p_rec.attribute26 :=
1837: hr_psf_shd.g_old_rec.attribute26;
1833: hr_psf_shd.g_old_rec.attribute25;
1834: End If;
1835: If (p_rec.attribute26 = hr_api.g_varchar2) then
1836: p_rec.attribute26 :=
1837: hr_psf_shd.g_old_rec.attribute26;
1838: End If;
1839: If (p_rec.attribute27 = hr_api.g_varchar2) then
1840: p_rec.attribute27 :=
1841: hr_psf_shd.g_old_rec.attribute27;
1837: hr_psf_shd.g_old_rec.attribute26;
1838: End If;
1839: If (p_rec.attribute27 = hr_api.g_varchar2) then
1840: p_rec.attribute27 :=
1841: hr_psf_shd.g_old_rec.attribute27;
1842: End If;
1843: If (p_rec.attribute28 = hr_api.g_varchar2) then
1844: p_rec.attribute28 :=
1845: hr_psf_shd.g_old_rec.attribute28;
1841: hr_psf_shd.g_old_rec.attribute27;
1842: End If;
1843: If (p_rec.attribute28 = hr_api.g_varchar2) then
1844: p_rec.attribute28 :=
1845: hr_psf_shd.g_old_rec.attribute28;
1846: End If;
1847: If (p_rec.attribute29 = hr_api.g_varchar2) then
1848: p_rec.attribute29 :=
1849: hr_psf_shd.g_old_rec.attribute29;
1845: hr_psf_shd.g_old_rec.attribute28;
1846: End If;
1847: If (p_rec.attribute29 = hr_api.g_varchar2) then
1848: p_rec.attribute29 :=
1849: hr_psf_shd.g_old_rec.attribute29;
1850: End If;
1851: If (p_rec.attribute30 = hr_api.g_varchar2) then
1852: p_rec.attribute30 :=
1853: hr_psf_shd.g_old_rec.attribute30;
1849: hr_psf_shd.g_old_rec.attribute29;
1850: End If;
1851: If (p_rec.attribute30 = hr_api.g_varchar2) then
1852: p_rec.attribute30 :=
1853: hr_psf_shd.g_old_rec.attribute30;
1854: End If;
1855: If (p_rec.attribute_category = hr_api.g_varchar2) then
1856: p_rec.attribute_category :=
1857: hr_psf_shd.g_old_rec.attribute_category;
1853: hr_psf_shd.g_old_rec.attribute30;
1854: End If;
1855: If (p_rec.attribute_category = hr_api.g_varchar2) then
1856: p_rec.attribute_category :=
1857: hr_psf_shd.g_old_rec.attribute_category;
1858: End If;
1859: If (p_rec.request_id = hr_api.g_number) then
1860: p_rec.request_id :=
1861: hr_psf_shd.g_old_rec.request_id;
1857: hr_psf_shd.g_old_rec.attribute_category;
1858: End If;
1859: If (p_rec.request_id = hr_api.g_number) then
1860: p_rec.request_id :=
1861: hr_psf_shd.g_old_rec.request_id;
1862: End If;
1863: If (p_rec.program_application_id = hr_api.g_number) then
1864: p_rec.program_application_id :=
1865: hr_psf_shd.g_old_rec.program_application_id;
1861: hr_psf_shd.g_old_rec.request_id;
1862: End If;
1863: If (p_rec.program_application_id = hr_api.g_number) then
1864: p_rec.program_application_id :=
1865: hr_psf_shd.g_old_rec.program_application_id;
1866: End If;
1867: If (p_rec.program_id = hr_api.g_number) then
1868: p_rec.program_id :=
1869: hr_psf_shd.g_old_rec.program_id;
1865: hr_psf_shd.g_old_rec.program_application_id;
1866: End If;
1867: If (p_rec.program_id = hr_api.g_number) then
1868: p_rec.program_id :=
1869: hr_psf_shd.g_old_rec.program_id;
1870: End If;
1871: If (p_rec.program_update_date = hr_api.g_date) then
1872: p_rec.program_update_date :=
1873: hr_psf_shd.g_old_rec.program_update_date;
1869: hr_psf_shd.g_old_rec.program_id;
1870: End If;
1871: If (p_rec.program_update_date = hr_api.g_date) then
1872: p_rec.program_update_date :=
1873: hr_psf_shd.g_old_rec.program_update_date;
1874: End If;
1875:
1876: --
1877: if g_debug then
1884: -- |---------------------------------< upd >----------------------------------|
1885: -- ----------------------------------------------------------------------------
1886: Procedure upd
1887: (
1888: p_rec in out nocopy hr_psf_shd.g_rec_type,
1889: p_effective_date in date,
1890: p_datetrack_mode in varchar2,
1891: p_validate in boolean default false
1892: ) is
1916: --
1917: --
1918: -- We must lock the row which we need to update.
1919: --
1920: hr_psf_shd.lck
1921: (p_effective_date => p_effective_date,
1922: p_datetrack_mode => p_datetrack_mode,
1923: p_position_id => p_rec.position_id,
1924: p_object_version_number => p_rec.object_version_number,
2176: p_datetrack_mode in varchar2,
2177: p_validate in boolean default false
2178: ) is
2179: --
2180: l_rec hr_psf_shd.g_rec_type;
2181: l_proc varchar2(72) ;
2182: --
2183: Begin
2184: if g_debug then
2190: -- Call conversion function to turn arguments into the
2191: -- l_rec structure.
2192: --
2193: l_rec :=
2194: hr_psf_shd.convert_args
2195: (
2196: p_position_id,
2197: null,
2198: null,