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_SPS_UPD dependencies on PER_SPS_SHD

Line 58: (p_rec in out nocopy per_sps_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy per_sps_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 83: per_sps_shd.g_api_dml := true; -- Set the api dml status

79: ,p_base_key_column => 'step_id'
80: ,p_base_key_value => p_rec.step_id
81: );
82: --
83: per_sps_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the per_spinal_point_steps_f Row
86: --
87: update per_spinal_point_steps_f

Line 134: per_sps_shd.g_api_dml := false; -- Unset the api dml status

130: where step_id = p_rec.step_id
131: and effective_start_date = p_validation_start_date
132: and effective_end_date = p_validation_end_date;
133: --
134: per_sps_shd.g_api_dml := false; -- Unset the api dml status
135: --
136: -- Set the effective start and end dates
137: --
138: p_rec.effective_start_date := p_validation_start_date;

Line 146: per_sps_shd.g_api_dml := false; -- Unset the api dml status

142: hr_utility.set_location(' Leaving:'||l_proc, 15);
143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: per_sps_shd.g_api_dml := false; -- Unset the api dml status
147: per_sps_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated

Line 147: per_sps_shd.constraint_error

143: Exception
144: When hr_api.check_integrity_violated Then
145: -- A check constraint has been violated
146: per_sps_shd.g_api_dml := false; -- Unset the api dml status
147: per_sps_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: per_sps_shd.g_api_dml := false; -- Unset the api dml status

Line 151: per_sps_shd.g_api_dml := false; -- Unset the api dml status

147: per_sps_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: per_sps_shd.g_api_dml := false; -- Unset the api dml status
152: per_sps_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: per_sps_shd.g_api_dml := false; -- Unset the api dml status

Line 152: per_sps_shd.constraint_error

148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When hr_api.unique_integrity_violated Then
150: -- Unique integrity has been violated
151: per_sps_shd.g_api_dml := false; -- Unset the api dml status
152: per_sps_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: per_sps_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;

Line 155: per_sps_shd.g_api_dml := false; -- Unset the api dml status

151: per_sps_shd.g_api_dml := false; -- Unset the api dml status
152: per_sps_shd.constraint_error
153: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
154: When Others Then
155: per_sps_shd.g_api_dml := false; -- Unset the api dml status
156: Raise;
157: End dt_update_dml;
158: --
159: -- ----------------------------------------------------------------------------

