Search Results cf_flexfield_lowformula




Overview
Explore in AI Chat

Overview

PSB_PSBBGASR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. The "XMLP" suffix and the associated file header (PSBBGASRB.pls) identify it as the report logic package generated for an Oracle XML Publisher (BI Publisher) concurrent program — in this case a budget group / budget analysis report within the Public Sector Budgeting (PSB) module. The package is classified under ETRM as OTHER (not a public API), meaning it is intended to be called by the report engine rather than by external custom code.

The package supplies the user-exit logic and formatted values that drive the report's output. Its most prominent function, BEFOREREPORT, runs ahead of report execution to initialize report parameters, translate internal IDs into descriptive names, and resolve FND message text for localized prompts and end-of-report markers. This is standard Oracle Reports XMLP architecture: the PL/SQL package binds the concurrent program's parameters to the report layout and performs the flexfield (key flexfield / descriptive flexfield) display conversion.

Key Procedures and Functions

The APPS.PSB_PSBBGASR_XMLP_PKG body documents fourteen callable units:

  • BEFOREREPORT — the primary initialization function. It derives the budget group name, validates the reporting context, and sets up globals used by the report.
  • AFTERREPORT — performs post-report processing.
  • BETWEENPAGE — executes logic between report pages.
  • CF_FLEXFIELD_HIGHFORMULA and CF_FLEXFIELD_LOWFORMULA — format-model formulas that resolve the high and low ranges of a key flexfield range parameter into a displayable flexfield value. Both accept a chart-of-accounts identifier and flexfield data values (the COA_ID parameter the user searched for is consumed here).
  • CF_USER_EXIT_DUMMYFORMULA — a placeholder formula for the report's user-exit logic.
  • CP_FLEXDATA_HIGH_P and CP_FLEXDATA_LOW_P — report parameter holders for the high and low flexdata inputs.
  • P_STRUCT_NUM_P — parameter holder for the key flexfield structure number.
  • CP_SET_OF_BOOKS_NAME_P, CP_BUDGET_GROUP_NAME_P, CP_PRINT_SUBGROUPS_P, CP_NO_DATA_FOUND_P, and CP_END_OF_REPORT_P — global/out-parameter getters that expose resolved display values (set of books name, budget group name, print-subgroups meaning, no-data message, and end-of-report message) to the XML Publisher layout.

Tables Accessed

The documented table reference is the APPS synonym for PSB_BUDGET_GROUPS. In the visible source, BEFOREREPORT queries PSB_BUDGET_GROUPS.NAME by BUDGET_GROUP_ID, and the same block queries GL_SETS_OF_BOOKS.NAME by SET_OF_BOOKS_ID and FND_LOOKUPS.MEANING for the YES_NO lookup type. These reads supply the descriptive names that appear in the report's parameter page and layout.

Usage Notes

The package is invoked by the Oracle Reports / XML Publisher runtime when the associated PSB concurrent program executes. It is not registered as a public API and is referenced by zero other packages, so custom code should not call it directly. The COA_ID parameter appears as an input to the flexfield formula functions and is referenced by the FND FLEXRIDVAL user exit, which converts a chart-of-accounts ID and flexdata string into a formatted flexfield value (typically via FND_FLEX_EXT or equivalent). In 12.1.1 and 12.2.2 the package remains an internal report artifact; customization should be done through the underlying concurrent program parameters rather than by modifying this generated body.