DBA Data[Home] [Help]

APPS.RCV_TRANSACTIONS_UTIL2 dependencies on MTL_TXNS_HISTORY

Line 64: update mtl_txns_history

60: EXCEPTION
61: WHEN update_history THEN
62:
63:
64: update mtl_txns_history
65: set transaction_status = 'ER'
66: where event_name = Item_type
67: and event_key = Item_key
68: and transaction_status = 'IP';

Line 78: update mtl_txns_history

74: raise;
75: WHEN OTHERS THEN
76:
77:
78: update mtl_txns_history
79: set transaction_status = 'ER'
80: where event_name = Item_type
81: and event_key = Item_key
82: and transaction_status = 'IP';

Line 172: update mtl_txns_history

168: EXCEPTION
169: WHEN update_history THEN
170:
171:
172: update mtl_txns_history
173: set transaction_status = 'ER'
174: where event_name = p_item_type
175: and event_key = p_item_key
176: and transaction_status = 'IP';

Line 186: update mtl_txns_history

182: ROLLBACK;
183: WHEN OTHERS THEN
184:
185:
186: update mtl_txns_history
187: set transaction_status = 'ER'
188: where event_name = p_item_type
189: and event_key = p_item_key
190: and transaction_status = 'IP';