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: --
1297: if g_debug then
1298: hr_utility.set_location(' Leaving:'||l_proc, 10);
1299: end if;

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

1342: -- Internal Row Handler Use Only.
1343: --
1344: -- {End Of Comments}
1345: -- ----------------------------------------------------------------------------
1346: Procedure convert_defs(p_rec in out nocopy hr_psf_shd.g_rec_type) is
1347: --
1348: l_proc varchar2(72) ;
1349: --
1350: Begin

Line 1364: hr_psf_shd.g_old_rec.availability_status_id;

1360: -- is being used then we must set to the 'current' argument value.
1361: --
1362: If (p_rec.availability_status_id = hr_api.g_number) then
1363: p_rec.availability_status_id :=
1364: hr_psf_shd.g_old_rec.availability_status_id;
1365: End If;
1366: If (p_rec.business_group_id = hr_api.g_number) then
1367: p_rec.business_group_id :=
1368: hr_psf_shd.g_old_rec.business_group_id;

Line 1368: hr_psf_shd.g_old_rec.business_group_id;

1364: hr_psf_shd.g_old_rec.availability_status_id;
1365: End If;
1366: If (p_rec.business_group_id = hr_api.g_number) then
1367: p_rec.business_group_id :=
1368: hr_psf_shd.g_old_rec.business_group_id;
1369: End If;
1370: If (p_rec.entry_step_id = hr_api.g_number) then
1371: p_rec.entry_step_id :=
1372: hr_psf_shd.g_old_rec.entry_step_id;

Line 1372: hr_psf_shd.g_old_rec.entry_step_id;

1368: hr_psf_shd.g_old_rec.business_group_id;
1369: End If;
1370: If (p_rec.entry_step_id = hr_api.g_number) then
1371: p_rec.entry_step_id :=
1372: hr_psf_shd.g_old_rec.entry_step_id;
1373: End If;
1374: If (p_rec.entry_grade_rule_id = hr_api.g_number) then
1375: p_rec.entry_grade_rule_id :=
1376: hr_psf_shd.g_old_rec.entry_grade_rule_id;

Line 1376: hr_psf_shd.g_old_rec.entry_grade_rule_id;

1372: hr_psf_shd.g_old_rec.entry_step_id;
1373: End If;
1374: If (p_rec.entry_grade_rule_id = hr_api.g_number) then
1375: p_rec.entry_grade_rule_id :=
1376: hr_psf_shd.g_old_rec.entry_grade_rule_id;
1377: End If;
1378: If (p_rec.job_id = hr_api.g_number) then
1379: p_rec.job_id :=
1380: hr_psf_shd.g_old_rec.job_id;

Line 1380: hr_psf_shd.g_old_rec.job_id;

1376: hr_psf_shd.g_old_rec.entry_grade_rule_id;
1377: End If;
1378: If (p_rec.job_id = hr_api.g_number) then
1379: p_rec.job_id :=
1380: hr_psf_shd.g_old_rec.job_id;
1381: End If;
1382: If (p_rec.location_id = hr_api.g_number) then
1383: p_rec.location_id :=
1384: hr_psf_shd.g_old_rec.location_id;

Line 1384: hr_psf_shd.g_old_rec.location_id;

1380: hr_psf_shd.g_old_rec.job_id;
1381: End If;
1382: If (p_rec.location_id = hr_api.g_number) then
1383: p_rec.location_id :=
1384: hr_psf_shd.g_old_rec.location_id;
1385: End If;
1386: If (p_rec.organization_id = hr_api.g_number) then
1387: p_rec.organization_id :=
1388: hr_psf_shd.g_old_rec.organization_id;

Line 1388: hr_psf_shd.g_old_rec.organization_id;

1384: hr_psf_shd.g_old_rec.location_id;
1385: End If;
1386: If (p_rec.organization_id = hr_api.g_number) then
1387: p_rec.organization_id :=
1388: hr_psf_shd.g_old_rec.organization_id;
1389: End If;
1390: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then
1391: p_rec.pay_freq_payroll_id :=
1392: hr_psf_shd.g_old_rec.pay_freq_payroll_id;

Line 1392: hr_psf_shd.g_old_rec.pay_freq_payroll_id;

1388: hr_psf_shd.g_old_rec.organization_id;
1389: End If;
1390: If (p_rec.pay_freq_payroll_id = hr_api.g_number) then
1391: p_rec.pay_freq_payroll_id :=
1392: hr_psf_shd.g_old_rec.pay_freq_payroll_id;
1393: End If;
1394: If (p_rec.position_definition_id = hr_api.g_number) then
1395: p_rec.position_definition_id :=
1396: hr_psf_shd.g_old_rec.position_definition_id;

Line 1396: hr_psf_shd.g_old_rec.position_definition_id;

1392: hr_psf_shd.g_old_rec.pay_freq_payroll_id;
1393: End If;
1394: If (p_rec.position_definition_id = hr_api.g_number) then
1395: p_rec.position_definition_id :=
1396: hr_psf_shd.g_old_rec.position_definition_id;
1397: End If;
1398: If (p_rec.position_transaction_id = hr_api.g_number) then
1399: p_rec.position_transaction_id :=
1400: hr_psf_shd.g_old_rec.position_transaction_id;

Line 1400: hr_psf_shd.g_old_rec.position_transaction_id;

1396: hr_psf_shd.g_old_rec.position_definition_id;
1397: End If;
1398: If (p_rec.position_transaction_id = hr_api.g_number) then
1399: p_rec.position_transaction_id :=
1400: hr_psf_shd.g_old_rec.position_transaction_id;
1401: End If;
1402: If (p_rec.prior_position_id = hr_api.g_number) then
1403: p_rec.prior_position_id :=
1404: hr_psf_shd.g_old_rec.prior_position_id;

Line 1404: hr_psf_shd.g_old_rec.prior_position_id;

1400: hr_psf_shd.g_old_rec.position_transaction_id;
1401: End If;
1402: If (p_rec.prior_position_id = hr_api.g_number) then
1403: p_rec.prior_position_id :=
1404: hr_psf_shd.g_old_rec.prior_position_id;
1405: End If;
1406: If (p_rec.relief_position_id = hr_api.g_number) then
1407: p_rec.relief_position_id :=
1408: hr_psf_shd.g_old_rec.relief_position_id;

Line 1408: hr_psf_shd.g_old_rec.relief_position_id;

1404: hr_psf_shd.g_old_rec.prior_position_id;
1405: End If;
1406: If (p_rec.relief_position_id = hr_api.g_number) then
1407: p_rec.relief_position_id :=
1408: hr_psf_shd.g_old_rec.relief_position_id;
1409: End If;
1410: If (p_rec.entry_grade_id = hr_api.g_number) then
1411: p_rec.entry_grade_id :=
1412: hr_psf_shd.g_old_rec.entry_grade_id;

Line 1412: hr_psf_shd.g_old_rec.entry_grade_id;

1408: hr_psf_shd.g_old_rec.relief_position_id;
1409: End If;
1410: If (p_rec.entry_grade_id = hr_api.g_number) then
1411: p_rec.entry_grade_id :=
1412: hr_psf_shd.g_old_rec.entry_grade_id;
1413: End If;
1414: If (p_rec.successor_position_id = hr_api.g_number) then
1415: p_rec.successor_position_id :=
1416: hr_psf_shd.g_old_rec.successor_position_id;

Line 1416: hr_psf_shd.g_old_rec.successor_position_id;

1412: hr_psf_shd.g_old_rec.entry_grade_id;
1413: End If;
1414: If (p_rec.successor_position_id = hr_api.g_number) then
1415: p_rec.successor_position_id :=
1416: hr_psf_shd.g_old_rec.successor_position_id;
1417: End If;
1418: If (p_rec.supervisor_position_id = hr_api.g_number) then
1419: p_rec.supervisor_position_id :=
1420: hr_psf_shd.g_old_rec.supervisor_position_id;

Line 1420: hr_psf_shd.g_old_rec.supervisor_position_id;

1416: hr_psf_shd.g_old_rec.successor_position_id;
1417: End If;
1418: If (p_rec.supervisor_position_id = hr_api.g_number) then
1419: p_rec.supervisor_position_id :=
1420: hr_psf_shd.g_old_rec.supervisor_position_id;
1421: End If;
1422: If (p_rec.amendment_date = hr_api.g_date) then
1423: p_rec.amendment_date :=
1424: hr_psf_shd.g_old_rec.amendment_date;

