APPS.AP_RECONCILIATION_PKG dependencies on AP_CHECKS_ALL

Line 293: l_exchange_rate AP_CHECKS_ALL.EXCHANGE_RATE%TYPE;

289: l_debug_info VARCHAR2(240);
290: l_api_name CONSTANT VARCHAR2(1000) := 'Recon_Payment_Maturity' ;
291:
292: -- bug 9069767 starts
293: l_exchange_rate AP_CHECKS_ALL.EXCHANGE_RATE%TYPE;
294: l_exchange_date AP_CHECKS_ALL.EXCHANGE_DATE%TYPE;
295: l_exchange_rate_type AP_CHECKS_ALL.EXCHANGE_RATE_TYPE%TYPE;
296: -- bug 9069767 ends
297: BEGIN

Line 294: l_exchange_date AP_CHECKS_ALL.EXCHANGE_DATE%TYPE;

290: l_api_name CONSTANT VARCHAR2(1000) := 'Recon_Payment_Maturity' ;
291:
292: -- bug 9069767 starts
293: l_exchange_rate AP_CHECKS_ALL.EXCHANGE_RATE%TYPE;
294: l_exchange_date AP_CHECKS_ALL.EXCHANGE_DATE%TYPE;
295: l_exchange_rate_type AP_CHECKS_ALL.EXCHANGE_RATE_TYPE%TYPE;
296: -- bug 9069767 ends
297: BEGIN
298: current_calling_sequence := X_CALLING_SEQUENCE ||

Line 295: l_exchange_rate_type AP_CHECKS_ALL.EXCHANGE_RATE_TYPE%TYPE;

291:
292: -- bug 9069767 starts
293: l_exchange_rate AP_CHECKS_ALL.EXCHANGE_RATE%TYPE;
294: l_exchange_date AP_CHECKS_ALL.EXCHANGE_DATE%TYPE;
295: l_exchange_rate_type AP_CHECKS_ALL.EXCHANGE_RATE_TYPE%TYPE;
296: -- bug 9069767 ends
297: BEGIN
298: current_calling_sequence := X_CALLING_SEQUENCE ||
299: 'AP_RECONCILIATION_PKG.RECON_PAYMENT_MATURITY' ;

Line 357: FROM ap_checks_all

353: exchange_rate_type
354: INTO l_exchange_rate,
355: l_exchange_date,
356: l_exchange_rate_type
357: FROM ap_checks_all
358: WHERE check_id = X_CHECK_ID;
359: END IF;
360: */
361: --bug 9069767 ends

Line 587: FROM ap_checks_all c,

583: c.currency_code,
584: asp.base_currency_code,
585: asp.org_id,
586: nvl(asp.recon_accounting_flag, 'N')
587: FROM ap_checks_all c,
588: ap_system_parameters_all asp
589: WHERE c.checkrun_id = X_CHECKRUN_id
590: AND c.org_id = p_org_id
591: AND c.org_id = asp.org_id

Line 744: FROM ap_checks_all ac

740: exchange_rate
741: INTO l_pmt_to_base_xrate_date,
742: l_pmt_to_base_xrate_type,
743: l_pmt_to_base_xrate
744: FROM ap_checks_all ac
745: WHERE check_id = l_check_id;
746: END IF;
747: END IF;
748: -- bug8628166 - end

Line 1289: FROM ap_checks_all c,

1285: l_future_pay_flag,
1286: l_functional_currency_code,
1287: l_org_id,
1288: l_recon_accounting_flag
1289: FROM ap_checks_all c,
1290: ap_system_parameters_all asp
1291: WHERE c.check_id = X_CHECK_ID
1292: AND c.org_id = asp.org_id;
1293:

Line 1334: FROM ap_checks_all ac

1330: exchange_rate
1331: INTO l_pmt_to_base_xrate_date,
1332: l_pmt_to_base_xrate_type,
1333: l_pmt_to_base_xrate
1334: FROM ap_checks_all ac
1335: WHERE check_id = X_CHECK_ID;
1336: END IF;
1337: END IF;
1338: -- bug8628166 - end

Line 1823: ap_checks_all C

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
1827: AND APHA.transaction_type = 'PAYMENT CLEARING'

Line 2016: ap_checks_all ac

2012: --bugfix:5674397
2013: SELECT nvl(recon_accounting_flag, 'N')
2014: INTO l_recon_accounting_flag
2015: FROM ap_system_parameters_all asp,
2016: ap_checks_all ac
2017: WHERE asp.org_id = ac.org_id
2018: AND ac.check_id = X_CHECK_ID;
2019:
2020: --bugfix:5623562 -- 5674397

Line 2610: UPDATE ap_checks_all

2606: end if ;
2607:
2608: ----------------------------------------------------------------
2609: --bug 8545814
2610: UPDATE ap_checks_all
2611: SET CLEARED_AMOUNT = RU_CLEARED_AMOUNT,
2612: CLEARED_BASE_AMOUNT = RU_CLEARED_BASE_AMOUNT,
2613: CLEARED_ERROR_AMOUNT = RU_CLEARED_ERROR_AMOUNT,
2614: CLEARED_ERROR_BASE_AMOUNT = RU_CLEARED_ERROR_BASE_AMOUNT,