Search Results get_invoice

Overview

APPS.FUN_INITIATOR_WF_PKG is an Oracle E-Business Suite PL/SQL package classified under the OTHER API category. Its name and header context (funwints.pls) indicate that it serves as the Workflow integration bridge for the Oracle Receivables transfer process initiated from Oracle Financials. The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, and it depends on APPS synonyms for all of its data access.

The primary business function of this package is to orchestrate the transfer of transactions into the Oracle Receivables interface tables and to drive the associated Oracle Workflow process through its lifecycle. It defines two PL/SQL record types — AR_interface_line and AR_interface_Dist_line — which model the structure of Receivables interface line and distribution rows, enabling the package to populate RA_INTERFACE_LINES_ALL and RA_INTERFACE_DISTRIBUTIONS_ALL programmatically. These structures carry attributes such as amount, batch source name, conversion type, currency code, customer transaction type, GL date, and descriptive flexfield context and attribute columns, reflecting the fields required for AutoInvoice processing. Notes in the header attribute certain columns to bug fix 3450031, indicating the record layouts were amended to support additional interface columns.

Key Procedures and Functions

The package exposes eight documented procedures and functions, invoked primarily as Workflow function activities:

• SET_ATTRIBUTES — Populates the workflow item attributes associated with the transaction process, preparing context values consumed by subsequent activities in the workflow.
• UPDATE_STATUS — Updates the transaction status, allowing the Workflow process to reflect progress or completion back to the underlying transaction record.
• TRANSFER_AR — Performs the core transfer of the transaction into the Receivables interface tables, using the AR_interface_line and AR_interface_Dist_line record types to construct the rows to be inserted.
• CHECK_AR_SETUP — Validates that the Oracle Receivables setup prerequisites are satisfied before attempting the transfer. This is the procedure most directly relevant to the search term "check_ar_setup", as it gates the transfer activity on the presence of valid Receivables configuration.
• GET_INVOICE — Retrieves invoice-related information required by the workflow process.
• GENERATE_KEY — Generates a key value, typically used to identify or correlate the workflow item or transaction being processed.
• UPDATE_TRX_HEADERS — Updates transaction header records, presumably after transfer or processing has completed.
• POST_AR_INVOICE — Handles posting of the Receivables invoice, completing the flow from interface staging to a posted transaction.

The header excerpt confirms the signature pattern for these activities: each accepts itemtype, itemkey, actid, and funcmode parameters and returns a resultout value, consistent with Oracle Workflow standard function activity conventions.

Tables Accessed

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

• RA_INTERFACE_LINES_ALL and RA_INTERFACE_DISTRIBUTIONS_ALL — the Receivables interface staging tables populated by TRANSFER_AR.
• RA_CUSTOMER_TRX_ALL, RA_CUST_TRX_LINE_GL_DIST_ALL, RA_BATCH_SOURCES_ALL, and RA_CUST_TRX_TYPES_ALL — Receivables transaction, distribution, batch source, and transaction type reference data used during setup validation and transfer.
• HZ_PARTIES, HZ_CUST_SITE_USES_ALL, and HZ_CUSTOMER_PROFILES — Trading partner and customer account information, including bill-to site usage, required to build valid interface rows.
• FUN_TRX_HEADERS, FUN_TRX_LINES, FUN_TRX_BATCHES, and FUN_DIST_LINES — the source transaction structures from which data is selected and transferred.
• WF_EVENT_T and FND_USER — Workflow event and user context data supporting the workflow-driven processing.

Usage Notes

FUN_INITIATOR_WF_PKG is not a general-purpose public API. It is invoked as part of the Oracle Workflow definition that governs the transfer of transactions to Oracle Receivables. Individual procedures correspond to workflow function activities; the Workflow engine calls them in sequence, passing itemtype, itemkey, actid, and funcmode, and receiving a resultout value that directs the next transition. CHECK_AR_SETUP in particular is designed to be executed before TRANSFER_AR so that the process fails gracefully if the Receivables setup is incomplete. The package is referenced by five other packages, indicating it participates in a broader dependency chain within the Financials suite. Because all access is via APPS synonyms and the unit is AUTHID CURRENT_USER, customizations should not alter its behavior directly; instead, standard Workflow configuration and Oracle-supported extension points should be used. Any modification or direct invocation outside the workflow framework is unsupported.