Search Results delete_from_temp_table

Overview

IBE_UTIL is a shared PL/SQL utility package owned by the APPS schema and classified under the ETRM as a UTIL API. It belongs to the Oracle iStore (IBE) product family and provides cross-cutting infrastructure services consumed by the broader E-Business Suite codebase. Its principal documented role is the generation of standard debug information for PL/SQL APIs, allowing developers and support engineers to trace execution by directing diagnostic messages either to the screen or to an operating system file. In addition to its debugging framework, the package exposes helper routines for installation checks, authorization checks, National Language Support (NLS) number formatting, temporary-table data handling, and telephone number formatting. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the invoking user rather than the definer, and it is referenced by 51 other packages, confirming its position as foundational shared infrastructure rather than an end-user business API.

Key Procedures and Functions

The package exposes 18 documented procedures and functions. The debugging family is the most prominent:

• DEBUG — emits a text message when the session is in debug mode; called from within PL/SQL APIs to record trace information.
• ENABLE_DEBUG / ENABLE_DEBUG_NEW / ENABLE_DEBUG_PVT — turn on runtime debugging, with the _NEW variants intended for callers that want the current debugging behavior without disturbing the oracle-level _PVT internals.
• DISABLE_DEBUG / DISABLE_DEBUG_NEW / DISABLE_DEBUG_PVT — turn runtime debugging off again.
• RESET_DEBUG — resets debugging state.
• FILE_DEBUG — writes text messages into a file when file-debug mode is active.
• ENABLE_FILE_DEBUG — enables writing debug messages to a file; requires a file path (directory), which must be defined in the INIT.ORA parameter UTIL_FILE_DIR, plus a file name.
• DISABLE_FILE_DEBUG — stops writing into the file.
• GET_INSTALL_INFO — calls FND_INSTALLATION.GET to determine installation status.
• CHECK_JTF_PERMISSION — validates JTF-based authorization permission for a caller.
• CHECK_USER_PERMISSION — validates whether a user holds a required permission.
• NLS_NUMBER_FORMAT — formats numeric values according to NLS conventions.
• INSERT_INTO_TEMP_TABLE / DELETE_FROM_TEMP_TABLE — populate and clear the shared temporary table used by iStore processing.
• FORMAT_PHONE — formats telephone numbers into a consistent display form.

Tables Accessed

The package references the following objects through APPS synonyms: FND_USER (user identity lookup), HZ_PARTIES (trading partner and party records), IBE_TEMP_TABLE (the temporary staging table manipulated by INSERT_INTO_TEMP_TABLE and DELETE_FROM_TEMP_TABLE), the JTF authorization tables JTF_AUTH_DOMAINS_B, JTF_AUTH_PERMISSIONS_B, JTF_AUTH_PRINCIPALS_B, JTF_AUTH_PRINCIPAL_MAPS, and JTF_AUTH_ROLE_PERMS (used by CHECK_JTF_PERMISSION and CHECK_USER_PERMISSION), and UTL_FILE (the Oracle-supplied file I/O package that FILE_DEBUG and the file-debug enable/disable routines rely on).

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, IBE_UTIL is typically invoked from custom PL/SQL, iStore PL/SQL APIs, and Java callers that build anonymous PL/SQL blocks. For Java callers the documented pattern is to append the enable-debug string before the target API call and the disable-debug string afterward. For PL/SQL callers, enable_debug_new is called before and disable_debug_new after the API under investigation, while IBE_UTIL.debug is called inside the API to emit messages without additional enable/disable calls. File-based debugging requires that the UTIL_FILE_DIR initialization parameter be configured. The INSERT_INTO_TEMP_TABLE and DELETE_FROM_TEMP_TABLE routines are used to stage and clear transient data consumed by iStore flows. Because the package is a UTIL-class API rather than a business-document API, it should not be invoked as part of normal transactional processing; it is intended for diagnostics, authorization checks, NLS formatting, and internal iStore support operations.