Search Results move_taxes_hook




Overview
Explore in AI Chat

Overview

APPS.GL_JOURNAL_IMPORT_TAX_PKG is a server-side PL/SQL package within the Oracle E-Business Suite General Ledger module. Its stated purpose, per the package header, is to consolidate all server-side procedures required for processing journal import tax details. The package was originally created on 19-Aug-2003 by V. Treiger and is catalogued in ETRM 12.2.2 under the APPS schema with an API classification of OTHER, indicating that it is an internal utility package rather than a formally published public API.

The package addresses a specific gap in the standard Journal Import flow: tax detail information associated with journal lines must be moved or reconciled into the appropriate General Ledger structures after import. GL_JOURNAL_IMPORT_TAX_PKG provides the mechanisms to perform this tax detail movement both from a concurrent program (SRS) context and from within the Journal Import execution hook itself.

Key Procedures and Functions

The package exposes four documented procedures, all declared in the package specification:

  • UPDATE_TAXES — Serves as the wrapper procedure invoked from a concurrent program (SRS). It accepts a batch name and returns the standard concurrent manager OUT parameters (errbuf and retcode) alongside the batch name, allowing the program to report success or failure back to the concurrent manager. It exists to expose the tax-movement logic to a schedulable concurrent program.
  • MOVE_TAXES_SRS — Performs the actual movement of tax details when driven from the SRS (concurrent program) path. It operates on a single batch identified by batch ID.
  • MOVE_TAXES_HOOK — Performs the equivalent tax detail movement when invoked from the Journal Import hook, again keyed by batch ID. This is the entry point used when tax processing must occur inline as part of journal import rather than as a separate scheduled request.
  • PROCESS_BATCH_LIST — Parses a separator-delimited list of batch IDs and processes each one by calling the tax-movement logic. It provides a mechanism for handling multiple batches in a single invocation.

Tables Accessed

Per the documented table references (via APPS synonyms), the package operates against the core Journal Import and journal entry tables:

  • GL_JE_BATCHES — The journal batch header table, used to identify and validate the batch whose tax details are being processed.
  • GL_JE_HEADERS — The journal header table, used to locate the journals belonging to the batch and to associate tax details at the journal level.
  • GL_JE_LINES — The journal line table, where tax-related line attributes are read and updated as tax detail information is moved into place.

These three tables form the standard parent-child hierarchy (batch → header → line), and the package's tax-movement logic necessarily traverses this hierarchy to relocate tax details onto the correct journal lines.

Usage Notes

GL_JOURNAL_IMPORT_TAX_PKG is not a general-purpose API and is referenced by zero other packages per the ETRM metadata, confirming its role as a leaf-level internal utility. It is typically invoked in one of two ways:

  • Concurrently — Through the UPDATE_TAXES wrapper, which is designed for registration as a concurrent program. The batch name parameter allows an operator or scheduler to target a specific batch.
  • Inline during Journal Import — Through MOVE_TAXES_HOOK, which is called by the Journal Import process itself so that tax details are moved as part of the import transaction.

PROCESS_BATCH_LIST supports bulk invocation when multiple batches require processing. Because the package is classified as OTHER and carries an older header revision (120.1, 2005), customizations should avoid direct dependency on its internal logic. Its documented interfaces should be treated as internal and subject to change across patch levels in both 12.1.1 and 12.2.2.