Search Results set_notification_subject

Overview

PON_AUCTION_APPROVAL_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that encapsulates the approval processing logic for Oracle Sourcing auctions and negotiations. Its primary business function is to manage the workflow-driven approval lifecycle of auction documents, from submission for approval through final approval, rejection, cancellation, or timeout. The package acts as the integration layer between the Oracle Sourcing application tables and the Oracle Workflow engine (WF), translating user and document events into workflow notifications and status transitions.

The package is classified as OTHER within the ETRM API taxonomy, indicating that it is an internal implementation package rather than a published public API. It is referenced by other Sourcing components, notably PON_NEGOTIATION_PUBLISH_PVT, which confirms its role as a supporting module within the negotiation and auction publishing framework. Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and it depends on the SYS.STANDARD package for core PL/SQL functionality.

Key Procedures and Functions

The package exposes 24 documented procedures and functions, organized around the approval workflow lifecycle:

• Workflow initiation: SUBMIT_FOR_APPROVAL, STARTUSERAPPROVALPROCESS, STARTEMDAPPROVALPROCESS, and USER_DECISION_WITHOUT_WF initiate and drive the approval and electronic message delivery (EMD) approval workflows for auction documents.
• Decision handling: DOC_APPROVED, DOC_REJECTED, DOC_TIMEDOUT, USER_APPROVED, USER_REJECTED, EMD_USER_APPROVED, and EMD_USER_REJECTED process the outcomes of approver and reviewer actions, updating the document status accordingly.
• Notification management: CANCEL_NOTIFICATION, UPDATE_NOTIF_ONLINE, and SET_NOTIFICATION_SUBJECT handle the creation, modification, and cancellation of Oracle Workflow notifications sent to approvers.
• Status and history: UPD_AUCTION_STATUSHISTORY and UPDATE_DOC_TO_CANCELLED record auction status changes and manage cancellation states.
• Process and document utilities: CLOSE_CHILD_PROCESS, GET_EMD_HEADERID, CREATE_CNF_DOC_CLM, and GET_CNF_DOC_PARAMS_WF provide supporting functions for child process cleanup, header identification, and confirmation document workflow parameters.

Tables Accessed

The package reads and writes a defined set of application tables through APPS synonyms:

• PON_AUCTION_HEADERS_ALL — the master auction document table, used to read and update header status.
• PON_AUCTION_WF_APPROVALS_S — stores the approval workflow state associated with each auction.
• PON_ACTION_HISTORY — records approval and status actions taken against items.
• PON_AUC_DOCTYPES — defines approval document types used to route workflow logic.
• PON_NEG_TEAM_MEMBERS — identifies negotiation team members who may serve as approvers.
• WF_NOTIFICATIONS and WF_ITEM_ACTIVITY_STATUSES — Oracle Workflow tables queried for notification and activity status information.
• FND_NEW_MESSAGES, FND_USER, and PER_ALL_PEOPLE_F — used for notification delivery, user identification, and person/party resolution.
• DUAL — used for single-row SQL expressions.

Usage Notes

PON_AUCTION_APPROVAL_PKG is an internal package and is not intended for direct invocation by end users or custom extensions. It is typically triggered by Oracle Sourcing forms and by Oracle Workflow function activities configured within the auction approval process. The workflow engine calls the DOC_APPROVED, DOC_REJECTED, USER_APPROVED, USER_REJECTED, and DOC_TIMEDOUT entry points as approvers respond to notifications or as timeouts expire. Concurrent programs and the negotiation publishing private API (PON_NEGOTIATION_PUBLISH_PVT) also reference this package. Developers extending Sourcing approval behavior should treat these procedures as private implementation details and prefer supported public APIs where available.