DBA Data[Home] [Help]

APPS.ZX_GLOBAL_STRUCTURES_PKG dependencies on DBMS_UTILITY

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

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

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

159: -- FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||'get_regimes_usages_info'||'.BEGIN','ZX_GLOBAL_STRUCTURES_PKG: get_regimes_usages_info()+ ');
160: --END IF;
161:
162: x_return_status := FND_API.G_RET_STS_SUCCESS;
163: l_tbl_index := dbms_utility.get_hash_value(p_tax_regime_code||to_char(p_first_pty_org_id), 1, 8192);
164:
165: IF G_REGIMES_USAGES_TBL.exists(l_tbl_index) then
166: x_regime_usage_id := G_REGIMES_USAGES_TBL(l_tbl_index).regime_usage_id;
167: ELSE