DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on DBMS_UTILITY

Line 1786: l_index := DBMS_UTILITY.get_hash_value(to_char(p_ptp_id)||l_tax_regime_code||l_tax||l_jurisdiction_code,1,8192);

1782: l_tax_regime_code := nvl(p_tax_regime_code, c_tax_regime_code_dummy);
1783: l_tax := nvl(p_tax, c_tax_dummy);
1784: l_jurisdiction_code := nvl(p_jurisdiction_code, c_jurisdiction_code_dummy);
1785:
1786: l_index := DBMS_UTILITY.get_hash_value(to_char(p_ptp_id)||l_tax_regime_code||l_tax||l_jurisdiction_code,1,8192);
1787:
1788: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1789: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'l_index = '||l_index);
1790: END IF;

Line 1911: l_index := DBMS_UTILITY.get_hash_value(to_char(p_ptp_id)||

1907: ELSE
1908: p_getone:=1;
1909: x_return_status := FND_API.G_RET_STS_SUCCESS;
1910:
1911: l_index := DBMS_UTILITY.get_hash_value(to_char(p_ptp_id)||
1912: nvl(x_get_registration_rec.tax_regime_code,c_tax_regime_code_dummy)||
1913: nvl(x_get_registration_rec.tax,c_tax_dummy)||
1914: nvl(x_get_registration_rec.tax_jurisdiction_code,c_jurisdiction_code_dummy),1,8192);
1915: