Search Results gma_edittext_pkg




Overview
Explore in AI Chat

Overview

GMA_EDITTEXT_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It is classified under the ETRM "OTHER" API category, indicating that it is an internal utility package rather than a formally published open interface or public API. Its core business function is to manage editable text records stored against the GEM5_TEXT_CODE_S table — a table used by the Process Manufacturing (OPM / GMA) suite for storing free-form, user-editable text associated with process entities such as specifications, quality results, batches, or formulas.

The package provides controlled create, update, and removal behaviour for these text records, wrapping the underlying DML so that consistent validation, keying, and referential handling are applied. Because editable text is embedded in many OPM forms, centralising the logic in a single package reduces duplicated code and enforces uniform behaviour across the product.

Key Procedures and Functions

  • COPY_TEXT — Duplicates an existing editable text record, typically cloning the text content and associated key attributes from a source record to a new target record. This supports scenarios such as copying text from a template specification to a new specification, or carrying text forward when a batch or formula is duplicated.
  • DELETE_TEXT — Removes a specified editable text record from GEM5_TEXT_CODE_S. It encapsulates the deletion so that any dependent cleanup or validation is performed consistently rather than through ad-hoc SQL.

Both procedures are documented as the package's complete public surface; parameter lists are not published in the metadata and should not be assumed.

Tables Accessed

  • GEM5_TEXT_CODE_S — The primary table of interest and the source of the user's search term ("gem5_text_code_s"). The package reads and writes here to persist, copy, and delete editable text records. This is the table that holds the actual text content and its identifying keys.
  • DUAL — Referenced for standard PL/SQL constructs such as SELECT ... INTO validation or sequence/date retrieval.
  • DBMS_SQL — Referenced as a dependency, indicating the package uses dynamic SQL. This is likely employed to build flexible WHERE clauses or to construct dynamic key handling rather than static statements.

Usage Notes

GMA_EDITTEXT_PKG is an internal component and is not referenced by any other database object per the documented metadata, meaning it is not itself a dependency of further database-level packages. It is instead invoked directly from the OPM application layer — most commonly from Oracle Forms (the Process Manufacturing specification, quality, and batch forms) and from other APPS packages where editable text must be manipulated programmatically.

Customisation and extension developers should treat this package as a supporting utility rather than a supported public API. When custom code needs to copy or delete editable text, invoking COPY_TEXT or DELETE_TEXT is preferable to issuing direct DML against GEM5_TEXT_CODE_S, because it preserves whatever internal validation and keying logic the package applies. Because the package uses DBMS_SQL, it relies on dynamic SQL privileges and should be executed within a session where APPS privileges and any required role grants are active. Its status is VALID in both 12.1.1 and 12.2.2, so the documented behaviour is consistent across those releases.