eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_BUCKET_PVT dependencies on DBMS_UTILITY

Line 1856: l_hash_value :=Dbms_Utility.Get_Hash_Value (

1852:
1853: BEGIN
1854:
1855: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_name)= FND_API.G_TRUE) THEN
1856: l_hash_value :=Dbms_Utility.Get_Hash_Value (
1857: name => p_bis_bucket_rec.range1_name
1858: ,base => 2
1859: ,hash_size => 1048576
1860: );

Line 1866: l_hash_value:=Dbms_Utility.Get_Hash_Value (

1862: l_range_name(l_hash_value) := p_bis_bucket_rec.range1_name;
1863: END IF;
1864:
1865: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_name)= FND_API.G_TRUE) THEN
1866: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1867: name => p_bis_bucket_rec.range2_name
1868: ,base => 2
1869: ,hash_size => 1048576
1870: );

Line 1880: l_hash_value:=Dbms_Utility.Get_Hash_Value (

1876: END IF;
1877: END IF;
1878:
1879: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_name)= FND_API.G_TRUE) THEN
1880: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1881: name => p_bis_bucket_rec.range3_name
1882: ,base => 2
1883: ,hash_size => 1048576
1884: );

Line 1895: l_hash_value:=Dbms_Utility.Get_Hash_Value (

1891: END IF;
1892:
1893:
1894: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_name)= FND_API.G_TRUE) THEN
1895: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1896: name => p_bis_bucket_rec.range4_name
1897: ,base => 2
1898: ,hash_size => 1048576
1899: );

Line 1910: l_hash_value:=Dbms_Utility.Get_Hash_Value (

1906: END IF;
1907:
1908:
1909: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_name)= FND_API.G_TRUE) THEN
1910: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1911: name => p_bis_bucket_rec.range5_name
1912: ,base => 2
1913: ,hash_size => 1048576
1914: );

Line 1925: l_hash_value:=Dbms_Utility.Get_Hash_Value (

1921: END IF;
1922:
1923:
1924: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_name)= FND_API.G_TRUE) THEN
1925: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1926: name => p_bis_bucket_rec.range6_name
1927: ,base => 2
1928: ,hash_size => 1048576
1929: );

Line 1940: l_hash_value:=Dbms_Utility.Get_Hash_Value (

1936: END IF;
1937:
1938:
1939: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_name)= FND_API.G_TRUE) THEN
1940: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1941: name => p_bis_bucket_rec.range7_name
1942: ,base => 2
1943: ,hash_size => 1048576
1944: );

Line 1955: l_hash_value:=Dbms_Utility.Get_Hash_Value (

1951: END IF;
1952:
1953:
1954: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_name)= FND_API.G_TRUE) THEN
1955: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1956: name => p_bis_bucket_rec.range8_name
1957: ,base => 2
1958: ,hash_size => 1048576
1959: );

Line 1970: l_hash_value:=Dbms_Utility.Get_Hash_Value (

1966: END IF;
1967:
1968:
1969: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_name)= FND_API.G_TRUE) THEN
1970: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1971: name => p_bis_bucket_rec.range9_name
1972: ,base => 2
1973: ,hash_size => 1048576
1974: );

Line 1985: l_hash_value:=Dbms_Utility.Get_Hash_Value (

1981: END IF;
1982:
1983:
1984: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_name)= FND_API.G_TRUE) THEN
1985: l_hash_value:=Dbms_Utility.Get_Hash_Value (
1986: name => p_bis_bucket_rec.range10_name
1987: ,base => 2
1988: ,hash_size => 1048576
1989: );

Line 2026: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2022: RETURN TRUE;
2023: END IF;
2024:
2025: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_low)= FND_API.G_TRUE) THEN
2026: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2027: name => p_bis_bucket_rec.range1_low
2028: ,base => 2
2029: ,hash_size => 1048576
2030: );

Line 2040: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2036: END IF;
2037: END IF;
2038:
2039: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_low)= FND_API.G_TRUE) THEN
2040: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2041: name => p_bis_bucket_rec.range2_low
2042: ,base => 2
2043: ,hash_size => 1048576
2044: );

Line 2054: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2050: END IF;
2051: END IF;
2052:
2053: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_low)= FND_API.G_TRUE) THEN
2054: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2055: name => p_bis_bucket_rec.range3_low
2056: ,base => 2
2057: ,hash_size => 1048576
2058: );

Line 2068: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2064: END IF;
2065: END IF;
2066:
2067: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_low)= FND_API.G_TRUE) THEN
2068: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2069: name => p_bis_bucket_rec.range4_low
2070: ,base => 2
2071: ,hash_size => 1048576
2072: );

