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.AP_ACCTG_PAY_DIST_PKG dependencies on AP_ACCOUNTING_PAY_PKG

Line 32: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info

28: -- payment history table based on the exchange rates of payment transactions.
29: --
30: --------------------------------------------------------------------------------
31: PROCEDURE Update_Gain_Loss_Ind
32: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
33: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
34: ,P_Calling_Sequence IN VARCHAR2
35: ) IS
36:

Line 33: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info

29: --
30: --------------------------------------------------------------------------------
31: PROCEDURE Update_Gain_Loss_Ind
32: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
33: ,P_Pay_Hist_Rec IN ap_accounting_pay_pkg.r_pay_hist_info
34: ,P_Calling_Sequence IN VARCHAR2
35: ) IS
36:
37: l_curr_calling_sequence VARCHAR2(2000);

Line 262: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info

258: -- distributions of the invoice and generate the payment history distribution.
259: --
260: --------------------------------------------------------------------------------
261: PROCEDURE Primary_Pay_Events
262: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
263: ,P_Calling_Sequence IN VARCHAR2
264: ) IS
265:
266: l_curr_calling_sequence VARCHAR2(2000);

Line 274: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;

270: l_pay_history_id NUMBER;
271: l_mat_history_id NUMBER;
272:
273: l_inv_pay_rec r_inv_pay_info;
274: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
275: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
276: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
277:
278: -- Logging Infra:

Line 275: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;

271: l_mat_history_id NUMBER;
272:
273: l_inv_pay_rec r_inv_pay_info;
274: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
275: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
276: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
277:
278: -- Logging Infra:
279: l_procedure_name CONSTANT VARCHAR2(30) := 'Primary_Pay_Events';

Line 276: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;

272:
273: l_inv_pay_rec r_inv_pay_info;
274: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
275: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
276: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
277:
278: -- Logging Infra:
279: l_procedure_name CONSTANT VARCHAR2(30) := 'Primary_Pay_Events';
280: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 356: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

352: APH.Pmt_To_Base_XRate_Type,
353: APH.Pmt_To_Base_XRate_Date,
354: APH.Pmt_To_Base_XRate
355: INTO l_pay_history_id,
356: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
357: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
358: ap_accounting_pay_pkg.g_pmt_to_base_xrate
359: FROM AP_Payment_History_All APH
360: WHERE APH.Payment_History_ID =

Line 357: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

