Search Results get_substring

Overview

GMI_ITEM_WRP is a wrapper package in the Oracle EBS Process Manufacturing (OPM) schema, owned by APPS and classified as an "OTHER" API in ETRM. Its documented purpose is to provide a wrapper around the Inventory Item create API, allowing item records to be loaded from a flat file rather than through a direct programmatic call. The package exposes a file-driven interface: a caller supplies a directory, an input file, an output file, and a delimiter, and the package reads delimited input records, interprets each field, and passes the resulting values to the underlying item creation logic. This design is characteristic of OPM data-loading utilities, where integration and conversion routines must accept vendor or legacy extract files without requiring custom PL/SQL per source system. The header block identifies this as file GMIPITW.pls, originally created in February 1999 and upgraded to Release 11 in May 1999, reflecting the package's long-standing role in OPM item conversion and interface processing.

Key Procedures and Functions

ETRM documents four callable units across the package. Neither parameter lists nor return types are reproduced here beyond what the package specification declares.

• CREATE_ITEM — documented both as a procedure and as a function. This is the primary entry point. It consumes the directory, input file, output file, and delimiter arguments and drives the item creation process, reading delimited records and invoking the Inventory Item create API. The function form returns a VARCHAR2 value, which is conventionally used to signal the processing outcome to the caller; the procedure form performs the same work without returning a status to the calling block.
• GET_FIELD — a helper function that parses a delimited input line and returns the value of a specified field position. It accepts the line, the delimiter, and a field number, and is used internally by CREATE_ITEM to map positional columns in the input file to item attributes.
• GET_SUBSTRING — a utility function that accepts a substring value and returns a VARCHAR2 result. It supports value extraction or normalization during the parsing of input records.

Tables Accessed

ETRM records three referenced objects accessed through APPS synonyms.

• IC_ITEM_MST — the OPM item master. This is the principal target of Create_Item; new item definitions derived from the input file are established here.
• IC_ITEM_CPG — the OPM item cost planning group association table. Writes here link newly created items to their cost planning group context, which is required for costing and inventory valuation.
• UTL_FILE — the Oracle-supplied file I/O package. It is used to open, read, and write the input and output files named in the Create_Item arguments and to emit processing results or error messages to the designated output file.

Usage Notes

GMI_ITEM_WRP is typically invoked by a concurrent program or a custom conversion script that stages a delimited item file on an accessible database server directory. The directory, input file, and output file arguments must resolve to a valid UTL_FILE location, and the delimiter defaults to a comma when not supplied. Because the package relies on UTL_FILE, the operating system directory must be registered in the database and the concurrent manager or calling schema must hold the required file system privileges. ETRM records no packages that reference GMI_ITEM_WRP, indicating it is not consumed internally by other OPM APIs and is intended for direct external invocation. The architecture makes it unsuitable for row-by-row interactive use from a form; it is a batch-oriented utility suited to data migration, supplier or item master loads, and legacy conversions. Input files should be validated for column order, since GET_FIELD resolves values by position rather than by named header.