APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on MTL_TRANSACTIONS_INTERFACE

Line 2762: -- mtl_transactions_interface ,mtl_serial_numbers_interface and

2758:
2759: --========================================================================
2760: -- PROCEDURE : Insert_inv_records
2761: -- This procedure inserts records into INV tables:
2762: -- mtl_transactions_interface ,mtl_serial_numbers_interface and
2763: -- mtl_transaction_lots_interface
2764: --
2765: -- PARAMETERS: p_start_index This is the start index of table
2766: -- p_mtl_txn_if_rec that should be used for

Line 2772: -- mtl_transactions_interface.

2768: -- p_end_index This is the end index of table
2769: -- p_mtl_txn_if_rec that should be used for
2770: -- bulk insert operations.
2771: -- p_mtl_txn_if_rec PLSQL table to be inserted into
2772: -- mtl_transactions_interface.
2773: -- p_mtl_ser_txn_if_rec PLSQL table to be inserted into
2774: -- mtl_serial_numbers_interface.
2775: -- p_mtl_lot_txn_if_rec PLSQL table to be inserted into
2776: -- mtl_transaction_lots_interface.

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

2821:
2822:
2823: SAVEPOINT sp_insert_inv_records;
2824:
2825: -- Bulk insert the INV information into mtl_transactions_interface
2826: IF (p_mtl_txn_if_rec.source_line_id.count > 0 ) THEN
2827: WSH_TRX_HANDLER.INSERT_ROW_BULK (
2828: p_start_index =>p_start_index,
2829: p_end_index =>p_end_index,

Line 4958: FROM mtl_transactions_interface mti,

4954: -- by other transaction. This can contain records that have errored in
4955: -- in the previous run
4956: CURSOR l_get_picking_ln_id_csr (p_batch_id IN NUMBER) IS
4957: SELECT mti.picking_line_id
4958: FROM mtl_transactions_interface mti,
4959: wsh_delivery_assignments_v da ,
4960: wsh_delivery_legs dg,
4961: wsh_new_deliveries dl,
4962: wsh_delivery_details wdd,

Line 5188: from mtl_transactions_interface mti

5184: last_updated_by = fnd_global.user_id
5185: where inv_interfaced_flag = 'P'
5186: and not exists (
5187: select picking_line_id
5188: from mtl_transactions_interface mti
5189: where source_line_id = mti.trx_source_line_id
5190: and mti.picking_line_id = dd.delivery_detail_id)
5191: and delivery_detail_id = l_detail_ids_tbl(i)
5192: and container_flag = 'N'

Line 5230: update mtl_transactions_interface

5226: --{
5227: --
5228: --
5229: FORALL i IN l_picking_line_id_tbl.first..l_picking_line_id_tbl.last
5230: update mtl_transactions_interface
5231: set transaction_header_id = l_transaction_header_id
5232: where picking_line_id = l_picking_line_id_tbl(i)
5233: and nvl(process_flag,1) <> 3
5234: and nvl(lock_flag,2) = 2;

Line 9705: -- mtl_transactions_interface

9701: -- the lines inserted into MTL interface tables to inventory.
9702: --
9703: -- PARAMETERS: p_batch_id ITS batch id.
9704: -- p_transaction_header_id The transaction header id for
9705: -- mtl_transactions_interface
9706: -- x_return_status The return status of the API.
9707: --
9708: -- COMMENT : Sets the inv_interfaced_flag for all the lines in the batch to
9709: -- 'P' then calls the inventories process_online. Then it calls