eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_BAT_API dependencies on CE_STATEMENT_LINES

Line 7: G_sl_description CE_STATEMENT_LINES.trx_text%TYPE := NULL;

3:
4: -- Statement lines
5: G_sl_trx_date DATE := NULL;
6: G_sl_value_date DATE := NULL;
7: G_sl_description CE_STATEMENT_LINES.trx_text%TYPE := NULL;
8: G_sl_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
9: G_sl_amount CE_STATEMENT_LINES.amount%TYPE := NULL;
10: G_sl_original_amount CE_STATEMENT_LINES.original_amount%TYPE := NULL;
11: G_sl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;

Line 8: G_sl_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;

4: -- Statement lines
5: G_sl_trx_date DATE := NULL;
6: G_sl_value_date DATE := NULL;
7: G_sl_description CE_STATEMENT_LINES.trx_text%TYPE := NULL;
8: G_sl_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
9: G_sl_amount CE_STATEMENT_LINES.amount%TYPE := NULL;
10: G_sl_original_amount CE_STATEMENT_LINES.original_amount%TYPE := NULL;
11: G_sl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
12: G_sl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE := NULL;

Line 9: G_sl_amount CE_STATEMENT_LINES.amount%TYPE := NULL;

5: G_sl_trx_date DATE := NULL;
6: G_sl_value_date DATE := NULL;
7: G_sl_description CE_STATEMENT_LINES.trx_text%TYPE := NULL;
8: G_sl_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
9: G_sl_amount CE_STATEMENT_LINES.amount%TYPE := NULL;
10: G_sl_original_amount CE_STATEMENT_LINES.original_amount%TYPE := NULL;
11: G_sl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
12: G_sl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE := NULL;
13: G_sl_trx_type CE_STATEMENT_LINES.trx_type%TYPE := NULL;

Line 10: G_sl_original_amount CE_STATEMENT_LINES.original_amount%TYPE := NULL;

6: G_sl_value_date DATE := NULL;
7: G_sl_description CE_STATEMENT_LINES.trx_text%TYPE := NULL;
8: G_sl_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
9: G_sl_amount CE_STATEMENT_LINES.amount%TYPE := NULL;
10: G_sl_original_amount CE_STATEMENT_LINES.original_amount%TYPE := NULL;
11: G_sl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
12: G_sl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE := NULL;
13: G_sl_trx_type CE_STATEMENT_LINES.trx_type%TYPE := NULL;
14:

Line 11: G_sl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;

7: G_sl_description CE_STATEMENT_LINES.trx_text%TYPE := NULL;
8: G_sl_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
9: G_sl_amount CE_STATEMENT_LINES.amount%TYPE := NULL;
10: G_sl_original_amount CE_STATEMENT_LINES.original_amount%TYPE := NULL;
11: G_sl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
12: G_sl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE := NULL;
13: G_sl_trx_type CE_STATEMENT_LINES.trx_type%TYPE := NULL;
14:
15: -- Bank accounts

Line 12: G_sl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE := NULL;

8: G_sl_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
9: G_sl_amount CE_STATEMENT_LINES.amount%TYPE := NULL;
10: G_sl_original_amount CE_STATEMENT_LINES.original_amount%TYPE := NULL;
11: G_sl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
12: G_sl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE := NULL;
13: G_sl_trx_type CE_STATEMENT_LINES.trx_type%TYPE := NULL;
14:
15: -- Bank accounts
16: G_source_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;

Line 13: G_sl_trx_type CE_STATEMENT_LINES.trx_type%TYPE := NULL;

9: G_sl_amount CE_STATEMENT_LINES.amount%TYPE := NULL;
10: G_sl_original_amount CE_STATEMENT_LINES.original_amount%TYPE := NULL;
11: G_sl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
12: G_sl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE := NULL;
13: G_sl_trx_type CE_STATEMENT_LINES.trx_type%TYPE := NULL;
14:
15: -- Bank accounts
16: G_source_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;
17: G_destination_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE := NULL;

Line 58: G_bat_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;

54:
55: -- Transfer
56: G_bat_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%TYPE := NULL;
57: G_bat_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%TYPE := NULL;
58: G_bat_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
59: G_bat_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
60: G_bat_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE := 'PAYMENT';
61: G_sl_cashflow_direction VARCHAR2(30) := NULL;
62: G_bat_settle_flag VARCHAR2(10) := NULL;

Line 59: G_bat_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;

55: -- Transfer
56: G_bat_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%TYPE := NULL;
57: G_bat_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%TYPE := NULL;
58: G_bat_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
59: G_bat_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
60: G_bat_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE := 'PAYMENT';
61: G_sl_cashflow_direction VARCHAR2(30) := NULL;
62: G_bat_settle_flag VARCHAR2(10) := NULL;
63: G_bat_status VARCHAR2(30) := NULL;

Line 60: G_bat_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE := 'PAYMENT';

56: G_bat_payment_offset_ccid CE_PAYMENT_TRANSACTIONS.payment_offset_ccid%TYPE := NULL;
57: G_bat_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%TYPE := NULL;
58: G_bat_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
59: G_bat_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
60: G_bat_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE := 'PAYMENT';
61: G_sl_cashflow_direction VARCHAR2(30) := NULL;
62: G_bat_settle_flag VARCHAR2(10) := NULL;
63: G_bat_status VARCHAR2(30) := NULL;
64: G_bat_authorize_flag VARCHAR2(10) := NULL;

Line 401: FROM ce_statement_lines sl

