Search Results gmo_instruction_tbl_type

Overview

GMO_DATATYPES_GRP is a PL/SQL specification-only package (a "group" or "GRP"-classified object) in the APPS schema of Oracle E-Business Suite, belonging to the GMO module — the Oracle Process Manufacturing (OPM) / Enterprise Territory and Recipe Management family of applications. As its name and header indicate (the source file GMOGDTPS.pls, dated 2005, with the "noship" flag), the package functions purely as a type repository. It defines no executable business logic or API procedures; instead, it centralizes common PL/SQL record and collection type definitions that are shared across the GMO subsystem's other packages and objects. By housing these reusable datatypes in a single compilation unit, GMO avoids redundant, inconsistent type declarations across its codebase and provides a stable contract for inter-package data exchange. Nine other packages reference GMO_DATATYPES_GRP, confirming its role as a foundational dependency within the module.

Key Procedures and Functions

The documented metadata lists zero procedures or functions. This is consistent with the source excerpt, which contains only TYPE declarations and no callable subprograms. The package instead publishes the following public datatype definitions:

• CONTEXT_PARAMS_REC_TYPE and CONTEXT_PARAMS_TBL_TYPE — a record pairing a NAME (VARCHAR2(200)) with a VALUE (VARCHAR2(400)), and an associative-array collection (indexed by BINARY_INTEGER) of that record, used to pass name/value context parameter sets.
• GMO_TABLE_OF_VARCHAR2_255 — a table of VARCHAR2(255) values, a generic string collection for lists of text items.
• GMO_DEFINITION_PARAM_REC_TYPE and GMO_DEFINITION_PARAM_TBL_TYPE — a record of NAME (VARCHAR2(100)) and VALUE (VARCHAR2(1000)) with a corresponding collection type, intended to carry definition parameters.
• GMO_INSTRUCTION_REC_TYPE and GMO_INSTRUCTION_TBL_TYPE — a record capturing instruction data (INSTRUCTION_ID, INSTRUCTION_SET_ID, INSTRUCTION_TEXT, TASK_NAME, TASK_ATTRIBUTE, TASK_DISPLAY_NAME) with an associated collection, supporting the transfer of instruction/task data structures between program units.

Tables Accessed

No tables are referenced. Because the package consists solely of type declarations, it issues no SQL against any base table or APPS synonym. The record structures it defines describe data that is populated and consumed by calling packages, but GMO_DATATYPES_GRP itself performs no reads or writes. Any table access associated with these datatypes occurs in the nine dependent packages that instantiate and populate the collections.

Usage Notes

This package is invoked implicitly rather than called directly. Other GMO packages declare variables and parameters using the qualified type names (for example, GMO_DATATYPES_GRP.GMO_INSTRUCTION_TBL_TYPE) to ensure type compatibility when values are passed across procedure boundaries — a common OPM pattern for bulk operations such as processing instruction sets or recipe definitions. Because it is a specification-only object, it is compiled and validated as a dependency; a change to its type definitions would invalidate all nine dependent packages and require their recompilation. The "noship" designation signifies it is a non-shipping, internal object not intended for customer or third-party use, so it does not form part of any public or documented API. Customizations should not reference these types directly, as their definitions are subject to change between releases. In EBS 12.1.1 and 12.2.2, the object resides in the APPS schema and is governed by standard EBS editioning and patching conventions.