APPS.HXC_TIMECARD_AUDIT dependencies on HXC_TRANSACTION_DETAILS

Line 106: select hxc_transaction_details_s.nextval from dual;

102:
103: l_index NUMBER;
104:
105: cursor c_transaction_detail_sequence is
106: select hxc_transaction_details_s.nextval from dual;
107:
108: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;
109:
110: Begin

Line 108: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;

104:
105: cursor c_transaction_detail_sequence is
106: select hxc_transaction_details_s.nextval from dual;
107:
108: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;
109:
110: Begin
111:
112: l_index := p_transaction_info.first;

Line 121: insert into hxc_transaction_details

117: open c_transaction_detail_sequence;
118: fetch c_transaction_detail_sequence into l_transaction_detail_id;
119: close c_transaction_detail_sequence;
120:
121: insert into hxc_transaction_details
122: (transaction_detail_id
123: ,time_building_block_id
124: ,transaction_id
125: ,created_by