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 545: => per_spp_shd.g_old_rec.effective_start_date

541: ,p_information_category => p_rec.information_category
542: ,p_object_version_number
543: => p_rec.object_version_number
544: ,p_effective_start_date_o
545: => per_spp_shd.g_old_rec.effective_start_date
546: ,p_effective_end_date_o
547: => per_spp_shd.g_old_rec.effective_end_date
548: ,p_business_group_id_o
549: => per_spp_shd.g_old_rec.business_group_id

Line 547: => per_spp_shd.g_old_rec.effective_end_date

543: => p_rec.object_version_number
544: ,p_effective_start_date_o
545: => per_spp_shd.g_old_rec.effective_start_date
546: ,p_effective_end_date_o
547: => per_spp_shd.g_old_rec.effective_end_date
548: ,p_business_group_id_o
549: => per_spp_shd.g_old_rec.business_group_id
550: ,p_assignment_id_o
551: => per_spp_shd.g_old_rec.assignment_id

Line 549: => per_spp_shd.g_old_rec.business_group_id

545: => per_spp_shd.g_old_rec.effective_start_date
546: ,p_effective_end_date_o
547: => per_spp_shd.g_old_rec.effective_end_date
548: ,p_business_group_id_o
549: => per_spp_shd.g_old_rec.business_group_id
550: ,p_assignment_id_o
551: => per_spp_shd.g_old_rec.assignment_id
552: ,p_step_id_o
553: => per_spp_shd.g_old_rec.step_id

Line 551: => per_spp_shd.g_old_rec.assignment_id

547: => per_spp_shd.g_old_rec.effective_end_date
548: ,p_business_group_id_o
549: => per_spp_shd.g_old_rec.business_group_id
550: ,p_assignment_id_o
551: => per_spp_shd.g_old_rec.assignment_id
552: ,p_step_id_o
553: => per_spp_shd.g_old_rec.step_id
554: ,p_auto_increment_flag_o
555: => per_spp_shd.g_old_rec.auto_increment_flag

Line 553: => per_spp_shd.g_old_rec.step_id

549: => per_spp_shd.g_old_rec.business_group_id
550: ,p_assignment_id_o
551: => per_spp_shd.g_old_rec.assignment_id
552: ,p_step_id_o
553: => per_spp_shd.g_old_rec.step_id
554: ,p_auto_increment_flag_o
555: => per_spp_shd.g_old_rec.auto_increment_flag
556: ,p_parent_spine_id_o
557: => per_spp_shd.g_old_rec.parent_spine_id

Line 555: => per_spp_shd.g_old_rec.auto_increment_flag

551: => per_spp_shd.g_old_rec.assignment_id
552: ,p_step_id_o
553: => per_spp_shd.g_old_rec.step_id
554: ,p_auto_increment_flag_o
555: => per_spp_shd.g_old_rec.auto_increment_flag
556: ,p_parent_spine_id_o
557: => per_spp_shd.g_old_rec.parent_spine_id
558: ,p_reason_o
559: => per_spp_shd.g_old_rec.reason

Line 557: => per_spp_shd.g_old_rec.parent_spine_id

553: => per_spp_shd.g_old_rec.step_id
554: ,p_auto_increment_flag_o
555: => per_spp_shd.g_old_rec.auto_increment_flag
556: ,p_parent_spine_id_o
557: => per_spp_shd.g_old_rec.parent_spine_id
558: ,p_reason_o
559: => per_spp_shd.g_old_rec.reason
560: ,p_request_id_o
561: => per_spp_shd.g_old_rec.request_id

Line 559: => per_spp_shd.g_old_rec.reason

555: => per_spp_shd.g_old_rec.auto_increment_flag
556: ,p_parent_spine_id_o
557: => per_spp_shd.g_old_rec.parent_spine_id
558: ,p_reason_o
559: => per_spp_shd.g_old_rec.reason
560: ,p_request_id_o
561: => per_spp_shd.g_old_rec.request_id
562: ,p_program_application_id_o
563: => per_spp_shd.g_old_rec.program_application_id

Line 561: => per_spp_shd.g_old_rec.request_id

557: => per_spp_shd.g_old_rec.parent_spine_id
558: ,p_reason_o
559: => per_spp_shd.g_old_rec.reason
560: ,p_request_id_o
561: => per_spp_shd.g_old_rec.request_id
562: ,p_program_application_id_o
563: => per_spp_shd.g_old_rec.program_application_id
564: ,p_program_id_o
565: => per_spp_shd.g_old_rec.program_id

Line 563: => per_spp_shd.g_old_rec.program_application_id

559: => per_spp_shd.g_old_rec.reason
560: ,p_request_id_o
561: => per_spp_shd.g_old_rec.request_id
562: ,p_program_application_id_o
563: => per_spp_shd.g_old_rec.program_application_id
564: ,p_program_id_o
565: => per_spp_shd.g_old_rec.program_id
566: ,p_program_update_date_o
567: => per_spp_shd.g_old_rec.program_update_date

Line 565: => per_spp_shd.g_old_rec.program_id

561: => per_spp_shd.g_old_rec.request_id
562: ,p_program_application_id_o
563: => per_spp_shd.g_old_rec.program_application_id
564: ,p_program_id_o
565: => per_spp_shd.g_old_rec.program_id
566: ,p_program_update_date_o
567: => per_spp_shd.g_old_rec.program_update_date
568: ,p_increment_number_o
569: => per_spp_shd.g_old_rec.increment_number

Line 567: => per_spp_shd.g_old_rec.program_update_date

563: => per_spp_shd.g_old_rec.program_application_id
564: ,p_program_id_o
565: => per_spp_shd.g_old_rec.program_id
566: ,p_program_update_date_o
567: => per_spp_shd.g_old_rec.program_update_date
568: ,p_increment_number_o
569: => per_spp_shd.g_old_rec.increment_number
570: ,p_information1_o => per_spp_shd.g_old_rec.information1
571: ,p_information2_o => per_spp_shd.g_old_rec.information2

Line 569: => per_spp_shd.g_old_rec.increment_number

