Search Results cp_nullformula

Overview

JA_JAINARE1_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It serves as the server-side logic container for the JAINARE1 Oracle Reports report, part of the Oracle Financials for India localization module. The package encapsulates the bind parameters, computed columns, summary formulas, and report trigger logic required to produce the report output. Its primary business purpose is to generate statutory excise and bond-related reporting for Indian tax compliance, drawing together delivery, order, and bond transaction data and deriving computed values such as assessable value, excise cess, tax rates, opening and closing balances, and debit amounts.

The package follows the standard Oracle Reports XML Publisher integration pattern, in which the report's data model calls back into the package to compute derived columns at runtime. The P_ and CP_ prefixed variables act as report-level bind and constant parameters, while the CF_ prefixed functions implement the column formulas referenced by the report layout. The header comment dates the source to release 120.1 and marks it as noship, indicating it is not shipped as part of the base product but is deployed by the localization patch stream.

Key Procedures and Functions

The documented interface exposes twenty procedures and functions, all of which support report generation.

• CF_CITYFORMULA — derives the city value for the report header or address block from the legal entity or location context.
• CF_LEGAL_ENTITYFORMULA — returns the legal entity name associated with the reporting organization.
• CF_DESTINATION_COUNTRYFORMULA — resolves the destination country for a given ship-to site use, used in export and bond documentation.
• CP_NULLFORMULA — a utility function returning a null placeholder, typically used to suppress display of a column.
• CF_QTY_OF_GOODSFORMULA — computes the quantity of goods in the requested unit of measure, accounting for UOM conversion.
• CF_TAX_RATEFORMULA — returns the applicable tax rate for a delivery and inventory item combination, sourced from the Indian tax setup tables.
• CF_VALUEFORMULA — the central valuation routine. It derives the assessable value for a transaction line using delivery, order header, order line, quantity, set of books, and functional currency inputs.
• CF_SET_OF_BOOKS_IDFORMULA — returns the set of books identifier used to drive currency and valuation logic.
• CF_FUN_CURRFORMULA — resolves the functional currency for the given set of books.
• CF_PACKINGFORMULA — returns the packing details printed on the excise or bond document.
• CF_FUNC_TAX_AMOUNTFORMULA — computes the tax amount in functional currency for a delivery and inventory item.
• CF_BALANCESFORMULA — computes the bond or excise register balance using order header, register, order line, customer transaction, delivery, and transaction number inputs. This is the function most directly associated with balance reporting.
• BEFOREREPORT / AFTERREPORT — report-level triggers that initialize parameters and perform post-processing.
• CP_CLOSING_BAL_P, CP_DEBIT_AMOUNT_P, CP_OPENING_BAL_P, CP_NULL_P, CP_EXCISE_CESS_AMOUNT_P, CP_EXCISE_SH_CESS_AMOUNT_P — parameter-return functions that expose the corresponding CP_ package variables (closing balance, debit amount, opening balance, null flag, excise cess, and excise share of cess) to the report layout.

Tables Accessed

The package reads from several application tables through APPS synonyms, reflecting its integration across order management, shipping, receivables, and Indian tax modules.

• OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL — source order and line details used for valuation and quantity formulas.
• WSH_NEW_DELIVERIES — delivery information linking shipments to order lines.
• JAI_OM_WSH_LINES_ALL, JAI_OM_WSH_LINE_TAXES — the India localization shipping line and line tax tables that hold excise and cess amounts.
• JAI_CMN_TAXES_ALL — the common Indian tax repository supplying tax rates and tax type definitions.
• JAI_OM_OE_BOND_TRXS — bond transaction data supporting bond register balance reporting.
• HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTY_SITES, HZ_LOCATIONS — trading community address and site data used to resolve ship-to destinations, cities, and postal addresses.
• FND_APPLICATION, FND_CONCURRENT_PROGRAMS — concurrent program metadata, used to identify the reporting application and request context.
• V$DATABASE, V$PROCESS — database and session-level information, typically used for report headers or diagnostics.

Usage Notes

JA_JAINARE1_XMLP_PKG is invoked indirectly through the JAINARE1 Oracle Reports executable. The report's data model and layout call the CF_ functions as formula columns and reference the CP_ variables through the parameter-return functions during output formatting. The package is not referenced by any other PL/SQL package, confirming that its only consumer is the associated report definition.

Typical invocation occurs when a user submits the report from the India localization responsibility, either directly from a report form or by scheduling the concurrent program. The concurrent request identifier and organization context are populated by the report at runtime into P_CONC_REQUEST_ID, P_ORG_ID, and P_ORGANIZATION_ID. Because the package is marked noship, it is deployed and patched only through the localizations patch stream, and its behavior should be validated against the installed India localization release level when diagnosing report discrepancies. Customizations should avoid modifying the package directly; instead, report-level substitutions or the supported XML Publisher template mechanisms are preferred to preserve patchability.