APPS.RCV_TRANSACTION_PROCESSOR dependencies on RCV_TRANSACTIONS_INTERFACE

Line 136: ( p_rti_id IN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE

132: RAISE;
133: END get_acct_period_status;
134:
135: PROCEDURE RVTTHIns
136: ( p_rti_id IN RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE
137: , p_transaction_type IN RCV_TRANSACTIONS.transaction_type%TYPE
138: , p_shipment_header_id IN RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
139: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
140: , p_primary_unit_of_measure IN RCV_TRANSACTIONS.primary_unit_of_measure%TYPE

Line 154: l_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;

150: , x_error_message OUT NOCOPY VARCHAR2
151: ) IS
152: l_rt_row RCV_TRANSACTIONS%ROWTYPE;
153: l_parent_row RCV_TRANSACTIONS%ROWTYPE;
154: l_rti_row RCV_TRANSACTIONS_INTERFACE%ROWTYPE;
155:
156: l_use_ship_to_flag VARCHAR2(1);
157: l_common_receiving BOOLEAN;
158:

Line 211: from rcv_transactions_interface

207: -- l_rti_row := RCV_TABLE_FUNCTIONS.get_rti_row_from_id( p_rti_id );
208:
209: select *
210: into l_rti_row
211: from rcv_transactions_interface
212: where interface_transaction_id = p_rti_id;
213:
214:
215: /*start of bug 13394743:get the latest price from PLL for PO transaction*/

Line 245: update rcv_transactions_interface

241: -- Change the price for this transaction
242: l_rti_row.po_unit_price := l_po_unit_price;
243:
244: -- Change price for later when calculate trx_cost when insert MMTT in rvtii
245: update rcv_transactions_interface
246: set po_unit_price = l_po_unit_price
247: where interface_transaction_id = l_rti_row.interface_transaction_id;
248: END IF;
249: END IF;

Line 902: UPDATE rcv_transactions_interface

898: * as null since if the user has populated parent_transaction_id
899: * and parent_interface_txn_id, then we dont want to override
900: * it.
901: */
902: UPDATE rcv_transactions_interface
903: SET parent_transaction_id = l_rt_row.transaction_id
904: , shipment_line_id = l_rt_row.shipment_line_id
905: WHERE parent_interface_txn_id = l_rti_row.interface_transaction_id
906: AND parent_transaction_id IS NULL;

Line 1048: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'

1044: UPDATE po_note_references
1045: SET table_name = 'RCV_TRANSACTIONS',
1046: column_name = 'TRANSACTION_ID',
1047: foreign_id = l_rt_row.transaction_id
1048: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'
1049: AND column_name = 'INTERFACE_TRANSACTION_ID'
1050: AND foreign_id = l_rti_row.interface_transaction_id;
1051:
1052: IF SQL%ROWCOUNT > 0 AND