eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_PAY_DEL dependencies on PAY_PAY_SHD

Line 54: (p_rec in out nocopy pay_pay_shd.g_rec_type

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

Line 67: pay_pay_shd.g_api_dml := true; -- Set the api dml status

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: --

Line 76: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

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

Line 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: --

Line 92: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

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');

Line 109: pay_pay_shd.g_api_dml := false; -- Unset the api dml status

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: --

Line 118: (p_rec in out nocopy pay_pay_shd.g_rec_type

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

Line 177: (p_rec in out nocopy pay_pay_shd.g_rec_type

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

Line 193: := pay_pay_shd.g_old_rec.effective_start_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;

Line 207: pay_pay_shd.upd_effective_end_date

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

Line 261: (p_rec in out nocopy pay_pay_shd.g_rec_type

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

Line 343: (p_rec in pay_pay_shd.g_rec_type

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

Line 375: => pay_pay_shd.g_old_rec.effective_start_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

Line 377: => pay_pay_shd.g_old_rec.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
380: ,p_business_group_id_o
381: => pay_pay_shd.g_old_rec.business_group_id

Line 379: => pay_pay_shd.g_old_rec.default_payment_method_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

Line 381: => pay_pay_shd.g_old_rec.business_group_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

Line 383: => pay_pay_shd.g_old_rec.consolidation_set_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

Line 385: => pay_pay_shd.g_old_rec.cost_allocation_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

Line 387: => pay_pay_shd.g_old_rec.suspense_account_keyflex_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

Line 389: => pay_pay_shd.g_old_rec.gl_set_of_books_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

Line 391: => pay_pay_shd.g_old_rec.soft_coding_keyflex_id

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

Line 393: => pay_pay_shd.g_old_rec.period_type

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

Line 395: => pay_pay_shd.g_old_rec.organization_id

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

Line 397: => pay_pay_shd.g_old_rec.cut_off_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

Line 399: => pay_pay_shd.g_old_rec.direct_deposit_date_offset

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

Line 401: => pay_pay_shd.g_old_rec.first_period_end_date

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

Line 403: => pay_pay_shd.g_old_rec.negative_pay_allowed_flag

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

Line 405: => pay_pay_shd.g_old_rec.number_of_years

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

Line 407: => pay_pay_shd.g_old_rec.pay_advice_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

Line 409: => pay_pay_shd.g_old_rec.pay_date_offset

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

Line 411: => pay_pay_shd.g_old_rec.payroll_name

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

Line 413: => pay_pay_shd.g_old_rec.workload_shifting_level

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

Line 415: => pay_pay_shd.g_old_rec.comment_id

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

Line 417: => pay_pay_shd.g_old_rec.comments

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

Line 419: => pay_pay_shd.g_old_rec.midpoint_offset

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

Line 421: => pay_pay_shd.g_old_rec.attribute_category

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

Line 423: => pay_pay_shd.g_old_rec.attribute1

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

Line 425: => pay_pay_shd.g_old_rec.attribute2

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

Line 427: => pay_pay_shd.g_old_rec.attribute3

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

Line 429: => pay_pay_shd.g_old_rec.attribute4

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

Line 431: => pay_pay_shd.g_old_rec.attribute5

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

Line 433: => pay_pay_shd.g_old_rec.attribute6

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

Line 435: => pay_pay_shd.g_old_rec.attribute7

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

Line 437: => pay_pay_shd.g_old_rec.attribute8

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

Line 439: => pay_pay_shd.g_old_rec.attribute9

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

Line 441: => pay_pay_shd.g_old_rec.attribute10

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

Line 443: => pay_pay_shd.g_old_rec.attribute11

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

Line 445: => pay_pay_shd.g_old_rec.attribute12

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

Line 447: => pay_pay_shd.g_old_rec.attribute13

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

Line 449: => pay_pay_shd.g_old_rec.attribute14

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

Line 451: => pay_pay_shd.g_old_rec.attribute15

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

Line 453: => pay_pay_shd.g_old_rec.attribute16

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

Line 455: => pay_pay_shd.g_old_rec.attribute17

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

Line 457: => pay_pay_shd.g_old_rec.attribute18

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

Line 459: => pay_pay_shd.g_old_rec.attribute19

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

Line 461: => pay_pay_shd.g_old_rec.attribute20

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

Line 463: => pay_pay_shd.g_old_rec.arrears_flag

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

Line 465: => pay_pay_shd.g_old_rec.payroll_type

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

Line 467: => pay_pay_shd.g_old_rec.prl_information_category

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

Line 469: => pay_pay_shd.g_old_rec.prl_information1

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

Line 471: => pay_pay_shd.g_old_rec.prl_information2

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

Line 473: => pay_pay_shd.g_old_rec.prl_information3

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

Line 475: => pay_pay_shd.g_old_rec.prl_information4

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

Line 477: => pay_pay_shd.g_old_rec.prl_information5

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

Line 479: => pay_pay_shd.g_old_rec.prl_information6

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

Line 481: => pay_pay_shd.g_old_rec.prl_information7

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

Line 483: => pay_pay_shd.g_old_rec.prl_information8

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

Line 485: => pay_pay_shd.g_old_rec.prl_information9

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

Line 487: => pay_pay_shd.g_old_rec.prl_information10

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

Line 489: => pay_pay_shd.g_old_rec.prl_information11

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

Line 491: => pay_pay_shd.g_old_rec.prl_information12

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

Line 493: => pay_pay_shd.g_old_rec.prl_information13

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

Line 495: => pay_pay_shd.g_old_rec.prl_information14

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

Line 497: => pay_pay_shd.g_old_rec.prl_information15

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

Line 499: => pay_pay_shd.g_old_rec.prl_information16

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

Line 501: => pay_pay_shd.g_old_rec.prl_information17

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

Line 503: => pay_pay_shd.g_old_rec.prl_information18

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

Line 505: => pay_pay_shd.g_old_rec.prl_information19

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

Line 507: => pay_pay_shd.g_old_rec.prl_information20

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

Line 509: => pay_pay_shd.g_old_rec.prl_information21

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

Line 511: => pay_pay_shd.g_old_rec.prl_information22

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

Line 513: => pay_pay_shd.g_old_rec.prl_information23

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

Line 515: => pay_pay_shd.g_old_rec.prl_information24

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

Line 517: => pay_pay_shd.g_old_rec.prl_information25

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

Line 519: => pay_pay_shd.g_old_rec.prl_information26

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

Line 521: => pay_pay_shd.g_old_rec.prl_information27

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

Line 523: => pay_pay_shd.g_old_rec.prl_information28

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

Line 525: => pay_pay_shd.g_old_rec.prl_information29

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

Line 527: => pay_pay_shd.g_old_rec.prl_information30

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

Line 529: => pay_pay_shd.g_old_rec.multi_assignments_flag

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

Line 531: => pay_pay_shd.g_old_rec.period_reset_years

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

Line 533: => pay_pay_shd.g_old_rec.object_version_number

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: --

Line 535: => pay_pay_shd.g_old_rec.payslip_view_date_offset

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: --

Line 558: ,p_rec in out nocopy pay_pay_shd.g_rec_type

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;

Line 576: pay_pay_shd.lck

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

Line 643: l_rec pay_pay_shd.g_rec_type;

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);