Line 1424: hr_psf_shd.g_old_rec.amendment_date;

1420: hr_psf_shd.g_old_rec.supervisor_position_id;
1421: End If;
1422: If (p_rec.amendment_date = hr_api.g_date) then
1423: p_rec.amendment_date :=
1424: hr_psf_shd.g_old_rec.amendment_date;
1425: End If;
1426: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then
1427: p_rec.amendment_recommendation :=
1428: hr_psf_shd.g_old_rec.amendment_recommendation;

Line 1428: hr_psf_shd.g_old_rec.amendment_recommendation;

1424: hr_psf_shd.g_old_rec.amendment_date;
1425: End If;
1426: If (p_rec.amendment_recommendation = hr_api.g_varchar2) then
1427: p_rec.amendment_recommendation :=
1428: hr_psf_shd.g_old_rec.amendment_recommendation;
1429: End If;
1430: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then
1431: p_rec.amendment_ref_number :=
1432: hr_psf_shd.g_old_rec.amendment_ref_number;

Line 1432: hr_psf_shd.g_old_rec.amendment_ref_number;

1428: hr_psf_shd.g_old_rec.amendment_recommendation;
1429: End If;
1430: If (p_rec.amendment_ref_number = hr_api.g_varchar2) then
1431: p_rec.amendment_ref_number :=
1432: hr_psf_shd.g_old_rec.amendment_ref_number;
1433: End If;
1434: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then
1435: p_rec.bargaining_unit_cd :=
1436: hr_psf_shd.g_old_rec.bargaining_unit_cd;

Line 1436: hr_psf_shd.g_old_rec.bargaining_unit_cd;

1432: hr_psf_shd.g_old_rec.amendment_ref_number;
1433: End If;
1434: If (p_rec.bargaining_unit_cd = hr_api.g_varchar2) then
1435: p_rec.bargaining_unit_cd :=
1436: hr_psf_shd.g_old_rec.bargaining_unit_cd;
1437: End If;
1438: If (p_rec.comments = hr_api.g_varchar2) then
1439: p_rec.comments :=
1440: hr_psf_shd.g_old_rec.comments;

Line 1440: hr_psf_shd.g_old_rec.comments;

1436: hr_psf_shd.g_old_rec.bargaining_unit_cd;
1437: End If;
1438: If (p_rec.comments = hr_api.g_varchar2) then
1439: p_rec.comments :=
1440: hr_psf_shd.g_old_rec.comments;
1441: End If;
1442: If (p_rec.current_job_prop_end_date = hr_api.g_date) then
1443: p_rec.current_job_prop_end_date :=
1444: hr_psf_shd.g_old_rec.current_job_prop_end_date;

Line 1444: hr_psf_shd.g_old_rec.current_job_prop_end_date;

1440: hr_psf_shd.g_old_rec.comments;
1441: End If;
1442: If (p_rec.current_job_prop_end_date = hr_api.g_date) then
1443: p_rec.current_job_prop_end_date :=
1444: hr_psf_shd.g_old_rec.current_job_prop_end_date;
1445: End If;
1446: If (p_rec.current_org_prop_end_date = hr_api.g_date) then
1447: p_rec.current_org_prop_end_date :=
1448: hr_psf_shd.g_old_rec.current_org_prop_end_date;

Line 1448: hr_psf_shd.g_old_rec.current_org_prop_end_date;

1444: hr_psf_shd.g_old_rec.current_job_prop_end_date;
1445: End If;
1446: If (p_rec.current_org_prop_end_date = hr_api.g_date) then
1447: p_rec.current_org_prop_end_date :=
1448: hr_psf_shd.g_old_rec.current_org_prop_end_date;
1449: End If;
1450: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then
1451: p_rec.avail_status_prop_end_date :=
1452: hr_psf_shd.g_old_rec.avail_status_prop_end_date;

Line 1452: hr_psf_shd.g_old_rec.avail_status_prop_end_date;

1448: hr_psf_shd.g_old_rec.current_org_prop_end_date;
1449: End If;
1450: If (p_rec.avail_status_prop_end_date = hr_api.g_date) then
1451: p_rec.avail_status_prop_end_date :=
1452: hr_psf_shd.g_old_rec.avail_status_prop_end_date;
1453: End If;
1454: If (p_rec.date_effective = hr_api.g_date) then
1455: p_rec.date_effective :=
1456: hr_psf_shd.g_old_rec.date_effective;

Line 1456: hr_psf_shd.g_old_rec.date_effective;

1452: hr_psf_shd.g_old_rec.avail_status_prop_end_date;
1453: End If;
1454: If (p_rec.date_effective = hr_api.g_date) then
1455: p_rec.date_effective :=
1456: hr_psf_shd.g_old_rec.date_effective;
1457: End If;
1458: If (p_rec.date_end = hr_api.g_date) then
1459: p_rec.date_end :=
1460: hr_psf_shd.g_old_rec.date_end;

Line 1460: hr_psf_shd.g_old_rec.date_end;

1456: hr_psf_shd.g_old_rec.date_effective;
1457: End If;
1458: If (p_rec.date_end = hr_api.g_date) then
1459: p_rec.date_end :=
1460: hr_psf_shd.g_old_rec.date_end;
1461: End If;
1462: If (p_rec.earliest_hire_date = hr_api.g_date) then
1463: p_rec.earliest_hire_date :=
1464: hr_psf_shd.g_old_rec.earliest_hire_date;

Line 1464: hr_psf_shd.g_old_rec.earliest_hire_date;

1460: hr_psf_shd.g_old_rec.date_end;
1461: End If;
1462: If (p_rec.earliest_hire_date = hr_api.g_date) then
1463: p_rec.earliest_hire_date :=
1464: hr_psf_shd.g_old_rec.earliest_hire_date;
1465: End If;
1466: If (p_rec.fill_by_date = hr_api.g_date) then
1467: p_rec.fill_by_date :=
1468: hr_psf_shd.g_old_rec.fill_by_date;

Line 1468: hr_psf_shd.g_old_rec.fill_by_date;

1464: hr_psf_shd.g_old_rec.earliest_hire_date;
1465: End If;
1466: If (p_rec.fill_by_date = hr_api.g_date) then
1467: p_rec.fill_by_date :=
1468: hr_psf_shd.g_old_rec.fill_by_date;
1469: End If;
1470: If (p_rec.frequency = hr_api.g_varchar2) then
1471: p_rec.frequency :=
1472: hr_psf_shd.g_old_rec.frequency;

Line 1472: hr_psf_shd.g_old_rec.frequency;

1468: hr_psf_shd.g_old_rec.fill_by_date;
1469: End If;
1470: If (p_rec.frequency = hr_api.g_varchar2) then
1471: p_rec.frequency :=
1472: hr_psf_shd.g_old_rec.frequency;
1473: End If;
1474: If (p_rec.fte = hr_api.g_number) then
1475: p_rec.fte :=
1476: hr_psf_shd.g_old_rec.fte;

Line 1476: hr_psf_shd.g_old_rec.fte;

1472: hr_psf_shd.g_old_rec.frequency;
1473: End If;
1474: If (p_rec.fte = hr_api.g_number) then
1475: p_rec.fte :=
1476: hr_psf_shd.g_old_rec.fte;
1477: End If;
1478: If (p_rec.max_persons = hr_api.g_number) then
1479: p_rec.max_persons :=
1480: hr_psf_shd.g_old_rec.max_persons;

Line 1480: hr_psf_shd.g_old_rec.max_persons;

1476: hr_psf_shd.g_old_rec.fte;
1477: End If;
1478: If (p_rec.max_persons = hr_api.g_number) then
1479: p_rec.max_persons :=
1480: hr_psf_shd.g_old_rec.max_persons;
1481: End If;
1482: If (p_rec.name = hr_api.g_varchar2) then
1483: p_rec.name :=
1484: hr_psf_shd.g_old_rec.name;

Line 1484: hr_psf_shd.g_old_rec.name;

1480: hr_psf_shd.g_old_rec.max_persons;
1481: End If;
1482: If (p_rec.name = hr_api.g_varchar2) then
1483: p_rec.name :=
1484: hr_psf_shd.g_old_rec.name;
1485: End If;
1486: If (p_rec.overlap_period = hr_api.g_number) then
1487: p_rec.overlap_period :=
1488: hr_psf_shd.g_old_rec.overlap_period;

