APPS.WMS_POSTALLOC_PVT dependencies on DBMS_UTILITY

Line 4365: l_hash_value_loctxnuom := DBMS_UTILITY.get_hash_value

4361: IF l_loc_uom_code = l_txn_uom_code THEN
4362: l_loc_txn_uom_ratio := 1;
4363: ELSE --{
4364: l_hash_string_loctxnuom := l_loc_uom_code || '-' || l_txn_uom_code || '-' || l_item_id; --newly added
4365: l_hash_value_loctxnuom := DBMS_UTILITY.get_hash_value
4366: ( name => l_hash_string_loctxnuom
4367: , base => g_hash_base
4368: , hash_size => g_hash_size
4369: );

Line 4403: l_hash_value_tpuom := DBMS_UTILITY.get_hash_value

4399: IF l_txn_uom_code = l_item_prim_uom_code THEN
4400: l_txn_pri_uom_ratio := 1;
4401: ELSE --{
4402: l_hash_string_tpuom := l_txn_uom_code || '-' || l_item_prim_uom_code || '-' || l_item_id; --newly added
4403: l_hash_value_tpuom := DBMS_UTILITY.get_hash_value
4404: ( name => l_hash_string_tpuom
4405: , base => g_hash_base
4406: , hash_size => g_hash_size
4407: );

Line 4441: l_hash_value_tsecuom := DBMS_UTILITY.get_hash_value

4437: IF l_txn_uom_code = l_sec_uom_code THEN
4438: l_txn_sec_uom_ratio := 1;
4439: ELSE --{
4440: l_hash_string_tsecuom := l_txn_uom_code || '-' || l_sec_uom_code || '-' || l_item_id; --newly added
4441: l_hash_value_tsecuom := DBMS_UTILITY.get_hash_value
4442: ( name => l_hash_string_tsecuom
4443: , base => g_hash_base
4444: , hash_size => g_hash_size
4445: );

Line 4484: l_hash_split_fac_value := DBMS_UTILITY.get_hash_value

4480: l_sfactor_flag := 0;
4481: l_hash_split_fac_string := TO_CHAR(l_organization_id) || '-' ||
4482: TO_CHAR(l_item_id) || '-' ||
4483: TO_CHAR(l_std_op_id);
4484: l_hash_split_fac_value := DBMS_UTILITY.get_hash_value
4485: ( name => l_hash_split_fac_string
4486: , base => g_hash_base
4487: , hash_size => g_hash_size
4488: );

Line 4574: l_hash_value_w := DBMS_UTILITY.get_hash_value

4570: IF l_equip_w_uom = l_item_w_uom THEN
4571: l_eq_it_w_uom_ratio := 1;
4572: ELSE --{
4573: l_hash_string_w := l_equip_w_uom || '-' || l_item_w_uom || '-' || '0'; --newly added
4574: l_hash_value_w := DBMS_UTILITY.get_hash_value
4575: ( name => l_hash_string_w
4576: , base => g_hash_base
4577: , hash_size => g_hash_size
4578: );

Line 4606: l_hash_value_v := DBMS_UTILITY.get_hash_value

4602: IF l_equip_v_uom = l_item_v_uom THEN
4603: l_eq_it_v_uom_ratio := 1;
4604: ELSE --{
4605: l_hash_string_v := l_equip_v_uom || '-' || l_item_v_uom || '-' || '0'; --newly added
4606: l_hash_value_v := DBMS_UTILITY.get_hash_value
4607: ( name => l_hash_string_v
4608: , base => g_hash_base
4609: , hash_size => g_hash_size
4610: );

Line 5394: l_hash_value := DBMS_UTILITY.get_hash_value

5390: || TO_CHAR(p_locator_id) || '-'
5391: || TO_CHAR(g_user_id);
5392:
5393: -- Generate hash value with the concatenated string
5394: l_hash_value := DBMS_UTILITY.get_hash_value
5395: ( name => l_hash_string
5396: , base => g_hash_base
5397: , hash_size => g_hash_size
5398: );