Results for “delete_all_requests”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
QP_QP_FORM_PRICE_LIST_LINE is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It is a form-support package, as indicated by the "QP_QP_FORM_PRICE_LIST_LINE" naming convention that pairs a form module (typically QP_QP_FORM_PRICE_LIST_LINE.fmb) with its server-side PL/SQL logic. Its business purpose is to encapsulate the row-level processing required to maintain price list lines within Oracle Advanced Pricing (QP). Price lists and their associated lines define the base prices, pricing attributes, and qualification rules that drive order pricing, so the integrity of each line record is business-critical.
The ETRM metadata classifies this package under the API classification "OTHER," meaning it is not a published, supported open interface but rather an internal form-support unit. It has a VALID status in both 12.1.1 and 12.2.2, confirming continued availability across the two releases.
Key Procedures and Functions
The metadata documents eight procedures or functions. Their purposes are consistent with standard Oracle Forms row-handling patterns:
- DEFAULT_ATTRIBUTES — Populates default column values for a new or queried price list line record, typically applying form-level or profile-derived defaults.
- CHANGE_ATTRIBUTE — Handles the logic triggered when a specific attribute or field value is modified, propagating dependent changes across the record.
- VALIDATE_AND_WRITE — Validates the current line record and persists the changes to the underlying pricing tables.
- DELETE_ROW — Removes a single price list line row, applying the necessary logical or physical delete semantics.
- PROCESS_ENTITY — Executes the entity-level processing for the line, coordinating the sequence of defaulting, validation, and write operations.
- LOCK_ROW — Acquires a lock on the current record to enforce concurrency control and prevent conflicting updates.
- CLEAR_RECORD — Resets the form record state, clearing fields in preparation for a new entry or query.
- DELETE_ALL_REQUESTS — Handles bulk deletion or clearing of pending request rows associated with the line.
No parameter lists are documented, so signatures must not be assumed.
Tables Accessed
The ETRM metadata excerpt does not enumerate the base tables referenced through APPS synonyms; only the SYS.STANDARD dependency and the package's own self-reference are documented. Functionally, a price list line form-support package of this name operates against the QP pricing line tables, principally QP_LIST_LINES (the price list line table) and its associated attribute and translation tables. Because the documented dependency section is limited, implementers should resolve the actual table references at runtime via the data dictionary views ALL_DEPENDENCIES and ALL_SYNONYMS before relying on any assumed target.
Usage Notes
This package is invoked by the Oracle Forms application that maintains price list lines. The form's triggers (WHEN-VALIDATE-RECORD, WHEN-NEW-RECORD-INSTANCE, KEY-DELREC, and similar) call the corresponding package procedures rather than embedding business logic locally. Because it is classified as OTHER and is referenced by zero other PL/SQL packages, it is not intended as a callable public API; custom integrations that require price list line maintenance should use the supported Advanced Pricing public APIs instead. Direct invocation from concurrent programs or custom code is not recommended. When troubleshooting, dependency resolution through the ETRM "show dependent code" links and the ALL_DEPENDENCIES view provides the authoritative picture of what the valid package body actually accesses.