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.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on HXC_TRANSACTIONS

Line 2219: -- records details of a deposit transaction in HXC_TRANSACTIONS

2215: -- procedure
2216: -- audit_transaction
2217: --
2218: -- description
2219: -- records details of a deposit transaction in HXC_TRANSACTIONS
2220: --
2221: -- parameters
2222: -- p_effective_date - the effective date of the transaction
2223: -- p_transaction_type - deposit type (DEPOSIT/RETRIEVAL)

Line 2239: select hxc_transactions_s.nextval from dual;

2235:
2236: PRAGMA AUTONOMOUS_TRANSACTION;
2237:
2238: cursor c_transaction_sequence is
2239: select hxc_transactions_s.nextval from dual;
2240:
2241: cursor c_transaction_detail_sequence is
2242: select hxc_transaction_details_s.nextval from dual;
2243:

Line 2244: l_transaction_id hxc_transactions.transaction_id%TYPE;

2240:
2241: cursor c_transaction_detail_sequence is
2242: select hxc_transaction_details_s.nextval from dual;
2243:
2244: l_transaction_id hxc_transactions.transaction_id%TYPE;
2245: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;
2246: l_tx_ind BINARY_INTEGER;
2247:
2248: begin

Line 2253: insert into hxc_transactions

2249: open c_transaction_sequence;
2250: fetch c_transaction_sequence into l_transaction_id;
2251: close c_transaction_sequence;
2252:
2253: insert into hxc_transactions
2254: (transaction_id
2255: ,transaction_date
2256: ,type
2257: ,transaction_process_id