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_RECONCILIATION_PKG dependencies on AP_PAYMENT_HISTORY

Line 7: -- In this case we insert a record into the AP_PAYMENT_HISTORY which

3:
4: --============================================================================
5: -- POSSIBLE SCENARIOS ON HOW THIS API MAY BE CALLED:
6: -- 1) PAYMENT MATURITY
7: -- In this case we insert a record into the AP_PAYMENT_HISTORY which
8: -- contains all information in currency of payment.
9: -- 2) PAYMENT CLEARING WITH RECONCILIATION ACCOUNTING OFF
10: -- In this case we simply update the AP_CHECKS and no entry is generated
11: -- for AP_PAYMENT_HISTORY. The amounts need to be properly converted

Line 11: -- for AP_PAYMENT_HISTORY. The amounts need to be properly converted

7: -- In this case we insert a record into the AP_PAYMENT_HISTORY which
8: -- contains all information in currency of payment.
9: -- 2) PAYMENT CLEARING WITH RECONCILIATION ACCOUNTING OFF
10: -- In this case we simply update the AP_CHECKS and no entry is generated
11: -- for AP_PAYMENT_HISTORY. The amounts need to be properly converted
12: -- to the payment currency.
13: -- 3) PAYMENT CLEARING WITH RECONCILIATION ACCOUNTING ON
14: -- Same as 2
15: -- 4) PAYMENT RECONCILIATION WITH RECONCILIATION ACCOUNTING OFF

Line 18: -- Same as 2 + Creation of entry into the AP_PAYMENT_HISTORY table.

14: -- Same as 2
15: -- 4) PAYMENT RECONCILIATION WITH RECONCILIATION ACCOUNTING OFF
16: -- Same as 2
17: -- 5) PAYMENT RECONCILIATION WITH RECONCILIATION ACCOUNTING ON
18: -- Same as 2 + Creation of entry into the AP_PAYMENT_HISTORY table.
19: -- NOTE: Entry into AP_PAYMENT_HISTORY table will be in the recon currency.
20: --
21: -- TERMINOLOGY:
22: -- 1) PAYMENT MATURITY:

Line 19: -- NOTE: Entry into AP_PAYMENT_HISTORY table will be in the recon currency.

15: -- 4) PAYMENT RECONCILIATION WITH RECONCILIATION ACCOUNTING OFF
16: -- Same as 2
17: -- 5) PAYMENT RECONCILIATION WITH RECONCILIATION ACCOUNTING ON
18: -- Same as 2 + Creation of entry into the AP_PAYMENT_HISTORY table.
19: -- NOTE: Entry into AP_PAYMENT_HISTORY table will be in the recon currency.
20: --
21: -- TERMINOLOGY:
22: -- 1) PAYMENT MATURITY:
23: -- TRANSACTION_TYPE = PAYMENT MATURITY

Line 117: l_Trx_Bank_Amount AP_PAYMENT_HISTORY.Trx_Bank_Amount%TYPE;

113: X_REQUEST_ID NUMBER,
114: X_CALLING_SEQUENCE VARCHAR2
115: ) AS
116: current_calling_sequence VARCHAR2(2000);
117: l_Trx_Bank_Amount AP_PAYMENT_HISTORY.Trx_Bank_Amount%TYPE;
118: l_Errors_Bank_Amount AP_PAYMENT_HISTORY.Errors_Bank_Amount%TYPE;
119: l_Charges_Bank_Amount AP_PAYMENT_HISTORY.Charges_Bank_Amount%TYPE;
120: l_Bank_Currency_Code AP_PAYMENT_HISTORY.Bank_Currency_Code%TYPE;
121: l_Pmt_to_Base_Xrate_Type AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Type%TYPE;

Line 118: l_Errors_Bank_Amount AP_PAYMENT_HISTORY.Errors_Bank_Amount%TYPE;

