Search Results is_manual_approval

Overview

The APPS.FUN_RECIPIENT_WF package is a workflow-enabled PL/SQL package within the Oracle E-Business Suite Financials family, operating under the APPS schema. Its name reflects its role as the recipient-side workflow handler for Oracle Financials transactions — most notably intercompany and intercompany transfer transactions managed by the FUN_TRX_PVT layer. The package supports the Oracle Workflow (WF) infrastructure by orchestrating transaction validation, approval routing, notification generation, and the transfer of approved transactions into General Ledger and, where configured, into Payables.

The package is classified as OTHER in the ETRM metadata, meaning it is not a formally published open API but rather an internal integration component invoked by other EBS packages and workflow processes. It is documented with a VALID status, confirming that the shipped version compiles and is populated in the database.

Key Procedures and Functions

The package exposes thirty-five documented procedures and functions that can be grouped by function:

• Transaction lifecycle and validation: VALIDATE_TRX, DELETE_TRX, and GET_ATTR manage transaction state, retrieve workflow attributes, and validate transactions before routing.
• Approval logic: CHECK_APPROVAL_RESULT, IS_MANUAL_APPROVAL, IS_SAME_INSTANCE, and CHECK_ALLOW_REJECT determine whether a transaction requires manual approval, whether the running instance matches the initiated instance, and whether rejection is permitted.
• Approval actions and notifications: ABORT_APPROVAL, GENERATE_APPROVAL_DOC, POST_APPROVAL_NTF, RAISE_APPROVE, RAISE_REJECT, and RAISE_RECEIVED drive approval outcome handling and generate workflow notifications.
• Downstream transfer and setup: TRANSFER_TO_AP, CHECK_AP_SETUP, and RAISE_GL_TRANSFER handle movement of approved transactions into Payables and General Ledger, validating related setup first.
• Context and support utilities: IS_GL_BATCH_MODE, CHECK_INVOICE_REQD, GET_CONTACT, and RAISE_ERROR provide mode checks, invoice-requirement tests, recipient contact resolution, and error signaling.

Tables Accessed

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

• FUN_TRX_HEADERS, FUN_TRX_LINES, FUN_TRX_BATCHES, FUN_TRX_TYPES_B — the core intercompany transaction structures being validated and transferred.
• FUN_DIST_LINES and FUN_DIST_LINES_S — distribution lines associated with transactions.
• FUN_INTER_ACCOUNTS_ADDL and FUN_TRX_ACCT_DEFINITIONS — intercompany account and accounting definition data.
• GL_LEDGERS — ledger context for GL transfer and batch-mode determination.
• HZ_PARTIES — trading partner and contact information.
• FND_USER — approver and user identity resolution.
• WF_ITEM_ACTIVITY_STATUSES, WF_NOTIFICATIONS, WF_PARAMETER_LIST_T, WF_PROCESS_ACTIVITIES — workflow engine state, notification records, and parameter lists.

Usage Notes

FUN_RECIPIENT_WF is not intended for direct invocation by end users or forms. It is called by workflow processes and by peer packages, notably FUN_GLINT_WF and FUN_TRX_PVT, which appear in its dependency chain. When customizing or extending intercompany approval flows, developers should invoke these internal procedures only through the supported workflow framework and should treat the package as a private implementation, since its interface is not published as a formal API and may change between releases. It functions consistently across EBS 12.1.1 and 12.2.2.