Search Results fun_recipient_wf
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, andGET_ATTRmanage transaction state, retrieve workflow attributes, and validate transactions before routing. - Approval logic:
CHECK_APPROVAL_RESULT,IS_MANUAL_APPROVAL,IS_SAME_INSTANCE, andCHECK_ALLOW_REJECTdetermine 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, andRAISE_RECEIVEDdrive approval outcome handling and generate workflow notifications. - Downstream transfer and setup:
TRANSFER_TO_AP,CHECK_AP_SETUP, andRAISE_GL_TRANSFERhandle 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, andRAISE_ERRORprovide 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.
-
PACKAGE: APPS.FUN_RECIPIENT_WF
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_RECIPIENT_WF, status:VALID,
-
PACKAGE: APPS.FUN_TRX_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_TRX_PVT, status:VALID,
-
PACKAGE: APPS.FUN_TRX_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_TRX_PVT, status:VALID,
-
PACKAGE: APPS.FUN_RECIPIENT_WF
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_RECIPIENT_WF, status:VALID,
-
PACKAGE BODY: APPS.FUN_RECIPIENT_WF
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FUN_RECIPIENT_WF, status:VALID,
-
PACKAGE BODY: APPS.FUN_RECIPIENT_WF
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FUN_RECIPIENT_WF, status:VALID,
-
SYNONYM: APPS.FUN_TRX_ACCT_DEFINITIONS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_ACCT_DEFINITIONS, status:VALID,
-
PACKAGE: APPS.FUN_GL_TRANSFER
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_GL_TRANSFER, status:VALID,
-
PACKAGE: APPS.FUN_XLA_TAB_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_XLA_TAB_PKG, status:VALID,
-
PACKAGE: APPS.FUN_BAL_UTILS_GRP
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_BAL_UTILS_GRP, status:VALID,
-
PACKAGE: APPS.FUN_AP_TRANSFER
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_AP_TRANSFER, status:VALID,
-
PACKAGE: APPS.FUN_AP_TRANSFER
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_AP_TRANSFER, status:VALID,
-
SYNONYM: APPS.FUN_TRX_ACCT_DEFINITIONS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_ACCT_DEFINITIONS, status:VALID,
-
SYNONYM: APPS.FUN_TRX_TYPES_B
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_TYPES_B, status:VALID,
-
SYNONYM: APPS.FUN_TRX_TYPES_B
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_TYPES_B, status:VALID,
-
SYNONYM: APPS.FUN_INTER_ACCOUNTS_ADDL
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FUN_INTER_ACCOUNTS_ADDL, status:VALID,
-
PACKAGE: APPS.FUN_GL_TRANSFER
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_GL_TRANSFER, status:VALID,
-
SYNONYM: APPS.WF_USER_ROLE_ASSIGNMENTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:WF_USER_ROLE_ASSIGNMENTS, status:VALID,
-
PACKAGE: APPS.FUN_TRADING_RELATION
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_TRADING_RELATION, status:VALID,
-
PACKAGE: APPS.FUN_SYSTEM_OPTIONS_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_SYSTEM_OPTIONS_PKG, status:VALID,
-
PACKAGE: APPS.FUN_BAL_UTILS_GRP
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_BAL_UTILS_GRP, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
PACKAGE: APPS.FUN_WF_COMMON
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_WF_COMMON, status:VALID,
-
PACKAGE: APPS.FUN_TRADING_RELATION
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_TRADING_RELATION, status:VALID,
-
PACKAGE: APPS.FUN_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_UTIL, status:VALID,
-
PACKAGE BODY: APPS.FUN_GLINT_WF
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FUN_GLINT_WF, status:VALID,
-
PACKAGE: APPS.FUN_XLA_TAB_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_XLA_TAB_PKG, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
12.1.1 DBA Data
12.1.1
-
SYNONYM: APPS.FUN_DIST_LINES_S
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FUN_DIST_LINES_S, status:VALID,
-
SYNONYM: APPS.FUN_DIST_LINES_S
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FUN_DIST_LINES_S, status:VALID,
-
PACKAGE: APPS.FUN_TCA_PKG
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_TCA_PKG, status:VALID,
-
SYNONYM: APPS.FUN_TRX_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_LINES, status:VALID,
-
PACKAGE: APPS.FUN_WF_COMMON
12.2.2
owner:APPS, object_type:PACKAGE, object_name:FUN_WF_COMMON, status:VALID,
-
PACKAGE: APPS.FUN_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_UTIL, status:VALID,
-
SYNONYM: APPS.FUN_DIST_LINES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FUN_DIST_LINES, status:VALID,
-
12.2.2 DBA Data
12.2.2
-
PACKAGE: APPS.FUN_SYSTEM_OPTIONS_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_SYSTEM_OPTIONS_PKG, status:VALID,
-
PACKAGE: APPS.FUN_TCA_PKG
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FUN_TCA_PKG, status:VALID,
-
SYNONYM: APPS.FUN_TRX_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_LINES, status:VALID,
-
SYNONYM: APPS.FUN_TRX_HEADERS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_HEADERS, status:VALID,
-
PACKAGE BODY: APPS.FUN_GLINT_WF
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FUN_GLINT_WF, status:VALID,
-
SYNONYM: APPS.FUN_DIST_LINES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FUN_DIST_LINES, status:VALID,
-
SYNONYM: APPS.FUN_TRX_HEADERS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_HEADERS, status:VALID,
-
SYNONYM: APPS.FUN_TRX_BATCHES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_BATCHES, status:VALID,
-
PACKAGE: APPS.AME_API3
12.2.2
owner:APPS, object_type:PACKAGE, object_name:AME_API3, status:VALID,
-
SYNONYM: APPS.FUN_TRX_BATCHES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:FUN_TRX_BATCHES, status:VALID,
-
VIEW: APPS.GL_LEDGER_LE_BSV_SPECIFIC_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_LEDGER_LE_BSV_SPECIFIC_V, object_name:GL_LEDGER_LE_BSV_SPECIFIC_V, status:VALID,
-
VIEW: APPS.GL_LEDGER_LE_BSV_SPECIFIC_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:SQLGL.GL_LEDGER_LE_BSV_SPECIFIC_V, object_name:GL_LEDGER_LE_BSV_SPECIFIC_V, status:VALID,
-
SYNONYM: APPS.WF_LOCAL_USER_ROLES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:WF_LOCAL_USER_ROLES, status:VALID,