Search Results cf_countformula

Overview

JA_JAINST3_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that backs the JAINST3 Oracle Reports XML Publisher (XMLP) concurrent program. The program produces the Indian Service Tax installment and credit statement, reconciling service cess and education cess balances across a reporting period. In EBS 12.1.1 and 12.2.2 the package is delivered as a companion to a report definition registered under the JA (India Localization) product, and it is classified in ETRM as API classification OTHER, meaning it is not a public interface but an internal report-support package.

The package holds the report's global parameter and computed-value state — PRM_RGM_PRIM_REGNO, PRM_FROMDT, PRM_TODT, PRM_ORG_ID, PRM_SERVICE_TYPE, P_REGIME, P_CONC_REQUEST_ID, and the Cp_* accumulation variables — and exposes the formula functions that the report layout calls to derive each column value at run time. It is the runtime engine behind every calculated figure on the printed statement.

Key Procedures and Functions

The documented interface contains 36 callable units. The most significant, and the entry point of interest for the search term "cf_countformula", belong to the CF_*FORMULA family of report formula columns:

• CF_REALISED_AMOUNTFORMULA — derives the realised amount from tax amount, recovered amount, and charged/billed inputs.
• CF_OPENING_BALANCEFORMULA, CF_CLOSING_BALANCEFORMULA, CF_TOTAL_CREDITFORMULA — compute the opening balance, total credit, and closing balance of the cess ledger for the period.
• CF_CREDIT_AVAILEDFORMULA, CF_CREDIT_RECEIVEDFORMULA, CF_CREDIT_UTILIZEDFORMULA, CF_CREDIT_INPUT_SERVICESFORMUL — the credit movement columns: credit availed, credit received, credit utilised, and input-service credit.
• CF_EDUCESS_OPENING_BALANCEFORM, CF_EDUCESS_CREDIT_AVAILEDFORMU, CF_EDUCESS_CLOSING_BALANCEFORM — the parallel education-cess balance series.
• CF_CCRD_ST_DISTRIBUTEDFORMULA, CF_CCRD_CLOSING_BALANCEFORMULA, CF_ECRD_EC_DISTRIBUTEDFORMULA — distributed-credit and closing-balance derivations for the central and education credit registers.
• CF_SERVICEFORMULA, CF_INVOICE_NUMFORMULA, CF_ST_SERVICE_AMOUNTFORMULA — resolve the service description, invoice number, and service-cess amount for a supplied month and year.
• CF_1FORMULA, CF_2FORMULA, CF_RETURN_NULL — layout helpers returning character output and a null placeholder for empty report cells.

Most monthly formula functions accept a month and year pair and return the corresponding figure, so the report layout can iterate months without re-querying.

Tables Accessed

The package reads its transactional and setup data through APPS synonyms. Invoice and payment facts come from AP_INVOICES_ALL and AP_INVOICE_PAYMENTS_ALL; vendor and item configuration come from JAI_CMN_VENDOR_SITES and JAI_INV_ITM_SETUPS. The India localization registers JAI_RGM_MANUAL_TRXS, JAI_RGM_TRX_RECORDS, and JAI_RGM_TRX_REFS supply the service-tax and cess transaction records that the balance formulas summarise. FND_CONCURRENT_PROGRAMS and FND_CONCURRENT_REQUESTS are consulted to identify the running concurrent request from P_CONC_REQUEST_ID, and the V$DATABASE, V$PROCESS, and V$SESSION dynamic performance views are used for session and instance context. No writes to application tables are documented; the package is read-only apart from its own package-level state.

Usage Notes

JA_JAINST3_XMLP_PKG is invoked exclusively through the JAINST3 concurrent program. Oracle Reports calls the CF_*FORMULA functions as formula columns, while the before-report and after-report triggers assign the PRM_* parameters and initialise the Cp_* accumulators. Because the package is registered with API classification OTHER and is referenced by zero other packages, it should not be called directly from custom code. Any extension should be made through a copy of the report definition rather than by modifying APPS.JA_JAINST3_XMLP_PKG in place.