Search Results p_table_name_t

Overview

The package APPS.IGI_IGISLSTL_XMLP_PKG is a generated Oracle Reports (XML Publisher) PL/SQL library package that supports the Oracle E-Business Suite report commonly associated with the IGI (Intellectual Property/Public Sector) product family — specifically a "Security Listing" or security group listing report (report short name IGISLSTL). The package is classified under the ETRM as an OTHER API type, meaning it is a report-support package rather than a business API, and it is owned by the APPS schema.

Its primary role is to hold the global variables, data bindings, and formula functions invoked by the Oracle Reports runtime engine when the associated concurrent program executes. The header comment ($Header: IGISLSTLS.pls 120.0.12010000.1) confirms the source was last shipped in 2008, consistent with a stable report artifact that has carried forward unchanged into EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

• BEFOREREPORT — A standard Oracle Reports report trigger executed once at the start of report execution. It is used to initialize package-level variables and any session-based parameters before data retrieval begins.
• AFTERREPORT — The complementary report trigger executed once after report generation completes. It is used for post-processing or cleanup of report-level state.
• CF_1FORMULA — A report formula/column function. The naming convention (CF_1FORMULA) indicates a generated "column formula" whose output is derived from an input value; in this case the input is SLS_SECURITY_GROUP, and the function returns a NUMBER. It supplies computed values to a report column, typically a lookup or decode of the security group passed as its argument.
• CP_GRP_NAME_P — An accessor function returning CP_GRP_NAME (VARCHAR2). The _P suffix is the standard Oracle Reports pattern for exposing a package global to the report layout. This is the function most directly connected to the searched term, since the security group parameter and the concatenated group name share the same report context.

The package also declares several package-level globals that supply values to the report layout, including P_SECURITY_GROUP, P_SECURITY_GROUP_T, P_TABLE_NAME, P_TABLE_NAME_T, P_CONC_REQUEST_ID, and CP_GRP_NAME. The _T variants conventionally hold the translated (display) value of their non-suffixed counterparts.

Tables Accessed

The ETRM metadata does not enumerate any APPS-synonym base tables referenced directly by this package. In Oracle Reports generated packages of this pattern, table access is normally performed through the report's own query (embedded SQL or a data model group), while the PL/SQL package supplies bind variables, formula columns, and formatting values. Consequently, the package itself is a presentation-layer artifact and the documented metadata records no table-level dependencies.

Usage Notes

This package is not intended for direct invocation by external code. It is loaded at runtime by the Oracle Reports engine when its associated concurrent program is submitted from the Submit Requests form or an equivalent scheduler. The P_CONC_REQUEST_ID global is populated from the concurrent request context, and the security group parameters (P_SECURITY_GROUP / P_SECURITY_GROUP_T) are surfaced as report parameters selected by the user.

Because the package exposes no documented public API and is referenced by zero other packages, it should be treated as internal to its report. Customizations should be applied via the underlying report definition rather than by modifying this generated package, and any change requires recompilation through adop or the standard EBS patching mechanism to preserve supportability.