DBA Data[Home] [Help]

APPS.RCV_INSERT_FROM_INL dependencies on RCV_TRANSACTIONS_INTERFACE

Line 89: update RCV_TRANSACTIONS_INTERFACE RTI

85:
86: if (currentLineGrpId <> -9999) then -- It is not the first record
87:
88: /*
89: update RCV_TRANSACTIONS_INTERFACE RTI
90: set PROCESSING_STATUS_CODE = 'PENDING'
91: where RTI.header_interface_id = ( select rhi.header_interface_id
92: from rcv_headers_interface rhi
93: where rhi.header_interface_id = rti.header_interface_id

Line 251: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

247: WHEN OTHERS THEN
248: l_primary_uom := NULL;
249: END;
250:
251: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
252: INTO l_interface_transaction_id
253: FROM dual;
254:
255: asn_debug.put_line ('interface id: '||l_interface_transaction_id);

Line 259: INSERT INTO rcv_transactions_interface

255: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
256: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
257: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);
258:
259: INSERT INTO rcv_transactions_interface
260: (interface_transaction_id, -- 01
261: group_id, -- 02
262: lpn_group_id, -- 03
263: transaction_type, -- 04