The OMI interface code consists of the following PL/SQL objects:
-
M_PCK_BOM_DOWNLOAD - The code for the export functionality in B.20.01.44.
-
M_PCK_OMI_UTL - Various auxiliary procedures and functions for OMI import. Implements the lock handling and provides the environment for SQL*Loader.
-
M_PCK_OMI_LOOKUP - Contains all internal lookup functions that the OMI main program uses.
-
M_PCK_BOM_LOAD - The OMI main program.
-
M_PCK_OMI_CUSTOM - This package provides the PL/SQL API for the OMI interface. Its package body is the only piece of OMI code that customers may modify.
-
M_PCK_PDS_BOM_IMPORT - This package reads and interprets the contents of the m_pds_raw_data table into which a PDS report is loaded initially, then transforms it into the native OMI format, and finally transfers it into table m_import_interfaces.