APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on HXC_TRANSACTIONS

Line 2220: -- records details of a retrieval transaction in HXC_TRANSACTIONS

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

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 2279: insert into hxc_transactions

2275: ,null
2276: ,p_overall_status
2277: );
2278: ELSE
2279: insert into hxc_transactions
2280: (transaction_id
2281: ,transaction_date
2282: ,type
2283: ,transaction_process_id