APPS.RCV_TRX_INTERFACE_TRX_UPD_PKG dependencies on RCV_TRANSACTIONS_INTERFACE

Line 5: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS

1: PACKAGE BODY RCV_TRX_INTERFACE_TRX_UPD_PKG as
2: /* $Header: RCVTIR6B.pls 120.0.12020000.4 2013/01/31 03:45:12 wayin ship $ */
3:
4: PROCEDURE update_rcv_transaction (
5: rcv_trx IN OUT NOCOPY rcv_transactions_interface%ROWTYPE) IS
6:
7: X_rowid ROWID;
8: X_progress VARCHAR2(4) := '000';
9:

Line 19: FROM rcv_transactions_interface

15: X_progress := '010';
16:
17: SELECT rowid
18: INTO X_Rowid
19: FROM rcv_transactions_interface
20: WHERE interface_transaction_id = rcv_trx.interface_transaction_id;
21:
22: /*
23: ** Update the columns of the transaction

Line 175: UPDATE rcv_transactions_interface

171: PROCEDURE roi_update_rti_rhi(p_rti_id IN NUMBER,
172: p_success_flag IN OUT NOCOPY NUMBER) IS
173: BEGIN
174: -- update the current RTI and its parent RTIs
175: UPDATE rcv_transactions_interface
176: SET request_id = NULL,
177: processing_request_id = NULL,
178: order_transaction_id = NULL,
179: primary_quantity = NULL,

Line 187: FROM rcv_transactions_interface rti

183: transaction_status_code = 'PENDING',
184: processing_mode_code = 'BATCH'
185: WHERE interface_transaction_id IN
186: (SELECT interface_transaction_id
187: FROM rcv_transactions_interface rti
188: START WITH rti.interface_transaction_id = p_rti_id
189: CONNECT BY PRIOR rti.parent_interface_txn_id =
190: rti.interface_transaction_id);
191:

Line 198: FROM rcv_transactions_interface

194: receipt_header_id = NULL,
195: processing_status_code = 'PENDING'
196: WHERE header_interface_id IN
197: (SELECT header_interface_id
198: FROM rcv_transactions_interface
199: START WITH interface_transaction_id = p_rti_id
200: CONNECT BY PRIOR
201: parent_interface_txn_id = interface_transaction_id);
202: p_success_flag := 0;