Search Results cf_2formula0008
Overview
The APPS.JA_JAINTSLS_XMLP_PKG package is a report logic container generated for the Oracle EBS India Localization (JA schema) "India Sales Tax" register report. It is bound to the BI Publisher/XML Publisher concurrent program JAINTSLS, which produces the India Sales Tax register and related statutory output for the Receivables (AR) subledger. The package encapsulates the PL/SQL formula columns, parameter validation triggers, and report-level Before/After Report functions required by the XML Publisher data template.
The header line confirms the object is compiled AUTHID CURRENT_USER and carries the RCS identifier $Header: JAINTSLSS.pls 120.1 2007/12/25 … noship $, indicating it is a "no ship" (non-shipped, internal) source artifact generated by the XML Publisher template builder rather than an application-programming interface. The declared globals (P_START_DATE, P_END_DATE, P_ORGANIZATION_ID, P_LOCATION_ID, P_TAX_NAME, P_TAX_ID, P_TAX_TYPE, P_REPORT_STYLE, P_ORG_ID, P_CONC_REQUEST_ID) map directly to the report's concurrent program parameters and are populated at run time from the concurrent request context.
Key Procedures and Functions
Sixteen documented program units are exposed, all declared in the package specification:
- BEFOREREPORT and AFTERREPORT — report lifecycle hooks that initialise and release session state around the data fetch.
- P_END_DATEVALIDTRIGGER — a parameter validation trigger returning BOOLEAN, used to enforce date-range consistency before the report executes.
- CF_1FORMULA, CF_1FORMULA0004, CF_1FORMULA0005, CF_1FORMULA0013 — named formula columns referenced by the XML template, each resolving a specific calculated value (line amount, taxable base, or attribute) from the row context supplied by the data model.
- CF_2FORMULA — the parent formula for line-level calculation.
- CF_2FORMULA0008 — the descendant formula keyed on TAX_ACCOUNT_ID, returning CHAR. This is the unit returned by the search term
cf_2formula0008; it typically derives a tax account name/identifier for display or grouping on the register. - CF_SALES_TAXABLE_AMT_2FORMULA — computes the taxable amount from tax type, rate, and tax amount inputs.
- CF_TRX_NUMBER_DATE_1FORMULA — formats the transaction number and transaction date into a single display string.
- C_LINE_TOTAL_W_TAXFORMULA — derives the tax-inclusive line total from the tax total and the tax-exclusive line total.
- CF_VAT_TAXES_1 — aggregates VAT components for the current line.
- CP_EXCISE_1_P, CP_ADDL_OTHER_TAXES_1_P, CP_VAT_TAXES_1_P — accessor functions returning the corresponding declared package-level accumulators (CP_EXCISE_1, CP_ADDL_OTHER_TAXES_1, CP_VAT_TAXES_1).
Tables Accessed
All reads are performed through APPS synonyms. Receivables transaction data is drawn from RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL, with payment terms supplied by AR_PAYMENT_SCHEDULES_ALL. India Localization transaction and tax detail is retrieved from JAI_AR_TRXS, JAI_AR_TRX_LINES, and JAI_AR_TRX_TAX_LINES. Supporting master data comes from JAI_CMN_TAXES_ALL (tax definitions) and JAI_CMN_CUS_ADDRESSES (customer/address details used for the report header). Concurrent program metadata and request context are read from FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS.
Usage Notes
This package is not a general-purpose API and is not referenced by any other package. It is invoked exclusively in the context of the JAINTSLS concurrent program: the concurrent manager calls the report entry point, which in turn calls BEFOREREPORT, the XML data template's SQL (which invokes the CF_* formula functions through the package), and finally AFTERREPORT. Parameter validation runs against P_END_DATEVALIDTRIGGER before submission. In 12.1.1 and 12.2.2 the object behaves identically, as its source predates both releases; in 12.2.x it remains compiled against the APPS edition. Customizations should not be applied directly to this generated package, since regeneration by the XML Publisher designer will overwrite modifications; extension points belong in the report template or in a separately named custom package.