Search Results g_proc_level




Overview
Explore in AI Chat

Overview

JA_CN_EAB_EXPORT_PKG is an Oracle Applications (APPS) PL/SQL package body that supports the Chinese localizations for Oracle E-Business Suite. Its documented purpose is to export the electronic accounting book (EAB) information required for statutory reporting under Chinese accounting and tax regulation. The package header comment identifies it as JACNVBEB.pls and dates its creation to 13-Mar-2006, with a subsequent update on 10-Jul-2006 that changed how the account structure is derived (Bug 5380368). The most recent header revision shown is 120.1.12000000.1 (13-Aug-2007). In ETRM the object is classified as API classification OTHER and is owned by APPS.

The package collects ledger, book, company and organisation context from the JA_CN_SYSTEM_PARAMETERS_ALL and GL_LEDGERS tables, resolves the account structure and functional currency, and emits the resulting electronic accounting book export for the operating unit. It is referenced by one other package, indicating it sits within a small localization call graph rather than being a general-purpose utility.

Key Procedures and Functions

The ETRM metadata formally documents a single public entry point, EXECUTE_EXPORT. The package header additionally lists internal procedures that support the export: Query_System_Options, Parse_Account_Structure, Query_Currency and Query_Software_Infor.

  • EXECUTE_EXPORT — the documented public procedure and the principal entry point. It drives the electronic accounting book export: it reads system parameters and ledger context, invokes the internal query and parsing routines, and produces the export output.
  • Query_System_Options — retrieves the Chinese localization system parameters (book number, book name, company name, organisation, enterprise quality and industry) used to seed the export.
  • Parse_Account_Structure — derives and parses the accounting flexfield structure; the header history indicates this logic was revised to correct account structure derivation.
  • Query_Currency — resolves the functional currency applied to the export.
  • Query_Software_Infor — obtains the software name and version reported with the exported book.

No parameter lists are documented in the supplied metadata, and none are asserted here.

Tables Accessed

The following tables are accessed through APPS synonyms:

  • JA_CN_SYSTEM_PARAMETERS_ALL — the primary localization parameter table, supplying book number, book name, company name, organisation identifier, enterprise quality and enterprise industry.
  • GL_LEDGERS — provides the ledger identifier that anchors the export to the correct accounting ledger.
  • JA_CN_SUB_ACC_SOURCES_ALL — supplies sub-account source definitions used when parsing the account structure.
  • FND_CURRENCIES_TL — the translated currency table, used to resolve currency names and descriptions.
  • AD_RELEASES — the applications release table, used to determine the software version reported by Query_Software_Infor.

Usage Notes

The package exposes a single documented procedure, EXECUTE_EXPORT, and is therefore normally invoked as a unit of work rather than called piecemeal. Typical invocation paths are a concurrent program registered against EXECUTE_EXPORT, or a form or custom PL/SQL block that calls APPS.JA_CN_EAB_EXPORT_PKG.EXECUTE_EXPORT directly. Because the package relies on session-level package state (g_ledger_id, g_book_num, g_functional_currency and related globals), each invocation should be treated as a discrete export run.

Regarding the search term g_dbg_level: the package declares g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level, together with g_proc_level (FND_LOG.Level_Procedure) and g_stmt_level (FND_LOG.Level_Statement). These globals bind the package to the Oracle Application Object Library FND_LOG diagnostic facility, so runtime tracing is controlled through the standard FND logging profile options rather than by any package-specific flag. Administrators enabling FND debug logging for this package will therefore see procedure- and statement-level messages emitted by EXECUTE_EXPORT and its internal routines.