Search Results je_jenogeis_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.JE_JENOGEIS_XMLP_PKG is a valid PL/SQL package body in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, owned by the APPS schema. It is the report-logic package associated with an Oracle Reports XML Publisher (XMLP) concurrent program in the Japan Localization / General Ledger tax reporting area, evidenced by the JE_ (Japan Extension) and "NO_GEI" (consumption tax / qualified invoice) naming conventions. Its business function is to produce the Japanese No-GEI (consumption tax) reporting output, driving report parameters, data retrieval from General Ledger balances and code combinations, and generation of an ASCII extract file registered through the JE_NO_GEI_ASCIIS_T table.

The package follows the canonical Oracle Reports PL/SQL library pattern: before-report initialization, an after-report cleanup phase, and a set of packaged functions that supply report-level parameters and lexical bindings to the underlying SQL query.

Key Procedures and Functions

The ETRM metadata documents fourteen procedures and functions within this package body:

  • BEFOREREPORT — Initializes report-level state, populates session context via FND_GLOBAL and FND_PROFILE, and prepares parameters prior to query execution.
  • AFTERREPORT — Performs post-extract cleanup, including any residual writes to the ASCII staging table.
  • P_GEI_VIEW — Controls the report view or output mode for the consumption tax extract.
  • P_INS_ASCII — Inserts the generated ASCII extract rows into JE_NO_GEI_ASCIIS_T.
  • P_INSERT_PERIOD_NAME — Resolves and inserts the accounting period name used in the report output.
  • CF_DATEFORMULA — A report formula column returning the formatted date (via FND_DATE).
  • CF_REPORT_TITLEFORMULA — A formula column supplying the runtime report title.
  • STRUCT_NUM_P, SET_OF_BOOKS_NAME_P, SELECT_ALL_P, WHERE_FLEX_P, ORDERBY_ACCT_P, PRECISION_P, FUNC_CURRENCY_P — Packaged parameter functions that feed the report's lexical parameters: accounting structure number, set of books name, select-all flag, the accounting flexfield WHERE clause, account ordering, numeric precision, and the functional currency code.

Tables Accessed

The package reads and writes the following documented objects (all resolved through APPS synonyms):

It also references FND_APPLICATION_VL, FND_CONCURRENT_PROGRAMS_VL, FND_DATE, FND_GLOBAL, FND_PROFILE, FND_REQUEST, DBMS_SESSION, and JG_INFO.

Usage Notes

JE_JENOGEIS_XMLP_PKG is invoked implicitly by the corresponding Oracle Reports XML Publisher concurrent program; the report template calls BEFOREREPORT and AFTERREPORT automatically, and the packaged parameter functions are consumed by the report's SQL and lexical parameters. Because the package is not referenced by any other database object and is classified as OTHER (not a public API), it should not be called directly from custom code. Any customization should be limited to the underlying report definition and concurrent program registration, with care taken to preserve the JE_NO_GEI control and ASCII staging table contract across 12.1.1 and 12.2.2 upgrades.