Line 1488: hr_psf_shd.g_old_rec.overlap_period;

1484: hr_psf_shd.g_old_rec.name;
1485: End If;
1486: If (p_rec.overlap_period = hr_api.g_number) then
1487: p_rec.overlap_period :=
1488: hr_psf_shd.g_old_rec.overlap_period;
1489: End If;
1490: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then
1491: p_rec.overlap_unit_cd :=
1492: hr_psf_shd.g_old_rec.overlap_unit_cd;

Line 1492: hr_psf_shd.g_old_rec.overlap_unit_cd;

1488: hr_psf_shd.g_old_rec.overlap_period;
1489: End If;
1490: If (p_rec.overlap_unit_cd = hr_api.g_varchar2) then
1491: p_rec.overlap_unit_cd :=
1492: hr_psf_shd.g_old_rec.overlap_unit_cd;
1493: End If;
1494: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then
1495: p_rec.pay_term_end_day_cd :=
1496: hr_psf_shd.g_old_rec.pay_term_end_day_cd;

Line 1496: hr_psf_shd.g_old_rec.pay_term_end_day_cd;

1492: hr_psf_shd.g_old_rec.overlap_unit_cd;
1493: End If;
1494: If (p_rec.pay_term_end_day_cd = hr_api.g_varchar2) then
1495: p_rec.pay_term_end_day_cd :=
1496: hr_psf_shd.g_old_rec.pay_term_end_day_cd;
1497: End If;
1498: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then
1499: p_rec.pay_term_end_month_cd :=
1500: hr_psf_shd.g_old_rec.pay_term_end_month_cd;

Line 1500: hr_psf_shd.g_old_rec.pay_term_end_month_cd;

1496: hr_psf_shd.g_old_rec.pay_term_end_day_cd;
1497: End If;
1498: If (p_rec.pay_term_end_month_cd = hr_api.g_varchar2) then
1499: p_rec.pay_term_end_month_cd :=
1500: hr_psf_shd.g_old_rec.pay_term_end_month_cd;
1501: End If;
1502: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then
1503: p_rec.permanent_temporary_flag :=
1504: hr_psf_shd.g_old_rec.permanent_temporary_flag;

Line 1504: hr_psf_shd.g_old_rec.permanent_temporary_flag;

1500: hr_psf_shd.g_old_rec.pay_term_end_month_cd;
1501: End If;
1502: If (p_rec.permanent_temporary_flag = hr_api.g_varchar2) then
1503: p_rec.permanent_temporary_flag :=
1504: hr_psf_shd.g_old_rec.permanent_temporary_flag;
1505: End If;
1506: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then
1507: p_rec.permit_recruitment_flag :=
1508: hr_psf_shd.g_old_rec.permit_recruitment_flag;

Line 1508: hr_psf_shd.g_old_rec.permit_recruitment_flag;

1504: hr_psf_shd.g_old_rec.permanent_temporary_flag;
1505: End If;
1506: If (p_rec.permit_recruitment_flag = hr_api.g_varchar2) then
1507: p_rec.permit_recruitment_flag :=
1508: hr_psf_shd.g_old_rec.permit_recruitment_flag;
1509: End If;
1510: If (p_rec.position_type = hr_api.g_varchar2) then
1511: p_rec.position_type :=
1512: hr_psf_shd.g_old_rec.position_type;

Line 1512: hr_psf_shd.g_old_rec.position_type;

1508: hr_psf_shd.g_old_rec.permit_recruitment_flag;
1509: End If;
1510: If (p_rec.position_type = hr_api.g_varchar2) then
1511: p_rec.position_type :=
1512: hr_psf_shd.g_old_rec.position_type;
1513: End If;
1514: If (p_rec.posting_description = hr_api.g_varchar2) then
1515: p_rec.posting_description :=
1516: hr_psf_shd.g_old_rec.posting_description;

Line 1516: hr_psf_shd.g_old_rec.posting_description;

1512: hr_psf_shd.g_old_rec.position_type;
1513: End If;
1514: If (p_rec.posting_description = hr_api.g_varchar2) then
1515: p_rec.posting_description :=
1516: hr_psf_shd.g_old_rec.posting_description;
1517: End If;
1518: If (p_rec.probation_period = hr_api.g_number) then
1519: p_rec.probation_period :=
1520: hr_psf_shd.g_old_rec.probation_period;

Line 1520: hr_psf_shd.g_old_rec.probation_period;

1516: hr_psf_shd.g_old_rec.posting_description;
1517: End If;
1518: If (p_rec.probation_period = hr_api.g_number) then
1519: p_rec.probation_period :=
1520: hr_psf_shd.g_old_rec.probation_period;
1521: End If;
1522: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then
1523: p_rec.probation_period_unit_cd :=
1524: hr_psf_shd.g_old_rec.probation_period_unit_cd;

Line 1524: hr_psf_shd.g_old_rec.probation_period_unit_cd;

1520: hr_psf_shd.g_old_rec.probation_period;
1521: End If;
1522: If (p_rec.probation_period_unit_cd = hr_api.g_varchar2) then
1523: p_rec.probation_period_unit_cd :=
1524: hr_psf_shd.g_old_rec.probation_period_unit_cd;
1525: End If;
1526: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
1527: p_rec.replacement_required_flag :=
1528: hr_psf_shd.g_old_rec.replacement_required_flag;

Line 1528: hr_psf_shd.g_old_rec.replacement_required_flag;

1524: hr_psf_shd.g_old_rec.probation_period_unit_cd;
1525: End If;
1526: If (p_rec.replacement_required_flag = hr_api.g_varchar2) then
1527: p_rec.replacement_required_flag :=
1528: hr_psf_shd.g_old_rec.replacement_required_flag;
1529: End If;
1530: If (p_rec.review_flag = hr_api.g_varchar2) then
1531: p_rec.review_flag :=
1532: hr_psf_shd.g_old_rec.review_flag;

Line 1532: hr_psf_shd.g_old_rec.review_flag;

1528: hr_psf_shd.g_old_rec.replacement_required_flag;
1529: End If;
1530: If (p_rec.review_flag = hr_api.g_varchar2) then
1531: p_rec.review_flag :=
1532: hr_psf_shd.g_old_rec.review_flag;
1533: End If;
1534: If (p_rec.seasonal_flag = hr_api.g_varchar2) then
1535: p_rec.seasonal_flag :=
1536: hr_psf_shd.g_old_rec.seasonal_flag;

Line 1536: hr_psf_shd.g_old_rec.seasonal_flag;

1532: hr_psf_shd.g_old_rec.review_flag;
1533: End If;
1534: If (p_rec.seasonal_flag = hr_api.g_varchar2) then
1535: p_rec.seasonal_flag :=
1536: hr_psf_shd.g_old_rec.seasonal_flag;
1537: End If;
1538: If (p_rec.security_requirements = hr_api.g_varchar2) then
1539: p_rec.security_requirements :=
1540: hr_psf_shd.g_old_rec.security_requirements;

Line 1540: hr_psf_shd.g_old_rec.security_requirements;

1536: hr_psf_shd.g_old_rec.seasonal_flag;
1537: End If;
1538: If (p_rec.security_requirements = hr_api.g_varchar2) then
1539: p_rec.security_requirements :=
1540: hr_psf_shd.g_old_rec.security_requirements;
1541: End If;
1542: If (p_rec.status = hr_api.g_varchar2) then
1543: p_rec.status :=
1544: hr_psf_shd.g_old_rec.status;

Line 1544: hr_psf_shd.g_old_rec.status;

1540: hr_psf_shd.g_old_rec.security_requirements;
1541: End If;
1542: If (p_rec.status = hr_api.g_varchar2) then
1543: p_rec.status :=
1544: hr_psf_shd.g_old_rec.status;
1545: End If;
1546: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then
1547: p_rec.term_start_day_cd :=
1548: hr_psf_shd.g_old_rec.term_start_day_cd;

Line 1548: hr_psf_shd.g_old_rec.term_start_day_cd;

1544: hr_psf_shd.g_old_rec.status;
1545: End If;
1546: If (p_rec.term_start_day_cd = hr_api.g_varchar2) then
1547: p_rec.term_start_day_cd :=
1548: hr_psf_shd.g_old_rec.term_start_day_cd;
1549: End If;
1550: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then
1551: p_rec.term_start_month_cd :=
1552: hr_psf_shd.g_old_rec.term_start_month_cd;

