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_DEL dependencies on PER_SPP_SHD

Line 54: (p_rec in out nocopy per_spp_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy per_spp_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

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

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: per_spp_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

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

71: delete from per_spinal_point_placements_f
72: where placement_id = p_rec.placement_id
73: and effective_start_date = p_validation_start_date;
74: --
75: per_spp_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: per_spp_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

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

73: and effective_start_date = p_validation_start_date;
74: --
75: per_spp_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: per_spp_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

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

82: delete from per_spinal_point_placements_f
83: where placement_id = p_rec.placement_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: per_spp_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --

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

89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: per_spp_shd.g_api_dml := false; -- Unset the api dml status
94: Raise;
95: --
96: End dt_delete_dml;
97: --

Line 102: (p_rec in out nocopy per_spp_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy per_spp_shd.g_rec_type
103: ,p_effective_date in date
104: ,p_datetrack_mode in varchar2
105: ,p_validation_start_date in date
106: ,p_validation_end_date in date

Line 159: (p_rec in out nocopy per_spp_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_pre_delete
159: (p_rec in out nocopy per_spp_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 174: := per_spp_shd.g_old_rec.effective_start_date;

170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date
174: := per_spp_shd.g_old_rec.effective_start_date;
175: --
176: If (p_datetrack_mode = hr_api.g_delete) then
177: p_rec.effective_end_date := p_validation_start_date - 1;
178: Else

Line 184: per_spp_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: per_spp_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.placement_id
187: ,p_new_effective_end_date => p_rec.effective_end_date
188: ,p_validation_start_date => p_validation_start_date

Line 233: (p_rec in out nocopy per_spp_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out nocopy per_spp_shd.g_rec_type
234: ,p_effective_date in date
235: ,p_datetrack_mode in varchar2
236: ,p_validation_start_date in date
237: ,p_validation_end_date in date

Line 293: (p_rec in per_spp_shd.g_rec_type

289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_delete
293: (p_rec in per_spp_shd.g_rec_type
294: ,p_effective_date in date
295: ,p_datetrack_mode in varchar2
296: ,p_validation_start_date in date
297: ,p_validation_end_date in date

Line 368: => per_spp_shd.g_old_rec.effective_start_date

364: => p_rec.effective_start_date
365: ,p_effective_end_date
366: => p_rec.effective_end_date
367: ,p_effective_start_date_o
368: => per_spp_shd.g_old_rec.effective_start_date
369: ,p_effective_end_date_o
370: => per_spp_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => per_spp_shd.g_old_rec.business_group_id

Line 370: => per_spp_shd.g_old_rec.effective_end_date

366: => p_rec.effective_end_date
367: ,p_effective_start_date_o
368: => per_spp_shd.g_old_rec.effective_start_date
369: ,p_effective_end_date_o
370: => per_spp_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => per_spp_shd.g_old_rec.business_group_id
373: ,p_assignment_id_o
374: => per_spp_shd.g_old_rec.assignment_id

Line 372: => per_spp_shd.g_old_rec.business_group_id

368: => per_spp_shd.g_old_rec.effective_start_date
369: ,p_effective_end_date_o
370: => per_spp_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => per_spp_shd.g_old_rec.business_group_id
373: ,p_assignment_id_o
374: => per_spp_shd.g_old_rec.assignment_id
375: ,p_step_id_o
376: => per_spp_shd.g_old_rec.step_id

Line 374: => per_spp_shd.g_old_rec.assignment_id

370: => per_spp_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => per_spp_shd.g_old_rec.business_group_id
373: ,p_assignment_id_o
374: => per_spp_shd.g_old_rec.assignment_id
375: ,p_step_id_o
376: => per_spp_shd.g_old_rec.step_id
377: ,p_auto_increment_flag_o
378: => per_spp_shd.g_old_rec.auto_increment_flag

Line 376: => per_spp_shd.g_old_rec.step_id

372: => per_spp_shd.g_old_rec.business_group_id
373: ,p_assignment_id_o
374: => per_spp_shd.g_old_rec.assignment_id
375: ,p_step_id_o
376: => per_spp_shd.g_old_rec.step_id
377: ,p_auto_increment_flag_o
378: => per_spp_shd.g_old_rec.auto_increment_flag
379: ,p_parent_spine_id_o
380: => per_spp_shd.g_old_rec.parent_spine_id

Line 378: => per_spp_shd.g_old_rec.auto_increment_flag

374: => per_spp_shd.g_old_rec.assignment_id
375: ,p_step_id_o
376: => per_spp_shd.g_old_rec.step_id
377: ,p_auto_increment_flag_o
378: => per_spp_shd.g_old_rec.auto_increment_flag
379: ,p_parent_spine_id_o
380: => per_spp_shd.g_old_rec.parent_spine_id
381: ,p_reason_o
382: => per_spp_shd.g_old_rec.reason

Line 380: => per_spp_shd.g_old_rec.parent_spine_id

376: => per_spp_shd.g_old_rec.step_id
377: ,p_auto_increment_flag_o
378: => per_spp_shd.g_old_rec.auto_increment_flag
379: ,p_parent_spine_id_o
380: => per_spp_shd.g_old_rec.parent_spine_id
381: ,p_reason_o
382: => per_spp_shd.g_old_rec.reason
383: ,p_request_id_o
384: => per_spp_shd.g_old_rec.request_id

Line 382: => per_spp_shd.g_old_rec.reason

378: => per_spp_shd.g_old_rec.auto_increment_flag
379: ,p_parent_spine_id_o
380: => per_spp_shd.g_old_rec.parent_spine_id
381: ,p_reason_o
382: => per_spp_shd.g_old_rec.reason
383: ,p_request_id_o
384: => per_spp_shd.g_old_rec.request_id
385: ,p_program_application_id_o
386: => per_spp_shd.g_old_rec.program_application_id

Line 384: => per_spp_shd.g_old_rec.request_id

380: => per_spp_shd.g_old_rec.parent_spine_id
381: ,p_reason_o
382: => per_spp_shd.g_old_rec.reason
383: ,p_request_id_o
384: => per_spp_shd.g_old_rec.request_id
385: ,p_program_application_id_o
386: => per_spp_shd.g_old_rec.program_application_id
387: ,p_program_id_o
388: => per_spp_shd.g_old_rec.program_id

Line 386: => per_spp_shd.g_old_rec.program_application_id

382: => per_spp_shd.g_old_rec.reason
383: ,p_request_id_o
384: => per_spp_shd.g_old_rec.request_id
385: ,p_program_application_id_o
386: => per_spp_shd.g_old_rec.program_application_id
387: ,p_program_id_o
388: => per_spp_shd.g_old_rec.program_id
389: ,p_program_update_date_o
390: => per_spp_shd.g_old_rec.program_update_date

Line 388: => per_spp_shd.g_old_rec.program_id

384: => per_spp_shd.g_old_rec.request_id
385: ,p_program_application_id_o
386: => per_spp_shd.g_old_rec.program_application_id
387: ,p_program_id_o
388: => per_spp_shd.g_old_rec.program_id
389: ,p_program_update_date_o
390: => per_spp_shd.g_old_rec.program_update_date
391: ,p_increment_number_o
392: => per_spp_shd.g_old_rec.increment_number

Line 390: => per_spp_shd.g_old_rec.program_update_date

386: => per_spp_shd.g_old_rec.program_application_id
387: ,p_program_id_o
388: => per_spp_shd.g_old_rec.program_id
389: ,p_program_update_date_o
390: => per_spp_shd.g_old_rec.program_update_date
391: ,p_increment_number_o
392: => per_spp_shd.g_old_rec.increment_number
393: ,p_information1_o => per_spp_shd.g_old_rec.information1
394: ,p_information2_o => per_spp_shd.g_old_rec.information2

Line 392: => per_spp_shd.g_old_rec.increment_number

388: => per_spp_shd.g_old_rec.program_id
389: ,p_program_update_date_o
390: => per_spp_shd.g_old_rec.program_update_date
391: ,p_increment_number_o
392: => per_spp_shd.g_old_rec.increment_number
393: ,p_information1_o => per_spp_shd.g_old_rec.information1
394: ,p_information2_o => per_spp_shd.g_old_rec.information2
395: ,p_information3_o => per_spp_shd.g_old_rec.information3
396: ,p_information4_o => per_spp_shd.g_old_rec.information4

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

389: ,p_program_update_date_o
390: => per_spp_shd.g_old_rec.program_update_date
391: ,p_increment_number_o
392: => per_spp_shd.g_old_rec.increment_number
393: ,p_information1_o => per_spp_shd.g_old_rec.information1
394: ,p_information2_o => per_spp_shd.g_old_rec.information2
395: ,p_information3_o => per_spp_shd.g_old_rec.information3
396: ,p_information4_o => per_spp_shd.g_old_rec.information4
397: ,p_information5_o => per_spp_shd.g_old_rec.information5

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

390: => per_spp_shd.g_old_rec.program_update_date
391: ,p_increment_number_o
392: => per_spp_shd.g_old_rec.increment_number
393: ,p_information1_o => per_spp_shd.g_old_rec.information1
394: ,p_information2_o => per_spp_shd.g_old_rec.information2
395: ,p_information3_o => per_spp_shd.g_old_rec.information3
396: ,p_information4_o => per_spp_shd.g_old_rec.information4
397: ,p_information5_o => per_spp_shd.g_old_rec.information5
398: ,p_information6_o => per_spp_shd.g_old_rec.information6

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

391: ,p_increment_number_o
392: => per_spp_shd.g_old_rec.increment_number
393: ,p_information1_o => per_spp_shd.g_old_rec.information1
394: ,p_information2_o => per_spp_shd.g_old_rec.information2
395: ,p_information3_o => per_spp_shd.g_old_rec.information3
396: ,p_information4_o => per_spp_shd.g_old_rec.information4
397: ,p_information5_o => per_spp_shd.g_old_rec.information5
398: ,p_information6_o => per_spp_shd.g_old_rec.information6
399: ,p_information7_o => per_spp_shd.g_old_rec.information7

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

392: => per_spp_shd.g_old_rec.increment_number
393: ,p_information1_o => per_spp_shd.g_old_rec.information1
394: ,p_information2_o => per_spp_shd.g_old_rec.information2
395: ,p_information3_o => per_spp_shd.g_old_rec.information3
396: ,p_information4_o => per_spp_shd.g_old_rec.information4
397: ,p_information5_o => per_spp_shd.g_old_rec.information5
398: ,p_information6_o => per_spp_shd.g_old_rec.information6
399: ,p_information7_o => per_spp_shd.g_old_rec.information7
400: ,p_information8_o => per_spp_shd.g_old_rec.information8

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

393: ,p_information1_o => per_spp_shd.g_old_rec.information1
394: ,p_information2_o => per_spp_shd.g_old_rec.information2
395: ,p_information3_o => per_spp_shd.g_old_rec.information3
396: ,p_information4_o => per_spp_shd.g_old_rec.information4
397: ,p_information5_o => per_spp_shd.g_old_rec.information5
398: ,p_information6_o => per_spp_shd.g_old_rec.information6
399: ,p_information7_o => per_spp_shd.g_old_rec.information7
400: ,p_information8_o => per_spp_shd.g_old_rec.information8
401: ,p_information9_o => per_spp_shd.g_old_rec.information9

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

394: ,p_information2_o => per_spp_shd.g_old_rec.information2
395: ,p_information3_o => per_spp_shd.g_old_rec.information3
396: ,p_information4_o => per_spp_shd.g_old_rec.information4
397: ,p_information5_o => per_spp_shd.g_old_rec.information5
398: ,p_information6_o => per_spp_shd.g_old_rec.information6
399: ,p_information7_o => per_spp_shd.g_old_rec.information7
400: ,p_information8_o => per_spp_shd.g_old_rec.information8
401: ,p_information9_o => per_spp_shd.g_old_rec.information9
402: ,p_information10_o => per_spp_shd.g_old_rec.information10

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

395: ,p_information3_o => per_spp_shd.g_old_rec.information3
396: ,p_information4_o => per_spp_shd.g_old_rec.information4
397: ,p_information5_o => per_spp_shd.g_old_rec.information5
398: ,p_information6_o => per_spp_shd.g_old_rec.information6
399: ,p_information7_o => per_spp_shd.g_old_rec.information7
400: ,p_information8_o => per_spp_shd.g_old_rec.information8
401: ,p_information9_o => per_spp_shd.g_old_rec.information9
402: ,p_information10_o => per_spp_shd.g_old_rec.information10
403: ,p_information11_o => per_spp_shd.g_old_rec.information11

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

396: ,p_information4_o => per_spp_shd.g_old_rec.information4
397: ,p_information5_o => per_spp_shd.g_old_rec.information5
398: ,p_information6_o => per_spp_shd.g_old_rec.information6
399: ,p_information7_o => per_spp_shd.g_old_rec.information7
400: ,p_information8_o => per_spp_shd.g_old_rec.information8
401: ,p_information9_o => per_spp_shd.g_old_rec.information9
402: ,p_information10_o => per_spp_shd.g_old_rec.information10
403: ,p_information11_o => per_spp_shd.g_old_rec.information11
404: ,p_information12_o => per_spp_shd.g_old_rec.information12

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

397: ,p_information5_o => per_spp_shd.g_old_rec.information5
398: ,p_information6_o => per_spp_shd.g_old_rec.information6
399: ,p_information7_o => per_spp_shd.g_old_rec.information7
400: ,p_information8_o => per_spp_shd.g_old_rec.information8
401: ,p_information9_o => per_spp_shd.g_old_rec.information9
402: ,p_information10_o => per_spp_shd.g_old_rec.information10
403: ,p_information11_o => per_spp_shd.g_old_rec.information11
404: ,p_information12_o => per_spp_shd.g_old_rec.information12
405: ,p_information13_o => per_spp_shd.g_old_rec.information13

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

398: ,p_information6_o => per_spp_shd.g_old_rec.information6
399: ,p_information7_o => per_spp_shd.g_old_rec.information7
400: ,p_information8_o => per_spp_shd.g_old_rec.information8
401: ,p_information9_o => per_spp_shd.g_old_rec.information9
402: ,p_information10_o => per_spp_shd.g_old_rec.information10
403: ,p_information11_o => per_spp_shd.g_old_rec.information11
404: ,p_information12_o => per_spp_shd.g_old_rec.information12
405: ,p_information13_o => per_spp_shd.g_old_rec.information13
406: ,p_information14_o => per_spp_shd.g_old_rec.information14

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

399: ,p_information7_o => per_spp_shd.g_old_rec.information7
400: ,p_information8_o => per_spp_shd.g_old_rec.information8
401: ,p_information9_o => per_spp_shd.g_old_rec.information9
402: ,p_information10_o => per_spp_shd.g_old_rec.information10
403: ,p_information11_o => per_spp_shd.g_old_rec.information11
404: ,p_information12_o => per_spp_shd.g_old_rec.information12
405: ,p_information13_o => per_spp_shd.g_old_rec.information13
406: ,p_information14_o => per_spp_shd.g_old_rec.information14
407: ,p_information15_o => per_spp_shd.g_old_rec.information15

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

400: ,p_information8_o => per_spp_shd.g_old_rec.information8
401: ,p_information9_o => per_spp_shd.g_old_rec.information9
402: ,p_information10_o => per_spp_shd.g_old_rec.information10
403: ,p_information11_o => per_spp_shd.g_old_rec.information11
404: ,p_information12_o => per_spp_shd.g_old_rec.information12
405: ,p_information13_o => per_spp_shd.g_old_rec.information13
406: ,p_information14_o => per_spp_shd.g_old_rec.information14
407: ,p_information15_o => per_spp_shd.g_old_rec.information15
408: ,p_information16_o => per_spp_shd.g_old_rec.information16

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

401: ,p_information9_o => per_spp_shd.g_old_rec.information9
402: ,p_information10_o => per_spp_shd.g_old_rec.information10
403: ,p_information11_o => per_spp_shd.g_old_rec.information11
404: ,p_information12_o => per_spp_shd.g_old_rec.information12
405: ,p_information13_o => per_spp_shd.g_old_rec.information13
406: ,p_information14_o => per_spp_shd.g_old_rec.information14
407: ,p_information15_o => per_spp_shd.g_old_rec.information15
408: ,p_information16_o => per_spp_shd.g_old_rec.information16
409: ,p_information17_o => per_spp_shd.g_old_rec.information17

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

402: ,p_information10_o => per_spp_shd.g_old_rec.information10
403: ,p_information11_o => per_spp_shd.g_old_rec.information11
404: ,p_information12_o => per_spp_shd.g_old_rec.information12
405: ,p_information13_o => per_spp_shd.g_old_rec.information13
406: ,p_information14_o => per_spp_shd.g_old_rec.information14
407: ,p_information15_o => per_spp_shd.g_old_rec.information15
408: ,p_information16_o => per_spp_shd.g_old_rec.information16
409: ,p_information17_o => per_spp_shd.g_old_rec.information17
410: ,p_information18_o => per_spp_shd.g_old_rec.information18

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

403: ,p_information11_o => per_spp_shd.g_old_rec.information11
404: ,p_information12_o => per_spp_shd.g_old_rec.information12
405: ,p_information13_o => per_spp_shd.g_old_rec.information13
406: ,p_information14_o => per_spp_shd.g_old_rec.information14
407: ,p_information15_o => per_spp_shd.g_old_rec.information15
408: ,p_information16_o => per_spp_shd.g_old_rec.information16
409: ,p_information17_o => per_spp_shd.g_old_rec.information17
410: ,p_information18_o => per_spp_shd.g_old_rec.information18
411: ,p_information19_o => per_spp_shd.g_old_rec.information19

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

404: ,p_information12_o => per_spp_shd.g_old_rec.information12
405: ,p_information13_o => per_spp_shd.g_old_rec.information13
406: ,p_information14_o => per_spp_shd.g_old_rec.information14
407: ,p_information15_o => per_spp_shd.g_old_rec.information15
408: ,p_information16_o => per_spp_shd.g_old_rec.information16
409: ,p_information17_o => per_spp_shd.g_old_rec.information17
410: ,p_information18_o => per_spp_shd.g_old_rec.information18
411: ,p_information19_o => per_spp_shd.g_old_rec.information19
412: ,p_information20_o => per_spp_shd.g_old_rec.information20

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

405: ,p_information13_o => per_spp_shd.g_old_rec.information13
406: ,p_information14_o => per_spp_shd.g_old_rec.information14
407: ,p_information15_o => per_spp_shd.g_old_rec.information15
408: ,p_information16_o => per_spp_shd.g_old_rec.information16
409: ,p_information17_o => per_spp_shd.g_old_rec.information17
410: ,p_information18_o => per_spp_shd.g_old_rec.information18
411: ,p_information19_o => per_spp_shd.g_old_rec.information19
412: ,p_information20_o => per_spp_shd.g_old_rec.information20
413: ,p_information21_o => per_spp_shd.g_old_rec.information21

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

406: ,p_information14_o => per_spp_shd.g_old_rec.information14
407: ,p_information15_o => per_spp_shd.g_old_rec.information15
408: ,p_information16_o => per_spp_shd.g_old_rec.information16
409: ,p_information17_o => per_spp_shd.g_old_rec.information17
410: ,p_information18_o => per_spp_shd.g_old_rec.information18
411: ,p_information19_o => per_spp_shd.g_old_rec.information19
412: ,p_information20_o => per_spp_shd.g_old_rec.information20
413: ,p_information21_o => per_spp_shd.g_old_rec.information21
414: ,p_information22_o => per_spp_shd.g_old_rec.information22

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

407: ,p_information15_o => per_spp_shd.g_old_rec.information15
408: ,p_information16_o => per_spp_shd.g_old_rec.information16
409: ,p_information17_o => per_spp_shd.g_old_rec.information17
410: ,p_information18_o => per_spp_shd.g_old_rec.information18
411: ,p_information19_o => per_spp_shd.g_old_rec.information19
412: ,p_information20_o => per_spp_shd.g_old_rec.information20
413: ,p_information21_o => per_spp_shd.g_old_rec.information21
414: ,p_information22_o => per_spp_shd.g_old_rec.information22
415: ,p_information23_o => per_spp_shd.g_old_rec.information23

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

408: ,p_information16_o => per_spp_shd.g_old_rec.information16
409: ,p_information17_o => per_spp_shd.g_old_rec.information17
410: ,p_information18_o => per_spp_shd.g_old_rec.information18
411: ,p_information19_o => per_spp_shd.g_old_rec.information19
412: ,p_information20_o => per_spp_shd.g_old_rec.information20
413: ,p_information21_o => per_spp_shd.g_old_rec.information21
414: ,p_information22_o => per_spp_shd.g_old_rec.information22
415: ,p_information23_o => per_spp_shd.g_old_rec.information23
416: ,p_information24_o => per_spp_shd.g_old_rec.information24

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

409: ,p_information17_o => per_spp_shd.g_old_rec.information17
410: ,p_information18_o => per_spp_shd.g_old_rec.information18
411: ,p_information19_o => per_spp_shd.g_old_rec.information19
412: ,p_information20_o => per_spp_shd.g_old_rec.information20
413: ,p_information21_o => per_spp_shd.g_old_rec.information21
414: ,p_information22_o => per_spp_shd.g_old_rec.information22
415: ,p_information23_o => per_spp_shd.g_old_rec.information23
416: ,p_information24_o => per_spp_shd.g_old_rec.information24
417: ,p_information25_o => per_spp_shd.g_old_rec.information25

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

410: ,p_information18_o => per_spp_shd.g_old_rec.information18
411: ,p_information19_o => per_spp_shd.g_old_rec.information19
412: ,p_information20_o => per_spp_shd.g_old_rec.information20
413: ,p_information21_o => per_spp_shd.g_old_rec.information21
414: ,p_information22_o => per_spp_shd.g_old_rec.information22
415: ,p_information23_o => per_spp_shd.g_old_rec.information23
416: ,p_information24_o => per_spp_shd.g_old_rec.information24
417: ,p_information25_o => per_spp_shd.g_old_rec.information25
418: ,p_information26_o => per_spp_shd.g_old_rec.information26

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

411: ,p_information19_o => per_spp_shd.g_old_rec.information19
412: ,p_information20_o => per_spp_shd.g_old_rec.information20
413: ,p_information21_o => per_spp_shd.g_old_rec.information21
414: ,p_information22_o => per_spp_shd.g_old_rec.information22
415: ,p_information23_o => per_spp_shd.g_old_rec.information23
416: ,p_information24_o => per_spp_shd.g_old_rec.information24
417: ,p_information25_o => per_spp_shd.g_old_rec.information25
418: ,p_information26_o => per_spp_shd.g_old_rec.information26
419: ,p_information27_o => per_spp_shd.g_old_rec.information27

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

412: ,p_information20_o => per_spp_shd.g_old_rec.information20
413: ,p_information21_o => per_spp_shd.g_old_rec.information21
414: ,p_information22_o => per_spp_shd.g_old_rec.information22
415: ,p_information23_o => per_spp_shd.g_old_rec.information23
416: ,p_information24_o => per_spp_shd.g_old_rec.information24
417: ,p_information25_o => per_spp_shd.g_old_rec.information25
418: ,p_information26_o => per_spp_shd.g_old_rec.information26
419: ,p_information27_o => per_spp_shd.g_old_rec.information27
420: ,p_information28_o => per_spp_shd.g_old_rec.information28

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

413: ,p_information21_o => per_spp_shd.g_old_rec.information21
414: ,p_information22_o => per_spp_shd.g_old_rec.information22
415: ,p_information23_o => per_spp_shd.g_old_rec.information23
416: ,p_information24_o => per_spp_shd.g_old_rec.information24
417: ,p_information25_o => per_spp_shd.g_old_rec.information25
418: ,p_information26_o => per_spp_shd.g_old_rec.information26
419: ,p_information27_o => per_spp_shd.g_old_rec.information27
420: ,p_information28_o => per_spp_shd.g_old_rec.information28
421: ,p_information29_o => per_spp_shd.g_old_rec.information29

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

414: ,p_information22_o => per_spp_shd.g_old_rec.information22
415: ,p_information23_o => per_spp_shd.g_old_rec.information23
416: ,p_information24_o => per_spp_shd.g_old_rec.information24
417: ,p_information25_o => per_spp_shd.g_old_rec.information25
418: ,p_information26_o => per_spp_shd.g_old_rec.information26
419: ,p_information27_o => per_spp_shd.g_old_rec.information27
420: ,p_information28_o => per_spp_shd.g_old_rec.information28
421: ,p_information29_o => per_spp_shd.g_old_rec.information29
422: ,p_information30_o => per_spp_shd.g_old_rec.information30

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

415: ,p_information23_o => per_spp_shd.g_old_rec.information23
416: ,p_information24_o => per_spp_shd.g_old_rec.information24
417: ,p_information25_o => per_spp_shd.g_old_rec.information25
418: ,p_information26_o => per_spp_shd.g_old_rec.information26
419: ,p_information27_o => per_spp_shd.g_old_rec.information27
420: ,p_information28_o => per_spp_shd.g_old_rec.information28
421: ,p_information29_o => per_spp_shd.g_old_rec.information29
422: ,p_information30_o => per_spp_shd.g_old_rec.information30
423: ,p_information_category_o => per_spp_shd.g_old_rec.information_category

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

416: ,p_information24_o => per_spp_shd.g_old_rec.information24
417: ,p_information25_o => per_spp_shd.g_old_rec.information25
418: ,p_information26_o => per_spp_shd.g_old_rec.information26
419: ,p_information27_o => per_spp_shd.g_old_rec.information27
420: ,p_information28_o => per_spp_shd.g_old_rec.information28
421: ,p_information29_o => per_spp_shd.g_old_rec.information29
422: ,p_information30_o => per_spp_shd.g_old_rec.information30
423: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
424: ,p_object_version_number_o

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

417: ,p_information25_o => per_spp_shd.g_old_rec.information25
418: ,p_information26_o => per_spp_shd.g_old_rec.information26
419: ,p_information27_o => per_spp_shd.g_old_rec.information27
420: ,p_information28_o => per_spp_shd.g_old_rec.information28
421: ,p_information29_o => per_spp_shd.g_old_rec.information29
422: ,p_information30_o => per_spp_shd.g_old_rec.information30
423: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
424: ,p_object_version_number_o
425: => per_spp_shd.g_old_rec.object_version_number

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

418: ,p_information26_o => per_spp_shd.g_old_rec.information26
419: ,p_information27_o => per_spp_shd.g_old_rec.information27
420: ,p_information28_o => per_spp_shd.g_old_rec.information28
421: ,p_information29_o => per_spp_shd.g_old_rec.information29
422: ,p_information30_o => per_spp_shd.g_old_rec.information30
423: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
424: ,p_object_version_number_o
425: => per_spp_shd.g_old_rec.object_version_number
426: );

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

419: ,p_information27_o => per_spp_shd.g_old_rec.information27
420: ,p_information28_o => per_spp_shd.g_old_rec.information28
421: ,p_information29_o => per_spp_shd.g_old_rec.information29
422: ,p_information30_o => per_spp_shd.g_old_rec.information30
423: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
424: ,p_object_version_number_o
425: => per_spp_shd.g_old_rec.object_version_number
426: );
427: --

Line 425: => per_spp_shd.g_old_rec.object_version_number

421: ,p_information29_o => per_spp_shd.g_old_rec.information29
422: ,p_information30_o => per_spp_shd.g_old_rec.information30
423: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
424: ,p_object_version_number_o
425: => per_spp_shd.g_old_rec.object_version_number
426: );
427: --
428: exception
429: --

Line 447: ,p_rec in out nocopy per_spp_shd.g_rec_type

443: -- ----------------------------------------------------------------------------
444: Procedure del
445: (p_effective_date in date
446: ,p_datetrack_mode in varchar2
447: ,p_rec in out nocopy per_spp_shd.g_rec_type
448: ) is
449: --
450: l_proc varchar2(72) := g_package||'del';
451: l_validation_start_date date;

Line 463: per_spp_shd.lck

459: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
460: --
461: -- We must lock the row which we need to delete.
462: --
463: per_spp_shd.lck
464: (p_effective_date => p_effective_date
465: ,p_datetrack_mode => p_datetrack_mode
466: ,p_placement_id => p_rec.placement_id
467: ,p_object_version_number => p_rec.object_version_number

Line 528: l_rec per_spp_shd.g_rec_type;

524: ,p_effective_start_date out nocopy date
525: ,p_effective_end_date out nocopy date
526: ) is
527: --
528: l_rec per_spp_shd.g_rec_type;
529: l_proc varchar2(72) := g_package||'del';
530: --
531: Begin
532: hr_utility.set_location('Entering:'||l_proc, 5);