APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on MTL_TRANSACTIONS_INTERFACE

Line 2273: -- mtl_transactions_interface ,mtl_serial_numbers_interface and

2269:
2270: --========================================================================
2271: -- PROCEDURE : Insert_inv_records
2272: -- This procedure inserts records into INV tables:
2273: -- mtl_transactions_interface ,mtl_serial_numbers_interface and
2274: -- mtl_transaction_lots_interface
2275: --
2276: -- PARAMETERS: p_start_index This is the start index of table
2277: -- p_mtl_txn_if_rec that should be used for

Line 2283: -- mtl_transactions_interface.

2279: -- p_end_index This is the end index of table
2280: -- p_mtl_txn_if_rec that should be used for
2281: -- bulk insert operations.
2282: -- p_mtl_txn_if_rec PLSQL table to be inserted into
2283: -- mtl_transactions_interface.
2284: -- p_mtl_ser_txn_if_rec PLSQL table to be inserted into
2285: -- mtl_serial_numbers_interface.
2286: -- p_mtl_lot_txn_if_rec PLSQL table to be inserted into
2287: -- mtl_transaction_lots_interface.

Line 2336: -- Bulk insert the INV information into mtl_transactions_interface

2332:
2333:
2334: SAVEPOINT sp_insert_inv_records;
2335:
2336: -- Bulk insert the INV information into mtl_transactions_interface
2337: IF (p_mtl_txn_if_rec.source_line_id.count > 0 ) THEN
2338: WSH_TRX_HANDLER.INSERT_ROW_BULK (
2339: p_start_index =>p_start_index,
2340: p_end_index =>p_end_index,

Line 4046: FROM mtl_transactions_interface mti,

4042: -- by other transaction. This can contain records that have errored in
4043: -- in the previous run
4044: CURSOR l_get_picking_ln_id_csr (p_batch_id IN NUMBER) IS
4045: SELECT mti.picking_line_id
4046: FROM mtl_transactions_interface mti,
4047: wsh_delivery_assignments_v da ,
4048: wsh_delivery_legs dg,
4049: wsh_new_deliveries dl,
4050: wsh_trip_stops st

Line 4210: from mtl_transactions_interface mti

4206: set inv_interfaced_flag = 'N'
4207: where inv_interfaced_flag = 'P'
4208: and not exists (
4209: select picking_line_id
4210: from mtl_transactions_interface mti
4211: where source_line_id = mti.trx_source_line_id
4212: and mti.picking_line_id = dd.delivery_detail_id)
4213: and delivery_detail_id = l_detail_ids_tbl(i)
4214: and container_flag = 'N'

Line 4252: update mtl_transactions_interface

4248: --{
4249: --
4250: --
4251: FORALL i IN l_picking_line_id_tbl.first..l_picking_line_id_tbl.last
4252: update mtl_transactions_interface
4253: set transaction_header_id = l_transaction_header_id
4254: where picking_line_id = l_picking_line_id_tbl(i)
4255: and nvl(process_flag,1) <> 3
4256: and nvl(lock_flag,2) = 2;

Line 8327: -- mtl_transactions_interface

8323: -- the lines inserted into MTL interface tables to inventory.
8324: --
8325: -- PARAMETERS: p_batch_id ITS batch id.
8326: -- p_transaction_header_id The transaction header id for
8327: -- mtl_transactions_interface
8328: -- x_return_status The return status of the API.
8329: --
8330: -- COMMENT : Sets the inv_interfaced_flag for all the lines in the batch to
8331: -- 'P' then calls the inventories process_online. Then it calls