565: => per_spp_shd.g_old_rec.program_id
566: ,p_program_update_date_o
567: => per_spp_shd.g_old_rec.program_update_date
568: ,p_increment_number_o
569: => per_spp_shd.g_old_rec.increment_number
570: ,p_information1_o => per_spp_shd.g_old_rec.information1
571: ,p_information2_o => per_spp_shd.g_old_rec.information2
572: ,p_information3_o => per_spp_shd.g_old_rec.information3
573: ,p_information4_o => per_spp_shd.g_old_rec.information4

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

566: ,p_program_update_date_o
567: => per_spp_shd.g_old_rec.program_update_date
568: ,p_increment_number_o
569: => per_spp_shd.g_old_rec.increment_number
570: ,p_information1_o => per_spp_shd.g_old_rec.information1
571: ,p_information2_o => per_spp_shd.g_old_rec.information2
572: ,p_information3_o => per_spp_shd.g_old_rec.information3
573: ,p_information4_o => per_spp_shd.g_old_rec.information4
574: ,p_information5_o => per_spp_shd.g_old_rec.information5

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

567: => per_spp_shd.g_old_rec.program_update_date
568: ,p_increment_number_o
569: => per_spp_shd.g_old_rec.increment_number
570: ,p_information1_o => per_spp_shd.g_old_rec.information1
571: ,p_information2_o => per_spp_shd.g_old_rec.information2
572: ,p_information3_o => per_spp_shd.g_old_rec.information3
573: ,p_information4_o => per_spp_shd.g_old_rec.information4
574: ,p_information5_o => per_spp_shd.g_old_rec.information5
575: ,p_information6_o => per_spp_shd.g_old_rec.information6

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

568: ,p_increment_number_o
569: => per_spp_shd.g_old_rec.increment_number
570: ,p_information1_o => per_spp_shd.g_old_rec.information1
571: ,p_information2_o => per_spp_shd.g_old_rec.information2
572: ,p_information3_o => per_spp_shd.g_old_rec.information3
573: ,p_information4_o => per_spp_shd.g_old_rec.information4
574: ,p_information5_o => per_spp_shd.g_old_rec.information5
575: ,p_information6_o => per_spp_shd.g_old_rec.information6
576: ,p_information7_o => per_spp_shd.g_old_rec.information7

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

569: => per_spp_shd.g_old_rec.increment_number
570: ,p_information1_o => per_spp_shd.g_old_rec.information1
571: ,p_information2_o => per_spp_shd.g_old_rec.information2
572: ,p_information3_o => per_spp_shd.g_old_rec.information3
573: ,p_information4_o => per_spp_shd.g_old_rec.information4
574: ,p_information5_o => per_spp_shd.g_old_rec.information5
575: ,p_information6_o => per_spp_shd.g_old_rec.information6
576: ,p_information7_o => per_spp_shd.g_old_rec.information7
577: ,p_information8_o => per_spp_shd.g_old_rec.information8

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

570: ,p_information1_o => per_spp_shd.g_old_rec.information1
571: ,p_information2_o => per_spp_shd.g_old_rec.information2
572: ,p_information3_o => per_spp_shd.g_old_rec.information3
573: ,p_information4_o => per_spp_shd.g_old_rec.information4
574: ,p_information5_o => per_spp_shd.g_old_rec.information5
575: ,p_information6_o => per_spp_shd.g_old_rec.information6
576: ,p_information7_o => per_spp_shd.g_old_rec.information7
577: ,p_information8_o => per_spp_shd.g_old_rec.information8
578: ,p_information9_o => per_spp_shd.g_old_rec.information9

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

571: ,p_information2_o => per_spp_shd.g_old_rec.information2
572: ,p_information3_o => per_spp_shd.g_old_rec.information3
573: ,p_information4_o => per_spp_shd.g_old_rec.information4
574: ,p_information5_o => per_spp_shd.g_old_rec.information5
575: ,p_information6_o => per_spp_shd.g_old_rec.information6
576: ,p_information7_o => per_spp_shd.g_old_rec.information7
577: ,p_information8_o => per_spp_shd.g_old_rec.information8
578: ,p_information9_o => per_spp_shd.g_old_rec.information9
579: ,p_information10_o => per_spp_shd.g_old_rec.information10

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

572: ,p_information3_o => per_spp_shd.g_old_rec.information3
573: ,p_information4_o => per_spp_shd.g_old_rec.information4
574: ,p_information5_o => per_spp_shd.g_old_rec.information5
575: ,p_information6_o => per_spp_shd.g_old_rec.information6
576: ,p_information7_o => per_spp_shd.g_old_rec.information7
577: ,p_information8_o => per_spp_shd.g_old_rec.information8
578: ,p_information9_o => per_spp_shd.g_old_rec.information9
579: ,p_information10_o => per_spp_shd.g_old_rec.information10
580: ,p_information11_o => per_spp_shd.g_old_rec.information11

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

573: ,p_information4_o => per_spp_shd.g_old_rec.information4
574: ,p_information5_o => per_spp_shd.g_old_rec.information5
575: ,p_information6_o => per_spp_shd.g_old_rec.information6
576: ,p_information7_o => per_spp_shd.g_old_rec.information7
577: ,p_information8_o => per_spp_shd.g_old_rec.information8
578: ,p_information9_o => per_spp_shd.g_old_rec.information9
579: ,p_information10_o => per_spp_shd.g_old_rec.information10
580: ,p_information11_o => per_spp_shd.g_old_rec.information11
581: ,p_information12_o => per_spp_shd.g_old_rec.information12

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

574: ,p_information5_o => per_spp_shd.g_old_rec.information5
575: ,p_information6_o => per_spp_shd.g_old_rec.information6
576: ,p_information7_o => per_spp_shd.g_old_rec.information7
577: ,p_information8_o => per_spp_shd.g_old_rec.information8
578: ,p_information9_o => per_spp_shd.g_old_rec.information9
579: ,p_information10_o => per_spp_shd.g_old_rec.information10
580: ,p_information11_o => per_spp_shd.g_old_rec.information11
581: ,p_information12_o => per_spp_shd.g_old_rec.information12
582: ,p_information13_o => per_spp_shd.g_old_rec.information13

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

