Results for “tds_invoice_batch”
4 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JAI_CONSTANTS is the central constants repository for the Oracle E-Business Suite India Localization (JAI) product family. As its header comment states, the package "is coded as a common reference to different Constants that are [to] be used across the product." It does not perform business logic; instead, it exposes a single, authoritative set of named literals — status codes, class codes, regime identifiers, GL source and category names, and trigger action names — so that every JAI module (tax, excise, VAT, TDS, TCS, and related sub-ledger components) references the same values rather than hard-coding string literals in individual packages.
The package history spans 2004 to 2008 and reflects the progressive evolution of the India Localization tax regime. Early versions (Bug#4068823, 3940588) established the base constant set. Subsequent revisions added VAT constants (Bug#4250236), replaced old DB entity names for CASE compliance, removed embedded SQL literals and introduced item class and closed code constants, revised GL sources and GL categories (Bug#4477004), added trigger action constants for insert/delete/update, introduced TDS batch and regime constants (Bug#4584221), and forward-ported CVD (Bug#5228046), TCS (Bug#5631784) and related 11i enhancements. The package is deployed identically across EBS 12.1.1 and 12.2.2, owned by APPS, and classified as OTHER rather than as a callable business API.
Key Procedures and Functions
The ETRM metadata records zero documented procedures or functions for JAI_CONSTANTS. This is consistent with its design: it is a specification-only package whose body consists primarily of PL/SQL constant declarations, not executable subprograms. The public interface is therefore a namespace of named constants rather than a set of callable routines.
Among the constants documented through the change history excerpt are:
- Regime and registration constants — including regn_type_tds_batch (value 'TDS_INVOICE_BATCH') and tds_regime (value 'TDS'), added for TDS batch processing.
- Item class codes — enumerated class identifiers consumed by item classification and tax determination logic.
- Closed code values — used to mark records or periods as closed.
- Trigger action constants — values representing the inserting, deleting, and updating actions performed by database triggers and audit routines.
- GL source and GL category values — naming constants for sub-ledger accounting sources and categories, revised under Bug#4477004.
- VAT-related constants — introduced as part of the VAT implementation effort.
Because the exact list of constants is version-dependent, custom code should reference the constant by name rather than by literal value, so that forward ports of the localization continue to resolve correctly.
Tables Accessed
No tables are documented as referenced through APPS synonyms for this package. This is expected: a pure constants package performs no SQL and therefore accesses no database objects. The absence of a table list should not be interpreted as missing documentation.
Usage Notes
JAI_CONSTANTS is referenced by 187 other packages, making it one of the most widely depended-upon objects in the India Localization schema. It is typically consumed at compile time within other JAI PL/SQL packages, where a fully qualified reference such as jai_constants.<constant_name> replaces an embedded literal. It is not invoked directly from Oracle Forms or concurrent programs; rather, forms and concurrent managers reach it indirectly through the packages that call it.
For users investigating the search term "order_booked," the relevant point is that order booking status values used by India Localization reporting and tax determination are defined as constants in this package rather than in application tables. Developers writing extensions should always reference jai_constants values instead of duplicating literals, and should verify the constant name against the deployed version, since constants were added and renamed across file versions 115.0 through 120.6. Any modification to constant values requires a coordinated patch, as 187 dependent packages compile against this specification.
-
India localization regime registration attribute names
-
India localization regime registration attribute names
-
PACKAGE: APPS.JAI_CONSTANTS 12.1.1
-
PACKAGE: APPS.JAI_CONSTANTS 12.2.2