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 8: G_sl_description CE_STATEMENT_LINES.trx_text%TYPE := NULL;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

65: G_bat_receipt_offset_ccid CE_PAYMENT_TRANSACTIONS.receipt_offset_ccid%TYPE
66: := NULL;
67: G_bat_amount NUMBER := NULL;
68: G_bat_date DATE := NULL;
69: G_bat_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
70: G_bat_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE := 'PAYMENT';
71: G_bat_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
72: G_bat_anticipated_date DATE := NULL;
73: G_cashflows_created_flag VARCHAR2(1) := 'N';

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

66: := NULL;
67: G_bat_amount NUMBER := NULL;
68: G_bat_date DATE := NULL;
69: G_bat_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
70: G_bat_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE := 'PAYMENT';
71: G_bat_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
72: G_bat_anticipated_date DATE := NULL;
73: G_cashflows_created_flag VARCHAR2(1) := 'N';
74: G_multi_currency_flag VARCHAR2(1) := 'N';

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

67: G_bat_amount NUMBER := NULL;
68: G_bat_date DATE := NULL;
69: G_bat_currency_code CE_STATEMENT_LINES.currency_code%TYPE := NULL;
70: G_bat_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE := 'PAYMENT';
71: G_bat_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE := NULL;
72: G_bat_anticipated_date DATE := NULL;
73: G_cashflows_created_flag VARCHAR2(1) := 'N';
74: G_multi_currency_flag VARCHAR2(1) := 'N';
75:

Line 330: ce_statement_lines sl

326: G_sl_description,
327: G_sl_bank_trx_number,
328: G_sl_currency_code
329: FROM
330: ce_statement_lines sl
331: WHERE
332: sl.statement_line_id = p_statement_line_id;
333:
334: G_bat_settle_flag := 'N';

Line 1228: l_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE;

1224:
1225: PROCEDURE populate_transfer (p_pay_trxn_number OUT NOCOPY NUMBER)
1226: IS
1227: l_settle_flag VARCHAR2(2);
1228: l_created_from_dir CE_STATEMENT_LINES.trx_type%TYPE;
1229: l_row_id ROWID;
1230: BEGIN
1231:
1232: log('>> populate_transfer...');

Line 1880: UPDATE ce_statement_lines

1876: WHERE cashflow_id = l_cashflow_id;
1877:
1878: /*bug4997215*/
1879: -- Update statement line to nullify the cashflow id
1880: UPDATE ce_statement_lines
1881: SET cashflow_id = null,
1882: je_status_flag = null
1883: WHERE cashflow_id = l_cashflow_id;
1884: p_result := 'SUCCESS';

Line 1910: UPDATE ce_statement_lines

1906: p_mode,
1907: p_cashflow_id1,
1908: p_cashflow_id2);
1909:
1910: UPDATE ce_statement_lines
1911: set cashflow_id=p_cashflow_id1
1912: WHERE statement_line_id=G_sl_statement_line_id;
1913:
1914: log('<<..create_update_cashflows');