eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_UTIL_PKG dependencies on CSM_UNIT_OF_MEASURE_TL_ACC

Line 1929: p_to_uom IN CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE,

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
1933: IS

Line 1930: p_min_uom IN CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE

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
1933: IS
1934: l_datediffmin NUMBER;

Line 1939: l_uom_min CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE;

1935: l_converted_value NUMBER;
1936: l_conversion_rate NUMBER;
1937: l_base_value NUMBER;
1938: l_actual_value NUMBER;
1939: l_uom_min CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE;
1940: l_base_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE;
1941: l_base_conversion_rate NUMBER;
1942:
1943: --Cursor Declarations

Line 1940: l_base_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE;

1936: l_conversion_rate NUMBER;
1937: l_base_value NUMBER;
1938: l_actual_value NUMBER;
1939: l_uom_min CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%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)

Line 1952: c_convert_to_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE)

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
1956: WHERE UOM_CLASS = c_uom_class

Line 1961: c_convert_to_uom CSM_UNIT_OF_MEASURE_TL_ACC.UOM_CODE%TYPE)

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
1965: WHERE UOM_CLASS = c_uom_class