397: G_sl_value_date,
398: G_sl_description,
399: G_sl_bank_trx_number,
400: G_sl_currency_code
401: FROM ce_statement_lines sl
402: WHERE sl.statement_line_id = p_statement_line_id;
403:
404: G_bat_settle_flag := 'N';
405: G_bat_amount := NVL(G_sl_original_amount,G_sl_amount);

Line 472: l_bank_trx_number ce_statement_lines.bank_trx_number%TYPE;

468: p_result OUT NOCOPY varchar2)
469: IS
470: l_cnt NUMBER;
471: -- Bug 9354284 Start
472: l_bank_trx_number ce_statement_lines.bank_trx_number%TYPE;
473: l_stmt_header_id ce_statement_lines.Statement_header_id%TYPE;
474: l_amount ce_statement_lines.amount%TYPE;
475: l_trx_date ce_statement_lines.trx_date%TYPE;
476: l_cashflow_id ce_statement_lines.cashflow_id%TYPE;

Line 473: l_stmt_header_id ce_statement_lines.Statement_header_id%TYPE;

469: IS
470: l_cnt NUMBER;
471: -- Bug 9354284 Start
472: l_bank_trx_number ce_statement_lines.bank_trx_number%TYPE;
473: l_stmt_header_id ce_statement_lines.Statement_header_id%TYPE;
474: l_amount ce_statement_lines.amount%TYPE;
475: l_trx_date ce_statement_lines.trx_date%TYPE;
476: l_cashflow_id ce_statement_lines.cashflow_id%TYPE;
477: -- Bug 9354284 End

Line 474: l_amount ce_statement_lines.amount%TYPE;

470: l_cnt NUMBER;
471: -- Bug 9354284 Start
472: l_bank_trx_number ce_statement_lines.bank_trx_number%TYPE;
473: l_stmt_header_id ce_statement_lines.Statement_header_id%TYPE;
474: l_amount ce_statement_lines.amount%TYPE;
475: l_trx_date ce_statement_lines.trx_date%TYPE;
476: l_cashflow_id ce_statement_lines.cashflow_id%TYPE;
477: -- Bug 9354284 End
478:

Line 475: l_trx_date ce_statement_lines.trx_date%TYPE;

471: -- Bug 9354284 Start
472: l_bank_trx_number ce_statement_lines.bank_trx_number%TYPE;
473: l_stmt_header_id ce_statement_lines.Statement_header_id%TYPE;
474: l_amount ce_statement_lines.amount%TYPE;
475: l_trx_date ce_statement_lines.trx_date%TYPE;
476: l_cashflow_id ce_statement_lines.cashflow_id%TYPE;
477: -- Bug 9354284 End
478:
479: -- Bug 9650263

Line 476: l_cashflow_id ce_statement_lines.cashflow_id%TYPE;

472: l_bank_trx_number ce_statement_lines.bank_trx_number%TYPE;
473: l_stmt_header_id ce_statement_lines.Statement_header_id%TYPE;
474: l_amount ce_statement_lines.amount%TYPE;
475: l_trx_date ce_statement_lines.trx_date%TYPE;
476: l_cashflow_id ce_statement_lines.cashflow_id%TYPE;
477: -- Bug 9354284 End
478:
479: -- Bug 9650263
480: CURSOR c_stmt_lines(c_stmt_line_id number) IS

Line 482: FROM ce_statement_lines

478:
479: -- Bug 9650263
480: CURSOR c_stmt_lines(c_stmt_line_id number) IS
481: SELECT bank_trx_number,statement_header_id,amount,trx_date
482: FROM ce_statement_lines
483: WHERE statement_line_id = c_stmt_line_id;
484:
485: -- Bug 16402102: Added
486: l_debug_proc VARCHAR2(30) := 'check_duplicate';

Line 547: UPDATE CE_STATEMENT_LINES

543: AND cashflow_amount = l_amount;
544: log_msg(l_debug_proc,'L_CASHFLOW_ID = ' || L_CASHFLOW_ID);
545:
546: -- Stamp the Cashflow ID and Statement Line Id in the respective tables
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

Line 1450: l_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE;

1446:
1447: PROCEDURE populate_transfer (p_pay_trxn_number OUT NOCOPY NUMBER)
1448: IS
1449: l_settle_flag VARCHAR2(2);
1450: l_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE;
1451: l_row_id ROWID;
1452:
1453: -- Bug 16402102: Added
1454: l_debug_proc VARCHAR2(30) := 'populate_transfer';

Line 2276: UPDATE ce_statement_lines

2272: WHERE cashflow_id = l_cashflow_id;
2273:
2274: /* bug 4997215 */
2275: -- Update statement line to nullify the cashflow id
2276: UPDATE ce_statement_lines
2277: SET cashflow_id = null,
2278: je_status_flag = null
2279: WHERE cashflow_id = l_cashflow_id;
2280: p_result := 'SUCCESS';

Line 2313: -- stamp cashflow_id in ce_statement_lines

2309:
2310: log_msg(l_debug_proc,'p_cashflow_id1='||p_cashflow_id1||', p_cashflow_id2='||p_cashflow_id2);
2311:
2312: -- 14731000 start
2313: -- stamp cashflow_id in ce_statement_lines
2314: begin
2315: select cashflow_id
2316: into l_stmt_cashflow_id
2317: from ce_cashflows

Line 2326: update ce_statement_lines

2322: l_stmt_cashflow_id := NULL;
2323: end;
2324: log_msg(l_debug_proc,'l_stmt_cashflow_id='||l_stmt_cashflow_id);
2325:
2326: update ce_statement_lines
2327: set cashflow_id = l_stmt_cashflow_id
2328: where statement_line_id=g_sl_statement_line_id;
2329: -- 14731000 end
2330: