APPS.CSM_UTIL_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 1877: p_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,

1873:
1874: FUNCTION Get_Datediff_For_Req_UOM(
1875: p_start_date IN DATE,
1876: p_end_date IN DATE,
1877: p_class IN MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,
1878: p_to_uom IN CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE,
1879: p_min_uom IN CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE
1880: )
1881: RETURN NUMBER

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

1889: l_base_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE;
1890: l_base_conversion_rate NUMBER;
1891:
1892: --Cursor Declarations
1893: CURSOR c_base_uom(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
1894: IS
1895: SELECT UOM_CODE
1896: FROM MTL_UNITS_OF_MEASURE
1897: WHERE UOM_CLASS = c_uom_class

Line 1896: FROM MTL_UNITS_OF_MEASURE

1892: --Cursor Declarations
1893: CURSOR c_base_uom(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE)
1894: IS
1895: SELECT UOM_CODE
1896: FROM MTL_UNITS_OF_MEASURE
1897: WHERE UOM_CLASS = c_uom_class
1898: AND base_uom_flag = 'Y';
1899:
1900: CURSOR c_actual_conversion(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,

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

1896: FROM MTL_UNITS_OF_MEASURE
1897: WHERE UOM_CLASS = c_uom_class
1898: AND base_uom_flag = 'Y';
1899:
1900: CURSOR c_actual_conversion(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,
1901: c_convert_to_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE)
1902: IS
1903: SELECT conversion_rate
1904: FROM MTL_UOM_CONVERSIONS

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

1905: WHERE UOM_CLASS = c_uom_class
1906: AND UOM_CODE = c_convert_to_uom
1907: AND inventory_item_id = 0;
1908:
1909: CURSOR c_base_conversion(c_uom_class MTL_UNITS_OF_MEASURE.UOM_CLASS%TYPE,
1910: c_convert_to_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE)
1911: IS
1912: SELECT conversion_rate
1913: FROM MTL_UOM_CONVERSIONS