Search Results cf_due_dateformula

Overview

JE_JEHUIAGE_XMLP_PKG is the generated PL/SQL package that backs the Oracle E-Business Suite Payables "Invoice Aging Report" (report short name JEHUIAGE). It is an XML Publisher (BI Publisher) concurrent program wrapper package, automatically produced by the Oracle Reports-to-XML Publisher migration utility beginning in Release 12.1.1 and retained in 12.2.2. In EBS, XML Publisher concurrent programs are executed through a thin PL/SQL driver package that gathers report parameters, performs pre- and post-processing logic, exposes user-defined "formula" columns to the underlying data model or template, and sets lexical parameters used in the report's SQL. JE_JEHUIAGE_XMLP_PKG fills this role for the Invoice Aging Report by initializing concurrent request context, resolving ledger and legal entity information, computing aging bucket ranges, and publishing global variables that the report definition consumes. It is classified as OTHER under ETRM, is owned by APPS, and is not referenced by any other package, confirming its role as a top-level report driver rather than a shared library.

Key Procedures and Functions

The package exposes 75 documented procedures and functions, most of which are either lifecycle hooks or formula accessors automatically generated from the report layout.

• BEFOREREPORT and AFTERREPORT — standard XML Publisher entry points invoked before and after report execution; used to initialize globals such as currency precision, NLS strings, and report run timestamp.
• CUSTOM_INIT — permits customer-specific initialization logic to be layered on top of the seeded behavior.
• GET_BASE_CURR_DATA — retrieves functional (base) currency code, precision, minimum accounting unit, and description for the reporting ledger.
• GET_COVER_PAGE_VALUES — assembles the header/cover-page data: company name, report start date, ledger and legal entity names.
• GET_COMPANY_NAME and GET_PERIOD_INFO — resolve the organization name and aging period information used in the report title and bucket definitions.
• GET_NLS_STRINGS — loads translated literals for Yes/No/All and the "No Data Exists" message.
• SET_ORDER_BY — builds the dynamic ORDER BY clause based on the user's sort and summary options.
• Formula functions (C_CONTACT_LINEFORMULA, C_PERCENT_REMAININGFORMULA, C_INV_DUE_AMT_1FORMULA through _4FORMULA, C_PER_V_INV_AMT_1FORMULA through _4FORMULA, C_CHECK_DATA_CONVERTEDFORMULA) — compute derived column values rendered in the report: per-vendor and per-invoice amounts falling into each of the four aging buckets, percentage of the balance remaining, contact line text, and converted check data.

The user's search term, cf_due_dateformula, corresponds to the class of generated column-formula functions in this pattern (a "CF_" prefixed formula for the due date column). Although it is not listed explicitly among the 75 documented members, it follows the same convention: it returns the formatted/derived due date value for a report row, and is called by the XML Publisher engine when rendering the template rather than being invoked directly.

Tables Accessed

The package reads reference and setup data primarily from the following APPS synonyms:

• AP_AGING_PERIODS and AP_AGING_PERIOD_LINES — define the aging buckets (days ranges and column headings) driving C_INV_DUE_n_RANGE_FR/TO and the corresponding header globals.
• AP_SYSTEM_PARAMETERS — supplies Payables system-level defaults such as base currency context.
• FND_CURRENCIES — supplies currency precision and minimum accounting unit used by GET_BASE_CURR_DATA.
• FND_PROFILE_OPTIONS — resolves user and system profile values such as ledger and organization context.
• GL_LEDGERS — provides ledger name and chart of accounts information.
• XLE_ENTITY_PROFILES — resolves legal entity name and identifier for the report header.

These accesses are read-only and occur during the pre-report phase; the actual invoice, payment, and supplier detail rows are retrieved by the report's main query, not by this package.

Usage Notes

JE_JEHUIAGE_XMLP_PKG is invoked indirectly whenever the "Invoice Aging Report" concurrent program is submitted — Payables automatically calls BEFOREREPORT, the formula functions, and AFTERREPORT as part of the XML Publisher execution cycle. It is not intended to be called from Oracle Forms or from custom PL/SQL. Customizations should be confined to the seeded CUSTOM_INIT hook or, more commonly, to a modified copy of the XML data template, since direct changes to the package body are overwritten by patching. Because the package is not referenced by any other package, changes to it carry no downstream API impact; however, DBMS_OUTPUT debugging should be enabled via P_DEBUG_SWITCH only in non-production environments, and P_TRACE_SWITCH should be left disabled for normal runs.