353: APH.Pmt_To_Base_XRate_Date,
354: APH.Pmt_To_Base_XRate
355: INTO l_pay_history_id,
356: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
357: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
358: ap_accounting_pay_pkg.g_pmt_to_base_xrate
359: FROM AP_Payment_History_All APH
360: WHERE APH.Payment_History_ID =
361: (SELECT MAX(APH1.Payment_History_ID)

Line 358: ap_accounting_pay_pkg.g_pmt_to_base_xrate

354: APH.Pmt_To_Base_XRate
355: INTO l_pay_history_id,
356: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
357: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
358: ap_accounting_pay_pkg.g_pmt_to_base_xrate
359: FROM AP_Payment_History_All APH
360: WHERE APH.Payment_History_ID =
361: (SELECT MAX(APH1.Payment_History_ID)
362: FROM AP_Payment_History_All APH1

Line 369: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_type'

365:
366:
367: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
368: l_log_msg := 'Payment_History_ID for payment = '|| l_pay_history_id
369: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_type'
370: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_type
371: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_date'
372: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_date
373: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate'

Line 370: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_type

366:
367: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
368: l_log_msg := 'Payment_History_ID for payment = '|| l_pay_history_id
369: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_type'
370: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_type
371: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_date'
372: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_date
373: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate'
374: || ap_accounting_pay_pkg.g_pmt_to_base_xrate;

Line 371: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_date'

367: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
368: l_log_msg := 'Payment_History_ID for payment = '|| l_pay_history_id
369: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_type'
370: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_type
371: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_date'
372: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_date
373: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate'
374: || ap_accounting_pay_pkg.g_pmt_to_base_xrate;
375:

Line 372: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_date

368: l_log_msg := 'Payment_History_ID for payment = '|| l_pay_history_id
369: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_type'
370: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_type
371: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_date'
372: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_date
373: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate'
374: || ap_accounting_pay_pkg.g_pmt_to_base_xrate;
375:
376: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 373: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate'

369: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_type'
370: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_type
371: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_date'
372: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_date
373: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate'
374: || ap_accounting_pay_pkg.g_pmt_to_base_xrate;
375:
376: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
377: END IF;

Line 374: || ap_accounting_pay_pkg.g_pmt_to_base_xrate;

370: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_type
371: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate_date'
372: || ap_accounting_pay_pkg.g_pmt_to_base_xrate_date
373: || 'ap_accounting_pay_pkg.g_pmt_to_base_xrate'
374: || ap_accounting_pay_pkg.g_pmt_to_base_xrate;
375:
376: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
377: END IF;
378:

Line 379: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;

375:
376: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
377: END IF;
378:
379: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
380:
381: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;
382: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
383: l_pay_hist_rec.pmt_to_base_xrate_type;

Line 381: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;

377: END IF;
378:
379: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
380:
381: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;
382: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
383: l_pay_hist_rec.pmt_to_base_xrate_type;
384: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=
385: l_pay_hist_rec.pmt_to_base_xrate_date;

Line 382: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=

378:
379: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
380:
381: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;
382: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
383: l_pay_hist_rec.pmt_to_base_xrate_type;
384: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=
385: l_pay_hist_rec.pmt_to_base_xrate_date;
386: ap_accounting_pay_pkg.g_mat_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

Line 384: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=

380:
381: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;
382: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
383: l_pay_hist_rec.pmt_to_base_xrate_type;
384: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=
385: l_pay_hist_rec.pmt_to_base_xrate_date;
386: ap_accounting_pay_pkg.g_mat_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
387:
388: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 386: ap_accounting_pay_pkg.g_mat_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

382: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
383: l_pay_hist_rec.pmt_to_base_xrate_type;
384: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=
385: l_pay_hist_rec.pmt_to_base_xrate_date;
386: ap_accounting_pay_pkg.g_mat_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
387:
388: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
389: l_log_msg := 'After assign maturity related global variables and ' ||
390: 'ap_accounting_pay_pkg.g_pay_pmt_history_id '||

Line 390: 'ap_accounting_pay_pkg.g_pay_pmt_history_id '||

386: ap_accounting_pay_pkg.g_mat_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
387:
388: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
389: l_log_msg := 'After assign maturity related global variables and ' ||
390: 'ap_accounting_pay_pkg.g_pay_pmt_history_id '||
391: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
392: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_type' ||
393: ap_accounting_pay_pkg.g_mat_to_base_xrate_type ||
394: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_date' ||

Line 391: ap_accounting_pay_pkg.g_pay_pmt_history_id ||

387:
388: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
389: l_log_msg := 'After assign maturity related global variables and ' ||
390: 'ap_accounting_pay_pkg.g_pay_pmt_history_id '||
391: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
392: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_type' ||
393: ap_accounting_pay_pkg.g_mat_to_base_xrate_type ||
394: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_date' ||
395: ap_accounting_pay_pkg.g_mat_to_base_xrate_date ||

Line 392: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_type' ||

388: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
389: l_log_msg := 'After assign maturity related global variables and ' ||
390: 'ap_accounting_pay_pkg.g_pay_pmt_history_id '||
391: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
392: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_type' ||
393: ap_accounting_pay_pkg.g_mat_to_base_xrate_type ||
394: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_date' ||
395: ap_accounting_pay_pkg.g_mat_to_base_xrate_date ||
396: 'ap_accounting_pay_pkg.g_mat_to_base_xrate' ||

Line 393: ap_accounting_pay_pkg.g_mat_to_base_xrate_type ||

389: l_log_msg := 'After assign maturity related global variables and ' ||
390: 'ap_accounting_pay_pkg.g_pay_pmt_history_id '||
391: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
392: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_type' ||
393: ap_accounting_pay_pkg.g_mat_to_base_xrate_type ||
394: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_date' ||
395: ap_accounting_pay_pkg.g_mat_to_base_xrate_date ||
396: 'ap_accounting_pay_pkg.g_mat_to_base_xrate' ||
397: ap_accounting_pay_pkg.g_mat_to_base_xrate;

Line 394: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_date' ||

390: 'ap_accounting_pay_pkg.g_pay_pmt_history_id '||
391: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
392: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_type' ||
393: ap_accounting_pay_pkg.g_mat_to_base_xrate_type ||
394: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_date' ||
395: ap_accounting_pay_pkg.g_mat_to_base_xrate_date ||
396: 'ap_accounting_pay_pkg.g_mat_to_base_xrate' ||
397: ap_accounting_pay_pkg.g_mat_to_base_xrate;
398:

Line 395: ap_accounting_pay_pkg.g_mat_to_base_xrate_date ||

391: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
392: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_type' ||
393: ap_accounting_pay_pkg.g_mat_to_base_xrate_type ||
394: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_date' ||
395: ap_accounting_pay_pkg.g_mat_to_base_xrate_date ||
396: 'ap_accounting_pay_pkg.g_mat_to_base_xrate' ||
397: ap_accounting_pay_pkg.g_mat_to_base_xrate;
398:
399: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 396: 'ap_accounting_pay_pkg.g_mat_to_base_xrate' ||

392: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_type' ||
393: ap_accounting_pay_pkg.g_mat_to_base_xrate_type ||
394: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_date' ||
395: ap_accounting_pay_pkg.g_mat_to_base_xrate_date ||
396: 'ap_accounting_pay_pkg.g_mat_to_base_xrate' ||
397: ap_accounting_pay_pkg.g_mat_to_base_xrate;
398:
399: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
400: END IF;

Line 397: ap_accounting_pay_pkg.g_mat_to_base_xrate;

393: ap_accounting_pay_pkg.g_mat_to_base_xrate_type ||
394: 'ap_accounting_pay_pkg.g_mat_to_base_xrate_date' ||
395: ap_accounting_pay_pkg.g_mat_to_base_xrate_date ||
396: 'ap_accounting_pay_pkg.g_mat_to_base_xrate' ||
397: ap_accounting_pay_pkg.g_mat_to_base_xrate;
398:
399: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
400: END IF;
401:

Line 415: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

411: APH.Pmt_To_Base_XRate_Type,
412: APH.Pmt_To_Base_XRate_Date,
413: APH.Pmt_To_Base_XRate
414: INTO l_pay_history_id,
415: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
416: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
417: ap_accounting_pay_pkg.g_pmt_to_base_xrate
418: FROM AP_Payment_History_All APH
419: WHERE APH.Payment_History_ID =

Line 416: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

412: APH.Pmt_To_Base_XRate_Date,
413: APH.Pmt_To_Base_XRate
414: INTO l_pay_history_id,
415: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
416: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
417: ap_accounting_pay_pkg.g_pmt_to_base_xrate
418: FROM AP_Payment_History_All APH
419: WHERE APH.Payment_History_ID =
420: (SELECT MAX(APH1.Payment_History_ID)

Line 417: ap_accounting_pay_pkg.g_pmt_to_base_xrate

413: APH.Pmt_To_Base_XRate
414: INTO l_pay_history_id,
415: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
416: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
417: ap_accounting_pay_pkg.g_pmt_to_base_xrate
418: FROM AP_Payment_History_All APH
419: WHERE APH.Payment_History_ID =
420: (SELECT MAX(APH1.Payment_History_ID)
421: FROM AP_Payment_History_All APH1

Line 445: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,

441:
442: SELECT APH.Pmt_To_Base_XRate_Type,
443: APH.Pmt_To_Base_XRate_Date,
444: APH.Pmt_To_Base_XRate
445: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
446: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
447: ap_accounting_pay_pkg.g_mat_to_base_xrate
448: FROM AP_Payment_History_All APH
449: WHERE APH.Payment_History_ID = l_mat_history_id;

Line 446: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,

442: SELECT APH.Pmt_To_Base_XRate_Type,
443: APH.Pmt_To_Base_XRate_Date,
444: APH.Pmt_To_Base_XRate
445: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
446: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
447: ap_accounting_pay_pkg.g_mat_to_base_xrate
448: FROM AP_Payment_History_All APH
449: WHERE APH.Payment_History_ID = l_mat_history_id;
450:

Line 447: ap_accounting_pay_pkg.g_mat_to_base_xrate

443: APH.Pmt_To_Base_XRate_Date,
444: APH.Pmt_To_Base_XRate
445: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
446: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
447: ap_accounting_pay_pkg.g_mat_to_base_xrate
448: FROM AP_Payment_History_All APH
449: WHERE APH.Payment_History_ID = l_mat_history_id;
450:
451: END IF;

Line 454: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;

450:
451: END IF;
452:
453:
454: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
455: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;
456:
457: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
458: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=

Line 455: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;

451: END IF;
452:
453:
454: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
455: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;
456:
457: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
458: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
459: l_pay_hist_rec.pmt_to_base_xrate_type;

Line 457: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;

453:
454: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
455: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;
456:
457: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
458: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
459: l_pay_hist_rec.pmt_to_base_xrate_type;
460: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=
461: l_pay_hist_rec.pmt_to_base_xrate_date;

Line 458: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=

454: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
455: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;
456:
457: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
458: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
459: l_pay_hist_rec.pmt_to_base_xrate_type;
460: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=
461: l_pay_hist_rec.pmt_to_base_xrate_date;
462: ap_accounting_pay_pkg.g_clr_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

Line 460: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=

456:
457: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
458: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
459: l_pay_hist_rec.pmt_to_base_xrate_type;
460: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=
461: l_pay_hist_rec.pmt_to_base_xrate_date;
462: ap_accounting_pay_pkg.g_clr_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
463:
464:

Line 462: ap_accounting_pay_pkg.g_clr_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

458: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
459: l_pay_hist_rec.pmt_to_base_xrate_type;
460: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=
461: l_pay_hist_rec.pmt_to_base_xrate_date;
462: ap_accounting_pay_pkg.g_clr_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
463:
464:
465: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
466: l_log_msg := 'after set clearing global varaiables, they are'||

Line 467: 'ap_accounting_pay_pkg.g_pay_pmt_history_id=' ||

463:
464:
465: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
466: l_log_msg := 'after set clearing global varaiables, they are'||
467: 'ap_accounting_pay_pkg.g_pay_pmt_history_id=' ||
468: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
469: 'ap_accounting_pay_pkg.g_mat_pmt_history_id =' ||
470: ap_accounting_pay_pkg.g_mat_pmt_history_id ||
471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||

Line 468: ap_accounting_pay_pkg.g_pay_pmt_history_id ||

464:
465: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
466: l_log_msg := 'after set clearing global varaiables, they are'||
467: 'ap_accounting_pay_pkg.g_pay_pmt_history_id=' ||
468: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
469: 'ap_accounting_pay_pkg.g_mat_pmt_history_id =' ||
470: ap_accounting_pay_pkg.g_mat_pmt_history_id ||
471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||
472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||

Line 469: 'ap_accounting_pay_pkg.g_mat_pmt_history_id =' ||

465: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
466: l_log_msg := 'after set clearing global varaiables, they are'||
467: 'ap_accounting_pay_pkg.g_pay_pmt_history_id=' ||
468: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
469: 'ap_accounting_pay_pkg.g_mat_pmt_history_id =' ||
470: ap_accounting_pay_pkg.g_mat_pmt_history_id ||
471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||
472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||
473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||

Line 470: ap_accounting_pay_pkg.g_mat_pmt_history_id ||

466: l_log_msg := 'after set clearing global varaiables, they are'||
467: 'ap_accounting_pay_pkg.g_pay_pmt_history_id=' ||
468: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
469: 'ap_accounting_pay_pkg.g_mat_pmt_history_id =' ||
470: ap_accounting_pay_pkg.g_mat_pmt_history_id ||
471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||
472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||
473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||
474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||

Line 471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||

467: 'ap_accounting_pay_pkg.g_pay_pmt_history_id=' ||
468: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
469: 'ap_accounting_pay_pkg.g_mat_pmt_history_id =' ||
470: ap_accounting_pay_pkg.g_mat_pmt_history_id ||
471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||
472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||
473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||
474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||
475: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_date=' ||

Line 472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||

468: ap_accounting_pay_pkg.g_pay_pmt_history_id ||
469: 'ap_accounting_pay_pkg.g_mat_pmt_history_id =' ||
470: ap_accounting_pay_pkg.g_mat_pmt_history_id ||
471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||
472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||
473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||
474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||
475: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_date=' ||
476: ap_accounting_pay_pkg.g_clr_to_base_xrate_date ||

Line 473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||

469: 'ap_accounting_pay_pkg.g_mat_pmt_history_id =' ||
470: ap_accounting_pay_pkg.g_mat_pmt_history_id ||
471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||
472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||
473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||
474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||
475: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_date=' ||
476: ap_accounting_pay_pkg.g_clr_to_base_xrate_date ||
477: 'ap_accounting_pay_pkg.g_clr_to_base_xrate=' ||

Line 474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||

470: ap_accounting_pay_pkg.g_mat_pmt_history_id ||
471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||
472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||
473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||
474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||
475: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_date=' ||
476: ap_accounting_pay_pkg.g_clr_to_base_xrate_date ||
477: 'ap_accounting_pay_pkg.g_clr_to_base_xrate=' ||
478: ap_accounting_pay_pkg.g_clr_to_base_xrate;

Line 475: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_date=' ||

471: ' ap_accounting_pay_pkg.g_clr_pmt_history_id =' ||
472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||
473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||
474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||
475: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_date=' ||
476: ap_accounting_pay_pkg.g_clr_to_base_xrate_date ||
477: 'ap_accounting_pay_pkg.g_clr_to_base_xrate=' ||
478: ap_accounting_pay_pkg.g_clr_to_base_xrate;
479:

Line 476: ap_accounting_pay_pkg.g_clr_to_base_xrate_date ||

472: ap_accounting_pay_pkg.g_clr_pmt_history_id ||
473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||
474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||
475: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_date=' ||
476: ap_accounting_pay_pkg.g_clr_to_base_xrate_date ||
477: 'ap_accounting_pay_pkg.g_clr_to_base_xrate=' ||
478: ap_accounting_pay_pkg.g_clr_to_base_xrate;
479:
480: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);

Line 477: 'ap_accounting_pay_pkg.g_clr_to_base_xrate=' ||

473: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_type=' ||
474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||
475: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_date=' ||
476: ap_accounting_pay_pkg.g_clr_to_base_xrate_date ||
477: 'ap_accounting_pay_pkg.g_clr_to_base_xrate=' ||
478: ap_accounting_pay_pkg.g_clr_to_base_xrate;
479:
480: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
481: END IF;

Line 478: ap_accounting_pay_pkg.g_clr_to_base_xrate;

474: ap_accounting_pay_pkg.g_clr_to_base_xrate_type ||
475: 'ap_accounting_pay_pkg.g_clr_to_base_xrate_date=' ||
476: ap_accounting_pay_pkg.g_clr_to_base_xrate_date ||
477: 'ap_accounting_pay_pkg.g_clr_to_base_xrate=' ||
478: ap_accounting_pay_pkg.g_clr_to_base_xrate;
479:
480: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
481: END IF;
482:

Line 491: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_hist_rec.payment_history_id;

487: P_XLA_Event_Rec.Event_Type_Code;
488: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
489: END IF;
490:
491: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_hist_rec.payment_history_id;
492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=
493: l_pay_hist_rec.pmt_to_base_xrate_type;
494: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=
495: l_pay_hist_rec.pmt_to_base_xrate_date;

Line 492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=

488: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
489: END IF;
490:
491: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_hist_rec.payment_history_id;
492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=
493: l_pay_hist_rec.pmt_to_base_xrate_type;
494: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=
495: l_pay_hist_rec.pmt_to_base_xrate_date;
496: ap_accounting_pay_pkg.g_pmt_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

Line 494: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=

490:
491: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_hist_rec.payment_history_id;
492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=
493: l_pay_hist_rec.pmt_to_base_xrate_type;
494: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=
495: l_pay_hist_rec.pmt_to_base_xrate_date;
496: ap_accounting_pay_pkg.g_pmt_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
497:
498: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 496: ap_accounting_pay_pkg.g_pmt_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=
493: l_pay_hist_rec.pmt_to_base_xrate_type;
494: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=
495: l_pay_hist_rec.pmt_to_base_xrate_date;
496: ap_accounting_pay_pkg.g_pmt_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
497:
498: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
499: l_log_msg := 'Payment_History_ID for payment = '||
500: l_pay_hist_rec.payment_history_id;

Line 596: l_final_payment := AP_Accounting_Pay_Pkg.Is_Final_Payment

592: AND Rownum = 1);
593:
594: IF l_upg_inv_pmts = 0 THEN
595: /* Check if the invoice is fully paid */
596: l_final_payment := AP_Accounting_Pay_Pkg.Is_Final_Payment
597: (l_inv_rec,
598: l_inv_pay_rec.amount,
599: l_inv_pay_rec.discount_taken,
600: 0, -- prepay amount

Line 868: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info

864: -- generate the payment history distribution.
865: --
866: --------------------------------------------------------------------------------
867: PROCEDURE Manual_Pay_Adj_Events
868: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
869: ,P_Calling_Sequence IN VARCHAR2
870: ) IS
871:
872: l_curr_calling_sequence VARCHAR2(2000);

Line 877: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;

873: l_total_paid_amt NUMBER;
874: l_final_payment BOOLEAN := FALSE;
875:
876: l_inv_pay_rec r_inv_pay_info;
877: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
878: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
879: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
880:
881: -- Logging Infra:

Line 878: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;

874: l_final_payment BOOLEAN := FALSE;
875:
876: l_inv_pay_rec r_inv_pay_info;
877: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
878: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
879: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
880:
881: -- Logging Infra:
882: l_procedure_name CONSTANT VARCHAR2(30) := 'Manual_Pay_Adj_Events';

Line 879: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;

875:
876: l_inv_pay_rec r_inv_pay_info;
877: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
878: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
879: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
880:
881: -- Logging Infra:
882: l_procedure_name CONSTANT VARCHAR2(30) := 'Manual_Pay_Adj_Events';
883: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 967: l_final_payment := AP_Accounting_Pay_Pkg.Is_Final_Payment

963: END IF;
964:
965:
966: /* Check if the invoice is fully paid */
967: l_final_payment := AP_Accounting_Pay_Pkg.Is_Final_Payment
968: (l_inv_rec,
969: l_inv_pay_rec.amount,
970: l_inv_pay_rec.discount_taken,
971: 0, -- prepay amount

Line 1175: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info

1171: -- unmatured and insert into the payment hist distribution table.
1172: --
1173: --------------------------------------------------------------------------------
1174: PROCEDURE Cancel_Primary_Pay_Events
1175: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
1176: ,P_Calling_Sequence IN VARCHAR2
1177: ) IS
1178:
1179: l_curr_calling_sequence VARCHAR2(2000);

Line 1181: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;

1177: ) IS
1178:
1179: l_curr_calling_sequence VARCHAR2(2000);
1180:
1181: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1182:
1183: -- Logging Infra:
1184: l_procedure_name CONSTANT VARCHAR2(30) := 'Cancel_Primary_Pay_Events';
1185: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

Line 1274: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info

1270: -- payment history distribution.
1271: --
1272: --------------------------------------------------------------------------------
1273: PROCEDURE Pay_Dist_Cascade_Adj_Events
1274: (P_XLA_Event_Rec IN ap_accounting_pay_pkg.r_xla_event_info
1275: ,P_Calling_Sequence IN VARCHAR2
1276: ) IS
1277:
1278: l_curr_calling_sequence VARCHAR2(2000);

Line 1290: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;

1286: l_pay_history_id NUMBER;
1287: l_mat_history_id NUMBER;
1288:
1289: l_inv_pay_rec r_inv_pay_info;
1290: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1291: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1292: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
1293:
1294: l_pay_dist_cnt NUMBER;

Line 1291: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;

1287: l_mat_history_id NUMBER;
1288:
1289: l_inv_pay_rec r_inv_pay_info;
1290: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1291: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1292: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
1293:
1294: l_pay_dist_cnt NUMBER;
1295: l_do_round NUMBER; --7454170 contains payment_history_id

Line 1292: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;

1288:
1289: l_inv_pay_rec r_inv_pay_info;
1290: l_pay_hist_rec ap_accounting_pay_pkg.r_pay_hist_info;
1291: l_inv_rec ap_accounting_pay_pkg.r_invoices_info;
1292: l_inv_dist_rec ap_accounting_pay_pkg.r_inv_dist_info;
1293:
1294: l_pay_dist_cnt NUMBER;
1295: l_do_round NUMBER; --7454170 contains payment_history_id
1296:

Line 1395: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

1391:
1392: SELECT APH.Pmt_To_Base_XRate_Type,
1393: APH.Pmt_To_Base_XRate_Date,
1394: APH.Pmt_To_Base_XRate
1395: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1396: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1397: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1398: FROM AP_Payment_History_All APH
1399: WHERE APH.Payment_History_ID = l_pay_history_id;

Line 1396: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

1392: SELECT APH.Pmt_To_Base_XRate_Type,
1393: APH.Pmt_To_Base_XRate_Date,
1394: APH.Pmt_To_Base_XRate
1395: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1396: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1397: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1398: FROM AP_Payment_History_All APH
1399: WHERE APH.Payment_History_ID = l_pay_history_id;
1400:

Line 1397: ap_accounting_pay_pkg.g_pmt_to_base_xrate

1393: APH.Pmt_To_Base_XRate_Date,
1394: APH.Pmt_To_Base_XRate
1395: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1396: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1397: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1398: FROM AP_Payment_History_All APH
1399: WHERE APH.Payment_History_ID = l_pay_history_id;
1400:
1401: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1407: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;

1403: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1404: END IF;
1405:
1406:
1407: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
1408:
1409: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;
1410: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
1411: l_pay_hist_rec.pmt_to_base_xrate_type;

Line 1409: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;

1405:
1406:
1407: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
1408:
1409: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;
1410: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
1411: l_pay_hist_rec.pmt_to_base_xrate_type;
1412: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=
1413: l_pay_hist_rec.pmt_to_base_xrate_date;

Line 1410: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=

1406:
1407: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
1408:
1409: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;
1410: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
1411: l_pay_hist_rec.pmt_to_base_xrate_type;
1412: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=
1413: l_pay_hist_rec.pmt_to_base_xrate_date;
1414: ap_accounting_pay_pkg.g_mat_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

Line 1412: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=

1408:
1409: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_pay_hist_rec.payment_history_id;
1410: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
1411: l_pay_hist_rec.pmt_to_base_xrate_type;
1412: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=
1413: l_pay_hist_rec.pmt_to_base_xrate_date;
1414: ap_accounting_pay_pkg.g_mat_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
1415:
1416: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1414: ap_accounting_pay_pkg.g_mat_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

1410: ap_accounting_pay_pkg.g_mat_to_base_xrate_type :=
1411: l_pay_hist_rec.pmt_to_base_xrate_type;
1412: ap_accounting_pay_pkg.g_mat_to_base_xrate_date :=
1413: l_pay_hist_rec.pmt_to_base_xrate_date;
1414: ap_accounting_pay_pkg.g_mat_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
1415:
1416: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1417: l_log_msg := 'Payment_History_ID for maturity = '||
1418: l_pay_hist_rec.payment_history_id;

Line 1434: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

1430:
1431: SELECT APH.Pmt_To_Base_XRate_Type,
1432: APH.Pmt_To_Base_XRate_Date,
1433: APH.Pmt_To_Base_XRate
1434: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1435: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1436: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1437: FROM AP_Payment_History_All APH
1438: WHERE APH.Payment_History_ID = l_pay_history_id;

Line 1435: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

1431: SELECT APH.Pmt_To_Base_XRate_Type,
1432: APH.Pmt_To_Base_XRate_Date,
1433: APH.Pmt_To_Base_XRate
1434: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1435: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1436: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1437: FROM AP_Payment_History_All APH
1438: WHERE APH.Payment_History_ID = l_pay_history_id;
1439:

Line 1436: ap_accounting_pay_pkg.g_pmt_to_base_xrate

1432: APH.Pmt_To_Base_XRate_Date,
1433: APH.Pmt_To_Base_XRate
1434: INTO ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
1435: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
1436: ap_accounting_pay_pkg.g_pmt_to_base_xrate
1437: FROM AP_Payment_History_All APH
1438: WHERE APH.Payment_History_ID = l_pay_history_id;
1439:
1440: SELECT MAX(APH.Payment_History_ID)

Line 1452: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,

1448:
1449: SELECT APH.Pmt_To_Base_XRate_Type,
1450: APH.Pmt_To_Base_XRate_Date,
1451: APH.Pmt_To_Base_XRate
1452: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
1453: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
1454: ap_accounting_pay_pkg.g_mat_to_base_xrate
1455: FROM AP_Payment_History_All APH
1456: WHERE APH.Payment_History_ID = l_mat_history_id;

Line 1453: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,

1449: SELECT APH.Pmt_To_Base_XRate_Type,
1450: APH.Pmt_To_Base_XRate_Date,
1451: APH.Pmt_To_Base_XRate
1452: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
1453: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
1454: ap_accounting_pay_pkg.g_mat_to_base_xrate
1455: FROM AP_Payment_History_All APH
1456: WHERE APH.Payment_History_ID = l_mat_history_id;
1457:

Line 1454: ap_accounting_pay_pkg.g_mat_to_base_xrate

1450: APH.Pmt_To_Base_XRate_Date,
1451: APH.Pmt_To_Base_XRate
1452: INTO ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
1453: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
1454: ap_accounting_pay_pkg.g_mat_to_base_xrate
1455: FROM AP_Payment_History_All APH
1456: WHERE APH.Payment_History_ID = l_mat_history_id;
1457:
1458: END IF;

Line 1471: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;

1467: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
1468: END IF;
1469:
1470:
1471: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
1472: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;
1473:
1474: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
1475: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=

Line 1472: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;

1468: END IF;
1469:
1470:
1471: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
1472: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;
1473:
1474: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
1475: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
1476: l_pay_hist_rec.pmt_to_base_xrate_type;

Line 1474: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;

1470:
1471: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
1472: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;
1473:
1474: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
1475: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
1476: l_pay_hist_rec.pmt_to_base_xrate_type;
1477: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=
1478: l_pay_hist_rec.pmt_to_base_xrate_date;

Line 1475: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=

1471: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_history_id;
1472: ap_accounting_pay_pkg.g_mat_pmt_history_id := l_mat_history_id;
1473:
1474: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
1475: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
1476: l_pay_hist_rec.pmt_to_base_xrate_type;
1477: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=
1478: l_pay_hist_rec.pmt_to_base_xrate_date;
1479: ap_accounting_pay_pkg.g_clr_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

Line 1477: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=

1473:
1474: ap_accounting_pay_pkg.g_clr_pmt_history_id := l_pay_hist_rec.payment_history_id;
1475: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
1476: l_pay_hist_rec.pmt_to_base_xrate_type;
1477: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=
1478: l_pay_hist_rec.pmt_to_base_xrate_date;
1479: ap_accounting_pay_pkg.g_clr_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
1480:
1481: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1479: ap_accounting_pay_pkg.g_clr_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

1475: ap_accounting_pay_pkg.g_clr_to_base_xrate_type :=
1476: l_pay_hist_rec.pmt_to_base_xrate_type;
1477: ap_accounting_pay_pkg.g_clr_to_base_xrate_date :=
1478: l_pay_hist_rec.pmt_to_base_xrate_date;
1479: ap_accounting_pay_pkg.g_clr_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
1480:
1481: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1482: l_log_msg := 'Payment_History_ID for clearing = '||
1483: l_pay_hist_rec.payment_history_id;

Line 1489: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_hist_rec.payment_history_id;

1485: END IF;
1486:
1487: ELSE
1488:
1489: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_hist_rec.payment_history_id;
1490: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=
1491: l_pay_hist_rec.pmt_to_base_xrate_type;
1492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=
1493: l_pay_hist_rec.pmt_to_base_xrate_date;

Line 1490: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=

1486:
1487: ELSE
1488:
1489: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_hist_rec.payment_history_id;
1490: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=
1491: l_pay_hist_rec.pmt_to_base_xrate_type;
1492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=
1493: l_pay_hist_rec.pmt_to_base_xrate_date;
1494: ap_accounting_pay_pkg.g_pmt_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

Line 1492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=

1488:
1489: ap_accounting_pay_pkg.g_pay_pmt_history_id := l_pay_hist_rec.payment_history_id;
1490: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=
1491: l_pay_hist_rec.pmt_to_base_xrate_type;
1492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=
1493: l_pay_hist_rec.pmt_to_base_xrate_date;
1494: ap_accounting_pay_pkg.g_pmt_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
1495:
1496: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 1494: ap_accounting_pay_pkg.g_pmt_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;

1490: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type :=
1491: l_pay_hist_rec.pmt_to_base_xrate_type;
1492: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date :=
1493: l_pay_hist_rec.pmt_to_base_xrate_date;
1494: ap_accounting_pay_pkg.g_pmt_to_base_xrate := l_pay_hist_rec.pmt_to_base_xrate;
1495:
1496: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1497: l_log_msg := 'Payment_History_ID for payment = '||
1498: l_pay_hist_rec.payment_history_id;

Line 1996: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info

1992: -- Also calculates discounts and ERV
1993: ---------------------------------------------------------------------
1994:
1995: PROCEDURE Pay_Dist_Proc
1996: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
1997: ,p_inv_pay_rec IN r_inv_pay_info
1998: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1999: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2000: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

Line 1998: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

1994:
1995: PROCEDURE Pay_Dist_Proc
1996: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
1997: ,p_inv_pay_rec IN r_inv_pay_info
1998: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1999: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2000: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2001: ,p_calc_mode IN VARCHAR2
2002: ,p_final_payment IN BOOLEAN

Line 1999: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info

1995: PROCEDURE Pay_Dist_Proc
1996: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
1997: ,p_inv_pay_rec IN r_inv_pay_info
1998: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1999: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2000: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2001: ,p_calc_mode IN VARCHAR2
2002: ,p_final_payment IN BOOLEAN
2003: ,p_calling_sequence IN VARCHAR2

Line 2000: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

1996: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
1997: ,p_inv_pay_rec IN r_inv_pay_info
1998: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
1999: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2000: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2001: ,p_calc_mode IN VARCHAR2
2002: ,p_final_payment IN BOOLEAN
2003: ,p_calling_sequence IN VARCHAR2
2004: ) IS

