Search Results p_period_name

Overview

The APPS.JA_CN_UPDATE_JL_SEQ_PKG package body is a China localization (JA_CN) component within Oracle E-Business Suite, delivered in both 12.1.1 and 12.2.2. Its documented purpose is to fetch and maintain sequence numbers used by the Journal Itemization program. The package supports the generation of sequential journal numbering under a specific Legal Entity, Ledger, and accounting Period, storing the current value in the JA_CN_JOURNAL_NUMBERING table. The package header carries the source file identifier JACNVJSB.pls (version 120.1.12000000.1) and an original creation date of 13-March-2006 by Jackey Li, with a subsequent revision on 28-April-2007 by Qingjun Zhao to add the Ledger_id column to the numbering table.

The package is classified under the ETRM API classification of OTHER. It is referenced by two other packages, indicating it functions as a shared utility consumed by higher-level China localization journal processing logic rather than as a standalone entry point.

Key Procedures and Functions

The package body declares three program units, with one — FETCH_JL_SEQ — listed in the ETRM documented procedures for the object:

• FETCH_JL_SEQ — The documented function used to fetch a sequence number for the Journal Itemization program. Its parameter list is not reproduced here from the metadata; based on the package's stated design, it supplies the next journal itemization sequence value to calling code.
• CREATE_JL_SEQ — A private procedure that creates a sequence number record under a given Legal Entity, Ledger, and Period Name, initializing the value to '2'. The package header documentation lists its input parameters conceptually as a legal entity identifier and a period name, with the Ledger identifier added by the 2007 revision.
• UPDATE_JL_SEQ — A procedure used to update an existing sequence number record for the applicable Legal Entity, Ledger, and Period, advancing the stored value as journal itemization proceeds.

All three units operate against the single China localization numbering table and share the package's logging framework, which uses global variables tied to FND_LOG procedure and statement levels.

Tables Accessed

The package accesses one documented table, JA_CN_JOURNAL_NUMBERING, referenced through an APPS synonym. This table stores the journal itemization sequence state keyed by Legal Entity, Ledger, and Period Name. The CREATE_JL_SEQ procedure inserts the initial row for a new combination, while UPDATE_JL_SEQ modifies the existing value. The Ledger_id column was added to this table as part of the April 2007 enhancement, meaning deployments predating that revision stored sequence state without ledger-level granularity.

Usage Notes

Because the package is classified as OTHER and is referenced by two dependent packages, it is not intended to be invoked directly by end users. It is typically called from the China localization Journal Itemization concurrent program or from the dependent packages that drive journal sequencing during period processing. The user search term p_period_name corresponds to the period-level parameter that scopes sequence records to a specific accounting period, so any diagnostic or extension work involving this package will require passing a valid, open or closed period name from GL_PERIODS, together with the appropriate Legal Entity and Ledger identifiers.

When debugging sequence collisions or duplicate journal numbers, verify that a numbering row exists for the Legal Entity, Ledger, and Period combination; if absent, CREATE_JL_SEQ is responsible for inserting the initial value of '2'. The presence of the FND_LOG global variables indicates that runtime diagnostics can be enabled through standard EBS logging profiles rather than by code modification.