Search Results get_term_id

Overview

APPS.JAI_CMN_RGM_TERMS_PKG is an Oracle EBS PL/SQL package that belongs to the ETRM (Excise Tax and Regime Management) product family, often referred to within the Oracle India Localization (JAI) module. The package was created to provide claim term information, as stated in its header, and serves as a programmatic interface for retrieving, generating, and managing the lifecycle of claim terms. Terms in this context represent the commercial or statutory conditions, schedules, and installment structures attached to a regime registration, which govern how amounts are claimed or recovered.

The package resides in the APPS schema with an API classification of OTHER, indicating it is not a formal public API but rather an internal utility used across the JAI Regime Management (RGM) components. Its primary responsibilities include resolving the applicable term for a given regime, item, organization, party, and location combination, generating term schedules and installments, and marking a term as in use. These operations support the downstream calculation of claim schedules that feed into excise and regime processing.

Key Procedures and Functions

• GET_TERM_ID — Resolves and returns the applicable term identifier for a specified regime, item, organization, party type, and location. It is the procedure most commonly referenced in custom extensions because it allows callers to determine which term applies to a given business context without querying the assignment tables directly. It returns the term ID along with a process flag and a process message to indicate success or the reason for failure.
• GENERATE_TERM_SCHEDULES — Accepts a term identifier, an amount, and a register date, and generates the associated term schedule records that represent the claim timeline. It returns a generated schedule identifier plus process status and message outputs, enabling callers to chain subsequent processing on the newly created schedule.
• SET_TERM_IN_USE — Marks the specified term as being in use, returning standard process status and message outputs. This procedure supports lifecycle management of terms, preventing conflicting changes to a term once it is actively referenced by schedules or registrations.

Tables Accessed

The package reads from and writes to several ETRM regime management tables through APPS synonyms:

• JAI_RGM_TERMS — The master definition of terms; read for term attributes and updated to reflect in-use status.
• JAI_RGM_TERM_ASSIGNS — Maps terms to regime, item, organization, party type, and location combinations; central to GET_TERM_ID resolution.
• JAI_RGM_TRM_SCHEDULES_T and JAI_RGM_TRM_SCHEDULES_T_S — Term schedule and schedule serial records populated by GENERATE_TERM_SCHEDULES.
• JAI_RGM_TERM_INSTALLMENTS — Installment breakdown used when generating schedules.
• JAI_RGM_DEFINITIONS and JAI_RGM_REGISTRATIONS — Regime definitions and registrations that provide context for term resolution.
• DUAL — Used for scalar validation and utility queries.

Usage Notes

This package is typically invoked from Oracle Forms, concurrent programs, and custom PL/SQL code within the JAI localization. GET_TERM_ID is frequently called by custom extensions and by other JAI packages that need to determine the term applicable to a transaction before calculating claim amounts. The metadata records that this package is referenced by two other packages, confirming its role as a shared dependency. Because the package is classified as OTHER rather than a formal API, callers should treat the interface as internal and validate behavior against the target release (12.1.1 or 12.2.2) after applying patches.