DBA Data[Home] [Help]

APPS.HR_PSF_UPD dependencies on HR_PSF_SHD

Line 52: (p_rec in out nocopy hr_psf_shd.g_rec_type,

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

Line 285: hr_psf_shd.constraint_error

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

Line 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;

Line 327: (p_rec in out nocopy hr_psf_shd.g_rec_type,

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

Line 397: (p_rec in out nocopy hr_psf_shd.g_rec_type,

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

Line 418: hr_psf_shd.upd_effective_end_date

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,

Line 461: (p_rec in out nocopy hr_psf_shd.g_rec_type

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)

Line 508: and hr_psf_shd.get_availability_status(pos.availability_status_id

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

Line 530: if p_rec.date_effective <> hr_psf_shd.g_old_rec.date_effective then

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;

Line 541: p_effective_Start_Date => hr_psf_shd.g_old_rec.effective_start_date,

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

Line 594: open current_row(hr_psf_shd.g_old_rec.effective_start_date);

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

Line 625: if p_rec.availability_status_id <> hr_psf_shd.g_old_rec.availability_status_id then

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;

Line 638: ,p_old_avail_status_id => hr_psf_shd.g_old_rec.availability_status_id

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;

Line 643: l_present_stat := hr_psf_shd.get_availability_status(p_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;
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);

Line 645: l_prev_stat := hr_psf_shd.get_availability_status(

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

Line 646: hr_psf_shd.g_old_rec.availability_status_id,

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

Line 676: elsif (hr_psf_bus.first_active_position_row(p_rec.position_id,hr_psf_shd.g_old_rec.effective_start_date)) 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);

Line 684: if (hr_psf_shd.get_availability_status(p_rec.availability_status_id

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.

Line 779: (p_rec in out nocopy hr_psf_shd.g_rec_type,

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

Line 809: effective_end_date = hr_psf_shd.g_old_rec.effective_start_date - 1

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

Line 831: and hr_psf_shd.get_availability_status(pos.availability_status_id

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

Line 859: if p_rec.date_effective <> hr_psf_shd.g_old_rec.date_effective 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: --

Line 893: l_current_row_stat := hr_psf_shd.get_availability_status(p_rec.availability_status_id

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

Line 902: effective_start_date = hr_psf_shd.g_old_rec.effective_start_date;

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');

Line 1006: (p_rec in hr_psf_shd.g_rec_type,

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

Line 1156: p_effective_start_date_o => hr_psf_shd.g_old_rec.effective_start_date ,

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 ,

Line 1157: p_effective_end_date_o => hr_psf_shd.g_old_rec.effective_end_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 ,
1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_id ,

Line 1158: p_availability_status_id_o => hr_psf_shd.g_old_rec.availability_status_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 ,

Line 1159: p_business_group_id_o => hr_psf_shd.g_old_rec.business_group_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 ,

Line 1160: p_entry_step_id_o => hr_psf_shd.g_old_rec.entry_step_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 ,

Line 1161: p_entry_grade_rule_id_o => hr_psf_shd.g_old_rec.entry_grade_rule_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 ,

Line 1162: p_job_id_o => hr_psf_shd.g_old_rec.job_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 ,

Line 1163: p_location_id_o => hr_psf_shd.g_old_rec.location_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 ,

Line 1164: p_organization_id_o => hr_psf_shd.g_old_rec.organization_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 ,

Line 1165: p_pay_freq_payroll_id_o => hr_psf_shd.g_old_rec.pay_freq_payroll_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 ,

Line 1166: p_position_definition_id_o => hr_psf_shd.g_old_rec.position_definition_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 ,

Line 1167: p_position_transaction_id_o => hr_psf_shd.g_old_rec.position_transaction_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 ,

Line 1168: p_prior_position_id_o => hr_psf_shd.g_old_rec.prior_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 ,

Line 1169: p_relief_position_id_o => hr_psf_shd.g_old_rec.relief_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 ,

Line 1170: p_entry_grade_id_o => hr_psf_shd.g_old_rec.entry_grade_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 ,
1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,

Line 1171: p_successor_position_id_o => hr_psf_shd.g_old_rec.successor_position_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 ,
1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,

Line 1172: p_supervisor_position_id_o => hr_psf_shd.g_old_rec.supervisor_position_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 ,
1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,

Line 1173: p_amendment_date_o => hr_psf_shd.g_old_rec.amendment_date ,

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 ,

Line 1174: p_amendment_recommendation_o => hr_psf_shd.g_old_rec.amendment_recommendation ,

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 ,

Line 1175: p_amendment_ref_number_o => hr_psf_shd.g_old_rec.amendment_ref_number ,

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 ,

Line 1176: p_bargaining_unit_cd_o => hr_psf_shd.g_old_rec.bargaining_unit_cd ,

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,

Line 1177: p_comments_o => hr_psf_shd.g_old_rec.comments ,

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 ,

Line 1178: p_current_job_prop_end_date_o => hr_psf_shd.g_old_rec.current_job_prop_end_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 ,
1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,

Line 1179: p_current_org_prop_end_date_o => hr_psf_shd.g_old_rec.current_org_prop_end_date ,

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 ,

Line 1180: p_avail_status_prop_end_date_o => hr_psf_shd.g_old_rec.avail_status_prop_end_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 ,

Line 1181: p_date_effective_o => hr_psf_shd.g_old_rec.date_effective ,

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 ,

Line 1182: p_date_end_o => hr_psf_shd.g_old_rec.date_end ,

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 ,

Line 1183: p_earliest_hire_date_o => hr_psf_shd.g_old_rec.earliest_hire_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 ,
1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,

Line 1184: p_fill_by_date_o => hr_psf_shd.g_old_rec.fill_by_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 ,
1188: p_name_o => hr_psf_shd.g_old_rec.name ,

Line 1185: p_frequency_o => hr_psf_shd.g_old_rec.frequency ,

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 ,

Line 1186: p_fte_o => hr_psf_shd.g_old_rec.fte ,

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 ,

Line 1187: p_max_persons_o => hr_psf_shd.g_old_rec.max_persons ,

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 ,

Line 1188: p_name_o => hr_psf_shd.g_old_rec.name ,

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 ,

Line 1189: p_overlap_period_o => hr_psf_shd.g_old_rec.overlap_period ,

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 ,

Line 1190: p_overlap_unit_cd_o => hr_psf_shd.g_old_rec.overlap_unit_cd ,

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 ,

Line 1191: p_pay_term_end_day_cd_o => hr_psf_shd.g_old_rec.pay_term_end_day_cd ,

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 ,

Line 1192: p_pay_term_end_month_cd_o => hr_psf_shd.g_old_rec.pay_term_end_month_cd ,

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 ,

Line 1193: p_permanent_temporary_flag_o => hr_psf_shd.g_old_rec.permanent_temporary_flag ,

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 ,

Line 1194: p_permit_recruitment_flag_o => hr_psf_shd.g_old_rec.permit_recruitment_flag ,

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 ,

Line 1195: p_position_type_o => hr_psf_shd.g_old_rec.position_type ,

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 ,

Line 1196: p_posting_description_o => hr_psf_shd.g_old_rec.posting_description ,

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 ,

Line 1197: p_probation_period_o => hr_psf_shd.g_old_rec.probation_period ,

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 ,

Line 1198: p_probation_period_unit_cd_o => hr_psf_shd.g_old_rec.probation_period_unit_cd ,

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 ,

Line 1199: p_replacement_required_flag_o => hr_psf_shd.g_old_rec.replacement_required_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 ,
1203: p_status_o => hr_psf_shd.g_old_rec.status ,

Line 1200: p_review_flag_o => hr_psf_shd.g_old_rec.review_flag ,

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 ,

Line 1201: p_seasonal_flag_o => hr_psf_shd.g_old_rec.seasonal_flag ,

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 ,

Line 1202: p_security_requirements_o => hr_psf_shd.g_old_rec.security_requirements ,

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 ,

Line 1203: p_status_o => hr_psf_shd.g_old_rec.status ,

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 ,

Line 1204: p_term_start_day_cd_o => hr_psf_shd.g_old_rec.term_start_day_cd ,

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 ,

Line 1205: p_term_start_month_cd_o => hr_psf_shd.g_old_rec.term_start_month_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 ,

Line 1206: p_time_normal_finish_o => hr_psf_shd.g_old_rec.time_normal_finish ,

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,

Line 1207: p_time_normal_start_o => hr_psf_shd.g_old_rec.time_normal_start ,

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 ,

Line 1208: p_update_source_cd_o => hr_psf_shd.g_old_rec.update_source_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 ,

Line 1209: p_working_hours_o => hr_psf_shd.g_old_rec.working_hours ,

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 ,

Line 1210: p_works_council_approval_fla_o => hr_psf_shd.g_old_rec.works_council_approval_flag,

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 ,

Line 1211: p_work_period_type_cd_o => hr_psf_shd.g_old_rec.work_period_type_cd ,

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 ,

Line 1212: p_work_term_end_day_cd_o => hr_psf_shd.g_old_rec.work_term_end_day_cd ,

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 ,

Line 1213: p_work_term_end_month_cd_o => hr_psf_shd.g_old_rec.work_term_end_month_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 ,
1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,

Line 1214: p_proposed_fte_for_layoff_o => hr_psf_shd.g_old_rec.proposed_fte_for_layoff ,

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 ,

Line 1215: p_proposed_date_for_layoff_o => hr_psf_shd.g_old_rec.proposed_date_for_layoff ,

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 ,

Line 1216: p_pay_basis_id_o => hr_psf_shd.g_old_rec.pay_basis_id ,

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 ,

Line 1217: p_supervisor_id_o => hr_psf_shd.g_old_rec.supervisor_id ,

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 ,

Line 1218: p_copied_to_old_table_flag_o => hr_psf_shd.g_old_rec.copied_to_old_table_flag ,

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 ,

Line 1219: p_information1_o => hr_psf_shd.g_old_rec.information1 ,

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 ,

Line 1220: p_information2_o => hr_psf_shd.g_old_rec.information2 ,

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 ,

Line 1221: p_information3_o => hr_psf_shd.g_old_rec.information3 ,

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 ,

Line 1222: p_information4_o => hr_psf_shd.g_old_rec.information4 ,

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 ,

Line 1223: p_information5_o => hr_psf_shd.g_old_rec.information5 ,

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 ,

Line 1224: p_information6_o => hr_psf_shd.g_old_rec.information6 ,

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 ,

Line 1225: p_information7_o => hr_psf_shd.g_old_rec.information7 ,

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 ,

Line 1226: p_information8_o => hr_psf_shd.g_old_rec.information8 ,

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 ,

Line 1227: p_information9_o => hr_psf_shd.g_old_rec.information9 ,

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 ,

Line 1228: p_information10_o => hr_psf_shd.g_old_rec.information10 ,

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 ,

Line 1229: p_information11_o => hr_psf_shd.g_old_rec.information11 ,

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 ,

Line 1230: p_information12_o => hr_psf_shd.g_old_rec.information12 ,

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 ,

Line 1231: p_information13_o => hr_psf_shd.g_old_rec.information13 ,

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 ,

Line 1232: p_information14_o => hr_psf_shd.g_old_rec.information14 ,

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 ,

Line 1233: p_information15_o => hr_psf_shd.g_old_rec.information15 ,

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 ,

Line 1234: p_information16_o => hr_psf_shd.g_old_rec.information16 ,

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 ,

Line 1235: p_information17_o => hr_psf_shd.g_old_rec.information17 ,

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 ,

Line 1236: p_information18_o => hr_psf_shd.g_old_rec.information18 ,

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 ,

Line 1237: p_information19_o => hr_psf_shd.g_old_rec.information19 ,

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 ,

Line 1238: p_information20_o => hr_psf_shd.g_old_rec.information20 ,

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 ,

Line 1239: p_information21_o => hr_psf_shd.g_old_rec.information21 ,

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 ,

Line 1240: p_information22_o => hr_psf_shd.g_old_rec.information22 ,

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 ,

Line 1241: p_information23_o => hr_psf_shd.g_old_rec.information23 ,

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 ,

Line 1242: p_information24_o => hr_psf_shd.g_old_rec.information24 ,

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 ,

Line 1243: p_information25_o => hr_psf_shd.g_old_rec.information25 ,

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 ,

Line 1244: p_information26_o => hr_psf_shd.g_old_rec.information26 ,

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 ,

Line 1245: p_information27_o => hr_psf_shd.g_old_rec.information27 ,

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 ,

Line 1246: p_information28_o => hr_psf_shd.g_old_rec.information28 ,

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 ,

Line 1247: p_information29_o => hr_psf_shd.g_old_rec.information29 ,

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 ,

Line 1248: p_information30_o => hr_psf_shd.g_old_rec.information30 ,

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 ,

Line 1249: p_information_category_o => hr_psf_shd.g_old_rec.information_category ,

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 ,

Line 1250: p_attribute1_o => hr_psf_shd.g_old_rec.attribute1 ,

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 ,

Line 1251: p_attribute2_o => hr_psf_shd.g_old_rec.attribute2 ,

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 ,

Line 1252: p_attribute3_o => hr_psf_shd.g_old_rec.attribute3 ,

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 ,

Line 1253: p_attribute4_o => hr_psf_shd.g_old_rec.attribute4 ,

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 ,

Line 1254: p_attribute5_o => hr_psf_shd.g_old_rec.attribute5 ,

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 ,

Line 1255: p_attribute6_o => hr_psf_shd.g_old_rec.attribute6 ,

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 ,

Line 1256: p_attribute7_o => hr_psf_shd.g_old_rec.attribute7 ,

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 ,

Line 1257: p_attribute8_o => hr_psf_shd.g_old_rec.attribute8 ,

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 ,

Line 1258: p_attribute9_o => hr_psf_shd.g_old_rec.attribute9 ,

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 ,

Line 1259: p_attribute10_o => hr_psf_shd.g_old_rec.attribute10 ,

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 ,

Line 1260: p_attribute11_o => hr_psf_shd.g_old_rec.attribute11 ,

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 ,

Line 1261: p_attribute12_o => hr_psf_shd.g_old_rec.attribute12 ,

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 ,

Line 1262: p_attribute13_o => hr_psf_shd.g_old_rec.attribute13 ,

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 ,

Line 1263: p_attribute14_o => hr_psf_shd.g_old_rec.attribute14 ,

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 ,

Line 1264: p_attribute15_o => hr_psf_shd.g_old_rec.attribute15 ,

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 ,

Line 1265: p_attribute16_o => hr_psf_shd.g_old_rec.attribute16 ,

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 ,

Line 1266: p_attribute17_o => hr_psf_shd.g_old_rec.attribute17 ,

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 ,

Line 1267: p_attribute18_o => hr_psf_shd.g_old_rec.attribute18 ,

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 ,

Line 1268: p_attribute19_o => hr_psf_shd.g_old_rec.attribute19 ,

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 ,

Line 1269: p_attribute20_o => hr_psf_shd.g_old_rec.attribute20 ,

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 ,

Line 1270: p_attribute21_o => hr_psf_shd.g_old_rec.attribute21 ,

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 ,

Line 1271: p_attribute22_o => hr_psf_shd.g_old_rec.attribute22 ,

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 ,

Line 1272: p_attribute23_o => hr_psf_shd.g_old_rec.attribute23 ,

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 ,

Line 1273: p_attribute24_o => hr_psf_shd.g_old_rec.attribute24 ,

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 ,

Line 1274: p_attribute25_o => hr_psf_shd.g_old_rec.attribute25 ,

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 ,

Line 1275: p_attribute26_o => hr_psf_shd.g_old_rec.attribute26 ,

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 ,

Line 1276: p_attribute27_o => hr_psf_shd.g_old_rec.attribute27 ,

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 ,

Line 1277: p_attribute28_o => hr_psf_shd.g_old_rec.attribute28 ,

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 ,

Line 1278: p_attribute29_o => hr_psf_shd.g_old_rec.attribute29 ,

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 ,

Line 1279: p_attribute30_o => hr_psf_shd.g_old_rec.attribute30 ,

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 ,

Line 1280: p_attribute_category_o => hr_psf_shd.g_old_rec.attribute_category ,

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 ,

Line 1281: p_request_id_o => hr_psf_shd.g_old_rec.request_id ,

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 );

Line 1282: p_program_application_id_o => hr_psf_shd.g_old_rec.program_application_id ,

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: --

Line 1283: p_program_id_o => hr_psf_shd.g_old_rec.program_id ,

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

Line 1284: p_program_update_date_o => hr_psf_shd.g_old_rec.program_update_date ,

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

Line 1285: p_object_version_number_o => hr_psf_shd.g_old_rec.object_version_number );

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

Line 1295: --hr_psf_shd.position_wf_sync(p_rec.position_id , p_validation_start_date);

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

Line 1296: hr_psf_shd.position_wf_sync(p_position_id => p_rec.position_id

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 );

Line 1351: Procedure convert_defs(p_rec in out nocopy hr_psf_shd.g_rec_type) is

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

Line 1369: hr_psf_shd.g_old_rec.availability_status_id;

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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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;

Line 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

Line 1888: p_rec in out nocopy hr_psf_shd.g_rec_type,

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

Line 1920: hr_psf_shd.lck

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,

Line 2180: l_rec hr_psf_shd.g_rec_type;

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

Line 2194: hr_psf_shd.convert_args

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,