Search Results get_change_summary

Overview

PO_APPROVE_SV is a server-side PL/SQL package body owned by APPS in the Oracle E-Business Suite, classified as an OTHER API within the ETRM repository for releases 12.1.1 and 12.2.2. Its primary business function is to centralize the approval-routing and document-change logic used by Oracle Purchasing. The package exposes the configuration rules that govern how a purchasing document such as a purchase order, blanket agreement, or contract may be routed through its approval hierarchy, and it furnishes the summarized change context that approval workflows rely upon when a document is modified and resubmitted. By isolating these rules in a single package, Oracle Purchasing allows the approval workflow, the document entry forms, and the change-request subsystem to share one consistent interpretation of document type behavior. The get_change_summary routine named in the user search is one of the documented entry points through which this change context is retrieved.

Key Procedures and Functions

ETRM documents six procedures or functions in this package. The metadata enumerates the following:

• GET_CHANGE_SUMMARY — Returns the summarized description of changes associated with a purchasing document or change request, giving approvers a consolidated view of what was modified since the last approved version.
• GET_APPROVAL_PATH — Retrieves the approval path applicable to a given document, resolving the routing rules that determine the sequence of approvers.
• GET_DOCUMENT_TYPES — Returns the document type and subtype configuration, including flags indicating whether the forward-from and forward-to routing may be changed, whether the approval path may be altered, the default approval path identifier, whether the preparer may approve, and whether an approver may modify the document. These values are returned through IN OUT NOCOPY parameters.
• NAME — A supporting routine documented within the package interface.
• Two additional documented routines complete the six-entry interface; the ETRM extract truncates before listing them individually.

The excerpt also preserves test_get_document_types, a diagnostic wrapper that invokes GET_DOCUMENT_TYPES and emits its output via DBMS_OUTPUT, confirming the package is used for runtime verification as well as production calls.

Tables Accessed

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

• PO_DOCUMENT_TYPES — supplies the document type and subtype definitions and the behavioral flags returned by GET_DOCUMENT_TYPES.
• PO_CHANGE_REQUESTS — stores change request records that describe pending modifications to approved documents.
• PO_ACTION_HISTORY — provides the historical action trail used to determine current approval state and prior approver actions.
• PER_POSITION_STRUCTURES — supplies Human Resources position hierarchy data used to resolve approval routing.
• DBMS_SQL and PLITBLM — Oracle-supplied utilities used for dynamic SQL and PL/SQL table manipulation within the package logic.

Usage Notes

PO_APPROVE_SV is invoked primarily from the Oracle Purchasing approval workflow and from the Purchasing forms when a document is submitted, forwarded, or resubmitted after change. Custom code extending approval behavior should call the documented routines rather than duplicating routing logic, because the package encapsulates the authoritative document type rules. ETRM records that the package is referenced by two other packages, indicating it is a dependency for higher-level approval or workflow objects. Because the source header dates from 2004 and later EBS releases may have refactored this interface, integrations should verify procedure availability against the target instance before deployment.