114: X_CALLING_SEQUENCE VARCHAR2
115: ) AS
116: current_calling_sequence VARCHAR2(2000);
117: l_Trx_Bank_Amount AP_PAYMENT_HISTORY.Trx_Bank_Amount%TYPE;
118: l_Errors_Bank_Amount AP_PAYMENT_HISTORY.Errors_Bank_Amount%TYPE;
119: l_Charges_Bank_Amount AP_PAYMENT_HISTORY.Charges_Bank_Amount%TYPE;
120: l_Bank_Currency_Code AP_PAYMENT_HISTORY.Bank_Currency_Code%TYPE;
121: l_Pmt_to_Base_Xrate_Type AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Type%TYPE;
122: l_Pmt_to_Base_Xrate_Date AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Date%TYPE;

Line 119: l_Charges_Bank_Amount AP_PAYMENT_HISTORY.Charges_Bank_Amount%TYPE;

115: ) AS
116: current_calling_sequence VARCHAR2(2000);
117: l_Trx_Bank_Amount AP_PAYMENT_HISTORY.Trx_Bank_Amount%TYPE;
118: l_Errors_Bank_Amount AP_PAYMENT_HISTORY.Errors_Bank_Amount%TYPE;
119: l_Charges_Bank_Amount AP_PAYMENT_HISTORY.Charges_Bank_Amount%TYPE;
120: l_Bank_Currency_Code AP_PAYMENT_HISTORY.Bank_Currency_Code%TYPE;
121: l_Pmt_to_Base_Xrate_Type AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Type%TYPE;
122: l_Pmt_to_Base_Xrate_Date AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Date%TYPE;
123: l_Pmt_to_Base_Xrate AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate%TYPE;

Line 120: l_Bank_Currency_Code AP_PAYMENT_HISTORY.Bank_Currency_Code%TYPE;

116: current_calling_sequence VARCHAR2(2000);
117: l_Trx_Bank_Amount AP_PAYMENT_HISTORY.Trx_Bank_Amount%TYPE;
118: l_Errors_Bank_Amount AP_PAYMENT_HISTORY.Errors_Bank_Amount%TYPE;
119: l_Charges_Bank_Amount AP_PAYMENT_HISTORY.Charges_Bank_Amount%TYPE;
120: l_Bank_Currency_Code AP_PAYMENT_HISTORY.Bank_Currency_Code%TYPE;
121: l_Pmt_to_Base_Xrate_Type AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Type%TYPE;
122: l_Pmt_to_Base_Xrate_Date AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Date%TYPE;
123: l_Pmt_to_Base_Xrate AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate%TYPE;
124: l_debug_info VARCHAR2(240);

Line 121: l_Pmt_to_Base_Xrate_Type AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Type%TYPE;

117: l_Trx_Bank_Amount AP_PAYMENT_HISTORY.Trx_Bank_Amount%TYPE;
118: l_Errors_Bank_Amount AP_PAYMENT_HISTORY.Errors_Bank_Amount%TYPE;
119: l_Charges_Bank_Amount AP_PAYMENT_HISTORY.Charges_Bank_Amount%TYPE;
120: l_Bank_Currency_Code AP_PAYMENT_HISTORY.Bank_Currency_Code%TYPE;
121: l_Pmt_to_Base_Xrate_Type AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Type%TYPE;
122: l_Pmt_to_Base_Xrate_Date AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Date%TYPE;
123: l_Pmt_to_Base_Xrate AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate%TYPE;
124: l_debug_info VARCHAR2(240);
125: l_api_name CONSTANT VARCHAR2(1000) := 'Recon_Payment_History' ;

Line 122: l_Pmt_to_Base_Xrate_Date AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Date%TYPE;

118: l_Errors_Bank_Amount AP_PAYMENT_HISTORY.Errors_Bank_Amount%TYPE;
119: l_Charges_Bank_Amount AP_PAYMENT_HISTORY.Charges_Bank_Amount%TYPE;
120: l_Bank_Currency_Code AP_PAYMENT_HISTORY.Bank_Currency_Code%TYPE;
121: l_Pmt_to_Base_Xrate_Type AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Type%TYPE;
122: l_Pmt_to_Base_Xrate_Date AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Date%TYPE;
123: l_Pmt_to_Base_Xrate AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate%TYPE;
124: l_debug_info VARCHAR2(240);
125: l_api_name CONSTANT VARCHAR2(1000) := 'Recon_Payment_History' ;
126: BEGIN

Line 123: l_Pmt_to_Base_Xrate AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate%TYPE;

119: l_Charges_Bank_Amount AP_PAYMENT_HISTORY.Charges_Bank_Amount%TYPE;
120: l_Bank_Currency_Code AP_PAYMENT_HISTORY.Bank_Currency_Code%TYPE;
121: l_Pmt_to_Base_Xrate_Type AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Type%TYPE;
122: l_Pmt_to_Base_Xrate_Date AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate_Date%TYPE;
123: l_Pmt_to_Base_Xrate AP_PAYMENT_HISTORY.Pmt_to_Base_Xrate%TYPE;
124: l_debug_info VARCHAR2(240);
125: l_api_name CONSTANT VARCHAR2(1000) := 'Recon_Payment_History' ;
126: BEGIN
127:

Line 285: l_trx_base_amount AP_PAYMENT_HISTORY.Trx_Base_Amount%TYPE;

281: X_REQUEST_ID NUMBER,
282: X_CALLING_SEQUENCE VARCHAR2
283: ) AS
284: current_calling_sequence VARCHAR2(2000);
285: l_trx_base_amount AP_PAYMENT_HISTORY.Trx_Base_Amount%TYPE;
286: l_functional_currency_code VARCHAR2(15);
287: l_rev_pmt_hist_id NUMBER; -- Bug3343314
288: l_org_id NUMBER;
289: l_debug_info VARCHAR2(240);

Line 309: FROM ap_payment_history aph

305: IF (x_transaction_type = 'PAYMENT MATURITY REVERSAL') THEN
306:
307: SELECT payment_history_id
308: INTO l_rev_pmt_hist_id
309: FROM ap_payment_history aph
310: WHERE transaction_type = 'PAYMENT MATURITY'
311: AND check_id = x_check_id
312: AND not exists (select 1
313: from ap_payment_history aph1

Line 313: from ap_payment_history aph1

309: FROM ap_payment_history aph
310: WHERE transaction_type = 'PAYMENT MATURITY'
311: AND check_id = x_check_id
312: AND not exists (select 1
313: from ap_payment_history aph1
314: where aph.check_id=aph1.check_id
315: and aph.payment_history_id=aph1.rev_pmt_hist_id);
316:
317: -- Bug 7674770

Line 444: * AP_PAYMENT_HISTORY for a particular check *

440:
441:
442: /* *************************************************************************
443: * DELETE_PAYMENT_MATURITY: Removes entry for payment maturity from *
444: * AP_PAYMENT_HISTORY for a particular check *
445: ************************************************************************* */
446:
447: PROCEDURE Delete_Payment_Maturity (
448: X_CHECK_ID NUMBER,

Line 465: DELETE FROM AP_PAYMENT_HISTORY

461: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
462: END IF;
463: ---------------------------------------------------------------
464:
465: DELETE FROM AP_PAYMENT_HISTORY
466: WHERE check_id = x_check_id
467: AND transaction_type = 'PAYMENT MATURITY'
468: AND nvl(posted_flag,'N') = 'N';
469:

Line 1761: l_rev_pmt_hist_id ap_payment_history.rev_pmt_hist_id%TYPE;

1757:
1758: --bgufix:5623562
1759: l_recon_accounting_flag ap_system_parameters.recon_accounting_flag%TYPE;
1760: l_check_amount ap_checks.amount%TYPE;
1761: l_rev_pmt_hist_id ap_payment_history.rev_pmt_hist_id%TYPE;
1762: l_check_id ap_checks.check_id%TYPE;
1763: l_ind_trx_bank_amount ap_payment_history.trx_bank_amount%TYPE;
1764: l_ind_errors_bank_amount ap_payment_history.errors_bank_amount%TYPE;
1765: l_ind_charges_bank_amount ap_payment_history.charges_bank_amount%TYPE;

Line 1763: l_ind_trx_bank_amount ap_payment_history.trx_bank_amount%TYPE;

1759: l_recon_accounting_flag ap_system_parameters.recon_accounting_flag%TYPE;
1760: l_check_amount ap_checks.amount%TYPE;
1761: l_rev_pmt_hist_id ap_payment_history.rev_pmt_hist_id%TYPE;
1762: l_check_id ap_checks.check_id%TYPE;
1763: l_ind_trx_bank_amount ap_payment_history.trx_bank_amount%TYPE;
1764: l_ind_errors_bank_amount ap_payment_history.errors_bank_amount%TYPE;
1765: l_ind_charges_bank_amount ap_payment_history.charges_bank_amount%TYPE;
1766: l_bank_currency_code ap_payment_history.bank_currency_code%TYPE;
1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;

Line 1764: l_ind_errors_bank_amount ap_payment_history.errors_bank_amount%TYPE;

1760: l_check_amount ap_checks.amount%TYPE;
1761: l_rev_pmt_hist_id ap_payment_history.rev_pmt_hist_id%TYPE;
1762: l_check_id ap_checks.check_id%TYPE;
1763: l_ind_trx_bank_amount ap_payment_history.trx_bank_amount%TYPE;
1764: l_ind_errors_bank_amount ap_payment_history.errors_bank_amount%TYPE;
1765: l_ind_charges_bank_amount ap_payment_history.charges_bank_amount%TYPE;
1766: l_bank_currency_code ap_payment_history.bank_currency_code%TYPE;
1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;
1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;

Line 1765: l_ind_charges_bank_amount ap_payment_history.charges_bank_amount%TYPE;

1761: l_rev_pmt_hist_id ap_payment_history.rev_pmt_hist_id%TYPE;
1762: l_check_id ap_checks.check_id%TYPE;
1763: l_ind_trx_bank_amount ap_payment_history.trx_bank_amount%TYPE;
1764: l_ind_errors_bank_amount ap_payment_history.errors_bank_amount%TYPE;
1765: l_ind_charges_bank_amount ap_payment_history.charges_bank_amount%TYPE;
1766: l_bank_currency_code ap_payment_history.bank_currency_code%TYPE;
1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;
1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;
1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;

Line 1766: l_bank_currency_code ap_payment_history.bank_currency_code%TYPE;

1762: l_check_id ap_checks.check_id%TYPE;
1763: l_ind_trx_bank_amount ap_payment_history.trx_bank_amount%TYPE;
1764: l_ind_errors_bank_amount ap_payment_history.errors_bank_amount%TYPE;
1765: l_ind_charges_bank_amount ap_payment_history.charges_bank_amount%TYPE;
1766: l_bank_currency_code ap_payment_history.bank_currency_code%TYPE;
1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;
1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;
1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;
1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;

Line 1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;

1763: l_ind_trx_bank_amount ap_payment_history.trx_bank_amount%TYPE;
1764: l_ind_errors_bank_amount ap_payment_history.errors_bank_amount%TYPE;
1765: l_ind_charges_bank_amount ap_payment_history.charges_bank_amount%TYPE;
1766: l_bank_currency_code ap_payment_history.bank_currency_code%TYPE;
1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;
1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;
1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;
1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;
1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;

Line 1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;

1764: l_ind_errors_bank_amount ap_payment_history.errors_bank_amount%TYPE;
1765: l_ind_charges_bank_amount ap_payment_history.charges_bank_amount%TYPE;
1766: l_bank_currency_code ap_payment_history.bank_currency_code%TYPE;
1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;
1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;
1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;
1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;
1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;
1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;

Line 1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;

1765: l_ind_charges_bank_amount ap_payment_history.charges_bank_amount%TYPE;
1766: l_bank_currency_code ap_payment_history.bank_currency_code%TYPE;
1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;
1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;
1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;
1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;
1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;
1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;
1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;

Line 1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;

1766: l_bank_currency_code ap_payment_history.bank_currency_code%TYPE;
1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;
1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;
1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;
1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;
1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;
1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;
1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;
1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;

Line 1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;

1767: l_bank_to_base_xrate_type ap_payment_history.bank_to_base_xrate_type%TYPE;
1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;
1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;
1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;
1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;
1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;
1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;
1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;
1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;

Line 1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;

1768: l_bank_to_base_xrate_date ap_payment_history.bank_to_base_xrate_date%TYPE;
1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;
1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;
1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;
1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;
1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;
1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;
1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;
1776: l_pmt_to_base_xrate ap_payment_history.pmt_to_base_xrate%TYPE;

Line 1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;

1769: l_bank_to_base_xrate ap_payment_history.bank_to_base_xrate%TYPE;
1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;
1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;
1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;
1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;
1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;
1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;
1776: l_pmt_to_base_xrate ap_payment_history.pmt_to_base_xrate%TYPE;
1777: l_ind_trx_base_amount ap_payment_history.trx_base_amount%TYPE;

Line 1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;

1770: l_ind_trx_pmt_amount ap_payment_history.trx_pmt_amount%TYPE;
1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;
1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;
1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;
1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;
1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;
1776: l_pmt_to_base_xrate ap_payment_history.pmt_to_base_xrate%TYPE;
1777: l_ind_trx_base_amount ap_payment_history.trx_base_amount%TYPE;
1778: l_ind_errors_base_amount ap_payment_history.errors_base_amount%TYPE;

Line 1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;

1771: l_ind_errors_pmt_amount ap_payment_history.errors_pmt_amount%TYPE;
1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;
1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;
1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;
1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;
1776: l_pmt_to_base_xrate ap_payment_history.pmt_to_base_xrate%TYPE;
1777: l_ind_trx_base_amount ap_payment_history.trx_base_amount%TYPE;
1778: l_ind_errors_base_amount ap_payment_history.errors_base_amount%TYPE;
1779: l_ind_charges_base_amount ap_payment_history.charges_base_amount%TYPE;

Line 1776: l_pmt_to_base_xrate ap_payment_history.pmt_to_base_xrate%TYPE;

1772: l_ind_charges_pmt_amount ap_payment_history.charges_pmt_amount%TYPE;
1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;
1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;
1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;
1776: l_pmt_to_base_xrate ap_payment_history.pmt_to_base_xrate%TYPE;
1777: l_ind_trx_base_amount ap_payment_history.trx_base_amount%TYPE;
1778: l_ind_errors_base_amount ap_payment_history.errors_base_amount%TYPE;
1779: l_ind_charges_base_amount ap_payment_history.charges_base_amount%TYPE;
1780: l_debug_info VARCHAR2(240);

Line 1777: l_ind_trx_base_amount ap_payment_history.trx_base_amount%TYPE;

1773: l_pmt_currency_code ap_payment_history.pmt_currency_code%TYPE;
1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;
1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;
1776: l_pmt_to_base_xrate ap_payment_history.pmt_to_base_xrate%TYPE;
1777: l_ind_trx_base_amount ap_payment_history.trx_base_amount%TYPE;
1778: l_ind_errors_base_amount ap_payment_history.errors_base_amount%TYPE;
1779: l_ind_charges_base_amount ap_payment_history.charges_base_amount%TYPE;
1780: l_debug_info VARCHAR2(240);
1781: l_api_name CONSTANT VARCHAR2(1000) := 'recon_payment_unclearing' ;

Line 1778: l_ind_errors_base_amount ap_payment_history.errors_base_amount%TYPE;

1774: l_pmt_to_base_xrate_type ap_payment_history.pmt_to_base_xrate_type%TYPE;
1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;
1776: l_pmt_to_base_xrate ap_payment_history.pmt_to_base_xrate%TYPE;
1777: l_ind_trx_base_amount ap_payment_history.trx_base_amount%TYPE;
1778: l_ind_errors_base_amount ap_payment_history.errors_base_amount%TYPE;
1779: l_ind_charges_base_amount ap_payment_history.charges_base_amount%TYPE;
1780: l_debug_info VARCHAR2(240);
1781: l_api_name CONSTANT VARCHAR2(1000) := 'recon_payment_unclearing' ;
1782:

Line 1779: l_ind_charges_base_amount ap_payment_history.charges_base_amount%TYPE;

1775: l_pmt_to_base_xrate_date ap_payment_history.pmt_to_base_xrate_date%TYPE;
1776: l_pmt_to_base_xrate ap_payment_history.pmt_to_base_xrate%TYPE;
1777: l_ind_trx_base_amount ap_payment_history.trx_base_amount%TYPE;
1778: l_ind_errors_base_amount ap_payment_history.errors_base_amount%TYPE;
1779: l_ind_charges_base_amount ap_payment_history.charges_base_amount%TYPE;
1780: l_debug_info VARCHAR2(240);
1781: l_api_name CONSTANT VARCHAR2(1000) := 'recon_payment_unclearing' ;
1782:
1783: l_org_id NUMBER;

Line 1822: FROM ap_payment_history_all APHA,

1818: APHA.charges_base_amount,
1819: C.check_id,
1820: NVL(c.amount, 0),
1821: c.org_id
1822: FROM ap_payment_history_all APHA,
1823: ap_checks_all C
1824: WHERE APHA.check_id = C.check_id
1825: AND C.checkrun_id = X_CHECKRUN_ID
1826: AND C.org_id = p_org_id -- Bug 5674397

Line 1833: FROM ap_payment_history APHB

1829: 'CLEARED BUT UNACCOUNTED',
1830: 'RECONCILED',
1831: 'RECONCILED UNACCOUNTED')
1832: AND NOT EXISTS (SELECT APHB.payment_history_id
1833: FROM ap_payment_history APHB
1834: WHERE APHB.check_id = APHA.check_id
1835: AND APHB.rev_pmt_hist_id = APHA.payment_history_id)
1836: GROUP BY
1837: APHA.payment_history_id,

Line 2026: FROM ap_payment_history

2022:
2023: --bugfix:2972765 added the following select and if statements.
2024: SELECT count(*)
2025: INTO l_dummy
2026: FROM ap_payment_history
2027: WHERE check_id=x_check_id
2028: AND transaction_type='PAYMENT CLEARING';
2029:
2030: --bugfix:5623562

Line 2080: FROM ap_payment_history APHA,

2076: l_ind_errors_base_amount,
2077: l_ind_charges_base_amount,
2078: l_check_amount,
2079: l_org_id
2080: FROM ap_payment_history APHA,
2081: ap_checks C
2082: WHERE APHA.check_id = X_CHECK_ID
2083: AND APHA.check_id = C.check_id
2084: AND APHA.transaction_type = 'PAYMENT CLEARING'

Line 2090: FROM ap_payment_history APHB

2086: 'CLEARED BUT UNACCOUNTED',
2087: 'RECONCILED',
2088: 'RECONCILED UNACCOUNTED')
2089: AND NOT EXISTS (SELECT APHB.payment_history_id
2090: FROM ap_payment_history APHB
2091: WHERE APHB.check_id = APHA.check_id
2092: AND APHB.rev_pmt_hist_id = APHA.payment_history_id);
2093:
2094: AP_RECONCILIATION_PKG.Insert_Payment_History

