50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_pay_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
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_pay_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_all_payrolls_f
73: where payroll_id = p_rec.payroll_id
74: and effective_start_date = p_validation_start_date;
75: --
76: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
77: --
78: Else
79: --
80: pay_pay_shd.g_api_dml := true; -- Set the api dml status
76: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
77: --
78: Else
79: --
80: pay_pay_shd.g_api_dml := true; -- Set the api dml status
81: --
82: -- Delete the row(s) where the effective start date is greater than
83: -- or equal to the validation start date.
84: --
88: --
89:
90: --Storing the result of the above DML operation.
91: l_status_of_dml:=SQL%NOTFOUND;
92: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
93:
94: --Checking the status of the above dml operation.
95: /*if (l_status_of_dml) then
96: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
105: hr_utility.set_location(' Leaving:'||l_proc, 20);
106: --
107: Exception
108: When Others Then
109: pay_pay_shd.g_api_dml := false; -- Unset the api dml status
110: Raise;
111: --
112: End dt_delete_dml;
113: --
114: -- ----------------------------------------------------------------------------
115: -- |------------------------------< delete_dml >------------------------------|
116: -- ----------------------------------------------------------------------------
117: Procedure delete_dml
118: (p_rec in out nocopy pay_pay_shd.g_rec_type
119: ,p_effective_date in date
120: ,p_datetrack_mode in varchar2
121: ,p_validation_start_date in date
122: ,p_validation_end_date in date
173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure dt_pre_delete
177: (p_rec in out nocopy pay_pay_shd.g_rec_type
178: ,p_effective_date in date
179: ,p_datetrack_mode in varchar2
180: ,p_validation_start_date in date
181: ,p_validation_end_date in date
189: --
190: If (p_datetrack_mode <> hr_api.g_zap) then
191: --
192: p_rec.effective_start_date
193: := pay_pay_shd.g_old_rec.effective_start_date;
194: --
195: If (p_datetrack_mode = hr_api.g_delete) then
196: --
197: p_rec.effective_end_date := p_validation_start_date - 1;
203: End If;
204: --
205: -- Update the current effective end date record
206: --
207: pay_pay_shd.upd_effective_end_date
208: (p_effective_date => p_effective_date
209: ,p_base_key_value => p_rec.payroll_id
210: ,p_new_effective_end_date => p_rec.effective_end_date
211: ,p_validation_start_date => p_validation_start_date
257: --
258: -- {End Of Comments}
259: -- ----------------------------------------------------------------------------
260: Procedure pre_delete
261: (p_rec in out nocopy pay_pay_shd.g_rec_type
262: ,p_effective_date in date
263: ,p_datetrack_mode in varchar2
264: ,p_validation_start_date in date
265: ,p_validation_end_date in date
339: --
340: -- {End Of Comments}
341: -- ----------------------------------------------------------------------------
342: Procedure post_delete
343: (p_rec in pay_pay_shd.g_rec_type
344: ,p_effective_date in date
345: ,p_datetrack_mode in varchar2
346: ,p_validation_start_date in date
347: ,p_validation_end_date in date
371: => p_rec.effective_start_date
372: ,p_effective_end_date
373: => p_rec.effective_end_date
374: ,p_effective_start_date_o
375: => pay_pay_shd.g_old_rec.effective_start_date
376: ,p_effective_end_date_o
377: => pay_pay_shd.g_old_rec.effective_end_date
378: ,p_default_payment_method_id_o
379: => pay_pay_shd.g_old_rec.default_payment_method_id
373: => p_rec.effective_end_date
374: ,p_effective_start_date_o
375: => pay_pay_shd.g_old_rec.effective_start_date
376: ,p_effective_end_date_o
377: => pay_pay_shd.g_old_rec.effective_end_date
378: ,p_default_payment_method_id_o
379: => pay_pay_shd.g_old_rec.default_payment_method_id
380: ,p_business_group_id_o
381: => pay_pay_shd.g_old_rec.business_group_id
375: => pay_pay_shd.g_old_rec.effective_start_date
376: ,p_effective_end_date_o
377: => pay_pay_shd.g_old_rec.effective_end_date
378: ,p_default_payment_method_id_o
379: => pay_pay_shd.g_old_rec.default_payment_method_id
380: ,p_business_group_id_o
381: => pay_pay_shd.g_old_rec.business_group_id
382: ,p_consolidation_set_id_o
383: => pay_pay_shd.g_old_rec.consolidation_set_id
377: => pay_pay_shd.g_old_rec.effective_end_date
378: ,p_default_payment_method_id_o
379: => pay_pay_shd.g_old_rec.default_payment_method_id
380: ,p_business_group_id_o
381: => pay_pay_shd.g_old_rec.business_group_id
382: ,p_consolidation_set_id_o
383: => pay_pay_shd.g_old_rec.consolidation_set_id
384: ,p_cost_allocation_keyflex_id_o
385: => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
379: => pay_pay_shd.g_old_rec.default_payment_method_id
380: ,p_business_group_id_o
381: => pay_pay_shd.g_old_rec.business_group_id
382: ,p_consolidation_set_id_o
383: => pay_pay_shd.g_old_rec.consolidation_set_id
384: ,p_cost_allocation_keyflex_id_o
385: => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
386: ,p_suspense_account_keyflex_i_o
387: => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
381: => pay_pay_shd.g_old_rec.business_group_id
382: ,p_consolidation_set_id_o
383: => pay_pay_shd.g_old_rec.consolidation_set_id
384: ,p_cost_allocation_keyflex_id_o
385: => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
386: ,p_suspense_account_keyflex_i_o
387: => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
388: ,p_gl_set_of_books_id_o
389: => pay_pay_shd.g_old_rec.gl_set_of_books_id
383: => pay_pay_shd.g_old_rec.consolidation_set_id
384: ,p_cost_allocation_keyflex_id_o
385: => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
386: ,p_suspense_account_keyflex_i_o
387: => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
388: ,p_gl_set_of_books_id_o
389: => pay_pay_shd.g_old_rec.gl_set_of_books_id
390: ,p_soft_coding_keyflex_id_o
391: => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
385: => pay_pay_shd.g_old_rec.cost_allocation_keyflex_id
386: ,p_suspense_account_keyflex_i_o
387: => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
388: ,p_gl_set_of_books_id_o
389: => pay_pay_shd.g_old_rec.gl_set_of_books_id
390: ,p_soft_coding_keyflex_id_o
391: => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
392: ,p_period_type_o
393: => pay_pay_shd.g_old_rec.period_type
387: => pay_pay_shd.g_old_rec.suspense_account_keyflex_id
388: ,p_gl_set_of_books_id_o
389: => pay_pay_shd.g_old_rec.gl_set_of_books_id
390: ,p_soft_coding_keyflex_id_o
391: => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
392: ,p_period_type_o
393: => pay_pay_shd.g_old_rec.period_type
394: ,p_organization_id_o
395: => pay_pay_shd.g_old_rec.organization_id
389: => pay_pay_shd.g_old_rec.gl_set_of_books_id
390: ,p_soft_coding_keyflex_id_o
391: => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
392: ,p_period_type_o
393: => pay_pay_shd.g_old_rec.period_type
394: ,p_organization_id_o
395: => pay_pay_shd.g_old_rec.organization_id
396: ,p_cut_off_date_offset_o
397: => pay_pay_shd.g_old_rec.cut_off_date_offset
391: => pay_pay_shd.g_old_rec.soft_coding_keyflex_id
392: ,p_period_type_o
393: => pay_pay_shd.g_old_rec.period_type
394: ,p_organization_id_o
395: => pay_pay_shd.g_old_rec.organization_id
396: ,p_cut_off_date_offset_o
397: => pay_pay_shd.g_old_rec.cut_off_date_offset
398: ,p_direct_deposit_date_offset_o
399: => pay_pay_shd.g_old_rec.direct_deposit_date_offset
393: => pay_pay_shd.g_old_rec.period_type
394: ,p_organization_id_o
395: => pay_pay_shd.g_old_rec.organization_id
396: ,p_cut_off_date_offset_o
397: => pay_pay_shd.g_old_rec.cut_off_date_offset
398: ,p_direct_deposit_date_offset_o
399: => pay_pay_shd.g_old_rec.direct_deposit_date_offset
400: ,p_first_period_end_date_o
401: => pay_pay_shd.g_old_rec.first_period_end_date
395: => pay_pay_shd.g_old_rec.organization_id
396: ,p_cut_off_date_offset_o
397: => pay_pay_shd.g_old_rec.cut_off_date_offset
398: ,p_direct_deposit_date_offset_o
399: => pay_pay_shd.g_old_rec.direct_deposit_date_offset
400: ,p_first_period_end_date_o
401: => pay_pay_shd.g_old_rec.first_period_end_date
402: ,p_negative_pay_allowed_flag_o
403: => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
397: => pay_pay_shd.g_old_rec.cut_off_date_offset
398: ,p_direct_deposit_date_offset_o
399: => pay_pay_shd.g_old_rec.direct_deposit_date_offset
400: ,p_first_period_end_date_o
401: => pay_pay_shd.g_old_rec.first_period_end_date
402: ,p_negative_pay_allowed_flag_o
403: => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
404: ,p_number_of_years_o
405: => pay_pay_shd.g_old_rec.number_of_years
399: => pay_pay_shd.g_old_rec.direct_deposit_date_offset
400: ,p_first_period_end_date_o
401: => pay_pay_shd.g_old_rec.first_period_end_date
402: ,p_negative_pay_allowed_flag_o
403: => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
404: ,p_number_of_years_o
405: => pay_pay_shd.g_old_rec.number_of_years
406: ,p_pay_advice_date_offset_o
407: => pay_pay_shd.g_old_rec.pay_advice_date_offset
401: => pay_pay_shd.g_old_rec.first_period_end_date
402: ,p_negative_pay_allowed_flag_o
403: => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
404: ,p_number_of_years_o
405: => pay_pay_shd.g_old_rec.number_of_years
406: ,p_pay_advice_date_offset_o
407: => pay_pay_shd.g_old_rec.pay_advice_date_offset
408: ,p_pay_date_offset_o
409: => pay_pay_shd.g_old_rec.pay_date_offset
403: => pay_pay_shd.g_old_rec.negative_pay_allowed_flag
404: ,p_number_of_years_o
405: => pay_pay_shd.g_old_rec.number_of_years
406: ,p_pay_advice_date_offset_o
407: => pay_pay_shd.g_old_rec.pay_advice_date_offset
408: ,p_pay_date_offset_o
409: => pay_pay_shd.g_old_rec.pay_date_offset
410: ,p_payroll_name_o
411: => pay_pay_shd.g_old_rec.payroll_name
405: => pay_pay_shd.g_old_rec.number_of_years
406: ,p_pay_advice_date_offset_o
407: => pay_pay_shd.g_old_rec.pay_advice_date_offset
408: ,p_pay_date_offset_o
409: => pay_pay_shd.g_old_rec.pay_date_offset
410: ,p_payroll_name_o
411: => pay_pay_shd.g_old_rec.payroll_name
412: ,p_workload_shifting_level_o
413: => pay_pay_shd.g_old_rec.workload_shifting_level
407: => pay_pay_shd.g_old_rec.pay_advice_date_offset
408: ,p_pay_date_offset_o
409: => pay_pay_shd.g_old_rec.pay_date_offset
410: ,p_payroll_name_o
411: => pay_pay_shd.g_old_rec.payroll_name
412: ,p_workload_shifting_level_o
413: => pay_pay_shd.g_old_rec.workload_shifting_level
414: ,p_comment_id_o
415: => pay_pay_shd.g_old_rec.comment_id
409: => pay_pay_shd.g_old_rec.pay_date_offset
410: ,p_payroll_name_o
411: => pay_pay_shd.g_old_rec.payroll_name
412: ,p_workload_shifting_level_o
413: => pay_pay_shd.g_old_rec.workload_shifting_level
414: ,p_comment_id_o
415: => pay_pay_shd.g_old_rec.comment_id
416: ,p_comments_o
417: => pay_pay_shd.g_old_rec.comments
411: => pay_pay_shd.g_old_rec.payroll_name
412: ,p_workload_shifting_level_o
413: => pay_pay_shd.g_old_rec.workload_shifting_level
414: ,p_comment_id_o
415: => pay_pay_shd.g_old_rec.comment_id
416: ,p_comments_o
417: => pay_pay_shd.g_old_rec.comments
418: ,p_midpoint_offset_o
419: => pay_pay_shd.g_old_rec.midpoint_offset
413: => pay_pay_shd.g_old_rec.workload_shifting_level
414: ,p_comment_id_o
415: => pay_pay_shd.g_old_rec.comment_id
416: ,p_comments_o
417: => pay_pay_shd.g_old_rec.comments
418: ,p_midpoint_offset_o
419: => pay_pay_shd.g_old_rec.midpoint_offset
420: ,p_attribute_category_o
421: => pay_pay_shd.g_old_rec.attribute_category
415: => pay_pay_shd.g_old_rec.comment_id
416: ,p_comments_o
417: => pay_pay_shd.g_old_rec.comments
418: ,p_midpoint_offset_o
419: => pay_pay_shd.g_old_rec.midpoint_offset
420: ,p_attribute_category_o
421: => pay_pay_shd.g_old_rec.attribute_category
422: ,p_attribute1_o
423: => pay_pay_shd.g_old_rec.attribute1
417: => pay_pay_shd.g_old_rec.comments
418: ,p_midpoint_offset_o
419: => pay_pay_shd.g_old_rec.midpoint_offset
420: ,p_attribute_category_o
421: => pay_pay_shd.g_old_rec.attribute_category
422: ,p_attribute1_o
423: => pay_pay_shd.g_old_rec.attribute1
424: ,p_attribute2_o
425: => pay_pay_shd.g_old_rec.attribute2
419: => pay_pay_shd.g_old_rec.midpoint_offset
420: ,p_attribute_category_o
421: => pay_pay_shd.g_old_rec.attribute_category
422: ,p_attribute1_o
423: => pay_pay_shd.g_old_rec.attribute1
424: ,p_attribute2_o
425: => pay_pay_shd.g_old_rec.attribute2
426: ,p_attribute3_o
427: => pay_pay_shd.g_old_rec.attribute3
421: => pay_pay_shd.g_old_rec.attribute_category
422: ,p_attribute1_o
423: => pay_pay_shd.g_old_rec.attribute1
424: ,p_attribute2_o
425: => pay_pay_shd.g_old_rec.attribute2
426: ,p_attribute3_o
427: => pay_pay_shd.g_old_rec.attribute3
428: ,p_attribute4_o
429: => pay_pay_shd.g_old_rec.attribute4
423: => pay_pay_shd.g_old_rec.attribute1
424: ,p_attribute2_o
425: => pay_pay_shd.g_old_rec.attribute2
426: ,p_attribute3_o
427: => pay_pay_shd.g_old_rec.attribute3
428: ,p_attribute4_o
429: => pay_pay_shd.g_old_rec.attribute4
430: ,p_attribute5_o
431: => pay_pay_shd.g_old_rec.attribute5
425: => pay_pay_shd.g_old_rec.attribute2
426: ,p_attribute3_o
427: => pay_pay_shd.g_old_rec.attribute3
428: ,p_attribute4_o
429: => pay_pay_shd.g_old_rec.attribute4
430: ,p_attribute5_o
431: => pay_pay_shd.g_old_rec.attribute5
432: ,p_attribute6_o
433: => pay_pay_shd.g_old_rec.attribute6
427: => pay_pay_shd.g_old_rec.attribute3
428: ,p_attribute4_o
429: => pay_pay_shd.g_old_rec.attribute4
430: ,p_attribute5_o
431: => pay_pay_shd.g_old_rec.attribute5
432: ,p_attribute6_o
433: => pay_pay_shd.g_old_rec.attribute6
434: ,p_attribute7_o
435: => pay_pay_shd.g_old_rec.attribute7
429: => pay_pay_shd.g_old_rec.attribute4
430: ,p_attribute5_o
431: => pay_pay_shd.g_old_rec.attribute5
432: ,p_attribute6_o
433: => pay_pay_shd.g_old_rec.attribute6
434: ,p_attribute7_o
435: => pay_pay_shd.g_old_rec.attribute7
436: ,p_attribute8_o
437: => pay_pay_shd.g_old_rec.attribute8
431: => pay_pay_shd.g_old_rec.attribute5
432: ,p_attribute6_o
433: => pay_pay_shd.g_old_rec.attribute6
434: ,p_attribute7_o
435: => pay_pay_shd.g_old_rec.attribute7
436: ,p_attribute8_o
437: => pay_pay_shd.g_old_rec.attribute8
438: ,p_attribute9_o
439: => pay_pay_shd.g_old_rec.attribute9
433: => pay_pay_shd.g_old_rec.attribute6
434: ,p_attribute7_o
435: => pay_pay_shd.g_old_rec.attribute7
436: ,p_attribute8_o
437: => pay_pay_shd.g_old_rec.attribute8
438: ,p_attribute9_o
439: => pay_pay_shd.g_old_rec.attribute9
440: ,p_attribute10_o
441: => pay_pay_shd.g_old_rec.attribute10
435: => pay_pay_shd.g_old_rec.attribute7
436: ,p_attribute8_o
437: => pay_pay_shd.g_old_rec.attribute8
438: ,p_attribute9_o
439: => pay_pay_shd.g_old_rec.attribute9
440: ,p_attribute10_o
441: => pay_pay_shd.g_old_rec.attribute10
442: ,p_attribute11_o
443: => pay_pay_shd.g_old_rec.attribute11
437: => pay_pay_shd.g_old_rec.attribute8
438: ,p_attribute9_o
439: => pay_pay_shd.g_old_rec.attribute9
440: ,p_attribute10_o
441: => pay_pay_shd.g_old_rec.attribute10
442: ,p_attribute11_o
443: => pay_pay_shd.g_old_rec.attribute11
444: ,p_attribute12_o
445: => pay_pay_shd.g_old_rec.attribute12
439: => pay_pay_shd.g_old_rec.attribute9
440: ,p_attribute10_o
441: => pay_pay_shd.g_old_rec.attribute10
442: ,p_attribute11_o
443: => pay_pay_shd.g_old_rec.attribute11
444: ,p_attribute12_o
445: => pay_pay_shd.g_old_rec.attribute12
446: ,p_attribute13_o
447: => pay_pay_shd.g_old_rec.attribute13
441: => pay_pay_shd.g_old_rec.attribute10
442: ,p_attribute11_o
443: => pay_pay_shd.g_old_rec.attribute11
444: ,p_attribute12_o
445: => pay_pay_shd.g_old_rec.attribute12
446: ,p_attribute13_o
447: => pay_pay_shd.g_old_rec.attribute13
448: ,p_attribute14_o
449: => pay_pay_shd.g_old_rec.attribute14
443: => pay_pay_shd.g_old_rec.attribute11
444: ,p_attribute12_o
445: => pay_pay_shd.g_old_rec.attribute12
446: ,p_attribute13_o
447: => pay_pay_shd.g_old_rec.attribute13
448: ,p_attribute14_o
449: => pay_pay_shd.g_old_rec.attribute14
450: ,p_attribute15_o
451: => pay_pay_shd.g_old_rec.attribute15
445: => pay_pay_shd.g_old_rec.attribute12
446: ,p_attribute13_o
447: => pay_pay_shd.g_old_rec.attribute13
448: ,p_attribute14_o
449: => pay_pay_shd.g_old_rec.attribute14
450: ,p_attribute15_o
451: => pay_pay_shd.g_old_rec.attribute15
452: ,p_attribute16_o
453: => pay_pay_shd.g_old_rec.attribute16
447: => pay_pay_shd.g_old_rec.attribute13
448: ,p_attribute14_o
449: => pay_pay_shd.g_old_rec.attribute14
450: ,p_attribute15_o
451: => pay_pay_shd.g_old_rec.attribute15
452: ,p_attribute16_o
453: => pay_pay_shd.g_old_rec.attribute16
454: ,p_attribute17_o
455: => pay_pay_shd.g_old_rec.attribute17
449: => pay_pay_shd.g_old_rec.attribute14
450: ,p_attribute15_o
451: => pay_pay_shd.g_old_rec.attribute15
452: ,p_attribute16_o
453: => pay_pay_shd.g_old_rec.attribute16
454: ,p_attribute17_o
455: => pay_pay_shd.g_old_rec.attribute17
456: ,p_attribute18_o
457: => pay_pay_shd.g_old_rec.attribute18
451: => pay_pay_shd.g_old_rec.attribute15
452: ,p_attribute16_o
453: => pay_pay_shd.g_old_rec.attribute16
454: ,p_attribute17_o
455: => pay_pay_shd.g_old_rec.attribute17
456: ,p_attribute18_o
457: => pay_pay_shd.g_old_rec.attribute18
458: ,p_attribute19_o
459: => pay_pay_shd.g_old_rec.attribute19
453: => pay_pay_shd.g_old_rec.attribute16
454: ,p_attribute17_o
455: => pay_pay_shd.g_old_rec.attribute17
456: ,p_attribute18_o
457: => pay_pay_shd.g_old_rec.attribute18
458: ,p_attribute19_o
459: => pay_pay_shd.g_old_rec.attribute19
460: ,p_attribute20_o
461: => pay_pay_shd.g_old_rec.attribute20
455: => pay_pay_shd.g_old_rec.attribute17
456: ,p_attribute18_o
457: => pay_pay_shd.g_old_rec.attribute18
458: ,p_attribute19_o
459: => pay_pay_shd.g_old_rec.attribute19
460: ,p_attribute20_o
461: => pay_pay_shd.g_old_rec.attribute20
462: ,p_arrears_flag_o
463: => pay_pay_shd.g_old_rec.arrears_flag
457: => pay_pay_shd.g_old_rec.attribute18
458: ,p_attribute19_o
459: => pay_pay_shd.g_old_rec.attribute19
460: ,p_attribute20_o
461: => pay_pay_shd.g_old_rec.attribute20
462: ,p_arrears_flag_o
463: => pay_pay_shd.g_old_rec.arrears_flag
464: ,p_payroll_type_o
465: => pay_pay_shd.g_old_rec.payroll_type
459: => pay_pay_shd.g_old_rec.attribute19
460: ,p_attribute20_o
461: => pay_pay_shd.g_old_rec.attribute20
462: ,p_arrears_flag_o
463: => pay_pay_shd.g_old_rec.arrears_flag
464: ,p_payroll_type_o
465: => pay_pay_shd.g_old_rec.payroll_type
466: ,p_prl_information_category_o
467: => pay_pay_shd.g_old_rec.prl_information_category
461: => pay_pay_shd.g_old_rec.attribute20
462: ,p_arrears_flag_o
463: => pay_pay_shd.g_old_rec.arrears_flag
464: ,p_payroll_type_o
465: => pay_pay_shd.g_old_rec.payroll_type
466: ,p_prl_information_category_o
467: => pay_pay_shd.g_old_rec.prl_information_category
468: ,p_prl_information1_o
469: => pay_pay_shd.g_old_rec.prl_information1
463: => pay_pay_shd.g_old_rec.arrears_flag
464: ,p_payroll_type_o
465: => pay_pay_shd.g_old_rec.payroll_type
466: ,p_prl_information_category_o
467: => pay_pay_shd.g_old_rec.prl_information_category
468: ,p_prl_information1_o
469: => pay_pay_shd.g_old_rec.prl_information1
470: ,p_prl_information2_o
471: => pay_pay_shd.g_old_rec.prl_information2
465: => pay_pay_shd.g_old_rec.payroll_type
466: ,p_prl_information_category_o
467: => pay_pay_shd.g_old_rec.prl_information_category
468: ,p_prl_information1_o
469: => pay_pay_shd.g_old_rec.prl_information1
470: ,p_prl_information2_o
471: => pay_pay_shd.g_old_rec.prl_information2
472: ,p_prl_information3_o
473: => pay_pay_shd.g_old_rec.prl_information3
467: => pay_pay_shd.g_old_rec.prl_information_category
468: ,p_prl_information1_o
469: => pay_pay_shd.g_old_rec.prl_information1
470: ,p_prl_information2_o
471: => pay_pay_shd.g_old_rec.prl_information2
472: ,p_prl_information3_o
473: => pay_pay_shd.g_old_rec.prl_information3
474: ,p_prl_information4_o
475: => pay_pay_shd.g_old_rec.prl_information4
469: => pay_pay_shd.g_old_rec.prl_information1
470: ,p_prl_information2_o
471: => pay_pay_shd.g_old_rec.prl_information2
472: ,p_prl_information3_o
473: => pay_pay_shd.g_old_rec.prl_information3
474: ,p_prl_information4_o
475: => pay_pay_shd.g_old_rec.prl_information4
476: ,p_prl_information5_o
477: => pay_pay_shd.g_old_rec.prl_information5
471: => pay_pay_shd.g_old_rec.prl_information2
472: ,p_prl_information3_o
473: => pay_pay_shd.g_old_rec.prl_information3
474: ,p_prl_information4_o
475: => pay_pay_shd.g_old_rec.prl_information4
476: ,p_prl_information5_o
477: => pay_pay_shd.g_old_rec.prl_information5
478: ,p_prl_information6_o
479: => pay_pay_shd.g_old_rec.prl_information6
473: => pay_pay_shd.g_old_rec.prl_information3
474: ,p_prl_information4_o
475: => pay_pay_shd.g_old_rec.prl_information4
476: ,p_prl_information5_o
477: => pay_pay_shd.g_old_rec.prl_information5
478: ,p_prl_information6_o
479: => pay_pay_shd.g_old_rec.prl_information6
480: ,p_prl_information7_o
481: => pay_pay_shd.g_old_rec.prl_information7
475: => pay_pay_shd.g_old_rec.prl_information4
476: ,p_prl_information5_o
477: => pay_pay_shd.g_old_rec.prl_information5
478: ,p_prl_information6_o
479: => pay_pay_shd.g_old_rec.prl_information6
480: ,p_prl_information7_o
481: => pay_pay_shd.g_old_rec.prl_information7
482: ,p_prl_information8_o
483: => pay_pay_shd.g_old_rec.prl_information8
477: => pay_pay_shd.g_old_rec.prl_information5
478: ,p_prl_information6_o
479: => pay_pay_shd.g_old_rec.prl_information6
480: ,p_prl_information7_o
481: => pay_pay_shd.g_old_rec.prl_information7
482: ,p_prl_information8_o
483: => pay_pay_shd.g_old_rec.prl_information8
484: ,p_prl_information9_o
485: => pay_pay_shd.g_old_rec.prl_information9
479: => pay_pay_shd.g_old_rec.prl_information6
480: ,p_prl_information7_o
481: => pay_pay_shd.g_old_rec.prl_information7
482: ,p_prl_information8_o
483: => pay_pay_shd.g_old_rec.prl_information8
484: ,p_prl_information9_o
485: => pay_pay_shd.g_old_rec.prl_information9
486: ,p_prl_information10_o
487: => pay_pay_shd.g_old_rec.prl_information10
481: => pay_pay_shd.g_old_rec.prl_information7
482: ,p_prl_information8_o
483: => pay_pay_shd.g_old_rec.prl_information8
484: ,p_prl_information9_o
485: => pay_pay_shd.g_old_rec.prl_information9
486: ,p_prl_information10_o
487: => pay_pay_shd.g_old_rec.prl_information10
488: ,p_prl_information11_o
489: => pay_pay_shd.g_old_rec.prl_information11
483: => pay_pay_shd.g_old_rec.prl_information8
484: ,p_prl_information9_o
485: => pay_pay_shd.g_old_rec.prl_information9
486: ,p_prl_information10_o
487: => pay_pay_shd.g_old_rec.prl_information10
488: ,p_prl_information11_o
489: => pay_pay_shd.g_old_rec.prl_information11
490: ,p_prl_information12_o
491: => pay_pay_shd.g_old_rec.prl_information12
485: => pay_pay_shd.g_old_rec.prl_information9
486: ,p_prl_information10_o
487: => pay_pay_shd.g_old_rec.prl_information10
488: ,p_prl_information11_o
489: => pay_pay_shd.g_old_rec.prl_information11
490: ,p_prl_information12_o
491: => pay_pay_shd.g_old_rec.prl_information12
492: ,p_prl_information13_o
493: => pay_pay_shd.g_old_rec.prl_information13
487: => pay_pay_shd.g_old_rec.prl_information10
488: ,p_prl_information11_o
489: => pay_pay_shd.g_old_rec.prl_information11
490: ,p_prl_information12_o
491: => pay_pay_shd.g_old_rec.prl_information12
492: ,p_prl_information13_o
493: => pay_pay_shd.g_old_rec.prl_information13
494: ,p_prl_information14_o
495: => pay_pay_shd.g_old_rec.prl_information14
489: => pay_pay_shd.g_old_rec.prl_information11
490: ,p_prl_information12_o
491: => pay_pay_shd.g_old_rec.prl_information12
492: ,p_prl_information13_o
493: => pay_pay_shd.g_old_rec.prl_information13
494: ,p_prl_information14_o
495: => pay_pay_shd.g_old_rec.prl_information14
496: ,p_prl_information15_o
497: => pay_pay_shd.g_old_rec.prl_information15
491: => pay_pay_shd.g_old_rec.prl_information12
492: ,p_prl_information13_o
493: => pay_pay_shd.g_old_rec.prl_information13
494: ,p_prl_information14_o
495: => pay_pay_shd.g_old_rec.prl_information14
496: ,p_prl_information15_o
497: => pay_pay_shd.g_old_rec.prl_information15
498: ,p_prl_information16_o
499: => pay_pay_shd.g_old_rec.prl_information16
493: => pay_pay_shd.g_old_rec.prl_information13
494: ,p_prl_information14_o
495: => pay_pay_shd.g_old_rec.prl_information14
496: ,p_prl_information15_o
497: => pay_pay_shd.g_old_rec.prl_information15
498: ,p_prl_information16_o
499: => pay_pay_shd.g_old_rec.prl_information16
500: ,p_prl_information17_o
501: => pay_pay_shd.g_old_rec.prl_information17
495: => pay_pay_shd.g_old_rec.prl_information14
496: ,p_prl_information15_o
497: => pay_pay_shd.g_old_rec.prl_information15
498: ,p_prl_information16_o
499: => pay_pay_shd.g_old_rec.prl_information16
500: ,p_prl_information17_o
501: => pay_pay_shd.g_old_rec.prl_information17
502: ,p_prl_information18_o
503: => pay_pay_shd.g_old_rec.prl_information18
497: => pay_pay_shd.g_old_rec.prl_information15
498: ,p_prl_information16_o
499: => pay_pay_shd.g_old_rec.prl_information16
500: ,p_prl_information17_o
501: => pay_pay_shd.g_old_rec.prl_information17
502: ,p_prl_information18_o
503: => pay_pay_shd.g_old_rec.prl_information18
504: ,p_prl_information19_o
505: => pay_pay_shd.g_old_rec.prl_information19
499: => pay_pay_shd.g_old_rec.prl_information16
500: ,p_prl_information17_o
501: => pay_pay_shd.g_old_rec.prl_information17
502: ,p_prl_information18_o
503: => pay_pay_shd.g_old_rec.prl_information18
504: ,p_prl_information19_o
505: => pay_pay_shd.g_old_rec.prl_information19
506: ,p_prl_information20_o
507: => pay_pay_shd.g_old_rec.prl_information20
501: => pay_pay_shd.g_old_rec.prl_information17
502: ,p_prl_information18_o
503: => pay_pay_shd.g_old_rec.prl_information18
504: ,p_prl_information19_o
505: => pay_pay_shd.g_old_rec.prl_information19
506: ,p_prl_information20_o
507: => pay_pay_shd.g_old_rec.prl_information20
508: ,p_prl_information21_o
509: => pay_pay_shd.g_old_rec.prl_information21
503: => pay_pay_shd.g_old_rec.prl_information18
504: ,p_prl_information19_o
505: => pay_pay_shd.g_old_rec.prl_information19
506: ,p_prl_information20_o
507: => pay_pay_shd.g_old_rec.prl_information20
508: ,p_prl_information21_o
509: => pay_pay_shd.g_old_rec.prl_information21
510: ,p_prl_information22_o
511: => pay_pay_shd.g_old_rec.prl_information22
505: => pay_pay_shd.g_old_rec.prl_information19
506: ,p_prl_information20_o
507: => pay_pay_shd.g_old_rec.prl_information20
508: ,p_prl_information21_o
509: => pay_pay_shd.g_old_rec.prl_information21
510: ,p_prl_information22_o
511: => pay_pay_shd.g_old_rec.prl_information22
512: ,p_prl_information23_o
513: => pay_pay_shd.g_old_rec.prl_information23
507: => pay_pay_shd.g_old_rec.prl_information20
508: ,p_prl_information21_o
509: => pay_pay_shd.g_old_rec.prl_information21
510: ,p_prl_information22_o
511: => pay_pay_shd.g_old_rec.prl_information22
512: ,p_prl_information23_o
513: => pay_pay_shd.g_old_rec.prl_information23
514: ,p_prl_information24_o
515: => pay_pay_shd.g_old_rec.prl_information24
509: => pay_pay_shd.g_old_rec.prl_information21
510: ,p_prl_information22_o
511: => pay_pay_shd.g_old_rec.prl_information22
512: ,p_prl_information23_o
513: => pay_pay_shd.g_old_rec.prl_information23
514: ,p_prl_information24_o
515: => pay_pay_shd.g_old_rec.prl_information24
516: ,p_prl_information25_o
517: => pay_pay_shd.g_old_rec.prl_information25
511: => pay_pay_shd.g_old_rec.prl_information22
512: ,p_prl_information23_o
513: => pay_pay_shd.g_old_rec.prl_information23
514: ,p_prl_information24_o
515: => pay_pay_shd.g_old_rec.prl_information24
516: ,p_prl_information25_o
517: => pay_pay_shd.g_old_rec.prl_information25
518: ,p_prl_information26_o
519: => pay_pay_shd.g_old_rec.prl_information26
513: => pay_pay_shd.g_old_rec.prl_information23
514: ,p_prl_information24_o
515: => pay_pay_shd.g_old_rec.prl_information24
516: ,p_prl_information25_o
517: => pay_pay_shd.g_old_rec.prl_information25
518: ,p_prl_information26_o
519: => pay_pay_shd.g_old_rec.prl_information26
520: ,p_prl_information27_o
521: => pay_pay_shd.g_old_rec.prl_information27
515: => pay_pay_shd.g_old_rec.prl_information24
516: ,p_prl_information25_o
517: => pay_pay_shd.g_old_rec.prl_information25
518: ,p_prl_information26_o
519: => pay_pay_shd.g_old_rec.prl_information26
520: ,p_prl_information27_o
521: => pay_pay_shd.g_old_rec.prl_information27
522: ,p_prl_information28_o
523: => pay_pay_shd.g_old_rec.prl_information28
517: => pay_pay_shd.g_old_rec.prl_information25
518: ,p_prl_information26_o
519: => pay_pay_shd.g_old_rec.prl_information26
520: ,p_prl_information27_o
521: => pay_pay_shd.g_old_rec.prl_information27
522: ,p_prl_information28_o
523: => pay_pay_shd.g_old_rec.prl_information28
524: ,p_prl_information29_o
525: => pay_pay_shd.g_old_rec.prl_information29
519: => pay_pay_shd.g_old_rec.prl_information26
520: ,p_prl_information27_o
521: => pay_pay_shd.g_old_rec.prl_information27
522: ,p_prl_information28_o
523: => pay_pay_shd.g_old_rec.prl_information28
524: ,p_prl_information29_o
525: => pay_pay_shd.g_old_rec.prl_information29
526: ,p_prl_information30_o
527: => pay_pay_shd.g_old_rec.prl_information30
521: => pay_pay_shd.g_old_rec.prl_information27
522: ,p_prl_information28_o
523: => pay_pay_shd.g_old_rec.prl_information28
524: ,p_prl_information29_o
525: => pay_pay_shd.g_old_rec.prl_information29
526: ,p_prl_information30_o
527: => pay_pay_shd.g_old_rec.prl_information30
528: ,p_multi_assignments_flag_o
529: => pay_pay_shd.g_old_rec.multi_assignments_flag
523: => pay_pay_shd.g_old_rec.prl_information28
524: ,p_prl_information29_o
525: => pay_pay_shd.g_old_rec.prl_information29
526: ,p_prl_information30_o
527: => pay_pay_shd.g_old_rec.prl_information30
528: ,p_multi_assignments_flag_o
529: => pay_pay_shd.g_old_rec.multi_assignments_flag
530: ,p_period_reset_years_o
531: => pay_pay_shd.g_old_rec.period_reset_years
525: => pay_pay_shd.g_old_rec.prl_information29
526: ,p_prl_information30_o
527: => pay_pay_shd.g_old_rec.prl_information30
528: ,p_multi_assignments_flag_o
529: => pay_pay_shd.g_old_rec.multi_assignments_flag
530: ,p_period_reset_years_o
531: => pay_pay_shd.g_old_rec.period_reset_years
532: ,p_object_version_number_o
533: => pay_pay_shd.g_old_rec.object_version_number
527: => pay_pay_shd.g_old_rec.prl_information30
528: ,p_multi_assignments_flag_o
529: => pay_pay_shd.g_old_rec.multi_assignments_flag
530: ,p_period_reset_years_o
531: => pay_pay_shd.g_old_rec.period_reset_years
532: ,p_object_version_number_o
533: => pay_pay_shd.g_old_rec.object_version_number
534: ,p_payslip_view_date_offset_o
535: => pay_pay_shd.g_old_rec.payslip_view_date_offset
529: => pay_pay_shd.g_old_rec.multi_assignments_flag
530: ,p_period_reset_years_o
531: => pay_pay_shd.g_old_rec.period_reset_years
532: ,p_object_version_number_o
533: => pay_pay_shd.g_old_rec.object_version_number
534: ,p_payslip_view_date_offset_o
535: => pay_pay_shd.g_old_rec.payslip_view_date_offset
536: );
537: --
531: => pay_pay_shd.g_old_rec.period_reset_years
532: ,p_object_version_number_o
533: => pay_pay_shd.g_old_rec.object_version_number
534: ,p_payslip_view_date_offset_o
535: => pay_pay_shd.g_old_rec.payslip_view_date_offset
536: );
537: --
538: exception
539: --
554: -- ----------------------------------------------------------------------------
555: Procedure del
556: (p_effective_date in date
557: ,p_datetrack_mode in varchar2
558: ,p_rec in out nocopy pay_pay_shd.g_rec_type
559: ) is
560: --
561: l_proc varchar2(72) := g_package||'del';
562: l_validation_start_date date;
572: --
573: -- We must lock the row which we need to delete.
574: --
575: --
576: pay_pay_shd.lck
577: (p_effective_date => p_effective_date
578: ,p_datetrack_mode => p_datetrack_mode
579: ,p_payroll_id => p_rec.payroll_id
580: ,p_object_version_number => p_rec.object_version_number
639: ,p_effective_start_date out nocopy date
640: ,p_effective_end_date out nocopy date
641: ) is
642: --
643: l_rec pay_pay_shd.g_rec_type;
644: l_proc varchar2(72) := g_package||'del';
645: --
646: Begin
647: hr_utility.set_location('Entering:'||l_proc, 5);