DBA Data[Home] [Help]

APPS.RCV_INSERT_FROM_INL dependencies on RCV_TRANSACTIONS_INTERFACE

Line 90: update RCV_TRANSACTIONS_INTERFACE RTI

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

Line 277: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL

273: l_secondary_uom := NULL;
274: END;
275:
276:
277: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL
278: INTO l_interface_transaction_id
279: FROM dual;
280:
281: asn_debug.put_line ('interface id: '||l_interface_transaction_id);

Line 285: INSERT INTO rcv_transactions_interface

281: asn_debug.put_line ('interface id: '||l_interface_transaction_id);
282: asn_debug.put_line ('lcm line id: '||p_int_rec(i).interface_source_line_id);
283: asn_debug.put_line ('landed cost: '||p_int_rec(i).unit_landed_cost);
284:
285: INSERT INTO rcv_transactions_interface
286: (interface_transaction_id, -- 01
287: group_id, -- 02
288: lpn_group_id, -- 03
289: transaction_type, -- 04