APPS.FTE_VEHICLE_PKG dependencies on WSH_GLOBAL_PARAMETERS

Line 58: -- from wsh_global_parameters

54: -- : current implementation to be consistent with LOV behavior
55: -- (java/util/webui/LovUOMCO.java)
56: -- 2) The alternative would be validating against all UOM Classes.
57: -- AND UOM_CLASS like (select gu_weight_class
58: -- from wsh_global_parameters
59: -- where rownum=1)||'%';
60: -- :The defect with this approach is if 'Weight' is set as the default
61: -- class and a non-used 'Weight***' class exists, any UOM belonging to
62: -- 'Weight***' can also be accepted.

Line 73: from wsh_global_parameters where rownum=1);

69: WHERE UNIT_OF_MEASURE_TL = p_weight_uom
70: AND LANGUAGE = USERENV('LANG')
71: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
72: AND UOM_CLASS = (select gu_weight_class
73: from wsh_global_parameters where rownum=1);
74:
75: EXCEPTION
76: WHEN OTHERS THEN
77: i := i+1;

Line 91: from wsh_global_parameters where rownum=1);

87: WHERE UNIT_OF_MEASURE_TL = p_volume_uom
88: AND LANGUAGE = USERENV('LANG')
89: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
90: AND UOM_CLASS = (select gu_volume_class
91: from wsh_global_parameters where rownum=1);
92: EXCEPTION
93: WHEN OTHERS THEN
94: i := i+1;
95: x_error_table(i) := fnd_message.get_string('FTE','FTE_VEH_VOL_UOM_INVALID');

Line 108: from wsh_global_parameters where rownum=1);

104: WHERE UNIT_OF_MEASURE_TL = p_dimension_uom
105: AND LANGUAGE = USERENV('LANG')
106: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE
107: AND UOM_CLASS = (select gu_dimension_class
108: from wsh_global_parameters where rownum=1);
109: EXCEPTION
110: WHEN OTHERS THEN
111: i := i+1;
112: x_error_table(i) := fnd_message.get_string('FTE','FTE_VEH_DIM_UOM_INVALID');