Line 1552: hr_psf_shd.g_old_rec.term_start_month_cd;

1548: hr_psf_shd.g_old_rec.term_start_day_cd;
1549: End If;
1550: If (p_rec.term_start_month_cd = hr_api.g_varchar2) then
1551: p_rec.term_start_month_cd :=
1552: hr_psf_shd.g_old_rec.term_start_month_cd;
1553: End If;
1554: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1555: p_rec.time_normal_finish :=
1556: hr_psf_shd.g_old_rec.time_normal_finish;

Line 1556: hr_psf_shd.g_old_rec.time_normal_finish;

1552: hr_psf_shd.g_old_rec.term_start_month_cd;
1553: End If;
1554: If (p_rec.time_normal_finish = hr_api.g_varchar2) then
1555: p_rec.time_normal_finish :=
1556: hr_psf_shd.g_old_rec.time_normal_finish;
1557: End If;
1558: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1559: p_rec.time_normal_start :=
1560: hr_psf_shd.g_old_rec.time_normal_start;

Line 1560: hr_psf_shd.g_old_rec.time_normal_start;

1556: hr_psf_shd.g_old_rec.time_normal_finish;
1557: End If;
1558: If (p_rec.time_normal_start = hr_api.g_varchar2) then
1559: p_rec.time_normal_start :=
1560: hr_psf_shd.g_old_rec.time_normal_start;
1561: End If;
1562: If (p_rec.update_source_cd = hr_api.g_varchar2) then
1563: p_rec.update_source_cd :=
1564: hr_psf_shd.g_old_rec.update_source_cd;

Line 1564: hr_psf_shd.g_old_rec.update_source_cd;

1560: hr_psf_shd.g_old_rec.time_normal_start;
1561: End If;
1562: If (p_rec.update_source_cd = hr_api.g_varchar2) then
1563: p_rec.update_source_cd :=
1564: hr_psf_shd.g_old_rec.update_source_cd;
1565: End If;
1566: If (p_rec.working_hours = hr_api.g_number) then
1567: p_rec.working_hours :=
1568: hr_psf_shd.g_old_rec.working_hours;

Line 1568: hr_psf_shd.g_old_rec.working_hours;

1564: hr_psf_shd.g_old_rec.update_source_cd;
1565: End If;
1566: If (p_rec.working_hours = hr_api.g_number) then
1567: p_rec.working_hours :=
1568: hr_psf_shd.g_old_rec.working_hours;
1569: End If;
1570: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then
1571: p_rec.works_council_approval_flag :=
1572: hr_psf_shd.g_old_rec.works_council_approval_flag;

Line 1572: hr_psf_shd.g_old_rec.works_council_approval_flag;

1568: hr_psf_shd.g_old_rec.working_hours;
1569: End If;
1570: If (p_rec.works_council_approval_flag = hr_api.g_varchar2) then
1571: p_rec.works_council_approval_flag :=
1572: hr_psf_shd.g_old_rec.works_council_approval_flag;
1573: End If;
1574: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then
1575: p_rec.work_period_type_cd :=
1576: hr_psf_shd.g_old_rec.work_period_type_cd;

Line 1576: hr_psf_shd.g_old_rec.work_period_type_cd;

1572: hr_psf_shd.g_old_rec.works_council_approval_flag;
1573: End If;
1574: If (p_rec.work_period_type_cd = hr_api.g_varchar2) then
1575: p_rec.work_period_type_cd :=
1576: hr_psf_shd.g_old_rec.work_period_type_cd;
1577: End If;
1578: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then
1579: p_rec.work_term_end_day_cd :=
1580: hr_psf_shd.g_old_rec.work_term_end_day_cd;

Line 1580: hr_psf_shd.g_old_rec.work_term_end_day_cd;

1576: hr_psf_shd.g_old_rec.work_period_type_cd;
1577: End If;
1578: If (p_rec.work_term_end_day_cd = hr_api.g_varchar2) then
1579: p_rec.work_term_end_day_cd :=
1580: hr_psf_shd.g_old_rec.work_term_end_day_cd;
1581: End If;
1582: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then
1583: p_rec.work_term_end_month_cd :=
1584: hr_psf_shd.g_old_rec.work_term_end_month_cd;

Line 1584: hr_psf_shd.g_old_rec.work_term_end_month_cd;

1580: hr_psf_shd.g_old_rec.work_term_end_day_cd;
1581: End If;
1582: If (p_rec.work_term_end_month_cd = hr_api.g_varchar2) then
1583: p_rec.work_term_end_month_cd :=
1584: hr_psf_shd.g_old_rec.work_term_end_month_cd;
1585: End If;
1586: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then
1587: p_rec.proposed_fte_for_layoff :=
1588: hr_psf_shd.g_old_rec.proposed_fte_for_layoff;

Line 1588: hr_psf_shd.g_old_rec.proposed_fte_for_layoff;

1584: hr_psf_shd.g_old_rec.work_term_end_month_cd;
1585: End If;
1586: If (p_rec.proposed_fte_for_layoff = hr_api.g_number) then
1587: p_rec.proposed_fte_for_layoff :=
1588: hr_psf_shd.g_old_rec.proposed_fte_for_layoff;
1589: End If;
1590: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then
1591: p_rec.proposed_date_for_layoff :=
1592: hr_psf_shd.g_old_rec.proposed_date_for_layoff;

Line 1592: hr_psf_shd.g_old_rec.proposed_date_for_layoff;

1588: hr_psf_shd.g_old_rec.proposed_fte_for_layoff;
1589: End If;
1590: If (p_rec.proposed_date_for_layoff = hr_api.g_date) then
1591: p_rec.proposed_date_for_layoff :=
1592: hr_psf_shd.g_old_rec.proposed_date_for_layoff;
1593: End If;
1594: If (p_rec.pay_basis_id = hr_api.g_number) then
1595: p_rec.pay_basis_id :=
1596: hr_psf_shd.g_old_rec.pay_basis_id;

Line 1596: hr_psf_shd.g_old_rec.pay_basis_id;

1592: hr_psf_shd.g_old_rec.proposed_date_for_layoff;
1593: End If;
1594: If (p_rec.pay_basis_id = hr_api.g_number) then
1595: p_rec.pay_basis_id :=
1596: hr_psf_shd.g_old_rec.pay_basis_id;
1597: End If;
1598: If (p_rec.supervisor_id = hr_api.g_number) then
1599: p_rec.supervisor_id :=
1600: hr_psf_shd.g_old_rec.supervisor_id;

Line 1600: hr_psf_shd.g_old_rec.supervisor_id;

1596: hr_psf_shd.g_old_rec.pay_basis_id;
1597: End If;
1598: If (p_rec.supervisor_id = hr_api.g_number) then
1599: p_rec.supervisor_id :=
1600: hr_psf_shd.g_old_rec.supervisor_id;
1601: End If;
1602: If (p_rec.copied_to_old_table_flag = hr_api.g_varchar2) then
1603: p_rec.copied_to_old_table_flag :=
1604: hr_psf_shd.g_old_rec.copied_to_old_table_flag;

Line 1604: hr_psf_shd.g_old_rec.copied_to_old_table_flag;

1600: hr_psf_shd.g_old_rec.supervisor_id;
1601: End If;
1602: If (p_rec.copied_to_old_table_flag = hr_api.g_varchar2) then
1603: p_rec.copied_to_old_table_flag :=
1604: hr_psf_shd.g_old_rec.copied_to_old_table_flag;
1605: End If;
1606: If (p_rec.information1 = hr_api.g_varchar2) then
1607: p_rec.information1 :=
1608: hr_psf_shd.g_old_rec.information1;

Line 1608: hr_psf_shd.g_old_rec.information1;

1604: hr_psf_shd.g_old_rec.copied_to_old_table_flag;
1605: End If;
1606: If (p_rec.information1 = hr_api.g_varchar2) then
1607: p_rec.information1 :=
1608: hr_psf_shd.g_old_rec.information1;
1609: End If;
1610: If (p_rec.information2 = hr_api.g_varchar2) then
1611: p_rec.information2 :=
1612: hr_psf_shd.g_old_rec.information2;

Line 1612: hr_psf_shd.g_old_rec.information2;

