APPS.INV_TRANSACTIONS_HISTORY_PKG dependencies on MTL_TXNS_HISTORY

Line 40: FROM MTL_TXNS_HISTORY

36:
37: --cursors
38: CURSOR txn_cur IS
39: SELECT transaction_id, transaction_status
40: FROM MTL_TXNS_HISTORY
41: WHERE document_type = p_txns_history_rec.document_type AND
42: document_number = p_txns_history_rec.document_number AND
43: document_direction = p_txns_history_rec.document_direction AND
44: action_type = p_txns_history_rec.action_type AND

Line 126: SELECT MTL_TXNS_HISTORY_S.nextval

122: -- Need to validate document_direction, entity_type, action_type
123: -- ctd.. transaction_status, document_type
124:
125:
126: SELECT MTL_TXNS_HISTORY_S.nextval
127: INTO x_transaction_id
128: FROM dual;
129:
130: if (g_debug = 1) then

Line 132: inv_trx_util_pub.TRACE('Inserting into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

128: FROM dual;
129:
130: if (g_debug = 1) then
131: inv_trx_util_pub.TRACE('Transaction ID is '|| x_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
132: inv_trx_util_pub.TRACE('Inserting into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
133: end if;
134:
135: INSERT INTO MTL_TXNS_HISTORY(
136: TRANSACTION_ID,

Line 135: INSERT INTO MTL_TXNS_HISTORY(

131: inv_trx_util_pub.TRACE('Transaction ID is '|| x_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
132: inv_trx_util_pub.TRACE('Inserting into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
133: end if;
134:
135: INSERT INTO MTL_TXNS_HISTORY(
136: TRANSACTION_ID,
137: DOCUMENT_TYPE,
138: DOCUMENT_NUMBER,
139: DOCUMENT_DIRECTION,

Line 222: inv_trx_util_pub.TRACE('Record inserted into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

218:
219: x_txns_id := x_transaction_id;
220:
221: if (g_debug = 1) then
222: inv_trx_util_pub.TRACE('Record inserted into MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
223: inv_trx_util_pub.TRACE('x_transaction_id is '||x_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
224: end if;
225:
226: ELSE

Line 232: inv_trx_util_pub.TRACE('Record already exists. So need to update in MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

228: if (g_debug = 1) then
229: inv_trx_util_pub.TRACE('transaction_id is ' || l_transaction_id, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
230: inv_trx_util_pub.TRACE('l_transaction_status is ' || l_transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
231: inv_trx_util_pub.TRACE('p_txns_history_rec.transaction_status is ' || p_txns_history_rec.transaction_status, 'INV_TRANSACTIONS_HISTORY_PKG', 9);
232: inv_trx_util_pub.TRACE('Record already exists. So need to update in MTL_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
233: end if;
234:
235: -- Record already exists. So Need to Update
236: -- Before Update Check for validity of status

Line 250: UPDATE MTL_TXNS_HISTORY

246: if (g_debug = 1) then
247: inv_trx_util_pub.TRACE('Updating MTL_XML_TXNS_HISTORY', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
248: end if;
249:
250: UPDATE MTL_TXNS_HISTORY
251: SET entity_number = p_txns_history_rec.entity_number,
252: entity_type = p_txns_history_rec.entity_type,
253: transaction_status = p_txns_history_rec.transaction_status,
254: ecx_message_id = p_txns_history_rec.ecx_message_id,

Line 284: inv_trx_util_pub.TRACE('MTL_TXNS_HISTORY record updated', 'INV_TRANSACTIONS_HISTORY_PKG', 9);

280: attribute15 = p_txns_history_rec.ATTRIBUTE15
281: WHERE transaction_id = l_transaction_id;
282:
283: if (g_debug = 1) then
284: inv_trx_util_pub.TRACE('MTL_TXNS_HISTORY record updated', 'INV_TRANSACTIONS_HISTORY_PKG', 9);
285: end if;
286:
287: if p_txns_history_rec.document_type ='ADJ' then --added for onhand
288: select count(*)

Line 415: FROM MTL_TXNS_HISTORY wth

411: wth.attribute13,
412: wth.attribute14,
413: wth.attribute15,
414: ''
415: FROM MTL_TXNS_HISTORY wth
416: WHERE wth.item_type = p_item_type
417: and wth.event_key = p_event_key
418: and wth.document_direction = p_direction
419: and wth.document_type = p_document_type