Search Results init_acct_dependencies




Overview
Explore in AI Chat

Overview

GL_JE_LINES_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM documentation as OTHER rather than as a published public API. It encapsulates the core business logic that governs journal entry lines within Oracle General Ledger. Journal lines represent the individual debit and credit distributions that make up a journal entry, and this package provides the programmatic operations required to validate, insert, update, delete, and total those lines. The package is referenced directly by GL_JE_HEADERS_PKG and is self-referential, indicating that line-level processing is invoked in coordination with header-level processing. In the context of Oracle EBS 12.1.1 and 12.2.2, GL_JE_LINES_PKG serves as an internal workhorse supporting the Journal Entry form and related general ledger transactions rather than a documented integration interface for external callers.

Key Procedures and Functions

The ETRM metadata documents seventeen procedures and functions. Several address data integrity and validation:

  • CHECK_UNIQUE verifies that a journal line does not duplicate an existing line, supporting unique-line enforcement within a journal entry.
  • HEADER_HAS_STAT and HEADER_HAS_TAX determine whether the parent journal header already contains statistical or tax-related lines, which affects downstream defaulting and validation behavior.

Maintenance routines operate on sets of lines and records:

  • INSERT_ROW, UPDATE_ROW, DELETE_ROW and LOCK_ROW provide the granular row-level operations against journal line records, including concurrency locking.
  • INSERT_LINES, UPDATE_LINES and DELETE_LINES (INSERT_ROW-driven bulk variants such as DELETE_LINES and UPDATE_LINES) support multi-line maintenance during journal entry or modification.
  • CALCULATE_TOTALS computes aggregate debit and credit amounts across the lines of a journal entry, supporting balance checking.

Defaulting and tax-related routines include POPULATE_FIELDS, INIT_ACCT_DEPENDENCIES, GET_TAX_DEFAULTS, DEFAULT_TAX_TYPE, DEFAULT_TAX_CODE, DEFAULT_ROUNDING_RULE, and DEFAULT_INCLUDES_TAX, which derive account dependencies and tax attributes such as tax type, tax code, rounding rule, and tax-inclusive treatment for journal lines.

Tables Accessed

The package accesses three documented tables through APPS synonyms:

  • GL_JE_LINES — the primary table it manipulates, holding the debit and credit distributions of each journal entry.
  • GL_CODE_COMBINATIONS — consulted for account validation and to resolve account-dependent defaulting behavior, particularly through INIT_ACCT_DEPENDENCIES.
  • ZX_ACCOUNT_RATES — used by the tax-defaulting logic to obtain tax rates applicable to journal lines, reflecting the integration between General Ledger and E-Business Tax.

Usage Notes

Because GL_JE_LINES_PKG is classified as OTHER and depends only on SYS.STANDARD and is referenced by GL_JE_HEADERS_PKG, it is an internal implementation package rather than a formally published API. In practice it is invoked by the Journal Entry form (GLXJEENT) and by GL_JE_HEADERS_PKG when journal headers and their lines are created, updated, validated, or deleted. Concurrent programs that import or generate journals may indirectly exercise its line-level routines. Custom code should avoid direct calls to this package; developers requiring journal line manipulation should use the documented Journal Import and GL journal APIs instead. Referencing this package directly risks incompatibility across patch levels and releases, including the 12.1.1 to 12.2.2 transition.