APPS.CE_AUTO_BANK_CLEAR1 dependencies on CE_LOOKUPS

Line 532: receipt_status CE_LOOKUPS.lookup_code%TYPE;

528: X_float_handling_flag VARCHAR2) IS
529: receipt_id AR_CASH_RECEIPTS_ALL.cash_receipt_id%TYPE;
530: receipt_history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
531: receipt_type AR_CASH_RECEIPTS_ALL.type%TYPE;
532: receipt_status CE_LOOKUPS.lookup_code%TYPE;
533: receipt_date DATE;
534: receipt_gl_date DATE;
535: amount_to_clear NUMBER;
536: trx_amount NUMBER;

Line 1505: check_status CE_LOOKUPS.lookup_code%TYPE;

1501: X_bank_currency_code VARCHAR2,
1502: pgroup_id VARCHAR2 DEFAULT NULL -- FOR SEPA ER 6700007
1503: ) IS
1504: check_id AP_CHECKS_ALL.check_id%TYPE;
1505: check_status CE_LOOKUPS.lookup_code%TYPE;
1506: amount_cleared AP_CHECKS_ALL.cleared_amount%TYPE;
1507: auto_reconciled_flag VARCHAR2(1);
1508: batch_trx_type varchar2(30);
1509: batch_app_id number;

Line 1816: cleared_trx_type CE_LOOKUPS.lookup_code%TYPE;

1812: X_float_handling_flag VARCHAR2,
1813: X_currency_code VARCHAR2,
1814: X_bank_trx_number VARCHAR2,
1815: X_reversed_receipt_flag VARCHAR2) IS
1816: cleared_trx_type CE_LOOKUPS.lookup_code%TYPE;
1817: cleared_trx_id CE_STATEMENT_RECONCILS_ALL.reference_id%TYPE;
1818: clearing_flag VARCHAR2(1) := 'N';
1819: clearing_sign NUMBER;
1820: x_trx_id NUMBER;

Line 2236: cleared_trx_type CE_LOOKUPS.lookup_code%TYPE;

2232: X_reversed_receipt_flag VARCHAR2,
2233: X_org_id NUMBER DEFAULT NULL,
2234: X_legal_entity_id NUMBER DEFAULT NULL
2235: ) IS
2236: cleared_trx_type CE_LOOKUPS.lookup_code%TYPE;
2237: cleared_trx_id CE_STATEMENT_RECONCILS_ALL.reference_id%TYPE;
2238: clearing_flag VARCHAR2(1) := 'N';
2239: X_RESULT VARCHAR2(100);
2240: X_RECONCILED_METHOD VARCHAR2(1);