APPS.CE_BAT_API dependencies on CE_CASHFLOWS

Line 539: FROM ce_cashflows

535:
536: -- Fetch the cashflow ID If above case is true
537: SELECT CASHFLOW_ID
538: INTO L_CASHFLOW_ID
539: FROM ce_cashflows
540: WHERE bank_trxn_number = l_bank_trx_number AND statement_line_id IS NULL
541: AND cashflow_bank_account_id = p_source_ba_id
542: AND cashflow_date = l_trx_date
543: AND cashflow_amount = l_amount;

Line 551: UPDATE CE_CASHFLOWS

547: UPDATE CE_STATEMENT_LINES
548: SET CASHFLOW_ID = L_CASHFLOW_ID
549: WHERE STATEMENT_LINE_ID = p_statement_line_id;
550:
551: UPDATE CE_CASHFLOWS
552: SET STATEMENT_LINE_ID = p_statement_line_id
553: WHERE CASHFLOW_ID = L_CASHFLOW_ID;
554:
555: EXCEPTION

Line 1321: FROM ce_cashflows

1317: p_result OUT NOCOPY varchar2)
1318: IS
1319: CURSOR c_cashflows(p_pay_trxn_number NUMBER) IS
1320: SELECT cashflow_id
1321: FROM ce_cashflows
1322: WHERE trxn_reference_number=p_pay_trxn_number;
1323:
1324: l_cashflow_id1 NUMBER;
1325: l_cashflow_id2 NUMBER;

Line 1336: UPDATE ce_cashflows

1332: p_pay_trxn_number,
1333: 'REJECTED');
1334:
1335: log_msg(l_debug_proc,'Update cashflows status to CANCELED');
1336: UPDATE ce_cashflows
1337: SET cashflow_status_code='CANCELED'
1338: WHERE trxn_reference_number=p_pay_trxn_number;
1339:
1340: p_result := 'SUCCESS';

Line 1373: FROM ce_cashflows cf,

1369: l_err NUMBER;
1370:
1371: CURSOR cashflows_c (p_trxn_ref_number NUMBER) IS
1372: SELECT cf.cashflow_id
1373: FROM ce_cashflows cf,
1374: ce_payment_transactions pt
1375: WHERE cf.trxn_reference_number = pt.trxn_reference_number
1376: AND pt.trxn_status_code = 'SETTLED'
1377: AND cf.trxn_reference_number = p_trxn_ref_number;

Line 1386: FROM ce_cashflows a

1382: log_msg(l_debug_proc,'begin');
1383: -- Bug 10164596
1384: SELECT COUNT(*)
1385: INTO l_err
1386: FROM ce_cashflows a
1387: WHERE a.trxn_reference_number = p_pay_trxn_number
1388: AND((SELECT COUNT(*)
1389: FROM ce_cashflow_acct_h
1390: WHERE cashflow_id=a.cashflow_id

Line 1417: UPDATE ce_cashflows

1413: END LOOP;
1414: CLOSE cashflows_c;
1415:
1416: -- Update the cashflows status to CANCELED
1417: UPDATE ce_cashflows
1418: SET cashflow_status_code = 'CANCELED'
1419: WHERE trxn_reference_number = p_pay_trxn_number;
1420:
1421: -- Update the payment transaction status to CANCELED

Line 1550: FROM ce_cashflows

1546:
1547: CURSOR c_cashflows(p_trxn_ref_number NUMBER)
1548: IS
1549: SELECT cashflow_id
1550: FROM ce_cashflows
1551: WHERE trxn_Reference_number=p_trxn_ref_number;
1552:
1553: -- Bug 16402102: Added
1554: l_debug_proc VARCHAR2(30) := 'settle_transfer';

Line 1576: UPDATE ce_cashflows

1572: UPDATE ce_payment_transactions
1573: SET bank_trxn_number = p_payment_reference_number
1574: WHERE trxn_reference_number = p_pay_trxn_number;
1575:
1576: UPDATE ce_cashflows
1577: SET bank_trxn_number = p_payment_reference_number
1578: WHERE trxn_reference_number = p_pay_trxn_number;
1579: END IF;
1580: END IF;

Line 2270: UPDATE ce_cashflows

2266: -- call the XLA API to cancel the BAT
2267: CE_XLA_ACCT_EVENTS_PKG.create_event(l_cashflow_id,'CE_STMT_CANCELED');
2268:
2269: -- Update the cashflows status to CANCELED
2270: UPDATE ce_cashflows
2271: SET cashflow_status_code = 'CANCELED'
2272: WHERE cashflow_id = l_cashflow_id;
2273:
2274: /* bug 4997215 */

Line 2296: l_stmt_cashflow_id ce_cashflows.cashflow_id%type; -- 14731000 Added

2292: p_mode OUT NOCOPY VARCHAR2,
2293: p_cashflow_id1 OUT NOCOPY NUMBER,
2294: p_cashflow_id2 OUT NOCOPY NUMBER)
2295: IS
2296: l_stmt_cashflow_id ce_cashflows.cashflow_id%type; -- 14731000 Added
2297:
2298: -- Bug 16402102: Added
2299: l_debug_proc VARCHAR2(30) := 'create_update_cashflows';
2300: BEGIN

Line 2317: from ce_cashflows

2313: -- stamp cashflow_id in ce_statement_lines
2314: begin
2315: select cashflow_id
2316: into l_stmt_cashflow_id
2317: from ce_cashflows
2318: where trxn_reference_number = p_trxn_reference_number
2319: and statement_line_id = g_sl_statement_line_id;
2320: exception
2321: when no_data_found then