Search Results jg_glppos_pkg




Overview
Explore in AI Chat

Overview

JG_GLPPOS_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM (E-Business Suite Technical Reference Manual) as an "OTHER" API type. Its name combines the "JG" prefix — denoting the Global Accounting/Global Consolidation family of modules (also referenced in objects such as JG_ZZ and JG_GL) — with "GLPPOS," which strongly associates the package with General Ledger posting processes. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, a common convention for utility or hook packages that must respect the caller's security context during posting operations.

Based on the single documented procedure and the module naming, the package serves as a posting-related utility within the JG (Global Accounting) application, invoked during the General Ledger posting cycle to perform a specialized step that the standard GL posting engine (GLPPOS) delegates or supplements.

Key Procedures and Functions

  • GLPHK — The sole documented procedure in the package. It accepts a posting_run_id parameter, identifying the specific posting run to act upon. The name "GLPHK" strongly suggests it implements a posting hook — a callback or extension point invoked by the GL posting engine for each posting run. Its role is to execute custom or module-specific logic during posting, keyed to the posting run identifier.

No other procedures or functions are documented in the 12.2.2 package metadata. The header comment references revision 120.1.12010000.1, dated 2009, which indicates the package has remained stable across the 12.1.1 and 12.2.2 releases.

Tables Accessed

  • FND_PRODUCT_INSTALLATIONS — Referenced via an APPS synonym. The package reads this table to determine which Oracle applications are installed and at what status, enabling it to conditionally execute logic only when the relevant JG/GL modules are present. This is a typical guard pattern for shared or cross-module utilities.
  • DUAL — The standard Oracle single-row dummy table, referenced for simple evaluation or selection of scalar values (for example, returning an installation status flag) without touching application data.

Notably, the package does not write to any posting or journal tables directly according to the documented metadata; its interaction is with installation and control data.

Usage Notes

Given its "hook" naming and single-parameter signature, JG_GLPPOS_PKG.GLPHK is typically invoked by the standard General Ledger posting engine or by the JG Global Accounting posting flow rather than by end users. It is not exposed through a form or concurrent program in the documented metadata; instead it is referenced programmatically — the ETRM records that it is referenced by one other package, confirming it participates in an internal call chain.

When customizing or troubleshooting posting behavior in EBS 12.1.1 or 12.2.2, developers should treat JG_GLPPOS_PKG as a posting-run hook: it is called with the active posting_run_id, and any changes to its logic affect the posting cycle for the invoking module. Because it is AUTHID CURRENT_USER and reads FND_PRODUCT_INSTALLATIONS, its behavior can vary by installation footprint, and it should be modified only with awareness of the calling package. The stable revision history suggests no functional changes were required between the two releases.