Search Results default_rounding_rule

Overview

The APPS.GL_JE_LINES_PKG package body encapsulates the core business logic used to create, validate, maintain, and delete journal entry lines within Oracle General Ledger. Journal entry lines represent the individual debit and credit distributions that make up a balanced journal entry, and this package serves as the underlying programmatic engine that enforces data integrity for them across Oracle E-Business Suite releases 12.1.1 and 12.2.2.

Beyond basic line maintenance, the package also contains logic for statistical line detection, tax handling, and calculation of entered versus accounted amounts. This makes it equally relevant to standard journal entry processing and to the subledger accounting flows that generate GL journal lines. The presence of tax-related routines reflects the integration between General Ledger and E-Business Tax, which supplies default tax types, tax codes, rounding rules, and the "includes tax" indicator for taxable journal lines.

Because the package is classified as an API of type OTHER, it is intended for controlled internal use rather than as a fully published public API, but Oracle forms, concurrent programs, and customer extensions commonly call into it directly or indirectly.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions grouped by purpose.

• CHECK_UNIQUE — validates that a journal entry line number is unique for a given header, preventing duplicate line numbers.
• DELETE_LINES — deletes all journal lines belonging to a header and removes any associated import reference lines.
• UPDATE_LINES, INSERT_ROW, LOCK_ROW, UPDATE_ROW, DELETE_ROW — the core record-level DML routines that insert, lock, update, and delete individual lines in the journal entry lines table.
• CALCULATE_TOTALS — computes totals for a set of journal lines, typically used to verify that debits and credits balance.
• HEADER_HAS_STAT, HEADER_HAS_TAX — predicate functions that determine whether a given header contains statistical lines or tax lines respectively, allowing downstream logic to branch accordingly.
• POPULATE_FIELDS, INIT_ACCT_DEPENDENCIES — initialise and populate line attributes and accounting flexfield-dependent values.
• GET_TAX_DEFAULTS, DEFAULT_TAX_TYPE, DEFAULT_TAX_CODE, DEFAULT_ROUNDING_RULE, DEFAULT_INCLUDES_TAX — the tax defaulting family. These resolve, from E-Business Tax configuration, the default tax type, tax code, rounding rule, and the DEFAULT_INCLUDES_TAX flag, which indicates whether the entered amount already includes tax.

Tables Accessed

• GL_JE_LINES — the primary table; all insert, update, delete, uniqueness, and total calculations operate against it.
• GL_CODE_COMBINATIONS — read to validate and resolve accounting flexfield combinations assigned to lines, supporting the account dependency initialisation routines.
• ZX_ACCOUNT_RATES — read by the tax defaulting routines to derive tax rates and related defaults from E-Business Tax, which underpins DEFAULT_TAX_TYPE, DEFAULT_TAX_CODE, and DEFAULT_INCLUDES_TAX.

Usage Notes

GL_JE_LINES_PKG is typically invoked from the Enter Journals form within General Ledger, from journal import and subledger accounting flows, and from concurrent programs that mass-create or validate journal lines. The presence of tax defaulting routines means it is called during journal entry whenever a line is flagged as taxable, so that the correct tax type, code, rounding rule, and "includes tax" indicator are applied automatically.

Custom code that needs to manipulate GL journal lines should call the public procedures rather than issuing direct DML, since these routines enforce the unique line number, balancing, and tax defaults that keep journal entries consistent. Only one other package is documented as referencing this package, indicating a relatively contained dependency footprint and reinforcing that it should be treated as a low-level utility supporting higher-level journal entry processing.