Search Results ja_zz_validate_invoice_gdf




Overview
Explore in AI Chat

Overview

JA_ZZ_VALIDATE_INVOICE_GDF is a Latin America (JA) localization package in the APPS schema that supports validation of Oracle Receivables (AR) invoices when a Global Descriptive Flexfield (GDF) is used to capture country-specific legal invoice data. The package name indicates that its purpose is to validate invoice records against Brazilian and wider Latin American fiscal requirements, in particular the manual or automatic assignment of transaction numbers and transaction dates for a given batch source and transaction type.

The package supplies a compact set of utility routines that read configuration from the source transaction setup and return either validation outcome messages or the underlying setup values. Its header carries a 120.0 version stamp dated 2004, indicating that the interface has remained stable from 11i through the 12.1.1 and 12.2.2 releases. The package is classified as OTHER under the ETRM metadata, meaning it is not a formal public API but is exposed for internal localization form and workflow processing.

Key Procedures and Functions

The ETRM metadata documents twenty callable elements. The following are the most significant.

  • GET_SEQ_NAME — Returns the sequence name associated with a batch source identifier. This is the function most closely related to the user's search term and is used when the localization derives the correct numbering sequence for a batch source.
  • GET_NEXT_SEQ_NUM — Retrieves the next available sequence number and returns it along with an error code.
  • GET_LAST_TRX_NUM / GET_LAST_TRX_DATE — Return the last transaction number or last transaction date recorded for a batch source.
  • GET_TRX_SRC_INFO — Returns source setup attributes including the automatic transaction number flag, invoice word, initial and final transaction numbers, last transaction date, and advance days.
  • GET_TRX_TYPE_INFO — Returns the GUI type and invoice class for a customer transaction type.
  • GET_REF_SRC_ID, GET_INV_WORD, GET_GUI_SRC_ID, GET_TRX_NUM_RANGE, GET_ADV_DAYS — Individual accessors for the reference source, invoice word, GUI source identifier, transaction number range boundaries, and advance days.
  • VAL_SRC_TYPE_REL, VAL_TRX_NUM, VAL_TRX_DATE — Validation routines that verify the relationship between batch source and transaction type, validate a transaction number, and validate a transaction date against the last transaction date and allowed advance days.
  • VAL_MIXED_TAX_CODES, VALIDATE_TAX_CODE, VALIDATE_TRX_DATE — Tax-code consistency and transaction date validation helpers.
  • UPDATE_LAST_TRX_DATE, UPDATE_LAST_ISSUED_DATE — Persist the last transaction date and last issued date after a successful validation cycle.
  • COPY_GUI_TYPE — Copies GUI type information as part of the localization's source-type handling.

Tables Accessed

The package reads and writes through APPS synonyms. RA_BATCH_SOURCES and RA_CUST_TRX_TYPES supply the source and transaction type setup that drives numbering and date validation. ALL_SEQUENCES is queried to resolve sequence names and confirm the existence of a numbering sequence. AR_TRX_HEADER_GT and AR_TRX_LINES_GT are the interface tables for pending invoice headers and lines. RA_CUSTOMER_TRX_LINES is referenced for line-level validation. ZX_ACCOUNTS and ZX_MCO_RATES are accessed for tax account and tax rate verification used by the tax-code validation routines.

Usage Notes

This package is typically invoked from the Receivables transaction entry forms and from concurrent programs that process Latin American invoices, where the Global Descriptive Flexfield must be validated before the record is committed. It may also be called from custom PL/SQL that implements the same validation rules, or from workflow and localization-specific subroutines. Because it is classified as OTHER and does not carry a public API designation, direct calls from custom code should be treated as unsupported and limited to read-only accessor functions such as GET_SEQ_NAME, which is used to determine the sequence name for a given batch source.