Search Results debug_dump_like

Overview

APPS.PAY_CA_BALANCE_VIEW_PKG is a Canadian (CA) localization package within the Oracle Payroll module of Oracle E-Business Suite. Its purpose is to provide the presentation and session-management layer that drives balance inquiry and balance viewing functionality for Canadian payroll balances. The package body is documented as a VALID object owned by the APPS schema in both EBS 12.1.1 and 12.2.2, and carries an API classification of OTHER, indicating it is an internal utility rather than a published public API.

The package sits above the core payroll balance engine — notably PAY_BALANCE_PKG — and abstracts the retrieval and contextual display of defined balances for Canadian legislative requirements (such as CPP, EI, and provincial tax balances), where balance screens must be filtered by balance dimension, context, time period, and reporting organization. A significant portion of the package is devoted to a self-contained debug framework, reflecting its role as a diagnostic and support-facing component invoked from Oracle Forms based balance inquiry screens.

Key Procedures and Functions

The 44 documented program units fall into three functional clusters.

• Session variable management: GET_SESSION_VAR, SET_SESSION_VAR, and CLEAR_SESSION_VARS maintain in-session state across Forms calls, allowing balance-view parameters and user selections to persist between interactions.
• View mode control: GET_VIEW_MODE and SET_VIEW_MODE determine which balance view or presentation layout is currently active, controlling whether the user sees summary or detail balance information.
• Debugging utilities: DEBUG_INIT, DEBUG_WRAP, DEBUG_SET_MAX, DEBUG_ON, DEBUG_OFF, DEBUG_RESET, DEBUG_DUMP, DEBUG_DUMP_TO_TRACE, DEBUG_DUMP_ERR, DEBUG_DUMP_LIKE, DEBUG_GET_LINE, DEBUG_GET_COUNT, DEBUG_MSG, DEBUG_ERR, and DEBUG_TOGGLE form a comprehensive internal logging subsystem used to trace balance-view execution and capture errors during support and troubleshooting.

No parameter signatures are asserted here; the metadata documents procedure names and purpose only.

Tables Accessed

The package reads from a well-defined set of payroll and HR tables accessed through APPS synonyms:

• Balance definition and context: PAY_BALANCE_TYPES, PAY_DEFINED_BALANCES, PAY_BALANCE_DIMENSIONS, PAY_BALANCE_CONTEXT_VALUES, and FF_CONTEXTS resolve which balances appear, which dimensions apply, and which context values constrain them.
• Assignment and action data: PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_LATEST_BALANCES, and PAY_PAYROLL_ACTIONS provide the assignment-level and run-level population of balances, including the pre-computed latest-balance snapshot.
• Time and organization: PER_TIME_PERIODS supplies the payroll period calendar, while HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION resolve organization and legislative context for filtering by reporting unit.
• Utility: DUAL and PLITBLM are used for expression evaluation and PL/SQL table operations.

Usage Notes

PAY_CA_BALANCE_VIEW_PKG is an internal, non-referenced dependency: it is invoked by 18 other packages but is not itself referenced by any database object, confirming it as a leaf-level consumer rather than a shared library. It is typically called from the Canadian payroll balance inquiry Forms, and indirectly through PAY_BALANCE_PKG and HR_UTILITY which appear in its dependency chain. When troubleshooting, the DEBUG_* routines can be enabled to trace balance-view execution to the trace file. Custom code should avoid direct calls, preferring supported APIs such as PAY_BALANCE_PKG, since this package has no documented public API contract.