Search Results get_bg_name

Overview

APPS.BEN_BENXSMRY_XMLP_PKG is a report-support package body that backs an Oracle Advanced Benefits (BEN) XML Publisher concurrent report. The naming convention follows the standard Oracle Reports-to-XML Publisher migration pattern: the BEN prefix denotes the Advanced Benefits product, BENXSMRY identifies the specific summary report, and the _XMLP_PKG suffix indicates a package generated to supply PL/SQL formula columns and report-level trigger logic to the XML Publisher data model. It is classified as an OTHER API, meaning it is not a public, supported application programming interface but an internal implementation artifact of the report definition.

As evidenced by the $Header comment (BENXSMRYB.pls 120.1, dated 2007/12/10), the source has remained stable across release levels and carries the noship designation, confirming that it is shipped for internal report execution rather than exposed for customer extension. The package itself holds no persistent business state; every routine is a stateless helper invoked at report runtime.

Key Procedures and Functions

The package exposes five documented functions, each with a distinct role in the report execution lifecycle.

• VALUEFORMULA — Extracts a single value from the Benefits extensibility framework by delegating to BEN_EXT_UTIL.GET_VALUE. It returns the result as a VARCHAR2, allowing the XML Publisher template to render extensibility-defined values without embedding framework logic in the data model itself.
• BUSINESS_GROUPFORMULA — Returns the name of the business group associated with the reported data. This is the routine at the center of the user search for the get_bg_name cursor, which it declares internally and opens, fetches, and closes against PER_BUSINESS_GROUPS. It supplies the business group name as a report placeholder.
• TOTAL_PEOPLEFORMULA — Computes the report's headline aggregate by summing the people count and error count inputs after applying NVL to each. This function typically drives a summary total field in the report output.
• BEFOREREPORT — The standard XML Publisher before-report trigger. In this package it is a stub that returns TRUE, its original debug event call having been commented out.
• AFTERREPORT — The corresponding after-report trigger, likewise a stub returning TRUE.

Tables Accessed

The only table directly referenced in the documented source is PER_BUSINESS_GROUPS, accessed through the local get_bg_name cursor within BUSINESS_GROUPFORMULA. The query selects the NAME column filtered by BUSINESS_GROUP_ID, supplying the business group label for the report header or parameter display. VALUEFORMULA performs no direct SQL; it reads Benefits extensibility data indirectly through BEN_EXT_UTIL.GET_VALUE, which resolves the underlying extensibility tables on the caller's behalf. No insert, update, or delete operations appear in the package.

Usage Notes

This package is not intended for direct invocation by forms or custom code. It is referenced by the corresponding Oracle Reports/XML Publisher report definition as the source of its formula columns and trigger functions, and the XML Publisher engine calls each function when resolving the associated placeholder. Because it is classified as an OTHER API and marked noship, customers should treat it as read-only and avoid building dependencies on its signature. Customizations that require business group name resolution should instead query PER_BUSINESS_GROUPS directly or use a supported HRMS API, ensuring upgrade safety. The package is not referenced by any other documented package, confirming its role as a terminal, report-specific artifact.