Search Results cp_to_sls_security_group_p

Overview

The package body APPS.IGI_IGISLSCG_XMLP_PKG is the generated PL/SQL execution stub that supports an Oracle E-Business Suite XML Publisher (BI Publisher) concurrent program. It is owned by the APPS schema and falls under the ETRM classification OTHER, indicating it is a reporting-support package rather than a public application programming interface. The package name follows the standard Oracle XML Publisher naming convention, where the object identifier (IGISLSCG) is combined with the _XMLP_PKG suffix to produce the package that accompanies an XML report definition and its associated data template or RTF layout.

Functionally, the package provides the procedural hooks that the Oracle Reports and XML Publisher integration layer expects from a report-supporting package. These hooks cover report initialization, report cleanup, and the population of report-level bind variables derived from the concurrent program's parameter set. In the 12.1.1 and 12.2.2 releases, the header comment ($Header: IGISLSCGB.pls 120.0.12010000.1 2008/07/29) confirms the file has been stable since the R12 development line and remains current through the 12.2.x upgrade path.

Key Procedures and Functions

• BEFOREREPORT — Executes before the report is rendered. It captures the concurrent request identifier via FND_GLOBAL.CONC_REQUEST_ID and initializes the internal parameter substitution variables P_TO_SLS_SECURITY_GROUP_T and P_FROM_SLS_SECURITY_GROUP_T, defaulting each to the wildcard '%' when no value is supplied.
• AFTERREPORT — Executes after report rendering completes and returns Boolean TRUE. It serves as the defined cleanup/termination hook for the report lifecycle.
• CF_1FORMULA — A formula or column-level function that accepts the TO_SLS_SECURITY_GROUP parameter, assigns it to the package variable CP_TO_SLS_SECURITY_GROUP, and returns the numeric constant 1. This is the object associated with the user's search term cf_1formula, and it is typically referenced from the report's XML layout or PL/SQL trigger to expose a report parameter to the rendered output.
• CP_TO_SLS_SECURITY_GROUP_P — A public accessor function that returns the value of CP_TO_SLS_SECURITY_GROUP. The _P suffix identifies it as the generated getter used by the XML Publisher engine to bind the parameter into the report output.

Tables Accessed

No tables are referenced directly from this package body. All database interaction for the report is performed by the underlying report query or data template, not by the PL/SQL stub. Persistent storage is limited to the package-level variable CP_TO_SLS_SECURITY_GROUP and the temporary substitution variables initialized during BEFOREREPORT.

Usage Notes

This package is invoked automatically by the Oracle XML Publisher concurrent program framework when the associated report is run. It is not intended to be called directly from custom code, although the CF_1FORMULA and CP_TO_SLS_SECURITY_GROUP_P functions can be referenced from within the report definition to surface the sales security group parameter. The BEFOREREPORT wildcard defaulting behavior is significant: when the user leaves the security group parameters blank, the report returns data for all security groups rather than failing or returning no rows. Because the package is version-stamped at 120.0 and shows no direct table dependencies, it is a low-risk object during patching and upgrades in both 12.1.1 and 12.2.2 environments, though any change to the report parameter set would require regeneration of the package.