APPS.EAM_MTL_TXN_PROCESS dependencies on INV_TRANSACTIONS

Line 406: INV_TRANSACTIONS.G_Header_ID := x_header_id;

402: x_header_id := p_txn_header_id;
403: end if;
404:
405:
406: INV_TRANSACTIONS.G_Header_ID := x_header_id;
407: INV_TRANSACTIONS.G_Interface_ID := x_header_id;
408:
409: if(p_serial_ctrl_code <> 1) then
410: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID

Line 407: INV_TRANSACTIONS.G_Interface_ID := x_header_id;

403: end if;
404:
405:
406: INV_TRANSACTIONS.G_Header_ID := x_header_id;
407: INV_TRANSACTIONS.G_Interface_ID := x_header_id;
408:
409: if(p_serial_ctrl_code <> 1) then
410: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID
411: from dual;

Line 410: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID

406: INV_TRANSACTIONS.G_Header_ID := x_header_id;
407: INV_TRANSACTIONS.G_Interface_ID := x_header_id;
408:
409: if(p_serial_ctrl_code <> 1) then
410: select mtl_material_transactions_s.nextval into INV_TRANSACTIONS.G_Serial_ID
411: from dual;
412: end if;
413:
414: if (l_slog) then FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_module,

Line 419: INV_TRANSACTIONS.Line_Interface_Insert(

415: 'Inserting into MTI with Tx Header ID=' || x_header_id);
416: end if;
417: /* Calling the Inventory Transaction API to insert data into MTI table .*/
418:
419: INV_TRANSACTIONS.Line_Interface_Insert(
420: p_item_id,
421: p_revision,
422: p_org_id,
423: p_trx_src_id,

Line 498: INV_TRANSACTIONS.LOT_INTERFACE_INSERT(

494: -- ------------------------------------------------------------------------------------
495:
496: if(p_lot_ctrl_code <> 1 and p_lot_num IS NOT NULL) then
497:
498: INV_TRANSACTIONS.LOT_INTERFACE_INSERT(
499: p_Transaction_Quantity => p_trx_qty,
500: p_Lot_Number => p_lot_num,
501: p_User_Id => p_user_id,
502: p_serial_number_control_code => p_serial_ctrl_code

Line 714: transaction_interface_id = INV_TRANSACTIONS.G_Header_Id ;

710: N_ATTRIBUTE8= l_n_attribute8 ,
711: N_ATTRIBUTE9= l_n_attribute9 ,
712: N_ATTRIBUTE10= l_n_attribute10
713: WHERE
714: transaction_interface_id = INV_TRANSACTIONS.G_Header_Id ;
715:
716: end if ; --end of if block for selecting and updating the values
717:
718: END; --end for Begin Block

Line 731: INV_TRANSACTIONS.SERIAL_INTERFACE_INSERT(

727:
728: if(p_serial_ctrl_code <> 1 and p_from_ser_number IS NOT NULL
729: and p_to_ser_number IS NOT NULL and p_serial_ctrl_code IS NOT NULL) then
730:
731: INV_TRANSACTIONS.SERIAL_INTERFACE_INSERT(
732: p_From_Serial => p_from_ser_number,
733: p_To_Serial => p_to_ser_number,
734: p_User_Id => p_user_id,
735: p_lot_control_code => p_lot_ctrl_code