Search Results get_ref_src_id

Overview

JA_TW_SH_GUI_UTILS is a PL/SQL utility package in the APPS schema that supports the Oracle EBS Taiwanese (JA_TW) localization for Sales Order and Accounts Receivable processing, specifically around the GUI (Government Uniform Invoice) numbering framework used in Taiwan. The package provides reusable helper logic that the Taiwanese invoice-integration UI and concurrent processes rely on to retrieve, validate, and maintain transaction numbering and transaction-source information. Because transaction sequence numbers in the Taiwanese localization must comply with local tax numbering rules, this package centralizes the lookups against receivable batch sources, customer transaction types, and the sequence repository so callers do not have to duplicate that logic.

The package is classified as OTHER in ETRM and exposes 17 documented program units. Its header comments reference an R12 MOAC enhancement (Bug 4673732), which added p_org_id parameters to key functions so multi-org access control is honored when resolving batch source and transaction type data.

Key Procedures and Functions

The most commonly referenced program unit, and the one returned by a "get_next_seq_num" search, is GET_NEXT_SEQ_NUM. It generates the next available sequence number for a supplied sequence name and returns both the numeric value and an error code through OUT parameters, making it the core numbering primitive for GUI transaction generation.

• GET_LAST_TRX_NUM — returns the last transaction number previously used for a given sequence name.
• GET_SEQ_NAME — returns the sequence name associated with a batch source ID.
• GET_TRX_SRC_INFO — returns batch source attributes such as the automatic transaction number flag, invoice word, initial/final transaction numbers, last transaction date, and advance days; accepts p_org_id for MOAC.
• GET_TRX_TYPE_INFO — returns the GUI type and invoice class for a customer transaction type ID, with p_org_id for MOAC.
• GET_REF_SRC_ID, GET_INV_WORD, GET_GUI_SRC_ID — return the reference source ID, invoice word, and GUI source ID for a batch source.
• GET_TRX_NUM_RANGE — returns the initial or final transaction number range for a batch source.
• GET_LAST_TRX_DATE and GET_ADV_DAYS — return the last transaction date and advance day count for a batch source.
• VAL_SRC_TYPE_REL — validates the relationship between an interface line, batch source, customer transaction type, and creation origin.
• VAL_TRX_NUM, VAL_TRX_DATE, VAL_MIXED_TAX_CODES — validate transaction numbers, dates, and mixed tax code combinations.
• UPDATE_LAST_TRX_DATE — updates the stored last transaction date.
• COPY_GUI_TYPE — copies GUI type information between records.

Tables Accessed

The package reads from and updates the following tables through APPS synonyms:

• RA_BATCH_SOURCES — source of batch source numbering configuration and flags.
• RA_CUST_TRX_TYPES — provides GUI type and invoice class values per transaction type.
• RA_CUSTOMER_TRX_LINES — used when validating transaction lines and sequence ranges.
• RA_INTERFACE_LINES_GT — temporary interface data used by validation routines.
• ALL_SEQUENCES — supplies the current next sequence value driving GET_NEXT_SEQ_NUM.

Usage Notes

JA_TW_SH_GUI_UTILS is typically invoked from the Taiwanese localization forms and concurrent programs that manage Government Uniform Invoice generation, and it is referenced by two other packages. GET_NEXT_SEQ_NUM is the entry point most frequently called by custom code seeking the next GUI transaction sequence number. In 12.1.1 and 12.2.2, callers should pass p_org_id where the signature requires it to ensure MOAC-correct results. Direct invocation is supported but should be limited to the transactional context for which the sequence was configured.