Search Results jl_jlcoglne_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.JL_JLCOGLNE_XMLP_PKG is an Oracle E-Business Suite PL/SQL package that supports the JLCOGLNE XML Publisher (BI Publisher) report, a subledger accounting diagnostic used in the Oracle Financials for localizations framework. The package encapsulates the report-level logic and bind-variable management required to render the JL "CO GL NE" (Cash/Changeover General Ledger Net Entry) listing. It is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema, consistent with standard Oracle EBS concurrent program and XML Publisher execution patterns.

The package operates in the context of Oracle EBS 12.1.1 and 12.2.2, where localization reports are typically registered as concurrent programs and driven by a concurrent request ID (P_CONC_REQUEST_ID) and a set of accounting flexfield context parameters such as P_SOB_ID (Set of Books identifier). It provides both formula functions returning formatted values for the report layout and helper functions that expose report parameters (for example, the period name and set of books name) to the XML template.

Key Procedures and Functions

  • BEFOREREPORT — Executed before report data is fetched; initializes package state, resolves NLS strings, and prepares the values required by the template prior to query execution.
  • AFTERREPORT — Executed after the report completes; performs cleanup and returns control following completion of the XML Publisher data model processing.
  • CP_PERIOD_NAMEFORMULA — A formula function returning the formatted period name for display in the report output. This function underpins the CP_PERIOD_NAME bind variable that users typically reference as cp_period_name.
  • CF_1FORMULA — A generic computed formula function returning a numeric value used within the report layout for calculated or conditional output.
  • GET_NLS_STRINGS — Loads translated (NLS) string resources, including the end-of-report and no-data-found messages, ensuring the report renders in the correct language.
  • CP_SOB_NAME_P — Accessor returning the Set of Books name (CP_SOB_NAME) to the report template.
  • CP_PERIOD_NAME_P — Accessor returning the accounting period name (CP_PERIOD_NAME) corresponding to the report parameters, enabling the template to print the period being reported on.

Tables Accessed

The package references three application tables through APPS synonyms:

  • JL_CO_GL_CONC_CTRL — The localization concurrent control table, holding control and run parameters for the JL CO GL concurrent program family; used to resolve report context such as period and set of books.
  • JL_CO_GL_NITS — Stores the net entry/transaction summary rows that form the core content of the JLCOGLNE report output.
  • JL_CO_GL_TRX — Holds the underlying transaction detail lines that feed the net entry listing, providing the transactional basis for reporting.

Usage Notes

JL_JLCOGLNE_XMLP_PKG is normally invoked indirectly by the Oracle EBS concurrent manager when the JLCOGLNE XML Publisher report is submitted. Parameters such as P_CONC_ID, P_SOB_ID, and P_CONC_REQUEST_ID are populated by the concurrent program framework before BEFOREREPORT runs. Report templates reference the accessor functions and bind variables (notably cp_period_name, cp_sob_name, p_end_of_report, and p_no_data_found) rather than calling the package directly.

The package is referenced by no other PL/SQL packages, confirming its role as a report-specific container rather than a shared API. Customizations should preserve the AUTHID CURRENT_USER declaration and avoid altering the documented public interfaces, since the XML template depends on the exact names of the accessor functions and bind variables. Because the header indicates a 2007 revision and NOSHIP status, the package is delivered as part of the localization layer and should be treated as read-only unless directed by Oracle support.