DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on DBMS_UTILITY

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

1743: l_tax_regime_code := nvl(p_tax_regime_code, c_tax_regime_code_dummy);
1744: l_tax := nvl(p_tax, c_tax_dummy);
1745: l_jurisdiction_code := nvl(p_jurisdiction_code, c_jurisdiction_code_dummy);
1746:
1747: l_index := DBMS_UTILITY.get_hash_value(to_char(p_ptp_id)||l_tax_regime_code||l_tax||l_jurisdiction_code,1,8192);
1748:
1749: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1750: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, 'l_index = '||l_index);
1751: END IF;

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

1867: ELSE
1868: p_getone:=1;
1869: x_return_status := FND_API.G_RET_STS_SUCCESS;
1870:
1871: l_index := DBMS_UTILITY.get_hash_value(to_char(p_ptp_id)||
1872: nvl(x_get_registration_rec.tax_regime_code,c_tax_regime_code_dummy)||
1873: nvl(x_get_registration_rec.tax,c_tax_dummy)||
1874: nvl(x_get_registration_rec.tax_jurisdiction_code,c_jurisdiction_code_dummy),1,8192);
1875: