51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure dt_delete_dml
55: (p_rec in out nocopy pay_ele_shd.g_rec_type
56: ,p_effective_date in date
57: ,p_datetrack_mode in varchar2
58: ,p_validation_start_date in date
59: ,p_validation_end_date in date
63: --
64: Begin
65: hr_utility.set_location('Entering:'||l_proc, 5);
66: If (p_datetrack_mode = hr_api.g_delete_next_change) then
67: pay_ele_shd.g_api_dml := true; -- Set the api dml status
68: --
69: -- Delete the where the effective start date is equal
70: -- to the validation end date.
71: --
72: delete from pay_element_entries_f
73: where element_entry_id = p_rec.element_entry_id
74: and effective_start_date = p_validation_start_date;
75: --
76: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
77: Else
78: pay_ele_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
74: and effective_start_date = p_validation_start_date;
75: --
76: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
77: Else
78: pay_ele_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.
82: --
83: delete from pay_element_entries_f
84: where element_entry_id = p_rec.element_entry_id
85: and effective_start_date >= p_validation_start_date;
86: --
87: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
88: End If;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
90: hr_utility.set_location(' Leaving:'||l_proc, 20);
91: --
92: Exception
93: When Others Then
94: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
95: Raise;
96: --
97: End dt_delete_dml;
98: --
99: -- ----------------------------------------------------------------------------
100: -- |------------------------------< delete_dml >------------------------------|
101: -- ----------------------------------------------------------------------------
102: Procedure delete_dml
103: (p_rec in out nocopy pay_ele_shd.g_rec_type
104: ,p_effective_date in date
105: ,p_datetrack_mode in varchar2
106: ,p_validation_start_date in date
107: ,p_validation_end_date in date
156: --
157: -- {End Of Comments}
158: -- ----------------------------------------------------------------------------
159: Procedure dt_pre_delete
160: (p_rec in out nocopy pay_ele_shd.g_rec_type
161: ,p_effective_date in date
162: ,p_datetrack_mode in varchar2
163: ,p_validation_start_date in date
164: ,p_validation_end_date in date
171: --
172: If (p_datetrack_mode <> hr_api.g_zap) then
173: --
174: p_rec.effective_start_date
175: := pay_ele_shd.g_old_rec.effective_start_date;
176: --
177: If (p_datetrack_mode = hr_api.g_delete) then
178: p_rec.effective_end_date := p_validation_start_date - 1;
179: Else
181: End If;
182: --
183: -- Update the current effective end date record
184: --
185: pay_ele_shd.upd_effective_end_date
186: (p_effective_date => p_effective_date
187: ,p_base_key_value => p_rec.element_entry_id
188: ,p_new_effective_end_date => p_rec.effective_end_date
189: ,p_validation_start_date => p_validation_start_date
230: --
231: -- {End Of Comments}
232: -- ----------------------------------------------------------------------------
233: Procedure pre_delete
234: (p_rec in out nocopy pay_ele_shd.g_rec_type
235: ,p_effective_date in date
236: ,p_datetrack_mode in varchar2
237: ,p_validation_start_date in date
238: ,p_validation_end_date in date
312: --
313: -- {End Of Comments}
314: -- ----------------------------------------------------------------------------
315: Procedure post_delete
316: (p_rec in pay_ele_shd.g_rec_type
317: ,p_effective_date in date
318: ,p_datetrack_mode in varchar2
319: ,p_validation_start_date in date
320: ,p_validation_end_date in date
341: => p_rec.effective_start_date
342: ,p_effective_end_date
343: => p_rec.effective_end_date
344: ,p_effective_start_date_o
345: => pay_ele_shd.g_old_rec.effective_start_date
346: ,p_effective_end_date_o
347: => pay_ele_shd.g_old_rec.effective_end_date
348: ,p_cost_allocation_keyflex_id_o
349: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
343: => p_rec.effective_end_date
344: ,p_effective_start_date_o
345: => pay_ele_shd.g_old_rec.effective_start_date
346: ,p_effective_end_date_o
347: => pay_ele_shd.g_old_rec.effective_end_date
348: ,p_cost_allocation_keyflex_id_o
349: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
350: ,p_assignment_id_o
351: => pay_ele_shd.g_old_rec.assignment_id
345: => pay_ele_shd.g_old_rec.effective_start_date
346: ,p_effective_end_date_o
347: => pay_ele_shd.g_old_rec.effective_end_date
348: ,p_cost_allocation_keyflex_id_o
349: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
350: ,p_assignment_id_o
351: => pay_ele_shd.g_old_rec.assignment_id
352: ,p_updating_action_id_o
353: => pay_ele_shd.g_old_rec.updating_action_id
347: => pay_ele_shd.g_old_rec.effective_end_date
348: ,p_cost_allocation_keyflex_id_o
349: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
350: ,p_assignment_id_o
351: => pay_ele_shd.g_old_rec.assignment_id
352: ,p_updating_action_id_o
353: => pay_ele_shd.g_old_rec.updating_action_id
354: ,p_updating_action_type_o
355: => pay_ele_shd.g_old_rec.updating_action_type
349: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
350: ,p_assignment_id_o
351: => pay_ele_shd.g_old_rec.assignment_id
352: ,p_updating_action_id_o
353: => pay_ele_shd.g_old_rec.updating_action_id
354: ,p_updating_action_type_o
355: => pay_ele_shd.g_old_rec.updating_action_type
356: ,p_element_link_id_o
357: => pay_ele_shd.g_old_rec.element_link_id
351: => pay_ele_shd.g_old_rec.assignment_id
352: ,p_updating_action_id_o
353: => pay_ele_shd.g_old_rec.updating_action_id
354: ,p_updating_action_type_o
355: => pay_ele_shd.g_old_rec.updating_action_type
356: ,p_element_link_id_o
357: => pay_ele_shd.g_old_rec.element_link_id
358: ,p_original_entry_id_o
359: => pay_ele_shd.g_old_rec.original_entry_id
353: => pay_ele_shd.g_old_rec.updating_action_id
354: ,p_updating_action_type_o
355: => pay_ele_shd.g_old_rec.updating_action_type
356: ,p_element_link_id_o
357: => pay_ele_shd.g_old_rec.element_link_id
358: ,p_original_entry_id_o
359: => pay_ele_shd.g_old_rec.original_entry_id
360: ,p_creator_type_o
361: => pay_ele_shd.g_old_rec.creator_type
355: => pay_ele_shd.g_old_rec.updating_action_type
356: ,p_element_link_id_o
357: => pay_ele_shd.g_old_rec.element_link_id
358: ,p_original_entry_id_o
359: => pay_ele_shd.g_old_rec.original_entry_id
360: ,p_creator_type_o
361: => pay_ele_shd.g_old_rec.creator_type
362: ,p_entry_type_o
363: => pay_ele_shd.g_old_rec.entry_type
357: => pay_ele_shd.g_old_rec.element_link_id
358: ,p_original_entry_id_o
359: => pay_ele_shd.g_old_rec.original_entry_id
360: ,p_creator_type_o
361: => pay_ele_shd.g_old_rec.creator_type
362: ,p_entry_type_o
363: => pay_ele_shd.g_old_rec.entry_type
364: ,p_comment_id_o
365: => pay_ele_shd.g_old_rec.comment_id
359: => pay_ele_shd.g_old_rec.original_entry_id
360: ,p_creator_type_o
361: => pay_ele_shd.g_old_rec.creator_type
362: ,p_entry_type_o
363: => pay_ele_shd.g_old_rec.entry_type
364: ,p_comment_id_o
365: => pay_ele_shd.g_old_rec.comment_id
366: ,p_comments_o
367: => pay_ele_shd.g_old_rec.comments
361: => pay_ele_shd.g_old_rec.creator_type
362: ,p_entry_type_o
363: => pay_ele_shd.g_old_rec.entry_type
364: ,p_comment_id_o
365: => pay_ele_shd.g_old_rec.comment_id
366: ,p_comments_o
367: => pay_ele_shd.g_old_rec.comments
368: ,p_creator_id_o
369: => pay_ele_shd.g_old_rec.creator_id
363: => pay_ele_shd.g_old_rec.entry_type
364: ,p_comment_id_o
365: => pay_ele_shd.g_old_rec.comment_id
366: ,p_comments_o
367: => pay_ele_shd.g_old_rec.comments
368: ,p_creator_id_o
369: => pay_ele_shd.g_old_rec.creator_id
370: ,p_reason_o
371: => pay_ele_shd.g_old_rec.reason
365: => pay_ele_shd.g_old_rec.comment_id
366: ,p_comments_o
367: => pay_ele_shd.g_old_rec.comments
368: ,p_creator_id_o
369: => pay_ele_shd.g_old_rec.creator_id
370: ,p_reason_o
371: => pay_ele_shd.g_old_rec.reason
372: ,p_target_entry_id_o
373: => pay_ele_shd.g_old_rec.target_entry_id
367: => pay_ele_shd.g_old_rec.comments
368: ,p_creator_id_o
369: => pay_ele_shd.g_old_rec.creator_id
370: ,p_reason_o
371: => pay_ele_shd.g_old_rec.reason
372: ,p_target_entry_id_o
373: => pay_ele_shd.g_old_rec.target_entry_id
374: ,p_attribute_category_o
375: => pay_ele_shd.g_old_rec.attribute_category
369: => pay_ele_shd.g_old_rec.creator_id
370: ,p_reason_o
371: => pay_ele_shd.g_old_rec.reason
372: ,p_target_entry_id_o
373: => pay_ele_shd.g_old_rec.target_entry_id
374: ,p_attribute_category_o
375: => pay_ele_shd.g_old_rec.attribute_category
376: ,p_attribute1_o
377: => pay_ele_shd.g_old_rec.attribute1
371: => pay_ele_shd.g_old_rec.reason
372: ,p_target_entry_id_o
373: => pay_ele_shd.g_old_rec.target_entry_id
374: ,p_attribute_category_o
375: => pay_ele_shd.g_old_rec.attribute_category
376: ,p_attribute1_o
377: => pay_ele_shd.g_old_rec.attribute1
378: ,p_attribute2_o
379: => pay_ele_shd.g_old_rec.attribute2
373: => pay_ele_shd.g_old_rec.target_entry_id
374: ,p_attribute_category_o
375: => pay_ele_shd.g_old_rec.attribute_category
376: ,p_attribute1_o
377: => pay_ele_shd.g_old_rec.attribute1
378: ,p_attribute2_o
379: => pay_ele_shd.g_old_rec.attribute2
380: ,p_attribute3_o
381: => pay_ele_shd.g_old_rec.attribute3
375: => pay_ele_shd.g_old_rec.attribute_category
376: ,p_attribute1_o
377: => pay_ele_shd.g_old_rec.attribute1
378: ,p_attribute2_o
379: => pay_ele_shd.g_old_rec.attribute2
380: ,p_attribute3_o
381: => pay_ele_shd.g_old_rec.attribute3
382: ,p_attribute4_o
383: => pay_ele_shd.g_old_rec.attribute4
377: => pay_ele_shd.g_old_rec.attribute1
378: ,p_attribute2_o
379: => pay_ele_shd.g_old_rec.attribute2
380: ,p_attribute3_o
381: => pay_ele_shd.g_old_rec.attribute3
382: ,p_attribute4_o
383: => pay_ele_shd.g_old_rec.attribute4
384: ,p_attribute5_o
385: => pay_ele_shd.g_old_rec.attribute5
379: => pay_ele_shd.g_old_rec.attribute2
380: ,p_attribute3_o
381: => pay_ele_shd.g_old_rec.attribute3
382: ,p_attribute4_o
383: => pay_ele_shd.g_old_rec.attribute4
384: ,p_attribute5_o
385: => pay_ele_shd.g_old_rec.attribute5
386: ,p_attribute6_o
387: => pay_ele_shd.g_old_rec.attribute6
381: => pay_ele_shd.g_old_rec.attribute3
382: ,p_attribute4_o
383: => pay_ele_shd.g_old_rec.attribute4
384: ,p_attribute5_o
385: => pay_ele_shd.g_old_rec.attribute5
386: ,p_attribute6_o
387: => pay_ele_shd.g_old_rec.attribute6
388: ,p_attribute7_o
389: => pay_ele_shd.g_old_rec.attribute7
383: => pay_ele_shd.g_old_rec.attribute4
384: ,p_attribute5_o
385: => pay_ele_shd.g_old_rec.attribute5
386: ,p_attribute6_o
387: => pay_ele_shd.g_old_rec.attribute6
388: ,p_attribute7_o
389: => pay_ele_shd.g_old_rec.attribute7
390: ,p_attribute8_o
391: => pay_ele_shd.g_old_rec.attribute8
385: => pay_ele_shd.g_old_rec.attribute5
386: ,p_attribute6_o
387: => pay_ele_shd.g_old_rec.attribute6
388: ,p_attribute7_o
389: => pay_ele_shd.g_old_rec.attribute7
390: ,p_attribute8_o
391: => pay_ele_shd.g_old_rec.attribute8
392: ,p_attribute9_o
393: => pay_ele_shd.g_old_rec.attribute9
387: => pay_ele_shd.g_old_rec.attribute6
388: ,p_attribute7_o
389: => pay_ele_shd.g_old_rec.attribute7
390: ,p_attribute8_o
391: => pay_ele_shd.g_old_rec.attribute8
392: ,p_attribute9_o
393: => pay_ele_shd.g_old_rec.attribute9
394: ,p_attribute10_o
395: => pay_ele_shd.g_old_rec.attribute10
389: => pay_ele_shd.g_old_rec.attribute7
390: ,p_attribute8_o
391: => pay_ele_shd.g_old_rec.attribute8
392: ,p_attribute9_o
393: => pay_ele_shd.g_old_rec.attribute9
394: ,p_attribute10_o
395: => pay_ele_shd.g_old_rec.attribute10
396: ,p_attribute11_o
397: => pay_ele_shd.g_old_rec.attribute11
391: => pay_ele_shd.g_old_rec.attribute8
392: ,p_attribute9_o
393: => pay_ele_shd.g_old_rec.attribute9
394: ,p_attribute10_o
395: => pay_ele_shd.g_old_rec.attribute10
396: ,p_attribute11_o
397: => pay_ele_shd.g_old_rec.attribute11
398: ,p_attribute12_o
399: => pay_ele_shd.g_old_rec.attribute12
393: => pay_ele_shd.g_old_rec.attribute9
394: ,p_attribute10_o
395: => pay_ele_shd.g_old_rec.attribute10
396: ,p_attribute11_o
397: => pay_ele_shd.g_old_rec.attribute11
398: ,p_attribute12_o
399: => pay_ele_shd.g_old_rec.attribute12
400: ,p_attribute13_o
401: => pay_ele_shd.g_old_rec.attribute13
395: => pay_ele_shd.g_old_rec.attribute10
396: ,p_attribute11_o
397: => pay_ele_shd.g_old_rec.attribute11
398: ,p_attribute12_o
399: => pay_ele_shd.g_old_rec.attribute12
400: ,p_attribute13_o
401: => pay_ele_shd.g_old_rec.attribute13
402: ,p_attribute14_o
403: => pay_ele_shd.g_old_rec.attribute14
397: => pay_ele_shd.g_old_rec.attribute11
398: ,p_attribute12_o
399: => pay_ele_shd.g_old_rec.attribute12
400: ,p_attribute13_o
401: => pay_ele_shd.g_old_rec.attribute13
402: ,p_attribute14_o
403: => pay_ele_shd.g_old_rec.attribute14
404: ,p_attribute15_o
405: => pay_ele_shd.g_old_rec.attribute15
399: => pay_ele_shd.g_old_rec.attribute12
400: ,p_attribute13_o
401: => pay_ele_shd.g_old_rec.attribute13
402: ,p_attribute14_o
403: => pay_ele_shd.g_old_rec.attribute14
404: ,p_attribute15_o
405: => pay_ele_shd.g_old_rec.attribute15
406: ,p_attribute16_o
407: => pay_ele_shd.g_old_rec.attribute16
401: => pay_ele_shd.g_old_rec.attribute13
402: ,p_attribute14_o
403: => pay_ele_shd.g_old_rec.attribute14
404: ,p_attribute15_o
405: => pay_ele_shd.g_old_rec.attribute15
406: ,p_attribute16_o
407: => pay_ele_shd.g_old_rec.attribute16
408: ,p_attribute17_o
409: => pay_ele_shd.g_old_rec.attribute17
403: => pay_ele_shd.g_old_rec.attribute14
404: ,p_attribute15_o
405: => pay_ele_shd.g_old_rec.attribute15
406: ,p_attribute16_o
407: => pay_ele_shd.g_old_rec.attribute16
408: ,p_attribute17_o
409: => pay_ele_shd.g_old_rec.attribute17
410: ,p_attribute18_o
411: => pay_ele_shd.g_old_rec.attribute18
405: => pay_ele_shd.g_old_rec.attribute15
406: ,p_attribute16_o
407: => pay_ele_shd.g_old_rec.attribute16
408: ,p_attribute17_o
409: => pay_ele_shd.g_old_rec.attribute17
410: ,p_attribute18_o
411: => pay_ele_shd.g_old_rec.attribute18
412: ,p_attribute19_o
413: => pay_ele_shd.g_old_rec.attribute19
407: => pay_ele_shd.g_old_rec.attribute16
408: ,p_attribute17_o
409: => pay_ele_shd.g_old_rec.attribute17
410: ,p_attribute18_o
411: => pay_ele_shd.g_old_rec.attribute18
412: ,p_attribute19_o
413: => pay_ele_shd.g_old_rec.attribute19
414: ,p_attribute20_o
415: => pay_ele_shd.g_old_rec.attribute20
409: => pay_ele_shd.g_old_rec.attribute17
410: ,p_attribute18_o
411: => pay_ele_shd.g_old_rec.attribute18
412: ,p_attribute19_o
413: => pay_ele_shd.g_old_rec.attribute19
414: ,p_attribute20_o
415: => pay_ele_shd.g_old_rec.attribute20
416: -- --
417: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
411: => pay_ele_shd.g_old_rec.attribute18
412: ,p_attribute19_o
413: => pay_ele_shd.g_old_rec.attribute19
414: ,p_attribute20_o
415: => pay_ele_shd.g_old_rec.attribute20
416: -- --
417: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
418: --as looked like a cut-n-paste accident
419: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
413: => pay_ele_shd.g_old_rec.attribute19
414: ,p_attribute20_o
415: => pay_ele_shd.g_old_rec.attribute20
416: -- --
417: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
418: --as looked like a cut-n-paste accident
419: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
420: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
421: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
415: => pay_ele_shd.g_old_rec.attribute20
416: -- --
417: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
418: --as looked like a cut-n-paste accident
419: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
420: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
421: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
422: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
423: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
416: -- --
417: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
418: --as looked like a cut-n-paste accident
419: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
420: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
421: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
422: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
423: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
424: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
417: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
418: --as looked like a cut-n-paste accident
419: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
420: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
421: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
422: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
423: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
424: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
425: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
418: --as looked like a cut-n-paste accident
419: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
420: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
421: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
422: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
423: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
424: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
425: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
426: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
419: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
420: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
421: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
422: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
423: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
424: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
425: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
426: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
427: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
420: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
421: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
422: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
423: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
424: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
425: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
426: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
427: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
428: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
421: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
422: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
423: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
424: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
425: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
426: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
427: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
428: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
429: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
422: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
423: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
424: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
425: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
426: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
427: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
428: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
429: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
430: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
423: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
424: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
425: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
426: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
427: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
428: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
429: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
430: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
431: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
424: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
425: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
426: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
427: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
428: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
429: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
430: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
431: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
432: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
425: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
426: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
427: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
428: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
429: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
430: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
431: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
432: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
433: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
426: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
427: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
428: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
429: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
430: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
431: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
432: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
433: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
434: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
427: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
428: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
429: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
430: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
431: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
432: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
433: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
434: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
435: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
428: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
429: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
430: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
431: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
432: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
433: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
434: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
435: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
436: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
429: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
430: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
431: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
432: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
433: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
434: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
435: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
436: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
437: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
430: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
431: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
432: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
433: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
434: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
435: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
436: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
437: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
438: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
431: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
432: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
433: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
434: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
435: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
436: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
437: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
438: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
439: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
432: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
433: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
434: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
435: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
436: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
437: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
438: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
439: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
440: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
433: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
434: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
435: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
436: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
437: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
438: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
439: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
440: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
441: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
434: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
435: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
436: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
437: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
438: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
439: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
440: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
441: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
442: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
435: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
436: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
437: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
438: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
439: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
440: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
441: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
442: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
443: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
436: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
437: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
438: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
439: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
440: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
441: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
442: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
443: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
444: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
437: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
438: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
439: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
440: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
441: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
442: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
443: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
444: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
445: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
438: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
439: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
440: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
441: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
442: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
443: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
444: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
445: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
446: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
439: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
440: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
441: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
442: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
443: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
444: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
445: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
446: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
447: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
440: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
441: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
442: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
443: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
444: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
445: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
446: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
447: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
448: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
441: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
442: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
443: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
444: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
445: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
446: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
447: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
448: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
449: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
442: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
443: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
444: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
445: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
446: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
447: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
448: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
449: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
450: ,p_subpriority_o
443: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
444: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
445: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
446: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
447: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
448: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
449: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
450: ,p_subpriority_o
451: => pay_ele_shd.g_old_rec.subpriority
444: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
445: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
446: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
447: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
448: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
449: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
450: ,p_subpriority_o
451: => pay_ele_shd.g_old_rec.subpriority
452: ,p_personal_payment_method_id_o
445: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
446: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
447: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
448: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
449: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
450: ,p_subpriority_o
451: => pay_ele_shd.g_old_rec.subpriority
452: ,p_personal_payment_method_id_o
453: => pay_ele_shd.g_old_rec.personal_payment_method_id
447: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
448: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
449: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
450: ,p_subpriority_o
451: => pay_ele_shd.g_old_rec.subpriority
452: ,p_personal_payment_method_id_o
453: => pay_ele_shd.g_old_rec.personal_payment_method_id
454: ,p_date_earned_o
455: => pay_ele_shd.g_old_rec.date_earned
449: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
450: ,p_subpriority_o
451: => pay_ele_shd.g_old_rec.subpriority
452: ,p_personal_payment_method_id_o
453: => pay_ele_shd.g_old_rec.personal_payment_method_id
454: ,p_date_earned_o
455: => pay_ele_shd.g_old_rec.date_earned
456: ,p_object_version_number_o
457: => pay_ele_shd.g_old_rec.object_version_number
451: => pay_ele_shd.g_old_rec.subpriority
452: ,p_personal_payment_method_id_o
453: => pay_ele_shd.g_old_rec.personal_payment_method_id
454: ,p_date_earned_o
455: => pay_ele_shd.g_old_rec.date_earned
456: ,p_object_version_number_o
457: => pay_ele_shd.g_old_rec.object_version_number
458: ,p_source_id_o
459: => pay_ele_shd.g_old_rec.source_id
453: => pay_ele_shd.g_old_rec.personal_payment_method_id
454: ,p_date_earned_o
455: => pay_ele_shd.g_old_rec.date_earned
456: ,p_object_version_number_o
457: => pay_ele_shd.g_old_rec.object_version_number
458: ,p_source_id_o
459: => pay_ele_shd.g_old_rec.source_id
460: ,p_balance_adj_cost_flag_o
461: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
455: => pay_ele_shd.g_old_rec.date_earned
456: ,p_object_version_number_o
457: => pay_ele_shd.g_old_rec.object_version_number
458: ,p_source_id_o
459: => pay_ele_shd.g_old_rec.source_id
460: ,p_balance_adj_cost_flag_o
461: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
462: ,p_element_type_id_o => pay_ele_shd.g_old_rec.element_type_id
463: ,p_all_entry_values_null_o
457: => pay_ele_shd.g_old_rec.object_version_number
458: ,p_source_id_o
459: => pay_ele_shd.g_old_rec.source_id
460: ,p_balance_adj_cost_flag_o
461: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
462: ,p_element_type_id_o => pay_ele_shd.g_old_rec.element_type_id
463: ,p_all_entry_values_null_o
464: => pay_ele_shd.g_old_rec.all_entry_values_null
465: );
458: ,p_source_id_o
459: => pay_ele_shd.g_old_rec.source_id
460: ,p_balance_adj_cost_flag_o
461: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
462: ,p_element_type_id_o => pay_ele_shd.g_old_rec.element_type_id
463: ,p_all_entry_values_null_o
464: => pay_ele_shd.g_old_rec.all_entry_values_null
465: );
466: --
460: ,p_balance_adj_cost_flag_o
461: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
462: ,p_element_type_id_o => pay_ele_shd.g_old_rec.element_type_id
463: ,p_all_entry_values_null_o
464: => pay_ele_shd.g_old_rec.all_entry_values_null
465: );
466: --
467: exception
468: --
486: -- ----------------------------------------------------------------------------
487: Procedure del
488: (p_effective_date in date
489: ,p_datetrack_mode in varchar2
490: ,p_rec in out nocopy pay_ele_shd.g_rec_type
491: ) is
492: --
493: l_proc varchar2(72) := g_package||'del';
494: l_validation_start_date date;
502: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
503: --
504: -- We must lock the row which we need to delete.
505: --
506: pay_ele_shd.lck
507: (p_effective_date => p_effective_date
508: ,p_datetrack_mode => p_datetrack_mode
509: ,p_element_entry_id => p_rec.element_entry_id
510: ,p_object_version_number => p_rec.object_version_number
565: ,p_effective_start_date out nocopy date
566: ,p_effective_end_date out nocopy date
567: ) is
568: --
569: l_rec pay_ele_shd.g_rec_type;
570: l_proc varchar2(72) := g_package||'del';
571: --
572: Begin
573: hr_utility.set_location('Entering:'||l_proc, 5);