Search Results c_set_of_books_name_p

Overview

APPS.JG_JGZZTAJA_XMLP_PKG is a generated Oracle Reports PL/SQL library package body associated with the JG (Global Tax) product family in Oracle E-Business Suite. Its header comment, dated 2007 and marked "noship," identifies it as a Report Builder support package (the _XMLP_PKG suffix pattern) for a tax rule-set report. The package is classified under ETRM as OTHER, meaning it is not a public API but a supporting report artifact. Its core responsibility is to prepare report-level data before output is produced, most notably populating a row count of tax rule-set records that match the user-entered selection criteria, and resolving the set of books name for the reporting context. It exposes accessor functions that the Oracle Reports engine or the XML Publisher data model calls to retrieve these package-level values at runtime.

Key Procedures and Functions

The 21 documented procedures and functions fall into functional categories:

• Report lifecycle: BEFOREREPORT executes the rule-set count query and resolves the set of books, returning TRUE to allow the report to continue; AFTERREPORT performs the corresponding teardown and returns TRUE.
• Value accessors: CP_ROWS_SELECTED_P returns the number of matching rule-set rows; C_SET_OF_BOOKS_NAME_P returns the set of books name; C_THE_END_P and CP_DATE_FORMAT_P return report formatting and end-of-report string values.
• Message handling: SET_NAME and SET_TOKEN configure FND_MESSAGE application, name, and token values; RAISE_ERROR surfaces a message to the user.
• Encoding utilities: GET_STRING, GET, GET_ENCODED, PARSE_ENCODED, and SET_ENCODED support report parameter string and encoding operations.
• Debugging: DEBUG, ENABLE_DEBUG, and DISABLE_DEBUG, together with the P_DEBUG_MODE parameter check in BEFOREREPORT, control whether diagnostic output is emitted.
• Session and retrieval helpers: RETRIEVE, CLEAR, and GET_WINDOW_SESSION_TITLE.

Tables Accessed

The BeforeReport query reads four JG tax rule-set tables via APPS synonyms: JG_ZZ_TA_RULE_SETS, JG_ZZ_TA_CC_RANGES, JG_ZZ_TA_ACCOUNT_RANGES, and JG_ZZ_TA_RULE_LINES. These are joined on account_range_id, cc_range_id, and rule_set_id to relate rule lines to their account and cost-center ranges and to the parent rule set. A lookup join to FND_LOOKUPS on account_type classifies each rule set. The query filters by rule_set_id using NVL(P_RULE_SET_ID, rule_set_id), allowing either a single rule set or all rule sets to be counted. A separate query reads GL_SETS_OF_BOOKS to obtain the book name for P_SET_OF_BOOKS_ID. The package performs read-only access; no inserts, updates, or deletes are documented.

Usage Notes

The package is invoked at runtime by its owning Oracle Reports report, not directly by forms or concurrent program registrations, as evidenced by the zero packages referencing it. The BeforeReport trigger fires first to establish the CP_ROWS_SELECTED and C_SET_OF_BOOKS_NAME values that the layout uses. Its parameters P_RULE_SET_ID, P_SET_OF_BOOKS_ID, and P_DEBUG_MODE drive selection and diagnostics; the P_DEBUG_MODE='Y' branch currently performs no action beyond a null statement. The reported row count supports conditional report logic, such as suppressing output when no rule sets qualify. Because the package body is a report artifact and not a supported API, customizations should avoid direct calls and instead target the underlying ETRM tax rule-set views and tables through supported interfaces.