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 3790: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);

3786: xst := WSMPLCVA.v_item.exists(v_wlji_item(v_index));
3787: else -- mode flag 2
3788: str := to_char(v_wlji_item(v_index))||
3789: to_char(v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id);
3790: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
3791:
3792: xst := WSMPLCVA.v_mode2_item.exists(hash_value)
3793: AND WSMPLCVA.v_mode2_item(hash_value).INVENTORY_ITEM_ID =
3794: v_wsli(v_wlji_source_line_id(v_index)).inventory_item_id

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

4070:
4071: -- do the subinventory validation here...
4072: -- validation of subinv begin
4073: str := to_char(v_wlji_org(v_index))||v_wlji_completion_subinventory(v_index);
4074: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
4075: if WSMPLCVA.v_subinv.exists(hash_value) then
4076: NULL;
4077: else
4078: l_aux_mesg := '';

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

4578: END IF;
4579:
4580: ELSE
4581: str := to_char(v_wlji_org(v_index))||v_wlji_class_code(v_index);
4582: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
4583: if WSMPLCVA.v_class_code.exists(hash_value) then
4584: NULL;
4585: else
4586: raise no_data_found;

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

5650: IF v_wlji_completion_subinventory(v_index) IS NOT NULL AND
5651: v_wlji_completion_locator_id(v_index) IS NULL THEN
5652:
5653: str := to_char(v_wlji_org(v_index))||v_wlji_completion_subinventory(v_index);
5654: hash_value := dbms_utility.get_hash_value(str, 37, 1073741824);
5655: if WSMPLCVA.v_subinv.exists(hash_value) then
5656: NULL;
5657: else
5658: l_aux_mesg := '';