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 1718: cep_standard.debug('update ce_statement_reconcils_all');

1714: end if;
1715: ------------------------------------
1716: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436677
1717: IF l_DEBUG in ('Y', 'C') THEN
1718: cep_standard.debug('update ce_statement_reconcils_all');
1719: END IF;
1720: --update ce_statement_reconciliations r
1721: update ce_statement_reconcils_all r
1722: set amount =

Line 1721: update ce_statement_reconcils_all r

1717: IF l_DEBUG in ('Y', 'C') THEN
1718: cep_standard.debug('update ce_statement_reconcils_all');
1719: END IF;
1720: --update ce_statement_reconciliations r
1721: update ce_statement_reconcils_all r
1722: set amount =
1723: (select DECODE(c.currency_code,
1724: X_bank_currency_code, c.cleared_amount,
1725: nvl(c.cleared_base_amount, c.cleared_amount*CE_AUTO_BANK_CLEAR.G_exchange_rate))

Line 1786: cleared_trx_id CE_STATEMENT_RECONCILS_ALL.reference_id%TYPE;

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

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

2024: END IF;
2025: end if;
2026: -- Need to calculate cleared amount, x_amount_cleared, here.
2027: IF l_DEBUG in ('Y', 'C') THEN
2028: cep_standard.debug('update ce_statement_reconcils_all');
2029: END IF;
2030: --update ce_statement_reconciliations
2031: update ce_statement_reconcils_all
2032: set current_record_flag = 'N'

Line 2031: update ce_statement_reconcils_all

2027: IF l_DEBUG in ('Y', 'C') THEN
2028: cep_standard.debug('update ce_statement_reconcils_all');
2029: END IF;
2030: --update ce_statement_reconciliations
2031: update ce_statement_reconcils_all
2032: set current_record_flag = 'N'
2033: where statement_line_id in
2034: (x_trx_id, CE_AUTO_BANK_MATCH.csl_statement_line_id)
2035: and reference_type = tx_type

Line 2063: -- CE_STATEMENT_RECONCILS_ALL

2059: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT') then
2060:
2061: -- bug 3252844 reconciled amount is duplicated because the
2062: -- the reconciled PAYMENT amount is negative on
2063: -- CE_STATEMENT_RECONCILS_ALL
2064:
2065: x_trx_amount3 := CE_AUTO_BANK_MATCH.corr_csl_amount;
2066:
2067: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then

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

2094: Y_amount => x_trx_amount3);
2095: --Y_amount => CE_AUTO_BANK_MATCH.corr_csl_amount);
2096: else /* CE_AUTO_BANK_MATCH.reconciled_this_run = 'Y' */
2097: IF l_DEBUG in ('Y', 'C') THEN
2098: cep_standard.debug('update ce_statement_reconcils_all');
2099: END IF;
2100: --update ce_statement_reconciliations
2101: update ce_statement_reconcils_all
2102: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,

Line 2101: update ce_statement_reconcils_all

2097: IF l_DEBUG in ('Y', 'C') THEN
2098: cep_standard.debug('update ce_statement_reconcils_all');
2099: END IF;
2100: --update ce_statement_reconciliations
2101: update ce_statement_reconcils_all
2102: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,
2103: amount = x_trx_amount3
2104: --amount = CE_AUTO_BANK_MATCH.corr_csl_amount
2105: where statement_line_id = x_trx_id

Line 2198: cleared_trx_id CE_STATEMENT_RECONCILS_ALL.reference_id%TYPE;

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