1608: hr_psf_shd.g_old_rec.information1;
1609: End If;
1610: If (p_rec.information2 = hr_api.g_varchar2) then
1611: p_rec.information2 :=
1612: hr_psf_shd.g_old_rec.information2;
1613: End If;
1614: If (p_rec.information3 = hr_api.g_varchar2) then
1615: p_rec.information3 :=
1616: hr_psf_shd.g_old_rec.information3;

Line 1616: hr_psf_shd.g_old_rec.information3;

1612: hr_psf_shd.g_old_rec.information2;
1613: End If;
1614: If (p_rec.information3 = hr_api.g_varchar2) then
1615: p_rec.information3 :=
1616: hr_psf_shd.g_old_rec.information3;
1617: End If;
1618: If (p_rec.information4 = hr_api.g_varchar2) then
1619: p_rec.information4 :=
1620: hr_psf_shd.g_old_rec.information4;

Line 1620: hr_psf_shd.g_old_rec.information4;

1616: hr_psf_shd.g_old_rec.information3;
1617: End If;
1618: If (p_rec.information4 = hr_api.g_varchar2) then
1619: p_rec.information4 :=
1620: hr_psf_shd.g_old_rec.information4;
1621: End If;
1622: If (p_rec.information5 = hr_api.g_varchar2) then
1623: p_rec.information5 :=
1624: hr_psf_shd.g_old_rec.information5;

Line 1624: hr_psf_shd.g_old_rec.information5;

1620: hr_psf_shd.g_old_rec.information4;
1621: End If;
1622: If (p_rec.information5 = hr_api.g_varchar2) then
1623: p_rec.information5 :=
1624: hr_psf_shd.g_old_rec.information5;
1625: End If;
1626: If (p_rec.information6 = hr_api.g_varchar2) then
1627: p_rec.information6 :=
1628: hr_psf_shd.g_old_rec.information6;

Line 1628: hr_psf_shd.g_old_rec.information6;

1624: hr_psf_shd.g_old_rec.information5;
1625: End If;
1626: If (p_rec.information6 = hr_api.g_varchar2) then
1627: p_rec.information6 :=
1628: hr_psf_shd.g_old_rec.information6;
1629: End If;
1630: If (p_rec.information7 = hr_api.g_varchar2) then
1631: p_rec.information7 :=
1632: hr_psf_shd.g_old_rec.information7;

Line 1632: hr_psf_shd.g_old_rec.information7;

1628: hr_psf_shd.g_old_rec.information6;
1629: End If;
1630: If (p_rec.information7 = hr_api.g_varchar2) then
1631: p_rec.information7 :=
1632: hr_psf_shd.g_old_rec.information7;
1633: End If;
1634: If (p_rec.information8 = hr_api.g_varchar2) then
1635: p_rec.information8 :=
1636: hr_psf_shd.g_old_rec.information8;

Line 1636: hr_psf_shd.g_old_rec.information8;

1632: hr_psf_shd.g_old_rec.information7;
1633: End If;
1634: If (p_rec.information8 = hr_api.g_varchar2) then
1635: p_rec.information8 :=
1636: hr_psf_shd.g_old_rec.information8;
1637: End If;
1638: If (p_rec.information9 = hr_api.g_varchar2) then
1639: p_rec.information9 :=
1640: hr_psf_shd.g_old_rec.information9;

Line 1640: hr_psf_shd.g_old_rec.information9;

1636: hr_psf_shd.g_old_rec.information8;
1637: End If;
1638: If (p_rec.information9 = hr_api.g_varchar2) then
1639: p_rec.information9 :=
1640: hr_psf_shd.g_old_rec.information9;
1641: End If;
1642: If (p_rec.information10 = hr_api.g_varchar2) then
1643: p_rec.information10 :=
1644: hr_psf_shd.g_old_rec.information10;

Line 1644: hr_psf_shd.g_old_rec.information10;

1640: hr_psf_shd.g_old_rec.information9;
1641: End If;
1642: If (p_rec.information10 = hr_api.g_varchar2) then
1643: p_rec.information10 :=
1644: hr_psf_shd.g_old_rec.information10;
1645: End If;
1646: If (p_rec.information11 = hr_api.g_varchar2) then
1647: p_rec.information11 :=
1648: hr_psf_shd.g_old_rec.information11;

Line 1648: hr_psf_shd.g_old_rec.information11;

1644: hr_psf_shd.g_old_rec.information10;
1645: End If;
1646: If (p_rec.information11 = hr_api.g_varchar2) then
1647: p_rec.information11 :=
1648: hr_psf_shd.g_old_rec.information11;
1649: End If;
1650: If (p_rec.information12 = hr_api.g_varchar2) then
1651: p_rec.information12 :=
1652: hr_psf_shd.g_old_rec.information12;

Line 1652: hr_psf_shd.g_old_rec.information12;

1648: hr_psf_shd.g_old_rec.information11;
1649: End If;
1650: If (p_rec.information12 = hr_api.g_varchar2) then
1651: p_rec.information12 :=
1652: hr_psf_shd.g_old_rec.information12;
1653: End If;
1654: If (p_rec.information13 = hr_api.g_varchar2) then
1655: p_rec.information13 :=
1656: hr_psf_shd.g_old_rec.information13;

Line 1656: hr_psf_shd.g_old_rec.information13;

1652: hr_psf_shd.g_old_rec.information12;
1653: End If;
1654: If (p_rec.information13 = hr_api.g_varchar2) then
1655: p_rec.information13 :=
1656: hr_psf_shd.g_old_rec.information13;
1657: End If;
1658: If (p_rec.information14 = hr_api.g_varchar2) then
1659: p_rec.information14 :=
1660: hr_psf_shd.g_old_rec.information14;

Line 1660: hr_psf_shd.g_old_rec.information14;

1656: hr_psf_shd.g_old_rec.information13;
1657: End If;
1658: If (p_rec.information14 = hr_api.g_varchar2) then
1659: p_rec.information14 :=
1660: hr_psf_shd.g_old_rec.information14;
1661: End If;
1662: If (p_rec.information15 = hr_api.g_varchar2) then
1663: p_rec.information15 :=
1664: hr_psf_shd.g_old_rec.information15;

Line 1664: hr_psf_shd.g_old_rec.information15;

1660: hr_psf_shd.g_old_rec.information14;
1661: End If;
1662: If (p_rec.information15 = hr_api.g_varchar2) then
1663: p_rec.information15 :=
1664: hr_psf_shd.g_old_rec.information15;
1665: End If;
1666: If (p_rec.information16 = hr_api.g_varchar2) then
1667: p_rec.information16 :=
1668: hr_psf_shd.g_old_rec.information16;

Line 1668: hr_psf_shd.g_old_rec.information16;

1664: hr_psf_shd.g_old_rec.information15;
1665: End If;
1666: If (p_rec.information16 = hr_api.g_varchar2) then
1667: p_rec.information16 :=
1668: hr_psf_shd.g_old_rec.information16;
1669: End If;
1670: If (p_rec.information17 = hr_api.g_varchar2) then
1671: p_rec.information17 :=
1672: hr_psf_shd.g_old_rec.information17;

Line 1672: hr_psf_shd.g_old_rec.information17;

1668: hr_psf_shd.g_old_rec.information16;
1669: End If;
1670: If (p_rec.information17 = hr_api.g_varchar2) then
1671: p_rec.information17 :=
1672: hr_psf_shd.g_old_rec.information17;
1673: End If;
1674: If (p_rec.information18 = hr_api.g_varchar2) then
1675: p_rec.information18 :=
1676: hr_psf_shd.g_old_rec.information18;

Line 1676: hr_psf_shd.g_old_rec.information18;

1672: hr_psf_shd.g_old_rec.information17;
1673: End If;
1674: If (p_rec.information18 = hr_api.g_varchar2) then
1675: p_rec.information18 :=
1676: hr_psf_shd.g_old_rec.information18;
1677: End If;
1678: If (p_rec.information19 = hr_api.g_varchar2) then
1679: p_rec.information19 :=
1680: hr_psf_shd.g_old_rec.information19;

Line 1680: hr_psf_shd.g_old_rec.information19;

1676: hr_psf_shd.g_old_rec.information18;
1677: End If;
1678: If (p_rec.information19 = hr_api.g_varchar2) then
1679: p_rec.information19 :=
1680: hr_psf_shd.g_old_rec.information19;
1681: End If;
1682: If (p_rec.information20 = hr_api.g_varchar2) then
1683: p_rec.information20 :=
1684: hr_psf_shd.g_old_rec.information20;

