Search Results cf_orgformula

Overview

PER_PERSAIPE_XMLP_PKG is an Oracle Application Object Library (AOL) report package owned by APPS and classified under the OTHER API category. It supports the Oracle HRMS concurrent program associated with the PERSAIPES SQL*Plus report, whose header indicates a last revision of 24 December 2007. The package functions as the PL/SQL container that BI Publisher and Oracle Reports generation logic invokes when the "Persons by Assignment, Position, and Organization Structure" style report is executed. It gathers parameters supplied at the concurrent request submission screen, resolves organizational hierarchy context (organization structure, structure version, and organization), constructs dynamic WHERE-clause fragments used by the report's query, and exposes ancillary formulas used by the report layout to render dates, durations, version numbers, hierarchy indicators, and currency format masks.

The package also encapsulates several report-level formulas that Oracle Reports names automatically. Values such as business group, legislation code, and currency format mask are resolved at runtime through user-exit style functions so that the report displays locale-appropriate information rather than raw identifiers.

Key Procedures and Functions

• BEFOREREPORT — Executed before the report's main query runs; typically initializes package-level variables and context.
• AFTERREPORT — Executed after report completion; used for cleanup or final formula evaluation.
• AFTERPFORM — Parameter form trigger, run after the parameter form is submitted, and commonly used to validate or compute dynamic conditions based on user-entered parameters.
• SET_CURRENCY_FORMAT_MASK — Procedure that derives and stores the currency format mask used for displaying monetary values.
• CF_BUSINESS_GROUPFORMULA — Returns the business group identifier as a display value.
• CF_LEGISLATION_CODEFORMULA — Returns the legislation code applicable to the report run.
• CF_CURRENCY_FORMAT_MASKFORMULA — Returns the currency format mask, accepting a legislation code as input to drive the mask selection.
• CF_1FORMULA — Numeric layout formula, generally used for a computed report column.
• CF_ORGFORMULA — Returns the organization name/value for display; this is the formula referenced by the search term cf_orgformula.
• CF_DURATION_UNITSFORMULA — Returns the duration units text for the assignment or position record.
• CF_VERSIONFORMULA — Returns the organization structure version number.
• CF_HIERARCHYFORMULA — Returns the hierarchy indicator text.
• P_BUSINESS_GROUP_IDVALIDTRIGGE — Validation trigger function for the business group parameter.
• CP_1_P — Accessor function returning the internal CP_1 counter value.

Tables Accessed

• HR_ALL_ORGANIZATION_UNITS — Source of organization unit names and identifiers used by CF_ORGFORMULA.
• HR_ORGANIZATION_INFORMATION — Provides additional descriptive attributes of organizations.
• PER_ORGANIZATION_STRUCTURES — Defines the organization hierarchy used to scope report output.
• PER_ORG_STRUCTURE_ELEMENTS — Identifies member organizations within the structure.
• PER_ORG_STRUCTURE_VERSIONS — Supplies version data used by CF_VERSIONFORMULA.
• FND_CURRENCIES — Supplies currency formatting and precision information for SET_CURRENCY_FORMAT_MASK and CF_CURRENCY_FORMAT_MASKFORMULA.

Usage Notes

This package is not a general-purpose API. It is invoked exclusively by the PERSAIPES concurrent program and its associated Oracle Reports XML definition, referenced by zero other packages per the documented metadata. Customizations should therefore be limited to the underlying query or the report template; modifying the package directly risks incompatibility during patching. The cf_orgformula term corresponds to the CF_ORGFORMULA function, which is the report formula that renders the organization value on the output. In EBS 12.1.1 and 12.2.2, the package is compiled under APPS and runs under the standard concurrent manager responsibility with the requesting user's security profile applied through the business group parameter.