Search Results update_last_issued_date

Overview

JA_TH_AR_TAX_INVOICE is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the "OTHER" API category in the ETRM repository. Its name identifies it as a country-specific localization component supporting Thailand ("JA_TH") tax invoice processing within Oracle Receivables. The package encapsulates validation and date-maintenance logic required to control when a Thai tax invoice may receive a transaction date and what tax code configuration must be satisfied before the document is considered valid. It operates as a supplier-side validation layer against Receivables transaction data rather than as a general-purpose public API.

The package is significant because Thai tax invoice numbering and dating are subject to statutory sequencing rules. The last issued date for a given transaction type must be tracked, and new invoices must fall within an allowable window relative to that last issued date, with an optional advance-days tolerance. JA_TH_AR_TAX_INVOICE centralizes these checks so that concurrent programs, forms-based entry, and custom extensions apply the same rules.

Key Procedures and Functions

• VALIDATE_TRX_DATE — Validates a candidate transaction date for a given Receivables transaction. It accepts identifiers for the customer transaction, the proposed transaction date, the previously issued date for the transaction type, an advance-days allowance, and a source indicator describing where the call originated. It returns a numeric status. The "created from" parameter allows the same validation to distinguish between creation channels.
• VALIDATE_TAX_CODE — Validates the tax code associated with a given customer transaction, again qualified by the creation source. It returns a numeric status indicating whether the tax configuration passes the Thai localization checks.
• UPDATE_LAST_ISSUED_DATE — Persists the last issued date for a customer transaction type following a successful invoice issuance. It takes the customer transaction, the transaction type, the transaction date, and the creation source, and returns a numeric status. This function maintains the sequencing baseline that VALIDATE_TRX_DATE later reads.

All three functions return NUMBER and are declared in the package specification, making them callable from other PL/SQL units. No procedure bodies are documented in the available metadata.

Tables Accessed

The package references two documented tables through APPS synonyms:

• RA_CUST_TRX_TYPES — the Receivables transaction type definition table. This provides the transaction type context, including setup attributes associated with numbering and dating rules for Thai tax invoices.
• RA_INTERFACE_LINES_GT — a global temporary interface table used during Receivables AutoInvoice processing. Access to this structure indicates the package participates in, or is invoked from, the interface/import path for Thai tax invoice data.

Usage Notes

JA_TH_AR_TAX_INVOICE is invoked when Thai tax invoices are created or imported, most commonly through Receivables AutoInvoice concurrent programs that stage data in RA_INTERFACE_LINES_GT, and through country-specific forms or custom wrapper code that call VALIDATE_TRX_DATE and VALIDATE_TAX_CODE before committing a transaction. The ETRM metadata records that the package is referenced by one other package, confirming it is a dependency of a higher-level localization routine rather than a standalone entry point.

Because the functions return numeric status codes, callers must interpret the return value according to the Thai localization convention and raise the appropriate application error. Implementation dates in the header comment indicate the package was last revised in 2005, and it remains available in both 12.1.1 and 12.2.2 as a legacy localization component. Customizations should treat it as a read-only dependency and avoid direct modification.