Line 2294: l_log_msg := 'This is a final payment and now calling AP_Accounting_Pay_Pkg.Get_Pay_Sum';

2290:
2291: IF p_final_payment = TRUE THEN
2292:
2293: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2294: l_log_msg := 'This is a final payment and now calling AP_Accounting_Pay_Pkg.Get_Pay_Sum';
2295: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
2296: END IF;
2297:
2298: AP_Accounting_Pay_Pkg.Get_Pay_Sum

Line 2298: AP_Accounting_Pay_Pkg.Get_Pay_Sum

2294: l_log_msg := 'This is a final payment and now calling AP_Accounting_Pay_Pkg.Get_Pay_Sum';
2295: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
2296: END IF;
2297:
2298: AP_Accounting_Pay_Pkg.Get_Pay_Sum
2299: (p_inv_dist_rec.invoice_distribution_id,
2300: p_xla_event_rec.event_type_code,
2301: l_total_paid_amt,
2302: l_tot_paid_amt_inv_curr,

Line 2307: l_log_msg := 'After Calling function AP_Accounting_Pay_Pkg.Get_Pay_Sum' ||

2303: l_tot_paid_amt_bank_curr,
2304: l_curr_calling_sequence);
2305:
2306: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2307: l_log_msg := 'After Calling function AP_Accounting_Pay_Pkg.Get_Pay_Sum' ||
2308: 'l_total_paid_amt==' || nvl(l_total_paid_amt,0) ||
2309: 'l_tot_paid_amt_inv_curr=' || nvl(l_tot_paid_amt_inv_curr,0) ||
2310: 'l_tot_paid_amt_bank_curr =' || nvl(l_tot_paid_amt_bank_curr,0);
2311: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);

