APPS.CE_AUTO_BANK_CLEAR1 dependencies on CE_STATEMENT_RECONCILS_ALL

Line 189: FROM ce_statement_recon_gt_v rec, --ce_statement_reconcils_all rec,

185: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.check_matching_status');
186: END IF;
187: SELECT crh.status
188: INTO x_status
189: FROM ce_statement_recon_gt_v rec, --ce_statement_reconcils_all rec,
190: ar_cash_receipt_history_all crh,
191: ar_cash_receipts_all cr
192: WHERE rec.current_record_flag = 'Y' AND
193: rec.status_flag = 'M' AND

Line 239: FROM CE_STATEMENT_RECONCILS_ALL

235: END IF;
236:
237: SELECT count(*)
238: INTO c_count_reconciled
239: FROM CE_STATEMENT_RECONCILS_ALL
240: WHERE statement_line_id = X_statement_line_id
241: AND current_record_flag = 'Y'
242: AND status_flag = 'M';
243:

Line 1749: cep_standard.debug('update ce_statement_reconcils_all');

1745: end if;
1746: ------------------------------------
1747: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436677
1748: IF l_DEBUG in ('Y', 'C') THEN
1749: cep_standard.debug('update ce_statement_reconcils_all');
1750: END IF;
1751: --update ce_statement_reconciliations r
1752: update ce_statement_reconcils_all r
1753: set amount =

Line 1752: update ce_statement_reconcils_all r

1748: IF l_DEBUG in ('Y', 'C') THEN
1749: cep_standard.debug('update ce_statement_reconcils_all');
1750: END IF;
1751: --update ce_statement_reconciliations r
1752: update ce_statement_reconcils_all r
1753: set amount =
1754: (select DECODE(c.currency_code,
1755: X_bank_currency_code, c.cleared_amount,
1756: nvl(c.cleared_base_amount, c.cleared_amount*CE_AUTO_BANK_CLEAR.G_exchange_rate))

Line 1817: cleared_trx_id CE_STATEMENT_RECONCILS_ALL.reference_id%TYPE;

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;
1821: x_trx_amount NUMBER;

Line 2065: cep_standard.debug('update ce_statement_reconcils_all');

2061: END IF;
2062: end if;
2063: -- Need to calculate cleared amount, x_amount_cleared, here.
2064: IF l_DEBUG in ('Y', 'C') THEN
2065: cep_standard.debug('update ce_statement_reconcils_all');
2066: END IF;
2067: --update ce_statement_reconciliations
2068: update ce_statement_reconcils_all
2069: set current_record_flag = 'N'

Line 2068: update ce_statement_reconcils_all

2064: IF l_DEBUG in ('Y', 'C') THEN
2065: cep_standard.debug('update ce_statement_reconcils_all');
2066: END IF;
2067: --update ce_statement_reconciliations
2068: update ce_statement_reconcils_all
2069: set current_record_flag = 'N'
2070: where statement_line_id in
2071: (x_trx_id, CE_AUTO_BANK_MATCH.csl_statement_line_id)
2072: and reference_type = tx_type

Line 2100: -- CE_STATEMENT_RECONCILS_ALL

2096: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then
2097:
2098: -- bug 3252844 reconciled amount is duplicated because the
2099: -- the reconciled PAYMENT amount is negative on
2100: -- CE_STATEMENT_RECONCILS_ALL
2101:
2102: x_trx_amount3 := CE_AUTO_BANK_MATCH.corr_csl_amount;
2103:
2104: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then

Line 2135: cep_standard.debug('update ce_statement_reconcils_all');

2131: Y_amount => x_trx_amount3);
2132: --Y_amount => CE_AUTO_BANK_MATCH.corr_csl_amount);
2133: else /* CE_AUTO_BANK_MATCH.reconciled_this_run = 'Y' */
2134: IF l_DEBUG in ('Y', 'C') THEN
2135: cep_standard.debug('update ce_statement_reconcils_all');
2136: END IF;
2137: --update ce_statement_reconciliations
2138: update ce_statement_reconcils_all
2139: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,

Line 2138: update ce_statement_reconcils_all

2134: IF l_DEBUG in ('Y', 'C') THEN
2135: cep_standard.debug('update ce_statement_reconcils_all');
2136: END IF;
2137: --update ce_statement_reconciliations
2138: update ce_statement_reconcils_all
2139: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,
2140: amount = x_trx_amount3
2141: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2142: where statement_line_id = x_trx_id

Line 2237: cleared_trx_id CE_STATEMENT_RECONCILS_ALL.reference_id%TYPE;

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);
2241: current_org_id NUMBER;