Search Results p_insert_period_name

Overview

APPS.JE_JENOGEIS_XMLP_PKG is an Oracle E-Business Suite PL/SQL package associated with the Japanese No GEI (general expense/inventory style) XML Publisher report. It is an XML Publisher (BI Publisher) report package generated for the concurrent program that reproduces a statutory or regulatory accounting layout known internally as "JE_NO_GEI". The package belongs to the JE product family, which manages journal entry and general ledger related reporting functions. Its header version, 120.1 dated 2007/12/25, confirms it is a long-standing report package retained across the 12.1.1 and 12.2.2 releases.

The package is classified as OTHER in the ETRM metadata. It is not an API in the conventional sense; instead, it is a report-level driver that accepts concurrent program parameters, constructs the report data set, and formats the output for XML retrieval. Key public variables such as P_LEDGER_ID, P_FILENAME, P_EXPENSE, P_INCOME, P_PERIOD_NAME and P_FINAL hold runtime values supplied by the concurrent request, while static configuration variables such as STRUCT_NUM ('101'), SET_OF_BOOKS_NAME, SELECT_ALL, WHERE_FLEX and ORDERBY_ACCT define the report's structural and query behavior.

Key Procedures and Functions

The package exposes 14 documented callable units, which fall into three groups.

• Report lifecycle: BEFOREREPORT and AFTERREPORT are the standard XML Publisher pre- and post-processing hooks. BEFOREREPORT initializes runtime state and resolves the ledger context; AFTERREPORT performs cleanup and finalization.
• Data extraction and staging: P_GEI_VIEW drives the main view generation logic; P_INS_ASCII inserts raw report lines into the ASCII staging table; P_INSERT_PERIOD_NAME stores period-level expense and income figures.
• Formula and accessor functions: CF_DATEFORMULA and CF_REPORT_TITLEFORMULA compute the report date and title. STRUCT_NUM_P, SET_OF_BOOKS_NAME_P, SELECT_ALL_P, WHERE_FLEX_P, ORDERBY_ACCT_P, PRECISION_P and FUNC_CURRENCY_P return the current values of the corresponding package variables for use inside the XML template.

The accessor naming convention (suffix "_P") follows Oracle's generated XML Publisher report pattern, allowing the RTF template to reference package state directly. Notably, ORDERBY_ACCT_P returns the value of ORDERBY_ACCT, which defaults to 'CC.SEGMENT10', establishing the default sort order of the account listing by segment 10.

Tables Accessed

The package reads and writes through APPS synonyms. GL_BALANCES supplies the period net debit/credit balances used to populate expense and income values. GL_CODE_COMBINATIONS supplies the account segments concatenated by SELECT_ALL and filtered by WHERE_FLEX. GL_PERIOD_STATUSES confirms the period is open for the requested ledger. FND_CURRENCIES resolves currency descriptions and precision. JE_NO_GEI_CONTROLS and its _S sequence-like table manage control records for the GEI report run. JE_NO_GEI_ASCIIS_T is the staging table populated by P_INS_ASCII. DBMS_SESSION and DUAL are used for session-level settings and simple value resolution.

Usage Notes

The package is invoked when the JE_NO_GEI XML Publisher concurrent program is submitted. Oracle Reports or the concurrent manager calls BEFOREREPORT, which materializes the data set, then the XML Publisher engine evaluates the template formulas calling the *_P functions. Because the package is referenced by zero other packages, it has no downstream API dependencies and is safe to treat as an isolated report component. Customizations typically take the form of modifying WHERE_FLEX or ORDERBY_ACCT defaults, or extending the RTF template rather than altering the package body.