APPS.AHL_CMP_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 54: -- Function : This procedure will insert data into interface table MTL_TRANSACTIONS_INTERFACE

50: ------------------------------------------------------------------------------------------------------
51: -- Start of Comments
52: -- Procedure name : Insert_Mtl_Txn_Intf
53: -- Type : Private
54: -- Function : This procedure will insert data into interface table MTL_TRANSACTIONS_INTERFACE
55: -- Pre-reqs :
56: -- Parameters :
57: --
58: -- Insert_Mtl_Txn_Intf Parameters

Line 197: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv

193:
194: --Query to get the error messages
195: CURSOR Txn_Error_Cur(p_txn_Id NUMBER) IS
196: SELECT intf.ERROR_EXPLANATION ,intf.ERROR_CODE, kfv.concatenated_segments
197: FROM MTL_TRANSACTIONS_INTERFACE INTF, mtl_system_items_kfv kfv
198: WHERE TRANSACTION_INTERFACE_ID = p_txn_Id
199: AND intf.inventory_item_id = kfv.inventory_item_id
200: AND intf.organization_id = kfv.organization_id ;
201:

Line 1116: INSERT INTO MTL_TRANSACTIONS_INTERFACE

1112: ||to_char(p_x_txn_intf_id)||']');
1113: END IF;
1114:
1115:
1116: INSERT INTO MTL_TRANSACTIONS_INTERFACE
1117:
1118: ( TRANSACTION_INTERFACE_ID , TRANSACTION_HEADER_ID ,
1119: SOURCE_CODE , SOURCE_LINE_ID ,
1120: SOURCE_HEADER_ID, PROCESS_FLAG ,