575: ,p_information6_o => per_spp_shd.g_old_rec.information6
576: ,p_information7_o => per_spp_shd.g_old_rec.information7
577: ,p_information8_o => per_spp_shd.g_old_rec.information8
578: ,p_information9_o => per_spp_shd.g_old_rec.information9
579: ,p_information10_o => per_spp_shd.g_old_rec.information10
580: ,p_information11_o => per_spp_shd.g_old_rec.information11
581: ,p_information12_o => per_spp_shd.g_old_rec.information12
582: ,p_information13_o => per_spp_shd.g_old_rec.information13
583: ,p_information14_o => per_spp_shd.g_old_rec.information14

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

576: ,p_information7_o => per_spp_shd.g_old_rec.information7
577: ,p_information8_o => per_spp_shd.g_old_rec.information8
578: ,p_information9_o => per_spp_shd.g_old_rec.information9
579: ,p_information10_o => per_spp_shd.g_old_rec.information10
580: ,p_information11_o => per_spp_shd.g_old_rec.information11
581: ,p_information12_o => per_spp_shd.g_old_rec.information12
582: ,p_information13_o => per_spp_shd.g_old_rec.information13
583: ,p_information14_o => per_spp_shd.g_old_rec.information14
584: ,p_information15_o => per_spp_shd.g_old_rec.information15

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

577: ,p_information8_o => per_spp_shd.g_old_rec.information8
578: ,p_information9_o => per_spp_shd.g_old_rec.information9
579: ,p_information10_o => per_spp_shd.g_old_rec.information10
580: ,p_information11_o => per_spp_shd.g_old_rec.information11
581: ,p_information12_o => per_spp_shd.g_old_rec.information12
582: ,p_information13_o => per_spp_shd.g_old_rec.information13
583: ,p_information14_o => per_spp_shd.g_old_rec.information14
584: ,p_information15_o => per_spp_shd.g_old_rec.information15
585: ,p_information16_o => per_spp_shd.g_old_rec.information16

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

578: ,p_information9_o => per_spp_shd.g_old_rec.information9
579: ,p_information10_o => per_spp_shd.g_old_rec.information10
580: ,p_information11_o => per_spp_shd.g_old_rec.information11
581: ,p_information12_o => per_spp_shd.g_old_rec.information12
582: ,p_information13_o => per_spp_shd.g_old_rec.information13
583: ,p_information14_o => per_spp_shd.g_old_rec.information14
584: ,p_information15_o => per_spp_shd.g_old_rec.information15
585: ,p_information16_o => per_spp_shd.g_old_rec.information16
586: ,p_information17_o => per_spp_shd.g_old_rec.information17

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

579: ,p_information10_o => per_spp_shd.g_old_rec.information10
580: ,p_information11_o => per_spp_shd.g_old_rec.information11
581: ,p_information12_o => per_spp_shd.g_old_rec.information12
582: ,p_information13_o => per_spp_shd.g_old_rec.information13
583: ,p_information14_o => per_spp_shd.g_old_rec.information14
584: ,p_information15_o => per_spp_shd.g_old_rec.information15
585: ,p_information16_o => per_spp_shd.g_old_rec.information16
586: ,p_information17_o => per_spp_shd.g_old_rec.information17
587: ,p_information18_o => per_spp_shd.g_old_rec.information18

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

580: ,p_information11_o => per_spp_shd.g_old_rec.information11
581: ,p_information12_o => per_spp_shd.g_old_rec.information12
582: ,p_information13_o => per_spp_shd.g_old_rec.information13
583: ,p_information14_o => per_spp_shd.g_old_rec.information14
584: ,p_information15_o => per_spp_shd.g_old_rec.information15
585: ,p_information16_o => per_spp_shd.g_old_rec.information16
586: ,p_information17_o => per_spp_shd.g_old_rec.information17
587: ,p_information18_o => per_spp_shd.g_old_rec.information18
588: ,p_information19_o => per_spp_shd.g_old_rec.information19

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

581: ,p_information12_o => per_spp_shd.g_old_rec.information12
582: ,p_information13_o => per_spp_shd.g_old_rec.information13
583: ,p_information14_o => per_spp_shd.g_old_rec.information14
584: ,p_information15_o => per_spp_shd.g_old_rec.information15
585: ,p_information16_o => per_spp_shd.g_old_rec.information16
586: ,p_information17_o => per_spp_shd.g_old_rec.information17
587: ,p_information18_o => per_spp_shd.g_old_rec.information18
588: ,p_information19_o => per_spp_shd.g_old_rec.information19
589: ,p_information20_o => per_spp_shd.g_old_rec.information20

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

582: ,p_information13_o => per_spp_shd.g_old_rec.information13
583: ,p_information14_o => per_spp_shd.g_old_rec.information14
584: ,p_information15_o => per_spp_shd.g_old_rec.information15
585: ,p_information16_o => per_spp_shd.g_old_rec.information16
586: ,p_information17_o => per_spp_shd.g_old_rec.information17
587: ,p_information18_o => per_spp_shd.g_old_rec.information18
588: ,p_information19_o => per_spp_shd.g_old_rec.information19
589: ,p_information20_o => per_spp_shd.g_old_rec.information20
590: ,p_information21_o => per_spp_shd.g_old_rec.information21

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

583: ,p_information14_o => per_spp_shd.g_old_rec.information14
584: ,p_information15_o => per_spp_shd.g_old_rec.information15
585: ,p_information16_o => per_spp_shd.g_old_rec.information16
586: ,p_information17_o => per_spp_shd.g_old_rec.information17
587: ,p_information18_o => per_spp_shd.g_old_rec.information18
588: ,p_information19_o => per_spp_shd.g_old_rec.information19
589: ,p_information20_o => per_spp_shd.g_old_rec.information20
590: ,p_information21_o => per_spp_shd.g_old_rec.information21
591: ,p_information22_o => per_spp_shd.g_old_rec.information22

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

