APPS.RCV_TRANSACTIONS_HISTORY_PKG dependencies on RCV_TRANSACTIONS

Line 1: PACKAGE BODY rcv_transactions_history_pkg as

1: PACKAGE BODY rcv_transactions_history_pkg as
2: /* $Header: RCVTXHSB.pls 120.0.12010000.11 2010/04/13 11:23:19 smididud noship $ */
3:
4: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790
5:

Line 7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'RCV_TRANSACTIONS_HISTORY_PKG';

3:
4: g_asn_debug VARCHAR2(1) := asn_debug.is_debug_on; -- Bug 9152790
5:
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'RCV_TRANSACTIONS_HISTORY_PKG';
8: --
9:
10: PROCEDURE Create_Update_Txns_History(
11: p_txns_history_rec IN OUT NOCOPY Txns_History_Record_Type,

Line 303: UPDATE rcv_transactions rt

299: IF (g_asn_debug = 'Y') THEN
300: asn_debug.put_line('LSP : Updating RT.receipt_confirmation_extracted to Y');
301: END IF;
302:
303: UPDATE rcv_transactions rt
304: SET rt.receipt_confirmation_extracted = 'Y',
305: rt.xml_document_id = p_txns_history_rec.document_number
306: WHERE rt.shipment_header_id = p_txns_history_rec.document_number
307: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'P'

Line 311: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

307: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'P'
308: AND xml_document_id is null
309: AND (rt.TRANSACTION_TYPE = 'DELIVER' OR
310: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
311: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
312: WHERE rt.parent_transaction_id = rt2.transaction_id
313: AND rt2.transaction_type = 'DELIVER')
314: ) OR
315: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 316: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

312: WHERE rt.parent_transaction_id = rt2.transaction_id
313: AND rt2.transaction_type = 'DELIVER')
314: ) OR
315: (rt.TRANSACTION_TYPE IN ('CORRECT')
316: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
317: WHERE rt.parent_transaction_id = rt3.transaction_id
318: AND rt3.transaction_type = 'RETURN TO RECEIVING')
319: )
320: )

Line 332: UPDATE rcv_transactions rt

328: asn_debug.put_line('Distributed : Updating RT.receipt_confirmation_extracted to Y');
329: END IF;
330:
331:
332: UPDATE rcv_transactions rt
333: SET rt.receipt_confirmation_extracted = 'Y',
334: rt.xml_document_id = p_txns_history_rec.document_number
335: WHERE rt.shipment_header_id = p_txns_history_rec.document_number
336: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'P'

Line 340: AND EXISTS (SELECT '1' FROM rcv_transactions rt2

336: AND nvl(rt.receipt_confirmation_extracted, 'N') = 'P'
337: and xml_document_id is null
338: AND (rt.TRANSACTION_TYPE = 'DELIVER' OR
339: (rt.TRANSACTION_TYPE IN ('CORRECT', 'RETURN TO RECEIVING')
340: AND EXISTS (SELECT '1' FROM rcv_transactions rt2
341: WHERE rt.parent_transaction_id = rt2.transaction_id
342: AND rt2.transaction_type = 'DELIVER')
343: ) OR
344: (rt.TRANSACTION_TYPE IN ('CORRECT')

Line 345: AND EXISTS (SELECT '1' FROM rcv_transactions rt3

341: WHERE rt.parent_transaction_id = rt2.transaction_id
342: AND rt2.transaction_type = 'DELIVER')
343: ) OR
344: (rt.TRANSACTION_TYPE IN ('CORRECT')
345: AND EXISTS (SELECT '1' FROM rcv_transactions rt3
346: WHERE rt.parent_transaction_id = rt3.transaction_id
347: AND rt3.transaction_type = 'RETURN TO RECEIVING')
348: )
349: );

Line 504: END RCV_TRANSACTIONS_HISTORY_PKG;

500: asn_debug.put_line('Unexpected error has occured. Oracle error message is '|| SQLERRM);
501: END IF;
502: END Get_Txns_History;
503:
504: END RCV_TRANSACTIONS_HISTORY_PKG;