The API consists of two packages.
The first package is m_pck_omi_utl, which must not be modified at all. This package provides the create_job procedure, which inserts a job definition record into the OMI job table and returns the internal identifier of this job to the caller, and the write_omi_log procedure, which allows you to insert status records in the OMI protocol table from within your own event procedures in m_pck_omi_custom. The package also provides two procedures to delete OMI job data: the m_pck_omi_utl.clear_job_data procedure performs the action behind the Clear Import Data button on the B.40.01 screen; the m_pck_omi_utl.clear_job procedure deletes the complete OMI job from the database. Both procedures return the number of deleted records back to the caller via the p_cnt IN/OUT parameter.
The second package body is m_pck_omi_custom. The omi_load procedure in this package is the place where the PL/SQL code for a custom loading program can be implemented. Furthermore, the package body also contains templates for the supported event procedures with an empty execution block (that is, with a BEGIN NULL; END; block).