Line 2315: l_total_prepaid_amt := AP_Accounting_Pay_Pkg.Get_Prepay_Sum

2311: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
2312: END IF;
2313:
2314:
2315: l_total_prepaid_amt := AP_Accounting_Pay_Pkg.Get_Prepay_Sum
2316: (p_inv_dist_rec.invoice_distribution_id,
2317: l_curr_calling_sequence);
2318:
2319: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN

Line 2566: AP_Accounting_Pay_Pkg.get_casc_pay_sum

2562: p_inv_rec.payment_currency_code,
2563: p_inv_rec.payment_cross_rate_date,
2564: 'EMU FIXED',
2565: p_inv_dist_rec.amount) -
2566: AP_Accounting_Pay_Pkg.get_casc_pay_sum
2567: (p_inv_dist_rec.invoice_distribution_id,
2568: p_pay_hist_rec.related_event_id,
2569: p_inv_pay_rec.invoice_payment_id,
2570: l_curr_calling_sequence);

Line 2573: AP_Accounting_Pay_Pkg.get_casc_inv_dist_sum

2569: p_inv_pay_rec.invoice_payment_id,
2570: l_curr_calling_sequence);
2571:
2572: l_inv_dist_amount := p_inv_dist_rec.amount -
2573: AP_Accounting_Pay_Pkg.get_casc_inv_dist_sum
2574: (p_inv_dist_rec.invoice_distribution_id,
2575: p_pay_hist_rec.related_event_id,
2576: p_inv_pay_rec.invoice_payment_id,
2577: l_curr_calling_sequence);

