Search Results psa_multifund_distribution_ext

Overview

PSA_MULTIFUND_DISTRIBUTION_EXT is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the ETRM as an "OTHER" API type. It resides in the Public Sector / Grants Accounting (PSA) product family and supports the multifund distribution functionality that allows a single expenditure or transaction to be allocated across multiple funding sources within a grant or project context. In Oracle EBS 12.1.1 and 12.2.2, this package serves as the extension or public-facing entry point used by the multifund distribution engine to generate and persist distribution records. Although the package is documented as VALID, the ETRM metadata exposes only a single public procedure, indicating the package is largely a wrapper or thin interface layer rather than a heavy business-logic container.

Key Procedures and Functions

The documented interface for PSA_MULTIFUND_DISTRIBUTION_EXT consists of one public procedure:

• CREATE_DISTRIBUTIONS_PUB — The primary public entry point used to create multifund distribution records. Its naming convention follows Oracle's standard "_PUB" suffix, indicating it is the supported public API intended for external invocation rather than an internal helper. This procedure accepts the appropriate distribution inputs and orchestrates the creation of the corresponding distribution lines for a multifunded transaction. Neither the parameter list nor the internal logic is documented in the ETRM extract; the procedure's purpose is limited to the creation of distribution records as implied by its name and the package's business domain. Internal private procedures, if any, are not exposed in the documented metadata.

Tables Accessed

The ETRM metadata for this package does not enumerate underlying base tables accessed directly. Instead, the documented dependency information shows the package references FND_API (the Oracle Application Object Library API package) and standard SYS constructs. The reliance on FND_API indicates the procedure follows Oracle's standard API programming model, which typically returns a standard API return status and message through FND_API constants and utilities, rather than raising hard exceptions to callers. Because no application tables are listed in the documented dependency set, the create-distribution logic is presumed to be delegated to internal calls or to be resolved through APPS synonyms not captured in the ETRM extract. Any table interaction occurs indirectly, and direct DML against PSA distribution tables should not be assumed from the metadata alone.

Usage Notes

The ETRM records that PSA_MULTIFUND_DISTRIBUTION_EXT references itself and is referenced by zero other packages, suggesting it is a leaf-level public API rather than a shared utility consumed widely across the application. Its typical invocation patterns are:

• Called by adjoining PSA multifund logic — The self-referential entry confirms the package can be invoked from within its own scope or via wrapper code; broader callers are not documented.
• Invoked from concurrent programs or forms — In standard PSA multifund flows, distribution creation is driven by the multifund distribution process, which may call CREATE_DISTRIBUTIONS_PUB to persist results.
• Custom extension point — The "_EXT" suffix convention in Oracle EBS commonly denotes an extension package intended for customer-specific logic. Customizations that need to override or augment multifund distribution creation may call this public procedure.

Because the documented metadata is thin, developers should treat this package as an interface whose behavior is governed by its FND_API-compliant calling convention and should verify runtime behavior against the actual package body rather than relying solely on the ETRM extract.