21: RETURN FALSE; /* validation fails*/
22: /* must either specify uom_code or unit_of_measure */
23: END IF;
24:
25: /* check to see if x_uom_code is valid in po_units_of_measure_val_v */
26: x_progress := '020';
27:
28: SELECT count(*)
29: INTO x_temp
26: x_progress := '020';
27:
28: SELECT count(*)
29: INTO x_temp
30: FROM po_units_of_measure_val_v
31: WHERE (uom_code = x_uom_code
32: OR
33: X_uom_code IS NULL)
34: AND (unit_of_measure = X_unit_of_measure
103: based on the x_uom_code which is provided from input para. */
104:
105: SELECT unit_of_measure
106: INTO X_unit_of_measure_v
107: FROM po_units_of_measure_val_v
108: WHERE uom_code = X_uom_code;
109:
110: RETURN X_unit_of_measure_v;
111: