Search Results qp_qp_form_con




Overview
Explore in AI Chat

Overview

The APPS.QP_QP_FORM_CON package body is a supporting PL/SQL unit within the Oracle E-Business Suite Advanced Pricing (QP) module, classified as an "OTHER" API. Its name and structure indicate that it is a "form controller" package, providing the server-side logic that backs the Oracle Forms user interface for pricing entities such as price lists, modifiers, and qualifiers. It does not expose a public business API to external callers; instead it is the internal engine that supports interactive maintenance of pricing records by end users in the Pricing Manager and related setup windows.

The package status is VALID in the APPS schema, and it is not referenced by any other database object. It is a leaf dependency in the object graph, invoked directly from Forms triggers and program units rather than from other PL/SQL packages.

Key Procedures and Functions

Seven documented procedures/functions constitute the package's interface:

  • DEFAULT_ATTRIBUTES — Populates default values for pricing attributes and entity columns when a new record is created in the form, ensuring consistent initial state before the user enters data.
  • CHANGE_ATTRIBUTE — Handles attribute-level changes made by the user, propagating dependent values and validations required when a specific pricing attribute is modified.
  • VALIDATE_AND_WRITE — Performs final validation of the entity and commits the changes to the database through the underlying pricing public and private APIs.
  • DELETE_ROW — Removes a selected row from the entity being maintained, applying the appropriate deletion logic and referential checks.
  • PROCESS_ENTITY — Coordinates processing of a complete entity (for example, an entire price list or modifier), orchestrating the child operations required to save or apply it.
  • PROCESS_OBJECT — Processes an individual object or record within the form, providing the granular counterpart to PROCESS_ENTITY.
  • LOCK_ROW — Acquires a lock on the row currently being edited to prevent concurrent update conflicts.

No parameter lists are documented, and none should be assumed.

Tables Accessed

The provided ETRM metadata does not enumerate tables referenced through APPS synonyms. Based on the package's dependencies, however, data access is performed indirectly: the package calls into QP_ATTRIBUTES_PUB, QP_ATTRIBUTES_PVT, and QP_CON_UTIL, which encapsulate the pricing attribute and pricing entity table operations. It also depends on QP_GLOBALS for session-level context, FND_API for the standard EBS API error-handling framework, and OE_MSG_PUB for message retrieval and display. The package therefore reads and writes the QP pricing entities and attribute tables through these layers rather than issuing direct SQL.

Usage Notes

QP_QP_FORM_CON is invoked from Oracle Forms when users maintain pricing data interactively. It is not intended to be called from concurrent programs or by custom PL/SQL, and no other database object references it. Customizations should target the documented public APIs such as QP_ATTRIBUTES_PUB rather than this form-controller package, whose signature and behavior are subject to change between releases and between EBS 12.1.1 and 12.2.2. The package is valid in the APPS schema, and its dependency on STANDARD and FND_API confirms it executes within the standard EBS runtime and error-handling regime.