Line 2586: AP_Accounting_Pay_Pkg.get_casc_bank_curr_sum(

2582: l_bank_curr_amount := AP_Utilities_Pkg.AP_Round_Currency(
2583: l_prorated_amount * p_pay_hist_rec.pmt_to_base_xrate
2584: /p_pay_hist_rec.bank_to_base_xrate,
2585: p_pay_hist_rec.bank_currency_code) -
2586: AP_Accounting_Pay_Pkg.get_casc_bank_curr_sum(
2587: p_inv_dist_rec.invoice_distribution_id,
2588: p_pay_hist_rec.related_event_id,
2589: p_inv_pay_rec.invoice_payment_id,
2590: l_curr_calling_sequence);

Line 2595: AP_Accounting_Pay_Pkg.get_casc_bank_curr_sum(

2591:
2592: ELSE
2593:
2594: l_bank_curr_amount := l_prorated_amount -
2595: AP_Accounting_Pay_Pkg.get_casc_bank_curr_sum(
2596: p_inv_dist_rec.invoice_distribution_id,
2597: p_pay_hist_rec.related_event_id,
2598: p_inv_pay_rec.invoice_payment_id,
2599: l_curr_calling_sequence);

Line 2611: - AP_Accounting_Pay_Pkg.get_casc_pay_sum

2607: -- give us the amount that needs to be adjusted
2608: l_prorated_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2609: (((p_inv_dist_rec.amount * p_inv_pay_rec.amount)
2610: / l_proration_divisor)
2611: - AP_Accounting_Pay_Pkg.get_casc_pay_sum
2612: (p_inv_dist_rec.invoice_distribution_id,
2613: p_pay_hist_rec.related_event_id,
2614: p_inv_pay_rec.invoice_payment_id,
2615: l_curr_calling_sequence),

Line 2621: - AP_Accounting_Pay_Pkg.get_casc_inv_dist_sum

2617:
2618: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2619: (((p_inv_dist_rec.amount * l_pay_amount_inv_curr)
2620: / l_proration_divisor)
2621: - AP_Accounting_Pay_Pkg.get_casc_inv_dist_sum
2622: (p_inv_dist_rec.invoice_distribution_id,
2623: p_pay_hist_rec.related_event_id,
2624: p_inv_pay_rec.invoice_payment_id,
2625: l_curr_calling_sequence),

Line 2633: - AP_Accounting_Pay_Pkg.get_casc_bank_curr_sum

2629:
2630: l_bank_curr_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
2631: (((p_inv_dist_rec.amount * l_pay_amount_bank_curr)
2632: / l_proration_divisor)
2633: - AP_Accounting_Pay_Pkg.get_casc_bank_curr_sum
2634: (p_inv_dist_rec.invoice_distribution_id,
2635: p_pay_hist_rec.related_event_id,
2636: p_inv_pay_rec.invoice_payment_id,
2637: l_curr_calling_sequence),

Line 2652: l_log_msg := 'Now calling AP_Accounting_Pay_Pkg.Get_Base_Amount before insert';

2648: END IF;
2649: END IF; -- If calc_mode in ('P','M')
2650:
2651: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2652: l_log_msg := 'Now calling AP_Accounting_Pay_Pkg.Get_Base_Amount before insert';
2653: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
2654: END IF;
2655:
2656: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

Line 2656: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

2652: l_log_msg := 'Now calling AP_Accounting_Pay_Pkg.Get_Base_Amount before insert';
2653: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
2654: END IF;
2655:
2656: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2657: (l_prorated_amount,
2658: p_pay_hist_rec.pmt_currency_code,
2659: ap_accounting_pay_pkg.g_base_currency_code,
2660: p_pay_hist_rec.pmt_to_base_xrate_type,

Line 2659: ap_accounting_pay_pkg.g_base_currency_code,

2655:
2656: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2657: (l_prorated_amount,
2658: p_pay_hist_rec.pmt_currency_code,
2659: ap_accounting_pay_pkg.g_base_currency_code,
2660: p_pay_hist_rec.pmt_to_base_xrate_type,
2661: p_pay_hist_rec.pmt_to_base_xrate_date,
2662: p_pay_hist_rec.pmt_to_base_xrate,
2663: l_curr_calling_sequence);

Line 2666: l_log_msg := 'after call AP_Accounting_Pay_Pkg.Get_Base_Amoun and ' ||

2662: p_pay_hist_rec.pmt_to_base_xrate,
2663: l_curr_calling_sequence);
2664:
2665: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2666: l_log_msg := 'after call AP_Accounting_Pay_Pkg.Get_Base_Amoun and ' ||
2667: 'l_prorated_base_amount=' || nvl(l_prorated_base_amount,0) ||
2668: 'l_prorated_amount= ' || nvl(l_prorated_amount,0);
2669: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg);
2670: END IF;

Line 2705: l_pd_rec.cleared_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

2701:
2702: IF p_xla_event_rec.event_type_code IN
2703: ('PAYMENT CLEARED', 'PAYMENT CLEARING ADJUSTED') THEN
2704:
2705: l_pd_rec.cleared_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2706: (l_bank_curr_amount,
2707: p_pay_hist_rec.bank_currency_code,
2708: ap_accounting_pay_pkg.g_base_currency_code,
2709: p_pay_hist_rec.bank_to_base_xrate_type,

Line 2708: ap_accounting_pay_pkg.g_base_currency_code,

2704:
2705: l_pd_rec.cleared_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2706: (l_bank_curr_amount,
2707: p_pay_hist_rec.bank_currency_code,
2708: ap_accounting_pay_pkg.g_base_currency_code,
2709: p_pay_hist_rec.bank_to_base_xrate_type,
2710: p_pay_hist_rec.bank_to_base_xrate_date,
2711: p_pay_hist_rec.bank_to_base_xrate,
2712: l_curr_calling_sequence);

Line 2714: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

2710: p_pay_hist_rec.bank_to_base_xrate_date,
2711: p_pay_hist_rec.bank_to_base_xrate,
2712: l_curr_calling_sequence);
2713:
2714: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2715: (l_prorated_amount,
2716: p_pay_hist_rec.pmt_currency_code,
2717: ap_accounting_pay_pkg.g_base_currency_code,
2718: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

Line 2717: ap_accounting_pay_pkg.g_base_currency_code,

2713:
2714: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2715: (l_prorated_amount,
2716: p_pay_hist_rec.pmt_currency_code,
2717: ap_accounting_pay_pkg.g_base_currency_code,
2718: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
2719: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
2720: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
2721: l_curr_calling_sequence);

Line 2718: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

2714: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2715: (l_prorated_amount,
2716: p_pay_hist_rec.pmt_currency_code,
2717: ap_accounting_pay_pkg.g_base_currency_code,
2718: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
2719: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
2720: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
2721: l_curr_calling_sequence);
2722:

Line 2719: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

2715: (l_prorated_amount,
2716: p_pay_hist_rec.pmt_currency_code,
2717: ap_accounting_pay_pkg.g_base_currency_code,
2718: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
2719: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
2720: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
2721: l_curr_calling_sequence);
2722:
2723: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN

Line 2720: ap_accounting_pay_pkg.g_pmt_to_base_xrate,

2716: p_pay_hist_rec.pmt_currency_code,
2717: ap_accounting_pay_pkg.g_base_currency_code,
2718: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
2719: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
2720: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
2721: l_curr_calling_sequence);
2722:
2723: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN
2724:

Line 2723: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN

2719: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
2720: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
2721: l_curr_calling_sequence);
2722:
2723: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN
2724:
2725: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2726: (l_prorated_amount,
2727: p_pay_hist_rec.pmt_currency_code,

Line 2725: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

2721: l_curr_calling_sequence);
2722:
2723: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN
2724:
2725: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2726: (l_prorated_amount,
2727: p_pay_hist_rec.pmt_currency_code,
2728: ap_accounting_pay_pkg.g_base_currency_code,
2729: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,

Line 2728: ap_accounting_pay_pkg.g_base_currency_code,

2724:
2725: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2726: (l_prorated_amount,
2727: p_pay_hist_rec.pmt_currency_code,
2728: ap_accounting_pay_pkg.g_base_currency_code,
2729: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
2730: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
2731: ap_accounting_pay_pkg.g_mat_to_base_xrate,
2732: l_curr_calling_sequence);

Line 2729: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,

2725: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2726: (l_prorated_amount,
2727: p_pay_hist_rec.pmt_currency_code,
2728: ap_accounting_pay_pkg.g_base_currency_code,
2729: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
2730: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
2731: ap_accounting_pay_pkg.g_mat_to_base_xrate,
2732: l_curr_calling_sequence);
2733: END IF ;

Line 2730: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,

2726: (l_prorated_amount,
2727: p_pay_hist_rec.pmt_currency_code,
2728: ap_accounting_pay_pkg.g_base_currency_code,
2729: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
2730: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
2731: ap_accounting_pay_pkg.g_mat_to_base_xrate,
2732: l_curr_calling_sequence);
2733: END IF ;
2734:

Line 2731: ap_accounting_pay_pkg.g_mat_to_base_xrate,

2727: p_pay_hist_rec.pmt_currency_code,
2728: ap_accounting_pay_pkg.g_base_currency_code,
2729: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
2730: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
2731: ap_accounting_pay_pkg.g_mat_to_base_xrate,
2732: l_curr_calling_sequence);
2733: END IF ;
2734:
2735: ELSIF p_xla_event_rec.event_type_code IN

Line 2739: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

2735: ELSIF p_xla_event_rec.event_type_code IN
2736: ('PAYMENT MATURED', 'PAYMENT MATURITY ADJUSTED') THEN
2737: l_pd_rec.matured_base_amount := l_prorated_base_amount;
2738:
2739: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2740: (l_prorated_amount,
2741: p_pay_hist_rec.pmt_currency_code,
2742: ap_accounting_pay_pkg.g_base_currency_code,
2743: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

Line 2742: ap_accounting_pay_pkg.g_base_currency_code,

2738:
2739: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2740: (l_prorated_amount,
2741: p_pay_hist_rec.pmt_currency_code,
2742: ap_accounting_pay_pkg.g_base_currency_code,
2743: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
2744: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
2745: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
2746: l_curr_calling_sequence);

Line 2743: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

2739: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
2740: (l_prorated_amount,
2741: p_pay_hist_rec.pmt_currency_code,
2742: ap_accounting_pay_pkg.g_base_currency_code,
2743: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
2744: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
2745: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
2746: l_curr_calling_sequence);
2747:

Line 2744: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

2740: (l_prorated_amount,
2741: p_pay_hist_rec.pmt_currency_code,
2742: ap_accounting_pay_pkg.g_base_currency_code,
2743: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
2744: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
2745: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
2746: l_curr_calling_sequence);
2747:
2748: ELSE

Line 2745: ap_accounting_pay_pkg.g_pmt_to_base_xrate,

2741: p_pay_hist_rec.pmt_currency_code,
2742: ap_accounting_pay_pkg.g_base_currency_code,
2743: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
2744: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
2745: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
2746: l_curr_calling_sequence);
2747:
2748: ELSE
2749: l_pd_rec.paid_base_amount := l_prorated_base_amount;

Line 2773: AP_Accounting_Pay_Pkg.Get_Base_Amount

2769:
2770: ELSE
2771:
2772: l_pd_rec.invoice_dist_base_amount :=
2773: AP_Accounting_Pay_Pkg.Get_Base_Amount
2774: (l_inv_dist_amount,
2775: p_inv_rec.invoice_currency_code,
2776: ap_accounting_pay_pkg.g_base_currency_code,
2777: p_inv_rec.exchange_rate_type,

Line 2776: ap_accounting_pay_pkg.g_base_currency_code,

2772: l_pd_rec.invoice_dist_base_amount :=
2773: AP_Accounting_Pay_Pkg.Get_Base_Amount
2774: (l_inv_dist_amount,
2775: p_inv_rec.invoice_currency_code,
2776: ap_accounting_pay_pkg.g_base_currency_code,
2777: p_inv_rec.exchange_rate_type,
2778: p_inv_rec.exchange_date,
2779: p_inv_rec.exchange_rate,
2780: l_curr_calling_sequence);

Line 2816: ap_accounting_pay_pkg.g_base_currency_code);

2812: l_base_qty_variance := AP_Utilities_PKG.AP_Round_Currency(
2813: ((p_inv_dist_rec.base_quantity_variance
2814: * l_pd_rec.invoice_dist_base_amount)
2815: / p_inv_dist_rec.base_amount),
2816: ap_accounting_pay_pkg.g_base_currency_code);
2817: END IF;
2818: END IF;
2819:
2820: IF p_inv_dist_rec.amount_variance IS NOT NULL THEN

Line 2843: ap_accounting_pay_pkg.g_base_currency_code);

2839: l_base_amt_variance := AP_Utilities_PKG.AP_Round_Currency(
2840: ((p_inv_dist_rec.base_amount_variance
2841: * l_pd_rec.invoice_dist_base_amount)
2842: / p_inv_dist_rec.base_amount),
2843: ap_accounting_pay_pkg.g_base_currency_code);
2844: END IF;
2845: END IF;
2846:
2847: l_pd_rec.quantity_variance := l_qty_variance;

Line 2874: (p_inv_rec.payment_currency_code <> ap_accounting_pay_pkg.g_base_currency_code) AND

2870:
2871:
2872: IF ((p_xla_event_rec.event_type_code NOT IN
2873: ('PAYMENT MATURED', 'PAYMENT MATURITY ADJUSTED')) AND
2874: (p_inv_rec.payment_currency_code <> ap_accounting_pay_pkg.g_base_currency_code) AND
2875: p_inv_dist_rec.po_distribution_id IS NOT NULL AND
2876: p_inv_dist_rec.line_type_lookup_code <> 'AWT') THEN
2877:
2878: -----------------------------------------------------------------------------

Line 2935: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info

2931: -- and inserts the calculated values into payment hist dists table
2932: ---------------------------------------------------------------------
2933:
2934: PROCEDURE Pay_Dist_Discount
2935: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
2936: ,p_inv_pay_rec IN r_inv_pay_info
2937: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2938: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2939: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

Line 2937: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

2933:
2934: PROCEDURE Pay_Dist_Discount
2935: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
2936: ,p_inv_pay_rec IN r_inv_pay_info
2937: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2938: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2939: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2940: ,p_calc_mode IN VARCHAR2
2941: ,p_disc_pay_amount IN OUT NOCOPY NUMBER

Line 2938: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info

2934: PROCEDURE Pay_Dist_Discount
2935: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
2936: ,p_inv_pay_rec IN r_inv_pay_info
2937: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2938: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2939: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2940: ,p_calc_mode IN VARCHAR2
2941: ,p_disc_pay_amount IN OUT NOCOPY NUMBER
2942: ,p_disc_dist_amount IN OUT NOCOPY NUMBER

Line 2939: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

2935: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
2936: ,p_inv_pay_rec IN r_inv_pay_info
2937: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
2938: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
2939: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
2940: ,p_calc_mode IN VARCHAR2
2941: ,p_disc_pay_amount IN OUT NOCOPY NUMBER
2942: ,p_disc_dist_amount IN OUT NOCOPY NUMBER
2943: ,p_disc_bank_amount IN OUT NOCOPY NUMBER

Line 3188: - ap_accounting_pay_pkg.get_casc_discount_sum

3184: l_prorated_disc_amt := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
3185: (p_inv_pay_rec.discount_taken * p_inv_dist_rec.amount
3186: / l_invoice_amount,
3187: p_pay_hist_rec.pmt_currency_code)
3188: - ap_accounting_pay_pkg.get_casc_discount_sum
3189: (p_inv_dist_rec.invoice_distribution_id,
3190: p_pay_hist_rec.related_event_id,
3191: p_inv_pay_rec.invoice_payment_id,
3192: l_curr_calling_sequence);

Line 3198: - ap_accounting_pay_pkg.get_casc_inv_dist_disc_sum

3194: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
3195: (l_disc_amt_inv_curr * p_inv_dist_rec.amount
3196: / l_invoice_amount,
3197: p_inv_rec.invoice_currency_code)
3198: - ap_accounting_pay_pkg.get_casc_inv_dist_disc_sum
3199: (p_inv_dist_rec.invoice_distribution_id,
3200: p_pay_hist_rec.related_event_id,
3201: p_inv_pay_rec.invoice_payment_id,
3202: l_curr_calling_sequence);

Line 3209: - ap_accounting_pay_pkg.get_casc_bank_curr_disc_sum

3205: l_inv_dist_amount := AP_UTILITIES_PKG.AP_ROUND_CURRENCY
3206: (l_disc_amt_bank_curr * p_inv_dist_rec.amount
3207: / l_invoice_amount,
3208: p_pay_hist_rec.bank_currency_code)
3209: - ap_accounting_pay_pkg.get_casc_bank_curr_disc_sum
3210: (p_inv_dist_rec.invoice_distribution_id,
3211: p_pay_hist_rec.related_event_id,
3212: p_inv_pay_rec.invoice_payment_id,
3213: l_curr_calling_sequence);

Line 3238: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3234: l_pd_rec.invoice_payment_id := p_inv_pay_rec.invoice_payment_id;
3235:
3236: l_pd_rec.bank_curr_amount := l_bank_curr_amount;
3237:
3238: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3239: (l_prorated_disc_amt,
3240: p_pay_hist_rec.pmt_currency_code,
3241: ap_accounting_pay_pkg.g_base_currency_code,
3242: p_pay_hist_rec.pmt_to_base_xrate_type,

Line 3241: ap_accounting_pay_pkg.g_base_currency_code,

3237:
3238: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3239: (l_prorated_disc_amt,
3240: p_pay_hist_rec.pmt_currency_code,
3241: ap_accounting_pay_pkg.g_base_currency_code,
3242: p_pay_hist_rec.pmt_to_base_xrate_type,
3243: p_pay_hist_rec.pmt_to_base_xrate_date,
3244: p_pay_hist_rec.pmt_to_base_xrate,
3245: l_curr_calling_sequence);

Line 3250: l_pd_rec.cleared_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3246:
3247: IF p_xla_event_rec.event_type_code IN
3248: ('PAYMENT CLEARED', 'PAYMENT CLEARING ADJUSTED') THEN
3249:
3250: l_pd_rec.cleared_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3251: (l_bank_curr_amount,
3252: p_pay_hist_rec.bank_currency_code,
3253: ap_accounting_pay_pkg.g_base_currency_code,
3254: p_pay_hist_rec.bank_to_base_xrate_type,

Line 3253: ap_accounting_pay_pkg.g_base_currency_code,

3249:
3250: l_pd_rec.cleared_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3251: (l_bank_curr_amount,
3252: p_pay_hist_rec.bank_currency_code,
3253: ap_accounting_pay_pkg.g_base_currency_code,
3254: p_pay_hist_rec.bank_to_base_xrate_type,
3255: p_pay_hist_rec.bank_to_base_xrate_date,
3256: p_pay_hist_rec.bank_to_base_xrate,
3257: l_curr_calling_sequence);

Line 3259: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3255: p_pay_hist_rec.bank_to_base_xrate_date,
3256: p_pay_hist_rec.bank_to_base_xrate,
3257: l_curr_calling_sequence);
3258:
3259: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3260: (l_prorated_disc_amt,
3261: p_pay_hist_rec.pmt_currency_code,
3262: ap_accounting_pay_pkg.g_base_currency_code,
3263: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

Line 3262: ap_accounting_pay_pkg.g_base_currency_code,

3258:
3259: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3260: (l_prorated_disc_amt,
3261: p_pay_hist_rec.pmt_currency_code,
3262: ap_accounting_pay_pkg.g_base_currency_code,
3263: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3264: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3265: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3266: l_curr_calling_sequence);

Line 3263: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

3259: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3260: (l_prorated_disc_amt,
3261: p_pay_hist_rec.pmt_currency_code,
3262: ap_accounting_pay_pkg.g_base_currency_code,
3263: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3264: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3265: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3266: l_curr_calling_sequence);
3267:

Line 3264: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

3260: (l_prorated_disc_amt,
3261: p_pay_hist_rec.pmt_currency_code,
3262: ap_accounting_pay_pkg.g_base_currency_code,
3263: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3264: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3265: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3266: l_curr_calling_sequence);
3267:
3268: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN

Line 3265: ap_accounting_pay_pkg.g_pmt_to_base_xrate,

3261: p_pay_hist_rec.pmt_currency_code,
3262: ap_accounting_pay_pkg.g_base_currency_code,
3263: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3264: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3265: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3266: l_curr_calling_sequence);
3267:
3268: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN
3269:

Line 3268: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN

3264: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3265: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3266: l_curr_calling_sequence);
3267:
3268: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN
3269:
3270: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3271: (l_prorated_disc_amt,
3272: p_pay_hist_rec.pmt_currency_code,

Line 3270: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3266: l_curr_calling_sequence);
3267:
3268: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN
3269:
3270: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3271: (l_prorated_disc_amt,
3272: p_pay_hist_rec.pmt_currency_code,
3273: ap_accounting_pay_pkg.g_base_currency_code,
3274: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,

Line 3273: ap_accounting_pay_pkg.g_base_currency_code,

3269:
3270: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3271: (l_prorated_disc_amt,
3272: p_pay_hist_rec.pmt_currency_code,
3273: ap_accounting_pay_pkg.g_base_currency_code,
3274: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
3275: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
3276: ap_accounting_pay_pkg.g_mat_to_base_xrate,
3277: l_curr_calling_sequence);

Line 3274: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,

3270: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3271: (l_prorated_disc_amt,
3272: p_pay_hist_rec.pmt_currency_code,
3273: ap_accounting_pay_pkg.g_base_currency_code,
3274: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
3275: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
3276: ap_accounting_pay_pkg.g_mat_to_base_xrate,
3277: l_curr_calling_sequence);
3278: END IF ;

Line 3275: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,

3271: (l_prorated_disc_amt,
3272: p_pay_hist_rec.pmt_currency_code,
3273: ap_accounting_pay_pkg.g_base_currency_code,
3274: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
3275: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
3276: ap_accounting_pay_pkg.g_mat_to_base_xrate,
3277: l_curr_calling_sequence);
3278: END IF ;
3279:

Line 3276: ap_accounting_pay_pkg.g_mat_to_base_xrate,

3272: p_pay_hist_rec.pmt_currency_code,
3273: ap_accounting_pay_pkg.g_base_currency_code,
3274: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
3275: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
3276: ap_accounting_pay_pkg.g_mat_to_base_xrate,
3277: l_curr_calling_sequence);
3278: END IF ;
3279:
3280: ELSIF p_xla_event_rec.event_type_code IN

Line 3284: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3280: ELSIF p_xla_event_rec.event_type_code IN
3281: ('PAYMENT MATURED', 'PAYMENT MATURITY ADJUSTED') THEN
3282: l_pd_rec.matured_base_amount := l_prorated_base_amount;
3283:
3284: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3285: (l_prorated_disc_amt,
3286: p_pay_hist_rec.pmt_currency_code,
3287: ap_accounting_pay_pkg.g_base_currency_code,
3288: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

Line 3287: ap_accounting_pay_pkg.g_base_currency_code,

3283:
3284: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3285: (l_prorated_disc_amt,
3286: p_pay_hist_rec.pmt_currency_code,
3287: ap_accounting_pay_pkg.g_base_currency_code,
3288: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3289: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3290: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3291: l_curr_calling_sequence);

Line 3288: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

3284: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3285: (l_prorated_disc_amt,
3286: p_pay_hist_rec.pmt_currency_code,
3287: ap_accounting_pay_pkg.g_base_currency_code,
3288: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3289: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3290: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3291: l_curr_calling_sequence);
3292:

Line 3289: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

3285: (l_prorated_disc_amt,
3286: p_pay_hist_rec.pmt_currency_code,
3287: ap_accounting_pay_pkg.g_base_currency_code,
3288: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3289: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3290: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3291: l_curr_calling_sequence);
3292:
3293: ELSE

Line 3290: ap_accounting_pay_pkg.g_pmt_to_base_xrate,

3286: p_pay_hist_rec.pmt_currency_code,
3287: ap_accounting_pay_pkg.g_base_currency_code,
3288: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3289: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3290: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3291: l_curr_calling_sequence);
3292:
3293: ELSE
3294: l_pd_rec.paid_base_amount := l_prorated_base_amount;

Line 3313: AP_Accounting_Pay_Pkg.Get_Base_Amount

3309:
3310: ELSE
3311:
3312: l_pd_rec.invoice_dist_base_amount :=
3313: AP_Accounting_Pay_Pkg.Get_Base_Amount
3314: (l_inv_dist_amount,
3315: p_inv_rec.invoice_currency_code,
3316: ap_accounting_pay_pkg.g_base_currency_code,
3317: p_inv_rec.exchange_rate_type,

Line 3316: ap_accounting_pay_pkg.g_base_currency_code,

3312: l_pd_rec.invoice_dist_base_amount :=
3313: AP_Accounting_Pay_Pkg.Get_Base_Amount
3314: (l_inv_dist_amount,
3315: p_inv_rec.invoice_currency_code,
3316: ap_accounting_pay_pkg.g_base_currency_code,
3317: p_inv_rec.exchange_rate_type,
3318: p_inv_rec.exchange_date,
3319: p_inv_rec.exchange_rate,
3320: l_curr_calling_sequence);

Line 3365: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info

3361: -- and inserts the calculated values into payment hist dists table
3362: ---------------------------------------------------------------------
3363:
3364: PROCEDURE Pay_Dist_ERV
3365: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
3366: ,p_inv_pay_rec IN r_inv_pay_info
3367: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
3368: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
3369: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

Line 3367: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

3363:
3364: PROCEDURE Pay_Dist_ERV
3365: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
3366: ,p_inv_pay_rec IN r_inv_pay_info
3367: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
3368: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
3369: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
3370: ,p_prorated_amount IN NUMBER
3371: ,p_calling_sequence IN VARCHAR2

Line 3368: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info

3364: PROCEDURE Pay_Dist_ERV
3365: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
3366: ,p_inv_pay_rec IN r_inv_pay_info
3367: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
3368: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
3369: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
3370: ,p_prorated_amount IN NUMBER
3371: ,p_calling_sequence IN VARCHAR2
3372: ) IS

Line 3369: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

3365: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
3366: ,p_inv_pay_rec IN r_inv_pay_info
3367: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
3368: ,p_inv_rec IN ap_accounting_pay_pkg.r_invoices_info
3369: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
3370: ,p_prorated_amount IN NUMBER
3371: ,p_calling_sequence IN VARCHAR2
3372: ) IS
3373:

Line 3533: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info

3529: -- and inserts the calculated values into payment hist dists table
3530: ---------------------------------------------------------------------
3531:
3532: PROCEDURE Pay_Dist_Err_Chrg
3533: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
3534: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
3535: ,p_distribute_mode IN VARCHAR2
3536: ,p_calling_sequence IN VARCHAR2
3537: ) IS

