Search Results copy_text




Overview
Explore in AI Chat

Overview

GMA_EDITTEXT_PKG is a PL/SQL package owned by the APPS schema that supports the management of editable text fields within Oracle Process Manufacturing (OPM) and its associated EBS modules. The suffix "EDITTEXT" reflects its role in handling the text editing infrastructure used by OPM applications, particularly the flexible text-code mechanism that allows customers to define reusable, editable text blocks attached to business objects such as specifications, quality results, batch records, and other OPM discrete entities.

The package's central purpose is to allow editable text associated with a given text code in one text-storage table to be duplicated into another text-storage table, and to allow such text to be removed. This enables controlled movement of descriptive content between staging areas and permanent storage, supports template-based text creation, and facilitates housekeeping of obsolete text entries. The package declares AUTHID CURRENT_USER, so it executes with the privileges of the calling session rather than as a definer-rights unit; callers must therefore hold appropriate privileges on the underlying text tables and on any dynamic SQL objects referenced.

Key Procedures and Functions

Two program units are documented, both exposed through the package specification.

  • COPY_TEXT — A function that copies the text identified by a text code from a source text table to a destination text table, returning a numeric status value to the caller. It is the primary entry point for duplicating or transferring editable text content between text-storage locations, and its return value allows callers to detect success or failure and branch accordingly.
  • DELETE_TEXT — A procedure that removes the text associated with a specified text code from a given text table. It is used to purge obsolete or superseded editable text records, keeping the text tables free of stale content. As a procedure it returns no value; error handling is performed through standard PL/SQL exception propagation.

No overloads or additional public subprograms are documented in the ETRM metadata.

Tables Accessed

The documented tables referenced through APPS synonyms are GEM5_TEXT_CODE_S, DBMS_SQL, and DUAL. GEM5_TEXT_CODE_S is the base text-code table where editable text definitions are stored; it is the principal data object the package reads and writes during copy and delete operations. DBMS_SQL is the Oracle-supplied dynamic SQL package, indicating that COPY_TEXT or DELETE_TEXT constructs and executes SQL statements dynamically at runtime, which allows the package to address different text tables by name rather than being compiled against a fixed table. DUAL is the standard single-row Oracle table, typically referenced for validation, constant selection, or existence checks preceding the dynamic operations. Because table names are supplied dynamically by the caller, the package can operate generically across the text tables defined in the OPM text-code model.

Usage Notes

GMA_EDITTEXT_PKG is an internal infrastructure package. It is not exposed directly to end users; instead it is invoked from OPM forms, from other PL/SQL packages, and potentially from concurrent programs that need to move or clear editable text. ETRM metadata records that the package is referenced by two other packages, confirming its role as a shared utility within the OPM text-handling stack. Because COPY_TEXT and DELETE_TEXT accept table names as arguments and use DBMS_SQL internally, callers are responsible for supplying valid, existing text table names and for holding the necessary object privileges, since AUTHID CURRENT_USER applies. Customizations that need bulk duplication of text codes — for example, copying specification text from a template code set to a new code set — can call COPY_TEXT directly, while DELETE_TEXT is appropriate for cleanup routines and error-recovery logic. As with all APPS-owned packages, direct modification is unsupported; customizations should wrap these subprograms rather than alter the package body.