eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_SPP_UPD dependencies on PER_SPP_SHD

Line 58: (p_rec in out nocopy per_spp_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy per_spp_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 91: per_spp_shd.g_api_dml := true; -- Set the api dml status

87: hr_utility.set_location('OVN '||p_rec.object_version_number, 10);
88: hr_utility.set_location('Start Date '||p_validation_start_date, 10);
89: hr_utility.set_location('End Date '||p_validation_end_date, 10);
90: hr_utility.set_location('Increment Number'||p_rec.increment_number, 20);
91: per_spp_shd.g_api_dml := true; -- Set the api dml status
92: --
93: -- Update the per_spinal_point_placements_f Row
94: --
95: update per_spinal_point_placements_f

Line 145: per_spp_shd.g_api_dml := false; -- Unset the api dml status

141: where placement_id = p_rec.placement_id
142: and effective_start_date = p_validation_start_date
143: and effective_end_date = p_validation_end_date;
144: --
145: per_spp_shd.g_api_dml := false; -- Unset the api dml status
146: hr_utility.set_location('Entering:'||l_proc, 15);
147: --
148: -- Set the effective start and end dates
149: --

Line 158: per_spp_shd.g_api_dml := false; -- Unset the api dml status

154: hr_utility.set_location(' Leaving:'||l_proc, 20);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: per_spp_shd.g_api_dml := false; -- Unset the api dml status
159: per_spp_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated

Line 159: per_spp_shd.constraint_error

155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: per_spp_shd.g_api_dml := false; -- Unset the api dml status
159: per_spp_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: per_spp_shd.g_api_dml := false; -- Unset the api dml status

Line 163: per_spp_shd.g_api_dml := false; -- Unset the api dml status

159: per_spp_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: per_spp_shd.g_api_dml := false; -- Unset the api dml status
164: per_spp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: per_spp_shd.g_api_dml := false; -- Unset the api dml status

Line 164: per_spp_shd.constraint_error

160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: per_spp_shd.g_api_dml := false; -- Unset the api dml status
164: per_spp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: per_spp_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;

Line 167: per_spp_shd.g_api_dml := false; -- Unset the api dml status

163: per_spp_shd.g_api_dml := false; -- Unset the api dml status
164: per_spp_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: per_spp_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;
169: End dt_update_dml;
170: --
171: -- ----------------------------------------------------------------------------

Line 203: (p_rec in out nocopy per_spp_shd.g_rec_type

199: --
200: -- {End Of Comments}
201: -- ----------------------------------------------------------------------------
202: Procedure update_dml
203: (p_rec in out nocopy per_spp_shd.g_rec_type
204: ,p_effective_date in date
205: ,p_datetrack_mode in varchar2
206: ,p_validation_start_date in date
207: ,p_validation_end_date in date

Line 270: (p_rec in out nocopy per_spp_shd.g_rec_type

266: --
267: -- {End Of Comments}
268: -- ----------------------------------------------------------------------------
269: Procedure dt_pre_update
270: (p_rec in out nocopy per_spp_shd.g_rec_type
271: ,p_effective_date in date
272: ,p_datetrack_mode in varchar2
273: ,p_validation_start_date in date
274: ,p_validation_end_date in date

Line 286: per_spp_shd.upd_effective_end_date

282: If (p_datetrack_mode <> hr_api.g_correction) then
283: --
284: -- Update the current effective end date
285: --
286: per_spp_shd.upd_effective_end_date
287: (p_effective_date => p_effective_date
288: ,p_base_key_value => p_rec.placement_id
289: ,p_new_effective_end_date => (p_validation_start_date - 1)
290: ,p_validation_start_date => p_validation_start_date

Line 356: (p_rec in out nocopy per_spp_shd.g_rec_type

352: --
353: -- {End Of Comments}
354: -- ----------------------------------------------------------------------------
355: Procedure pre_update
356: (p_rec in out nocopy per_spp_shd.g_rec_type
357: ,p_effective_date in date
358: ,p_datetrack_mode in varchar2
359: ,p_validation_start_date in date
360: ,p_validation_end_date in date

Line 414: (p_rec in per_spp_shd.g_rec_type

410: --
411: -- {End Of Comments}
412: -- ----------------------------------------------------------------------------
413: Procedure post_update
414: (p_rec in per_spp_shd.g_rec_type
415: ,p_effective_date in date
416: ,p_datetrack_mode in varchar2
417: ,p_validation_start_date in date
418: ,p_validation_end_date in date

Line 498: => per_spp_shd.g_old_rec.effective_start_date

494: ,p_information_category => p_rec.information_category
495: ,p_object_version_number
496: => p_rec.object_version_number
497: ,p_effective_start_date_o
498: => per_spp_shd.g_old_rec.effective_start_date
499: ,p_effective_end_date_o
500: => per_spp_shd.g_old_rec.effective_end_date
501: ,p_business_group_id_o
502: => per_spp_shd.g_old_rec.business_group_id

Line 500: => per_spp_shd.g_old_rec.effective_end_date

496: => p_rec.object_version_number
497: ,p_effective_start_date_o
498: => per_spp_shd.g_old_rec.effective_start_date
499: ,p_effective_end_date_o
500: => per_spp_shd.g_old_rec.effective_end_date
501: ,p_business_group_id_o
502: => per_spp_shd.g_old_rec.business_group_id
503: ,p_assignment_id_o
504: => per_spp_shd.g_old_rec.assignment_id

Line 502: => per_spp_shd.g_old_rec.business_group_id

498: => per_spp_shd.g_old_rec.effective_start_date
499: ,p_effective_end_date_o
500: => per_spp_shd.g_old_rec.effective_end_date
501: ,p_business_group_id_o
502: => per_spp_shd.g_old_rec.business_group_id
503: ,p_assignment_id_o
504: => per_spp_shd.g_old_rec.assignment_id
505: ,p_step_id_o
506: => per_spp_shd.g_old_rec.step_id

Line 504: => per_spp_shd.g_old_rec.assignment_id

500: => per_spp_shd.g_old_rec.effective_end_date
501: ,p_business_group_id_o
502: => per_spp_shd.g_old_rec.business_group_id
503: ,p_assignment_id_o
504: => per_spp_shd.g_old_rec.assignment_id
505: ,p_step_id_o
506: => per_spp_shd.g_old_rec.step_id
507: ,p_auto_increment_flag_o
508: => per_spp_shd.g_old_rec.auto_increment_flag

Line 506: => per_spp_shd.g_old_rec.step_id

502: => per_spp_shd.g_old_rec.business_group_id
503: ,p_assignment_id_o
504: => per_spp_shd.g_old_rec.assignment_id
505: ,p_step_id_o
506: => per_spp_shd.g_old_rec.step_id
507: ,p_auto_increment_flag_o
508: => per_spp_shd.g_old_rec.auto_increment_flag
509: ,p_parent_spine_id_o
510: => per_spp_shd.g_old_rec.parent_spine_id

Line 508: => per_spp_shd.g_old_rec.auto_increment_flag

504: => per_spp_shd.g_old_rec.assignment_id
505: ,p_step_id_o
506: => per_spp_shd.g_old_rec.step_id
507: ,p_auto_increment_flag_o
508: => per_spp_shd.g_old_rec.auto_increment_flag
509: ,p_parent_spine_id_o
510: => per_spp_shd.g_old_rec.parent_spine_id
511: ,p_reason_o
512: => per_spp_shd.g_old_rec.reason

Line 510: => per_spp_shd.g_old_rec.parent_spine_id

506: => per_spp_shd.g_old_rec.step_id
507: ,p_auto_increment_flag_o
508: => per_spp_shd.g_old_rec.auto_increment_flag
509: ,p_parent_spine_id_o
510: => per_spp_shd.g_old_rec.parent_spine_id
511: ,p_reason_o
512: => per_spp_shd.g_old_rec.reason
513: ,p_request_id_o
514: => per_spp_shd.g_old_rec.request_id

Line 512: => per_spp_shd.g_old_rec.reason

508: => per_spp_shd.g_old_rec.auto_increment_flag
509: ,p_parent_spine_id_o
510: => per_spp_shd.g_old_rec.parent_spine_id
511: ,p_reason_o
512: => per_spp_shd.g_old_rec.reason
513: ,p_request_id_o
514: => per_spp_shd.g_old_rec.request_id
515: ,p_program_application_id_o
516: => per_spp_shd.g_old_rec.program_application_id

Line 514: => per_spp_shd.g_old_rec.request_id

510: => per_spp_shd.g_old_rec.parent_spine_id
511: ,p_reason_o
512: => per_spp_shd.g_old_rec.reason
513: ,p_request_id_o
514: => per_spp_shd.g_old_rec.request_id
515: ,p_program_application_id_o
516: => per_spp_shd.g_old_rec.program_application_id
517: ,p_program_id_o
518: => per_spp_shd.g_old_rec.program_id

Line 516: => per_spp_shd.g_old_rec.program_application_id

512: => per_spp_shd.g_old_rec.reason
513: ,p_request_id_o
514: => per_spp_shd.g_old_rec.request_id
515: ,p_program_application_id_o
516: => per_spp_shd.g_old_rec.program_application_id
517: ,p_program_id_o
518: => per_spp_shd.g_old_rec.program_id
519: ,p_program_update_date_o
520: => per_spp_shd.g_old_rec.program_update_date

Line 518: => per_spp_shd.g_old_rec.program_id

514: => per_spp_shd.g_old_rec.request_id
515: ,p_program_application_id_o
516: => per_spp_shd.g_old_rec.program_application_id
517: ,p_program_id_o
518: => per_spp_shd.g_old_rec.program_id
519: ,p_program_update_date_o
520: => per_spp_shd.g_old_rec.program_update_date
521: ,p_increment_number_o
522: => per_spp_shd.g_old_rec.increment_number

Line 520: => per_spp_shd.g_old_rec.program_update_date

516: => per_spp_shd.g_old_rec.program_application_id
517: ,p_program_id_o
518: => per_spp_shd.g_old_rec.program_id
519: ,p_program_update_date_o
520: => per_spp_shd.g_old_rec.program_update_date
521: ,p_increment_number_o
522: => per_spp_shd.g_old_rec.increment_number
523: ,p_information1_o => per_spp_shd.g_old_rec.information1
524: ,p_information2_o => per_spp_shd.g_old_rec.information2

Line 522: => per_spp_shd.g_old_rec.increment_number

518: => per_spp_shd.g_old_rec.program_id
519: ,p_program_update_date_o
520: => per_spp_shd.g_old_rec.program_update_date
521: ,p_increment_number_o
522: => per_spp_shd.g_old_rec.increment_number
523: ,p_information1_o => per_spp_shd.g_old_rec.information1
524: ,p_information2_o => per_spp_shd.g_old_rec.information2
525: ,p_information3_o => per_spp_shd.g_old_rec.information3
526: ,p_information4_o => per_spp_shd.g_old_rec.information4

Line 523: ,p_information1_o => per_spp_shd.g_old_rec.information1

519: ,p_program_update_date_o
520: => per_spp_shd.g_old_rec.program_update_date
521: ,p_increment_number_o
522: => per_spp_shd.g_old_rec.increment_number
523: ,p_information1_o => per_spp_shd.g_old_rec.information1
524: ,p_information2_o => per_spp_shd.g_old_rec.information2
525: ,p_information3_o => per_spp_shd.g_old_rec.information3
526: ,p_information4_o => per_spp_shd.g_old_rec.information4
527: ,p_information5_o => per_spp_shd.g_old_rec.information5

Line 524: ,p_information2_o => per_spp_shd.g_old_rec.information2

520: => per_spp_shd.g_old_rec.program_update_date
521: ,p_increment_number_o
522: => per_spp_shd.g_old_rec.increment_number
523: ,p_information1_o => per_spp_shd.g_old_rec.information1
524: ,p_information2_o => per_spp_shd.g_old_rec.information2
525: ,p_information3_o => per_spp_shd.g_old_rec.information3
526: ,p_information4_o => per_spp_shd.g_old_rec.information4
527: ,p_information5_o => per_spp_shd.g_old_rec.information5
528: ,p_information6_o => per_spp_shd.g_old_rec.information6

Line 525: ,p_information3_o => per_spp_shd.g_old_rec.information3

521: ,p_increment_number_o
522: => per_spp_shd.g_old_rec.increment_number
523: ,p_information1_o => per_spp_shd.g_old_rec.information1
524: ,p_information2_o => per_spp_shd.g_old_rec.information2
525: ,p_information3_o => per_spp_shd.g_old_rec.information3
526: ,p_information4_o => per_spp_shd.g_old_rec.information4
527: ,p_information5_o => per_spp_shd.g_old_rec.information5
528: ,p_information6_o => per_spp_shd.g_old_rec.information6
529: ,p_information7_o => per_spp_shd.g_old_rec.information7

Line 526: ,p_information4_o => per_spp_shd.g_old_rec.information4

522: => per_spp_shd.g_old_rec.increment_number
523: ,p_information1_o => per_spp_shd.g_old_rec.information1
524: ,p_information2_o => per_spp_shd.g_old_rec.information2
525: ,p_information3_o => per_spp_shd.g_old_rec.information3
526: ,p_information4_o => per_spp_shd.g_old_rec.information4
527: ,p_information5_o => per_spp_shd.g_old_rec.information5
528: ,p_information6_o => per_spp_shd.g_old_rec.information6
529: ,p_information7_o => per_spp_shd.g_old_rec.information7
530: ,p_information8_o => per_spp_shd.g_old_rec.information8

Line 527: ,p_information5_o => per_spp_shd.g_old_rec.information5

523: ,p_information1_o => per_spp_shd.g_old_rec.information1
524: ,p_information2_o => per_spp_shd.g_old_rec.information2
525: ,p_information3_o => per_spp_shd.g_old_rec.information3
526: ,p_information4_o => per_spp_shd.g_old_rec.information4
527: ,p_information5_o => per_spp_shd.g_old_rec.information5
528: ,p_information6_o => per_spp_shd.g_old_rec.information6
529: ,p_information7_o => per_spp_shd.g_old_rec.information7
530: ,p_information8_o => per_spp_shd.g_old_rec.information8
531: ,p_information9_o => per_spp_shd.g_old_rec.information9

Line 528: ,p_information6_o => per_spp_shd.g_old_rec.information6

524: ,p_information2_o => per_spp_shd.g_old_rec.information2
525: ,p_information3_o => per_spp_shd.g_old_rec.information3
526: ,p_information4_o => per_spp_shd.g_old_rec.information4
527: ,p_information5_o => per_spp_shd.g_old_rec.information5
528: ,p_information6_o => per_spp_shd.g_old_rec.information6
529: ,p_information7_o => per_spp_shd.g_old_rec.information7
530: ,p_information8_o => per_spp_shd.g_old_rec.information8
531: ,p_information9_o => per_spp_shd.g_old_rec.information9
532: ,p_information10_o => per_spp_shd.g_old_rec.information10

Line 529: ,p_information7_o => per_spp_shd.g_old_rec.information7

525: ,p_information3_o => per_spp_shd.g_old_rec.information3
526: ,p_information4_o => per_spp_shd.g_old_rec.information4
527: ,p_information5_o => per_spp_shd.g_old_rec.information5
528: ,p_information6_o => per_spp_shd.g_old_rec.information6
529: ,p_information7_o => per_spp_shd.g_old_rec.information7
530: ,p_information8_o => per_spp_shd.g_old_rec.information8
531: ,p_information9_o => per_spp_shd.g_old_rec.information9
532: ,p_information10_o => per_spp_shd.g_old_rec.information10
533: ,p_information11_o => per_spp_shd.g_old_rec.information11

Line 530: ,p_information8_o => per_spp_shd.g_old_rec.information8

526: ,p_information4_o => per_spp_shd.g_old_rec.information4
527: ,p_information5_o => per_spp_shd.g_old_rec.information5
528: ,p_information6_o => per_spp_shd.g_old_rec.information6
529: ,p_information7_o => per_spp_shd.g_old_rec.information7
530: ,p_information8_o => per_spp_shd.g_old_rec.information8
531: ,p_information9_o => per_spp_shd.g_old_rec.information9
532: ,p_information10_o => per_spp_shd.g_old_rec.information10
533: ,p_information11_o => per_spp_shd.g_old_rec.information11
534: ,p_information12_o => per_spp_shd.g_old_rec.information12

Line 531: ,p_information9_o => per_spp_shd.g_old_rec.information9

527: ,p_information5_o => per_spp_shd.g_old_rec.information5
528: ,p_information6_o => per_spp_shd.g_old_rec.information6
529: ,p_information7_o => per_spp_shd.g_old_rec.information7
530: ,p_information8_o => per_spp_shd.g_old_rec.information8
531: ,p_information9_o => per_spp_shd.g_old_rec.information9
532: ,p_information10_o => per_spp_shd.g_old_rec.information10
533: ,p_information11_o => per_spp_shd.g_old_rec.information11
534: ,p_information12_o => per_spp_shd.g_old_rec.information12
535: ,p_information13_o => per_spp_shd.g_old_rec.information13

Line 532: ,p_information10_o => per_spp_shd.g_old_rec.information10

528: ,p_information6_o => per_spp_shd.g_old_rec.information6
529: ,p_information7_o => per_spp_shd.g_old_rec.information7
530: ,p_information8_o => per_spp_shd.g_old_rec.information8
531: ,p_information9_o => per_spp_shd.g_old_rec.information9
532: ,p_information10_o => per_spp_shd.g_old_rec.information10
533: ,p_information11_o => per_spp_shd.g_old_rec.information11
534: ,p_information12_o => per_spp_shd.g_old_rec.information12
535: ,p_information13_o => per_spp_shd.g_old_rec.information13
536: ,p_information14_o => per_spp_shd.g_old_rec.information14

Line 533: ,p_information11_o => per_spp_shd.g_old_rec.information11

529: ,p_information7_o => per_spp_shd.g_old_rec.information7
530: ,p_information8_o => per_spp_shd.g_old_rec.information8
531: ,p_information9_o => per_spp_shd.g_old_rec.information9
532: ,p_information10_o => per_spp_shd.g_old_rec.information10
533: ,p_information11_o => per_spp_shd.g_old_rec.information11
534: ,p_information12_o => per_spp_shd.g_old_rec.information12
535: ,p_information13_o => per_spp_shd.g_old_rec.information13
536: ,p_information14_o => per_spp_shd.g_old_rec.information14
537: ,p_information15_o => per_spp_shd.g_old_rec.information15

Line 534: ,p_information12_o => per_spp_shd.g_old_rec.information12

530: ,p_information8_o => per_spp_shd.g_old_rec.information8
531: ,p_information9_o => per_spp_shd.g_old_rec.information9
532: ,p_information10_o => per_spp_shd.g_old_rec.information10
533: ,p_information11_o => per_spp_shd.g_old_rec.information11
534: ,p_information12_o => per_spp_shd.g_old_rec.information12
535: ,p_information13_o => per_spp_shd.g_old_rec.information13
536: ,p_information14_o => per_spp_shd.g_old_rec.information14
537: ,p_information15_o => per_spp_shd.g_old_rec.information15
538: ,p_information16_o => per_spp_shd.g_old_rec.information16

Line 535: ,p_information13_o => per_spp_shd.g_old_rec.information13

531: ,p_information9_o => per_spp_shd.g_old_rec.information9
532: ,p_information10_o => per_spp_shd.g_old_rec.information10
533: ,p_information11_o => per_spp_shd.g_old_rec.information11
534: ,p_information12_o => per_spp_shd.g_old_rec.information12
535: ,p_information13_o => per_spp_shd.g_old_rec.information13
536: ,p_information14_o => per_spp_shd.g_old_rec.information14
537: ,p_information15_o => per_spp_shd.g_old_rec.information15
538: ,p_information16_o => per_spp_shd.g_old_rec.information16
539: ,p_information17_o => per_spp_shd.g_old_rec.information17

Line 536: ,p_information14_o => per_spp_shd.g_old_rec.information14

532: ,p_information10_o => per_spp_shd.g_old_rec.information10
533: ,p_information11_o => per_spp_shd.g_old_rec.information11
534: ,p_information12_o => per_spp_shd.g_old_rec.information12
535: ,p_information13_o => per_spp_shd.g_old_rec.information13
536: ,p_information14_o => per_spp_shd.g_old_rec.information14
537: ,p_information15_o => per_spp_shd.g_old_rec.information15
538: ,p_information16_o => per_spp_shd.g_old_rec.information16
539: ,p_information17_o => per_spp_shd.g_old_rec.information17
540: ,p_information18_o => per_spp_shd.g_old_rec.information18

Line 537: ,p_information15_o => per_spp_shd.g_old_rec.information15

533: ,p_information11_o => per_spp_shd.g_old_rec.information11
534: ,p_information12_o => per_spp_shd.g_old_rec.information12
535: ,p_information13_o => per_spp_shd.g_old_rec.information13
536: ,p_information14_o => per_spp_shd.g_old_rec.information14
537: ,p_information15_o => per_spp_shd.g_old_rec.information15
538: ,p_information16_o => per_spp_shd.g_old_rec.information16
539: ,p_information17_o => per_spp_shd.g_old_rec.information17
540: ,p_information18_o => per_spp_shd.g_old_rec.information18
541: ,p_information19_o => per_spp_shd.g_old_rec.information19

Line 538: ,p_information16_o => per_spp_shd.g_old_rec.information16

534: ,p_information12_o => per_spp_shd.g_old_rec.information12
535: ,p_information13_o => per_spp_shd.g_old_rec.information13
536: ,p_information14_o => per_spp_shd.g_old_rec.information14
537: ,p_information15_o => per_spp_shd.g_old_rec.information15
538: ,p_information16_o => per_spp_shd.g_old_rec.information16
539: ,p_information17_o => per_spp_shd.g_old_rec.information17
540: ,p_information18_o => per_spp_shd.g_old_rec.information18
541: ,p_information19_o => per_spp_shd.g_old_rec.information19
542: ,p_information20_o => per_spp_shd.g_old_rec.information20

Line 539: ,p_information17_o => per_spp_shd.g_old_rec.information17

535: ,p_information13_o => per_spp_shd.g_old_rec.information13
536: ,p_information14_o => per_spp_shd.g_old_rec.information14
537: ,p_information15_o => per_spp_shd.g_old_rec.information15
538: ,p_information16_o => per_spp_shd.g_old_rec.information16
539: ,p_information17_o => per_spp_shd.g_old_rec.information17
540: ,p_information18_o => per_spp_shd.g_old_rec.information18
541: ,p_information19_o => per_spp_shd.g_old_rec.information19
542: ,p_information20_o => per_spp_shd.g_old_rec.information20
543: ,p_information21_o => per_spp_shd.g_old_rec.information21

Line 540: ,p_information18_o => per_spp_shd.g_old_rec.information18

536: ,p_information14_o => per_spp_shd.g_old_rec.information14
537: ,p_information15_o => per_spp_shd.g_old_rec.information15
538: ,p_information16_o => per_spp_shd.g_old_rec.information16
539: ,p_information17_o => per_spp_shd.g_old_rec.information17
540: ,p_information18_o => per_spp_shd.g_old_rec.information18
541: ,p_information19_o => per_spp_shd.g_old_rec.information19
542: ,p_information20_o => per_spp_shd.g_old_rec.information20
543: ,p_information21_o => per_spp_shd.g_old_rec.information21
544: ,p_information22_o => per_spp_shd.g_old_rec.information22

Line 541: ,p_information19_o => per_spp_shd.g_old_rec.information19

537: ,p_information15_o => per_spp_shd.g_old_rec.information15
538: ,p_information16_o => per_spp_shd.g_old_rec.information16
539: ,p_information17_o => per_spp_shd.g_old_rec.information17
540: ,p_information18_o => per_spp_shd.g_old_rec.information18
541: ,p_information19_o => per_spp_shd.g_old_rec.information19
542: ,p_information20_o => per_spp_shd.g_old_rec.information20
543: ,p_information21_o => per_spp_shd.g_old_rec.information21
544: ,p_information22_o => per_spp_shd.g_old_rec.information22
545: ,p_information23_o => per_spp_shd.g_old_rec.information23

Line 542: ,p_information20_o => per_spp_shd.g_old_rec.information20

538: ,p_information16_o => per_spp_shd.g_old_rec.information16
539: ,p_information17_o => per_spp_shd.g_old_rec.information17
540: ,p_information18_o => per_spp_shd.g_old_rec.information18
541: ,p_information19_o => per_spp_shd.g_old_rec.information19
542: ,p_information20_o => per_spp_shd.g_old_rec.information20
543: ,p_information21_o => per_spp_shd.g_old_rec.information21
544: ,p_information22_o => per_spp_shd.g_old_rec.information22
545: ,p_information23_o => per_spp_shd.g_old_rec.information23
546: ,p_information24_o => per_spp_shd.g_old_rec.information24

Line 543: ,p_information21_o => per_spp_shd.g_old_rec.information21

539: ,p_information17_o => per_spp_shd.g_old_rec.information17
540: ,p_information18_o => per_spp_shd.g_old_rec.information18
541: ,p_information19_o => per_spp_shd.g_old_rec.information19
542: ,p_information20_o => per_spp_shd.g_old_rec.information20
543: ,p_information21_o => per_spp_shd.g_old_rec.information21
544: ,p_information22_o => per_spp_shd.g_old_rec.information22
545: ,p_information23_o => per_spp_shd.g_old_rec.information23
546: ,p_information24_o => per_spp_shd.g_old_rec.information24
547: ,p_information25_o => per_spp_shd.g_old_rec.information25

Line 544: ,p_information22_o => per_spp_shd.g_old_rec.information22

540: ,p_information18_o => per_spp_shd.g_old_rec.information18
541: ,p_information19_o => per_spp_shd.g_old_rec.information19
542: ,p_information20_o => per_spp_shd.g_old_rec.information20
543: ,p_information21_o => per_spp_shd.g_old_rec.information21
544: ,p_information22_o => per_spp_shd.g_old_rec.information22
545: ,p_information23_o => per_spp_shd.g_old_rec.information23
546: ,p_information24_o => per_spp_shd.g_old_rec.information24
547: ,p_information25_o => per_spp_shd.g_old_rec.information25
548: ,p_information26_o => per_spp_shd.g_old_rec.information26

Line 545: ,p_information23_o => per_spp_shd.g_old_rec.information23

541: ,p_information19_o => per_spp_shd.g_old_rec.information19
542: ,p_information20_o => per_spp_shd.g_old_rec.information20
543: ,p_information21_o => per_spp_shd.g_old_rec.information21
544: ,p_information22_o => per_spp_shd.g_old_rec.information22
545: ,p_information23_o => per_spp_shd.g_old_rec.information23
546: ,p_information24_o => per_spp_shd.g_old_rec.information24
547: ,p_information25_o => per_spp_shd.g_old_rec.information25
548: ,p_information26_o => per_spp_shd.g_old_rec.information26
549: ,p_information27_o => per_spp_shd.g_old_rec.information27

Line 546: ,p_information24_o => per_spp_shd.g_old_rec.information24

542: ,p_information20_o => per_spp_shd.g_old_rec.information20
543: ,p_information21_o => per_spp_shd.g_old_rec.information21
544: ,p_information22_o => per_spp_shd.g_old_rec.information22
545: ,p_information23_o => per_spp_shd.g_old_rec.information23
546: ,p_information24_o => per_spp_shd.g_old_rec.information24
547: ,p_information25_o => per_spp_shd.g_old_rec.information25
548: ,p_information26_o => per_spp_shd.g_old_rec.information26
549: ,p_information27_o => per_spp_shd.g_old_rec.information27
550: ,p_information28_o => per_spp_shd.g_old_rec.information28

Line 547: ,p_information25_o => per_spp_shd.g_old_rec.information25

543: ,p_information21_o => per_spp_shd.g_old_rec.information21
544: ,p_information22_o => per_spp_shd.g_old_rec.information22
545: ,p_information23_o => per_spp_shd.g_old_rec.information23
546: ,p_information24_o => per_spp_shd.g_old_rec.information24
547: ,p_information25_o => per_spp_shd.g_old_rec.information25
548: ,p_information26_o => per_spp_shd.g_old_rec.information26
549: ,p_information27_o => per_spp_shd.g_old_rec.information27
550: ,p_information28_o => per_spp_shd.g_old_rec.information28
551: ,p_information29_o => per_spp_shd.g_old_rec.information29

Line 548: ,p_information26_o => per_spp_shd.g_old_rec.information26

544: ,p_information22_o => per_spp_shd.g_old_rec.information22
545: ,p_information23_o => per_spp_shd.g_old_rec.information23
546: ,p_information24_o => per_spp_shd.g_old_rec.information24
547: ,p_information25_o => per_spp_shd.g_old_rec.information25
548: ,p_information26_o => per_spp_shd.g_old_rec.information26
549: ,p_information27_o => per_spp_shd.g_old_rec.information27
550: ,p_information28_o => per_spp_shd.g_old_rec.information28
551: ,p_information29_o => per_spp_shd.g_old_rec.information29
552: ,p_information30_o => per_spp_shd.g_old_rec.information30

Line 549: ,p_information27_o => per_spp_shd.g_old_rec.information27

545: ,p_information23_o => per_spp_shd.g_old_rec.information23
546: ,p_information24_o => per_spp_shd.g_old_rec.information24
547: ,p_information25_o => per_spp_shd.g_old_rec.information25
548: ,p_information26_o => per_spp_shd.g_old_rec.information26
549: ,p_information27_o => per_spp_shd.g_old_rec.information27
550: ,p_information28_o => per_spp_shd.g_old_rec.information28
551: ,p_information29_o => per_spp_shd.g_old_rec.information29
552: ,p_information30_o => per_spp_shd.g_old_rec.information30
553: ,p_information_category_o => per_spp_shd.g_old_rec.information_category

Line 550: ,p_information28_o => per_spp_shd.g_old_rec.information28

546: ,p_information24_o => per_spp_shd.g_old_rec.information24
547: ,p_information25_o => per_spp_shd.g_old_rec.information25
548: ,p_information26_o => per_spp_shd.g_old_rec.information26
549: ,p_information27_o => per_spp_shd.g_old_rec.information27
550: ,p_information28_o => per_spp_shd.g_old_rec.information28
551: ,p_information29_o => per_spp_shd.g_old_rec.information29
552: ,p_information30_o => per_spp_shd.g_old_rec.information30
553: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
554: ,p_object_version_number_o

Line 551: ,p_information29_o => per_spp_shd.g_old_rec.information29

547: ,p_information25_o => per_spp_shd.g_old_rec.information25
548: ,p_information26_o => per_spp_shd.g_old_rec.information26
549: ,p_information27_o => per_spp_shd.g_old_rec.information27
550: ,p_information28_o => per_spp_shd.g_old_rec.information28
551: ,p_information29_o => per_spp_shd.g_old_rec.information29
552: ,p_information30_o => per_spp_shd.g_old_rec.information30
553: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
554: ,p_object_version_number_o
555: => per_spp_shd.g_old_rec.object_version_number

Line 552: ,p_information30_o => per_spp_shd.g_old_rec.information30

548: ,p_information26_o => per_spp_shd.g_old_rec.information26
549: ,p_information27_o => per_spp_shd.g_old_rec.information27
550: ,p_information28_o => per_spp_shd.g_old_rec.information28
551: ,p_information29_o => per_spp_shd.g_old_rec.information29
552: ,p_information30_o => per_spp_shd.g_old_rec.information30
553: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
554: ,p_object_version_number_o
555: => per_spp_shd.g_old_rec.object_version_number
556: );

Line 553: ,p_information_category_o => per_spp_shd.g_old_rec.information_category

549: ,p_information27_o => per_spp_shd.g_old_rec.information27
550: ,p_information28_o => per_spp_shd.g_old_rec.information28
551: ,p_information29_o => per_spp_shd.g_old_rec.information29
552: ,p_information30_o => per_spp_shd.g_old_rec.information30
553: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
554: ,p_object_version_number_o
555: => per_spp_shd.g_old_rec.object_version_number
556: );
557: --

Line 555: => per_spp_shd.g_old_rec.object_version_number

551: ,p_information29_o => per_spp_shd.g_old_rec.information29
552: ,p_information30_o => per_spp_shd.g_old_rec.information30
553: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
554: ,p_object_version_number_o
555: => per_spp_shd.g_old_rec.object_version_number
556: );
557: --
558: exception
559: --

Line 615: (p_rec in out nocopy per_spp_shd.g_rec_type

611: --
612: -- {End Of Comments}
613: -- ----------------------------------------------------------------------------
614: Procedure convert_defs
615: (p_rec in out nocopy per_spp_shd.g_rec_type
616: ) is
617: --
618: Begin
619: --

Line 627: per_spp_shd.g_old_rec.business_group_id;

623: -- is being used then we must set to the 'current' argument value.
624: --
625: If (p_rec.business_group_id = hr_api.g_number) then
626: p_rec.business_group_id :=
627: per_spp_shd.g_old_rec.business_group_id;
628: End If;
629: If (p_rec.assignment_id = hr_api.g_number) then
630: p_rec.assignment_id :=
631: per_spp_shd.g_old_rec.assignment_id;

Line 631: per_spp_shd.g_old_rec.assignment_id;

627: per_spp_shd.g_old_rec.business_group_id;
628: End If;
629: If (p_rec.assignment_id = hr_api.g_number) then
630: p_rec.assignment_id :=
631: per_spp_shd.g_old_rec.assignment_id;
632: End If;
633: If (p_rec.step_id = hr_api.g_number) then
634: p_rec.step_id :=
635: per_spp_shd.g_old_rec.step_id;

Line 635: per_spp_shd.g_old_rec.step_id;

631: per_spp_shd.g_old_rec.assignment_id;
632: End If;
633: If (p_rec.step_id = hr_api.g_number) then
634: p_rec.step_id :=
635: per_spp_shd.g_old_rec.step_id;
636: End If;
637: If (p_rec.auto_increment_flag = hr_api.g_varchar2) then
638: p_rec.auto_increment_flag :=
639: per_spp_shd.g_old_rec.auto_increment_flag;

Line 639: per_spp_shd.g_old_rec.auto_increment_flag;

635: per_spp_shd.g_old_rec.step_id;
636: End If;
637: If (p_rec.auto_increment_flag = hr_api.g_varchar2) then
638: p_rec.auto_increment_flag :=
639: per_spp_shd.g_old_rec.auto_increment_flag;
640: End If;
641: If (p_rec.parent_spine_id = hr_api.g_number) then
642: p_rec.parent_spine_id :=
643: per_spp_shd.g_old_rec.parent_spine_id;

Line 643: per_spp_shd.g_old_rec.parent_spine_id;

639: per_spp_shd.g_old_rec.auto_increment_flag;
640: End If;
641: If (p_rec.parent_spine_id = hr_api.g_number) then
642: p_rec.parent_spine_id :=
643: per_spp_shd.g_old_rec.parent_spine_id;
644: End If;
645: If (p_rec.reason = hr_api.g_varchar2) then
646: p_rec.reason :=
647: per_spp_shd.g_old_rec.reason;

Line 647: per_spp_shd.g_old_rec.reason;

643: per_spp_shd.g_old_rec.parent_spine_id;
644: End If;
645: If (p_rec.reason = hr_api.g_varchar2) then
646: p_rec.reason :=
647: per_spp_shd.g_old_rec.reason;
648: End If;
649: If (p_rec.request_id = hr_api.g_number) then
650: p_rec.request_id :=
651: per_spp_shd.g_old_rec.request_id;

Line 651: per_spp_shd.g_old_rec.request_id;

647: per_spp_shd.g_old_rec.reason;
648: End If;
649: If (p_rec.request_id = hr_api.g_number) then
650: p_rec.request_id :=
651: per_spp_shd.g_old_rec.request_id;
652: End If;
653: If (p_rec.program_application_id = hr_api.g_number) then
654: p_rec.program_application_id :=
655: per_spp_shd.g_old_rec.program_application_id;

Line 655: per_spp_shd.g_old_rec.program_application_id;

651: per_spp_shd.g_old_rec.request_id;
652: End If;
653: If (p_rec.program_application_id = hr_api.g_number) then
654: p_rec.program_application_id :=
655: per_spp_shd.g_old_rec.program_application_id;
656: End If;
657: If (p_rec.program_id = hr_api.g_number) then
658: p_rec.program_id :=
659: per_spp_shd.g_old_rec.program_id;

Line 659: per_spp_shd.g_old_rec.program_id;

655: per_spp_shd.g_old_rec.program_application_id;
656: End If;
657: If (p_rec.program_id = hr_api.g_number) then
658: p_rec.program_id :=
659: per_spp_shd.g_old_rec.program_id;
660: End If;
661: If (p_rec.program_update_date = hr_api.g_date) then
662: p_rec.program_update_date :=
663: per_spp_shd.g_old_rec.program_update_date;

Line 663: per_spp_shd.g_old_rec.program_update_date;

659: per_spp_shd.g_old_rec.program_id;
660: End If;
661: If (p_rec.program_update_date = hr_api.g_date) then
662: p_rec.program_update_date :=
663: per_spp_shd.g_old_rec.program_update_date;
664: End If;
665: If (p_rec.increment_number = hr_api.g_number) then
666: p_rec.increment_number :=
667: per_spp_shd.g_old_rec.increment_number;

Line 667: per_spp_shd.g_old_rec.increment_number;

663: per_spp_shd.g_old_rec.program_update_date;
664: End If;
665: If (p_rec.increment_number = hr_api.g_number) then
666: p_rec.increment_number :=
667: per_spp_shd.g_old_rec.increment_number;
668: End If;
669: If (p_rec.information1 = hr_api.g_varchar2) then
670: p_rec.information1 := per_spp_shd.g_old_rec.information1;
671: End If;

Line 670: p_rec.information1 := per_spp_shd.g_old_rec.information1;

666: p_rec.increment_number :=
667: per_spp_shd.g_old_rec.increment_number;
668: End If;
669: If (p_rec.information1 = hr_api.g_varchar2) then
670: p_rec.information1 := per_spp_shd.g_old_rec.information1;
671: End If;
672: If (p_rec.information2 = hr_api.g_varchar2) then
673: p_rec.information2 := per_spp_shd.g_old_rec.information2;
674: End If;

Line 673: p_rec.information2 := per_spp_shd.g_old_rec.information2;

669: If (p_rec.information1 = hr_api.g_varchar2) then
670: p_rec.information1 := per_spp_shd.g_old_rec.information1;
671: End If;
672: If (p_rec.information2 = hr_api.g_varchar2) then
673: p_rec.information2 := per_spp_shd.g_old_rec.information2;
674: End If;
675: If (p_rec.information3 = hr_api.g_varchar2) then
676: p_rec.information3 := per_spp_shd.g_old_rec.information3;
677: End If;

Line 676: p_rec.information3 := per_spp_shd.g_old_rec.information3;

672: If (p_rec.information2 = hr_api.g_varchar2) then
673: p_rec.information2 := per_spp_shd.g_old_rec.information2;
674: End If;
675: If (p_rec.information3 = hr_api.g_varchar2) then
676: p_rec.information3 := per_spp_shd.g_old_rec.information3;
677: End If;
678: If (p_rec.information3 = hr_api.g_varchar2) then
679: p_rec.information3 := per_spp_shd.g_old_rec.information3;
680: End If;

Line 679: p_rec.information3 := per_spp_shd.g_old_rec.information3;

675: If (p_rec.information3 = hr_api.g_varchar2) then
676: p_rec.information3 := per_spp_shd.g_old_rec.information3;
677: End If;
678: If (p_rec.information3 = hr_api.g_varchar2) then
679: p_rec.information3 := per_spp_shd.g_old_rec.information3;
680: End If;
681: If (p_rec.information4 = hr_api.g_varchar2) then
682: p_rec.information4 := per_spp_shd.g_old_rec.information4;
683: End If;

Line 682: p_rec.information4 := per_spp_shd.g_old_rec.information4;

678: If (p_rec.information3 = hr_api.g_varchar2) then
679: p_rec.information3 := per_spp_shd.g_old_rec.information3;
680: End If;
681: If (p_rec.information4 = hr_api.g_varchar2) then
682: p_rec.information4 := per_spp_shd.g_old_rec.information4;
683: End If;
684: If (p_rec.information5 = hr_api.g_varchar2) then
685: p_rec.information5 := per_spp_shd.g_old_rec.information5;
686: End If;

Line 685: p_rec.information5 := per_spp_shd.g_old_rec.information5;

681: If (p_rec.information4 = hr_api.g_varchar2) then
682: p_rec.information4 := per_spp_shd.g_old_rec.information4;
683: End If;
684: If (p_rec.information5 = hr_api.g_varchar2) then
685: p_rec.information5 := per_spp_shd.g_old_rec.information5;
686: End If;
687: If (p_rec.information6 = hr_api.g_varchar2) then
688: p_rec.information6 := per_spp_shd.g_old_rec.information6;
689: End If;

Line 688: p_rec.information6 := per_spp_shd.g_old_rec.information6;

684: If (p_rec.information5 = hr_api.g_varchar2) then
685: p_rec.information5 := per_spp_shd.g_old_rec.information5;
686: End If;
687: If (p_rec.information6 = hr_api.g_varchar2) then
688: p_rec.information6 := per_spp_shd.g_old_rec.information6;
689: End If;
690: If (p_rec.information7 = hr_api.g_varchar2) then
691: p_rec.information7 := per_spp_shd.g_old_rec.information7;
692: End If;

Line 691: p_rec.information7 := per_spp_shd.g_old_rec.information7;

687: If (p_rec.information6 = hr_api.g_varchar2) then
688: p_rec.information6 := per_spp_shd.g_old_rec.information6;
689: End If;
690: If (p_rec.information7 = hr_api.g_varchar2) then
691: p_rec.information7 := per_spp_shd.g_old_rec.information7;
692: End If;
693: If (p_rec.information8 = hr_api.g_varchar2) then
694: p_rec.information8 := per_spp_shd.g_old_rec.information8;
695: End If;

Line 694: p_rec.information8 := per_spp_shd.g_old_rec.information8;

690: If (p_rec.information7 = hr_api.g_varchar2) then
691: p_rec.information7 := per_spp_shd.g_old_rec.information7;
692: End If;
693: If (p_rec.information8 = hr_api.g_varchar2) then
694: p_rec.information8 := per_spp_shd.g_old_rec.information8;
695: End If;
696: If (p_rec.information9 = hr_api.g_varchar2) then
697: p_rec.information9 := per_spp_shd.g_old_rec.information9;
698: End If;

Line 697: p_rec.information9 := per_spp_shd.g_old_rec.information9;

693: If (p_rec.information8 = hr_api.g_varchar2) then
694: p_rec.information8 := per_spp_shd.g_old_rec.information8;
695: End If;
696: If (p_rec.information9 = hr_api.g_varchar2) then
697: p_rec.information9 := per_spp_shd.g_old_rec.information9;
698: End If;
699: If (p_rec.information10 = hr_api.g_varchar2) then
700: p_rec.information10 := per_spp_shd.g_old_rec.information10;
701: End If;

Line 700: p_rec.information10 := per_spp_shd.g_old_rec.information10;

696: If (p_rec.information9 = hr_api.g_varchar2) then
697: p_rec.information9 := per_spp_shd.g_old_rec.information9;
698: End If;
699: If (p_rec.information10 = hr_api.g_varchar2) then
700: p_rec.information10 := per_spp_shd.g_old_rec.information10;
701: End If;
702: If (p_rec.information11 = hr_api.g_varchar2) then
703: p_rec.information11 := per_spp_shd.g_old_rec.information11;
704: End If;

Line 703: p_rec.information11 := per_spp_shd.g_old_rec.information11;

699: If (p_rec.information10 = hr_api.g_varchar2) then
700: p_rec.information10 := per_spp_shd.g_old_rec.information10;
701: End If;
702: If (p_rec.information11 = hr_api.g_varchar2) then
703: p_rec.information11 := per_spp_shd.g_old_rec.information11;
704: End If;
705: If (p_rec.information12 = hr_api.g_varchar2) then
706: p_rec.information12 := per_spp_shd.g_old_rec.information12;
707: End If;

Line 706: p_rec.information12 := per_spp_shd.g_old_rec.information12;

702: If (p_rec.information11 = hr_api.g_varchar2) then
703: p_rec.information11 := per_spp_shd.g_old_rec.information11;
704: End If;
705: If (p_rec.information12 = hr_api.g_varchar2) then
706: p_rec.information12 := per_spp_shd.g_old_rec.information12;
707: End If;
708: If (p_rec.information13 = hr_api.g_varchar2) then
709: p_rec.information13 := per_spp_shd.g_old_rec.information13;
710: End If;

Line 709: p_rec.information13 := per_spp_shd.g_old_rec.information13;

705: If (p_rec.information12 = hr_api.g_varchar2) then
706: p_rec.information12 := per_spp_shd.g_old_rec.information12;
707: End If;
708: If (p_rec.information13 = hr_api.g_varchar2) then
709: p_rec.information13 := per_spp_shd.g_old_rec.information13;
710: End If;
711: If (p_rec.information14 = hr_api.g_varchar2) then
712: p_rec.information14 := per_spp_shd.g_old_rec.information14;
713: End If;

Line 712: p_rec.information14 := per_spp_shd.g_old_rec.information14;

708: If (p_rec.information13 = hr_api.g_varchar2) then
709: p_rec.information13 := per_spp_shd.g_old_rec.information13;
710: End If;
711: If (p_rec.information14 = hr_api.g_varchar2) then
712: p_rec.information14 := per_spp_shd.g_old_rec.information14;
713: End If;
714: If (p_rec.information15 = hr_api.g_varchar2) then
715: p_rec.information15 := per_spp_shd.g_old_rec.information15;
716: End If;

Line 715: p_rec.information15 := per_spp_shd.g_old_rec.information15;

711: If (p_rec.information14 = hr_api.g_varchar2) then
712: p_rec.information14 := per_spp_shd.g_old_rec.information14;
713: End If;
714: If (p_rec.information15 = hr_api.g_varchar2) then
715: p_rec.information15 := per_spp_shd.g_old_rec.information15;
716: End If;
717: If (p_rec.information16 = hr_api.g_varchar2) then
718: p_rec.information16 := per_spp_shd.g_old_rec.information16;
719: End If;

Line 718: p_rec.information16 := per_spp_shd.g_old_rec.information16;

714: If (p_rec.information15 = hr_api.g_varchar2) then
715: p_rec.information15 := per_spp_shd.g_old_rec.information15;
716: End If;
717: If (p_rec.information16 = hr_api.g_varchar2) then
718: p_rec.information16 := per_spp_shd.g_old_rec.information16;
719: End If;
720: If (p_rec.information17 = hr_api.g_varchar2) then
721: p_rec.information17 := per_spp_shd.g_old_rec.information17;
722: End If;

Line 721: p_rec.information17 := per_spp_shd.g_old_rec.information17;

717: If (p_rec.information16 = hr_api.g_varchar2) then
718: p_rec.information16 := per_spp_shd.g_old_rec.information16;
719: End If;
720: If (p_rec.information17 = hr_api.g_varchar2) then
721: p_rec.information17 := per_spp_shd.g_old_rec.information17;
722: End If;
723: If (p_rec.information18 = hr_api.g_varchar2) then
724: p_rec.information18 := per_spp_shd.g_old_rec.information18;
725: End If;

Line 724: p_rec.information18 := per_spp_shd.g_old_rec.information18;

720: If (p_rec.information17 = hr_api.g_varchar2) then
721: p_rec.information17 := per_spp_shd.g_old_rec.information17;
722: End If;
723: If (p_rec.information18 = hr_api.g_varchar2) then
724: p_rec.information18 := per_spp_shd.g_old_rec.information18;
725: End If;
726: If (p_rec.information19 = hr_api.g_varchar2) then
727: p_rec.information19 := per_spp_shd.g_old_rec.information19;
728: End If;

Line 727: p_rec.information19 := per_spp_shd.g_old_rec.information19;

723: If (p_rec.information18 = hr_api.g_varchar2) then
724: p_rec.information18 := per_spp_shd.g_old_rec.information18;
725: End If;
726: If (p_rec.information19 = hr_api.g_varchar2) then
727: p_rec.information19 := per_spp_shd.g_old_rec.information19;
728: End If;
729: If (p_rec.information20 = hr_api.g_varchar2) then
730: p_rec.information20 := per_spp_shd.g_old_rec.information20;
731: End If;

Line 730: p_rec.information20 := per_spp_shd.g_old_rec.information20;

726: If (p_rec.information19 = hr_api.g_varchar2) then
727: p_rec.information19 := per_spp_shd.g_old_rec.information19;
728: End If;
729: If (p_rec.information20 = hr_api.g_varchar2) then
730: p_rec.information20 := per_spp_shd.g_old_rec.information20;
731: End If;
732: If (p_rec.information21 = hr_api.g_varchar2) then
733: p_rec.information21 := per_spp_shd.g_old_rec.information21;
734: End If;

Line 733: p_rec.information21 := per_spp_shd.g_old_rec.information21;

729: If (p_rec.information20 = hr_api.g_varchar2) then
730: p_rec.information20 := per_spp_shd.g_old_rec.information20;
731: End If;
732: If (p_rec.information21 = hr_api.g_varchar2) then
733: p_rec.information21 := per_spp_shd.g_old_rec.information21;
734: End If;
735: If (p_rec.information22 = hr_api.g_varchar2) then
736: p_rec.information22 := per_spp_shd.g_old_rec.information22;
737: End If;

Line 736: p_rec.information22 := per_spp_shd.g_old_rec.information22;

732: If (p_rec.information21 = hr_api.g_varchar2) then
733: p_rec.information21 := per_spp_shd.g_old_rec.information21;
734: End If;
735: If (p_rec.information22 = hr_api.g_varchar2) then
736: p_rec.information22 := per_spp_shd.g_old_rec.information22;
737: End If;
738: If (p_rec.information23 = hr_api.g_varchar2) then
739: p_rec.information23 := per_spp_shd.g_old_rec.information23;
740: End If;

Line 739: p_rec.information23 := per_spp_shd.g_old_rec.information23;

735: If (p_rec.information22 = hr_api.g_varchar2) then
736: p_rec.information22 := per_spp_shd.g_old_rec.information22;
737: End If;
738: If (p_rec.information23 = hr_api.g_varchar2) then
739: p_rec.information23 := per_spp_shd.g_old_rec.information23;
740: End If;
741: If (p_rec.information24 = hr_api.g_varchar2) then
742: p_rec.information24 := per_spp_shd.g_old_rec.information24;
743: End If;

Line 742: p_rec.information24 := per_spp_shd.g_old_rec.information24;

738: If (p_rec.information23 = hr_api.g_varchar2) then
739: p_rec.information23 := per_spp_shd.g_old_rec.information23;
740: End If;
741: If (p_rec.information24 = hr_api.g_varchar2) then
742: p_rec.information24 := per_spp_shd.g_old_rec.information24;
743: End If;
744: If (p_rec.information25 = hr_api.g_varchar2) then
745: p_rec.information25 := per_spp_shd.g_old_rec.information25;
746: End If;

Line 745: p_rec.information25 := per_spp_shd.g_old_rec.information25;

741: If (p_rec.information24 = hr_api.g_varchar2) then
742: p_rec.information24 := per_spp_shd.g_old_rec.information24;
743: End If;
744: If (p_rec.information25 = hr_api.g_varchar2) then
745: p_rec.information25 := per_spp_shd.g_old_rec.information25;
746: End If;
747: If (p_rec.information26 = hr_api.g_varchar2) then
748: p_rec.information26 := per_spp_shd.g_old_rec.information26;
749: End If;

Line 748: p_rec.information26 := per_spp_shd.g_old_rec.information26;

744: If (p_rec.information25 = hr_api.g_varchar2) then
745: p_rec.information25 := per_spp_shd.g_old_rec.information25;
746: End If;
747: If (p_rec.information26 = hr_api.g_varchar2) then
748: p_rec.information26 := per_spp_shd.g_old_rec.information26;
749: End If;
750: If (p_rec.information27 = hr_api.g_varchar2) then
751: p_rec.information27 := per_spp_shd.g_old_rec.information27;
752: End If;

Line 751: p_rec.information27 := per_spp_shd.g_old_rec.information27;

747: If (p_rec.information26 = hr_api.g_varchar2) then
748: p_rec.information26 := per_spp_shd.g_old_rec.information26;
749: End If;
750: If (p_rec.information27 = hr_api.g_varchar2) then
751: p_rec.information27 := per_spp_shd.g_old_rec.information27;
752: End If;
753: If (p_rec.information28 = hr_api.g_varchar2) then
754: p_rec.information28 := per_spp_shd.g_old_rec.information28;
755: End If;

Line 754: p_rec.information28 := per_spp_shd.g_old_rec.information28;

750: If (p_rec.information27 = hr_api.g_varchar2) then
751: p_rec.information27 := per_spp_shd.g_old_rec.information27;
752: End If;
753: If (p_rec.information28 = hr_api.g_varchar2) then
754: p_rec.information28 := per_spp_shd.g_old_rec.information28;
755: End If;
756: If (p_rec.information29 = hr_api.g_varchar2) then
757: p_rec.information29 := per_spp_shd.g_old_rec.information29;
758: End If;

Line 757: p_rec.information29 := per_spp_shd.g_old_rec.information29;

753: If (p_rec.information28 = hr_api.g_varchar2) then
754: p_rec.information28 := per_spp_shd.g_old_rec.information28;
755: End If;
756: If (p_rec.information29 = hr_api.g_varchar2) then
757: p_rec.information29 := per_spp_shd.g_old_rec.information29;
758: End If;
759: If (p_rec.information30 = hr_api.g_varchar2) then
760: p_rec.information30 := per_spp_shd.g_old_rec.information30;
761: End If;

Line 760: p_rec.information30 := per_spp_shd.g_old_rec.information30;

756: If (p_rec.information29 = hr_api.g_varchar2) then
757: p_rec.information29 := per_spp_shd.g_old_rec.information29;
758: End If;
759: If (p_rec.information30 = hr_api.g_varchar2) then
760: p_rec.information30 := per_spp_shd.g_old_rec.information30;
761: End If;
762: If (p_rec.information_category = hr_api.g_varchar2) then
763: p_rec.information_category := per_spp_shd.g_old_rec.information_category;
764: End If;

Line 763: p_rec.information_category := per_spp_shd.g_old_rec.information_category;

759: If (p_rec.information30 = hr_api.g_varchar2) then
760: p_rec.information30 := per_spp_shd.g_old_rec.information30;
761: End If;
762: If (p_rec.information_category = hr_api.g_varchar2) then
763: p_rec.information_category := per_spp_shd.g_old_rec.information_category;
764: End If;
765: --
766: End convert_defs;
767: --

Line 774: ,p_rec in out nocopy per_spp_shd.g_rec_type

770: -- ----------------------------------------------------------------------------
771: Procedure upd
772: (p_effective_date in date
773: ,p_datetrack_mode in out nocopy varchar2
774: ,p_rec in out nocopy per_spp_shd.g_rec_type
775: ) is
776: --
777: l_proc varchar2(72) := g_package||'upd';
778: l_validation_start_date date;

Line 792: per_spp_shd.lck

788: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
789: --
790: -- We must lock the row which we need to update.
791: --
792: per_spp_shd.lck
793: (p_effective_date => p_effective_date
794: ,p_datetrack_mode => p_datetrack_mode
795: ,p_placement_id => p_rec.placement_id
796: ,p_object_version_number => p_rec.object_version_number

Line 904: l_rec per_spp_shd.g_rec_type;

900: ,p_effective_start_date in out nocopy date
901: ,p_effective_end_date in out nocopy date
902: ) is
903: --
904: l_rec per_spp_shd.g_rec_type;
905: l_proc varchar2(72) := g_package||'upd';
906: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
907: --
908: Begin

Line 932: per_spp_shd.convert_args

928: -- Call conversion function to turn arguments into the
929: -- l_rec structure.
930: --
931: l_rec :=
932: per_spp_shd.convert_args
933: (p_placement_id
934: ,p_effective_start_date
935: ,p_effective_end_date
936: ,p_business_group_id