APPS.CSM_UTIL_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 1928: p_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,

1924:
1925: FUNCTION Get_Datediff_For_Req_UOM(
1926: p_start_date IN DATE,
1927: p_end_date IN DATE,
1928: p_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,
1929: p_to_uom IN CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE,
1930: p_min_uom IN CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE
1931: )
1932: RETURN NUMBER

Line 1944: CURSOR c_base_uom(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)

1940: l_base_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE;
1941: l_base_conversion_rate NUMBER;
1942:
1943: --Cursor Declarations
1944: CURSOR c_base_uom(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
1945: IS
1946: SELECT UOM_CODE
1947: FROM MTL_UNITS_OF_MEASURE
1948: WHERE UOM_CLASS = c_uom_class

Line 1947: FROM MTL_UNITS_OF_MEASURE

1943: --Cursor Declarations
1944: CURSOR c_base_uom(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
1945: IS
1946: SELECT UOM_CODE
1947: FROM MTL_UNITS_OF_MEASURE
1948: WHERE UOM_CLASS = c_uom_class
1949: AND base_uom_flag = 'Y';
1950:
1951: CURSOR c_actual_conversion(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,

Line 1951: CURSOR c_actual_conversion(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,

1947: FROM MTL_UNITS_OF_MEASURE
1948: WHERE UOM_CLASS = c_uom_class
1949: AND base_uom_flag = 'Y';
1950:
1951: CURSOR c_actual_conversion(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,
1952: c_convert_to_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE)
1953: IS
1954: SELECT conversion_rate
1955: FROM MTL_UOM_CONVERSIONS

Line 1960: CURSOR c_base_conversion(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,

1956: WHERE UOM_CLASS = c_uom_class
1957: AND UOM_CODE = c_convert_to_uom
1958: AND inventory_item_id = 0;
1959:
1960: CURSOR c_base_conversion(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,
1961: c_convert_to_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE)
1962: IS
1963: SELECT conversion_rate
1964: FROM MTL_UOM_CONVERSIONS