Results for “process_entity”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GMI_TO_FORM_TROLIN is an APPS-owned PL/SQL package within the Oracle E-Business Suite Process Manufacturing (OPM/GMI) module. Its documented purpose is to mediate between the Oracle Forms user interface layer and the underlying OPM move-order transaction engine. The package name follows the established OPM convention of a "TO_FORM" wrapper, indicating that it exposes server-side logic and record-manipulation routines that a form calls rather than embedding that logic in the form itself. This separation allows validation, locking, attribute defaulting, and write operations to be centralized and reused.

The package carries an ETRM API classification of OTHER, meaning it is not published as a formally supported open interface or public API. It is an internal supporting package for the OPM move-order form, and its procedures are intended to service the form's block-level triggers and event flow rather than to be called by external integrations.

Key Procedures and Functions

Six procedures are documented. Each is described below by purpose only.

• DEFAULT_ATTRIBUTES — Populates derived or context-sensitive field values on a record, so that the form displays defaults such as transaction type, organization, or status without requiring the user to enter them manually.
• VALIDATE_RECORD — Performs field-level and cross-field validation on a single record without persisting it. Typically invoked from form validation triggers to surface errors before the user attempts a save.
• VALIDATE_AND_WRITE — Combines validation with persistence. It confirms the record is valid and then commits the change to the database, which is the standard pattern for a form's save/post trigger.
• DELETE_ROW — Handles removal of a record, including any referential or business-rule checks required before the row is deleted.
• PROCESS_ENTITY — Acts as the coordinating routine that drives the end-to-end handling of a move-order entity, orchestrating the validation and write steps as a single logical operation.
• LOCK_ROW — Acquires a row-level lock to prevent concurrent modification, supporting the form's optimistic or pessimistic locking model.

Tables Accessed

The ETRM documentation for this object does not enumerate the base tables accessed through APPS synonyms. What is documented is a dependency on the package GMI_MOVE_ORDER_GLOBAL, which is the global move-order business logic package in OPM. GMI_TO_FORM_TROLIN therefore does not own the transaction rules itself; it delegates the substantive move-order processing to GMI_MOVE_ORDER_GLOBAL and relies on it for the database work. In addition, the package depends on the SYS.STANDARD package, which is a normal PL/SQL runtime dependency.

Usage Notes

This package is invoked from the OPM move-order Oracle Forms application, where its procedures are wired into block-level and record-level triggers. DEFAULT_ATTRIBUTES and VALIDATE_RECORD are called during record entry and navigation, LOCK_ROW on record selection, and VALIDATE_AND_WRITE or PROCESS_ENTITY on save. DELETE_ROW services the form's delete action. Because the package is documented as an internal ("OTHER") API and is referenced by no other packages, custom code should not call it directly; the supported integration path for move-order transactions is the underlying GMI_MOVE_ORDER_GLOBAL package, with which GMI_TO_FORM_TROLIN is itself dependent.