APPS.PAY_OPM_DEL dependencies on PAY_OPM_SHD

Line 54: (p_rec in out nocopy pay_opm_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_opm_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 66: pay_opm_shd.g_api_dml := true; -- Set the api dml status

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: pay_opm_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

Line 75: pay_opm_shd.g_api_dml := false; -- Unset the api dml status

71: delete from pay_org_payment_methods_f
72: where org_payment_method_id = p_rec.org_payment_method_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pay_opm_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

Line 77: pay_opm_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pay_opm_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

Line 86: pay_opm_shd.g_api_dml := false; -- Unset the api dml status

82: delete from pay_org_payment_methods_f
83: where org_payment_method_id = p_rec.org_payment_method_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --

Line 93: pay_opm_shd.g_api_dml := false; -- Unset the api dml status

89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: pay_opm_shd.g_api_dml := false; -- Unset the api dml status
94: Raise;
95: --
96: End dt_delete_dml;
97: --

Line 102: (p_rec in out nocopy pay_opm_shd.g_rec_type

98: -- ----------------------------------------------------------------------------
99: -- |------------------------------< delete_dml >------------------------------|
100: -- ----------------------------------------------------------------------------
101: Procedure delete_dml
102: (p_rec in out nocopy pay_opm_shd.g_rec_type
103: ,p_effective_date in date
104: ,p_datetrack_mode in varchar2
105: ,p_validation_start_date in date
106: ,p_validation_end_date in date

Line 159: (p_rec in out nocopy pay_opm_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure dt_pre_delete
159: (p_rec in out nocopy pay_opm_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 174: := pay_opm_shd.g_old_rec.effective_start_date;

170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date
174: := pay_opm_shd.g_old_rec.effective_start_date;
175: --
176: If (p_datetrack_mode = hr_api.g_delete) then
177: p_rec.effective_end_date := p_validation_start_date - 1;
178: Else

Line 184: pay_opm_shd.upd_effective_end_date

180: End If;
181: --
182: -- Update the current effective end date record
183: --
184: pay_opm_shd.upd_effective_end_date
185: (p_effective_date => p_effective_date
186: ,p_base_key_value => p_rec.org_payment_method_id
187: ,p_new_effective_end_date => p_rec.effective_end_date
188: ,p_validation_start_date => p_validation_start_date

Line 233: (p_rec in out nocopy pay_opm_shd.g_rec_type

229: --
230: -- {End Of Comments}
231: -- ----------------------------------------------------------------------------
232: Procedure pre_delete
233: (p_rec in out nocopy pay_opm_shd.g_rec_type
234: ,p_effective_date in date
235: ,p_datetrack_mode in varchar2
236: ,p_validation_start_date in date
237: ,p_validation_end_date in date

Line 319: (p_rec in pay_opm_shd.g_rec_type

315: --
316: -- {End Of Comments}
317: -- ----------------------------------------------------------------------------
318: Procedure post_delete
319: (p_rec in pay_opm_shd.g_rec_type
320: ,p_effective_date in date
321: ,p_datetrack_mode in varchar2
322: ,p_validation_start_date in date
323: ,p_validation_end_date in date

Line 348: => pay_opm_shd.g_old_rec.effective_start_date

344: => p_rec.effective_start_date
345: ,p_effective_end_date
346: => p_rec.effective_end_date
347: ,p_effective_start_date_o
348: => pay_opm_shd.g_old_rec.effective_start_date
349: ,p_effective_end_date_o
350: => pay_opm_shd.g_old_rec.effective_end_date
351: ,p_business_group_id_o
352: => pay_opm_shd.g_old_rec.business_group_id

Line 350: => pay_opm_shd.g_old_rec.effective_end_date

346: => p_rec.effective_end_date
347: ,p_effective_start_date_o
348: => pay_opm_shd.g_old_rec.effective_start_date
349: ,p_effective_end_date_o
350: => pay_opm_shd.g_old_rec.effective_end_date
351: ,p_business_group_id_o
352: => pay_opm_shd.g_old_rec.business_group_id
353: ,p_external_account_id_o
354: => pay_opm_shd.g_old_rec.external_account_id

Line 352: => pay_opm_shd.g_old_rec.business_group_id

348: => pay_opm_shd.g_old_rec.effective_start_date
349: ,p_effective_end_date_o
350: => pay_opm_shd.g_old_rec.effective_end_date
351: ,p_business_group_id_o
352: => pay_opm_shd.g_old_rec.business_group_id
353: ,p_external_account_id_o
354: => pay_opm_shd.g_old_rec.external_account_id
355: ,p_currency_code_o
356: => pay_opm_shd.g_old_rec.currency_code

Line 354: => pay_opm_shd.g_old_rec.external_account_id

350: => pay_opm_shd.g_old_rec.effective_end_date
351: ,p_business_group_id_o
352: => pay_opm_shd.g_old_rec.business_group_id
353: ,p_external_account_id_o
354: => pay_opm_shd.g_old_rec.external_account_id
355: ,p_currency_code_o
356: => pay_opm_shd.g_old_rec.currency_code
357: ,p_payment_type_id_o
358: => pay_opm_shd.g_old_rec.payment_type_id

Line 356: => pay_opm_shd.g_old_rec.currency_code

352: => pay_opm_shd.g_old_rec.business_group_id
353: ,p_external_account_id_o
354: => pay_opm_shd.g_old_rec.external_account_id
355: ,p_currency_code_o
356: => pay_opm_shd.g_old_rec.currency_code
357: ,p_payment_type_id_o
358: => pay_opm_shd.g_old_rec.payment_type_id
359: ,p_defined_balance_id_o
360: => pay_opm_shd.g_old_rec.defined_balance_id

Line 358: => pay_opm_shd.g_old_rec.payment_type_id

354: => pay_opm_shd.g_old_rec.external_account_id
355: ,p_currency_code_o
356: => pay_opm_shd.g_old_rec.currency_code
357: ,p_payment_type_id_o
358: => pay_opm_shd.g_old_rec.payment_type_id
359: ,p_defined_balance_id_o
360: => pay_opm_shd.g_old_rec.defined_balance_id
361: ,p_org_payment_method_name_o
362: => pay_opm_shd.g_old_rec.org_payment_method_name

Line 360: => pay_opm_shd.g_old_rec.defined_balance_id

356: => pay_opm_shd.g_old_rec.currency_code
357: ,p_payment_type_id_o
358: => pay_opm_shd.g_old_rec.payment_type_id
359: ,p_defined_balance_id_o
360: => pay_opm_shd.g_old_rec.defined_balance_id
361: ,p_org_payment_method_name_o
362: => pay_opm_shd.g_old_rec.org_payment_method_name
363: ,p_comment_id_o
364: => pay_opm_shd.g_old_rec.comment_id

Line 362: => pay_opm_shd.g_old_rec.org_payment_method_name

358: => pay_opm_shd.g_old_rec.payment_type_id
359: ,p_defined_balance_id_o
360: => pay_opm_shd.g_old_rec.defined_balance_id
361: ,p_org_payment_method_name_o
362: => pay_opm_shd.g_old_rec.org_payment_method_name
363: ,p_comment_id_o
364: => pay_opm_shd.g_old_rec.comment_id
365: ,p_comments_o
366: => pay_opm_shd.g_old_rec.comments

Line 364: => pay_opm_shd.g_old_rec.comment_id

360: => pay_opm_shd.g_old_rec.defined_balance_id
361: ,p_org_payment_method_name_o
362: => pay_opm_shd.g_old_rec.org_payment_method_name
363: ,p_comment_id_o
364: => pay_opm_shd.g_old_rec.comment_id
365: ,p_comments_o
366: => pay_opm_shd.g_old_rec.comments
367: ,p_attribute_category_o
368: => pay_opm_shd.g_old_rec.attribute_category

Line 366: => pay_opm_shd.g_old_rec.comments

362: => pay_opm_shd.g_old_rec.org_payment_method_name
363: ,p_comment_id_o
364: => pay_opm_shd.g_old_rec.comment_id
365: ,p_comments_o
366: => pay_opm_shd.g_old_rec.comments
367: ,p_attribute_category_o
368: => pay_opm_shd.g_old_rec.attribute_category
369: ,p_attribute1_o
370: => pay_opm_shd.g_old_rec.attribute1

Line 368: => pay_opm_shd.g_old_rec.attribute_category

364: => pay_opm_shd.g_old_rec.comment_id
365: ,p_comments_o
366: => pay_opm_shd.g_old_rec.comments
367: ,p_attribute_category_o
368: => pay_opm_shd.g_old_rec.attribute_category
369: ,p_attribute1_o
370: => pay_opm_shd.g_old_rec.attribute1
371: ,p_attribute2_o
372: => pay_opm_shd.g_old_rec.attribute2

Line 370: => pay_opm_shd.g_old_rec.attribute1

366: => pay_opm_shd.g_old_rec.comments
367: ,p_attribute_category_o
368: => pay_opm_shd.g_old_rec.attribute_category
369: ,p_attribute1_o
370: => pay_opm_shd.g_old_rec.attribute1
371: ,p_attribute2_o
372: => pay_opm_shd.g_old_rec.attribute2
373: ,p_attribute3_o
374: => pay_opm_shd.g_old_rec.attribute3

Line 372: => pay_opm_shd.g_old_rec.attribute2

368: => pay_opm_shd.g_old_rec.attribute_category
369: ,p_attribute1_o
370: => pay_opm_shd.g_old_rec.attribute1
371: ,p_attribute2_o
372: => pay_opm_shd.g_old_rec.attribute2
373: ,p_attribute3_o
374: => pay_opm_shd.g_old_rec.attribute3
375: ,p_attribute4_o
376: => pay_opm_shd.g_old_rec.attribute4

Line 374: => pay_opm_shd.g_old_rec.attribute3

370: => pay_opm_shd.g_old_rec.attribute1
371: ,p_attribute2_o
372: => pay_opm_shd.g_old_rec.attribute2
373: ,p_attribute3_o
374: => pay_opm_shd.g_old_rec.attribute3
375: ,p_attribute4_o
376: => pay_opm_shd.g_old_rec.attribute4
377: ,p_attribute5_o
378: => pay_opm_shd.g_old_rec.attribute5

Line 376: => pay_opm_shd.g_old_rec.attribute4

372: => pay_opm_shd.g_old_rec.attribute2
373: ,p_attribute3_o
374: => pay_opm_shd.g_old_rec.attribute3
375: ,p_attribute4_o
376: => pay_opm_shd.g_old_rec.attribute4
377: ,p_attribute5_o
378: => pay_opm_shd.g_old_rec.attribute5
379: ,p_attribute6_o
380: => pay_opm_shd.g_old_rec.attribute6

Line 378: => pay_opm_shd.g_old_rec.attribute5

374: => pay_opm_shd.g_old_rec.attribute3
375: ,p_attribute4_o
376: => pay_opm_shd.g_old_rec.attribute4
377: ,p_attribute5_o
378: => pay_opm_shd.g_old_rec.attribute5
379: ,p_attribute6_o
380: => pay_opm_shd.g_old_rec.attribute6
381: ,p_attribute7_o
382: => pay_opm_shd.g_old_rec.attribute7

Line 380: => pay_opm_shd.g_old_rec.attribute6

376: => pay_opm_shd.g_old_rec.attribute4
377: ,p_attribute5_o
378: => pay_opm_shd.g_old_rec.attribute5
379: ,p_attribute6_o
380: => pay_opm_shd.g_old_rec.attribute6
381: ,p_attribute7_o
382: => pay_opm_shd.g_old_rec.attribute7
383: ,p_attribute8_o
384: => pay_opm_shd.g_old_rec.attribute8

Line 382: => pay_opm_shd.g_old_rec.attribute7

378: => pay_opm_shd.g_old_rec.attribute5
379: ,p_attribute6_o
380: => pay_opm_shd.g_old_rec.attribute6
381: ,p_attribute7_o
382: => pay_opm_shd.g_old_rec.attribute7
383: ,p_attribute8_o
384: => pay_opm_shd.g_old_rec.attribute8
385: ,p_attribute9_o
386: => pay_opm_shd.g_old_rec.attribute9

Line 384: => pay_opm_shd.g_old_rec.attribute8

380: => pay_opm_shd.g_old_rec.attribute6
381: ,p_attribute7_o
382: => pay_opm_shd.g_old_rec.attribute7
383: ,p_attribute8_o
384: => pay_opm_shd.g_old_rec.attribute8
385: ,p_attribute9_o
386: => pay_opm_shd.g_old_rec.attribute9
387: ,p_attribute10_o
388: => pay_opm_shd.g_old_rec.attribute10

Line 386: => pay_opm_shd.g_old_rec.attribute9

382: => pay_opm_shd.g_old_rec.attribute7
383: ,p_attribute8_o
384: => pay_opm_shd.g_old_rec.attribute8
385: ,p_attribute9_o
386: => pay_opm_shd.g_old_rec.attribute9
387: ,p_attribute10_o
388: => pay_opm_shd.g_old_rec.attribute10
389: ,p_attribute11_o
390: => pay_opm_shd.g_old_rec.attribute11

Line 388: => pay_opm_shd.g_old_rec.attribute10

384: => pay_opm_shd.g_old_rec.attribute8
385: ,p_attribute9_o
386: => pay_opm_shd.g_old_rec.attribute9
387: ,p_attribute10_o
388: => pay_opm_shd.g_old_rec.attribute10
389: ,p_attribute11_o
390: => pay_opm_shd.g_old_rec.attribute11
391: ,p_attribute12_o
392: => pay_opm_shd.g_old_rec.attribute12

Line 390: => pay_opm_shd.g_old_rec.attribute11

386: => pay_opm_shd.g_old_rec.attribute9
387: ,p_attribute10_o
388: => pay_opm_shd.g_old_rec.attribute10
389: ,p_attribute11_o
390: => pay_opm_shd.g_old_rec.attribute11
391: ,p_attribute12_o
392: => pay_opm_shd.g_old_rec.attribute12
393: ,p_attribute13_o
394: => pay_opm_shd.g_old_rec.attribute13

Line 392: => pay_opm_shd.g_old_rec.attribute12

388: => pay_opm_shd.g_old_rec.attribute10
389: ,p_attribute11_o
390: => pay_opm_shd.g_old_rec.attribute11
391: ,p_attribute12_o
392: => pay_opm_shd.g_old_rec.attribute12
393: ,p_attribute13_o
394: => pay_opm_shd.g_old_rec.attribute13
395: ,p_attribute14_o
396: => pay_opm_shd.g_old_rec.attribute14

Line 394: => pay_opm_shd.g_old_rec.attribute13

390: => pay_opm_shd.g_old_rec.attribute11
391: ,p_attribute12_o
392: => pay_opm_shd.g_old_rec.attribute12
393: ,p_attribute13_o
394: => pay_opm_shd.g_old_rec.attribute13
395: ,p_attribute14_o
396: => pay_opm_shd.g_old_rec.attribute14
397: ,p_attribute15_o
398: => pay_opm_shd.g_old_rec.attribute15

Line 396: => pay_opm_shd.g_old_rec.attribute14

392: => pay_opm_shd.g_old_rec.attribute12
393: ,p_attribute13_o
394: => pay_opm_shd.g_old_rec.attribute13
395: ,p_attribute14_o
396: => pay_opm_shd.g_old_rec.attribute14
397: ,p_attribute15_o
398: => pay_opm_shd.g_old_rec.attribute15
399: ,p_attribute16_o
400: => pay_opm_shd.g_old_rec.attribute16

Line 398: => pay_opm_shd.g_old_rec.attribute15

394: => pay_opm_shd.g_old_rec.attribute13
395: ,p_attribute14_o
396: => pay_opm_shd.g_old_rec.attribute14
397: ,p_attribute15_o
398: => pay_opm_shd.g_old_rec.attribute15
399: ,p_attribute16_o
400: => pay_opm_shd.g_old_rec.attribute16
401: ,p_attribute17_o
402: => pay_opm_shd.g_old_rec.attribute17

Line 400: => pay_opm_shd.g_old_rec.attribute16

396: => pay_opm_shd.g_old_rec.attribute14
397: ,p_attribute15_o
398: => pay_opm_shd.g_old_rec.attribute15
399: ,p_attribute16_o
400: => pay_opm_shd.g_old_rec.attribute16
401: ,p_attribute17_o
402: => pay_opm_shd.g_old_rec.attribute17
403: ,p_attribute18_o
404: => pay_opm_shd.g_old_rec.attribute18

Line 402: => pay_opm_shd.g_old_rec.attribute17

398: => pay_opm_shd.g_old_rec.attribute15
399: ,p_attribute16_o
400: => pay_opm_shd.g_old_rec.attribute16
401: ,p_attribute17_o
402: => pay_opm_shd.g_old_rec.attribute17
403: ,p_attribute18_o
404: => pay_opm_shd.g_old_rec.attribute18
405: ,p_attribute19_o
406: => pay_opm_shd.g_old_rec.attribute19

Line 404: => pay_opm_shd.g_old_rec.attribute18

400: => pay_opm_shd.g_old_rec.attribute16
401: ,p_attribute17_o
402: => pay_opm_shd.g_old_rec.attribute17
403: ,p_attribute18_o
404: => pay_opm_shd.g_old_rec.attribute18
405: ,p_attribute19_o
406: => pay_opm_shd.g_old_rec.attribute19
407: ,p_attribute20_o
408: => pay_opm_shd.g_old_rec.attribute20

Line 406: => pay_opm_shd.g_old_rec.attribute19

402: => pay_opm_shd.g_old_rec.attribute17
403: ,p_attribute18_o
404: => pay_opm_shd.g_old_rec.attribute18
405: ,p_attribute19_o
406: => pay_opm_shd.g_old_rec.attribute19
407: ,p_attribute20_o
408: => pay_opm_shd.g_old_rec.attribute20
409: ,p_pmeth_information_category_o
410: => pay_opm_shd.g_old_rec.pmeth_information_category

Line 408: => pay_opm_shd.g_old_rec.attribute20

404: => pay_opm_shd.g_old_rec.attribute18
405: ,p_attribute19_o
406: => pay_opm_shd.g_old_rec.attribute19
407: ,p_attribute20_o
408: => pay_opm_shd.g_old_rec.attribute20
409: ,p_pmeth_information_category_o
410: => pay_opm_shd.g_old_rec.pmeth_information_category
411: ,p_pmeth_information1_o
412: => pay_opm_shd.g_old_rec.pmeth_information1

Line 410: => pay_opm_shd.g_old_rec.pmeth_information_category

406: => pay_opm_shd.g_old_rec.attribute19
407: ,p_attribute20_o
408: => pay_opm_shd.g_old_rec.attribute20
409: ,p_pmeth_information_category_o
410: => pay_opm_shd.g_old_rec.pmeth_information_category
411: ,p_pmeth_information1_o
412: => pay_opm_shd.g_old_rec.pmeth_information1
413: ,p_pmeth_information2_o
414: => pay_opm_shd.g_old_rec.pmeth_information2

Line 412: => pay_opm_shd.g_old_rec.pmeth_information1

408: => pay_opm_shd.g_old_rec.attribute20
409: ,p_pmeth_information_category_o
410: => pay_opm_shd.g_old_rec.pmeth_information_category
411: ,p_pmeth_information1_o
412: => pay_opm_shd.g_old_rec.pmeth_information1
413: ,p_pmeth_information2_o
414: => pay_opm_shd.g_old_rec.pmeth_information2
415: ,p_pmeth_information3_o
416: => pay_opm_shd.g_old_rec.pmeth_information3

Line 414: => pay_opm_shd.g_old_rec.pmeth_information2

410: => pay_opm_shd.g_old_rec.pmeth_information_category
411: ,p_pmeth_information1_o
412: => pay_opm_shd.g_old_rec.pmeth_information1
413: ,p_pmeth_information2_o
414: => pay_opm_shd.g_old_rec.pmeth_information2
415: ,p_pmeth_information3_o
416: => pay_opm_shd.g_old_rec.pmeth_information3
417: ,p_pmeth_information4_o
418: => pay_opm_shd.g_old_rec.pmeth_information4

Line 416: => pay_opm_shd.g_old_rec.pmeth_information3

412: => pay_opm_shd.g_old_rec.pmeth_information1
413: ,p_pmeth_information2_o
414: => pay_opm_shd.g_old_rec.pmeth_information2
415: ,p_pmeth_information3_o
416: => pay_opm_shd.g_old_rec.pmeth_information3
417: ,p_pmeth_information4_o
418: => pay_opm_shd.g_old_rec.pmeth_information4
419: ,p_pmeth_information5_o
420: => pay_opm_shd.g_old_rec.pmeth_information5

Line 418: => pay_opm_shd.g_old_rec.pmeth_information4

414: => pay_opm_shd.g_old_rec.pmeth_information2
415: ,p_pmeth_information3_o
416: => pay_opm_shd.g_old_rec.pmeth_information3
417: ,p_pmeth_information4_o
418: => pay_opm_shd.g_old_rec.pmeth_information4
419: ,p_pmeth_information5_o
420: => pay_opm_shd.g_old_rec.pmeth_information5
421: ,p_pmeth_information6_o
422: => pay_opm_shd.g_old_rec.pmeth_information6

Line 420: => pay_opm_shd.g_old_rec.pmeth_information5

416: => pay_opm_shd.g_old_rec.pmeth_information3
417: ,p_pmeth_information4_o
418: => pay_opm_shd.g_old_rec.pmeth_information4
419: ,p_pmeth_information5_o
420: => pay_opm_shd.g_old_rec.pmeth_information5
421: ,p_pmeth_information6_o
422: => pay_opm_shd.g_old_rec.pmeth_information6
423: ,p_pmeth_information7_o
424: => pay_opm_shd.g_old_rec.pmeth_information7

Line 422: => pay_opm_shd.g_old_rec.pmeth_information6

418: => pay_opm_shd.g_old_rec.pmeth_information4
419: ,p_pmeth_information5_o
420: => pay_opm_shd.g_old_rec.pmeth_information5
421: ,p_pmeth_information6_o
422: => pay_opm_shd.g_old_rec.pmeth_information6
423: ,p_pmeth_information7_o
424: => pay_opm_shd.g_old_rec.pmeth_information7
425: ,p_pmeth_information8_o
426: => pay_opm_shd.g_old_rec.pmeth_information8

Line 424: => pay_opm_shd.g_old_rec.pmeth_information7

420: => pay_opm_shd.g_old_rec.pmeth_information5
421: ,p_pmeth_information6_o
422: => pay_opm_shd.g_old_rec.pmeth_information6
423: ,p_pmeth_information7_o
424: => pay_opm_shd.g_old_rec.pmeth_information7
425: ,p_pmeth_information8_o
426: => pay_opm_shd.g_old_rec.pmeth_information8
427: ,p_pmeth_information9_o
428: => pay_opm_shd.g_old_rec.pmeth_information9

Line 426: => pay_opm_shd.g_old_rec.pmeth_information8

422: => pay_opm_shd.g_old_rec.pmeth_information6
423: ,p_pmeth_information7_o
424: => pay_opm_shd.g_old_rec.pmeth_information7
425: ,p_pmeth_information8_o
426: => pay_opm_shd.g_old_rec.pmeth_information8
427: ,p_pmeth_information9_o
428: => pay_opm_shd.g_old_rec.pmeth_information9
429: ,p_pmeth_information10_o
430: => pay_opm_shd.g_old_rec.pmeth_information10

Line 428: => pay_opm_shd.g_old_rec.pmeth_information9

424: => pay_opm_shd.g_old_rec.pmeth_information7
425: ,p_pmeth_information8_o
426: => pay_opm_shd.g_old_rec.pmeth_information8
427: ,p_pmeth_information9_o
428: => pay_opm_shd.g_old_rec.pmeth_information9
429: ,p_pmeth_information10_o
430: => pay_opm_shd.g_old_rec.pmeth_information10
431: ,p_pmeth_information11_o
432: => pay_opm_shd.g_old_rec.pmeth_information11

Line 430: => pay_opm_shd.g_old_rec.pmeth_information10

426: => pay_opm_shd.g_old_rec.pmeth_information8
427: ,p_pmeth_information9_o
428: => pay_opm_shd.g_old_rec.pmeth_information9
429: ,p_pmeth_information10_o
430: => pay_opm_shd.g_old_rec.pmeth_information10
431: ,p_pmeth_information11_o
432: => pay_opm_shd.g_old_rec.pmeth_information11
433: ,p_pmeth_information12_o
434: => pay_opm_shd.g_old_rec.pmeth_information12

Line 432: => pay_opm_shd.g_old_rec.pmeth_information11

428: => pay_opm_shd.g_old_rec.pmeth_information9
429: ,p_pmeth_information10_o
430: => pay_opm_shd.g_old_rec.pmeth_information10
431: ,p_pmeth_information11_o
432: => pay_opm_shd.g_old_rec.pmeth_information11
433: ,p_pmeth_information12_o
434: => pay_opm_shd.g_old_rec.pmeth_information12
435: ,p_pmeth_information13_o
436: => pay_opm_shd.g_old_rec.pmeth_information13

Line 434: => pay_opm_shd.g_old_rec.pmeth_information12

430: => pay_opm_shd.g_old_rec.pmeth_information10
431: ,p_pmeth_information11_o
432: => pay_opm_shd.g_old_rec.pmeth_information11
433: ,p_pmeth_information12_o
434: => pay_opm_shd.g_old_rec.pmeth_information12
435: ,p_pmeth_information13_o
436: => pay_opm_shd.g_old_rec.pmeth_information13
437: ,p_pmeth_information14_o
438: => pay_opm_shd.g_old_rec.pmeth_information14

Line 436: => pay_opm_shd.g_old_rec.pmeth_information13

432: => pay_opm_shd.g_old_rec.pmeth_information11
433: ,p_pmeth_information12_o
434: => pay_opm_shd.g_old_rec.pmeth_information12
435: ,p_pmeth_information13_o
436: => pay_opm_shd.g_old_rec.pmeth_information13
437: ,p_pmeth_information14_o
438: => pay_opm_shd.g_old_rec.pmeth_information14
439: ,p_pmeth_information15_o
440: => pay_opm_shd.g_old_rec.pmeth_information15

Line 438: => pay_opm_shd.g_old_rec.pmeth_information14

434: => pay_opm_shd.g_old_rec.pmeth_information12
435: ,p_pmeth_information13_o
436: => pay_opm_shd.g_old_rec.pmeth_information13
437: ,p_pmeth_information14_o
438: => pay_opm_shd.g_old_rec.pmeth_information14
439: ,p_pmeth_information15_o
440: => pay_opm_shd.g_old_rec.pmeth_information15
441: ,p_pmeth_information16_o
442: => pay_opm_shd.g_old_rec.pmeth_information16

Line 440: => pay_opm_shd.g_old_rec.pmeth_information15

436: => pay_opm_shd.g_old_rec.pmeth_information13
437: ,p_pmeth_information14_o
438: => pay_opm_shd.g_old_rec.pmeth_information14
439: ,p_pmeth_information15_o
440: => pay_opm_shd.g_old_rec.pmeth_information15
441: ,p_pmeth_information16_o
442: => pay_opm_shd.g_old_rec.pmeth_information16
443: ,p_pmeth_information17_o
444: => pay_opm_shd.g_old_rec.pmeth_information17

Line 442: => pay_opm_shd.g_old_rec.pmeth_information16

438: => pay_opm_shd.g_old_rec.pmeth_information14
439: ,p_pmeth_information15_o
440: => pay_opm_shd.g_old_rec.pmeth_information15
441: ,p_pmeth_information16_o
442: => pay_opm_shd.g_old_rec.pmeth_information16
443: ,p_pmeth_information17_o
444: => pay_opm_shd.g_old_rec.pmeth_information17
445: ,p_pmeth_information18_o
446: => pay_opm_shd.g_old_rec.pmeth_information18

Line 444: => pay_opm_shd.g_old_rec.pmeth_information17

440: => pay_opm_shd.g_old_rec.pmeth_information15
441: ,p_pmeth_information16_o
442: => pay_opm_shd.g_old_rec.pmeth_information16
443: ,p_pmeth_information17_o
444: => pay_opm_shd.g_old_rec.pmeth_information17
445: ,p_pmeth_information18_o
446: => pay_opm_shd.g_old_rec.pmeth_information18
447: ,p_pmeth_information19_o
448: => pay_opm_shd.g_old_rec.pmeth_information19

Line 446: => pay_opm_shd.g_old_rec.pmeth_information18

442: => pay_opm_shd.g_old_rec.pmeth_information16
443: ,p_pmeth_information17_o
444: => pay_opm_shd.g_old_rec.pmeth_information17
445: ,p_pmeth_information18_o
446: => pay_opm_shd.g_old_rec.pmeth_information18
447: ,p_pmeth_information19_o
448: => pay_opm_shd.g_old_rec.pmeth_information19
449: ,p_pmeth_information20_o
450: => pay_opm_shd.g_old_rec.pmeth_information20

Line 448: => pay_opm_shd.g_old_rec.pmeth_information19

444: => pay_opm_shd.g_old_rec.pmeth_information17
445: ,p_pmeth_information18_o
446: => pay_opm_shd.g_old_rec.pmeth_information18
447: ,p_pmeth_information19_o
448: => pay_opm_shd.g_old_rec.pmeth_information19
449: ,p_pmeth_information20_o
450: => pay_opm_shd.g_old_rec.pmeth_information20
451: ,p_object_version_number_o
452: => pay_opm_shd.g_old_rec.object_version_number

Line 450: => pay_opm_shd.g_old_rec.pmeth_information20

446: => pay_opm_shd.g_old_rec.pmeth_information18
447: ,p_pmeth_information19_o
448: => pay_opm_shd.g_old_rec.pmeth_information19
449: ,p_pmeth_information20_o
450: => pay_opm_shd.g_old_rec.pmeth_information20
451: ,p_object_version_number_o
452: => pay_opm_shd.g_old_rec.object_version_number
453: ,p_transfer_to_gl_flag_o
454: => pay_opm_shd.g_old_rec.transfer_to_gl_flag

Line 452: => pay_opm_shd.g_old_rec.object_version_number

448: => pay_opm_shd.g_old_rec.pmeth_information19
449: ,p_pmeth_information20_o
450: => pay_opm_shd.g_old_rec.pmeth_information20
451: ,p_object_version_number_o
452: => pay_opm_shd.g_old_rec.object_version_number
453: ,p_transfer_to_gl_flag_o
454: => pay_opm_shd.g_old_rec.transfer_to_gl_flag
455: ,p_cost_payment_o
456: => pay_opm_shd.g_old_rec.cost_payment

Line 454: => pay_opm_shd.g_old_rec.transfer_to_gl_flag

450: => pay_opm_shd.g_old_rec.pmeth_information20
451: ,p_object_version_number_o
452: => pay_opm_shd.g_old_rec.object_version_number
453: ,p_transfer_to_gl_flag_o
454: => pay_opm_shd.g_old_rec.transfer_to_gl_flag
455: ,p_cost_payment_o
456: => pay_opm_shd.g_old_rec.cost_payment
457: ,p_cost_cleared_payment_o
458: => pay_opm_shd.g_old_rec.cost_cleared_payment

Line 456: => pay_opm_shd.g_old_rec.cost_payment

452: => pay_opm_shd.g_old_rec.object_version_number
453: ,p_transfer_to_gl_flag_o
454: => pay_opm_shd.g_old_rec.transfer_to_gl_flag
455: ,p_cost_payment_o
456: => pay_opm_shd.g_old_rec.cost_payment
457: ,p_cost_cleared_payment_o
458: => pay_opm_shd.g_old_rec.cost_cleared_payment
459: ,p_cost_cleared_void_payment_o
460: => pay_opm_shd.g_old_rec.cost_cleared_void_payment

Line 458: => pay_opm_shd.g_old_rec.cost_cleared_payment

454: => pay_opm_shd.g_old_rec.transfer_to_gl_flag
455: ,p_cost_payment_o
456: => pay_opm_shd.g_old_rec.cost_payment
457: ,p_cost_cleared_payment_o
458: => pay_opm_shd.g_old_rec.cost_cleared_payment
459: ,p_cost_cleared_void_payment_o
460: => pay_opm_shd.g_old_rec.cost_cleared_void_payment
461: ,p_exclude_manual_payment_o
462: => pay_opm_shd.g_old_rec.exclude_manual_payment

Line 460: => pay_opm_shd.g_old_rec.cost_cleared_void_payment

456: => pay_opm_shd.g_old_rec.cost_payment
457: ,p_cost_cleared_payment_o
458: => pay_opm_shd.g_old_rec.cost_cleared_payment
459: ,p_cost_cleared_void_payment_o
460: => pay_opm_shd.g_old_rec.cost_cleared_void_payment
461: ,p_exclude_manual_payment_o
462: => pay_opm_shd.g_old_rec.exclude_manual_payment
463: );
464: --

Line 462: => pay_opm_shd.g_old_rec.exclude_manual_payment

458: => pay_opm_shd.g_old_rec.cost_cleared_payment
459: ,p_cost_cleared_void_payment_o
460: => pay_opm_shd.g_old_rec.cost_cleared_void_payment
461: ,p_exclude_manual_payment_o
462: => pay_opm_shd.g_old_rec.exclude_manual_payment
463: );
464: --
465: exception
466: --

Line 484: ,p_rec in out nocopy pay_opm_shd.g_rec_type

480: -- ----------------------------------------------------------------------------
481: Procedure del
482: (p_effective_date in date
483: ,p_datetrack_mode in varchar2
484: ,p_rec in out nocopy pay_opm_shd.g_rec_type
485: ) is
486: --
487: l_proc varchar2(72) := g_package||'del';
488: l_validation_start_date date;

Line 500: pay_opm_shd.lck

496: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
497: --
498: -- We must lock the row which we need to delete.
499: --
500: pay_opm_shd.lck
501: (p_effective_date => p_effective_date
502: ,p_datetrack_mode => p_datetrack_mode
503: ,p_org_payment_method_id => p_rec.org_payment_method_id
504: ,p_object_version_number => p_rec.object_version_number

Line 568: l_rec pay_opm_shd.g_rec_type;

564: select opm.business_group_id
565: from pay_org_payment_methods_f opm
566: where opm.org_payment_method_id = p_org_payment_method_id;
567: --
568: l_rec pay_opm_shd.g_rec_type;
569: l_proc varchar2(72) := g_package||'del';
570: --
571: Begin
572: hr_utility.set_location('Entering:'||l_proc, 5);