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 1479: check_status CE_LOOKUPS.lookup_code%TYPE;

1475: X_bank_currency_code VARCHAR2,
1476: pgroup_id VARCHAR2 DEFAULT NULL -- FOR SEPA ER 6700007
1477: ) IS
1478: check_id AP_CHECKS_ALL.check_id%TYPE;
1479: check_status CE_LOOKUPS.lookup_code%TYPE;
1480: amount_cleared AP_CHECKS_ALL.cleared_amount%TYPE;
1481: auto_reconciled_flag VARCHAR2(1);
1482: batch_trx_type varchar2(30);
1483: batch_app_id number;

Line 1785: cleared_trx_type CE_LOOKUPS.lookup_code%TYPE;

1781: X_float_handling_flag VARCHAR2,
1782: X_currency_code VARCHAR2,
1783: X_bank_trx_number VARCHAR2,
1784: X_reversed_receipt_flag VARCHAR2) IS
1785: cleared_trx_type CE_LOOKUPS.lookup_code%TYPE;
1786: cleared_trx_id CE_STATEMENT_RECONCILS_ALL.reference_id%TYPE;
1787: clearing_flag VARCHAR2(1) := 'N';
1788: clearing_sign NUMBER;
1789: x_trx_id NUMBER;

Line 2197: cleared_trx_type CE_LOOKUPS.lookup_code%TYPE;

2193: X_float_handling_flag VARCHAR2,
2194: X_reversed_receipt_flag VARCHAR2,
2195: X_org_id NUMBER DEFAULT NULL,
2196: X_legal_entity_id NUMBER DEFAULT NULL) IS
2197: cleared_trx_type CE_LOOKUPS.lookup_code%TYPE;
2198: cleared_trx_id CE_STATEMENT_RECONCILS_ALL.reference_id%TYPE;
2199: clearing_flag VARCHAR2(1) := 'N';
2200: X_RESULT VARCHAR2(100);
2201: X_RECONCILED_METHOD VARCHAR2(1);