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

318: => p_rec.effective_start_date
319: ,p_effective_end_date
320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => per_spp_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => per_spp_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => per_spp_shd.g_old_rec.business_group_id

Line 324: => per_spp_shd.g_old_rec.effective_end_date

320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => per_spp_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => per_spp_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => per_spp_shd.g_old_rec.business_group_id
327: ,p_assignment_id_o
328: => per_spp_shd.g_old_rec.assignment_id

Line 326: => per_spp_shd.g_old_rec.business_group_id

322: => per_spp_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => per_spp_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => per_spp_shd.g_old_rec.business_group_id
327: ,p_assignment_id_o
328: => per_spp_shd.g_old_rec.assignment_id
329: ,p_step_id_o
330: => per_spp_shd.g_old_rec.step_id

Line 328: => per_spp_shd.g_old_rec.assignment_id

324: => per_spp_shd.g_old_rec.effective_end_date
325: ,p_business_group_id_o
326: => per_spp_shd.g_old_rec.business_group_id
327: ,p_assignment_id_o
328: => per_spp_shd.g_old_rec.assignment_id
329: ,p_step_id_o
330: => per_spp_shd.g_old_rec.step_id
331: ,p_auto_increment_flag_o
332: => per_spp_shd.g_old_rec.auto_increment_flag

Line 330: => per_spp_shd.g_old_rec.step_id

326: => per_spp_shd.g_old_rec.business_group_id
327: ,p_assignment_id_o
328: => per_spp_shd.g_old_rec.assignment_id
329: ,p_step_id_o
330: => per_spp_shd.g_old_rec.step_id
331: ,p_auto_increment_flag_o
332: => per_spp_shd.g_old_rec.auto_increment_flag
333: ,p_parent_spine_id_o
334: => per_spp_shd.g_old_rec.parent_spine_id

Line 332: => per_spp_shd.g_old_rec.auto_increment_flag

328: => per_spp_shd.g_old_rec.assignment_id
329: ,p_step_id_o
330: => per_spp_shd.g_old_rec.step_id
331: ,p_auto_increment_flag_o
332: => per_spp_shd.g_old_rec.auto_increment_flag
333: ,p_parent_spine_id_o
334: => per_spp_shd.g_old_rec.parent_spine_id
335: ,p_reason_o
336: => per_spp_shd.g_old_rec.reason

Line 334: => per_spp_shd.g_old_rec.parent_spine_id

330: => per_spp_shd.g_old_rec.step_id
331: ,p_auto_increment_flag_o
332: => per_spp_shd.g_old_rec.auto_increment_flag
333: ,p_parent_spine_id_o
334: => per_spp_shd.g_old_rec.parent_spine_id
335: ,p_reason_o
336: => per_spp_shd.g_old_rec.reason
337: ,p_request_id_o
338: => per_spp_shd.g_old_rec.request_id

Line 336: => per_spp_shd.g_old_rec.reason

332: => per_spp_shd.g_old_rec.auto_increment_flag
333: ,p_parent_spine_id_o
334: => per_spp_shd.g_old_rec.parent_spine_id
335: ,p_reason_o
336: => per_spp_shd.g_old_rec.reason
337: ,p_request_id_o
338: => per_spp_shd.g_old_rec.request_id
339: ,p_program_application_id_o
340: => per_spp_shd.g_old_rec.program_application_id

Line 338: => per_spp_shd.g_old_rec.request_id

334: => per_spp_shd.g_old_rec.parent_spine_id
335: ,p_reason_o
336: => per_spp_shd.g_old_rec.reason
337: ,p_request_id_o
338: => per_spp_shd.g_old_rec.request_id
339: ,p_program_application_id_o
340: => per_spp_shd.g_old_rec.program_application_id
341: ,p_program_id_o
342: => per_spp_shd.g_old_rec.program_id

Line 340: => per_spp_shd.g_old_rec.program_application_id

336: => per_spp_shd.g_old_rec.reason
337: ,p_request_id_o
338: => per_spp_shd.g_old_rec.request_id
339: ,p_program_application_id_o
340: => per_spp_shd.g_old_rec.program_application_id
341: ,p_program_id_o
342: => per_spp_shd.g_old_rec.program_id
343: ,p_program_update_date_o
344: => per_spp_shd.g_old_rec.program_update_date

Line 342: => per_spp_shd.g_old_rec.program_id

338: => per_spp_shd.g_old_rec.request_id
339: ,p_program_application_id_o
340: => per_spp_shd.g_old_rec.program_application_id
341: ,p_program_id_o
342: => per_spp_shd.g_old_rec.program_id
343: ,p_program_update_date_o
344: => per_spp_shd.g_old_rec.program_update_date
345: ,p_increment_number_o
346: => per_spp_shd.g_old_rec.increment_number

Line 344: => per_spp_shd.g_old_rec.program_update_date

340: => per_spp_shd.g_old_rec.program_application_id
341: ,p_program_id_o
342: => per_spp_shd.g_old_rec.program_id
343: ,p_program_update_date_o
344: => per_spp_shd.g_old_rec.program_update_date
345: ,p_increment_number_o
346: => per_spp_shd.g_old_rec.increment_number
347: ,p_information1_o => per_spp_shd.g_old_rec.information1
348: ,p_information2_o => per_spp_shd.g_old_rec.information2

Line 346: => per_spp_shd.g_old_rec.increment_number

342: => per_spp_shd.g_old_rec.program_id
343: ,p_program_update_date_o
344: => per_spp_shd.g_old_rec.program_update_date
345: ,p_increment_number_o
346: => per_spp_shd.g_old_rec.increment_number
347: ,p_information1_o => per_spp_shd.g_old_rec.information1
348: ,p_information2_o => per_spp_shd.g_old_rec.information2
349: ,p_information3_o => per_spp_shd.g_old_rec.information3
350: ,p_information4_o => per_spp_shd.g_old_rec.information4

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

343: ,p_program_update_date_o
344: => per_spp_shd.g_old_rec.program_update_date
345: ,p_increment_number_o
346: => per_spp_shd.g_old_rec.increment_number
347: ,p_information1_o => per_spp_shd.g_old_rec.information1
348: ,p_information2_o => per_spp_shd.g_old_rec.information2
349: ,p_information3_o => per_spp_shd.g_old_rec.information3
350: ,p_information4_o => per_spp_shd.g_old_rec.information4
351: ,p_information5_o => per_spp_shd.g_old_rec.information5

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

344: => per_spp_shd.g_old_rec.program_update_date
345: ,p_increment_number_o
346: => per_spp_shd.g_old_rec.increment_number
347: ,p_information1_o => per_spp_shd.g_old_rec.information1
348: ,p_information2_o => per_spp_shd.g_old_rec.information2
349: ,p_information3_o => per_spp_shd.g_old_rec.information3
350: ,p_information4_o => per_spp_shd.g_old_rec.information4
351: ,p_information5_o => per_spp_shd.g_old_rec.information5
352: ,p_information6_o => per_spp_shd.g_old_rec.information6

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

345: ,p_increment_number_o
346: => per_spp_shd.g_old_rec.increment_number
347: ,p_information1_o => per_spp_shd.g_old_rec.information1
348: ,p_information2_o => per_spp_shd.g_old_rec.information2
349: ,p_information3_o => per_spp_shd.g_old_rec.information3
350: ,p_information4_o => per_spp_shd.g_old_rec.information4
351: ,p_information5_o => per_spp_shd.g_old_rec.information5
352: ,p_information6_o => per_spp_shd.g_old_rec.information6
353: ,p_information7_o => per_spp_shd.g_old_rec.information7

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

346: => per_spp_shd.g_old_rec.increment_number
347: ,p_information1_o => per_spp_shd.g_old_rec.information1
348: ,p_information2_o => per_spp_shd.g_old_rec.information2
349: ,p_information3_o => per_spp_shd.g_old_rec.information3
350: ,p_information4_o => per_spp_shd.g_old_rec.information4
351: ,p_information5_o => per_spp_shd.g_old_rec.information5
352: ,p_information6_o => per_spp_shd.g_old_rec.information6
353: ,p_information7_o => per_spp_shd.g_old_rec.information7
354: ,p_information8_o => per_spp_shd.g_old_rec.information8

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

347: ,p_information1_o => per_spp_shd.g_old_rec.information1
348: ,p_information2_o => per_spp_shd.g_old_rec.information2
349: ,p_information3_o => per_spp_shd.g_old_rec.information3
350: ,p_information4_o => per_spp_shd.g_old_rec.information4
351: ,p_information5_o => per_spp_shd.g_old_rec.information5
352: ,p_information6_o => per_spp_shd.g_old_rec.information6
353: ,p_information7_o => per_spp_shd.g_old_rec.information7
354: ,p_information8_o => per_spp_shd.g_old_rec.information8
355: ,p_information9_o => per_spp_shd.g_old_rec.information9

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

348: ,p_information2_o => per_spp_shd.g_old_rec.information2
349: ,p_information3_o => per_spp_shd.g_old_rec.information3
350: ,p_information4_o => per_spp_shd.g_old_rec.information4
351: ,p_information5_o => per_spp_shd.g_old_rec.information5
352: ,p_information6_o => per_spp_shd.g_old_rec.information6
353: ,p_information7_o => per_spp_shd.g_old_rec.information7
354: ,p_information8_o => per_spp_shd.g_old_rec.information8
355: ,p_information9_o => per_spp_shd.g_old_rec.information9
356: ,p_information10_o => per_spp_shd.g_old_rec.information10

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

349: ,p_information3_o => per_spp_shd.g_old_rec.information3
350: ,p_information4_o => per_spp_shd.g_old_rec.information4
351: ,p_information5_o => per_spp_shd.g_old_rec.information5
352: ,p_information6_o => per_spp_shd.g_old_rec.information6
353: ,p_information7_o => per_spp_shd.g_old_rec.information7
354: ,p_information8_o => per_spp_shd.g_old_rec.information8
355: ,p_information9_o => per_spp_shd.g_old_rec.information9
356: ,p_information10_o => per_spp_shd.g_old_rec.information10
357: ,p_information11_o => per_spp_shd.g_old_rec.information11

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

350: ,p_information4_o => per_spp_shd.g_old_rec.information4
351: ,p_information5_o => per_spp_shd.g_old_rec.information5
352: ,p_information6_o => per_spp_shd.g_old_rec.information6
353: ,p_information7_o => per_spp_shd.g_old_rec.information7
354: ,p_information8_o => per_spp_shd.g_old_rec.information8
355: ,p_information9_o => per_spp_shd.g_old_rec.information9
356: ,p_information10_o => per_spp_shd.g_old_rec.information10
357: ,p_information11_o => per_spp_shd.g_old_rec.information11
358: ,p_information12_o => per_spp_shd.g_old_rec.information12

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

351: ,p_information5_o => per_spp_shd.g_old_rec.information5
352: ,p_information6_o => per_spp_shd.g_old_rec.information6
353: ,p_information7_o => per_spp_shd.g_old_rec.information7
354: ,p_information8_o => per_spp_shd.g_old_rec.information8
355: ,p_information9_o => per_spp_shd.g_old_rec.information9
356: ,p_information10_o => per_spp_shd.g_old_rec.information10
357: ,p_information11_o => per_spp_shd.g_old_rec.information11
358: ,p_information12_o => per_spp_shd.g_old_rec.information12
359: ,p_information13_o => per_spp_shd.g_old_rec.information13

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

352: ,p_information6_o => per_spp_shd.g_old_rec.information6
353: ,p_information7_o => per_spp_shd.g_old_rec.information7
354: ,p_information8_o => per_spp_shd.g_old_rec.information8
355: ,p_information9_o => per_spp_shd.g_old_rec.information9
356: ,p_information10_o => per_spp_shd.g_old_rec.information10
357: ,p_information11_o => per_spp_shd.g_old_rec.information11
358: ,p_information12_o => per_spp_shd.g_old_rec.information12
359: ,p_information13_o => per_spp_shd.g_old_rec.information13
360: ,p_information14_o => per_spp_shd.g_old_rec.information14

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

353: ,p_information7_o => per_spp_shd.g_old_rec.information7
354: ,p_information8_o => per_spp_shd.g_old_rec.information8
355: ,p_information9_o => per_spp_shd.g_old_rec.information9
356: ,p_information10_o => per_spp_shd.g_old_rec.information10
357: ,p_information11_o => per_spp_shd.g_old_rec.information11
358: ,p_information12_o => per_spp_shd.g_old_rec.information12
359: ,p_information13_o => per_spp_shd.g_old_rec.information13
360: ,p_information14_o => per_spp_shd.g_old_rec.information14
361: ,p_information15_o => per_spp_shd.g_old_rec.information15

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

354: ,p_information8_o => per_spp_shd.g_old_rec.information8
355: ,p_information9_o => per_spp_shd.g_old_rec.information9
356: ,p_information10_o => per_spp_shd.g_old_rec.information10
357: ,p_information11_o => per_spp_shd.g_old_rec.information11
358: ,p_information12_o => per_spp_shd.g_old_rec.information12
359: ,p_information13_o => per_spp_shd.g_old_rec.information13
360: ,p_information14_o => per_spp_shd.g_old_rec.information14
361: ,p_information15_o => per_spp_shd.g_old_rec.information15
362: ,p_information16_o => per_spp_shd.g_old_rec.information16

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

355: ,p_information9_o => per_spp_shd.g_old_rec.information9
356: ,p_information10_o => per_spp_shd.g_old_rec.information10
357: ,p_information11_o => per_spp_shd.g_old_rec.information11
358: ,p_information12_o => per_spp_shd.g_old_rec.information12
359: ,p_information13_o => per_spp_shd.g_old_rec.information13
360: ,p_information14_o => per_spp_shd.g_old_rec.information14
361: ,p_information15_o => per_spp_shd.g_old_rec.information15
362: ,p_information16_o => per_spp_shd.g_old_rec.information16
363: ,p_information17_o => per_spp_shd.g_old_rec.information17

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

356: ,p_information10_o => per_spp_shd.g_old_rec.information10
357: ,p_information11_o => per_spp_shd.g_old_rec.information11
358: ,p_information12_o => per_spp_shd.g_old_rec.information12
359: ,p_information13_o => per_spp_shd.g_old_rec.information13
360: ,p_information14_o => per_spp_shd.g_old_rec.information14
361: ,p_information15_o => per_spp_shd.g_old_rec.information15
362: ,p_information16_o => per_spp_shd.g_old_rec.information16
363: ,p_information17_o => per_spp_shd.g_old_rec.information17
364: ,p_information18_o => per_spp_shd.g_old_rec.information18

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

357: ,p_information11_o => per_spp_shd.g_old_rec.information11
358: ,p_information12_o => per_spp_shd.g_old_rec.information12
359: ,p_information13_o => per_spp_shd.g_old_rec.information13
360: ,p_information14_o => per_spp_shd.g_old_rec.information14
361: ,p_information15_o => per_spp_shd.g_old_rec.information15
362: ,p_information16_o => per_spp_shd.g_old_rec.information16
363: ,p_information17_o => per_spp_shd.g_old_rec.information17
364: ,p_information18_o => per_spp_shd.g_old_rec.information18
365: ,p_information19_o => per_spp_shd.g_old_rec.information19

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

358: ,p_information12_o => per_spp_shd.g_old_rec.information12
359: ,p_information13_o => per_spp_shd.g_old_rec.information13
360: ,p_information14_o => per_spp_shd.g_old_rec.information14
361: ,p_information15_o => per_spp_shd.g_old_rec.information15
362: ,p_information16_o => per_spp_shd.g_old_rec.information16
363: ,p_information17_o => per_spp_shd.g_old_rec.information17
364: ,p_information18_o => per_spp_shd.g_old_rec.information18
365: ,p_information19_o => per_spp_shd.g_old_rec.information19
366: ,p_information20_o => per_spp_shd.g_old_rec.information20

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

359: ,p_information13_o => per_spp_shd.g_old_rec.information13
360: ,p_information14_o => per_spp_shd.g_old_rec.information14
361: ,p_information15_o => per_spp_shd.g_old_rec.information15
362: ,p_information16_o => per_spp_shd.g_old_rec.information16
363: ,p_information17_o => per_spp_shd.g_old_rec.information17
364: ,p_information18_o => per_spp_shd.g_old_rec.information18
365: ,p_information19_o => per_spp_shd.g_old_rec.information19
366: ,p_information20_o => per_spp_shd.g_old_rec.information20
367: ,p_information21_o => per_spp_shd.g_old_rec.information21

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

360: ,p_information14_o => per_spp_shd.g_old_rec.information14
361: ,p_information15_o => per_spp_shd.g_old_rec.information15
362: ,p_information16_o => per_spp_shd.g_old_rec.information16
363: ,p_information17_o => per_spp_shd.g_old_rec.information17
364: ,p_information18_o => per_spp_shd.g_old_rec.information18
365: ,p_information19_o => per_spp_shd.g_old_rec.information19
366: ,p_information20_o => per_spp_shd.g_old_rec.information20
367: ,p_information21_o => per_spp_shd.g_old_rec.information21
368: ,p_information22_o => per_spp_shd.g_old_rec.information22

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

361: ,p_information15_o => per_spp_shd.g_old_rec.information15
362: ,p_information16_o => per_spp_shd.g_old_rec.information16
363: ,p_information17_o => per_spp_shd.g_old_rec.information17
364: ,p_information18_o => per_spp_shd.g_old_rec.information18
365: ,p_information19_o => per_spp_shd.g_old_rec.information19
366: ,p_information20_o => per_spp_shd.g_old_rec.information20
367: ,p_information21_o => per_spp_shd.g_old_rec.information21
368: ,p_information22_o => per_spp_shd.g_old_rec.information22
369: ,p_information23_o => per_spp_shd.g_old_rec.information23

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

362: ,p_information16_o => per_spp_shd.g_old_rec.information16
363: ,p_information17_o => per_spp_shd.g_old_rec.information17
364: ,p_information18_o => per_spp_shd.g_old_rec.information18
365: ,p_information19_o => per_spp_shd.g_old_rec.information19
366: ,p_information20_o => per_spp_shd.g_old_rec.information20
367: ,p_information21_o => per_spp_shd.g_old_rec.information21
368: ,p_information22_o => per_spp_shd.g_old_rec.information22
369: ,p_information23_o => per_spp_shd.g_old_rec.information23
370: ,p_information24_o => per_spp_shd.g_old_rec.information24

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

363: ,p_information17_o => per_spp_shd.g_old_rec.information17
364: ,p_information18_o => per_spp_shd.g_old_rec.information18
365: ,p_information19_o => per_spp_shd.g_old_rec.information19
366: ,p_information20_o => per_spp_shd.g_old_rec.information20
367: ,p_information21_o => per_spp_shd.g_old_rec.information21
368: ,p_information22_o => per_spp_shd.g_old_rec.information22
369: ,p_information23_o => per_spp_shd.g_old_rec.information23
370: ,p_information24_o => per_spp_shd.g_old_rec.information24
371: ,p_information25_o => per_spp_shd.g_old_rec.information25

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

364: ,p_information18_o => per_spp_shd.g_old_rec.information18
365: ,p_information19_o => per_spp_shd.g_old_rec.information19
366: ,p_information20_o => per_spp_shd.g_old_rec.information20
367: ,p_information21_o => per_spp_shd.g_old_rec.information21
368: ,p_information22_o => per_spp_shd.g_old_rec.information22
369: ,p_information23_o => per_spp_shd.g_old_rec.information23
370: ,p_information24_o => per_spp_shd.g_old_rec.information24
371: ,p_information25_o => per_spp_shd.g_old_rec.information25
372: ,p_information26_o => per_spp_shd.g_old_rec.information26

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

365: ,p_information19_o => per_spp_shd.g_old_rec.information19
366: ,p_information20_o => per_spp_shd.g_old_rec.information20
367: ,p_information21_o => per_spp_shd.g_old_rec.information21
368: ,p_information22_o => per_spp_shd.g_old_rec.information22
369: ,p_information23_o => per_spp_shd.g_old_rec.information23
370: ,p_information24_o => per_spp_shd.g_old_rec.information24
371: ,p_information25_o => per_spp_shd.g_old_rec.information25
372: ,p_information26_o => per_spp_shd.g_old_rec.information26
373: ,p_information27_o => per_spp_shd.g_old_rec.information27

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

366: ,p_information20_o => per_spp_shd.g_old_rec.information20
367: ,p_information21_o => per_spp_shd.g_old_rec.information21
368: ,p_information22_o => per_spp_shd.g_old_rec.information22
369: ,p_information23_o => per_spp_shd.g_old_rec.information23
370: ,p_information24_o => per_spp_shd.g_old_rec.information24
371: ,p_information25_o => per_spp_shd.g_old_rec.information25
372: ,p_information26_o => per_spp_shd.g_old_rec.information26
373: ,p_information27_o => per_spp_shd.g_old_rec.information27
374: ,p_information28_o => per_spp_shd.g_old_rec.information28

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

367: ,p_information21_o => per_spp_shd.g_old_rec.information21
368: ,p_information22_o => per_spp_shd.g_old_rec.information22
369: ,p_information23_o => per_spp_shd.g_old_rec.information23
370: ,p_information24_o => per_spp_shd.g_old_rec.information24
371: ,p_information25_o => per_spp_shd.g_old_rec.information25
372: ,p_information26_o => per_spp_shd.g_old_rec.information26
373: ,p_information27_o => per_spp_shd.g_old_rec.information27
374: ,p_information28_o => per_spp_shd.g_old_rec.information28
375: ,p_information29_o => per_spp_shd.g_old_rec.information29

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

368: ,p_information22_o => per_spp_shd.g_old_rec.information22
369: ,p_information23_o => per_spp_shd.g_old_rec.information23
370: ,p_information24_o => per_spp_shd.g_old_rec.information24
371: ,p_information25_o => per_spp_shd.g_old_rec.information25
372: ,p_information26_o => per_spp_shd.g_old_rec.information26
373: ,p_information27_o => per_spp_shd.g_old_rec.information27
374: ,p_information28_o => per_spp_shd.g_old_rec.information28
375: ,p_information29_o => per_spp_shd.g_old_rec.information29
376: ,p_information30_o => per_spp_shd.g_old_rec.information30

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

369: ,p_information23_o => per_spp_shd.g_old_rec.information23
370: ,p_information24_o => per_spp_shd.g_old_rec.information24
371: ,p_information25_o => per_spp_shd.g_old_rec.information25
372: ,p_information26_o => per_spp_shd.g_old_rec.information26
373: ,p_information27_o => per_spp_shd.g_old_rec.information27
374: ,p_information28_o => per_spp_shd.g_old_rec.information28
375: ,p_information29_o => per_spp_shd.g_old_rec.information29
376: ,p_information30_o => per_spp_shd.g_old_rec.information30
377: ,p_information_category_o => per_spp_shd.g_old_rec.information_category

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

370: ,p_information24_o => per_spp_shd.g_old_rec.information24
371: ,p_information25_o => per_spp_shd.g_old_rec.information25
372: ,p_information26_o => per_spp_shd.g_old_rec.information26
373: ,p_information27_o => per_spp_shd.g_old_rec.information27
374: ,p_information28_o => per_spp_shd.g_old_rec.information28
375: ,p_information29_o => per_spp_shd.g_old_rec.information29
376: ,p_information30_o => per_spp_shd.g_old_rec.information30
377: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
378: ,p_object_version_number_o

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

371: ,p_information25_o => per_spp_shd.g_old_rec.information25
372: ,p_information26_o => per_spp_shd.g_old_rec.information26
373: ,p_information27_o => per_spp_shd.g_old_rec.information27
374: ,p_information28_o => per_spp_shd.g_old_rec.information28
375: ,p_information29_o => per_spp_shd.g_old_rec.information29
376: ,p_information30_o => per_spp_shd.g_old_rec.information30
377: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
378: ,p_object_version_number_o
379: => per_spp_shd.g_old_rec.object_version_number

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

372: ,p_information26_o => per_spp_shd.g_old_rec.information26
373: ,p_information27_o => per_spp_shd.g_old_rec.information27
374: ,p_information28_o => per_spp_shd.g_old_rec.information28
375: ,p_information29_o => per_spp_shd.g_old_rec.information29
376: ,p_information30_o => per_spp_shd.g_old_rec.information30
377: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
378: ,p_object_version_number_o
379: => per_spp_shd.g_old_rec.object_version_number
380: );

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

373: ,p_information27_o => per_spp_shd.g_old_rec.information27
374: ,p_information28_o => per_spp_shd.g_old_rec.information28
375: ,p_information29_o => per_spp_shd.g_old_rec.information29
376: ,p_information30_o => per_spp_shd.g_old_rec.information30
377: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
378: ,p_object_version_number_o
379: => per_spp_shd.g_old_rec.object_version_number
380: );
381: --

Line 379: => per_spp_shd.g_old_rec.object_version_number

375: ,p_information29_o => per_spp_shd.g_old_rec.information29
376: ,p_information30_o => per_spp_shd.g_old_rec.information30
377: ,p_information_category_o => per_spp_shd.g_old_rec.information_category
378: ,p_object_version_number_o
379: => per_spp_shd.g_old_rec.object_version_number
380: );
381: --
382: exception
383: --

Line 401: ,p_rec in out nocopy per_spp_shd.g_rec_type

397: -- ----------------------------------------------------------------------------
398: Procedure del
399: (p_effective_date in date
400: ,p_datetrack_mode in varchar2
401: ,p_rec in out nocopy per_spp_shd.g_rec_type
402: ) is
403: --
404: l_proc varchar2(72) := g_package||'del';
405: l_validation_start_date date;

Line 417: per_spp_shd.lck

413: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
414: --
415: -- We must lock the row which we need to delete.
416: --
417: per_spp_shd.lck
418: (p_effective_date => p_effective_date
419: ,p_datetrack_mode => p_datetrack_mode
420: ,p_placement_id => p_rec.placement_id
421: ,p_object_version_number => p_rec.object_version_number

Line 482: l_rec per_spp_shd.g_rec_type;

478: ,p_effective_start_date out nocopy date
479: ,p_effective_end_date out nocopy date
480: ) is
481: --
482: l_rec per_spp_shd.g_rec_type;
483: l_proc varchar2(72) := g_package||'del';
484: --
485: Begin
486: hr_utility.set_location('Entering:'||l_proc, 5);