Search Results cp_group

Overview

IGI_IGISLSUA_XMLP_PKG is an Oracle Application Object Library package body owned by APPS and classified as OTHER. It is the generated PL/SQL wrapper that supports an Oracle Reports executable driven by the XML Publisher (BI Publisher) concurrent program architecture. The package name follows the standard EBS convention for report packages: the suffix _XMLP_PKG identifies it as the container for report-level triggers (BEFOREREPORT, AFTERREPORT) and user-defined formula columns referenced by the report layout. The embedded header comment ($Header: IGISLSUAB.pls 120.0.12010000.1 2008/07/29) confirms that the source file is IGISLSUAB.pls and that the shipped version corresponds to the 12.1.1 code line, which is carried forward unchanged into 12.2.2.

The underlying business report belongs to the Oracle Process Manufacturing / Oracle Financials family of IGI (Intellectual Property / Internal Controls) reports. The parameter and variable names — P_GROUP_NAME, P_USER_NAME, and CP_GROUP — indicate that the report extracts and formats data based on a security or assignment group and a named user, a common pattern for access-control and assignment listings. This aligns with the user's search for "cp_group," which is the report's group-name column variable.

Key Procedures and Functions

• BEFOREREPORT — The Before Report trigger. Initializes the concurrent request identifier from FND_GLOBAL.CONC_REQUEST_ID and builds the two runtime filter values, P_GROUP_NAME_T and P_USER_NAME_T, by applying NVL with a '%' wildcard so that the report returns all groups and users when the parameters are left blank. Returns TRUE to allow the report to execute.
• AFTERREPORT — The After Report trigger. It contains no logic beyond returning TRUE and is present as a required placeholder for the report lifecycle.
• CF_1FORMULA — A user-defined formula column function. It accepts the group value from the report query and assigns it to the package-level variable CP_GROUP before returning 1 as the formula result. This is the mechanism by which the "cp_group" value is made available to the report layout and to any dependent formula columns.
• CP_GROUP_P — A packaged getter function that returns the current value of CP_GROUP. It exposes the group value stored by CF_1FORMULA to subsequent report sections or to the XML Publisher template.

Tables Accessed

The ETRM metadata records no direct table references for this package. This is expected for an XML Publisher report wrapper: all SQL is contained in the report definition and the XML Publisher data template, not in the PL/SQL package. The only external dependency is the call to FND_GLOBAL.CONC_REQUEST_ID, which reads the current concurrent request context. No INSERT, UPDATE, or DELETE statements are present, so the package is read-only with respect to application data.

Usage Notes

The package is invoked by the Oracle Reports runtime whenever the associated concurrent program or the XML Publisher report is executed. The Before Report trigger runs automatically, the formula column CF_1FORMULA is called once per result row, and CP_GROUP_P is called by the layout when the group value is required. Because the package is generated from the report source file, it should never be edited directly; customizations must be applied to the report definition and the .pls source, then regenerated.

No other packages reference this object, and the report itself exposes no callable business API. Administrators encountering "cp_group" in the report output or in a debugging trace should recognize it as the group-name variable populated by CF_1FORMULA and retrieved through CP_GROUP_P. The package is unchanged across 12.1.1 and 12.2.2, so troubleshooting guidance derived from either release applies equally.