584: ,p_information15_o => per_spp_shd.g_old_rec.information15
585: ,p_information16_o => per_spp_shd.g_old_rec.information16
586: ,p_information17_o => per_spp_shd.g_old_rec.information17
587: ,p_information18_o => per_spp_shd.g_old_rec.information18
588: ,p_information19_o => per_spp_shd.g_old_rec.information19
589: ,p_information20_o => per_spp_shd.g_old_rec.information20
590: ,p_information21_o => per_spp_shd.g_old_rec.information21
591: ,p_information22_o => per_spp_shd.g_old_rec.information22
592: ,p_information23_o => per_spp_shd.g_old_rec.information23

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

585: ,p_information16_o => per_spp_shd.g_old_rec.information16
586: ,p_information17_o => per_spp_shd.g_old_rec.information17
587: ,p_information18_o => per_spp_shd.g_old_rec.information18
588: ,p_information19_o => per_spp_shd.g_old_rec.information19
589: ,p_information20_o => per_spp_shd.g_old_rec.information20
590: ,p_information21_o => per_spp_shd.g_old_rec.information21
591: ,p_information22_o => per_spp_shd.g_old_rec.information22
592: ,p_information23_o => per_spp_shd.g_old_rec.information23
593: ,p_information24_o => per_spp_shd.g_old_rec.information24

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

586: ,p_information17_o => per_spp_shd.g_old_rec.information17
587: ,p_information18_o => per_spp_shd.g_old_rec.information18
588: ,p_information19_o => per_spp_shd.g_old_rec.information19
589: ,p_information20_o => per_spp_shd.g_old_rec.information20
590: ,p_information21_o => per_spp_shd.g_old_rec.information21
591: ,p_information22_o => per_spp_shd.g_old_rec.information22
592: ,p_information23_o => per_spp_shd.g_old_rec.information23
593: ,p_information24_o => per_spp_shd.g_old_rec.information24
594: ,p_information25_o => per_spp_shd.g_old_rec.information25

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

587: ,p_information18_o => per_spp_shd.g_old_rec.information18
588: ,p_information19_o => per_spp_shd.g_old_rec.information19
589: ,p_information20_o => per_spp_shd.g_old_rec.information20
590: ,p_information21_o => per_spp_shd.g_old_rec.information21
591: ,p_information22_o => per_spp_shd.g_old_rec.information22
592: ,p_information23_o => per_spp_shd.g_old_rec.information23
593: ,p_information24_o => per_spp_shd.g_old_rec.information24
594: ,p_information25_o => per_spp_shd.g_old_rec.information25
595: ,p_information26_o => per_spp_shd.g_old_rec.information26

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

588: ,p_information19_o => per_spp_shd.g_old_rec.information19
589: ,p_information20_o => per_spp_shd.g_old_rec.information20
590: ,p_information21_o => per_spp_shd.g_old_rec.information21
591: ,p_information22_o => per_spp_shd.g_old_rec.information22
592: ,p_information23_o => per_spp_shd.g_old_rec.information23
593: ,p_information24_o => per_spp_shd.g_old_rec.information24
594: ,p_information25_o => per_spp_shd.g_old_rec.information25
595: ,p_information26_o => per_spp_shd.g_old_rec.information26
596: ,p_information27_o => per_spp_shd.g_old_rec.information27

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

589: ,p_information20_o => per_spp_shd.g_old_rec.information20
590: ,p_information21_o => per_spp_shd.g_old_rec.information21
591: ,p_information22_o => per_spp_shd.g_old_rec.information22
592: ,p_information23_o => per_spp_shd.g_old_rec.information23
593: ,p_information24_o => per_spp_shd.g_old_rec.information24
594: ,p_information25_o => per_spp_shd.g_old_rec.information25
595: ,p_information26_o => per_spp_shd.g_old_rec.information26
596: ,p_information27_o => per_spp_shd.g_old_rec.information27
597: ,p_information28_o => per_spp_shd.g_old_rec.information28

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

590: ,p_information21_o => per_spp_shd.g_old_rec.information21
591: ,p_information22_o => per_spp_shd.g_old_rec.information22
592: ,p_information23_o => per_spp_shd.g_old_rec.information23
593: ,p_information24_o => per_spp_shd.g_old_rec.information24
594: ,p_information25_o => per_spp_shd.g_old_rec.information25
595: ,p_information26_o => per_spp_shd.g_old_rec.information26
596: ,p_information27_o => per_spp_shd.g_old_rec.information27
597: ,p_information28_o => per_spp_shd.g_old_rec.information28
598: ,p_information29_o => per_spp_shd.g_old_rec.information29

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

591: ,p_information22_o => per_spp_shd.g_old_rec.information22
592: ,p_information23_o => per_spp_shd.g_old_rec.information23
593: ,p_information24_o => per_spp_shd.g_old_rec.information24
594: ,p_information25_o => per_spp_shd.g_old_rec.information25
595: ,p_information26_o => per_spp_shd.g_old_rec.information26
596: ,p_information27_o => per_spp_shd.g_old_rec.information27
597: ,p_information28_o => per_spp_shd.g_old_rec.information28
598: ,p_information29_o => per_spp_shd.g_old_rec.information29
599: ,p_information30_o => per_spp_shd.g_old_rec.information30

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

592: ,p_information23_o => per_spp_shd.g_old_rec.information23
593: ,p_information24_o => per_spp_shd.g_old_rec.information24
594: ,p_information25_o => per_spp_shd.g_old_rec.information25
595: ,p_information26_o => per_spp_shd.g_old_rec.information26
596: ,p_information27_o => per_spp_shd.g_old_rec.information27
597: ,p_information28_o => per_spp_shd.g_old_rec.information28
598: ,p_information29_o => per_spp_shd.g_old_rec.information29
599: ,p_information30_o => per_spp_shd.g_old_rec.information30
600: ,p_information_category_o => per_spp_shd.g_old_rec.information_category

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

