DBA Data[Home] [Help]

APPS.INV_TRANSACTIONS_UTIL2 dependencies on MTL_TXNS_HISTORY

Line 125: update mtl_txns_history

121:
122: EXCEPTION
123: WHEN update_history THEN
124:
125: update mtl_txns_history
126: set transaction_status = 'ER'
127: where event_name = Item_type
128: and event_key = Item_key
129: and transaction_status = 'IP';

Line 139: update mtl_txns_history

135: end if;
136: raise;
137: WHEN OTHERS THEN
138:
139: update mtl_txns_history
140: set transaction_status = 'ER'
141: where event_name = Item_type
142: and event_key = Item_key
143: and transaction_status = 'IP';

Line 236: update mtl_txns_history

232:
233: EXCEPTION
234: WHEN update_history THEN
235:
236: update mtl_txns_history
237: set transaction_status = 'ER'
238: where event_name = p_item_type
239: and event_key = p_item_key
240: and transaction_status = 'IP';

Line 249: update mtl_txns_history

245: end if;
246: ROLLBACK;
247: WHEN OTHERS THEN
248:
249: update mtl_txns_history
250: set transaction_status = 'ER'
251: where event_name = p_item_type
252: and event_key = p_item_key
253: and transaction_status = 'IP';