Search Results cf_master_orgformula

Overview

WSH_WSHRDIST_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. It is the generated support package for the XML Publisher (BI Publisher) concurrent program that produces the Shipping Distribution or Service Provider distribution report within the Oracle Shipping Execution (WSH) module. The nomenclature — the _XMLP_PKG suffix together with the single-character "CF_" function names and the LP_ variant globals — is the standard signature emitted by Oracle Reports to XML Publisher migration, in which report-level formula columns and format triggers are converted into callable PL/SQL functions and package globals.

The package therefore exists to supply runtime values for the report's layout tokens and to manage report lifecycle events. Its package-level variables store the bind parameters passed from the concurrent program request: P_APPLICATION_ID, P_MASTER_ORG_ID, P_ORGANIZATION_ID, P_APPL_USER_ID, P_VENDOR_ID and P_CONC_REQUEST_ID, plus the LP_ character versions used for display formatting. In the 12.1.1 and 12.2.2 releases the source remains at version 120.2 (header dated 2007/12/25), which reflects the relative stability of the Shipping distribution report across those releases.

Key Procedures and Functions

• AFTERPFORM — Standard XML Publisher after-parameter-form trigger. Fires once the parameter form is submitted, and is typically used to default or validate parameter values and populate package globals before the report query is executed.
• BEFOREREPORT — Standard before-report trigger. Executes prior to data retrieval and is used to initialise session state, derive the LP_ display variables from the numeric parameters, and prepare the report environment.
• CF_APPLICATION_IDFORMULA — Formula column function that returns the display value for the Application identifier based on P_APPLICATION_ID.
• CF_SERVICE_PROVIDERFORMULA — Formula column function that derives and returns the service provider description for the report output.
• CF_MASTER_ORGFORMULA — Formula column function that resolves and returns the master organisation name; this is the function associated with the search term "cf_master_orgformula". It supplies the human-readable master organisation value rather than the raw numeric identifier.
• CF_ORG_NAMEFORMULA — Formula column function that returns the operating unit or inventory organisation name for display.
• CF_APPLICATION_USERFORMULA — Formula column function that returns the application user name associated with P_APPL_USER_ID.
• AFTERREPORT — Standard after-report trigger. Fires once report generation completes and is used for cleanup or post-processing of package state.

All CF_ functions return CHAR and carry no documented input parameters, consistent with XML Publisher report formula columns that read package-level globals rather than being passed arguments.

Tables Accessed

• FND_USER — Read to translate P_APPL_USER_ID into a displayable user name for CF_APPLICATION_USERFORMULA.
• MTL_PARAMETERS — Read to resolve organisation identifiers (master organisation and inventory organisation) into their descriptive names for the master org and org name formula columns.
• WSH_ITM_VENDORS — Read to obtain service provider and vendor-related information used by CF_SERVICE_PROVIDERFORMULA and the vendor parameter.

These tables are accessed through APPS synonyms, which is why the package is declared AUTHID CURRENT_USER and must be executed in a context where the APPS synonyms are visible.

Usage Notes

The package is not intended for direct invocation by application code. It is called by the XML Publisher runtime engine when the associated Shipping distribution concurrent program is submitted, with the engine executing AFTERPFORM, BEFOREREPORT, the CF_ formula functions during layout rendering, and AFTERREPORT at completion. No other packages reference it, as confirmed by the zero reverse-dependency count.

Customisations should be limited to the report template and to data-model queries rather than to this generated package, because Oracle may regenerate the package body during patching. When troubleshooting report output, the CF_MASTER_ORGFORMULA function is the appropriate starting point for issues where the master organisation value prints incorrectly or returns null, and validating the MTL_PARAMETERS lookup for the supplied P_MASTER_ORG_ID is the usual first diagnostic step.