Search Results report_control

Overview

APPS.JTF_TERR_JSP_REPORTS is a publicly accessible PL/SQL package belonging to the JTF/A Territories module of Oracle E-Business Suite. Its stated purpose is to provide the server-side reporting logic required by JSP-based Territory Manager reports. The package was originally created in May 2001 and, as indicated by its header revision (120.0), has remained stable across the 12.1.1 and 12.2.2 releases. It is compiled with AUTHID CURRENT_USER, meaning that its SQL statements execute under the privileges of the calling schema rather than the package owner, a design choice consistent with utility packages intended for broad reuse.

The package exposes a single output record type, report_out_rec_type, composed of twenty VARCHAR2(2000) columns, together with a corresponding collection type, report_out_tbl_type. This generic tabular shape allows callers to retrieve heterogeneous territory report results through one uniform interface, with each report populating the columns according to its own layout. The business function served is therefore the consolidation of Territory Manager reporting into a single, callable entry point suitable for web-tier invocation.

Key Procedures and Functions

ETRM documents one procedure for this package: REPORT_CONTROL. It accepts a report identifier (a report name or code) together with up to five generic input parameters, and returns a PL/SQL table of report_out_rec_type records through an OUT NOCOPY parameter. The five parameters are deliberately generic (p_param1 through p_param5), functioning as a positional argument list whose meaning varies by report. REPORT_CONTROL acts as a dispatcher: based on the supplied report name, it branches to the appropriate query logic, applies the caller's filter values, and materialises the result set into the output collection for rendering by the calling JSP. No additional procedures or functions are documented.

Tables Accessed

The package reads from a core set of Territory Manager tables, all accessed through APPS synonyms. These include the territory definition and denormalised hierarchy tables (JTF_TERR, JTF_TERR_ALL, JTF_TERR_VALUES_ALL), the resource assignment tables (JTF_TERR_RSC, JTF_TERR_RSC_ALL), the usage and rule tables (JTF_TERR_USGS, JTF_TERR_USGS_ALL, JTF_TERR_DENORM_RULES_ALL), and the qualification linkage tables (JTF_TERR_QUAL, JTF_TERR_QUAL_ALL, JTF_QUAL_USGS_ALL, JTF_QUAL_TYPE_USGS_ALL, JTF_SEEDED_QUAL_ALL_TL). DUAL and PLITBLM (the PL/SQL table-index-by-binary-integer helper) are used for trivial selects and collection operations respectively. The package is read-only against these objects; it neither inserts nor updates territory data.

Usage Notes

As the name implies, JTF_TERR_JSP_REPORTS is designed for invocation from the middle tier by Oracle Territory Manager JSP pages, which call REPORT_CONTROL to obtain formatted rows for display. It is documented as publicly available and is referenced by one other package, so custom code or concurrent programs may also invoke it where territory reporting data is required programmatically. Because the procedure returns only VARCHAR2 output with generic column names, callers are responsible for interpreting column semantics per report. Implementers extending or wrapping this package should note that parameter meanings are report-specific and that permission to read the underlying JTF tables is required at call time.