Line 2162: -- INSERT_PAYMENT_HISTORY : API to insert a row into the AP_Payment_History

2158: APP_EXCEPTION.RAISE_EXCEPTION;
2159: END Recon_Payment_Unclearing ;
2160:
2161: --============================================================================
2162: -- INSERT_PAYMENT_HISTORY : API to insert a row into the AP_Payment_History
2163: -- table.
2164: --
2165: -- Due to R12 SLA project impact, for every payment action, we will need
2166: -- to add the row in ap_payment_history

Line 2166: -- to add the row in ap_payment_history

2162: -- INSERT_PAYMENT_HISTORY : API to insert a row into the AP_Payment_History
2163: -- table.
2164: --
2165: -- Due to R12 SLA project impact, for every payment action, we will need
2166: -- to add the row in ap_payment_history
2167: -- in 11i - transaction types are
2168: -- PAYMENT MATURITY
2169: -- PAYMENT UNCLEARING
2170: -- PAYMENT CLEARING

Line 2297: FROM AP_Payment_History APH

2293: IF X_REV_PMT_HIST_ID IS NOT NULL THEN
2294:
2295: SELECT Accounting_Event_ID
2296: INTO l_related_event_id
2297: FROM AP_Payment_History APH
2298: WHERE APH.Payment_History_ID = X_REV_PMT_HIST_ID;
2299:
2300: END IF;
2301:

