APPS.INV_QUANTITY_TREE_PVT dependencies on DBMS_UTILITY

Line 1897: l_tree_index := dbms_utility.get_hash_value(

1893: --if not null, we found an empty slot in find_rootinfo and don't need to look for it again
1894: l_tree_index := g_empty_root_index;
1895: g_empty_root_index := NULL;
1896: ELSE
1897: l_tree_index := dbms_utility.get_hash_value(
1898: name => l_hash_string || l_hash_string
1899: , base => l_hash_base
1900: , hash_size => l_hash_size);
1901:

Line 1926: l_org_item_index := dbms_utility.get_hash_value(

1922: g_all_roots(g_all_roots_counter).last_root := g_all_roots_counter;
1923:
1924: --set values for org/item combo
1925: l_hash_string := p_organization_id || ':' || p_inventory_item_id;
1926: l_org_item_index := dbms_utility.get_hash_value(
1927: name => l_hash_string
1928: , base => l_hash_base
1929: , hash_size => l_hash_size);
1930: IF g_org_item_trees.exists(l_org_item_index) THEN

Line 2368: l_hash_value := DBMS_UTILITY.get_hash_value

2364: BEGIN
2365: --Bug 4699159. The query is throwing a no data found exception when
2366: --p_subinventory_code is being passed as null.
2367: IF(p_subinventory_code IS NOT NULL) THEN
2368: l_hash_value := DBMS_UTILITY.get_hash_value
2369: ( NAME => p_organization_id ||'-'|| p_subinventory_code
2370: , base => 1
2371: , hash_size => POWER(2, 25)
2372: );

Line 2949: l_tree_index := dbms_utility.get_hash_value(

2945: g_hash_string := l_hash_string;
2946: -- Bug 2092207 - hash procedure returning duplicate indices;
2947: -- doubling length of name to try to decrease probability of
2948: -- getting duplicate values
2949: l_tree_index := dbms_utility.get_hash_value(
2950: name => l_hash_string || l_hash_string
2951: , base => l_hash_base
2952: , hash_size => l_hash_size);
2953:

Line 3158: --get hash value using dbms_utility package

3154: p_lot_number || ':' || p_subinventory_code || ':' ||
3155: p_locator_id || ':' || p_lpn_id || ':' ||
3156: p_cost_group_id;
3157:
3158: --get hash value using dbms_utility package
3159: l_node_index := dbms_utility.get_hash_value(
3160: name => l_hash_string
3161: ,base => l_hash_base
3162: ,hash_size => l_hash_size);

Line 3159: l_node_index := dbms_utility.get_hash_value(

3155: p_locator_id || ':' || p_lpn_id || ':' ||
3156: p_cost_group_id;
3157:
3158: --get hash value using dbms_utility package
3159: l_node_index := dbms_utility.get_hash_value(
3160: name => l_hash_string
3161: ,base => l_hash_base
3162: ,hash_size => l_hash_size);
3163:

Line 3164: print_debug('... in find_child_node, after dbms_utility.get_hash_value');

3160: name => l_hash_string
3161: ,base => l_hash_base
3162: ,hash_size => l_hash_size);
3163:
3164: print_debug('... in find_child_node, after dbms_utility.get_hash_value');
3165:
3166: IF g_nodes.exists(l_node_index) THEN
3167: WHILE g_nodes(l_node_index).hash_string <> l_hash_string LOOP
3168: l_prev_node_index := l_node_index;

Line 5047: l_org_item_index := dbms_utility.get_hash_value(

5043: */
5044:
5045: l_hash_string := g_rootinfos(p_tree_id).organization_id
5046: || ':' || g_rootinfos(p_tree_id).inventory_item_id;
5047: l_org_item_index := dbms_utility.get_hash_value(
5048: name => l_hash_string
5049: ,base => l_hash_base
5050: ,hash_size => l_hash_size);
5051: If g_org_item_trees.exists(l_org_item_index) Then