513:
514: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
515: is
516: SELECT 1
517: FROM MTL_UNITS_OF_MEASURE_TL
518: WHERE uom_code = p_uom_code
519: AND LANGUAGE = USERENV('LANG');
520:
521: cr_validate_uom cs_validate_uom%ROWTYPE;
655:
656: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
657: is
658: SELECT 1
659: FROM MTL_UNITS_OF_MEASURE_TL
660: WHERE uom_code = p_uom_code
661: --AND uom_class = 'Time' commented for bug#5585356
662: AND LANGUAGE = USERENV('LANG');
663: cr_validate_uom cs_validate_uom%ROWTYPE;
813: as
814: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
815: is
816: SELECT 1
817: FROM MTL_UNITS_OF_MEASURE_TL
818: WHERE uom_code = p_uom_code
819: --AND uom_class = 'Time' commented for bug#5585356
820: AND LANGUAGE = USERENV('LANG');
821:
955:
956: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
957: is
958: SELECT 1
959: FROM MTL_UNITS_OF_MEASURE_TL
960: WHERE uom_code = p_uom_code
961: --AND uom_class = 'Time' commented for bug#5585356
962: AND LANGUAGE = USERENV('LANG');
963: cr_validate_uom cs_validate_uom%ROWTYPE;
1110:
1111: CURSOR cs_validate_uom(p_uom_code IN VARCHAR2)
1112: is
1113: SELECT 1
1114: FROM MTL_UNITS_OF_MEASURE_TL
1115: WHERE uom_code = p_uom_code
1116: --AND uom_class = 'Time' commented for bug#5585356
1117: AND LANGUAGE = USERENV('LANG');
1118: