Search Results get_bg

Overview

APPS.BEN_BENXAUDT_XMLP_PKG is the PL/SQL package body that supports the Oracle EBS Benefits XML Publisher (BI Publisher) report BENXAUDT. In Oracle E-Business Suite 12.1.1 and 12.2.2, Oracle Reports and their XML Publisher variants rely on companion PL/SQL packages that expose report-level entry points and reusable formula functions. This package body plays that supporting role: it increments an internal counter, delegates value lookups to the Benefits utility package, resolves the business group name for the report grouping, and provides the standard before/after report and between-page placeholders that the report engine calls during execution.

The package header comment ($Header: BENXAUDTB.pls 120.1 2007/12/10) confirms that the body dates from the R12 development cycle and was last modified in December 2007, which is consistent with the 12.1.1 feature set carried forward into 12.2.2. The package is owned by APPS and classified as OTHER rather than as a public API, meaning it is intended for internal use by the report rather than by external integrations.

Key Procedures and Functions

• GET_SEQ_NUM — Maintains a monotonic sequence counter (g_counter) used by the report to produce sequential row or line numbers within the output.
• VALUEFORMULA — A wrapper that returns a Benefits value by delegating to ben_ext_util.get_value, passing the external record identifier, result detail identifier, and sequence number supplied by the report data model.
• BUSINESS_NAMEFORMULA — Resolves and returns the name of the business group against which the benefits extract or audit is run. It opens the get_bg cursor, fetches the name, closes the cursor, and returns the value.
• BETWEENPAGE — Invoked between report pages; it decrements the internal counter and returns TRUE, controlling page-level counter behaviour.
• BEFOREREPORT — Standard report trigger returning TRUE before report execution begins.
• AFTERREPORT — Standard report trigger returning TRUE after report execution completes.

Tables Accessed

The package body queries a single documented table, accessed in Oracle EBS through the APPS synonym HR_ALL_ORGANIZATION_UNITS, specifically the view HR_ALL_ORGANIZATION_UNITS_VL. This is used inside BUSINESS_NAMEFORMULA to obtain the organization name corresponding to the business group identifier. The join condition organization_id = p_business_group_id restricts the lookup to the requested business group. No insert, update, or delete operations are performed by this package; it is strictly read-only.

Usage Notes

This package is invoked indirectly whenever the BENXAUDT Benefits audit or extract report is executed, typically from the concurrent manager via the submitted concurrent program. The report engine calls BEFOREREPORT and AFTERREPORT at the start and end of execution, BETWEENPAGE between page breaks, and VALUEFORMULA and BUSINESS_NAMEFORMULA as formula columns within the report layout. GET_SEQ_NUM supports sequential numbering of output rows.

Because the package is documented as referenced by zero other packages, it should be treated as a report-private dependency rather than a reusable API. Customisations should avoid modifying this package directly; the underlying lookup logic resides in ben_ext_util, which is the correct extension point for value retrieval behaviour. In 12.2.2 the package remains namespace-compatible with 12.1.1, so no migration changes are expected between the two releases.