593: ,p_information24_o => per_spp_shd.g_old_rec.information24
594: ,p_information25_o => per_spp_shd.g_old_rec.information25
595: ,p_information26_o => per_spp_shd.g_old_rec.information26
596: ,p_information27_o => per_spp_shd.g_old_rec.information27
597: ,p_information28_o => per_spp_shd.g_old_rec.information28
598: ,p_information29_o => per_spp_shd.g_old_rec.information29
599: ,p_information30_o => per_spp_shd.g_old_rec.information30
600: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
601: ,p_object_version_number_o

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

594: ,p_information25_o => per_spp_shd.g_old_rec.information25
595: ,p_information26_o => per_spp_shd.g_old_rec.information26
596: ,p_information27_o => per_spp_shd.g_old_rec.information27
597: ,p_information28_o => per_spp_shd.g_old_rec.information28
598: ,p_information29_o => per_spp_shd.g_old_rec.information29
599: ,p_information30_o => per_spp_shd.g_old_rec.information30
600: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
601: ,p_object_version_number_o
602: => per_spp_shd.g_old_rec.object_version_number

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

595: ,p_information26_o => per_spp_shd.g_old_rec.information26
596: ,p_information27_o => per_spp_shd.g_old_rec.information27
597: ,p_information28_o => per_spp_shd.g_old_rec.information28
598: ,p_information29_o => per_spp_shd.g_old_rec.information29
599: ,p_information30_o => per_spp_shd.g_old_rec.information30
600: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
601: ,p_object_version_number_o
602: => per_spp_shd.g_old_rec.object_version_number
603: );

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

596: ,p_information27_o => per_spp_shd.g_old_rec.information27
597: ,p_information28_o => per_spp_shd.g_old_rec.information28
598: ,p_information29_o => per_spp_shd.g_old_rec.information29
599: ,p_information30_o => per_spp_shd.g_old_rec.information30
600: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
601: ,p_object_version_number_o
602: => per_spp_shd.g_old_rec.object_version_number
603: );
604: --

Line 602: => per_spp_shd.g_old_rec.object_version_number

598: ,p_information29_o => per_spp_shd.g_old_rec.information29
599: ,p_information30_o => per_spp_shd.g_old_rec.information30
600: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
601: ,p_object_version_number_o
602: => per_spp_shd.g_old_rec.object_version_number
603: );
604: --
605: exception
606: --