Line 3534: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

3530: ---------------------------------------------------------------------
3531:
3532: PROCEDURE Pay_Dist_Err_Chrg
3533: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
3534: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
3535: ,p_distribute_mode IN VARCHAR2
3536: ,p_calling_sequence IN VARCHAR2
3537: ) IS
3538:

Line 3655: l_pd_rec.bank_curr_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3651:
3652: l_pd_rec.payment_history_id := p_pay_hist_rec.payment_history_id;
3653: l_pd_rec.invoice_payment_id := l_clr_rec.invoice_payment_id;
3654:
3655: l_pd_rec.bank_curr_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3656: (l_prorated_amt,
3657: p_pay_hist_rec.bank_currency_code,
3658: ap_accounting_pay_pkg.g_base_currency_code,
3659: p_pay_hist_rec.bank_to_base_xrate_type,

Line 3658: ap_accounting_pay_pkg.g_base_currency_code,

3654:
3655: l_pd_rec.bank_curr_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3656: (l_prorated_amt,
3657: p_pay_hist_rec.bank_currency_code,
3658: ap_accounting_pay_pkg.g_base_currency_code,
3659: p_pay_hist_rec.bank_to_base_xrate_type,
3660: p_pay_hist_rec.bank_to_base_xrate_date,
3661: p_pay_hist_rec.bank_to_base_xrate,
3662: l_curr_calling_sequence);

Line 3668: /*l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3664: -- Bug6901436. l_prorated_amount is in bank currency. Bank to base
3665: -- exchange rate details needs to be provided to Get_Base_Amount
3666: -- procedure.
3667:
3668: /*l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3669: -- (l_prorated_amt,
3670: -- p_pay_hist_rec.pmt_currency_code,
3671: -- ap_accounting_pay_pkg.g_base_currency_code,
3672: -- p_pay_hist_rec.pmt_to_base_xrate_type,

Line 3671: -- ap_accounting_pay_pkg.g_base_currency_code,

3667:
3668: /*l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3669: -- (l_prorated_amt,
3670: -- p_pay_hist_rec.pmt_currency_code,
3671: -- ap_accounting_pay_pkg.g_base_currency_code,
3672: -- p_pay_hist_rec.pmt_to_base_xrate_type,
3673: -- p_pay_hist_rec.pmt_to_base_xrate_date,
3674: -- p_pay_hist_rec.pmt_to_base_xrate,
3675: -- l_curr_calling_sequence);*/

Line 3677: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3673: -- p_pay_hist_rec.pmt_to_base_xrate_date,
3674: -- p_pay_hist_rec.pmt_to_base_xrate,
3675: -- l_curr_calling_sequence);*/
3676:
3677: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3678: (l_prorated_amt,
3679: p_pay_hist_rec.bank_currency_code,
3680: ap_accounting_pay_pkg.g_base_currency_code,
3681: p_pay_hist_rec.bank_to_base_xrate_type,

Line 3680: ap_accounting_pay_pkg.g_base_currency_code,

3676:
3677: l_prorated_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3678: (l_prorated_amt,
3679: p_pay_hist_rec.bank_currency_code,
3680: ap_accounting_pay_pkg.g_base_currency_code,
3681: p_pay_hist_rec.bank_to_base_xrate_type,
3682: p_pay_hist_rec.bank_to_base_xrate_date,
3683: p_pay_hist_rec.bank_to_base_xrate,
3684: l_curr_calling_sequence);

Line 3692: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3688: IF p_xla_event_rec.event_type_code IN
3689: ('PAYMENT CLEARED', 'PAYMENT CLEARING ADJUSTED') THEN
3690: l_pd_rec.cleared_base_amount := l_prorated_base_amount;
3691:
3692: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3693: (l_prorated_amt,
3694: p_pay_hist_rec.pmt_currency_code,
3695: ap_accounting_pay_pkg.g_base_currency_code,
3696: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

Line 3695: ap_accounting_pay_pkg.g_base_currency_code,

3691:
3692: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3693: (l_prorated_amt,
3694: p_pay_hist_rec.pmt_currency_code,
3695: ap_accounting_pay_pkg.g_base_currency_code,
3696: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3697: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3698: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3699: l_curr_calling_sequence);

Line 3696: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

3692: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3693: (l_prorated_amt,
3694: p_pay_hist_rec.pmt_currency_code,
3695: ap_accounting_pay_pkg.g_base_currency_code,
3696: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3697: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3698: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3699: l_curr_calling_sequence);
3700:

Line 3697: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

3693: (l_prorated_amt,
3694: p_pay_hist_rec.pmt_currency_code,
3695: ap_accounting_pay_pkg.g_base_currency_code,
3696: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3697: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3698: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3699: l_curr_calling_sequence);
3700:
3701: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN

Line 3698: ap_accounting_pay_pkg.g_pmt_to_base_xrate,

3694: p_pay_hist_rec.pmt_currency_code,
3695: ap_accounting_pay_pkg.g_base_currency_code,
3696: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3697: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3698: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3699: l_curr_calling_sequence);
3700:
3701: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN
3702:

Line 3701: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN

3697: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3698: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3699: l_curr_calling_sequence);
3700:
3701: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN
3702:
3703: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3704: (l_prorated_amt,
3705: p_pay_hist_rec.pmt_currency_code,

Line 3703: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3699: l_curr_calling_sequence);
3700:
3701: IF ap_accounting_pay_pkg.g_mat_to_base_xrate IS NOT NULL THEN
3702:
3703: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3704: (l_prorated_amt,
3705: p_pay_hist_rec.pmt_currency_code,
3706: ap_accounting_pay_pkg.g_base_currency_code,
3707: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,

Line 3706: ap_accounting_pay_pkg.g_base_currency_code,

3702:
3703: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3704: (l_prorated_amt,
3705: p_pay_hist_rec.pmt_currency_code,
3706: ap_accounting_pay_pkg.g_base_currency_code,
3707: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
3708: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
3709: ap_accounting_pay_pkg.g_mat_to_base_xrate,
3710: l_curr_calling_sequence);

Line 3707: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,

3703: l_pd_rec.matured_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3704: (l_prorated_amt,
3705: p_pay_hist_rec.pmt_currency_code,
3706: ap_accounting_pay_pkg.g_base_currency_code,
3707: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
3708: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
3709: ap_accounting_pay_pkg.g_mat_to_base_xrate,
3710: l_curr_calling_sequence);
3711: END IF ;

Line 3708: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,

3704: (l_prorated_amt,
3705: p_pay_hist_rec.pmt_currency_code,
3706: ap_accounting_pay_pkg.g_base_currency_code,
3707: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
3708: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
3709: ap_accounting_pay_pkg.g_mat_to_base_xrate,
3710: l_curr_calling_sequence);
3711: END IF ;
3712: ELSIF p_xla_event_rec.event_type_code IN

Line 3709: ap_accounting_pay_pkg.g_mat_to_base_xrate,

3705: p_pay_hist_rec.pmt_currency_code,
3706: ap_accounting_pay_pkg.g_base_currency_code,
3707: ap_accounting_pay_pkg.g_mat_to_base_xrate_type,
3708: ap_accounting_pay_pkg.g_mat_to_base_xrate_date,
3709: ap_accounting_pay_pkg.g_mat_to_base_xrate,
3710: l_curr_calling_sequence);
3711: END IF ;
3712: ELSIF p_xla_event_rec.event_type_code IN
3713: ('PAYMENT MATURED', 'PAYMENT MATURITY ADJUSTED') THEN

