Results for “pricing_attribute36”

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

Overview

OE_VALIDATE_ADJ is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the server-side validation layer for the Order Management (OE) adjustments model. The package is declared with AUTHID CURRENT_USER, so all validation functions execute under the privileges of the calling session rather than the definer, which is consistent with its role as an internal component invoked from other order-entry packages and Forms. Its primary business purpose is to expose a set of boolean validation routines that confirm whether the constituent attributes of an adjustment record — amounts, percentages, pricing phase, discount references, header and line identifiers, and audit columns — are structurally valid before the adjustment is written to the pricing and order tables.

The package header carries the revision marker OEXSVADS.pls 120.0, indicating that it belongs to the seed and validation generator family that produces attribute-level validators for entities in the pricing and order adjustment domain. The comment embedded in the header, "Used by generator to avoid overriding or duplicating existing validation functions," confirms that the prototype block is generated and that the package is not intended for direct modification by implementers.

Key Procedures and Functions

The documented interface consists of a table-fetch routine and a large set of validation functions that each return BOOLEAN. Represented entries include:

• GET_ATTR_TBL — supplies the attribute table consumed by the generator; the header explicitly warns that it must not be modified.
• ADJUSTED_AMOUNT — validates the monetary adjustment value.
• PRICING_PHASE_ID — validates the pricing phase identifier associated with the adjustment.
• DESC_FLEX — validates a descriptive flexfield reference by application short name and flexfield name.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LAST_UPDATED_BY — validate the standard WHO audit columns.
• HEADER and LINE — validate the parent order header or line identifier referenced by the adjustment.
• PERCENT — validates the percentage value applied to the adjustment.
• PROGRAM_APPLICATION, PROGRAM, PROGRAM_UPDATE_DATE, REQUEST, REQUEST_DATE — validate the concurrent program and request context columns.
• APPLIED_FLAG, AUTOMATIC — validate the indicator flags that record whether the adjustment is applied and whether it arose automatically.
• CHANGE_REASON_CODE, CHANGE_REASON_TEXT — validate the reason code and its free-text counterpart.
• DISCOUNT, DISCOUNT_LINE — validate the discount identifier and discount line reference.

The complete documented inventory contains 147 procedures and functions following this attribute-per-function convention.

Tables Accessed

ETRM documents two referenced objects, both reached through APPS synonyms: QP_LIST_LINES and PLITBLM. QP_LIST_LINES stores pricing list lines, and the message table PLITBLM is the associated Oracle Messages repository. The validators call against these tables to confirm that adjustment attributes — notably discount and pricing phase references — correspond to existing pricing records and to raise translated error messages when they do not.

Usage Notes

OE_VALIDATE_ADJ is invoked indirectly. ETRM records that it is referenced by six other packages, which call these validators when preparing or committing adjustment data; Forms-based order entry and pricing screens reach the package through that same package layer rather than calling it directly. Because the prototypes are regenerated, customizations should not be applied to the package body. Implementers extending the adjustment attribute set should instead add validators through the generator so that GET_ATTR_TBL and the accompanying prototypes remain synchronized. The prominent search fragment involving a UNION ALL SELECT with a long NULL list and a trailing comment is a SQL-injection probe attempt and is unrelated to any documented interface of this package.