APPS.INV_QUANTITY_TREE_PVT dependencies on DBMS_UTILITY

Line 629: l_hash_value := DBMS_UTILITY.get_hash_value

625: BEGIN
626: --Bug 4699159. The query is throwing a no data found exception when
627: --p_subinventory_code is being passed as null.
628: IF(p_subinventory_code IS NOT NULL) THEN
629: l_hash_value := DBMS_UTILITY.get_hash_value
630: ( NAME => p_organization_id ||'-'|| p_subinventory_code
631: , base => 1
632: , hash_size => POWER(2, 25)
633: );

Line 695: l_hash_value := DBMS_UTILITY.get_hash_value

691: BEGIN
692: --Bug 4699159. The query is throwing a no data found exception when
693: --p_subinventory_code is being passed as null.
694: IF(p_inventory_location_id IS NOT NULL) THEN
695: l_hash_value := DBMS_UTILITY.get_hash_value
696: ( NAME => p_organization_id ||'-'|| p_inventory_location_id
697: , base => 1
698: , hash_size => POWER(2, 25)
699: );

Line 762: l_hash_value := DBMS_UTILITY.get_hash_value

758: BEGIN
759: --Bug 4699159. The query is throwing a no data found exception when
760: --p_lot_number is being passed as null.
761: IF(p_lot_number IS NOT NULL) THEN
762: l_hash_value := DBMS_UTILITY.get_hash_value
763: ( NAME => p_organization_id ||'-'|| p_inventory_item_id ||'-'|| p_lot_number
764: , base => 1
765: , hash_size => POWER(2, 25)
766: );

Line 859: l_hash_value := DBMS_UTILITY.get_hash_value

855: end if;
856:
857: print_debug('In check_is_reservable_onhand, hash string built: '||l_hash_string);
858:
859: l_hash_value := DBMS_UTILITY.get_hash_value
860: ( NAME => l_hash_string
861: , base => 1
862: , hash_size => POWER(2, 25)
863: );

Line 1620: l_tree_index := dbms_utility.get_hash_value(

1616: --if not null, we found an empty slot in find_rootinfo and don't need to look for it again
1617: l_tree_index := g_empty_root_index;
1618: g_empty_root_index := NULL;
1619: ELSE
1620: l_tree_index := dbms_utility.get_hash_value(
1621: name => l_hash_string || l_hash_string
1622: , base => l_hash_base
1623: , hash_size => l_hash_size);
1624:

Line 1649: l_org_item_index := dbms_utility.get_hash_value(

1645: g_all_roots(g_all_roots_counter).last_root := g_all_roots_counter;
1646:
1647: --set values for org/item combo
1648: l_hash_string := p_organization_id || ':' || p_inventory_item_id;
1649: l_org_item_index := dbms_utility.get_hash_value(
1650: name => l_hash_string
1651: , base => l_hash_base
1652: , hash_size => l_hash_size);
1653: IF g_org_item_trees.exists(l_org_item_index) THEN

Line 2199: l_tree_index := dbms_utility.get_hash_value(

2195: g_hash_string := l_hash_string;
2196: -- Bug 2092207 - hash procedure returning duplicate indices;
2197: -- doubling length of name to try to decrease probability of
2198: -- getting duplicate values
2199: l_tree_index := dbms_utility.get_hash_value(
2200: name => l_hash_string || l_hash_string
2201: , base => l_hash_base
2202: , hash_size => l_hash_size);
2203:

Line 2332: --get hash value using dbms_utility package

2328: p_lot_number || ':' || p_subinventory_code || ':' ||
2329: p_locator_id || ':' || p_lpn_id || ':' ||
2330: p_cost_group_id;
2331:
2332: --get hash value using dbms_utility package
2333: l_node_index := dbms_utility.get_hash_value(
2334: name => l_hash_string
2335: ,base => l_hash_base
2336: ,hash_size => l_hash_size);

Line 2333: l_node_index := dbms_utility.get_hash_value(

2329: p_locator_id || ':' || p_lpn_id || ':' ||
2330: p_cost_group_id;
2331:
2332: --get hash value using dbms_utility package
2333: l_node_index := dbms_utility.get_hash_value(
2334: name => l_hash_string
2335: ,base => l_hash_base
2336: ,hash_size => l_hash_size);
2337:

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

2334: name => l_hash_string
2335: ,base => l_hash_base
2336: ,hash_size => l_hash_size);
2337:
2338: print_debug('... in find_child_node, after dbms_utility.get_hash_value');
2339:
2340: IF g_nodes.exists(l_node_index) THEN
2341: WHILE g_nodes(l_node_index).hash_string <> l_hash_string LOOP
2342: l_prev_node_index := l_node_index;

Line 4227: l_org_item_index := dbms_utility.get_hash_value(

4223: */
4224:
4225: l_hash_string := g_rootinfos(p_tree_id).organization_id
4226: || ':' || g_rootinfos(p_tree_id).inventory_item_id;
4227: l_org_item_index := dbms_utility.get_hash_value(
4228: name => l_hash_string
4229: ,base => l_hash_base
4230: ,hash_size => l_hash_size);
4231: If g_org_item_trees.exists(l_org_item_index) Then