eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_FTE_CONSTRAINT_FRAMEWORK dependencies on DBMS_UTILITY

Line 619: l_hash_value := dbms_utility.get_hash_value(

615: IF l_debug_on THEN
616: wsh_debug_sv.push (l_module_name);
617: END IF;
618: --
619: l_hash_value := dbms_utility.get_hash_value(
620: name => p_comp_class_code,
621: base => g_hash_base,
622: hash_size =>g_hash_size );
623:

Line 1947: l_hash_value := dbms_utility.get_hash_value(

1943: l_hash_string := (l_comp_class_id)||'-'||l_constraint_rec.constraint_object1_type||'-'||nvl( to_char(l_constraint_rec.constraint_object1_id),
1944: l_constraint_rec.constraint_object1_value_char)||'-'|| (nvl(l_constraint_rec.object1_source_id,-9999))||
1945: '-'||l_constraint_rec.constraint_object2_type||'-'||nvl(to_char(l_constraint_rec.constraint_object2_id),l_constraint_rec.constraint_object2_value_char)||'-'|| (nvl(l_constraint_rec.object2_source_id,-9999));
1946:
1947: l_hash_value := dbms_utility.get_hash_value(
1948: name => l_hash_string,
1949: base => g_hash_base,
1950: hash_size => g_hash_size );
1951: --

Line 2080: l_hash_value := dbms_utility.get_hash_value(

2076: WSH_DEBUG_SV.logmsg(l_module_name,'Called populate_constraint_cache return status : '||l_return_status);
2077: END IF;
2078: --
2079:
2080: l_hash_value := dbms_utility.get_hash_value(
2081: name => p_hash_string,
2082: base => g_hash_base,
2083: hash_size => g_hash_size );
2084:

Line 2379: l_region_hash_val := dbms_utility.get_hash_value(

2375: l_region_hash_str := p_location_id ||'-'
2376: || p_object2_id ||'-'
2377: || p_constraint_type;
2378:
2379: l_region_hash_val := dbms_utility.get_hash_value(
2380: name => l_region_hash_str,
2381: base => l_reg_hash_base,
2382: hash_size =>l_reg_hash_size );
2383:

Line 2491: l_region_hash_val := dbms_utility.get_hash_value(

2487: l_region_hash_str := p_location_id ||'-'
2488: || p_object2_id ||'-'
2489: || p_constraint_type;
2490:
2491: l_region_hash_val := dbms_utility.get_hash_value(
2492: name => l_region_hash_str,
2493: base => l_reg_hash_base,
2494: hash_size =>l_reg_hash_size );
2495:

Line 2661: l_hash_value := dbms_utility.get_hash_value(

2657:
2658: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2659: x_validate_result := 'S';
2660:
2661: l_hash_value := dbms_utility.get_hash_value(
2662: name => l_comp_class_code,
2663: base => g_hash_base,
2664: hash_size =>g_hash_size );
2665:

Line 2775: l_reg_hash_value := dbms_utility.get_hash_value(

2771: ||'FAC'||'-'
2772: || to_char(l_object2_id)||'-'
2773: ||(-9999);
2774:
2775: l_reg_hash_value := dbms_utility.get_hash_value(
2776: name => l_reg_hash_string,
2777: base => g_hash_base,
2778: hash_size =>g_hash_size);
2779:

Line 2843: l_zone_hash_value := dbms_utility.get_hash_value(

2839: ||'FAC'||'-'
2840: ||to_char(l_object2_id)||'-'
2841: ||(-9999);
2842:
2843: l_zone_hash_value := dbms_utility.get_hash_value(
2844: name => l_zone_hash_string,
2845: base => g_hash_base,
2846: hash_size =>g_hash_size);
2847:

Line 2878: c_zone_hash_value := dbms_utility.get_hash_value(

2874: ||'FAC'||'-'
2875: ||to_char(l_object2_id)||'-'
2876: ||(-9999);
2877:
2878: c_zone_hash_value := dbms_utility.get_hash_value(
2879: name => c_zone_hash_string,
2880: base => g_hash_base,
2881: hash_size =>g_hash_size);
2882:

Line 3128: l_hash_value := dbms_utility.get_hash_value(

3124: --
3125: -- Populate REG-FAC cache.
3126: --
3127:
3128: l_hash_value := dbms_utility.get_hash_value(
3129: name => l_comp_class_code,
3130: base => g_hash_base,
3131: hash_size =>g_hash_size);
3132:

Line 3201: l_reg_hash_value := dbms_utility.get_hash_value(

3197: END IF;
3198: --
3199: l_reg_hash_string:=l_reg_hash_str_const||(p_location_list(itr))||'-'||(-9999);
3200:
3201: l_reg_hash_value := dbms_utility.get_hash_value(
3202: name => l_reg_hash_string,
3203: base => g_hash_base,
3204: hash_size =>g_hash_size );
3205: --

Line 3343: l_zone_hash_value := dbms_utility.get_hash_value(

3339: END IF;
3340: --
3341: l_zone_hash_string:=l_zone_hash_str_const ||(p_location_list(itr))||'-'||(-9999);
3342:
3343: l_zone_hash_value := dbms_utility.get_hash_value(
3344: name => l_zone_hash_string,
3345: base => g_hash_base,
3346: hash_size =>g_hash_size );
3347: --

Line 3422: l_zone_hash_excl_value := dbms_utility.get_hash_value(

3418: ||'FAC'||'-'
3419: ||to_char(l_fac_id)||'-'
3420: ||(-9999);
3421:
3422: l_zone_hash_excl_value := dbms_utility.get_hash_value(
3423: name => l_zone_hash_excl_string,
3424: base => g_hash_base,
3425: hash_size =>g_hash_size );
3426:

Line 3785: l_itm_hash_value := dbms_utility.get_hash_value(

3781: IF l_object1_typesub = 'ITM' AND p_constraint_type = 'E' THEN
3782:
3783: l_itm_hash_string :=p_comp_class_code||'-'||nvl(l_object1_parent_id,-9999)||'-'||p_object1_val_num||'-'||nvl(to_char(p_object2_val_num),p_object2_val_char);
3784:
3785: l_itm_hash_value := dbms_utility.get_hash_value(
3786: name => l_itm_hash_string,
3787: base => g_hash_base,
3788: hash_size =>g_hash_size );
3789:

Line 3822: l_fac_hash_value := dbms_utility.get_hash_value(

3818: IF l_comp_type1 = 'FAC' AND p_constraint_type = 'E' THEN
3819:
3820: l_fac_hash_string := p_comp_class_code||'-'||l_object1_typesub||'-'||p_object1_val_num||'-'||nvl(to_char(p_object2_val_num),p_object2_val_char);
3821:
3822: l_fac_hash_value := dbms_utility.get_hash_value(
3823: name => l_fac_hash_string,
3824: base => g_hash_base,
3825: hash_size =>g_hash_size );
3826: --

Line 3853: l_hash_value := dbms_utility.get_hash_value(

3849:
3850: -- Alternatively the package can store internal numeric
3851: -- values for each of the compatibility classes and use that to index the table
3852: -- which will help avoiding hash creation
3853: l_hash_value := dbms_utility.get_hash_value(
3854: name => p_comp_class_code,
3855: base => g_hash_base,
3856: hash_size =>g_hash_size );
3857:

Line 3934: l1_hash_value := dbms_utility.get_hash_value(

3930: l1_hash_string := (l_comp_class_id)||'-'||l_object1_typesub||'-'||nvl( to_char(p_object1_val_num),p_object1_val_char)||'-'|| (nvl(l_object1_parent_id,-9999))||
3931: '-'||l_object2_typesub||'-'||nvl( to_char(p_object2_val_num),p_object2_val_char)||'-'|| (nvl(p_object2_parent_id,-9999));
3932:
3933:
3934: l1_hash_value := dbms_utility.get_hash_value(
3935: name => l1_hash_string,
3936: base => g_hash_base,
3937: hash_size =>g_hash_size );
3938:

Line 3951: l11_hash_value := dbms_utility.get_hash_value(

3947:
3948: l11_hash_string := (l_comp_class_id)||'-'||l_object1_typesub||'-'||to_char(p_object2_val_num)||'-'||(nvl(p_object2_parent_id,-9999))||
3949: '-'||l_object2_typesub||'-'||to_char(p_object1_val_num)||'-'||(nvl(l_object1_parent_id,-9999));
3950:
3951: l11_hash_value := dbms_utility.get_hash_value(
3952: name => l11_hash_string,
3953: base => g_hash_base,
3954: hash_size =>g_hash_size );
3955:

Line 3984: l11_hash_value := dbms_utility.get_hash_value(

3980:
3981: l11_hash_string := (l_comp_class_id)||'-'||l_object1_typesub||'-'||to_char(l_master_org_id)||'-'||(nvl(l_object1_parent_id,-9999))||
3982: '-'||l_object2_typesub||'-'||to_char(p_object2_val_num)||'-'||(nvl(p_object2_parent_id,-9999));
3983:
3984: l11_hash_value := dbms_utility.get_hash_value(
3985: name => l11_hash_string,
3986: base => g_hash_base,
3987: hash_size =>g_hash_size );
3988:

Line 4117: l2_hash_value := dbms_utility.get_hash_value(

4113:
4114: l2_hash_string := (l_comp_class_id)||'-'||l_object1_type||'-'|| (l_object1_id)||'-'|| (nvl(l_object1_parent_id,-9999))||
4115: '-'||l_object2_type||'-'||nvl( to_char(l_object2_id),l_object2_val_char)||'-'|| (-9999);
4116:
4117: l2_hash_value := dbms_utility.get_hash_value(
4118: name => l2_hash_string,
4119: base => g_hash_base,
4120: hash_size =>g_hash_size );
4121:

Line 4182: l3_hash_value := dbms_utility.get_hash_value(

4178:
4179: l3_hash_string := (l_comp_class_id)||'-'||l_object1_type||'-'|| (l_object1_id)||'-'|| (nvl(l_object1_parent_id,-9999))||
4180: '-'||l_object2_type||'-'||nvl( to_char(l_object2_id),l_object2_val_char)||'-'|| (-9999);
4181:
4182: l3_hash_value := dbms_utility.get_hash_value(
4183: name => l3_hash_string,
4184: base => g_hash_base,
4185: hash_size =>g_hash_size );
4186:

Line 4247: l4_hash_value := dbms_utility.get_hash_value(

4243:
4244: l4_hash_string := (l_comp_class_id)||'-'||l_object1_type||'-'|| (l_object1_id)||'-'|| (nvl(l_object1_parent_id,-9999))||
4245: '-'||l_object2_type||'-'||nvl( to_char(l_object2_id),l_object2_val_char)||'-'|| (-9999);
4246:
4247: l4_hash_value := dbms_utility.get_hash_value(
4248: name => l4_hash_string,
4249: base => g_hash_base,
4250: hash_size =>g_hash_size );
4251:

Line 4665: l_hash_value := dbms_utility.get_hash_value(

4661:
4662: END IF;
4663: --#DUM_LOC(E)
4664:
4665: l_hash_value := dbms_utility.get_hash_value(
4666: name => p_comp_class_code,
4667: base => g_hash_base,
4668: hash_size =>g_hash_size );
4669:

Line 4756: l1_hash_value := dbms_utility.get_hash_value(

4752:
4753: l1_hash_string := (l_comp_class_id)||'-'||l_object1_type||'-'|| (p_attribute_id)||'-'|| (nvl(l_parent_id,-9999))||
4754: '-'||'FAC'||'-'|| (p_location_list(i))||'-'|| (-9999);
4755:
4756: l1_hash_value := dbms_utility.get_hash_value(
4757: name => l1_hash_string,
4758: base => g_hash_base,
4759: hash_size =>g_hash_size );
4760: --

Line 4772: l11_hash_value := dbms_utility.get_hash_value(

4768:
4769: l11_hash_string := (l_comp_class_id)||'-'||l_object1_type||'-'||to_char(l_master_org_id)||'-'||(nvl(l_parent_id,-9999))||
4770: '-'||'FAC'||'-'||to_char(p_location_list(i))||'-'||(-9999);
4771:
4772: l11_hash_value := dbms_utility.get_hash_value(
4773: name => l11_hash_string,
4774: base => g_hash_base,
4775: hash_size =>g_hash_size );
4776:

Line 5149: l_hash_value := dbms_utility.get_hash_value(

5145:
5146: l_object1_typesub := nvl(p_object1_type,l_comp_type1);
5147: l_object2_typesub := nvl(p_object2_type,l_comp_type2);
5148:
5149: l_hash_value := dbms_utility.get_hash_value(
5150: name => p_comp_class_code,
5151: base => g_hash_base,
5152: hash_size =>g_hash_size );
5153:

Line 5213: l1_hash_value := dbms_utility.get_hash_value(

5209:
5210: l1_hash_string := (l_comp_class_id)||'-'||l_object1_typesub||'-'|| (p_object1_val_num)||'-'|| (nvl(l_object1_parent_id,-9999))||
5211: '-'||l_object2_typesub||'-'||nvl( to_char(p_object2_val_num),p_object2_val_char)||'-'|| (-9999);
5212:
5213: l1_hash_value := dbms_utility.get_hash_value(
5214: name => l1_hash_string,
5215: base => g_hash_base,
5216: hash_size =>g_hash_size );
5217: --

Line 5267: l2_hash_value := dbms_utility.get_hash_value(

5263:
5264: l2_hash_string := (l_comp_class_id)||'-'||'CAR'||'-'|| (l_carrier_id)||'-'|| (-9999)||
5265: '-'||l_object2_typesub||'-'||nvl( to_char(p_object2_val_num),p_object2_val_char)||'-'|| (-9999);
5266:
5267: l2_hash_value := dbms_utility.get_hash_value(
5268: name => l2_hash_string,
5269: base => g_hash_base,
5270: hash_size =>g_hash_size );
5271: --

Line 5325: l3_hash_value := dbms_utility.get_hash_value(

5321:
5322: l3_hash_string := (l_comp_class_id)||'-'||'CUS'||'-'|| (l_customer_id_tab(itr))||'-'|| (-9999)||
5323: '-'||l_object2_typesub||'-'||nvl( to_char(p_object2_val_num),p_object2_val_char)||'-'|| (-9999);
5324:
5325: l3_hash_value := dbms_utility.get_hash_value(
5326: name => l3_hash_string,
5327: base => g_hash_base,
5328: hash_size =>g_hash_size );
5329: --

Line 5385: l4_hash_value := dbms_utility.get_hash_value(

5381:
5382: l4_hash_string := (l_comp_class_id)||'-'||'SUP'||'-'|| (l_supplier_id)||'-'|| (-9999)||
5383: '-'||l_object2_typesub||'-'||nvl( to_char(p_object2_val_num),p_object2_val_char)||'-'|| (-9999);
5384:
5385: l4_hash_value := dbms_utility.get_hash_value(
5386: name => l4_hash_string,
5387: base => g_hash_base,
5388: hash_size =>g_hash_size );
5389: --

Line 5761: l_hash_value := dbms_utility.get_hash_value(

5757: END IF;
5758:
5759: l_hash_string := l_fac_hash_string || p_items_tab(j).item_id||'-'||nvl(l_item_org_id,-9999);
5760:
5761: l_hash_value := dbms_utility.get_hash_value(
5762: name => l_hash_string,
5763: base => g_hash_base,
5764: hash_size =>g_hash_size );
5765:

Line 6060: l_hash_value := dbms_utility.get_hash_value(

6056:
6057: l_hash_string := p_entity_rec.inventory_item_id||'-'||nvl(l_input_item_org_id,-9999)||'-';
6058: l_hash_string := l_hash_string || p_target_rec.inventory_item_id||'-'||nvl(l_target_item_org_id,-9999);
6059:
6060: l_hash_value := dbms_utility.get_hash_value(
6061: name => l_hash_string,
6062: base => g_hash_base,
6063: hash_size =>g_hash_size );
6064: