Search Results cf_1formula0013

Overview

The APPS.JA_JAINTSLS_XMLP_PKG package body supports the Oracle E-Business Suite localization reporting infrastructure for the JA (Asia/Pacific) region, specifically the India-localized sales tax register report. Its internal naming convention (the "JAINTSLS" prefix, suggesting "India Tax Sales") and the presence of Indian tax structures such as excise and VAT confirm that it is a report-support package backing an Oracle Reports (XML Publisher) concurrent program. The package encapsulates the PL/SQL logic referenced by formula columns and trigger functions embedded in the corresponding report definition file, whose header comment (JAINTSLSB.pls 120.1, dated 2007) indicates a long-standing part of the EBS codebase carried forward into releases 12.1.1 and 12.2.2.

The package has no public API surface beyond these report support routines. It is classified as OTHER in the ETRM metadata and is not referenced by any other package, meaning its sole consumer is the associated report definition. It exposes 16 documented program units that are invoked by Oracle Reports at runtime: the format triggers BEFOREREPORT and AFTERREPORT, and a set of user-named formula columns and group functions that calculate totals for display.

Key Procedures and Functions

• CF_1FORMULA — a formula column that accepts a line amount and returns the accumulated line amount. The indexed variants CF_1FORMULA0004, CF_2FORMULA, CF_1FORMULA0013, CF_2FORMULA0008, CF_1FORMULA0005, CF_SALES_TAXABLE_AMT_2FORMULA, and CF_TRX_NUMBER_DATE_1FORMULA serve analogous formula-column roles, producing computed display values such as taxable amounts and transaction identifiers/dates. The user's search term cf_1formula0004 matches the auto-generated name of one such formula column.
• C_LINE_TOTAL_W_TAXFORMULA — a summary formula that sums a tax total and a tax-exclusive line total to produce the tax-inclusive line total.
• P_END_DATEVALIDTRIGGER — a validation trigger that defaults the ending date parameter to the current truncation of SYSDATE when none is supplied.
• BEFOREREPORT — the report's main before-report trigger. It resolves the concurrent request context, optionally enables SQL tracing (event 10046) when the program's trace flag is set, captures the operating unit via FND_PROFILE, and defaults the start date by querying the earliest transaction date when the parameter is null.
• AFTERREPORT — the complementary after-report trigger used to finalize report state.
• CF_VAT_TAXES_1, CP_EXCISE_1_P, CP_ADDL_OTHER_TAXES_1_P, and CP_VAT_TAXES_1_P — summary/group functions that aggregate Indian VAT, excise, and additional tax amounts for the report's total columns.

Tables Accessed

• FND_CONCURRENT_REQUESTS, FND_CONCURRENT_PROGRAMS — read in BEFOREREPORT to obtain the concurrent program ID and trace flag.
• RA_CUSTOMER_TRX_ALL, RA_CUSTOMER_TRX_LINES_ALL, JAI_AR_TRXS, JAI_AR_TRX_LINES, JAI_AR_TRX_TAX_LINES — the transactional core supplying invoice, line, and tax-line data and the localization transaction enrichment.
• JAI_CMN_TAXES_ALL — read to classify tax types (SALES, CST, VAT, excise).
• JAI_CMN_CUS_ADDRESSES — supplies customer address details for the register.
• AR_PAYMENT_SCHEDULES_ALL — provides payment schedule information.

Usage Notes

This package is not intended for direct invocation from forms or custom code. It is bound to its parent Oracle Reports/XML Publisher report definition, which invokes the functions as formula columns and format triggers at report execution. The report is submitted as a concurrent request; during submission BEFOREREPORT derives the request ID and operating unit from FND_GLOBAL and FND_PROFILE, so the package must always run within an initialized EBS session. Because the package is not referenced by any other object, modifications are isolated to the India sales tax register report, but its dependency on localization views (JA* tables) means it is only meaningful in an environment where the India localization is installed.