APPS.ZX_GLOBAL_STRUCTURES_PKG dependencies on DBMS_UTILITY

Line 99: l_tbl_index := dbms_utility.get_hash_value(to_char(p_application_id)||to_char(p_org_id), 1, 8192);

95: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
96: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'get_product_options_info'||'.BEGIN','ZX_GLOBAL_STRUCTURES_PKG: get_product_options_info()+ ');
97: END IF;
98:
99: l_tbl_index := dbms_utility.get_hash_value(to_char(p_application_id)||to_char(p_org_id), 1, 8192);
100: IF g_zx_proudct_options_tbl.exists(l_tbl_index) then
101: x_product_options_rec := g_zx_proudct_options_tbl(l_tbl_index);
102:
103: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 193: l_tbl_index := dbms_utility.get_hash_value(

189: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'get_product_options_info'||'.BEGIN','ZX_GLOBAL_STRUCTURES_PKG: get_product_options_info()+ ');
190: END IF;
191:
192: IF p_event_class_mapping_id IS NOT NULL THEN
193: l_tbl_index := dbms_utility.get_hash_value(
194: TO_CHAR(p_application_id) || TO_CHAR(p_org_id) || '-' ||
195: TO_CHAR(p_event_class_mapping_id),
196: 1, 8192);
197: ELSE

Line 198: l_tbl_index := dbms_utility.get_hash_value(

194: TO_CHAR(p_application_id) || TO_CHAR(p_org_id) || '-' ||
195: TO_CHAR(p_event_class_mapping_id),
196: 1, 8192);
197: ELSE
198: l_tbl_index := dbms_utility.get_hash_value(
199: TO_CHAR(p_application_id) || TO_CHAR(p_org_id),
200: 1, 8192);
201: END IF;
202:

Line 267: l_tbl_index := dbms_utility.get_hash_value(p_tax_regime_code||to_char(p_first_pty_org_id), 1, 8192);

263: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'get_regimes_usages_info'||'.BEGIN','ZX_GLOBAL_STRUCTURES_PKG: get_regimes_usages_info()+ ');
264: --END IF;
265:
266: x_return_status := FND_API.G_RET_STS_SUCCESS;
267: l_tbl_index := dbms_utility.get_hash_value(p_tax_regime_code||to_char(p_first_pty_org_id), 1, 8192);
268:
269: IF G_REGIMES_USAGES_TBL.exists(l_tbl_index) then
270: x_regime_usage_id := G_REGIMES_USAGES_TBL(l_tbl_index).regime_usage_id;
271: ELSE