Line 1684: hr_psf_shd.g_old_rec.information20;

1680: hr_psf_shd.g_old_rec.information19;
1681: End If;
1682: If (p_rec.information20 = hr_api.g_varchar2) then
1683: p_rec.information20 :=
1684: hr_psf_shd.g_old_rec.information20;
1685: End If;
1686: If (p_rec.information21 = hr_api.g_varchar2) then
1687: p_rec.information21 :=
1688: hr_psf_shd.g_old_rec.information21;

Line 1688: hr_psf_shd.g_old_rec.information21;

1684: hr_psf_shd.g_old_rec.information20;
1685: End If;
1686: If (p_rec.information21 = hr_api.g_varchar2) then
1687: p_rec.information21 :=
1688: hr_psf_shd.g_old_rec.information21;
1689: End If;
1690: If (p_rec.information22 = hr_api.g_varchar2) then
1691: p_rec.information22 :=
1692: hr_psf_shd.g_old_rec.information22;

Line 1692: hr_psf_shd.g_old_rec.information22;

1688: hr_psf_shd.g_old_rec.information21;
1689: End If;
1690: If (p_rec.information22 = hr_api.g_varchar2) then
1691: p_rec.information22 :=
1692: hr_psf_shd.g_old_rec.information22;
1693: End If;
1694: If (p_rec.information23 = hr_api.g_varchar2) then
1695: p_rec.information23 :=
1696: hr_psf_shd.g_old_rec.information23;

Line 1696: hr_psf_shd.g_old_rec.information23;

1692: hr_psf_shd.g_old_rec.information22;
1693: End If;
1694: If (p_rec.information23 = hr_api.g_varchar2) then
1695: p_rec.information23 :=
1696: hr_psf_shd.g_old_rec.information23;
1697: End If;
1698: If (p_rec.information24 = hr_api.g_varchar2) then
1699: p_rec.information24 :=
1700: hr_psf_shd.g_old_rec.information24;

Line 1700: hr_psf_shd.g_old_rec.information24;

1696: hr_psf_shd.g_old_rec.information23;
1697: End If;
1698: If (p_rec.information24 = hr_api.g_varchar2) then
1699: p_rec.information24 :=
1700: hr_psf_shd.g_old_rec.information24;
1701: End If;
1702: If (p_rec.information25 = hr_api.g_varchar2) then
1703: p_rec.information25 :=
1704: hr_psf_shd.g_old_rec.information25;

Line 1704: hr_psf_shd.g_old_rec.information25;

1700: hr_psf_shd.g_old_rec.information24;
1701: End If;
1702: If (p_rec.information25 = hr_api.g_varchar2) then
1703: p_rec.information25 :=
1704: hr_psf_shd.g_old_rec.information25;
1705: End If;
1706: If (p_rec.information26 = hr_api.g_varchar2) then
1707: p_rec.information26 :=
1708: hr_psf_shd.g_old_rec.information26;

Line 1708: hr_psf_shd.g_old_rec.information26;

1704: hr_psf_shd.g_old_rec.information25;
1705: End If;
1706: If (p_rec.information26 = hr_api.g_varchar2) then
1707: p_rec.information26 :=
1708: hr_psf_shd.g_old_rec.information26;
1709: End If;
1710: If (p_rec.information27 = hr_api.g_varchar2) then
1711: p_rec.information27 :=
1712: hr_psf_shd.g_old_rec.information27;

Line 1712: hr_psf_shd.g_old_rec.information27;

1708: hr_psf_shd.g_old_rec.information26;
1709: End If;
1710: If (p_rec.information27 = hr_api.g_varchar2) then
1711: p_rec.information27 :=
1712: hr_psf_shd.g_old_rec.information27;
1713: End If;
1714: If (p_rec.information28 = hr_api.g_varchar2) then
1715: p_rec.information28 :=
1716: hr_psf_shd.g_old_rec.information28;

Line 1716: hr_psf_shd.g_old_rec.information28;

1712: hr_psf_shd.g_old_rec.information27;
1713: End If;
1714: If (p_rec.information28 = hr_api.g_varchar2) then
1715: p_rec.information28 :=
1716: hr_psf_shd.g_old_rec.information28;
1717: End If;
1718: If (p_rec.information29 = hr_api.g_varchar2) then
1719: p_rec.information29 :=
1720: hr_psf_shd.g_old_rec.information29;

Line 1720: hr_psf_shd.g_old_rec.information29;

1716: hr_psf_shd.g_old_rec.information28;
1717: End If;
1718: If (p_rec.information29 = hr_api.g_varchar2) then
1719: p_rec.information29 :=
1720: hr_psf_shd.g_old_rec.information29;
1721: End If;
1722: If (p_rec.information30 = hr_api.g_varchar2) then
1723: p_rec.information30 :=
1724: hr_psf_shd.g_old_rec.information30;

Line 1724: hr_psf_shd.g_old_rec.information30;

1720: hr_psf_shd.g_old_rec.information29;
1721: End If;
1722: If (p_rec.information30 = hr_api.g_varchar2) then
1723: p_rec.information30 :=
1724: hr_psf_shd.g_old_rec.information30;
1725: End If;
1726: If (p_rec.information_category = hr_api.g_varchar2) then
1727: p_rec.information_category :=
1728: hr_psf_shd.g_old_rec.information_category;

Line 1728: hr_psf_shd.g_old_rec.information_category;

1724: hr_psf_shd.g_old_rec.information30;
1725: End If;
1726: If (p_rec.information_category = hr_api.g_varchar2) then
1727: p_rec.information_category :=
1728: hr_psf_shd.g_old_rec.information_category;
1729: End If;
1730: If (p_rec.attribute1 = hr_api.g_varchar2) then
1731: p_rec.attribute1 :=
1732: hr_psf_shd.g_old_rec.attribute1;

Line 1732: hr_psf_shd.g_old_rec.attribute1;

1728: hr_psf_shd.g_old_rec.information_category;
1729: End If;
1730: If (p_rec.attribute1 = hr_api.g_varchar2) then
1731: p_rec.attribute1 :=
1732: hr_psf_shd.g_old_rec.attribute1;
1733: End If;
1734: If (p_rec.attribute2 = hr_api.g_varchar2) then
1735: p_rec.attribute2 :=
1736: hr_psf_shd.g_old_rec.attribute2;

Line 1736: hr_psf_shd.g_old_rec.attribute2;

1732: hr_psf_shd.g_old_rec.attribute1;
1733: End If;
1734: If (p_rec.attribute2 = hr_api.g_varchar2) then
1735: p_rec.attribute2 :=
1736: hr_psf_shd.g_old_rec.attribute2;
1737: End If;
1738: If (p_rec.attribute3 = hr_api.g_varchar2) then
1739: p_rec.attribute3 :=
1740: hr_psf_shd.g_old_rec.attribute3;

Line 1740: hr_psf_shd.g_old_rec.attribute3;

1736: hr_psf_shd.g_old_rec.attribute2;
1737: End If;
1738: If (p_rec.attribute3 = hr_api.g_varchar2) then
1739: p_rec.attribute3 :=
1740: hr_psf_shd.g_old_rec.attribute3;
1741: End If;
1742: If (p_rec.attribute4 = hr_api.g_varchar2) then
1743: p_rec.attribute4 :=
1744: hr_psf_shd.g_old_rec.attribute4;

Line 1744: hr_psf_shd.g_old_rec.attribute4;

1740: hr_psf_shd.g_old_rec.attribute3;
1741: End If;
1742: If (p_rec.attribute4 = hr_api.g_varchar2) then
1743: p_rec.attribute4 :=
1744: hr_psf_shd.g_old_rec.attribute4;
1745: End If;
1746: If (p_rec.attribute5 = hr_api.g_varchar2) then
1747: p_rec.attribute5 :=
1748: hr_psf_shd.g_old_rec.attribute5;

Line 1748: hr_psf_shd.g_old_rec.attribute5;

1744: hr_psf_shd.g_old_rec.attribute4;
1745: End If;
1746: If (p_rec.attribute5 = hr_api.g_varchar2) then
1747: p_rec.attribute5 :=
1748: hr_psf_shd.g_old_rec.attribute5;
1749: End If;
1750: If (p_rec.attribute6 = hr_api.g_varchar2) then
1751: p_rec.attribute6 :=
1752: hr_psf_shd.g_old_rec.attribute6;

Line 1752: hr_psf_shd.g_old_rec.attribute6;

1748: hr_psf_shd.g_old_rec.attribute5;
1749: End If;
1750: If (p_rec.attribute6 = hr_api.g_varchar2) then
1751: p_rec.attribute6 :=
1752: hr_psf_shd.g_old_rec.attribute6;
1753: End If;
1754: If (p_rec.attribute7 = hr_api.g_varchar2) then
1755: p_rec.attribute7 :=
1756: hr_psf_shd.g_old_rec.attribute7;

Line 1756: hr_psf_shd.g_old_rec.attribute7;

1752: hr_psf_shd.g_old_rec.attribute6;
1753: End If;
1754: If (p_rec.attribute7 = hr_api.g_varchar2) then
1755: p_rec.attribute7 :=
1756: hr_psf_shd.g_old_rec.attribute7;
1757: End If;
1758: If (p_rec.attribute8 = hr_api.g_varchar2) then
1759: p_rec.attribute8 :=
1760: hr_psf_shd.g_old_rec.attribute8;

Line 1760: hr_psf_shd.g_old_rec.attribute8;

1756: hr_psf_shd.g_old_rec.attribute7;
1757: End If;
1758: If (p_rec.attribute8 = hr_api.g_varchar2) then
1759: p_rec.attribute8 :=
1760: hr_psf_shd.g_old_rec.attribute8;
1761: End If;
1762: If (p_rec.attribute9 = hr_api.g_varchar2) then
1763: p_rec.attribute9 :=
1764: hr_psf_shd.g_old_rec.attribute9;

Line 1764: hr_psf_shd.g_old_rec.attribute9;

1760: hr_psf_shd.g_old_rec.attribute8;
1761: End If;
1762: If (p_rec.attribute9 = hr_api.g_varchar2) then
1763: p_rec.attribute9 :=
1764: hr_psf_shd.g_old_rec.attribute9;
1765: End If;
1766: If (p_rec.attribute10 = hr_api.g_varchar2) then
1767: p_rec.attribute10 :=
1768: hr_psf_shd.g_old_rec.attribute10;

Line 1768: hr_psf_shd.g_old_rec.attribute10;

1764: hr_psf_shd.g_old_rec.attribute9;
1765: End If;
1766: If (p_rec.attribute10 = hr_api.g_varchar2) then
1767: p_rec.attribute10 :=
1768: hr_psf_shd.g_old_rec.attribute10;
1769: End If;
1770: If (p_rec.attribute11 = hr_api.g_varchar2) then
1771: p_rec.attribute11 :=
1772: hr_psf_shd.g_old_rec.attribute11;

Line 1772: hr_psf_shd.g_old_rec.attribute11;

1768: hr_psf_shd.g_old_rec.attribute10;
1769: End If;
1770: If (p_rec.attribute11 = hr_api.g_varchar2) then
1771: p_rec.attribute11 :=
1772: hr_psf_shd.g_old_rec.attribute11;
1773: End If;
1774: If (p_rec.attribute12 = hr_api.g_varchar2) then
1775: p_rec.attribute12 :=
1776: hr_psf_shd.g_old_rec.attribute12;

Line 1776: hr_psf_shd.g_old_rec.attribute12;

1772: hr_psf_shd.g_old_rec.attribute11;
1773: End If;
1774: If (p_rec.attribute12 = hr_api.g_varchar2) then
1775: p_rec.attribute12 :=
1776: hr_psf_shd.g_old_rec.attribute12;
1777: End If;
1778: If (p_rec.attribute13 = hr_api.g_varchar2) then
1779: p_rec.attribute13 :=
1780: hr_psf_shd.g_old_rec.attribute13;

Line 1780: hr_psf_shd.g_old_rec.attribute13;

1776: hr_psf_shd.g_old_rec.attribute12;
1777: End If;
1778: If (p_rec.attribute13 = hr_api.g_varchar2) then
1779: p_rec.attribute13 :=
1780: hr_psf_shd.g_old_rec.attribute13;
1781: End If;
1782: If (p_rec.attribute14 = hr_api.g_varchar2) then
1783: p_rec.attribute14 :=
1784: hr_psf_shd.g_old_rec.attribute14;

Line 1784: hr_psf_shd.g_old_rec.attribute14;

1780: hr_psf_shd.g_old_rec.attribute13;
1781: End If;
1782: If (p_rec.attribute14 = hr_api.g_varchar2) then
1783: p_rec.attribute14 :=
1784: hr_psf_shd.g_old_rec.attribute14;
1785: End If;
1786: If (p_rec.attribute15 = hr_api.g_varchar2) then
1787: p_rec.attribute15 :=
1788: hr_psf_shd.g_old_rec.attribute15;

Line 1788: hr_psf_shd.g_old_rec.attribute15;

1784: hr_psf_shd.g_old_rec.attribute14;
1785: End If;
1786: If (p_rec.attribute15 = hr_api.g_varchar2) then
1787: p_rec.attribute15 :=
1788: hr_psf_shd.g_old_rec.attribute15;
1789: End If;
1790: If (p_rec.attribute16 = hr_api.g_varchar2) then
1791: p_rec.attribute16 :=
1792: hr_psf_shd.g_old_rec.attribute16;

Line 1792: hr_psf_shd.g_old_rec.attribute16;

1788: hr_psf_shd.g_old_rec.attribute15;
1789: End If;
1790: If (p_rec.attribute16 = hr_api.g_varchar2) then
1791: p_rec.attribute16 :=
1792: hr_psf_shd.g_old_rec.attribute16;
1793: End If;
1794: If (p_rec.attribute17 = hr_api.g_varchar2) then
1795: p_rec.attribute17 :=
1796: hr_psf_shd.g_old_rec.attribute17;

Line 1796: hr_psf_shd.g_old_rec.attribute17;

1792: hr_psf_shd.g_old_rec.attribute16;
1793: End If;
1794: If (p_rec.attribute17 = hr_api.g_varchar2) then
1795: p_rec.attribute17 :=
1796: hr_psf_shd.g_old_rec.attribute17;
1797: End If;
1798: If (p_rec.attribute18 = hr_api.g_varchar2) then
1799: p_rec.attribute18 :=
1800: hr_psf_shd.g_old_rec.attribute18;

Line 1800: hr_psf_shd.g_old_rec.attribute18;

1796: hr_psf_shd.g_old_rec.attribute17;
1797: End If;
1798: If (p_rec.attribute18 = hr_api.g_varchar2) then
1799: p_rec.attribute18 :=
1800: hr_psf_shd.g_old_rec.attribute18;
1801: End If;
1802: If (p_rec.attribute19 = hr_api.g_varchar2) then
1803: p_rec.attribute19 :=
1804: hr_psf_shd.g_old_rec.attribute19;

Line 1804: hr_psf_shd.g_old_rec.attribute19;

1800: hr_psf_shd.g_old_rec.attribute18;
1801: End If;
1802: If (p_rec.attribute19 = hr_api.g_varchar2) then
1803: p_rec.attribute19 :=
1804: hr_psf_shd.g_old_rec.attribute19;
1805: End If;
1806: If (p_rec.attribute20 = hr_api.g_varchar2) then
1807: p_rec.attribute20 :=
1808: hr_psf_shd.g_old_rec.attribute20;

Line 1808: hr_psf_shd.g_old_rec.attribute20;

1804: hr_psf_shd.g_old_rec.attribute19;
1805: End If;
1806: If (p_rec.attribute20 = hr_api.g_varchar2) then
1807: p_rec.attribute20 :=
1808: hr_psf_shd.g_old_rec.attribute20;
1809: End If;
1810: If (p_rec.attribute21 = hr_api.g_varchar2) then
1811: p_rec.attribute21 :=
1812: hr_psf_shd.g_old_rec.attribute21;

Line 1812: hr_psf_shd.g_old_rec.attribute21;

1808: hr_psf_shd.g_old_rec.attribute20;
1809: End If;
1810: If (p_rec.attribute21 = hr_api.g_varchar2) then
1811: p_rec.attribute21 :=
1812: hr_psf_shd.g_old_rec.attribute21;
1813: End If;
1814: If (p_rec.attribute22 = hr_api.g_varchar2) then
1815: p_rec.attribute22 :=
1816: hr_psf_shd.g_old_rec.attribute22;

Line 1816: hr_psf_shd.g_old_rec.attribute22;

