Search Results maintain_supply

Overview

APPS.ICX_PO_REQS_CANCEL_SV is a server-side PL/SQL package body that supports the cancellation of purchase requisitions originating from Oracle EBS self-service purchasing and iProcurement web flows. Its central responsibility is to propagate a user-initiated cancellation from the web application layer into the requisition tables while preserving the integrity of the associated encumbrance and supply/demand records. The package operates as a service-layer wrapper around the core purchasing requisition logic, and is classified in the ETRM repository as an OTHER API owned by APPS.

The package header comment block identifies the primary business entry point, update_web_reqs_status, and documents its expected calling convention, including the requisition header, requisition line, document type and subtype, control action, control reason, control date, and the encumbrance and order-entry installed flags. The return code parameter is populated only when an error condition occurs, allowing the caller to distinguish a successful cancellation from a rejected one.

Key Procedures and Functions

The ETRM metadata records two documented program units for this package: NAME and ICX_MAINTAIN_SUPPLY.

• update_web_reqs_status — the principal cancellation procedure. It accepts the requisition header and line identifiers, agent identifier, document type and subtype, control action (for example CANCEL), the user-entered cancellation reason, the cancellation date, and the encumbrance and order-entry flags. It returns an error return code when the operation fails. Internally it reads the current authorization status of the requisition header before applying the cancellation, and derives the corresponding action history code.
• ICX_MAINTAIN_SUPPLY — the supply-maintenance routine that reconciles the MTL_SUPPLY record associated with the cancelled requisition. It is the program unit surfaced by the search term maintain_supply. Its purpose is to keep the supply table consistent with the requisition cancellation so that downstream planning, sourcing, and demand/supply netting remain accurate.

Local variables declared in the body include a progress marker, the requisition header authorization status, the action history code, and a supply action and supply identifier used by the supply-maintenance logic.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• PO_REQUISITION_HEADERS — the requisition header is queried to obtain the current authorization_status and is updated to reflect the cancellation action.
• PO_REQUISITION_LINES — the requisition line records are updated to mirror the header-level cancellation status.
• PO_ACTION_HISTORY — an action history record is inserted to capture the cancellation action code, reason, and date for audit purposes.
• MTL_SUPPLY — the supply record linked to the requisition is maintained (via ICX_MAINTAIN_SUPPLY) so that the supply/demand picture reflects the cancellation.

Usage Notes

The package is invoked from self-service requisitioning and iProcurement user interfaces when a requisition is cancelled at the header level. The header comment notes that line-level cancellation is not supported at this revision, though the parameter signature reserves a line identifier for future extension. Callers pass SYSDATE as the cancellation date when the user has not specified one, set the document subtype to REQUISITION (or to the requisition header type lookup code), and pass NULL for the encumbrance and order-entry flags, which are not used in this release.

Because the package has no documented dependents, it is typically called directly by forms, OAF pages, or custom PL/SQL wrappers rather than being consumed by other server packages. Implementers extending requisition cancellation behavior in Oracle EBS 12.1.1 or 12.2.2 should treat update_web_reqs_status as the authoritative entry point and rely on its error return code to drive user-facing validation.