Results for “qp_qp_form_limits”

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

Overview

QP_QP_FORM_LIMITS is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified in ETRM as an "OTHER" API. It belongs to the Oracle Advanced Pricing (QP) product family, which manages price lists, modifiers, qualifiers, and pricing limits. The package supports the Oracle Pricing Limits feature, a control mechanism that constrains the monetary value or quantity of a pricing document (such as an order, quote, or agreement) or of individual pricing entities. Limits are defined at specific levels and, when exceeded, trigger configurable actions such as holds or approval requirements.

The package is intended primarily as a form-support layer, evidenced by its name and the presence of generic attribute handling routines. It exposes the plumbing necessary to default, validate, and persist pricing limit records on behalf of an Oracle Forms-based user interface. It is declared with AUTHID CURRENT_USER, meaning execution privileges and name resolution are evaluated in the context of the calling user rather than the definer, which is typical for packages that operate against APPS synonyms on behalf of a logged-in application user.

Key Procedures and Functions

• DEFAULT_ATTRIBUTES — Populates the standard Oracle attribute columns (attribute1 through attribute15), together with context, amount, basis, limit identifiers, limit level code, limit number, and the limit-exceed action code and hold flag, so that a form block or API caller receives correctly defaulted limit data.
• CHANGE_ATTRIBUTE — Updates an individual attribute value associated with a limit record, supporting incremental edits from a form without rewriting the entire row.
• VALIDATE_AND_WRITE — Performs validation of the limit data and commits the record to the underlying pricing limits tables, ensuring integrity before persistence.
• DELETE_ROW — Removes a limit row, typically invoked when a user deletes a limit line within the pricing form.
• PROCESS_ENTITY — Handles processing of a pricing entity in relation to its limits, applying limit logic at the entity level.
• PROCESS_OBJECT — Handles processing of an individual object associated with limits, complementing PROCESS_ENTITY.
• LOCK_ROW — Acquires a row-level lock to prevent concurrent modification during an edit or validation cycle.

Tables Accessed

The ETRM metadata for this package does not enumerate the underlying tables accessed through APPS synonyms. Functionally, the package operates on the Oracle Pricing limits and limits-attribute storage. Given the procedure signatures, it reads and writes the pricing limit header and attribute rows, resolving limit identifiers (limit_id), list header and line references (list_header_id, list_line_id), and the associated descriptive flexfield context and attribute columns. The LOCK_ROW and DELETE_ROW routines imply direct row-level DML against the limits table. No dependent packages are documented as referencing this package.

Usage Notes

QP_QP_FORM_LIMITS is not a general-purpose public API in the sense of the larger pricing APIs; it is a form-support package. It is most commonly invoked from the Oracle Pricing limits form when a user defines, edits, or deletes a limit and when the form needs to default attribute values or apply limit validation before saving. Custom code should approach this package cautiously because its procedures were designed around form block semantics and AUTHID CURRENT_USER execution. Developers seeking to enforce or interrogate pricing limits programmatically should generally prefer the documented pricing public APIs rather than calling these internal routines directly. When troubleshooting limit behavior in Oracle EBS 12.1.1 or 12.2.2, this package is relevant for diagnosing how limit attributes are defaulted, validated, and locked during form-based maintenance of pricing limits.