Search Results pqh_bdgt_realloc_log_pkg




Overview
Explore in AI Chat

Overview

The APPS.PQH_BDGT_REALLOC_LOG_PKG package is a PL/SQL logging utility within the Oracle E-Business Suite Public Sector / Human Resources budget reallocation framework. It is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, which is consistent with an internal utility designed to be invoked from other PL/SQL units within the same application session. The package's header comment, dated 2003, identifies it as a non-shipped (noship) internal component whose purpose is to record diagnostic and trace information during budget reallocation processing.

Its role is to capture structured log entries that describe the progress and outcome of budget reallocation rules applied to specific entities — folders, transactions, transaction entities, and budget entities. This gives implementers and support personnel a mechanism to audit how reallocation logic evaluated each entity, what rule was applied, at what level, and whether any message or error condition was produced. The documentation classifies the package under API classification OTHER, confirming it is not a public, supported integration API but an internal logging facility.

Key Procedures and Functions

Three procedures are documented in the package specification.

  • START_LOG — Opens a log context for a given entity. It is intended to be called at the beginning of a reallocation operation so that subsequent rule evaluations are associated with the correct folder, transaction, or transaction entity. Parameters include folder, transaction, and entity identifiers, plus transaction entity type and budget entity type.
  • LOG_RULE_FOR_ENTITY — Records the application of an individual budget rule against a specific entity. It captures identifiers for the folder, transaction, entity, and budget period, together with the rule name, rule level, and a rule message code. This procedure is the primary mechanism for writing detailed, rule-level trace records.
  • END_LOG — Closes the log context opened by START_LOG. It accepts the transaction entity type and optional folder, transaction, and entity identifiers, and is typically invoked at the conclusion of processing to finalize and flush the logging context. This is the procedure most commonly sought by users searching for "end_log," since it marks the termination point of a logged reallocation run.

Tables Accessed

The package interacts with a set of budget and logging tables, referenced through APPS synonyms.

Usage Notes

PQH_BDGT_REALLOC_LOG_PKG is not intended for direct invocation by end users. It is invoked internally by the budget reallocation engine and is referenced by one other package within the application. Typical callers are the reallocation driver routines that iterate folders, transactions, and budget entities, calling START_LOG at the outset, LOG_RULE_FOR_ENTITY as each rule is evaluated, and END_LOG upon completion. Implementers diagnosing reallocation behavior or tracing rule application can query PQH_PROCESS_LOG to inspect the records this package produces. Because the package is documented as noship and classified as OTHER, customizations should avoid depending on its interface, as it is subject to change without notice and is not part of Oracle's supported public API surface.