Search Results get_window_session_title

Overview

JG_JGZZTAJA_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified as an "OTHER" API in the ETRM 12.2.2 metadata. It is the generated report logic package associated with the JG (Oracle Financials for India / regional localization) Tax Authority (JGZZTAJA) XML Publisher report. The package encapsulates the server-side PL/SQL that an XML Publisher concurrent program or report template relies upon: it declares report-level global variables, exposes a BeforeReport trigger function, and provides a set of utility routines for managing the FND message/parameter stack, debug tracing, and runtime session context. Business users trigger this package indirectly by running the Tax Authority report, which extracts tax rule membership data for reporting purposes. The package name suffix "XMLP_PKG" confirms it is auto-generated by the Oracle XML Publisher report definition utility and should be treated as report-internal rather than a general-purpose business API.

Key Procedures and Functions

The metadata documents twenty-one callable units. The report lifecycle functions are BEFOREREPORT, which executes the report's before-trigger logic, and AFTERREPORT, which finalizes execution. Corresponding getter functions (C_THE_END_P, C_SET_OF_BOOKS_NAME_P, CP_DATE_FORMAT_P, CP_ROWS_SELECTED_P) return the values of package globals used to control report completion, display the set of books name, apply the date format, and communicate the count of rows selected.

The message stack utilities are SET_NAME, SET_TOKEN, RETRIEVE, CLEAR, GET_STRING, GET, GET_ENCODED, PARSE_ENCODED, and SET_ENCODED. Together these populate a message with application/name tokens, retrieve or encode the resulting message text, and parse an encoded message back into its application short name and message name. Error and diagnostic support is provided by RAISE_ERROR, DEBUG, ENABLE_DEBUG, and DISABLE_DEBUG. Two specialized functions round out the package: GET_WINDOW_SESSION_TITLE, which returns the current Oracle Forms window/session title string, and GET_EFFECTIVE_DATE, which resolves an effective date from a bank account, transaction code, and receipt date.

Tables Accessed

The package operates against four JG tax-authority tables referenced through APPS synonyms: JG_ZZ_TA_ACCOUNT_RANGES and JG_ZZ_TA_CC_RANGES, which hold the account and cost-center range definitions used by the tax authority rule sets; JG_ZZ_TA_RULE_LINES, which stores the individual rule lines (conditions and rates) that make up each rule; and JG_ZZ_TA_RULE_SETS, which groups rule lines into named rule sets. The report reads these tables to present tax authority rule configuration and its associated account/cost-center ranges to the user. The P_RULE_SET_ID, P_SET_OF_BOOKS_ID, and P_CHART_OF_ACCOUNTS_ID package globals are the primary bind parameters that scope those queries.

Usage Notes

Because the ETRM metadata records zero packages referencing JG_JGZZTAJA_XMLP_PKG, it is not a shared dependency of other PL/SQL units. It is invoked exclusively by the XML Publisher runtime when the associated Tax Authority concurrent program or report template executes, with the concurrent program populating P_CONC_REQUEST_ID, P_RULE_SET_ID, P_SET_OF_BOOKS_ID, and P_CHART_OF_ACCOUNTS_ID before BEFOREREPORT is called. Customizations should avoid calling the internal message-stack and debug routines directly; developers who need the underlying report output should instead query the JG_ZZ_TA_* tables directly or invoke the report through its registered concurrent program. Debug tracing can be enabled at runtime through ENABLE_DEBUG when troubleshooting report failures in 12.1.1 or 12.2.2 environments.