eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RCV_TRANSACTIONS_HISTORY_PKG dependencies on MTL_TXNS_HISTORY

Line 39: FROM MTL_TXNS_HISTORY

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

Line 135: SELECT MTL_TXNS_HISTORY_S.nextval

131: -- Need to validate document_direction, entity_type, action_type
132: -- ctd.. transaction_status, document_type
133:
134:
135: SELECT MTL_TXNS_HISTORY_S.nextval
136: INTO x_transaction_id
137: FROM dual;
138:
139: IF (g_asn_debug = 'Y') THEN

Line 141: asn_debug.put_line('Inserting into MTL_TXNS_HISTORY');

137: FROM dual;
138:
139: IF (g_asn_debug = 'Y') THEN
140: asn_debug.put_line('Transaction ID is '|| x_transaction_id);
141: asn_debug.put_line('Inserting into MTL_TXNS_HISTORY');
142: END IF;
143:
144:
145: INSERT INTO MTL_TXNS_HISTORY(

Line 145: INSERT INTO MTL_TXNS_HISTORY(

141: asn_debug.put_line('Inserting into MTL_TXNS_HISTORY');
142: END IF;
143:
144:
145: INSERT INTO MTL_TXNS_HISTORY(
146: TRANSACTION_ID,
147: DOCUMENT_TYPE,
148: DOCUMENT_NUMBER,
149: DOCUMENT_DIRECTION,

Line 230: asn_debug.put_line('Record inserted into MTL_TXNS_HISTORY');

226:
227: x_txns_id := x_transaction_id;
228:
229: IF (g_asn_debug = 'Y') THEN
230: asn_debug.put_line('Record inserted into MTL_TXNS_HISTORY');
231: asn_debug.put_line('x_transaction_id is '||x_transaction_id);
232: END IF;
233:
234: ELSE

Line 240: asn_debug.put_line('Record already exists. So need to update in MTL_TXNS_HISTORY');

236: IF (g_asn_debug = 'Y') THEN
237: asn_debug.put_line('transaction_id is ' || l_transaction_id);
238: asn_debug.put_line('l_transaction_status is ' || l_transaction_status);
239: asn_debug.put_line('p_txns_history_rec.transaction_status is ' || p_txns_history_rec.transaction_status);
240: asn_debug.put_line('Record already exists. So need to update in MTL_TXNS_HISTORY');
241: END IF;
242:
243: -- Record already exists. So Need to Update
244: -- Before Update Check for validity of status

Line 255: asn_debug.put_line('Updating MTL_TXNS_HISTORY');

251:
252: END IF; -- if l_transaction_status checks
253:
254: IF (g_asn_debug = 'Y') THEN
255: asn_debug.put_line('Updating MTL_TXNS_HISTORY');
256: END IF;
257:
258:
259: UPDATE MTL_TXNS_HISTORY

Line 259: UPDATE MTL_TXNS_HISTORY

255: asn_debug.put_line('Updating MTL_TXNS_HISTORY');
256: END IF;
257:
258:
259: UPDATE MTL_TXNS_HISTORY
260: SET entity_number = p_txns_history_rec.entity_number,
261: entity_type = p_txns_history_rec.entity_type,
262: transaction_status = p_txns_history_rec.transaction_status,
263: event_name = p_txns_history_rec.event_name,

Line 291: asn_debug.put_line('MTL_TXNS_HISTORY record updated');

287: attribute15 = p_txns_history_rec.ATTRIBUTE15
288: WHERE transaction_id = l_transaction_id;
289:
290: IF (g_asn_debug = 'Y') THEN
291: asn_debug.put_line('MTL_TXNS_HISTORY record updated');
292: END IF;
293:
294:
295: IF (l_xml_document_id is null) THEN

Line 454: FROM MTL_TXNS_HISTORY wth

450: wth.attribute13,
451: wth.attribute14,
452: wth.attribute15,
453: wth.client_code
454: FROM MTL_TXNS_HISTORY wth
455: WHERE wth.item_type = p_item_type
456: and wth.event_key = p_event_key
457: and wth.document_direction = p_direction
458: and wth.document_type = p_document_type