1812: hr_psf_shd.g_old_rec.attribute21;
1813: End If;
1814: If (p_rec.attribute22 = hr_api.g_varchar2) then
1815: p_rec.attribute22 :=
1816: hr_psf_shd.g_old_rec.attribute22;
1817: End If;
1818: If (p_rec.attribute23 = hr_api.g_varchar2) then
1819: p_rec.attribute23 :=
1820: hr_psf_shd.g_old_rec.attribute23;

Line 1820: hr_psf_shd.g_old_rec.attribute23;

1816: hr_psf_shd.g_old_rec.attribute22;
1817: End If;
1818: If (p_rec.attribute23 = hr_api.g_varchar2) then
1819: p_rec.attribute23 :=
1820: hr_psf_shd.g_old_rec.attribute23;
1821: End If;
1822: If (p_rec.attribute24 = hr_api.g_varchar2) then
1823: p_rec.attribute24 :=
1824: hr_psf_shd.g_old_rec.attribute24;

Line 1824: hr_psf_shd.g_old_rec.attribute24;

1820: hr_psf_shd.g_old_rec.attribute23;
1821: End If;
1822: If (p_rec.attribute24 = hr_api.g_varchar2) then
1823: p_rec.attribute24 :=
1824: hr_psf_shd.g_old_rec.attribute24;
1825: End If;
1826: If (p_rec.attribute25 = hr_api.g_varchar2) then
1827: p_rec.attribute25 :=
1828: hr_psf_shd.g_old_rec.attribute25;

Line 1828: hr_psf_shd.g_old_rec.attribute25;

1824: hr_psf_shd.g_old_rec.attribute24;
1825: End If;
1826: If (p_rec.attribute25 = hr_api.g_varchar2) then
1827: p_rec.attribute25 :=
1828: hr_psf_shd.g_old_rec.attribute25;
1829: End If;
1830: If (p_rec.attribute26 = hr_api.g_varchar2) then
1831: p_rec.attribute26 :=
1832: hr_psf_shd.g_old_rec.attribute26;

Line 1832: hr_psf_shd.g_old_rec.attribute26;

1828: hr_psf_shd.g_old_rec.attribute25;
1829: End If;
1830: If (p_rec.attribute26 = hr_api.g_varchar2) then
1831: p_rec.attribute26 :=
1832: hr_psf_shd.g_old_rec.attribute26;
1833: End If;
1834: If (p_rec.attribute27 = hr_api.g_varchar2) then
1835: p_rec.attribute27 :=
1836: hr_psf_shd.g_old_rec.attribute27;

Line 1836: hr_psf_shd.g_old_rec.attribute27;

1832: hr_psf_shd.g_old_rec.attribute26;
1833: End If;
1834: If (p_rec.attribute27 = hr_api.g_varchar2) then
1835: p_rec.attribute27 :=
1836: hr_psf_shd.g_old_rec.attribute27;
1837: End If;
1838: If (p_rec.attribute28 = hr_api.g_varchar2) then
1839: p_rec.attribute28 :=
1840: hr_psf_shd.g_old_rec.attribute28;

Line 1840: hr_psf_shd.g_old_rec.attribute28;

1836: hr_psf_shd.g_old_rec.attribute27;
1837: End If;
1838: If (p_rec.attribute28 = hr_api.g_varchar2) then
1839: p_rec.attribute28 :=
1840: hr_psf_shd.g_old_rec.attribute28;
1841: End If;
1842: If (p_rec.attribute29 = hr_api.g_varchar2) then
1843: p_rec.attribute29 :=
1844: hr_psf_shd.g_old_rec.attribute29;

Line 1844: hr_psf_shd.g_old_rec.attribute29;

1840: hr_psf_shd.g_old_rec.attribute28;
1841: End If;
1842: If (p_rec.attribute29 = hr_api.g_varchar2) then
1843: p_rec.attribute29 :=
1844: hr_psf_shd.g_old_rec.attribute29;
1845: End If;
1846: If (p_rec.attribute30 = hr_api.g_varchar2) then
1847: p_rec.attribute30 :=
1848: hr_psf_shd.g_old_rec.attribute30;

Line 1848: hr_psf_shd.g_old_rec.attribute30;

1844: hr_psf_shd.g_old_rec.attribute29;
1845: End If;
1846: If (p_rec.attribute30 = hr_api.g_varchar2) then
1847: p_rec.attribute30 :=
1848: hr_psf_shd.g_old_rec.attribute30;
1849: End If;
1850: If (p_rec.attribute_category = hr_api.g_varchar2) then
1851: p_rec.attribute_category :=
1852: hr_psf_shd.g_old_rec.attribute_category;

Line 1852: hr_psf_shd.g_old_rec.attribute_category;

1848: hr_psf_shd.g_old_rec.attribute30;
1849: End If;
1850: If (p_rec.attribute_category = hr_api.g_varchar2) then
1851: p_rec.attribute_category :=
1852: hr_psf_shd.g_old_rec.attribute_category;
1853: End If;
1854: If (p_rec.request_id = hr_api.g_number) then
1855: p_rec.request_id :=
1856: hr_psf_shd.g_old_rec.request_id;

Line 1856: hr_psf_shd.g_old_rec.request_id;

1852: hr_psf_shd.g_old_rec.attribute_category;
1853: End If;
1854: If (p_rec.request_id = hr_api.g_number) then
1855: p_rec.request_id :=
1856: hr_psf_shd.g_old_rec.request_id;
1857: End If;
1858: If (p_rec.program_application_id = hr_api.g_number) then
1859: p_rec.program_application_id :=
1860: hr_psf_shd.g_old_rec.program_application_id;

Line 1860: hr_psf_shd.g_old_rec.program_application_id;

1856: hr_psf_shd.g_old_rec.request_id;
1857: End If;
1858: If (p_rec.program_application_id = hr_api.g_number) then
1859: p_rec.program_application_id :=
1860: hr_psf_shd.g_old_rec.program_application_id;
1861: End If;
1862: If (p_rec.program_id = hr_api.g_number) then
1863: p_rec.program_id :=
1864: hr_psf_shd.g_old_rec.program_id;

Line 1864: hr_psf_shd.g_old_rec.program_id;

1860: hr_psf_shd.g_old_rec.program_application_id;
1861: End If;
1862: If (p_rec.program_id = hr_api.g_number) then
1863: p_rec.program_id :=
1864: hr_psf_shd.g_old_rec.program_id;
1865: End If;
1866: If (p_rec.program_update_date = hr_api.g_date) then
1867: p_rec.program_update_date :=
1868: hr_psf_shd.g_old_rec.program_update_date;

Line 1868: hr_psf_shd.g_old_rec.program_update_date;

1864: hr_psf_shd.g_old_rec.program_id;
1865: End If;
1866: If (p_rec.program_update_date = hr_api.g_date) then
1867: p_rec.program_update_date :=
1868: hr_psf_shd.g_old_rec.program_update_date;
1869: End If;
1870:
1871: --
1872: if g_debug then

Line 1883: p_rec in out nocopy hr_psf_shd.g_rec_type,

1879: -- |---------------------------------< upd >----------------------------------|
1880: -- ----------------------------------------------------------------------------
1881: Procedure upd
1882: (
1883: p_rec in out nocopy hr_psf_shd.g_rec_type,
1884: p_effective_date in date,
1885: p_datetrack_mode in varchar2,
1886: p_validate in boolean default false
1887: ) is

Line 1915: hr_psf_shd.lck

1911: --
1912: --
1913: -- We must lock the row which we need to update.
1914: --
1915: hr_psf_shd.lck
1916: (p_effective_date => p_effective_date,
1917: p_datetrack_mode => p_datetrack_mode,
1918: p_position_id => p_rec.position_id,
1919: p_object_version_number => p_rec.object_version_number,

Line 2175: l_rec hr_psf_shd.g_rec_type;

2171: p_datetrack_mode in varchar2,
2172: p_validate in boolean default false
2173: ) is
2174: --
2175: l_rec hr_psf_shd.g_rec_type;
2176: l_proc varchar2(72) ;
2177: --
2178: Begin
2179: if g_debug then

Line 2189: hr_psf_shd.convert_args

2185: -- Call conversion function to turn arguments into the
2186: -- l_rec structure.
2187: --
2188: l_rec :=
2189: hr_psf_shd.convert_args
2190: (
2191: p_position_id,
2192: null,
2193: null,