Search Results cs_reports_package




Overview
Explore in AI Chat

Overview

CS_REPORTS_PACKAGE is a PL/SQL package body owned by the APPS schema that supports reporting and helper functionality within the Oracle E-Business Suite Customer Service (CS) module. Its classification as an "OTHER" API indicates that it is not an interface or public business API in the conventional sense, but rather an internal utility package that centralizes common lookup and reporting logic used across CS-related concurrent programs and reports. In EBS 12.1.1 and 12.2.2, such helper packages are typically invoked by concurrent programs and report definitions to resolve descriptive values — such as company names, report names, and structure identifiers — before those values are printed or processed. The package body is documented as VALID, confirming it is compiled and available in the run-time environment.

Key Procedures and Functions

The ETRM metadata documents three program units within CS_REPORTS_PACKAGE. Parameter lists are intentionally not reproduced here; each entry is described by its documented purpose only.

  • CS_GET_COMPANY_NAME — Returns the company (legal entity or organization) name associated with a given context, allowing reports and concurrent programs to display a human-readable company identifier rather than a numeric identifier.
  • CS_GET_REPORT_NAME — Resolves and returns the descriptive name of a report, typically by joining the concurrent program definition against the request or program metadata so that output headers and log files show the report title.
  • GET_P_STRUCT_NUM — Retrieves a chart of accounts structure number, most likely the accounting structure or period structure number used to qualify General Ledger data referenced by CS reports.

All three units are read-only in nature and return scalar values for consumption by the calling report or program.

Tables Accessed

The documented dependency list shows the package body referencing the following objects:

  • FND_CONCURRENT_REQUESTS — The core Oracle Application Object Library table holding concurrent request records. CS_REPORTS_PACKAGE uses it to correlate a running request with its report name and related attributes.
  • FND_CONCURRENT_PROGRAMS_VL — The concurrent program definition view, used to resolve user-facing report titles from program identifiers.
  • GL_SETS_OF_BOOKS — The General Ledger set of books definition, consulted to obtain the accounting structure and set of books context required for reporting.
  • MTL_DEFAULT_SETS_VIEW — An inventory default sets view, indicating that reporting logic also touches inventory organization defaults.

All accesses flow through APPS synonyms. The package itself is documented as not referenced by any database object, confirming it is a top-level consumer rather than a dependency of other database code.

Usage Notes

CS_REPORTS_PACKAGE is typically invoked from concurrent programs, report definition files (such as Oracle Reports or BI Publisher data models), and custom PL/SQL code within the Customer Service module. Because it depends on FND_CONCURRENT_REQUESTS and FND_CONCURRENT_PROGRAMS_VL, it is designed to be called from within the context of a running concurrent request, where a request identifier is available for resolving report and company metadata. The ETRM metadata records that the package is referenced by three other packages, indicating that other database code also calls these helper units. In upgrade or patching scenarios between 12.1.1 and 12.2.2, the package should be treated as an internal utility: customizations should not modify it directly, and any dependency on its behavior should be validated after applying CS or FND patches, since changes to the underlying AOL and GL views can affect the values it returns.