Line 2310: FROM AP_Payment_History APH

2306: 'REFUND ADJUSTED', 'MANUAL REFUND ADJUSTED') THEN --8449674 added refund adjusted
2307: BEGIN
2308: SELECT Accounting_Event_ID
2309: INTO l_related_event_id
2310: FROM AP_Payment_History APH
2311: WHERE APH.Check_ID = x_check_id
2312: AND APH.Transaction_Type =
2313: DECODE(X_Transaction_Type, 'PAYMENT ADJUSTED' ,'PAYMENT CREATED',
2314: 'MANUAL PAYMENT ADJUSTED', 'PAYMENT CREATED',

Line 2319: FROM AP_Payment_History APH1

2315: 'PAYMENT MATURITY ADJUSTED', 'PAYMENT MATURITY',
2316: 'PAYMENT CLEARING ADJUSTED', 'PAYMENT CLEARING',
2317: 'REFUND ADJUSTED', 'REFUND RECORDED', 'MANUAL REFUND ADJUSTED' ) --8449674
2318: AND NOT EXISTS (SELECT 'Reversal Pay Hist'
2319: FROM AP_Payment_History APH1
2320: WHERE APH1.Check_ID = x_check_id
2321: AND APH1.Rev_Pmt_Hist_ID = APH.Payment_History_ID)
2322: AND ROWNUM = 1;
2323: EXCEPTION

Line 2332: l_debug_info := 'Inserting into AP_Payment_History';

2328:
2329: ----------------------------------------------------------------
2330: -- Insert payment information into payment history table
2331: ----------------------------------------------------------------
2332: l_debug_info := 'Inserting into AP_Payment_History';
2333: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2335: END IF;
2336: ---------------------------------------------------------------

Line 2338: INSERT INTO AP_PAYMENT_HISTORY_ALL

2334: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2335: END IF;
2336: ---------------------------------------------------------------
2337:
2338: INSERT INTO AP_PAYMENT_HISTORY_ALL
2339: ( PAYMENT_HISTORY_ID,
2340: CHECK_ID,
2341: ACCOUNTING_DATE,
2342: TRANSACTION_TYPE,

Line 2378: ( AP_PAYMENT_HISTORY_S.nextval,

2374: RELATED_EVENT_ID, -- Bug 5015973
2375: invoice_adjustment_event_id -- bug 5694577
2376: )
2377: VALUES
2378: ( AP_PAYMENT_HISTORY_S.nextval,
2379: X_CHECK_ID,
2380: X_ACCOUNTING_DATE,
2381: X_TRANSACTION_TYPE,
2382: 'N',