APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on HXC_TRANSACTION_DETAILS

Line 2242: select hxc_transaction_details_s.nextval from dual;

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:
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;

Line 2245: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;

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
2249: open c_transaction_sequence;

Line 2286: insert into hxc_transaction_details

2282: open c_transaction_detail_sequence;
2283: fetch c_transaction_detail_sequence into l_transaction_detail_id;
2284: close c_transaction_detail_sequence;
2285:
2286: insert into hxc_transaction_details
2287: (transaction_detail_id
2288: ,time_building_block_id
2289: ,transaction_id
2290: ,created_by

Line 2931: from hxc_transaction_details

2927: cursor c_tx_id
2928: (p_tbb_id in number,
2929: p_tbb_ovn in number) is
2930: select transaction_id
2931: from hxc_transaction_details
2932: where time_building_block_id = p_tbb_id
2933: and object_version_number = p_tbb_ovn;
2934:
2935:

Line 2936: TYPE r_tbb_vs_txd IS RECORD ( txd_id hxc_transaction_details.transaction_detail_id%TYPE );

2932: where time_building_block_id = p_tbb_id
2933: and object_version_number = p_tbb_ovn;
2934:
2935:
2936: TYPE r_tbb_vs_txd IS RECORD ( txd_id hxc_transaction_details.transaction_detail_id%TYPE );
2937:
2938: TYPE t_tbb_vs_txd IS TABLE OF r_tbb_vs_txd INDEX BY BINARY_INTEGER;
2939:
2940: t_tbb_vs_txds t_tbb_vs_txd;