Line 3716: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount

3712: ELSIF p_xla_event_rec.event_type_code IN
3713: ('PAYMENT MATURED', 'PAYMENT MATURITY ADJUSTED') THEN
3714: l_pd_rec.matured_base_amount := l_prorated_base_amount;
3715:
3716: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3717: (l_prorated_amt,
3718: p_pay_hist_rec.pmt_currency_code,
3719: ap_accounting_pay_pkg.g_base_currency_code,
3720: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

Line 3719: ap_accounting_pay_pkg.g_base_currency_code,

3715:
3716: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3717: (l_prorated_amt,
3718: p_pay_hist_rec.pmt_currency_code,
3719: ap_accounting_pay_pkg.g_base_currency_code,
3720: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3721: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3722: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3723: l_curr_calling_sequence);

Line 3720: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,

3716: l_pd_rec.paid_base_amount := AP_Accounting_Pay_Pkg.Get_Base_Amount
3717: (l_prorated_amt,
3718: p_pay_hist_rec.pmt_currency_code,
3719: ap_accounting_pay_pkg.g_base_currency_code,
3720: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3721: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3722: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3723: l_curr_calling_sequence);
3724:

Line 3721: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,

3717: (l_prorated_amt,
3718: p_pay_hist_rec.pmt_currency_code,
3719: ap_accounting_pay_pkg.g_base_currency_code,
3720: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3721: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3722: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3723: l_curr_calling_sequence);
3724:
3725: ELSE

Line 3722: ap_accounting_pay_pkg.g_pmt_to_base_xrate,

3718: p_pay_hist_rec.pmt_currency_code,
3719: ap_accounting_pay_pkg.g_base_currency_code,
3720: ap_accounting_pay_pkg.g_pmt_to_base_xrate_type,
3721: ap_accounting_pay_pkg.g_pmt_to_base_xrate_date,
3722: ap_accounting_pay_pkg.g_pmt_to_base_xrate,
3723: l_curr_calling_sequence);
3724:
3725: ELSE
3726: l_pd_rec.paid_base_amount := l_prorated_base_amount;

Line 3774: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info

3770: ---------------------------------------------------------------------
3771:
3772: -- Bug 6887295. Added parameter p_inv_dist_rec
3773: PROCEDURE Pay_Dist_Reverse
3774: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
3775: ,p_inv_pay_rec IN r_inv_pay_info
3776: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
3777: ,p_reversal_inv_pmt_id IN NUMBER
3778: ,p_related_event_id IN NUMBER

Line 3776: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info

3772: -- Bug 6887295. Added parameter p_inv_dist_rec
3773: PROCEDURE Pay_Dist_Reverse
3774: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
3775: ,p_inv_pay_rec IN r_inv_pay_info
3776: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
3777: ,p_reversal_inv_pmt_id IN NUMBER
3778: ,p_related_event_id IN NUMBER
3779: ,p_invoice_dist_id IN NUMBER
3780: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

Line 3780: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info

3776: ,p_pay_hist_rec IN ap_accounting_pay_pkg.r_pay_hist_info
3777: ,p_reversal_inv_pmt_id IN NUMBER
3778: ,p_related_event_id IN NUMBER
3779: ,p_invoice_dist_id IN NUMBER
3780: ,p_inv_dist_rec IN ap_accounting_pay_pkg.r_inv_dist_info
3781: ,p_calling_sequence IN VARCHAR2
3782: ) IS
3783:
3784: l_curr_calling_sequence VARCHAR2(2000);

Line 4396: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info

4392: -- ap_payment_hist_dists table
4393: ----------------------------------------------------------------------------------
4394:
4395: PROCEDURE Upg_Dist_Links_Insert
4396: (p_xla_event_rec IN ap_accounting_pay_pkg.r_xla_event_info
4397: ,p_payment_history_id IN NUMBER
4398: ,p_accounting_event_id IN NUMBER
4399: ,p_calling_sequence IN VARCHAR2
4400: ) IS