304: x_header_id := p_txn_header_id;
305: end if;
306:
307:
308: INV_TRANSACTIONS.G_Header_ID := x_header_id;
309: INV_TRANSACTIONS.G_Interface_ID := x_header_id;
310:
311: if(p_serial_ctrl_code <> 1) then
312: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID
305: end if;
306:
307:
308: INV_TRANSACTIONS.G_Header_ID := x_header_id;
309: INV_TRANSACTIONS.G_Interface_ID := x_header_id;
310:
311: if(p_serial_ctrl_code <> 1) then
312: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID
313: from dual;
308: INV_TRANSACTIONS.G_Header_ID := x_header_id;
309: INV_TRANSACTIONS.G_Interface_ID := x_header_id;
310:
311: if(p_serial_ctrl_code <> 1) then
312: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID
313: from dual;
314: end if;
315:
316: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,
317: 'Inserting into MTI with Tx Header ID=' || x_header_id);
318: end if;
319: /* Calling the Inventory Transaction API to insert data into MTI table .*/
320:
321: INV_TRANSACTIONS.Line_Interface_Insert(
322: p_item_id,
323: p_revision,
324: p_org_id,
325: p_trx_src_id,
378: -- ------------------------------------------------------------------------------------
379:
380: if(p_lot_ctrl_code <> 1 and p_lot_num IS NOT NULL) then
381:
382: INV_TRANSACTIONS.LOT_INTERFACE_INSERT(
383: p_Transaction_Quantity => p_trx_qty,
384: p_Lot_Number => p_lot_num,
385: p_User_Id => p_user_id,
386: p_serial_number_control_code => p_serial_ctrl_code
395:
396: if(p_serial_ctrl_code <> 1 and p_from_ser_number IS NOT NULL
397: and p_to_ser_number IS NOT NULL and p_serial_ctrl_code IS NOT NULL) then
398:
399: INV_TRANSACTIONS.SERIAL_INTERFACE_INSERT(
400: p_From_Serial => p_from_ser_number,
401: p_To_Serial => p_to_ser_number,
402: p_User_Id => p_user_id,
403: p_lot_control_code => p_lot_ctrl_code