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 201: from rcv_transactions_interface

197: -- l_rti_row := RCV_TABLE_FUNCTIONS.get_rti_row_from_id( p_rti_id );
198:
199: select *
200: into l_rti_row
201: from rcv_transactions_interface
202: where interface_transaction_id = p_rti_id;
203:
204: -- default values
205: l_rt_row.user_entered_flag := 'Y';

Line 826: UPDATE rcv_transactions_interface

822: * as null since if the user has populated parent_transaction_id
823: * and parent_interface_txn_id, then we dont want to override
824: * it.
825: */
826: UPDATE rcv_transactions_interface
827: SET parent_transaction_id = l_rt_row.transaction_id
828: , shipment_line_id = l_rt_row.shipment_line_id
829: WHERE parent_interface_txn_id = l_rti_row.interface_transaction_id
830: AND parent_transaction_id IS NULL;

Line 972: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'

968: UPDATE po_note_references
969: SET table_name = 'RCV_TRANSACTIONS',
970: column_name = 'TRANSACTION_ID',
971: foreign_id = l_rt_row.transaction_id
972: WHERE table_name = 'RCV_TRANSACTIONS_INTERFACE'
973: AND column_name = 'INTERFACE_TRANSACTION_ID'
974: AND foreign_id = l_rti_row.interface_transaction_id;
975:
976: IF SQL%ROWCOUNT > 0 AND