Search Results compare_headers

Overview

M4R_7B5_OSFM_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and is classified under the OTHER API category within ETRM. It exists to support the Oracle Workflow process designated "M4R 7B5 OSFM Notify WO," which relates to Outside Processing (OSP) and Outside Service/Fabrication Management (OSFM) notifications against approved purchase orders. The package header declares AUTHID CURRENT_USER, meaning that all SQL executed by the package runs with the privileges of the calling user rather than the package owner. The package was created in February 2005 and enhanced in May 2005 with the addition of the COMPARE_HEADERS procedure. Its documented source version is 120.0.

Key Procedures and Functions

Three procedures are documented in the package specification.

• SET_WF_ATTRIBUTES — Invoked from the Workflow. It determines whether an approved purchase order contains any Outside Processing items and sets the corresponding Workflow attributes used by the "M4R 7B5 OSFM Notify WO" process.
• PROCESS_WO — Invoked from the Workflow to evaluate a purchase order and classify whether the request constitutes a New, Change, or Cancel action. This drives downstream Workflow routing for the OSFM notification.
• COMPARE_HEADERS — Called internally from PROCESS_WO. It compares the header of a standard purchase order or release against the corresponding previous version, and returns an output flag indicating whether the header has changed. This is the procedure most closely associated with the "compare_headers" search term.

Parameter lists are not reproduced here; the documented arguments follow standard Oracle Workflow callback conventions (itemtype, itemkey, actid, funcmode, resultout) for the two Workflow entry points, and identification arguments (header, release, revision) with an OUT change flag for COMPARE_HEADERS.

Tables Accessed

The package operates against both current and archived purchasing tables through APPS synonyms, which supports its change-detection role:

• Current and archive PO tables: PO_HEADERS_ARCHIVE_ALL, PO_LINES_ALL, PO_LINES_ARCHIVE_ALL, PO_LINE_LOCATIONS_ALL, PO_LINE_LOCATIONS_ARCHIVE_ALL, PO_DISTRIBUTIONS_ALL, PO_DISTRIBUTIONS_ARCHIVE_ALL, PO_RELEASES_ALL, and PO_RELEASES_ARCHIVE_ALL — used to compare current order data against prior revisions when determining New/Change/Cancel status.
• PO_LINE_TYPES and WIP_OPERATIONS — used to identify Outside Processing line information associated with the order.
• M4R_7B5_OSFM_S1 — the package's own supporting table (a sequence-backed entity, indicated by the S1 suffix).
• WF_PARAMETER_LIST_T — a Workflow parameter list type used for attribute handling in the notification process.
• DUAL — used for utility queries.

Usage Notes

M4R_7B5_OSFM_PKG is not a general-purpose business API and is referenced by zero other packages, confirming its role as a Workflow-specific utility. It is invoked by the Oracle Workflow engine during execution of the "M4R 7B5 OSFM Notify WO" process, typically triggered when an approved purchase order containing Outside Processing items progresses through the notification routing. Custom code and forms should not call these procedures directly; the intended invocation path is through the configured Workflow item type. Because the package is compiled with AUTHID CURRENT_USER, the effective privileges at runtime derive from the executing session, which is standard for Workflow-launched callbacks in Oracle EBS 12.1.1 and 12.2.2.