APPS.WSMPLBJI dependencies on DBMS_UTILITY

Line 11: -- when calling dbms_utility.get_hash_value use larger seed number

7: -- session, hence each submission of launch worker will have it's
8: -- own set of "global" variables and tables.
9:
10: -- BUG 3934661
11: -- when calling dbms_utility.get_hash_value use larger seed number
12: -- OLD: dbms_utility.get_hash_value(str, 1000, 5625);
13: -- NEW: dbms_utility.get_hash_value(str, 37, 1073741824);
14:
15: v_index NUMBER;

Line 12: -- OLD: dbms_utility.get_hash_value(str, 1000, 5625);

8: -- own set of "global" variables and tables.
9:
10: -- BUG 3934661
11: -- when calling dbms_utility.get_hash_value use larger seed number
12: -- OLD: dbms_utility.get_hash_value(str, 1000, 5625);
13: -- NEW: dbms_utility.get_hash_value(str, 37, 1073741824);
14:
15: v_index NUMBER;
16: v_wsli_index NUMBER;

Line 13: -- NEW: dbms_utility.get_hash_value(str, 37, 1073741824);

9:
10: -- BUG 3934661
11: -- when calling dbms_utility.get_hash_value use larger seed number
12: -- OLD: dbms_utility.get_hash_value(str, 1000, 5625);
13: -- NEW: dbms_utility.get_hash_value(str, 37, 1073741824);
14:
15: v_index NUMBER;
16: v_wsli_index NUMBER;
17:

Line 3784: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);

3780: xst := WSMPLCVA.v_item.exists(v_wlji_item(v_index));
3781: else -- mode flag 2
3782: str := to_char(v_wlji_item(v_index))||
3783: to_char(v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id);
3784: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
3785:
3786: xst := WSMPLCVA.v_mode2_item.exists(hash_value)
3787: AND WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID =
3788: v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id

Line 4068: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);

4064:
4065: -- do the subinventory validation here...
4066: -- validation of subinv begin
4067: str := to_char(v_wlji_org(v_index))||v_wlji_completion_subinventory(v_index);
4068: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
4069: if WSMPLCVA.v_subinv.exists(hash_value) then
4070: NULL;
4071: else
4072: l_aux_mesg := '';

Line 4576: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);

4572: END IF;
4573:
4574: ELSE
4575: str := to_char(v_wlji_org(v_index))||v_wlji_class_code(v_index);
4576: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
4577: if WSMPLCVA.v_class_code.exists(hash_value) then
4578: NULL;
4579: else
4580: raise no_data_found;

Line 5648: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);

5644: IF v_wlji_completion_subinventory(v_index) IS NOT NULL AND
5645: v_wlji_completion_locator_id(v_index) IS NULL THEN
5646:
5647: str := to_char(v_wlji_org(v_index))||v_wlji_completion_subinventory(v_index);
5648: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
5649: if WSMPLCVA.v_subinv.exists(hash_value) then
5650: NULL;
5651: else
5652: l_aux_mesg := '';