Line 662: (p_rec in out nocopy per_spp_shd.g_rec_type

658: --
659: -- {End Of Comments}
660: -- ----------------------------------------------------------------------------
661: Procedure convert_defs
662: (p_rec in out nocopy per_spp_shd.g_rec_type
663: ) is
664: --
665: Begin
666: --

Line 674: per_spp_shd.g_old_rec.business_group_id;

670: -- is being used then we must set to the 'current' argument value.
671: --
672: If (p_rec.business_group_id = hr_api.g_number) then
673: p_rec.business_group_id :=
674: per_spp_shd.g_old_rec.business_group_id;
675: End If;
676: If (p_rec.assignment_id = hr_api.g_number) then
677: p_rec.assignment_id :=
678: per_spp_shd.g_old_rec.assignment_id;

Line 678: per_spp_shd.g_old_rec.assignment_id;

674: per_spp_shd.g_old_rec.business_group_id;
675: End If;
676: If (p_rec.assignment_id = hr_api.g_number) then
677: p_rec.assignment_id :=
678: per_spp_shd.g_old_rec.assignment_id;
679: End If;
680: If (p_rec.step_id = hr_api.g_number) then
681: p_rec.step_id :=
682: per_spp_shd.g_old_rec.step_id;

Line 682: per_spp_shd.g_old_rec.step_id;

678: per_spp_shd.g_old_rec.assignment_id;
679: End If;
680: If (p_rec.step_id = hr_api.g_number) then
681: p_rec.step_id :=
682: per_spp_shd.g_old_rec.step_id;
683: End If;
684: If (p_rec.auto_increment_flag = hr_api.g_varchar2) then
685: p_rec.auto_increment_flag :=
686: per_spp_shd.g_old_rec.auto_increment_flag;

Line 686: per_spp_shd.g_old_rec.auto_increment_flag;

682: per_spp_shd.g_old_rec.step_id;
683: End If;
684: If (p_rec.auto_increment_flag = hr_api.g_varchar2) then
685: p_rec.auto_increment_flag :=
686: per_spp_shd.g_old_rec.auto_increment_flag;
687: End If;
688: If (p_rec.parent_spine_id = hr_api.g_number) then
689: p_rec.parent_spine_id :=
690: per_spp_shd.g_old_rec.parent_spine_id;

Line 690: per_spp_shd.g_old_rec.parent_spine_id;

686: per_spp_shd.g_old_rec.auto_increment_flag;
687: End If;
688: If (p_rec.parent_spine_id = hr_api.g_number) then
689: p_rec.parent_spine_id :=
690: per_spp_shd.g_old_rec.parent_spine_id;
691: End If;
692: If (p_rec.reason = hr_api.g_varchar2) then
693: p_rec.reason :=
694: per_spp_shd.g_old_rec.reason;

Line 694: per_spp_shd.g_old_rec.reason;

690: per_spp_shd.g_old_rec.parent_spine_id;
691: End If;
692: If (p_rec.reason = hr_api.g_varchar2) then
693: p_rec.reason :=
694: per_spp_shd.g_old_rec.reason;
695: End If;
696: If (p_rec.request_id = hr_api.g_number) then
697: p_rec.request_id :=
698: per_spp_shd.g_old_rec.request_id;

Line 698: per_spp_shd.g_old_rec.request_id;

694: per_spp_shd.g_old_rec.reason;
695: End If;
696: If (p_rec.request_id = hr_api.g_number) then
697: p_rec.request_id :=
698: per_spp_shd.g_old_rec.request_id;
699: End If;
700: If (p_rec.program_application_id = hr_api.g_number) then
701: p_rec.program_application_id :=
702: per_spp_shd.g_old_rec.program_application_id;

Line 702: per_spp_shd.g_old_rec.program_application_id;

698: per_spp_shd.g_old_rec.request_id;
699: End If;
700: If (p_rec.program_application_id = hr_api.g_number) then
701: p_rec.program_application_id :=
702: per_spp_shd.g_old_rec.program_application_id;
703: End If;
704: If (p_rec.program_id = hr_api.g_number) then
705: p_rec.program_id :=
706: per_spp_shd.g_old_rec.program_id;

Line 706: per_spp_shd.g_old_rec.program_id;

702: per_spp_shd.g_old_rec.program_application_id;
703: End If;
704: If (p_rec.program_id = hr_api.g_number) then
705: p_rec.program_id :=
706: per_spp_shd.g_old_rec.program_id;
707: End If;
708: If (p_rec.program_update_date = hr_api.g_date) then
709: p_rec.program_update_date :=
710: per_spp_shd.g_old_rec.program_update_date;

Line 710: per_spp_shd.g_old_rec.program_update_date;

706: per_spp_shd.g_old_rec.program_id;
707: End If;
708: If (p_rec.program_update_date = hr_api.g_date) then
709: p_rec.program_update_date :=
710: per_spp_shd.g_old_rec.program_update_date;
711: End If;
712: If (p_rec.increment_number = hr_api.g_number) then
713: p_rec.increment_number :=
714: per_spp_shd.g_old_rec.increment_number;

Line 714: per_spp_shd.g_old_rec.increment_number;

710: per_spp_shd.g_old_rec.program_update_date;
711: End If;
712: If (p_rec.increment_number = hr_api.g_number) then
713: p_rec.increment_number :=
714: per_spp_shd.g_old_rec.increment_number;
715: End If;
716: If (p_rec.information1 = hr_api.g_varchar2) then
717: p_rec.information1 := per_spp_shd.g_old_rec.information1;
718: End If;

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

713: p_rec.increment_number :=
714: per_spp_shd.g_old_rec.increment_number;
715: End If;
716: If (p_rec.information1 = hr_api.g_varchar2) then
717: p_rec.information1 := per_spp_shd.g_old_rec.information1;
718: End If;
719: If (p_rec.information2 = hr_api.g_varchar2) then
720: p_rec.information2 := per_spp_shd.g_old_rec.information2;
721: End If;

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

716: If (p_rec.information1 = hr_api.g_varchar2) then
717: p_rec.information1 := per_spp_shd.g_old_rec.information1;
718: End If;
719: If (p_rec.information2 = hr_api.g_varchar2) then
720: p_rec.information2 := per_spp_shd.g_old_rec.information2;
721: End If;
722: If (p_rec.information3 = hr_api.g_varchar2) then
723: p_rec.information3 := per_spp_shd.g_old_rec.information3;
724: End If;

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

719: If (p_rec.information2 = hr_api.g_varchar2) then
720: p_rec.information2 := per_spp_shd.g_old_rec.information2;
721: End If;
722: If (p_rec.information3 = hr_api.g_varchar2) then
723: p_rec.information3 := per_spp_shd.g_old_rec.information3;
724: End If;
725: If (p_rec.information3 = hr_api.g_varchar2) then
726: p_rec.information3 := per_spp_shd.g_old_rec.information3;
727: End If;

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

722: If (p_rec.information3 = hr_api.g_varchar2) then
723: p_rec.information3 := per_spp_shd.g_old_rec.information3;
724: End If;
725: If (p_rec.information3 = hr_api.g_varchar2) then
726: p_rec.information3 := per_spp_shd.g_old_rec.information3;
727: End If;
728: If (p_rec.information4 = hr_api.g_varchar2) then
729: p_rec.information4 := per_spp_shd.g_old_rec.information4;
730: End If;

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

725: If (p_rec.information3 = hr_api.g_varchar2) then
726: p_rec.information3 := per_spp_shd.g_old_rec.information3;
727: End If;
728: If (p_rec.information4 = hr_api.g_varchar2) then
729: p_rec.information4 := per_spp_shd.g_old_rec.information4;
730: End If;
731: If (p_rec.information5 = hr_api.g_varchar2) then
732: p_rec.information5 := per_spp_shd.g_old_rec.information5;
733: End If;

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

728: If (p_rec.information4 = hr_api.g_varchar2) then
729: p_rec.information4 := per_spp_shd.g_old_rec.information4;
730: End If;
731: If (p_rec.information5 = hr_api.g_varchar2) then
732: p_rec.information5 := per_spp_shd.g_old_rec.information5;
733: End If;
734: If (p_rec.information6 = hr_api.g_varchar2) then
735: p_rec.information6 := per_spp_shd.g_old_rec.information6;
736: End If;

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

731: If (p_rec.information5 = hr_api.g_varchar2) then
732: p_rec.information5 := per_spp_shd.g_old_rec.information5;
733: End If;
734: If (p_rec.information6 = hr_api.g_varchar2) then
735: p_rec.information6 := per_spp_shd.g_old_rec.information6;
736: End If;
737: If (p_rec.information7 = hr_api.g_varchar2) then
738: p_rec.information7 := per_spp_shd.g_old_rec.information7;
739: End If;

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

734: If (p_rec.information6 = hr_api.g_varchar2) then
735: p_rec.information6 := per_spp_shd.g_old_rec.information6;
736: End If;
737: If (p_rec.information7 = hr_api.g_varchar2) then
738: p_rec.information7 := per_spp_shd.g_old_rec.information7;
739: End If;
740: If (p_rec.information8 = hr_api.g_varchar2) then
741: p_rec.information8 := per_spp_shd.g_old_rec.information8;
742: End If;

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

737: If (p_rec.information7 = hr_api.g_varchar2) then
738: p_rec.information7 := per_spp_shd.g_old_rec.information7;
739: End If;
740: If (p_rec.information8 = hr_api.g_varchar2) then
741: p_rec.information8 := per_spp_shd.g_old_rec.information8;
742: End If;
743: If (p_rec.information9 = hr_api.g_varchar2) then
744: p_rec.information9 := per_spp_shd.g_old_rec.information9;
745: End If;

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

740: If (p_rec.information8 = hr_api.g_varchar2) then
741: p_rec.information8 := per_spp_shd.g_old_rec.information8;
742: End If;
743: If (p_rec.information9 = hr_api.g_varchar2) then
744: p_rec.information9 := per_spp_shd.g_old_rec.information9;
745: End If;
746: If (p_rec.information10 = hr_api.g_varchar2) then
747: p_rec.information10 := per_spp_shd.g_old_rec.information10;
748: End If;

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

743: If (p_rec.information9 = hr_api.g_varchar2) then
744: p_rec.information9 := per_spp_shd.g_old_rec.information9;
745: End If;
746: If (p_rec.information10 = hr_api.g_varchar2) then
747: p_rec.information10 := per_spp_shd.g_old_rec.information10;
748: End If;
749: If (p_rec.information11 = hr_api.g_varchar2) then
750: p_rec.information11 := per_spp_shd.g_old_rec.information11;
751: End If;

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

746: If (p_rec.information10 = hr_api.g_varchar2) then
747: p_rec.information10 := per_spp_shd.g_old_rec.information10;
748: End If;
749: If (p_rec.information11 = hr_api.g_varchar2) then
750: p_rec.information11 := per_spp_shd.g_old_rec.information11;
751: End If;
752: If (p_rec.information12 = hr_api.g_varchar2) then
753: p_rec.information12 := per_spp_shd.g_old_rec.information12;
754: End If;

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

749: If (p_rec.information11 = hr_api.g_varchar2) then
750: p_rec.information11 := per_spp_shd.g_old_rec.information11;
751: End If;
752: If (p_rec.information12 = hr_api.g_varchar2) then
753: p_rec.information12 := per_spp_shd.g_old_rec.information12;
754: End If;
755: If (p_rec.information13 = hr_api.g_varchar2) then
756: p_rec.information13 := per_spp_shd.g_old_rec.information13;
757: End If;

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

752: If (p_rec.information12 = hr_api.g_varchar2) then
753: p_rec.information12 := per_spp_shd.g_old_rec.information12;
754: End If;
755: If (p_rec.information13 = hr_api.g_varchar2) then
756: p_rec.information13 := per_spp_shd.g_old_rec.information13;
757: End If;
758: If (p_rec.information14 = hr_api.g_varchar2) then
759: p_rec.information14 := per_spp_shd.g_old_rec.information14;
760: End If;

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

755: If (p_rec.information13 = hr_api.g_varchar2) then
756: p_rec.information13 := per_spp_shd.g_old_rec.information13;
757: End If;
758: If (p_rec.information14 = hr_api.g_varchar2) then
759: p_rec.information14 := per_spp_shd.g_old_rec.information14;
760: End If;
761: If (p_rec.information15 = hr_api.g_varchar2) then
762: p_rec.information15 := per_spp_shd.g_old_rec.information15;
763: End If;

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

758: If (p_rec.information14 = hr_api.g_varchar2) then
759: p_rec.information14 := per_spp_shd.g_old_rec.information14;
760: End If;
761: If (p_rec.information15 = hr_api.g_varchar2) then
762: p_rec.information15 := per_spp_shd.g_old_rec.information15;
763: End If;
764: If (p_rec.information16 = hr_api.g_varchar2) then
765: p_rec.information16 := per_spp_shd.g_old_rec.information16;
766: End If;

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

761: If (p_rec.information15 = hr_api.g_varchar2) then
762: p_rec.information15 := per_spp_shd.g_old_rec.information15;
763: End If;
764: If (p_rec.information16 = hr_api.g_varchar2) then
765: p_rec.information16 := per_spp_shd.g_old_rec.information16;
766: End If;
767: If (p_rec.information17 = hr_api.g_varchar2) then
768: p_rec.information17 := per_spp_shd.g_old_rec.information17;
769: End If;

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

764: If (p_rec.information16 = hr_api.g_varchar2) then
765: p_rec.information16 := per_spp_shd.g_old_rec.information16;
766: End If;
767: If (p_rec.information17 = hr_api.g_varchar2) then
768: p_rec.information17 := per_spp_shd.g_old_rec.information17;
769: End If;
770: If (p_rec.information18 = hr_api.g_varchar2) then
771: p_rec.information18 := per_spp_shd.g_old_rec.information18;
772: End If;

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

767: If (p_rec.information17 = hr_api.g_varchar2) then
768: p_rec.information17 := per_spp_shd.g_old_rec.information17;
769: End If;
770: If (p_rec.information18 = hr_api.g_varchar2) then
771: p_rec.information18 := per_spp_shd.g_old_rec.information18;
772: End If;
773: If (p_rec.information19 = hr_api.g_varchar2) then
774: p_rec.information19 := per_spp_shd.g_old_rec.information19;
775: End If;

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

770: If (p_rec.information18 = hr_api.g_varchar2) then
771: p_rec.information18 := per_spp_shd.g_old_rec.information18;
772: End If;
773: If (p_rec.information19 = hr_api.g_varchar2) then
774: p_rec.information19 := per_spp_shd.g_old_rec.information19;
775: End If;
776: If (p_rec.information20 = hr_api.g_varchar2) then
777: p_rec.information20 := per_spp_shd.g_old_rec.information20;
778: End If;

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

773: If (p_rec.information19 = hr_api.g_varchar2) then
774: p_rec.information19 := per_spp_shd.g_old_rec.information19;
775: End If;
776: If (p_rec.information20 = hr_api.g_varchar2) then
777: p_rec.information20 := per_spp_shd.g_old_rec.information20;
778: End If;
779: If (p_rec.information21 = hr_api.g_varchar2) then
780: p_rec.information21 := per_spp_shd.g_old_rec.information21;
781: End If;

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

776: If (p_rec.information20 = hr_api.g_varchar2) then
777: p_rec.information20 := per_spp_shd.g_old_rec.information20;
778: End If;
779: If (p_rec.information21 = hr_api.g_varchar2) then
780: p_rec.information21 := per_spp_shd.g_old_rec.information21;
781: End If;
782: If (p_rec.information22 = hr_api.g_varchar2) then
783: p_rec.information22 := per_spp_shd.g_old_rec.information22;
784: End If;

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

779: If (p_rec.information21 = hr_api.g_varchar2) then
780: p_rec.information21 := per_spp_shd.g_old_rec.information21;
781: End If;
782: If (p_rec.information22 = hr_api.g_varchar2) then
783: p_rec.information22 := per_spp_shd.g_old_rec.information22;
784: End If;
785: If (p_rec.information23 = hr_api.g_varchar2) then
786: p_rec.information23 := per_spp_shd.g_old_rec.information23;
787: End If;

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

782: If (p_rec.information22 = hr_api.g_varchar2) then
783: p_rec.information22 := per_spp_shd.g_old_rec.information22;
784: End If;
785: If (p_rec.information23 = hr_api.g_varchar2) then
786: p_rec.information23 := per_spp_shd.g_old_rec.information23;
787: End If;
788: If (p_rec.information24 = hr_api.g_varchar2) then
789: p_rec.information24 := per_spp_shd.g_old_rec.information24;
790: End If;

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

785: If (p_rec.information23 = hr_api.g_varchar2) then
786: p_rec.information23 := per_spp_shd.g_old_rec.information23;
787: End If;
788: If (p_rec.information24 = hr_api.g_varchar2) then
789: p_rec.information24 := per_spp_shd.g_old_rec.information24;
790: End If;
791: If (p_rec.information25 = hr_api.g_varchar2) then
792: p_rec.information25 := per_spp_shd.g_old_rec.information25;
793: End If;

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

788: If (p_rec.information24 = hr_api.g_varchar2) then
789: p_rec.information24 := per_spp_shd.g_old_rec.information24;
790: End If;
791: If (p_rec.information25 = hr_api.g_varchar2) then
792: p_rec.information25 := per_spp_shd.g_old_rec.information25;
793: End If;
794: If (p_rec.information26 = hr_api.g_varchar2) then
795: p_rec.information26 := per_spp_shd.g_old_rec.information26;
796: End If;

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

791: If (p_rec.information25 = hr_api.g_varchar2) then
792: p_rec.information25 := per_spp_shd.g_old_rec.information25;
793: End If;
794: If (p_rec.information26 = hr_api.g_varchar2) then
795: p_rec.information26 := per_spp_shd.g_old_rec.information26;
796: End If;
797: If (p_rec.information27 = hr_api.g_varchar2) then
798: p_rec.information27 := per_spp_shd.g_old_rec.information27;
799: End If;

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

794: If (p_rec.information26 = hr_api.g_varchar2) then
795: p_rec.information26 := per_spp_shd.g_old_rec.information26;
796: End If;
797: If (p_rec.information27 = hr_api.g_varchar2) then
798: p_rec.information27 := per_spp_shd.g_old_rec.information27;
799: End If;
800: If (p_rec.information28 = hr_api.g_varchar2) then
801: p_rec.information28 := per_spp_shd.g_old_rec.information28;
802: End If;

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

797: If (p_rec.information27 = hr_api.g_varchar2) then
798: p_rec.information27 := per_spp_shd.g_old_rec.information27;
799: End If;
800: If (p_rec.information28 = hr_api.g_varchar2) then
801: p_rec.information28 := per_spp_shd.g_old_rec.information28;
802: End If;
803: If (p_rec.information29 = hr_api.g_varchar2) then
804: p_rec.information29 := per_spp_shd.g_old_rec.information29;
805: End If;

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

800: If (p_rec.information28 = hr_api.g_varchar2) then
801: p_rec.information28 := per_spp_shd.g_old_rec.information28;
802: End If;
803: If (p_rec.information29 = hr_api.g_varchar2) then
804: p_rec.information29 := per_spp_shd.g_old_rec.information29;
805: End If;
806: If (p_rec.information30 = hr_api.g_varchar2) then
807: p_rec.information30 := per_spp_shd.g_old_rec.information30;
808: End If;

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

803: If (p_rec.information29 = hr_api.g_varchar2) then
804: p_rec.information29 := per_spp_shd.g_old_rec.information29;
805: End If;
806: If (p_rec.information30 = hr_api.g_varchar2) then
807: p_rec.information30 := per_spp_shd.g_old_rec.information30;
808: End If;
809: If (p_rec.information_category = hr_api.g_varchar2) then
810: p_rec.information_category := per_spp_shd.g_old_rec.information_category;
811: End If;

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

806: If (p_rec.information30 = hr_api.g_varchar2) then
807: p_rec.information30 := per_spp_shd.g_old_rec.information30;
808: End If;
809: If (p_rec.information_category = hr_api.g_varchar2) then
810: p_rec.information_category := per_spp_shd.g_old_rec.information_category;
811: End If;
812: --
813: End convert_defs;
814: --

Line 821: ,p_rec in out nocopy per_spp_shd.g_rec_type

817: -- ----------------------------------------------------------------------------
818: Procedure upd
819: (p_effective_date in date
820: ,p_datetrack_mode in out nocopy varchar2
821: ,p_rec in out nocopy per_spp_shd.g_rec_type
822: ) is
823: --
824: l_proc varchar2(72) := g_package||'upd';
825: l_validation_start_date date;

Line 839: per_spp_shd.lck

835: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
836: --
837: -- We must lock the row which we need to update.
838: --
839: per_spp_shd.lck
840: (p_effective_date => p_effective_date
841: ,p_datetrack_mode => p_datetrack_mode
842: ,p_placement_id => p_rec.placement_id
843: ,p_object_version_number => p_rec.object_version_number

Line 951: l_rec per_spp_shd.g_rec_type;

947: ,p_effective_start_date in out nocopy date
948: ,p_effective_end_date in out nocopy date
949: ) is
950: --
951: l_rec per_spp_shd.g_rec_type;
952: l_proc varchar2(72) := g_package||'upd';
953: l_parent_spine_id per_spinal_point_placements_f.parent_spine_id%TYPE;
954: --
955: Begin

Line 979: per_spp_shd.convert_args

975: -- Call conversion function to turn arguments into the
976: -- l_rec structure.
977: --
978: l_rec :=
979: per_spp_shd.convert_args
980: (p_placement_id
981: ,p_effective_start_date
982: ,p_effective_end_date
983: ,p_business_group_id