61: x_progress varchar2(3) := null;
62: x_temp binary_integer := 0;
63:
64: BEGIN
65: /* check to see if x_item_unit_of_measure is valid in mtl_item_uoms_view */
66: x_progress := '010';
67:
68: SELECT count(*)
69: INTO x_temp
66: x_progress := '010';
67:
68: SELECT count(*)
69: INTO x_temp
70: FROM mtl_item_uoms_view
71: WHERE unit_of_measure = x_item_unit_of_measure
72: AND inventory_item_id = x_item_id
73: AND organization_id = x_organization_id;
74: