APPS.PER_REI_DEL dependencies on PER_REI_SHD

Line 54: (p_rec in out nocopy per_rei_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy per_rei_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_rei_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_rei_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_rei_shd.g_api_dml := false; -- Unset the api dml status

71: delete from per_contact_extra_info_f
72: where contact_extra_info_id = p_rec.contact_extra_info_id
73: and effective_start_date = p_validation_start_date;
74: --
75: per_rei_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: per_rei_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_rei_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: per_rei_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: per_rei_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_rei_shd.g_api_dml := false; -- Unset the api dml status

82: delete from per_contact_extra_info_f
83: where contact_extra_info_id = p_rec.contact_extra_info_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: per_rei_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_rei_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_rei_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_rei_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy per_rei_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_rei_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_pre_delete
159: (p_rec in out nocopy per_rei_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_rei_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_rei_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_rei_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: per_rei_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.contact_extra_info_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_rei_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out nocopy per_rei_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_rei_shd.g_rec_type

289: --
290: -- {End Of Comments}
291: -- ----------------------------------------------------------------------------
292: Procedure post_delete
293: (p_rec in per_rei_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_rei_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_rei_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => per_rei_shd.g_old_rec.effective_end_date
325: ,p_contact_relationship_id_o
326: => per_rei_shd.g_old_rec.contact_relationship_id

Line 324: => per_rei_shd.g_old_rec.effective_end_date

320: => p_rec.effective_end_date
321: ,p_effective_start_date_o
322: => per_rei_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => per_rei_shd.g_old_rec.effective_end_date
325: ,p_contact_relationship_id_o
326: => per_rei_shd.g_old_rec.contact_relationship_id
327: ,p_information_type_o
328: => per_rei_shd.g_old_rec.information_type

Line 326: => per_rei_shd.g_old_rec.contact_relationship_id

322: => per_rei_shd.g_old_rec.effective_start_date
323: ,p_effective_end_date_o
324: => per_rei_shd.g_old_rec.effective_end_date
325: ,p_contact_relationship_id_o
326: => per_rei_shd.g_old_rec.contact_relationship_id
327: ,p_information_type_o
328: => per_rei_shd.g_old_rec.information_type
329: ,p_cei_information_category_o
330: => per_rei_shd.g_old_rec.cei_information_category

Line 328: => per_rei_shd.g_old_rec.information_type

324: => per_rei_shd.g_old_rec.effective_end_date
325: ,p_contact_relationship_id_o
326: => per_rei_shd.g_old_rec.contact_relationship_id
327: ,p_information_type_o
328: => per_rei_shd.g_old_rec.information_type
329: ,p_cei_information_category_o
330: => per_rei_shd.g_old_rec.cei_information_category
331: ,p_cei_information1_o
332: => per_rei_shd.g_old_rec.cei_information1

Line 330: => per_rei_shd.g_old_rec.cei_information_category

326: => per_rei_shd.g_old_rec.contact_relationship_id
327: ,p_information_type_o
328: => per_rei_shd.g_old_rec.information_type
329: ,p_cei_information_category_o
330: => per_rei_shd.g_old_rec.cei_information_category
331: ,p_cei_information1_o
332: => per_rei_shd.g_old_rec.cei_information1
333: ,p_cei_information2_o
334: => per_rei_shd.g_old_rec.cei_information2

Line 332: => per_rei_shd.g_old_rec.cei_information1

328: => per_rei_shd.g_old_rec.information_type
329: ,p_cei_information_category_o
330: => per_rei_shd.g_old_rec.cei_information_category
331: ,p_cei_information1_o
332: => per_rei_shd.g_old_rec.cei_information1
333: ,p_cei_information2_o
334: => per_rei_shd.g_old_rec.cei_information2
335: ,p_cei_information3_o
336: => per_rei_shd.g_old_rec.cei_information3

Line 334: => per_rei_shd.g_old_rec.cei_information2

330: => per_rei_shd.g_old_rec.cei_information_category
331: ,p_cei_information1_o
332: => per_rei_shd.g_old_rec.cei_information1
333: ,p_cei_information2_o
334: => per_rei_shd.g_old_rec.cei_information2
335: ,p_cei_information3_o
336: => per_rei_shd.g_old_rec.cei_information3
337: ,p_cei_information4_o
338: => per_rei_shd.g_old_rec.cei_information4

Line 336: => per_rei_shd.g_old_rec.cei_information3

332: => per_rei_shd.g_old_rec.cei_information1
333: ,p_cei_information2_o
334: => per_rei_shd.g_old_rec.cei_information2
335: ,p_cei_information3_o
336: => per_rei_shd.g_old_rec.cei_information3
337: ,p_cei_information4_o
338: => per_rei_shd.g_old_rec.cei_information4
339: ,p_cei_information5_o
340: => per_rei_shd.g_old_rec.cei_information5

Line 338: => per_rei_shd.g_old_rec.cei_information4

334: => per_rei_shd.g_old_rec.cei_information2
335: ,p_cei_information3_o
336: => per_rei_shd.g_old_rec.cei_information3
337: ,p_cei_information4_o
338: => per_rei_shd.g_old_rec.cei_information4
339: ,p_cei_information5_o
340: => per_rei_shd.g_old_rec.cei_information5
341: ,p_cei_information6_o
342: => per_rei_shd.g_old_rec.cei_information6

Line 340: => per_rei_shd.g_old_rec.cei_information5

336: => per_rei_shd.g_old_rec.cei_information3
337: ,p_cei_information4_o
338: => per_rei_shd.g_old_rec.cei_information4
339: ,p_cei_information5_o
340: => per_rei_shd.g_old_rec.cei_information5
341: ,p_cei_information6_o
342: => per_rei_shd.g_old_rec.cei_information6
343: ,p_cei_information7_o
344: => per_rei_shd.g_old_rec.cei_information7

Line 342: => per_rei_shd.g_old_rec.cei_information6

338: => per_rei_shd.g_old_rec.cei_information4
339: ,p_cei_information5_o
340: => per_rei_shd.g_old_rec.cei_information5
341: ,p_cei_information6_o
342: => per_rei_shd.g_old_rec.cei_information6
343: ,p_cei_information7_o
344: => per_rei_shd.g_old_rec.cei_information7
345: ,p_cei_information8_o
346: => per_rei_shd.g_old_rec.cei_information8

Line 344: => per_rei_shd.g_old_rec.cei_information7

340: => per_rei_shd.g_old_rec.cei_information5
341: ,p_cei_information6_o
342: => per_rei_shd.g_old_rec.cei_information6
343: ,p_cei_information7_o
344: => per_rei_shd.g_old_rec.cei_information7
345: ,p_cei_information8_o
346: => per_rei_shd.g_old_rec.cei_information8
347: ,p_cei_information9_o
348: => per_rei_shd.g_old_rec.cei_information9

Line 346: => per_rei_shd.g_old_rec.cei_information8

342: => per_rei_shd.g_old_rec.cei_information6
343: ,p_cei_information7_o
344: => per_rei_shd.g_old_rec.cei_information7
345: ,p_cei_information8_o
346: => per_rei_shd.g_old_rec.cei_information8
347: ,p_cei_information9_o
348: => per_rei_shd.g_old_rec.cei_information9
349: ,p_cei_information10_o
350: => per_rei_shd.g_old_rec.cei_information10

Line 348: => per_rei_shd.g_old_rec.cei_information9

344: => per_rei_shd.g_old_rec.cei_information7
345: ,p_cei_information8_o
346: => per_rei_shd.g_old_rec.cei_information8
347: ,p_cei_information9_o
348: => per_rei_shd.g_old_rec.cei_information9
349: ,p_cei_information10_o
350: => per_rei_shd.g_old_rec.cei_information10
351: ,p_cei_information11_o
352: => per_rei_shd.g_old_rec.cei_information11

Line 350: => per_rei_shd.g_old_rec.cei_information10

346: => per_rei_shd.g_old_rec.cei_information8
347: ,p_cei_information9_o
348: => per_rei_shd.g_old_rec.cei_information9
349: ,p_cei_information10_o
350: => per_rei_shd.g_old_rec.cei_information10
351: ,p_cei_information11_o
352: => per_rei_shd.g_old_rec.cei_information11
353: ,p_cei_information12_o
354: => per_rei_shd.g_old_rec.cei_information12

Line 352: => per_rei_shd.g_old_rec.cei_information11

348: => per_rei_shd.g_old_rec.cei_information9
349: ,p_cei_information10_o
350: => per_rei_shd.g_old_rec.cei_information10
351: ,p_cei_information11_o
352: => per_rei_shd.g_old_rec.cei_information11
353: ,p_cei_information12_o
354: => per_rei_shd.g_old_rec.cei_information12
355: ,p_cei_information13_o
356: => per_rei_shd.g_old_rec.cei_information13

Line 354: => per_rei_shd.g_old_rec.cei_information12

350: => per_rei_shd.g_old_rec.cei_information10
351: ,p_cei_information11_o
352: => per_rei_shd.g_old_rec.cei_information11
353: ,p_cei_information12_o
354: => per_rei_shd.g_old_rec.cei_information12
355: ,p_cei_information13_o
356: => per_rei_shd.g_old_rec.cei_information13
357: ,p_cei_information14_o
358: => per_rei_shd.g_old_rec.cei_information14

Line 356: => per_rei_shd.g_old_rec.cei_information13

352: => per_rei_shd.g_old_rec.cei_information11
353: ,p_cei_information12_o
354: => per_rei_shd.g_old_rec.cei_information12
355: ,p_cei_information13_o
356: => per_rei_shd.g_old_rec.cei_information13
357: ,p_cei_information14_o
358: => per_rei_shd.g_old_rec.cei_information14
359: ,p_cei_information15_o
360: => per_rei_shd.g_old_rec.cei_information15

Line 358: => per_rei_shd.g_old_rec.cei_information14

354: => per_rei_shd.g_old_rec.cei_information12
355: ,p_cei_information13_o
356: => per_rei_shd.g_old_rec.cei_information13
357: ,p_cei_information14_o
358: => per_rei_shd.g_old_rec.cei_information14
359: ,p_cei_information15_o
360: => per_rei_shd.g_old_rec.cei_information15
361: ,p_cei_information16_o
362: => per_rei_shd.g_old_rec.cei_information16

Line 360: => per_rei_shd.g_old_rec.cei_information15

356: => per_rei_shd.g_old_rec.cei_information13
357: ,p_cei_information14_o
358: => per_rei_shd.g_old_rec.cei_information14
359: ,p_cei_information15_o
360: => per_rei_shd.g_old_rec.cei_information15
361: ,p_cei_information16_o
362: => per_rei_shd.g_old_rec.cei_information16
363: ,p_cei_information17_o
364: => per_rei_shd.g_old_rec.cei_information17

Line 362: => per_rei_shd.g_old_rec.cei_information16

358: => per_rei_shd.g_old_rec.cei_information14
359: ,p_cei_information15_o
360: => per_rei_shd.g_old_rec.cei_information15
361: ,p_cei_information16_o
362: => per_rei_shd.g_old_rec.cei_information16
363: ,p_cei_information17_o
364: => per_rei_shd.g_old_rec.cei_information17
365: ,p_cei_information18_o
366: => per_rei_shd.g_old_rec.cei_information18

Line 364: => per_rei_shd.g_old_rec.cei_information17

360: => per_rei_shd.g_old_rec.cei_information15
361: ,p_cei_information16_o
362: => per_rei_shd.g_old_rec.cei_information16
363: ,p_cei_information17_o
364: => per_rei_shd.g_old_rec.cei_information17
365: ,p_cei_information18_o
366: => per_rei_shd.g_old_rec.cei_information18
367: ,p_cei_information19_o
368: => per_rei_shd.g_old_rec.cei_information19

Line 366: => per_rei_shd.g_old_rec.cei_information18

362: => per_rei_shd.g_old_rec.cei_information16
363: ,p_cei_information17_o
364: => per_rei_shd.g_old_rec.cei_information17
365: ,p_cei_information18_o
366: => per_rei_shd.g_old_rec.cei_information18
367: ,p_cei_information19_o
368: => per_rei_shd.g_old_rec.cei_information19
369: ,p_cei_information20_o
370: => per_rei_shd.g_old_rec.cei_information20

Line 368: => per_rei_shd.g_old_rec.cei_information19

364: => per_rei_shd.g_old_rec.cei_information17
365: ,p_cei_information18_o
366: => per_rei_shd.g_old_rec.cei_information18
367: ,p_cei_information19_o
368: => per_rei_shd.g_old_rec.cei_information19
369: ,p_cei_information20_o
370: => per_rei_shd.g_old_rec.cei_information20
371: ,p_cei_information21_o
372: => per_rei_shd.g_old_rec.cei_information21

Line 370: => per_rei_shd.g_old_rec.cei_information20

366: => per_rei_shd.g_old_rec.cei_information18
367: ,p_cei_information19_o
368: => per_rei_shd.g_old_rec.cei_information19
369: ,p_cei_information20_o
370: => per_rei_shd.g_old_rec.cei_information20
371: ,p_cei_information21_o
372: => per_rei_shd.g_old_rec.cei_information21
373: ,p_cei_information22_o
374: => per_rei_shd.g_old_rec.cei_information22

Line 372: => per_rei_shd.g_old_rec.cei_information21

368: => per_rei_shd.g_old_rec.cei_information19
369: ,p_cei_information20_o
370: => per_rei_shd.g_old_rec.cei_information20
371: ,p_cei_information21_o
372: => per_rei_shd.g_old_rec.cei_information21
373: ,p_cei_information22_o
374: => per_rei_shd.g_old_rec.cei_information22
375: ,p_cei_information23_o
376: => per_rei_shd.g_old_rec.cei_information23

Line 374: => per_rei_shd.g_old_rec.cei_information22

370: => per_rei_shd.g_old_rec.cei_information20
371: ,p_cei_information21_o
372: => per_rei_shd.g_old_rec.cei_information21
373: ,p_cei_information22_o
374: => per_rei_shd.g_old_rec.cei_information22
375: ,p_cei_information23_o
376: => per_rei_shd.g_old_rec.cei_information23
377: ,p_cei_information24_o
378: => per_rei_shd.g_old_rec.cei_information24

Line 376: => per_rei_shd.g_old_rec.cei_information23

372: => per_rei_shd.g_old_rec.cei_information21
373: ,p_cei_information22_o
374: => per_rei_shd.g_old_rec.cei_information22
375: ,p_cei_information23_o
376: => per_rei_shd.g_old_rec.cei_information23
377: ,p_cei_information24_o
378: => per_rei_shd.g_old_rec.cei_information24
379: ,p_cei_information25_o
380: => per_rei_shd.g_old_rec.cei_information25

Line 378: => per_rei_shd.g_old_rec.cei_information24

374: => per_rei_shd.g_old_rec.cei_information22
375: ,p_cei_information23_o
376: => per_rei_shd.g_old_rec.cei_information23
377: ,p_cei_information24_o
378: => per_rei_shd.g_old_rec.cei_information24
379: ,p_cei_information25_o
380: => per_rei_shd.g_old_rec.cei_information25
381: ,p_cei_information26_o
382: => per_rei_shd.g_old_rec.cei_information26

Line 380: => per_rei_shd.g_old_rec.cei_information25

376: => per_rei_shd.g_old_rec.cei_information23
377: ,p_cei_information24_o
378: => per_rei_shd.g_old_rec.cei_information24
379: ,p_cei_information25_o
380: => per_rei_shd.g_old_rec.cei_information25
381: ,p_cei_information26_o
382: => per_rei_shd.g_old_rec.cei_information26
383: ,p_cei_information27_o
384: => per_rei_shd.g_old_rec.cei_information27

Line 382: => per_rei_shd.g_old_rec.cei_information26

378: => per_rei_shd.g_old_rec.cei_information24
379: ,p_cei_information25_o
380: => per_rei_shd.g_old_rec.cei_information25
381: ,p_cei_information26_o
382: => per_rei_shd.g_old_rec.cei_information26
383: ,p_cei_information27_o
384: => per_rei_shd.g_old_rec.cei_information27
385: ,p_cei_information28_o
386: => per_rei_shd.g_old_rec.cei_information28

Line 384: => per_rei_shd.g_old_rec.cei_information27

380: => per_rei_shd.g_old_rec.cei_information25
381: ,p_cei_information26_o
382: => per_rei_shd.g_old_rec.cei_information26
383: ,p_cei_information27_o
384: => per_rei_shd.g_old_rec.cei_information27
385: ,p_cei_information28_o
386: => per_rei_shd.g_old_rec.cei_information28
387: ,p_cei_information29_o
388: => per_rei_shd.g_old_rec.cei_information29

Line 386: => per_rei_shd.g_old_rec.cei_information28

382: => per_rei_shd.g_old_rec.cei_information26
383: ,p_cei_information27_o
384: => per_rei_shd.g_old_rec.cei_information27
385: ,p_cei_information28_o
386: => per_rei_shd.g_old_rec.cei_information28
387: ,p_cei_information29_o
388: => per_rei_shd.g_old_rec.cei_information29
389: ,p_cei_information30_o
390: => per_rei_shd.g_old_rec.cei_information30

Line 388: => per_rei_shd.g_old_rec.cei_information29

384: => per_rei_shd.g_old_rec.cei_information27
385: ,p_cei_information28_o
386: => per_rei_shd.g_old_rec.cei_information28
387: ,p_cei_information29_o
388: => per_rei_shd.g_old_rec.cei_information29
389: ,p_cei_information30_o
390: => per_rei_shd.g_old_rec.cei_information30
391: ,p_cei_attribute_category_o
392: => per_rei_shd.g_old_rec.cei_attribute_category

Line 390: => per_rei_shd.g_old_rec.cei_information30

386: => per_rei_shd.g_old_rec.cei_information28
387: ,p_cei_information29_o
388: => per_rei_shd.g_old_rec.cei_information29
389: ,p_cei_information30_o
390: => per_rei_shd.g_old_rec.cei_information30
391: ,p_cei_attribute_category_o
392: => per_rei_shd.g_old_rec.cei_attribute_category
393: ,p_cei_attribute1_o
394: => per_rei_shd.g_old_rec.cei_attribute1

Line 392: => per_rei_shd.g_old_rec.cei_attribute_category

388: => per_rei_shd.g_old_rec.cei_information29
389: ,p_cei_information30_o
390: => per_rei_shd.g_old_rec.cei_information30
391: ,p_cei_attribute_category_o
392: => per_rei_shd.g_old_rec.cei_attribute_category
393: ,p_cei_attribute1_o
394: => per_rei_shd.g_old_rec.cei_attribute1
395: ,p_cei_attribute2_o
396: => per_rei_shd.g_old_rec.cei_attribute2

Line 394: => per_rei_shd.g_old_rec.cei_attribute1

390: => per_rei_shd.g_old_rec.cei_information30
391: ,p_cei_attribute_category_o
392: => per_rei_shd.g_old_rec.cei_attribute_category
393: ,p_cei_attribute1_o
394: => per_rei_shd.g_old_rec.cei_attribute1
395: ,p_cei_attribute2_o
396: => per_rei_shd.g_old_rec.cei_attribute2
397: ,p_cei_attribute3_o
398: => per_rei_shd.g_old_rec.cei_attribute3

Line 396: => per_rei_shd.g_old_rec.cei_attribute2

392: => per_rei_shd.g_old_rec.cei_attribute_category
393: ,p_cei_attribute1_o
394: => per_rei_shd.g_old_rec.cei_attribute1
395: ,p_cei_attribute2_o
396: => per_rei_shd.g_old_rec.cei_attribute2
397: ,p_cei_attribute3_o
398: => per_rei_shd.g_old_rec.cei_attribute3
399: ,p_cei_attribute4_o
400: => per_rei_shd.g_old_rec.cei_attribute4

Line 398: => per_rei_shd.g_old_rec.cei_attribute3

394: => per_rei_shd.g_old_rec.cei_attribute1
395: ,p_cei_attribute2_o
396: => per_rei_shd.g_old_rec.cei_attribute2
397: ,p_cei_attribute3_o
398: => per_rei_shd.g_old_rec.cei_attribute3
399: ,p_cei_attribute4_o
400: => per_rei_shd.g_old_rec.cei_attribute4
401: ,p_cei_attribute5_o
402: => per_rei_shd.g_old_rec.cei_attribute5

Line 400: => per_rei_shd.g_old_rec.cei_attribute4

396: => per_rei_shd.g_old_rec.cei_attribute2
397: ,p_cei_attribute3_o
398: => per_rei_shd.g_old_rec.cei_attribute3
399: ,p_cei_attribute4_o
400: => per_rei_shd.g_old_rec.cei_attribute4
401: ,p_cei_attribute5_o
402: => per_rei_shd.g_old_rec.cei_attribute5
403: ,p_cei_attribute6_o
404: => per_rei_shd.g_old_rec.cei_attribute6

Line 402: => per_rei_shd.g_old_rec.cei_attribute5

398: => per_rei_shd.g_old_rec.cei_attribute3
399: ,p_cei_attribute4_o
400: => per_rei_shd.g_old_rec.cei_attribute4
401: ,p_cei_attribute5_o
402: => per_rei_shd.g_old_rec.cei_attribute5
403: ,p_cei_attribute6_o
404: => per_rei_shd.g_old_rec.cei_attribute6
405: ,p_cei_attribute7_o
406: => per_rei_shd.g_old_rec.cei_attribute7

Line 404: => per_rei_shd.g_old_rec.cei_attribute6

400: => per_rei_shd.g_old_rec.cei_attribute4
401: ,p_cei_attribute5_o
402: => per_rei_shd.g_old_rec.cei_attribute5
403: ,p_cei_attribute6_o
404: => per_rei_shd.g_old_rec.cei_attribute6
405: ,p_cei_attribute7_o
406: => per_rei_shd.g_old_rec.cei_attribute7
407: ,p_cei_attribute8_o
408: => per_rei_shd.g_old_rec.cei_attribute8

Line 406: => per_rei_shd.g_old_rec.cei_attribute7

402: => per_rei_shd.g_old_rec.cei_attribute5
403: ,p_cei_attribute6_o
404: => per_rei_shd.g_old_rec.cei_attribute6
405: ,p_cei_attribute7_o
406: => per_rei_shd.g_old_rec.cei_attribute7
407: ,p_cei_attribute8_o
408: => per_rei_shd.g_old_rec.cei_attribute8
409: ,p_cei_attribute9_o
410: => per_rei_shd.g_old_rec.cei_attribute9

Line 408: => per_rei_shd.g_old_rec.cei_attribute8

404: => per_rei_shd.g_old_rec.cei_attribute6
405: ,p_cei_attribute7_o
406: => per_rei_shd.g_old_rec.cei_attribute7
407: ,p_cei_attribute8_o
408: => per_rei_shd.g_old_rec.cei_attribute8
409: ,p_cei_attribute9_o
410: => per_rei_shd.g_old_rec.cei_attribute9
411: ,p_cei_attribute10_o
412: => per_rei_shd.g_old_rec.cei_attribute10

Line 410: => per_rei_shd.g_old_rec.cei_attribute9

406: => per_rei_shd.g_old_rec.cei_attribute7
407: ,p_cei_attribute8_o
408: => per_rei_shd.g_old_rec.cei_attribute8
409: ,p_cei_attribute9_o
410: => per_rei_shd.g_old_rec.cei_attribute9
411: ,p_cei_attribute10_o
412: => per_rei_shd.g_old_rec.cei_attribute10
413: ,p_cei_attribute11_o
414: => per_rei_shd.g_old_rec.cei_attribute11

Line 412: => per_rei_shd.g_old_rec.cei_attribute10

408: => per_rei_shd.g_old_rec.cei_attribute8
409: ,p_cei_attribute9_o
410: => per_rei_shd.g_old_rec.cei_attribute9
411: ,p_cei_attribute10_o
412: => per_rei_shd.g_old_rec.cei_attribute10
413: ,p_cei_attribute11_o
414: => per_rei_shd.g_old_rec.cei_attribute11
415: ,p_cei_attribute12_o
416: => per_rei_shd.g_old_rec.cei_attribute12

Line 414: => per_rei_shd.g_old_rec.cei_attribute11

410: => per_rei_shd.g_old_rec.cei_attribute9
411: ,p_cei_attribute10_o
412: => per_rei_shd.g_old_rec.cei_attribute10
413: ,p_cei_attribute11_o
414: => per_rei_shd.g_old_rec.cei_attribute11
415: ,p_cei_attribute12_o
416: => per_rei_shd.g_old_rec.cei_attribute12
417: ,p_cei_attribute13_o
418: => per_rei_shd.g_old_rec.cei_attribute13

Line 416: => per_rei_shd.g_old_rec.cei_attribute12

412: => per_rei_shd.g_old_rec.cei_attribute10
413: ,p_cei_attribute11_o
414: => per_rei_shd.g_old_rec.cei_attribute11
415: ,p_cei_attribute12_o
416: => per_rei_shd.g_old_rec.cei_attribute12
417: ,p_cei_attribute13_o
418: => per_rei_shd.g_old_rec.cei_attribute13
419: ,p_cei_attribute14_o
420: => per_rei_shd.g_old_rec.cei_attribute14

Line 418: => per_rei_shd.g_old_rec.cei_attribute13

414: => per_rei_shd.g_old_rec.cei_attribute11
415: ,p_cei_attribute12_o
416: => per_rei_shd.g_old_rec.cei_attribute12
417: ,p_cei_attribute13_o
418: => per_rei_shd.g_old_rec.cei_attribute13
419: ,p_cei_attribute14_o
420: => per_rei_shd.g_old_rec.cei_attribute14
421: ,p_cei_attribute15_o
422: => per_rei_shd.g_old_rec.cei_attribute15

Line 420: => per_rei_shd.g_old_rec.cei_attribute14

416: => per_rei_shd.g_old_rec.cei_attribute12
417: ,p_cei_attribute13_o
418: => per_rei_shd.g_old_rec.cei_attribute13
419: ,p_cei_attribute14_o
420: => per_rei_shd.g_old_rec.cei_attribute14
421: ,p_cei_attribute15_o
422: => per_rei_shd.g_old_rec.cei_attribute15
423: ,p_cei_attribute16_o
424: => per_rei_shd.g_old_rec.cei_attribute16

Line 422: => per_rei_shd.g_old_rec.cei_attribute15

418: => per_rei_shd.g_old_rec.cei_attribute13
419: ,p_cei_attribute14_o
420: => per_rei_shd.g_old_rec.cei_attribute14
421: ,p_cei_attribute15_o
422: => per_rei_shd.g_old_rec.cei_attribute15
423: ,p_cei_attribute16_o
424: => per_rei_shd.g_old_rec.cei_attribute16
425: ,p_cei_attribute17_o
426: => per_rei_shd.g_old_rec.cei_attribute17

Line 424: => per_rei_shd.g_old_rec.cei_attribute16

420: => per_rei_shd.g_old_rec.cei_attribute14
421: ,p_cei_attribute15_o
422: => per_rei_shd.g_old_rec.cei_attribute15
423: ,p_cei_attribute16_o
424: => per_rei_shd.g_old_rec.cei_attribute16
425: ,p_cei_attribute17_o
426: => per_rei_shd.g_old_rec.cei_attribute17
427: ,p_cei_attribute18_o
428: => per_rei_shd.g_old_rec.cei_attribute18

Line 426: => per_rei_shd.g_old_rec.cei_attribute17

422: => per_rei_shd.g_old_rec.cei_attribute15
423: ,p_cei_attribute16_o
424: => per_rei_shd.g_old_rec.cei_attribute16
425: ,p_cei_attribute17_o
426: => per_rei_shd.g_old_rec.cei_attribute17
427: ,p_cei_attribute18_o
428: => per_rei_shd.g_old_rec.cei_attribute18
429: ,p_cei_attribute19_o
430: => per_rei_shd.g_old_rec.cei_attribute19

Line 428: => per_rei_shd.g_old_rec.cei_attribute18

424: => per_rei_shd.g_old_rec.cei_attribute16
425: ,p_cei_attribute17_o
426: => per_rei_shd.g_old_rec.cei_attribute17
427: ,p_cei_attribute18_o
428: => per_rei_shd.g_old_rec.cei_attribute18
429: ,p_cei_attribute19_o
430: => per_rei_shd.g_old_rec.cei_attribute19
431: ,p_cei_attribute20_o
432: => per_rei_shd.g_old_rec.cei_attribute20

Line 430: => per_rei_shd.g_old_rec.cei_attribute19

426: => per_rei_shd.g_old_rec.cei_attribute17
427: ,p_cei_attribute18_o
428: => per_rei_shd.g_old_rec.cei_attribute18
429: ,p_cei_attribute19_o
430: => per_rei_shd.g_old_rec.cei_attribute19
431: ,p_cei_attribute20_o
432: => per_rei_shd.g_old_rec.cei_attribute20
433: ,p_object_version_number_o
434: => per_rei_shd.g_old_rec.object_version_number

Line 432: => per_rei_shd.g_old_rec.cei_attribute20

428: => per_rei_shd.g_old_rec.cei_attribute18
429: ,p_cei_attribute19_o
430: => per_rei_shd.g_old_rec.cei_attribute19
431: ,p_cei_attribute20_o
432: => per_rei_shd.g_old_rec.cei_attribute20
433: ,p_object_version_number_o
434: => per_rei_shd.g_old_rec.object_version_number
435: ,p_request_id_o
436: => per_rei_shd.g_old_rec.request_id

Line 434: => per_rei_shd.g_old_rec.object_version_number

430: => per_rei_shd.g_old_rec.cei_attribute19
431: ,p_cei_attribute20_o
432: => per_rei_shd.g_old_rec.cei_attribute20
433: ,p_object_version_number_o
434: => per_rei_shd.g_old_rec.object_version_number
435: ,p_request_id_o
436: => per_rei_shd.g_old_rec.request_id
437: ,p_program_application_id_o
438: => per_rei_shd.g_old_rec.program_application_id

Line 436: => per_rei_shd.g_old_rec.request_id

432: => per_rei_shd.g_old_rec.cei_attribute20
433: ,p_object_version_number_o
434: => per_rei_shd.g_old_rec.object_version_number
435: ,p_request_id_o
436: => per_rei_shd.g_old_rec.request_id
437: ,p_program_application_id_o
438: => per_rei_shd.g_old_rec.program_application_id
439: ,p_program_id_o
440: => per_rei_shd.g_old_rec.program_id

Line 438: => per_rei_shd.g_old_rec.program_application_id

434: => per_rei_shd.g_old_rec.object_version_number
435: ,p_request_id_o
436: => per_rei_shd.g_old_rec.request_id
437: ,p_program_application_id_o
438: => per_rei_shd.g_old_rec.program_application_id
439: ,p_program_id_o
440: => per_rei_shd.g_old_rec.program_id
441: ,p_program_update_date_o
442: => per_rei_shd.g_old_rec.program_update_date

Line 440: => per_rei_shd.g_old_rec.program_id

436: => per_rei_shd.g_old_rec.request_id
437: ,p_program_application_id_o
438: => per_rei_shd.g_old_rec.program_application_id
439: ,p_program_id_o
440: => per_rei_shd.g_old_rec.program_id
441: ,p_program_update_date_o
442: => per_rei_shd.g_old_rec.program_update_date
443: );
444: --

Line 442: => per_rei_shd.g_old_rec.program_update_date

438: => per_rei_shd.g_old_rec.program_application_id
439: ,p_program_id_o
440: => per_rei_shd.g_old_rec.program_id
441: ,p_program_update_date_o
442: => per_rei_shd.g_old_rec.program_update_date
443: );
444: --
445: exception
446: --

Line 464: ,p_rec in out nocopy per_rei_shd.g_rec_type

460: -- ----------------------------------------------------------------------------
461: Procedure del
462: (p_effective_date in date
463: ,p_datetrack_mode in varchar2
464: ,p_rec in out nocopy per_rei_shd.g_rec_type
465: ) is
466: --
467: l_proc varchar2(72) := g_package||'del';
468: l_validation_start_date date;

Line 480: per_rei_shd.lck

476: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
477: --
478: -- We must lock the row which we need to delete.
479: --
480: per_rei_shd.lck
481: (p_effective_date => p_effective_date
482: ,p_datetrack_mode => p_datetrack_mode
483: ,p_contact_extra_info_id => p_rec.contact_extra_info_id
484: ,p_object_version_number => p_rec.object_version_number

Line 549: l_rec per_rei_shd.g_rec_type;

545: ,p_effective_start_date out nocopy date
546: ,p_effective_end_date out nocopy date
547: ) is
548: --
549: l_rec per_rei_shd.g_rec_type;
550: l_proc varchar2(72) := g_package||'del';
551: --
552: Begin
553: hr_utility.set_location('Entering:'||l_proc, 5);