Results for “process_object”

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

Overview

The PL/SQL package APPS.QP_QP_FORM_CON is a Forms-support controller package within the Oracle E-Business Suite Advanced Pricing (QP) module. Its "FORM_CON" suffix indicates that it functions as a Forms controller — a server-side package whose procedures implement the business logic executed by the Oracle Forms user interface for pricing entities, most notably price list and modifier (adjustment) definitions. Rather than containing independent business rules, the package sits between the pricing Forms screens and the underlying pricing tables, handling defaulting, validation, row-level locking, and the write/delete lifecycle of pricing attribute rows as users interact with flexfield-style descriptive and pricing attributes.

The package header ($Header: QPXFCONS.pls 120.1 2005/06/13) confirms its long-standing role in the pricing Forms layer. It is classified as an OTHER API in the ETRM metadata, meaning Oracle does not publish it as a formal public interface; it is nevertheless a stable, documented internal object frequently referenced by Forms and by extension developers working with pricing attribute screens.

Key Procedures and Functions

The package exposes seven documented procedures:

• DEFAULT_ATTRIBUTES — Populates a complete set of descriptive/pricing attribute values (attribute1 through attribute15), together with context and context-sensitive values such as context code, context ID, context type, and the seeded/user description fields. It returns the calculated defaults through a series of OUT NOCOPY parameters along with the standard return status and message outputs.
• CHANGE_ATTRIBUTE — Handles the re-evaluation of attribute values when a user changes a context, attribute, or controlling value on the Form, reapplying the appropriate validation and defaulting behavior for the new context.
• VALIDATE_AND_WRITE — Validates the attribute set entered on the Form and persists it to the underlying pricing tables, combining validation logic and the insert/update operation into a single call.
• DELETE_ROW — Removes the currently selected pricing attribute row, applying the relevant deletion rules and referential checks.
• PROCESS_ENTITY — Performs entity-level processing for the pricing record being edited, coordinating behavior across the attribute set as a whole.
• PROCESS_OBJECT — Performs object-level processing, invoked as the Form processes the underlying pricing object (for example, a price list line or modifier line).
• LOCK_ROW — Acquires the row-level lock required to prevent concurrent modification of the pricing attribute row before updates or deletes are applied.

Tables Accessed

The ETRM metadata for this object does not enumerate the base tables referenced through APPS synonyms. Functionally, the package operates on the pricing attribute structures that back the Advanced Pricing Forms — the pricing attribute and context tables associated with QP_ entities — reading seeded context/attribute definitions to drive defaulting and validation, and writing the attribute1–attribute15 values supplied by the Form. Because access is through APPS synonyms, the package resolves these objects in the APPS schema at runtime.

Usage Notes

QP_QP_FORM_CON is normally invoked indirectly through the Oracle Forms trigger logic for pricing setup and maintenance screens; end users never call it directly. In customization or extension work, developers may invoke its procedures from custom Forms code or from PL/SQL that must replicate Form-level defaulting and validation behavior for pricing attributes. ETRM records that no other packages reference it, which reinforces its position as a Form-facing controller rather than a shared business API. The NOCOPY hints throughout the parameter list reflect performance tuning for the large OUT parameter sets that carry the attribute values, context details, and seeded/user descriptions back to the client Form.