1168:
1169: CURSOR c_get_EBS_UOM(c_uom_class IN VARCHAR2,c_uom IN VARCHAR2)
1170: IS
1171: SELECT uom_code
1172: FROM MTL_UNITS_OF_MEASURE
1173: WHERE uom_class=c_uom_class
1174: AND nvl(disable_date, sysdate) >= SYSDATE
1175: AND attribute15=c_uom;
1176:
1176:
1177: CURSOR c_check_uom(c_uom_class IN VARCHAR2, c_uom IN VARCHAR2)
1178: IS
1179: SELECT UOM_CODE
1180: FROM mtl_units_of_measure
1181: WHERE uom_code = c_uom
1182: AND nvl(disable_date, sysdate) >= SYSDATE
1183: AND uom_class = c_uom_class;
1184:
1273:
1274: CURSOR c_get_OTM_UOM(c_uom IN VARCHAR2)
1275: IS
1276: SELECT attribute15
1277: FROM MTL_UNITS_OF_MEASURE
1278: WHERE uom_code=c_uom
1279: AND nvl(disable_date, sysdate) >= SYSDATE;
1280:
1281: l_uom VARCHAR2(30);