Line 191: (p_rec in out nocopy per_sps_shd.g_rec_type

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure update_dml
191: (p_rec in out nocopy per_sps_shd.g_rec_type
192: ,p_effective_date in date
193: ,p_datetrack_mode in varchar2
194: ,p_validation_start_date in date
195: ,p_validation_end_date in date

Line 258: (p_rec in out nocopy per_sps_shd.g_rec_type

254: --
255: -- {End Of Comments}
256: -- ----------------------------------------------------------------------------
257: Procedure dt_pre_update
258: (p_rec in out nocopy per_sps_shd.g_rec_type
259: ,p_effective_date in date
260: ,p_datetrack_mode in varchar2
261: ,p_validation_start_date in date
262: ,p_validation_end_date in date

Line 274: per_sps_shd.upd_effective_end_date

270: If (p_datetrack_mode <> hr_api.g_correction) then
271: --
272: -- Update the current effective end date
273: --
274: per_sps_shd.upd_effective_end_date
275: (p_effective_date => p_effective_date
276: ,p_base_key_value => p_rec.step_id
277: ,p_new_effective_end_date => (p_validation_start_date - 1)
278: ,p_validation_start_date => p_validation_start_date

Line 343: (p_rec in out nocopy per_sps_shd.g_rec_type

339: --
340: -- {End Of Comments}
341: -- ----------------------------------------------------------------------------
342: Procedure pre_update
343: (p_rec in out nocopy per_sps_shd.g_rec_type
344: ,p_effective_date in date
345: ,p_datetrack_mode in varchar2
346: ,p_validation_start_date in date
347: ,p_validation_end_date in date

Line 401: (p_rec in per_sps_shd.g_rec_type

397: --
398: -- {End Of Comments}
399: -- ----------------------------------------------------------------------------
400: Procedure post_update
401: (p_rec in per_sps_shd.g_rec_type
402: ,p_effective_date in date
403: ,p_datetrack_mode in varchar2
404: ,p_validation_start_date in date
405: ,p_validation_end_date in date

Line 510: => per_sps_shd.g_old_rec.effective_start_date

506: => p_rec.information_category
507: ,p_object_version_number
508: => p_rec.object_version_number
509: ,p_effective_start_date_o
510: => per_sps_shd.g_old_rec.effective_start_date
511: ,p_effective_end_date_o
512: => per_sps_shd.g_old_rec.effective_end_date
513: ,p_business_group_id_o
514: => per_sps_shd.g_old_rec.business_group_id

Line 512: => per_sps_shd.g_old_rec.effective_end_date

508: => p_rec.object_version_number
509: ,p_effective_start_date_o
510: => per_sps_shd.g_old_rec.effective_start_date
511: ,p_effective_end_date_o
512: => per_sps_shd.g_old_rec.effective_end_date
513: ,p_business_group_id_o
514: => per_sps_shd.g_old_rec.business_group_id
515: ,p_spinal_point_id_o
516: => per_sps_shd.g_old_rec.spinal_point_id

Line 514: => per_sps_shd.g_old_rec.business_group_id

510: => per_sps_shd.g_old_rec.effective_start_date
511: ,p_effective_end_date_o
512: => per_sps_shd.g_old_rec.effective_end_date
513: ,p_business_group_id_o
514: => per_sps_shd.g_old_rec.business_group_id
515: ,p_spinal_point_id_o
516: => per_sps_shd.g_old_rec.spinal_point_id
517: ,p_grade_spine_id_o
518: => per_sps_shd.g_old_rec.grade_spine_id

Line 516: => per_sps_shd.g_old_rec.spinal_point_id

512: => per_sps_shd.g_old_rec.effective_end_date
513: ,p_business_group_id_o
514: => per_sps_shd.g_old_rec.business_group_id
515: ,p_spinal_point_id_o
516: => per_sps_shd.g_old_rec.spinal_point_id
517: ,p_grade_spine_id_o
518: => per_sps_shd.g_old_rec.grade_spine_id
519: ,p_sequence_o
520: => per_sps_shd.g_old_rec.sequence

Line 518: => per_sps_shd.g_old_rec.grade_spine_id

514: => per_sps_shd.g_old_rec.business_group_id
515: ,p_spinal_point_id_o
516: => per_sps_shd.g_old_rec.spinal_point_id
517: ,p_grade_spine_id_o
518: => per_sps_shd.g_old_rec.grade_spine_id
519: ,p_sequence_o
520: => per_sps_shd.g_old_rec.sequence
521: ,p_request_id_o
522: => per_sps_shd.g_old_rec.request_id

Line 520: => per_sps_shd.g_old_rec.sequence

516: => per_sps_shd.g_old_rec.spinal_point_id
517: ,p_grade_spine_id_o
518: => per_sps_shd.g_old_rec.grade_spine_id
519: ,p_sequence_o
520: => per_sps_shd.g_old_rec.sequence
521: ,p_request_id_o
522: => per_sps_shd.g_old_rec.request_id
523: ,p_program_application_id_o
524: => per_sps_shd.g_old_rec.program_application_id

Line 522: => per_sps_shd.g_old_rec.request_id

518: => per_sps_shd.g_old_rec.grade_spine_id
519: ,p_sequence_o
520: => per_sps_shd.g_old_rec.sequence
521: ,p_request_id_o
522: => per_sps_shd.g_old_rec.request_id
523: ,p_program_application_id_o
524: => per_sps_shd.g_old_rec.program_application_id
525: ,p_program_id_o
526: => per_sps_shd.g_old_rec.program_id

Line 524: => per_sps_shd.g_old_rec.program_application_id

520: => per_sps_shd.g_old_rec.sequence
521: ,p_request_id_o
522: => per_sps_shd.g_old_rec.request_id
523: ,p_program_application_id_o
524: => per_sps_shd.g_old_rec.program_application_id
525: ,p_program_id_o
526: => per_sps_shd.g_old_rec.program_id
527: ,p_program_update_date_o
528: => per_sps_shd.g_old_rec.program_update_date

Line 526: => per_sps_shd.g_old_rec.program_id

522: => per_sps_shd.g_old_rec.request_id
523: ,p_program_application_id_o
524: => per_sps_shd.g_old_rec.program_application_id
525: ,p_program_id_o
526: => per_sps_shd.g_old_rec.program_id
527: ,p_program_update_date_o
528: => per_sps_shd.g_old_rec.program_update_date
529: ,p_information1_o
530: => per_sps_shd.g_old_rec.information1

Line 528: => per_sps_shd.g_old_rec.program_update_date

524: => per_sps_shd.g_old_rec.program_application_id
525: ,p_program_id_o
526: => per_sps_shd.g_old_rec.program_id
527: ,p_program_update_date_o
528: => per_sps_shd.g_old_rec.program_update_date
529: ,p_information1_o
530: => per_sps_shd.g_old_rec.information1
531: ,p_information2_o
532: => per_sps_shd.g_old_rec.information2

Line 530: => per_sps_shd.g_old_rec.information1

526: => per_sps_shd.g_old_rec.program_id
527: ,p_program_update_date_o
528: => per_sps_shd.g_old_rec.program_update_date
529: ,p_information1_o
530: => per_sps_shd.g_old_rec.information1
531: ,p_information2_o
532: => per_sps_shd.g_old_rec.information2
533: ,p_information3_o
534: => per_sps_shd.g_old_rec.information3

Line 532: => per_sps_shd.g_old_rec.information2

528: => per_sps_shd.g_old_rec.program_update_date
529: ,p_information1_o
530: => per_sps_shd.g_old_rec.information1
531: ,p_information2_o
532: => per_sps_shd.g_old_rec.information2
533: ,p_information3_o
534: => per_sps_shd.g_old_rec.information3
535: ,p_information4_o
536: => per_sps_shd.g_old_rec.information4

Line 534: => per_sps_shd.g_old_rec.information3

530: => per_sps_shd.g_old_rec.information1
531: ,p_information2_o
532: => per_sps_shd.g_old_rec.information2
533: ,p_information3_o
534: => per_sps_shd.g_old_rec.information3
535: ,p_information4_o
536: => per_sps_shd.g_old_rec.information4
537: ,p_information5_o
538: => per_sps_shd.g_old_rec.information5

Line 536: => per_sps_shd.g_old_rec.information4

532: => per_sps_shd.g_old_rec.information2
533: ,p_information3_o
534: => per_sps_shd.g_old_rec.information3
535: ,p_information4_o
536: => per_sps_shd.g_old_rec.information4
537: ,p_information5_o
538: => per_sps_shd.g_old_rec.information5
539: ,p_information6_o
540: => per_sps_shd.g_old_rec.information6

Line 538: => per_sps_shd.g_old_rec.information5

534: => per_sps_shd.g_old_rec.information3
535: ,p_information4_o
536: => per_sps_shd.g_old_rec.information4
537: ,p_information5_o
538: => per_sps_shd.g_old_rec.information5
539: ,p_information6_o
540: => per_sps_shd.g_old_rec.information6
541: ,p_information7_o
542: => per_sps_shd.g_old_rec.information7

Line 540: => per_sps_shd.g_old_rec.information6

536: => per_sps_shd.g_old_rec.information4
537: ,p_information5_o
538: => per_sps_shd.g_old_rec.information5
539: ,p_information6_o
540: => per_sps_shd.g_old_rec.information6
541: ,p_information7_o
542: => per_sps_shd.g_old_rec.information7
543: ,p_information8_o
544: => per_sps_shd.g_old_rec.information8

Line 542: => per_sps_shd.g_old_rec.information7

538: => per_sps_shd.g_old_rec.information5
539: ,p_information6_o
540: => per_sps_shd.g_old_rec.information6
541: ,p_information7_o
542: => per_sps_shd.g_old_rec.information7
543: ,p_information8_o
544: => per_sps_shd.g_old_rec.information8
545: ,p_information9_o
546: => per_sps_shd.g_old_rec.information9

Line 544: => per_sps_shd.g_old_rec.information8

540: => per_sps_shd.g_old_rec.information6
541: ,p_information7_o
542: => per_sps_shd.g_old_rec.information7
543: ,p_information8_o
544: => per_sps_shd.g_old_rec.information8
545: ,p_information9_o
546: => per_sps_shd.g_old_rec.information9
547: ,p_information10_o
548: => per_sps_shd.g_old_rec.information10

Line 546: => per_sps_shd.g_old_rec.information9

542: => per_sps_shd.g_old_rec.information7
543: ,p_information8_o
544: => per_sps_shd.g_old_rec.information8
545: ,p_information9_o
546: => per_sps_shd.g_old_rec.information9
547: ,p_information10_o
548: => per_sps_shd.g_old_rec.information10
549: ,p_information11_o
550: => per_sps_shd.g_old_rec.information11

Line 548: => per_sps_shd.g_old_rec.information10

544: => per_sps_shd.g_old_rec.information8
545: ,p_information9_o
546: => per_sps_shd.g_old_rec.information9
547: ,p_information10_o
548: => per_sps_shd.g_old_rec.information10
549: ,p_information11_o
550: => per_sps_shd.g_old_rec.information11
551: ,p_information12_o
552: => per_sps_shd.g_old_rec.information12

Line 550: => per_sps_shd.g_old_rec.information11

546: => per_sps_shd.g_old_rec.information9
547: ,p_information10_o
548: => per_sps_shd.g_old_rec.information10
549: ,p_information11_o
550: => per_sps_shd.g_old_rec.information11
551: ,p_information12_o
552: => per_sps_shd.g_old_rec.information12
553: ,p_information13_o
554: => per_sps_shd.g_old_rec.information13

Line 552: => per_sps_shd.g_old_rec.information12

548: => per_sps_shd.g_old_rec.information10
549: ,p_information11_o
550: => per_sps_shd.g_old_rec.information11
551: ,p_information12_o
552: => per_sps_shd.g_old_rec.information12
553: ,p_information13_o
554: => per_sps_shd.g_old_rec.information13
555: ,p_information14_o
556: => per_sps_shd.g_old_rec.information14

Line 554: => per_sps_shd.g_old_rec.information13

550: => per_sps_shd.g_old_rec.information11
551: ,p_information12_o
552: => per_sps_shd.g_old_rec.information12
553: ,p_information13_o
554: => per_sps_shd.g_old_rec.information13
555: ,p_information14_o
556: => per_sps_shd.g_old_rec.information14
557: ,p_information15_o
558: => per_sps_shd.g_old_rec.information15

Line 556: => per_sps_shd.g_old_rec.information14

552: => per_sps_shd.g_old_rec.information12
553: ,p_information13_o
554: => per_sps_shd.g_old_rec.information13
555: ,p_information14_o
556: => per_sps_shd.g_old_rec.information14
557: ,p_information15_o
558: => per_sps_shd.g_old_rec.information15
559: ,p_information16_o
560: => per_sps_shd.g_old_rec.information16

Line 558: => per_sps_shd.g_old_rec.information15

554: => per_sps_shd.g_old_rec.information13
555: ,p_information14_o
556: => per_sps_shd.g_old_rec.information14
557: ,p_information15_o
558: => per_sps_shd.g_old_rec.information15
559: ,p_information16_o
560: => per_sps_shd.g_old_rec.information16
561: ,p_information17_o
562: => per_sps_shd.g_old_rec.information17

Line 560: => per_sps_shd.g_old_rec.information16

556: => per_sps_shd.g_old_rec.information14
557: ,p_information15_o
558: => per_sps_shd.g_old_rec.information15
559: ,p_information16_o
560: => per_sps_shd.g_old_rec.information16
561: ,p_information17_o
562: => per_sps_shd.g_old_rec.information17
563: ,p_information18_o
564: => per_sps_shd.g_old_rec.information18

Line 562: => per_sps_shd.g_old_rec.information17

558: => per_sps_shd.g_old_rec.information15
559: ,p_information16_o
560: => per_sps_shd.g_old_rec.information16
561: ,p_information17_o
562: => per_sps_shd.g_old_rec.information17
563: ,p_information18_o
564: => per_sps_shd.g_old_rec.information18
565: ,p_information19_o
566: => per_sps_shd.g_old_rec.information19

Line 564: => per_sps_shd.g_old_rec.information18

560: => per_sps_shd.g_old_rec.information16
561: ,p_information17_o
562: => per_sps_shd.g_old_rec.information17
563: ,p_information18_o
564: => per_sps_shd.g_old_rec.information18
565: ,p_information19_o
566: => per_sps_shd.g_old_rec.information19
567: ,p_information20_o
568: => per_sps_shd.g_old_rec.information20

Line 566: => per_sps_shd.g_old_rec.information19

562: => per_sps_shd.g_old_rec.information17
563: ,p_information18_o
564: => per_sps_shd.g_old_rec.information18
565: ,p_information19_o
566: => per_sps_shd.g_old_rec.information19
567: ,p_information20_o
568: => per_sps_shd.g_old_rec.information20
569: ,p_information21_o
570: => per_sps_shd.g_old_rec.information21

Line 568: => per_sps_shd.g_old_rec.information20

564: => per_sps_shd.g_old_rec.information18
565: ,p_information19_o
566: => per_sps_shd.g_old_rec.information19
567: ,p_information20_o
568: => per_sps_shd.g_old_rec.information20
569: ,p_information21_o
570: => per_sps_shd.g_old_rec.information21
571: ,p_information22_o
572: => per_sps_shd.g_old_rec.information22

Line 570: => per_sps_shd.g_old_rec.information21

566: => per_sps_shd.g_old_rec.information19
567: ,p_information20_o
568: => per_sps_shd.g_old_rec.information20
569: ,p_information21_o
570: => per_sps_shd.g_old_rec.information21
571: ,p_information22_o
572: => per_sps_shd.g_old_rec.information22
573: ,p_information23_o
574: => per_sps_shd.g_old_rec.information23

Line 572: => per_sps_shd.g_old_rec.information22

568: => per_sps_shd.g_old_rec.information20
569: ,p_information21_o
570: => per_sps_shd.g_old_rec.information21
571: ,p_information22_o
572: => per_sps_shd.g_old_rec.information22
573: ,p_information23_o
574: => per_sps_shd.g_old_rec.information23
575: ,p_information24_o
576: => per_sps_shd.g_old_rec.information24

Line 574: => per_sps_shd.g_old_rec.information23

570: => per_sps_shd.g_old_rec.information21
571: ,p_information22_o
572: => per_sps_shd.g_old_rec.information22
573: ,p_information23_o
574: => per_sps_shd.g_old_rec.information23
575: ,p_information24_o
576: => per_sps_shd.g_old_rec.information24
577: ,p_information25_o
578: => per_sps_shd.g_old_rec.information25

Line 576: => per_sps_shd.g_old_rec.information24

572: => per_sps_shd.g_old_rec.information22
573: ,p_information23_o
574: => per_sps_shd.g_old_rec.information23
575: ,p_information24_o
576: => per_sps_shd.g_old_rec.information24
577: ,p_information25_o
578: => per_sps_shd.g_old_rec.information25
579: ,p_information26_o
580: => per_sps_shd.g_old_rec.information26

Line 578: => per_sps_shd.g_old_rec.information25

574: => per_sps_shd.g_old_rec.information23
575: ,p_information24_o
576: => per_sps_shd.g_old_rec.information24
577: ,p_information25_o
578: => per_sps_shd.g_old_rec.information25
579: ,p_information26_o
580: => per_sps_shd.g_old_rec.information26
581: ,p_information27_o
582: => per_sps_shd.g_old_rec.information27

Line 580: => per_sps_shd.g_old_rec.information26

576: => per_sps_shd.g_old_rec.information24
577: ,p_information25_o
578: => per_sps_shd.g_old_rec.information25
579: ,p_information26_o
580: => per_sps_shd.g_old_rec.information26
581: ,p_information27_o
582: => per_sps_shd.g_old_rec.information27
583: ,p_information28_o
584: => per_sps_shd.g_old_rec.information28

Line 582: => per_sps_shd.g_old_rec.information27

578: => per_sps_shd.g_old_rec.information25
579: ,p_information26_o
580: => per_sps_shd.g_old_rec.information26
581: ,p_information27_o
582: => per_sps_shd.g_old_rec.information27
583: ,p_information28_o
584: => per_sps_shd.g_old_rec.information28
585: ,p_information29_o
586: => per_sps_shd.g_old_rec.information29

Line 584: => per_sps_shd.g_old_rec.information28

580: => per_sps_shd.g_old_rec.information26
581: ,p_information27_o
582: => per_sps_shd.g_old_rec.information27
583: ,p_information28_o
584: => per_sps_shd.g_old_rec.information28
585: ,p_information29_o
586: => per_sps_shd.g_old_rec.information29
587: ,p_information30_o
588: => per_sps_shd.g_old_rec.information30

Line 586: => per_sps_shd.g_old_rec.information29

582: => per_sps_shd.g_old_rec.information27
583: ,p_information28_o
584: => per_sps_shd.g_old_rec.information28
585: ,p_information29_o
586: => per_sps_shd.g_old_rec.information29
587: ,p_information30_o
588: => per_sps_shd.g_old_rec.information30
589: ,p_information_category_o
590: => per_sps_shd.g_old_rec.information_category

Line 588: => per_sps_shd.g_old_rec.information30

584: => per_sps_shd.g_old_rec.information28
585: ,p_information29_o
586: => per_sps_shd.g_old_rec.information29
587: ,p_information30_o
588: => per_sps_shd.g_old_rec.information30
589: ,p_information_category_o
590: => per_sps_shd.g_old_rec.information_category
591: ,p_object_version_number_o
592: => per_sps_shd.g_old_rec.object_version_number

Line 590: => per_sps_shd.g_old_rec.information_category

586: => per_sps_shd.g_old_rec.information29
587: ,p_information30_o
588: => per_sps_shd.g_old_rec.information30
589: ,p_information_category_o
590: => per_sps_shd.g_old_rec.information_category
591: ,p_object_version_number_o
592: => per_sps_shd.g_old_rec.object_version_number
593: );
594: --

Line 592: => per_sps_shd.g_old_rec.object_version_number

588: => per_sps_shd.g_old_rec.information30
589: ,p_information_category_o
590: => per_sps_shd.g_old_rec.information_category
591: ,p_object_version_number_o
592: => per_sps_shd.g_old_rec.object_version_number
593: );
594: --
595: exception
596: --

Line 652: (p_rec in out nocopy per_sps_shd.g_rec_type

648: --
649: -- {End Of Comments}
650: -- ----------------------------------------------------------------------------
651: Procedure convert_defs
652: (p_rec in out nocopy per_sps_shd.g_rec_type
653: ) is
654: --
655: Begin
656: --

Line 664: per_sps_shd.g_old_rec.business_group_id;

660: -- is being used then we must set to the 'current' argument value.
661: --
662: If (p_rec.business_group_id = hr_api.g_number) then
663: p_rec.business_group_id :=
664: per_sps_shd.g_old_rec.business_group_id;
665: End If;
666: If (p_rec.spinal_point_id = hr_api.g_number) then
667: p_rec.spinal_point_id :=
668: per_sps_shd.g_old_rec.spinal_point_id;

Line 668: per_sps_shd.g_old_rec.spinal_point_id;

664: per_sps_shd.g_old_rec.business_group_id;
665: End If;
666: If (p_rec.spinal_point_id = hr_api.g_number) then
667: p_rec.spinal_point_id :=
668: per_sps_shd.g_old_rec.spinal_point_id;
669: End If;
670: If (p_rec.grade_spine_id = hr_api.g_number) then
671: p_rec.grade_spine_id :=
672: per_sps_shd.g_old_rec.grade_spine_id;

Line 672: per_sps_shd.g_old_rec.grade_spine_id;

668: per_sps_shd.g_old_rec.spinal_point_id;
669: End If;
670: If (p_rec.grade_spine_id = hr_api.g_number) then
671: p_rec.grade_spine_id :=
672: per_sps_shd.g_old_rec.grade_spine_id;
673: End If;
674: If (p_rec.sequence = hr_api.g_number) then
675: p_rec.sequence :=
676: per_sps_shd.g_old_rec.sequence;

Line 676: per_sps_shd.g_old_rec.sequence;

672: per_sps_shd.g_old_rec.grade_spine_id;
673: End If;
674: If (p_rec.sequence = hr_api.g_number) then
675: p_rec.sequence :=
676: per_sps_shd.g_old_rec.sequence;
677: End If;
678: If (p_rec.request_id = hr_api.g_number) then
679: p_rec.request_id :=
680: per_sps_shd.g_old_rec.request_id;

Line 680: per_sps_shd.g_old_rec.request_id;

676: per_sps_shd.g_old_rec.sequence;
677: End If;
678: If (p_rec.request_id = hr_api.g_number) then
679: p_rec.request_id :=
680: per_sps_shd.g_old_rec.request_id;
681: End If;
682: If (p_rec.program_application_id = hr_api.g_number) then
683: p_rec.program_application_id :=
684: per_sps_shd.g_old_rec.program_application_id;

Line 684: per_sps_shd.g_old_rec.program_application_id;

680: per_sps_shd.g_old_rec.request_id;
681: End If;
682: If (p_rec.program_application_id = hr_api.g_number) then
683: p_rec.program_application_id :=
684: per_sps_shd.g_old_rec.program_application_id;
685: End If;
686: If (p_rec.program_id = hr_api.g_number) then
687: p_rec.program_id :=
688: per_sps_shd.g_old_rec.program_id;

Line 688: per_sps_shd.g_old_rec.program_id;

684: per_sps_shd.g_old_rec.program_application_id;
685: End If;
686: If (p_rec.program_id = hr_api.g_number) then
687: p_rec.program_id :=
688: per_sps_shd.g_old_rec.program_id;
689: End If;
690: If (p_rec.program_update_date = hr_api.g_date) then
691: p_rec.program_update_date :=
692: per_sps_shd.g_old_rec.program_update_date;

Line 692: per_sps_shd.g_old_rec.program_update_date;

688: per_sps_shd.g_old_rec.program_id;
689: End If;
690: If (p_rec.program_update_date = hr_api.g_date) then
691: p_rec.program_update_date :=
692: per_sps_shd.g_old_rec.program_update_date;
693: End If;
694: If (p_rec.information1 = hr_api.g_varchar2) then
695: p_rec.information1 :=
696: per_sps_shd.g_old_rec.information1;

Line 696: per_sps_shd.g_old_rec.information1;

692: per_sps_shd.g_old_rec.program_update_date;
693: End If;
694: If (p_rec.information1 = hr_api.g_varchar2) then
695: p_rec.information1 :=
696: per_sps_shd.g_old_rec.information1;
697: End If;
698: If (p_rec.information2 = hr_api.g_varchar2) then
699: p_rec.information2 :=
700: per_sps_shd.g_old_rec.information2;

Line 700: per_sps_shd.g_old_rec.information2;

696: per_sps_shd.g_old_rec.information1;
697: End If;
698: If (p_rec.information2 = hr_api.g_varchar2) then
699: p_rec.information2 :=
700: per_sps_shd.g_old_rec.information2;
701: End If;
702: If (p_rec.information3 = hr_api.g_varchar2) then
703: p_rec.information3 :=
704: per_sps_shd.g_old_rec.information3;

Line 704: per_sps_shd.g_old_rec.information3;

700: per_sps_shd.g_old_rec.information2;
701: End If;
702: If (p_rec.information3 = hr_api.g_varchar2) then
703: p_rec.information3 :=
704: per_sps_shd.g_old_rec.information3;
705: End If;
706: If (p_rec.information4 = hr_api.g_varchar2) then
707: p_rec.information4 :=
708: per_sps_shd.g_old_rec.information4;

Line 708: per_sps_shd.g_old_rec.information4;

704: per_sps_shd.g_old_rec.information3;
705: End If;
706: If (p_rec.information4 = hr_api.g_varchar2) then
707: p_rec.information4 :=
708: per_sps_shd.g_old_rec.information4;
709: End If;
710: If (p_rec.information5 = hr_api.g_varchar2) then
711: p_rec.information5 :=
712: per_sps_shd.g_old_rec.information5;

Line 712: per_sps_shd.g_old_rec.information5;

708: per_sps_shd.g_old_rec.information4;
709: End If;
710: If (p_rec.information5 = hr_api.g_varchar2) then
711: p_rec.information5 :=
712: per_sps_shd.g_old_rec.information5;
713: End If;
714: If (p_rec.information6 = hr_api.g_varchar2) then
715: p_rec.information6 :=
716: per_sps_shd.g_old_rec.information6;

Line 716: per_sps_shd.g_old_rec.information6;

712: per_sps_shd.g_old_rec.information5;
713: End If;
714: If (p_rec.information6 = hr_api.g_varchar2) then
715: p_rec.information6 :=
716: per_sps_shd.g_old_rec.information6;
717: End If;
718: If (p_rec.information7 = hr_api.g_varchar2) then
719: p_rec.information7 :=
720: per_sps_shd.g_old_rec.information7;

Line 720: per_sps_shd.g_old_rec.information7;

716: per_sps_shd.g_old_rec.information6;
717: End If;
718: If (p_rec.information7 = hr_api.g_varchar2) then
719: p_rec.information7 :=
720: per_sps_shd.g_old_rec.information7;
721: End If;
722: If (p_rec.information8 = hr_api.g_varchar2) then
723: p_rec.information8 :=
724: per_sps_shd.g_old_rec.information8;

Line 724: per_sps_shd.g_old_rec.information8;

720: per_sps_shd.g_old_rec.information7;
721: End If;
722: If (p_rec.information8 = hr_api.g_varchar2) then
723: p_rec.information8 :=
724: per_sps_shd.g_old_rec.information8;
725: End If;
726: If (p_rec.information9 = hr_api.g_varchar2) then
727: p_rec.information9 :=
728: per_sps_shd.g_old_rec.information9;

Line 728: per_sps_shd.g_old_rec.information9;

724: per_sps_shd.g_old_rec.information8;
725: End If;
726: If (p_rec.information9 = hr_api.g_varchar2) then
727: p_rec.information9 :=
728: per_sps_shd.g_old_rec.information9;
729: End If;
730: If (p_rec.information10 = hr_api.g_varchar2) then
731: p_rec.information10 :=
732: per_sps_shd.g_old_rec.information10;

Line 732: per_sps_shd.g_old_rec.information10;

728: per_sps_shd.g_old_rec.information9;
729: End If;
730: If (p_rec.information10 = hr_api.g_varchar2) then
731: p_rec.information10 :=
732: per_sps_shd.g_old_rec.information10;
733: End If;
734: If (p_rec.information11 = hr_api.g_varchar2) then
735: p_rec.information11 :=
736: per_sps_shd.g_old_rec.information11;

Line 736: per_sps_shd.g_old_rec.information11;

732: per_sps_shd.g_old_rec.information10;
733: End If;
734: If (p_rec.information11 = hr_api.g_varchar2) then
735: p_rec.information11 :=
736: per_sps_shd.g_old_rec.information11;
737: End If;
738: If (p_rec.information12 = hr_api.g_varchar2) then
739: p_rec.information12 :=
740: per_sps_shd.g_old_rec.information12;

Line 740: per_sps_shd.g_old_rec.information12;

736: per_sps_shd.g_old_rec.information11;
737: End If;
738: If (p_rec.information12 = hr_api.g_varchar2) then
739: p_rec.information12 :=
740: per_sps_shd.g_old_rec.information12;
741: End If;
742: If (p_rec.information13 = hr_api.g_varchar2) then
743: p_rec.information13 :=
744: per_sps_shd.g_old_rec.information13;

Line 744: per_sps_shd.g_old_rec.information13;

740: per_sps_shd.g_old_rec.information12;
741: End If;
742: If (p_rec.information13 = hr_api.g_varchar2) then
743: p_rec.information13 :=
744: per_sps_shd.g_old_rec.information13;
745: End If;
746: If (p_rec.information14 = hr_api.g_varchar2) then
747: p_rec.information14 :=
748: per_sps_shd.g_old_rec.information14;

Line 748: per_sps_shd.g_old_rec.information14;

744: per_sps_shd.g_old_rec.information13;
745: End If;
746: If (p_rec.information14 = hr_api.g_varchar2) then
747: p_rec.information14 :=
748: per_sps_shd.g_old_rec.information14;
749: End If;
750: If (p_rec.information15 = hr_api.g_varchar2) then
751: p_rec.information15 :=
752: per_sps_shd.g_old_rec.information15;

Line 752: per_sps_shd.g_old_rec.information15;

748: per_sps_shd.g_old_rec.information14;
749: End If;
750: If (p_rec.information15 = hr_api.g_varchar2) then
751: p_rec.information15 :=
752: per_sps_shd.g_old_rec.information15;
753: End If;
754: If (p_rec.information16 = hr_api.g_varchar2) then
755: p_rec.information16 :=
756: per_sps_shd.g_old_rec.information16;

Line 756: per_sps_shd.g_old_rec.information16;

752: per_sps_shd.g_old_rec.information15;
753: End If;
754: If (p_rec.information16 = hr_api.g_varchar2) then
755: p_rec.information16 :=
756: per_sps_shd.g_old_rec.information16;
757: End If;
758: If (p_rec.information17 = hr_api.g_varchar2) then
759: p_rec.information17 :=
760: per_sps_shd.g_old_rec.information17;

Line 760: per_sps_shd.g_old_rec.information17;

756: per_sps_shd.g_old_rec.information16;
757: End If;
758: If (p_rec.information17 = hr_api.g_varchar2) then
759: p_rec.information17 :=
760: per_sps_shd.g_old_rec.information17;
761: End If;
762: If (p_rec.information18 = hr_api.g_varchar2) then
763: p_rec.information18 :=
764: per_sps_shd.g_old_rec.information18;

Line 764: per_sps_shd.g_old_rec.information18;

760: per_sps_shd.g_old_rec.information17;
761: End If;
762: If (p_rec.information18 = hr_api.g_varchar2) then
763: p_rec.information18 :=
764: per_sps_shd.g_old_rec.information18;
765: End If;
766: If (p_rec.information19 = hr_api.g_varchar2) then
767: p_rec.information19 :=
768: per_sps_shd.g_old_rec.information19;

Line 768: per_sps_shd.g_old_rec.information19;

764: per_sps_shd.g_old_rec.information18;
765: End If;
766: If (p_rec.information19 = hr_api.g_varchar2) then
767: p_rec.information19 :=
768: per_sps_shd.g_old_rec.information19;
769: End If;
770: If (p_rec.information20 = hr_api.g_varchar2) then
771: p_rec.information20 :=
772: per_sps_shd.g_old_rec.information20;

Line 772: per_sps_shd.g_old_rec.information20;

768: per_sps_shd.g_old_rec.information19;
769: End If;
770: If (p_rec.information20 = hr_api.g_varchar2) then
771: p_rec.information20 :=
772: per_sps_shd.g_old_rec.information20;
773: End If;
774: If (p_rec.information21 = hr_api.g_varchar2) then
775: p_rec.information21 :=
776: per_sps_shd.g_old_rec.information21;

Line 776: per_sps_shd.g_old_rec.information21;

772: per_sps_shd.g_old_rec.information20;
773: End If;
774: If (p_rec.information21 = hr_api.g_varchar2) then
775: p_rec.information21 :=
776: per_sps_shd.g_old_rec.information21;
777: End If;
778: If (p_rec.information22 = hr_api.g_varchar2) then
779: p_rec.information22 :=
780: per_sps_shd.g_old_rec.information22;

Line 780: per_sps_shd.g_old_rec.information22;

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

Line 784: per_sps_shd.g_old_rec.information23;

780: per_sps_shd.g_old_rec.information22;
781: End If;
782: If (p_rec.information23 = hr_api.g_varchar2) then
783: p_rec.information23 :=
784: per_sps_shd.g_old_rec.information23;
785: End If;
786: If (p_rec.information24 = hr_api.g_varchar2) then
787: p_rec.information24 :=
788: per_sps_shd.g_old_rec.information24;

Line 788: per_sps_shd.g_old_rec.information24;

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

Line 792: per_sps_shd.g_old_rec.information25;

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

Line 796: per_sps_shd.g_old_rec.information26;

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

Line 800: per_sps_shd.g_old_rec.information27;

796: per_sps_shd.g_old_rec.information26;
797: End If;
798: If (p_rec.information27 = hr_api.g_varchar2) then
799: p_rec.information27 :=
800: per_sps_shd.g_old_rec.information27;
801: End If;
802: If (p_rec.information28 = hr_api.g_varchar2) then
803: p_rec.information28 :=
804: per_sps_shd.g_old_rec.information28;

Line 804: per_sps_shd.g_old_rec.information28;

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

Line 808: per_sps_shd.g_old_rec.information29;

804: per_sps_shd.g_old_rec.information28;
805: End If;
806: If (p_rec.information29 = hr_api.g_varchar2) then
807: p_rec.information29 :=
808: per_sps_shd.g_old_rec.information29;
809: End If;
810: If (p_rec.information30 = hr_api.g_varchar2) then
811: p_rec.information30 :=
812: per_sps_shd.g_old_rec.information30;

Line 812: per_sps_shd.g_old_rec.information30;

808: per_sps_shd.g_old_rec.information29;
809: End If;
810: If (p_rec.information30 = hr_api.g_varchar2) then
811: p_rec.information30 :=
812: per_sps_shd.g_old_rec.information30;
813: End If;
814: If (p_rec.information_category = hr_api.g_varchar2) then
815: p_rec.information_category :=
816: per_sps_shd.g_old_rec.information_category;

Line 816: per_sps_shd.g_old_rec.information_category;

812: per_sps_shd.g_old_rec.information30;
813: End If;
814: If (p_rec.information_category = hr_api.g_varchar2) then
815: p_rec.information_category :=
816: per_sps_shd.g_old_rec.information_category;
817: End If;
818: --
819: End convert_defs;
820: --

Line 827: ,p_rec in out nocopy per_sps_shd.g_rec_type

823: -- ----------------------------------------------------------------------------
824: Procedure upd
825: (p_effective_date in date
826: ,p_datetrack_mode in varchar2
827: ,p_rec in out nocopy per_sps_shd.g_rec_type
828: ) is
829: --
830: l_proc varchar2(72) := g_package||'upd';
831: l_validation_start_date date;

Line 843: per_sps_shd.lck

839: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
840: --
841: -- We must lock the row which we need to update.
842: --
843: per_sps_shd.lck
844: (p_effective_date => p_effective_date
845: ,p_datetrack_mode => p_datetrack_mode
846: ,p_step_id => p_rec.step_id
847: ,p_object_version_number => p_rec.object_version_number

Line 956: l_rec per_sps_shd.g_rec_type;

952: ,p_effective_start_date out nocopy date
953: ,p_effective_end_date out nocopy date
954: ) is
955: --
956: l_rec per_sps_shd.g_rec_type;
957: l_proc varchar2(72) := g_package||'upd';
958: --
959: Begin
960: hr_utility.set_location('Entering:'||l_proc, 5);

Line 966: per_sps_shd.convert_args

962: -- Call conversion function to turn arguments into the
963: -- l_rec structure.
964: --
965: l_rec :=
966: per_sps_shd.convert_args
967: (p_step_id
968: ,null
969: ,null
970: ,p_business_group_id