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 2343: insert into hxc_transaction_details

2339: ,p_transaction_tab(l_tx_ind).status
2340: ,p_transaction_tab(l_tx_ind).exception_desc
2341: );
2342: ELSE
2343: insert into hxc_transaction_details
2344: (transaction_detail_id
2345: ,time_building_block_id
2346: ,transaction_id
2347: ,created_by

Line 3187: from hxc_transaction_details

3183: cursor c_tx_id
3184: (p_tbb_id in number,
3185: p_tbb_ovn in number) is
3186: select transaction_id
3187: from hxc_transaction_details
3188: where time_building_block_id = p_tbb_id
3189: and object_version_number = p_tbb_ovn;
3190:
3191:

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

3188: where time_building_block_id = p_tbb_id
3189: and object_version_number = p_tbb_ovn;
3190:
3191:
3192: TYPE r_tbb_vs_txd IS RECORD ( txd_id hxc_transaction_details.transaction_detail_id%TYPE );
3193:
3194: TYPE t_tbb_vs_txd IS TABLE OF r_tbb_vs_txd INDEX BY BINARY_INTEGER;
3195:
3196: t_tbb_vs_txds t_tbb_vs_txd;