Search Results lv_adjust_liability

Overview

JA_JAINRGCR_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by APPS that supports the India Localization Service Tax Register / Input Tax Credit register reporting program, internally identified as JAINRGCR (India Register Credit). Its name follows the standard XML Publisher concurrent program package convention, in which a report-specific PL/SQL package supplies the data-level formulas, lexical parameters, and report triggers consumed by an underlying XML Publisher (BI Publisher) template. The package header declares global variables used for date range binding (P_FROM_DATE, P_TO_DATE), period and regime selection (P_REGM_PRMY_REGN), concurrent request identity (P_CONC_REQUEST_ID), organization and reporting entity filtering (P_ORG_WHERE, P_REPORTING_ENTITY_ID, P_REPORTING_LEVEL), and character-format date bind variables (CP_FROM_DATE, CP_TO_DATE). The package exposes a set of report-level trigger functions and column formula functions that compute credit taken, credit utilized, opening and closing balances, service type classification, document descriptions, and taxable values directly within the report query.

Key Procedures and Functions

The package documents ten procedures and functions:

• BEFOREREPORT — the standard report trigger executed before the report query runs, used to initialize package globals such as the date range, organization predicate, and concurrent request context.
• AFTERPFORM — a report trigger fired after the parameter form is submitted, allowing parameter values to be validated or transformed.
• AFTERREPORT — the report trigger executed after the report data is generated, conventionally used for cleanup of package state.
• CF_CREDIT_TAKENFORMULA — computes the credit taken from service credit and education cess credit inputs.
• CF_CREDIT_UTILIZEDFORMULA — computes the credit utilized for the reporting period.
• CF_OPENING_BALFORMULA — derives the opening balance of the credit ledger for the reporting period.
• CF_CLOSING_BALFORMULA — calculates the closing balance from opening balance, credit taken, and credit utilized.
• CF_SERVICE_TYPEFORMULA — maps a service type code to the descriptive service type shown on the report based on the LV_TAX_TYPE constants (Service, SERVICE_EDUCATION_CESS, SERVICE_SH_EDU_CESS).
• CF_VALUEFORMULA — the function most relevant to the cf_valueformula search; it derives the report's taxable or reported value from an invoice reference, source type, service tax rate, service tax amount, and base value input.
• CF_DESCRIPTIONFORMULA — resolves the descriptive text for a source document or item based on source document id, item id, and source type.

The package also declares constant values used to classify source distributions, tax types, and recovery/liability categories, including LV_SERVICE_REGIME ('SERVICE'), LV_RECOVERY, LV_LIABILITY, LV_ADJUST_RECOVERY, LV_ADJUST_LIABILITY, and the SERVICE_DISTRIBUTE_IN/OUT source types.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

• JAI_RGM_DIS_SRC_HDRS, JAI_RGM_DIS_SRC_TAXES, JAI_RGM_DIS_DES_HDRS, JAI_RGM_DIS_DES_TAXES — the India localization Register Source and Destination headers and tax lines that hold the reporting data being presented.
• JAI_RGM_TRX_RECORDS, JAI_RGM_TRX_REFS — transaction records and cross-references supporting the register lines.
• AP_PAYMENT_SCHEDULES_ALL — supplier invoice payment schedule information used for taxable base determination.
• FND_CONCURRENT_REQUESTS, FND_CONCURRENT_PROGRAMS — used to resolve the concurrent request identity and program context.
• HR_ALL_ORGANIZATION_UNITS — organization unit resolution for the reporting entity and organization-level security predicate.
• MTL_SYSTEM_ITEMS — item description resolution used by CF_DESCRIPTIONFORMULA.
• V$SESSION, V$PROCESS, V$DATABASE — standard database/session context views used to identify the executing session.

Usage Notes

This package is invoked exclusively through the Oracle EBS concurrent manager when the associated India Localization register concurrent program is submitted. It is not a general-purpose API and is not referenced by any other package, so direct calls from forms or custom code are not expected. Report templates call the CF_* formula functions as column formulas; report triggers call BEFOREREPORT, AFTERPFORM, and AFTERREPORT. Customizations should be limited to template-level changes, since modifying the package body requires an APPS-level compilation and is subject to India Localization patch overlays.