Line 2082: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2078: END IF;
2079: END IF;
2080:
2081: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_low)= FND_API.G_TRUE) THEN
2082: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2083: name => p_bis_bucket_rec.range5_low
2084: ,base => 2
2085: ,hash_size => 1048576
2086: );

Line 2096: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2092: END IF;
2093: END IF;
2094:
2095: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_low)= FND_API.G_TRUE) THEN
2096: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2097: name => p_bis_bucket_rec.range6_low
2098: ,base => 2
2099: ,hash_size => 1048576
2100: );

Line 2110: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2106: END IF;
2107: END IF;
2108:
2109: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_low)= FND_API.G_TRUE) THEN
2110: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2111: name => p_bis_bucket_rec.range7_low
2112: ,base => 2
2113: ,hash_size => 1048576
2114: );

Line 2124: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2120: END IF;
2121: END IF;
2122:
2123: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_low)= FND_API.G_TRUE) THEN
2124: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2125: name => p_bis_bucket_rec.range8_low
2126: ,base => 2
2127: ,hash_size => 1048576
2128: );

Line 2138: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2134: END IF;
2135: END IF;
2136:
2137: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_low)= FND_API.G_TRUE) THEN
2138: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2139: name => p_bis_bucket_rec.range9_low
2140: ,base => 2
2141: ,hash_size => 1048576
2142: );

Line 2152: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2148: END IF;
2149: END IF;
2150:
2151: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_low)= FND_API.G_TRUE) THEN
2152: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2153: name => p_bis_bucket_rec.range10_low
2154: ,base => 2
2155: ,hash_size => 1048576
2156: );

Line 2190: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2186: IF((p_bis_bucket_rec.overlapping ='T') OR (p_bis_bucket_rec.discontinuous='T')) THEN
2187: RETURN TRUE;
2188: END IF;
2189: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range1_high)= FND_API.G_TRUE) THEN
2190: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2191: name => p_bis_bucket_rec.range1_high
2192: ,base => 2
2193: ,hash_size => 1048576
2194: );

Line 2204: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2200: END IF;
2201: END IF;
2202:
2203: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range2_high)= FND_API.G_TRUE) THEN
2204: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2205: name => p_bis_bucket_rec.range2_high
2206: ,base => 2
2207: ,hash_size => 1048576
2208: );

Line 2218: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2214: END IF;
2215: END IF;
2216:
2217: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range3_high)= FND_API.G_TRUE) THEN
2218: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2219: name => p_bis_bucket_rec.range3_high
2220: ,base => 2
2221: ,hash_size => 1048576
2222: );

Line 2232: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2228: END IF;
2229: END IF;
2230:
2231: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range4_high)= FND_API.G_TRUE) THEN
2232: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2233: name => p_bis_bucket_rec.range4_high
2234: ,base => 2
2235: ,hash_size => 1048576
2236: );

Line 2246: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2242: END IF;
2243: END IF;
2244:
2245: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range5_high)= FND_API.G_TRUE) THEN
2246: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2247: name => p_bis_bucket_rec.range5_high
2248: ,base => 2
2249: ,hash_size => 1048576
2250: );

Line 2260: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2256: END IF;
2257: END IF;
2258:
2259: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range6_high)= FND_API.G_TRUE) THEN
2260: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2261: name => p_bis_bucket_rec.range6_high
2262: ,base => 2
2263: ,hash_size => 1048576
2264: );

Line 2274: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2270: END IF;
2271: END IF;
2272:
2273: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range7_high)= FND_API.G_TRUE) THEN
2274: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2275: name => p_bis_bucket_rec.range7_high
2276: ,base => 2
2277: ,hash_size => 1048576
2278: );

Line 2288: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2284: END IF;
2285: END IF;
2286:
2287: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range8_high)= FND_API.G_TRUE) THEN
2288: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2289: name => p_bis_bucket_rec.range8_high
2290: ,base => 2
2291: ,hash_size => 1048576
2292: );

Line 2302: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2298: END IF;
2299: END IF;
2300:
2301: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range9_high)= FND_API.G_TRUE) THEN
2302: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2303: name => p_bis_bucket_rec.range9_high
2304: ,base => 2
2305: ,hash_size => 1048576
2306: );

Line 2316: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (

2312: END IF;
2313: END IF;
2314:
2315: IF (BIS_UTILITIES_PUB.Value_Not_Missing(p_bis_bucket_rec.range10_high)= FND_API.G_TRUE) THEN
2316: l_hash_value :=DBMS_UTILITY.GET_HASH_VALUE (
2317: name => p_bis_bucket_rec.range10_high
2318: ,base => 2
2319: ,hash_size => 1048576
2320: );