Search Results ibe_util

Overview

IBE_UTIL is a utility package body in the APPS schema that supports the Oracle iStore (IBE) application family within Oracle E-Business Suite 12.1.1 and 12.2.2. Its API classification is UTIL, indicating that it is not a public business API but rather an internal helper library consumed by other iStore and Oracle Applications modules. The package consolidates cross-cutting services that many iStore components require: runtime debug instrumentation, authorization and permission checks against the JTF security model, installation metadata retrieval, NLS-aware number formatting, temporary-table data staging, and phone number presentation formatting.

The package holds a VALID status in the ETRM dictionary and exposes eighteen documented procedures and functions. Dependencies include FND_API, FND_GLOBAL, FND_PROFILE, FND_USER, FND_NUMBER, FND_INSTALLATION, APP_EXCEPTION, ASO_DEBUG_PUB, OE_DEBUG_PUB, UTL_FILE, and the JTF authorization tables. Notably, IBE_UTIL is not referenced by any other database object according to the ETRM record, though its own dependency footprint is broad.

Key Procedures and Functions

The eighteen documented entry points fall into four functional groups.

Debug instrumentation: FILE_DEBUG, ENABLE_FILE_DEBUG, DISABLE_FILE_DEBUG, DEBUG, ENABLE_DEBUG, ENABLE_DEBUG_NEW, ENABLE_DEBUG_PVT, DISABLE_DEBUG, DISABLE_DEBUG_NEW, RESET_DEBUG, and DISABLE_DEBUG_PVT. These govern message logging, allowing developers to route diagnostic output to a file via UTL_FILE or to the standard debug stream, to toggle debug on and off at session or package level, and to reset debug state between operations. The private (PVT) variants support internal enable/disable logic invoked by the public wrappers.
Environment and authorization: GET_INSTALL_INFO retrieves installation-level metadata using FND_INSTALLATION. CHECK_JTF_PERMISSION and CHECK_USER_PERMISSION validate whether the current user holds a required permission or is known to the application, drawing on the JTF authorization tables and FND_USER.
Utility formatting and staging: NLS_NUMBER_FORMAT renders numeric values using the session's NLS conventions. FORMAT_PHONE standardizes telephone number presentation. INSERT_INTO_TEMP_TABLE and DELETE_FROM_TEMP_TABLE manage rows in the IBE_TEMP_TABLE staging area used to hold intermediate result sets.

Tables Accessed

Via APPS synonyms, IBE_UTIL reads FND_USER and HZ_PARTIES for identity context, and the JTF authorization set — JTF_AUTH_DOMAINS_B, JTF_AUTH_PERMISSIONS_B, JTF_AUTH_PRINCIPALS_B, JTF_AUTH_PRINCIPAL_MAPS, and JTF_AUTH_ROLE_PERMS — to resolve roles, permissions, and principal mappings during permission checks. IBE_TEMP_TABLE is written and read for transient data staging. UTL_FILE is used to support file-based debugging output. The documented dependency list additionally names FND_API, FND_GLOBAL, FND_PROFILE, FND_NUMBER, FND_INSTALLATION, APP_EXCEPTION, ASO_DEBUG_PUB, and OE_DEBUG_PUB as referenced package dependencies.

Usage Notes

Because IBE_UTIL is classified as a utility package and is not referenced by other database objects, it is primarily invoked from PL/SQL code paths internal to iStore — forms, concurrent programs, and other iStore packages that need debug toggling, permission validation, or formatting support. Customizations should treat these routines as internal helpers rather than supported public APIs. Debug-enabled calls should be used only during troubleshooting because they add logging overhead and may require file system privileges for UTL_FILE.

PACKAGE BODY: APPS.IBE_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_UTIL, status:VALID,
PACKAGE BODY: APPS.IBE_UTIL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_UTIL, status:VALID,
PACKAGE: APPS.IBE_UTIL 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IBE_UTIL, status:VALID,
SYNONYM: APPS.IBE_TEMP_TABLE 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IBE_TEMP_TABLE, status:VALID,
PACKAGE BODY: APPS.IBE_SHOP_LIST_LINE_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_SHOP_LIST_LINE_PKG, status:VALID,
PACKAGE BODY: APPS.IBE_INSTALLBASE_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_INSTALLBASE_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_COPY_LOGICALCONTENT_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_COPY_LOGICALCONTENT_GRP, status:VALID,
PACKAGE BODY: APPS.IBE_SHOPLIST_LINE_RELATION_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_SHOPLIST_LINE_RELATION_PKG, status:VALID,
PACKAGE BODY: APPS.IBE_QUOTE_W2_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_QUOTE_W2_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_WF_MSG_MAPPING_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_WF_MSG_MAPPING_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_SHOPLIST_LINE_RELATION_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_SHOPLIST_LINE_RELATION_PKG, status:VALID,
PACKAGE BODY: APPS.IBE_SHOP_LIST_HEADER_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_SHOP_LIST_HEADER_PKG, status:VALID,
PACKAGE BODY: APPS.IBE_USER_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_USER_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_MSITE_INFORMATION_MGR_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_MSITE_INFORMATION_MGR_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_CCTBOM_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_CCTBOM_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_SHOP_LIST_HEADER_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_SHOP_LIST_HEADER_PKG, status:VALID,
SYNONYM: APPS.IBE_TEMP_TABLE 12.2.2
owner:APPS, object_type:SYNONYM, object_name:IBE_TEMP_TABLE, status:VALID,
PACKAGE BODY: APPS.IBE_ORDER_W1_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_ORDER_W1_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_CATALOG_PRELOAD_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_CATALOG_PRELOAD_PUB, status:VALID,
PACKAGE BODY: APPS.IBE_CATALOG_PRELOAD_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_CATALOG_PRELOAD_PUB, status:VALID,
PACKAGE: APPS.IBE_UTIL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:IBE_UTIL, status:VALID,
SYNONYM: APPS.JTF_AUTH_ROLE_PERMS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JTF_AUTH_ROLE_PERMS, status:VALID,
PACKAGE BODY: APPS.IBE_M_PRICING_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_M_PRICING_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_USER_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_USER_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_DSP_HIERARCHY_SETUP_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_DSP_HIERARCHY_SETUP_PUB, status:VALID,
PACKAGE BODY: APPS.IBE_JTA_INTEGRATION_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_JTA_INTEGRATION_GRP, status:VALID,
PACKAGE BODY: APPS.IBE_PROD_RELATION_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_PROD_RELATION_GRP, status:VALID,
PACKAGE BODY: APPS.IBE_PROD_RELATION_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_PROD_RELATION_GRP, status:VALID,
PACKAGE BODY: APPS.IBE_ORDER_W1_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_ORDER_W1_PVT, status:VALID,
SYNONYM: APPS.JTF_AUTH_PRINCIPAL_MAPS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JTF_AUTH_PRINCIPAL_MAPS, status:VALID,
PACKAGE BODY: APPS.IBE_M_IBC_INT_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_M_IBC_INT_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_CUSTOMER_ACCT_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_CUSTOMER_ACCT_PVT, status:VALID,
SYNONYM: APPS.JTF_AUTH_PERMISSIONS_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JTF_AUTH_PERMISSIONS_B, status:VALID,
PACKAGE BODY: APPS.IBE_ORDER_UTIL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_ORDER_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_WF_NOTIF_MSG_MAPS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_WF_NOTIF_MSG_MAPS_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_CANCEL_ORDER_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_CANCEL_ORDER_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_ORDER_UTIL_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_ORDER_UTIL_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_MSITE_INFORMATION_MGR_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_MSITE_INFORMATION_MGR_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_CANCEL_ORDER_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_CANCEL_ORDER_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_CCTBOM_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_CCTBOM_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_QUOTE_W1_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_QUOTE_W1_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_JTA_INTEGRATION_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_JTA_INTEGRATION_GRP, status:VALID,
PACKAGE BODY: APPS.IBE_PROD_RELATION_RULE_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_PROD_RELATION_RULE_PVT, status:VALID,
SYNONYM: APPS.JTF_AUTH_DOMAINS_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:JTF_AUTH_DOMAINS_B, status:VALID,
SYNONYM: APPS.JTF_AUTH_DOMAINS_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:JTF_AUTH_DOMAINS_B, status:VALID,
PACKAGE BODY: APPS.IBE_MINISITERUNTIME_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_MINISITERUNTIME_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_CFG_CONFIG_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_CFG_CONFIG_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_INSTALLBASE_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_INSTALLBASE_PVT, status:VALID,
PACKAGE BODY: APPS.IBE_SHOP_LIST_LINE_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_SHOP_LIST_LINE_PKG, status:VALID,
PACKAGE BODY: APPS.IBE_CUSTOMER_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IBE_CUSTOMER_PVT, status:VALID,