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_RECONCILIATION_PKG

Line 1: PACKAGE BODY AP_RECONCILIATION_PKG as

1: PACKAGE BODY AP_RECONCILIATION_PKG as
2: /* $Header: apreconb.pls 120.22 2006/12/20 20:16:15 lxzhang noship $ */
3:
4: --============================================================================
5: -- POSSIBLE SCENARIOS ON HOW THIS API MAY BE CALLED:

Line 118: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_HISTORY' ;

114: l_debug_info VARCHAR2(240);
115: BEGIN
116:
117: current_calling_sequence := X_CALLING_SEQUENCE ||
118: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_HISTORY' ;
119:
120: -- Check if all required data is passed
121:
122: l_debug_info := 'Check for required info';

Line 146: AP_RECONCILIATION_PKG.Recon_Payment_Maturity

142: IF X_TRANSACTION_TYPE IN ('PAYMENT MATURITY' ,
143: 'PAYMENT MATURITY REVERSAL' ) THEN
144: l_debug_info := 'Payment Maturity';
145:
146: AP_RECONCILIATION_PKG.Recon_Payment_Maturity
147: ( X_CHECK_ID,
148: X_ACCOUNTING_DATE,
149: X_TRANSACTION_TYPE,
150: X_TRANSACTION_AMOUNT,

Line 169: AP_RECONCILIATION_PKG.Recon_Payment_Clearing

165:
166: ELSIF X_TRANSACTION_TYPE IN ('PAYMENT CLEARING' ) THEN
167:
168: l_debug_info := 'Payment Clearing';
169: AP_RECONCILIATION_PKG.Recon_Payment_Clearing
170: ( X_CHECKRUN_ID,
171: X_CHECK_ID,
172: X_ACCOUNTING_DATE,
173: X_CLEARED_DATE,

Line 197: AP_RECONCILIATION_PKG.Recon_Payment_Unclearing

193: X_CALLING_SEQUENCE ) ;
194:
195: ELSIF X_TRANSACTION_TYPE IN ('PAYMENT UNCLEARING' ) THEN
196: l_debug_info := 'Payment Unclearing';
197: AP_RECONCILIATION_PKG.Recon_Payment_Unclearing
198: ( X_CHECKRUN_ID,
199: X_CHECK_ID,
200: X_ACCOUNTING_DATE,
201: X_TRANSACTION_TYPE,

Line 265: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_MATURITY' ;

261: l_debug_info VARCHAR2(240);
262:
263: BEGIN
264: current_calling_sequence := X_CALLING_SEQUENCE ||
265: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_MATURITY' ;
266:
267: IF (x_transaction_type IN ('PAYMENT MATURITY', -- Bug3343314
268: 'PAYMENT MATURITY REVERSAL')) THEN -- Bug3343314
269:

Line 301: AP_RECONCILIATION_PKG.Insert_Payment_History

297: X_Transaction_Amount*X_Exchange_Rate,
298: l_functional_currency_code );
299: l_debug_info := 'Insert Payment History';
300:
301: AP_RECONCILIATION_PKG.Insert_Payment_History
302: ( X_CHECK_ID => X_CHECK_ID,
303: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
304: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
305: X_TRX_BANK_AMOUNT => NULL,

Line 370: 'AP_RECONCILIATION_PKG.DELETE_PAYMENT_MATURITY' ;

366: l_debug_info VARCHAR2(240);
367:
368: BEGIN
369: current_calling_sequence := X_CALLING_SEQUENCE ||
370: 'AP_RECONCILIATION_PKG.DELETE_PAYMENT_MATURITY' ;
371: l_debug_info := 'Deleting from Payment History table';
372:
373: DELETE FROM AP_PAYMENT_HISTORY
374: WHERE check_id = x_check_id

Line 513: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_CLEARING' ;

509: ORDER BY nvl(c.amount,0);
510:
511: BEGIN
512: current_calling_sequence := X_CALLING_SEQUENCE ||
513: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_CLEARING' ;
514:
515:
516: --bugfix:5623562
517: --bug 5674397. Comment the following section

Line 756: AP_RECONCILIATION_PKG.Insert_Payment_History

752: --IF Check_Not_Accounted_To_Cash(l_check_id) THEN
753: -- Commenting condition for bug 2626686 as accounting is now created correctly
754: l_debug_info := 'Inside International, Negotiable, before insert';
755:
756: AP_RECONCILIATION_PKG.Insert_Payment_History
757: ( X_CHECK_ID => l_check_id,
758: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
759: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
760: X_TRX_BANK_AMOUNT => l_trx_base_amount,

Line 814: AP_RECONCILIATION_PKG.Insert_Payment_History

810: --IF Check_Not_Accounted_To_Cash(l_check_id) THEN
811: -- Commenting condition for bug 2626686 as accounting is now created correctly
812: l_debug_info := 'Insert history for Negotiable, Foreign';
813:
814: AP_RECONCILIATION_PKG.Insert_Payment_History
815: ( X_CHECK_ID => l_check_id,
816: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
817: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
818: X_TRX_BANK_AMOUNT => l_check_amount

Line 867: AP_RECONCILIATION_PKG.Insert_Payment_History

863: --IF Check_Not_Accounted_To_Cash(l_check_id) THEN
864: -- Commenting condition for bug 2626686 as accounting is now created correctly
865: l_debug_info := 'Inside Negotiable, Domestic, before Insert';
866:
867: AP_RECONCILIATION_PKG.Insert_Payment_History
868: ( X_CHECK_ID => l_check_id,
869: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
870: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
871: X_TRX_BANK_AMOUNT => l_check_amount

Line 1140: AP_RECONCILIATION_PKG.Insert_Payment_History

1136: -- Bug 2276503
1137: --IF Check_Not_Accounted_To_Cash(l_check_id) THEN
1138: -- Commenting condition for bug 2626686 as accounting is now created correctly
1139: l_debug_info := 'Negotiable, International, before Insert';
1140: AP_RECONCILIATION_PKG.Insert_Payment_History
1141: ( X_CHECK_ID => X_check_id,
1142: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1143: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
1144: X_TRX_BANK_AMOUNT => l_trx_base_amount,

Line 1198: AP_RECONCILIATION_PKG.Insert_Payment_History

1194: --IF Check_Not_Accounted_To_Cash(l_check_id) THEN
1195: -- Commenting condition for bug 2626686 as accounting is now created correctly
1196: l_debug_info := 'Negotiable, Foreign, before Insert';
1197:
1198: AP_RECONCILIATION_PKG.Insert_Payment_History
1199: ( X_CHECK_ID => X_check_id,
1200: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1201: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
1202: X_TRX_BANK_AMOUNT => l_check_amount

Line 1251: AP_RECONCILIATION_PKG.Insert_Payment_History

1247: --IF Check_Not_Accounted_To_Cash(l_check_id) THEN
1248: -- Commenting condition for bug 2626686 as accounting is now created correctly
1249: l_debug_info := 'Negotiable, Domestic, before Insert';
1250:
1251: AP_RECONCILIATION_PKG.Insert_Payment_History
1252: ( X_CHECK_ID => X_check_id,
1253: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1254: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,
1255: X_TRX_BANK_AMOUNT => l_check_amount

Line 1538: X_CALLING_SEQUENCE || 'AP_RECONCILIATION_PKG.recon_payment_unclearing';

1534:
1535: BEGIN
1536:
1537: current_calling_sequence :=
1538: X_CALLING_SEQUENCE || 'AP_RECONCILIATION_PKG.recon_payment_unclearing';
1539:
1540:
1541: IF (X_CHECKRUN_ID IS NOT NULL) THEN
1542:

Line 1602: AP_RECONCILIATION_PKG.insert_payment_history

1598: END IF;
1599: END IF;
1600: l_debug_info := 'Inside recon_payment_unclearing, before insert';
1601:
1602: AP_RECONCILIATION_PKG.insert_payment_history
1603: (
1604: X_CHECK_ID => l_check_id,
1605: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1606: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,

Line 1746: AP_RECONCILIATION_PKG.Insert_Payment_History

1742: FROM ap_payment_history APHB
1743: WHERE APHB.check_id = APHA.check_id
1744: AND APHB.rev_pmt_hist_id = APHA.payment_history_id);
1745:
1746: AP_RECONCILIATION_PKG.Insert_Payment_History
1747: (
1748: X_CHECK_ID => X_check_id,
1749: X_TRANSACTION_TYPE => X_TRANSACTION_TYPE,
1750: X_ACCOUNTING_DATE => X_ACCOUNTING_DATE,

Line 1879: 'AP_RECONCILIATION_PKG.insert_payment_history<-'||X_Calling_Sequence;

1875: BEGIN
1876: -- Update the calling sequence
1877: --
1878: current_calling_sequence :=
1879: 'AP_RECONCILIATION_PKG.insert_payment_history<-'||X_Calling_Sequence;
1880:
1881: -- Bug 3343314
1882: ---------------------------------------------------------------
1883: -- Create accounting event if event id is null

Line 2278: END AP_RECONCILIATION_PKG;

2274:
2275: END CASE_TYPE;
2276:
2277:
2278: END AP_RECONCILIATION_PKG;