Search Results add_approver

Overview

PON_AWARD_APPROVAL_PKG is the Oracle Sourcing awards approval engine within Oracle E-Business Suite. It orchestrates the multi-level approval workflow that a negotiation award (auction or RFQ award) must pass through before it becomes effective. The package integrates Sourcing award transactions with Oracle Approvals Management (AME) and the Oracle Workflow engine, using the AME application identifier 396 and the transaction type constant PON_NEGOTIATION_AWARD. It manages the full approval life cycle: seeding a transaction record, calling AME to compute and obtain the approver list, applying approver responses, recording approval history, and releasing the transaction once a final decision is reached. It also exposes programmatic operations that let callers insert, delete, reorder, or reset approvers, which is the functionality behind user actions such as add_approver in the Sourcing award approval UI.

Key Procedures and Functions

The package exposes documented procedures and functions covering the approval life cycle:

• SETUP_OAM_TRANSACTION — initializes an approval transaction for a given auction header, producing transaction context used by subsequent approval calls.
• CLEAR_OAM_TRANSACTION — removes or resets the approval transaction state for an auction header.
• PRE_APPROVAL / POST_APPROVAL — Workflow-callable entry points invoked before and after the approval activity to prepare and finalize the approval context.
• SUBMIT_FOR_APPROVAL — submits the award document into the approval process.
• GET_NEXT_APPROVER — retrieves the next approver in the computed approval list.
• ADD_APPROVER / DELETE_APPROVER — add or remove an approver on the current approval list; invoked by Sourcing UI actions such as add_approver.
• CHANGE_FIRST_APPROVER — promotes a specified approver to the front of the approval list.
• RESET_APPROVER_LIST — restores the approval list to the AME-generated sequence.
• PROCESS_APPROVER_RESPONSE — records and processes an approver's action (approve, reject, forward, and similar).
• MAKE_APPROVAL_DECISION / DOCUMENT_APPROVED / DOCUMENT_REJECTED — apply the terminal approval outcome to the document.
• PROCESS_ERROR / IS_OAM_ERROR — publish and test approval error state.
• IS_OAM_ADMIN_AVAILABLE — checks availability of the Sourcing approval administrator configuration.
• GETAMEFIELDDELIMITER / GETAMERECORDDELIMITER — return the delimiters used to parse AME approver field and record strings.
• LOG_STRING — writes diagnostic text to the log.

Tables Accessed

The package reads and writes documented objects via APPS synonyms:

• PON_AUCTION_HEADERS_ALL — the award/negotiation header that owns the approval transaction.
• PON_ACTION_HISTORY — records approval actions against the award for audit and display.
• PON_AUC_DOCTYPES — document type configuration governing the approval path.
• WF_ITEM_ACTIVITY_STATUSES — Workflow activity state for the running approval process.
• FND_USER — resolves approver identities.
• PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES — resolve employee approvers and their active assignments.
• PLITBLM — the standard PL/SQL integer table used for list/array processing.

Usage Notes

PON_AWARD_APPROVAL_PKG is normally invoked indirectly. The Sourcing Award page calls it when a buyer submits an award for approval, and its ADD_APPROVER, DELETE_APPROVER, CHANGE_FIRST_APPROVER, and RESET_APPROVER_LIST procedures back the user-facing approver maintenance actions, including add_approver. Oracle Workflow invokes PRE_APPROVAL, POST_APPROVAL, GET_NEXT_APPROVER, and PROCESS_APPROVER_RESPONSE as the approval activity executes. Because AME owns the approver computation while this package owns the Sourcing transaction state, customization should be limited to calling the documented procedures rather than modifying the package body. The package is referenced by no other documented packages, so its contract is consumed by forms and workflow rather than by dependent PL/SQL APIs.