152: PROCEDURE validate_uom
153: (
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_uom IN MTL_UNITS_OF_MEASURE_VL.unit_of_measure%TYPE,
157: p_x_uom_code IN OUT NOCOPY MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
158: );
159:
160: -- Procedure to validate whether a UOM is valid for an Item / Item Group
153: (
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_uom IN MTL_UNITS_OF_MEASURE_VL.unit_of_measure%TYPE,
157: p_x_uom_code IN OUT NOCOPY MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
158: );
159:
160: -- Procedure to validate whether a UOM is valid for an Item / Item Group
161: PROCEDURE validate_item_uom
164: x_msg_data OUT NOCOPY VARCHAR2,
165: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,
166: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
167: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,
168: p_uom_code IN MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
169: );
170:
171: -- Procedure to validate Product Type and Zone association
172: PROCEDURE validate_pt_zone