Search Results fetch_jl_seq

Overview

The APPS.JA_CN_UPDATE_BANK_SEQ_PKG package is a China localization (JA_CN) database component within Oracle E-Business Suite. Its stated purpose, per the package header, is to fetch a sequence number for the Journal export program. It supports the Chinese statutory requirement that journal vouchers carry a controlled, sequentially assigned voucher number, often referred to as the bank sequence or voucher bank number, under a specific legal entity, ledger, and accounting period.

The package is declared with AUTHID CURRENT_USER, meaning its unqualified references resolve against the schema of the invoking user rather than the package owner. The header identifies the file as JACNUBSS.pls and traces its origin to a 2012 creation by Jar Wang, with the last recorded revision in 2013. The associated design reference, CNAO_Journal_Voucher_Number_TD.doc, indicates the routine was built to satisfy a defined voucher-numbering design rather than an ad hoc requirement.

Key Procedures and Functions

The package exposes a single documented public function: FETCH_JL_SEQ. It is described as returning a sequence number scoped to the legal entity and ledger, together with the period name, for consumption by the Journal export program. The function accepts inputs identifying the legal entity, the balance segment value, the ledger, and the period name, and returns a numeric value. It should be treated as the sole entry point into this package; no other procedures or functions are documented in the ETRM metadata, and the package body is not exposed for direct reference.

Because the routine is a function rather than a procedure, it is intended to be called inline within SQL or PL/SQL expressions wherever a voucher sequence value is required, rather than as a standalone executable step. Callers should observe the four input parameters as documented and must not assume additional or optional arguments exist.

Tables Accessed

The package operates against JA_CN_VOUCHER_BANK_NUM (referenced through an APPS synonym). This table holds the voucher bank numbering state used by the China journal export process. The function reads and updates the relevant row for the supplied legal entity, ledger, and period to obtain and advance the sequence value. Because a sequence retrieval of this nature generally implies a read followed by an increment, the package is expected to insert or update the numbering record as each journal export consumes a number, preserving contiguous numbering within the period. Under the AUTHID CURRENT_USER declaration, the invoking user must hold appropriate privileges on this table.

Usage Notes

The package is documented as referenced by one other package, indicating it is invoked indirectly from within the China journal export flow rather than called directly by end users. Typical invocation paths include the Chinese journal export concurrent program and any localization form or routine that prepares journal voucher output for statutory reporting. Custom extensions should call FETCH_JL_SEQ only within the same transaction that writes the corresponding journal voucher records, so that numbering and voucher creation remain consistent. Because the routine advances shared numbering state, callers should avoid invoking it speculatively, in parallel without coordination, or outside the intended period and ledger context. All behavior described here is limited to what the ETRM metadata documents; the package body and internal logic are not published.