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.INV_UOM_API_PUB dependencies on MTL_UNITS_OF_MEASURE

Line 468: L_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;

464: IS
465: L_FOUND BOOLEAN;
466: L_SUCCESS VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
467: -- L_UNIT_OF_MEASURE VARCHAR2(25);
468: L_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
469:
470: -- L_UOM_CODE VARCHAR2(3);
471:
472: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;

Line 472: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;

468: L_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
469:
470: -- L_UOM_CODE VARCHAR2(3);
471:
472: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;
473:
474: -- p_uom_class_tl VARCHAR2(10);
475: p_uom_class_tl MTL_UOM_CLASSES_TL.UOM_CLASS_TL%type;
476: L_ROW_ID VARCHAR2(40);

Line 601: FROM MTL_UNITS_OF_MEASURE_VL

597: BEGIN
598:
599: SELECT UNIT_OF_MEASURE
600: INTO L_UNIT_OF_MEASURE
601: FROM MTL_UNITS_OF_MEASURE_VL
602: WHERE UNIT_OF_MEASURE_TL = P_BASE_UNIT_OF_MEASURE
603: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
604:
605: EXCEPTION

Line 629: FROM MTL_UNITS_OF_MEASURE_VL

625: BEGIN
626:
627: SELECT UOM_CODE
628: INTO L_UOM_CODE
629: FROM MTL_UNITS_OF_MEASURE_VL
630: WHERE UOM_CODE = P_BASE_UOM_CODE
631: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
632:
633: EXCEPTION

Line 739: FROM MTL_UNITS_OF_MEASURE_VL

735: SELECT UNIT_OF_MEASURE,
736: UOM_CODE
737: INTO L_UNIT_OF_MEASURE ,
738: L_UOM_CODE
739: FROM MTL_UNITS_OF_MEASURE_VL
740: WHERE UOM_CLASS = P_UOM_CLASS
741: AND UNIT_OF_MEASURE_TL = P_BASE_UNIT_OF_MEASURE
742: AND UOM_CODE = P_BASE_UOM_CODE ;
743:

Line 943: -- Code logic to insert MTL_UNITS_OF_MEASURE table. (user installed languages)

939: APP_EXCEPTION.RAISE_EXCEPTION;
940: END IF;
941:
942: -- End of Code logic to insert MTL_UOM_CLASSES_TL table.
943: -- Code logic to insert MTL_UNITS_OF_MEASURE table. (user installed languages)
944: -- From this procedure always base_unit_of_measure gets inserted into unit of measure table.
945: -- DBMS_OUTPUT.PUT_LINE('Before calling UOM insert');
946:
947: L_DESC_FLEX_NAME := 'MTL_UNITS_OF_MEASURE';

Line 947: L_DESC_FLEX_NAME := 'MTL_UNITS_OF_MEASURE';

943: -- Code logic to insert MTL_UNITS_OF_MEASURE table. (user installed languages)
944: -- From this procedure always base_unit_of_measure gets inserted into unit of measure table.
945: -- DBMS_OUTPUT.PUT_LINE('Before calling UOM insert');
946:
947: L_DESC_FLEX_NAME := 'MTL_UNITS_OF_MEASURE';
948:
949: l_att_count := 0;
950: IF p_uom_attribute1 IS NOT NULL THEN
951: l_att_count := l_att_count + 1;

Line 1061: MTL_UNITS_OF_MEASURE_TL_PKG.INSERT_ROW(X_ROW_ID => L_ROW_ID,

1057: END IF;
1058:
1059: END LOOP;
1060:
1061: MTL_UNITS_OF_MEASURE_TL_PKG.INSERT_ROW(X_ROW_ID => L_ROW_ID,
1062: X_UNIT_OF_MEASURE => P_BASE_UNIT_OF_MEASURE ,
1063: X_UNIT_OF_MEASURE_TL => P_BASE_UNIT_OF_MEASURE,
1064: X_ATTRIBUTE_CATEGORY => P_UOM_ATTRIBUTE_CATEGORY,
1065: X_ATTRIBUTE1 => L_UOM_ATTRIBUTES_TBL(1),

Line 1096: -- End of Code logic to insert MTL_UNITS_OF_MEASURE table.

1092: X_PROGRAM_ID => TO_NUMBER(NULL),
1093: X_PROGRAM_UPDATE_DATE => SYSDATE );
1094:
1095:
1096: -- End of Code logic to insert MTL_UNITS_OF_MEASURE table.
1097: -- Code logic to insert MTL_UOM_CONVERSIONS table.
1098: BEGIN
1099: INSERT
1100: INTO MTL_UOM_CONVERSIONS

Line 1316: L_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;

1312: L_BASE_UOM_FLAG VARCHAR2(10);
1313:
1314: -- L_UNIT_OF_MEASURE VARCHAR2(25);
1315:
1316: L_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1317:
1318: -- L_UOM_CODE VARCHAR2(3) ;
1319: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;
1320:

Line 1319: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;

1315:
1316: L_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1317:
1318: -- L_UOM_CODE VARCHAR2(3) ;
1319: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;
1320:
1321: L_FOUND BOOLEAN;
1322: L_ROW_ID VARCHAR2( 40) ;
1323: -- P_CREATED_BY NUMBER := -1;

Line 1325: L_DESC_FLEX_NAME VARCHAR2(30) := 'MTL_UNITS_OF_MEASURE' ;

1321: L_FOUND BOOLEAN;
1322: L_ROW_ID VARCHAR2( 40) ;
1323: -- P_CREATED_BY NUMBER := -1;
1324:
1325: L_DESC_FLEX_NAME VARCHAR2(30) := 'MTL_UNITS_OF_MEASURE' ;
1326:
1327: L_USERID NUMBER := FND_GLOBAL.USER_ID;
1328: L_LOGINID NUMBER := FND_GLOBAL.LOGIN_ID;
1329:

Line 1442: FROM MTL_UNITS_OF_MEASURE_VL

1438: BEGIN
1439:
1440: SELECT UNIT_OF_MEASURE , UOM_CODE , BASE_UOM_FLAG
1441: INTO L_UNIT_OF_MEASURE , L_UOM_CODE , L_BASE_UOM_FLAG
1442: FROM MTL_UNITS_OF_MEASURE_VL
1443: WHERE UOM_CLASS = P_UOM_CLASS
1444: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE)
1445: AND (UNIT_OF_MEASURE_TL = P_UNIT_OF_MEASURE
1446: OR UOM_CODE = P_UOM_CODE) ;

Line 1516: FROM MTL_UNITS_OF_MEASURE_VL

1512: BEGIN
1513:
1514: SELECT UNIT_OF_MEASURE , UOM_CODE
1515: INTO L_UNIT_OF_MEASURE , L_UOM_CODE
1516: FROM MTL_UNITS_OF_MEASURE_VL
1517: WHERE UNIT_OF_MEASURE_TL = P_UNIT_OF_MEASURE
1518: -- AND uom_code = p_uom_code
1519: OR UOM_CODE = P_UOM_CODE
1520: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);

Line 1546: -- Code logic to insert MTL_UNITS_OF_MEASURE table. (user installed languages)

1542: -- Already unit of measure and uom code exists with some other class exists.
1543:
1544: END IF;
1545: -- end of Validating p_unit_of_measure and p_uom_code
1546: -- Code logic to insert MTL_UNITS_OF_MEASURE table. (user installed languages)
1547: -- From this procedure unit_of_measure gets inserted into unit of measure table.
1548:
1549: END IF;
1550:

Line 1653: MTL_UNITS_OF_MEASURE_TL_PKG.INSERT_ROW(X_ROW_ID => L_ROW_ID,

1649: END LOOP;
1650:
1651: IF p_action_type = 'I' THEN
1652:
1653: MTL_UNITS_OF_MEASURE_TL_PKG.INSERT_ROW(X_ROW_ID => L_ROW_ID,
1654: X_UNIT_OF_MEASURE => P_UNIT_OF_MEASURE ,
1655: X_UNIT_OF_MEASURE_TL => P_UNIT_OF_MEASURE,
1656: X_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY,
1657: X_ATTRIBUTE1 => L_INV_ATTRIBUTES_TBL(1) ,

Line 1690: MTL_UNITS_OF_MEASURE_TL_PKG.UPDATE_ROW (X_UNIT_OF_MEASURE => P_UNIT_OF_MEASURE ,

1686:
1687:
1688: ELSIF p_action_type = 'U' THEN -- object type is update
1689:
1690: MTL_UNITS_OF_MEASURE_TL_PKG.UPDATE_ROW (X_UNIT_OF_MEASURE => P_UNIT_OF_MEASURE ,
1691: X_UNIT_OF_MEASURE_TL => P_UNIT_OF_MEASURE ,
1692: X_UOM_CODE => P_UOM_CODE ,
1693: X_UOM_CLASS => P_UOM_CLASS,
1694: X_BASE_UOM_FLAG => L_BASE_UOM_FLAG,

Line 1729: -- End of Code logic to insert MTL_UNITS_OF_MEASURE table.

1725: RAISE L_INVALID_OBJECT_TYPE;
1726:
1727: END IF;
1728:
1729: -- End of Code logic to insert MTL_UNITS_OF_MEASURE table.
1730: -- print_debug(' successfully returned from the package create_unit_of_measure ' || g_pkg_version, 1);
1731: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS ;
1732:
1733: COMMIT;

Line 1917: L_FROM_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;

1913: X_LINE_TYPE NUMBER;
1914: X_BATCH_ID NUMBER(10);
1915: L_CONV_REC MTL_LOT_UOM_CLASS_CONVERSIONS%ROWTYPE;
1916: -- L_FROM_UNIT_OF_MEASURE VARCHAR(25);
1917: L_FROM_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1918: -- L_FROM_UOM_CLASS VARCHAR2(30);
1919: L_FROM_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1920: L_TO_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1921: -- L_TO_UNIT_OF_MEASURE VARCHAR2(40);

Line 1920: L_TO_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;

1916: -- L_FROM_UNIT_OF_MEASURE VARCHAR(25);
1917: L_FROM_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1918: -- L_FROM_UOM_CLASS VARCHAR2(30);
1919: L_FROM_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1920: L_TO_UNIT_OF_MEASURE MTL_UNITS_OF_MEASURE_TL.UNIT_OF_MEASURE%TYPE;
1921: -- L_TO_UNIT_OF_MEASURE VARCHAR2(40);
1922: -- l_to_uom_class VARCHAR2(40);
1923: L_TO_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1924: --L_UOM_CODE VARCHAR2(3);

Line 1925: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;

1921: -- L_TO_UNIT_OF_MEASURE VARCHAR2(40);
1922: -- l_to_uom_class VARCHAR2(40);
1923: L_TO_UOM_CLASS MTL_UOM_CLASSES_TL.UOM_CLASS_TL%TYPE;
1924: --L_UOM_CODE VARCHAR2(3);
1925: L_UOM_CODE MTL_UNITS_OF_MEASURE_TL.UOM_CODE%type;
1926: -- l_class VARCHAR2(10);
1927: l_conversion_id NUMBER;
1928: l_primary_uom_code VARCHAR2(3);
1929: l_secondary_uom_code VARCHAR2(3);

Line 1976: CURSOR GET_UOM_CLASS(V_UOM MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE)

1972: WHERE BATCH_ID = X_BATCH_ID
1973: AND LINE_TYPE = X_LINE_TYPE
1974: and inventory_item_id = P_ITEM_ID;
1975:
1976: CURSOR GET_UOM_CLASS(V_UOM MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE)
1977: IS
1978: SELECT UOM_CLASS
1979: FROM MTL_UNITS_OF_MEASURE
1980: WHERE uom_code = v_uom;

Line 1979: FROM MTL_UNITS_OF_MEASURE

1975:
1976: CURSOR GET_UOM_CLASS(V_UOM MTL_UNITS_OF_MEASURE.UOM_CODE%TYPE)
1977: IS
1978: SELECT UOM_CLASS
1979: FROM MTL_UNITS_OF_MEASURE
1980: WHERE uom_code = v_uom;
1981:
1982: X_MATL_LINE GME_MATERIAL_DETAILS%ROWTYPE;
1983: l_tracking_quantity_ind mtl_system_items_b.tracking_quantity_ind%TYPE;

Line 2105: FROM MTL_UNITS_OF_MEASURE_VL

2101:
2102: BEGIN
2103: SELECT UNIT_OF_MEASURE , UOM_CLASS , BASE_UOM_FLAG
2104: INTO L_FROM_UNIT_OF_MEASURE , L_FROM_CLASS , P_FROM_BASE_UOM_FLAG
2105: FROM MTL_UNITS_OF_MEASURE_VL
2106: WHERE UOM_CODE = P_FROM_UOM_CODE
2107: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2108: EXCEPTION
2109: WHEN NO_DATA_FOUND THEN

Line 2123: FROM MTL_UNITS_OF_MEASURE_VL

2119:
2120: BEGIN
2121: SELECT UNIT_OF_MEASURE , UOM_CLASS , BASE_UOM_FLAG
2122: INTO L_TO_UNIT_OF_MEASURE , L_TO_CLASS , P_TO_BASE_UOM_FLAG
2123: FROM MTL_UNITS_OF_MEASURE_VL
2124: WHERE UOM_CODE = P_TO_UOM_CODE
2125: AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2126: EXCEPTION
2127: WHEN NO_DATA_FOUND THEN

Line 2357: FROM MTL_UNITS_OF_MEASURE_VL

2353: -- These uom code must be base uom.
2354: BEGIN
2355: SELECT UOM_CODE , UOM_CLASS
2356: INTO l_uom_code , l_from_uom_class
2357: FROM MTL_UNITS_OF_MEASURE_VL
2358: WHERE UOM_CODE = P_FROM_UOM_CODE
2359: AND base_uom_flag = 'Y'
2360: AND NVL(disable_date, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2361: EXCEPTION

Line 2377: FROM MTL_UNITS_OF_MEASURE_VL

2373: BEGIN
2374:
2375: SELECT UOM_CODE
2376: INTO L_PRIMARY_UOM_CODE
2377: FROM MTL_UNITS_OF_MEASURE_VL
2378: WHERE UOM_CODE = L_PRIMARY_UOM_CODE
2379: and uom_class = l_from_uom_class
2380: AND NVL(disable_date, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2381:

Line 2397: FROM MTL_UNITS_OF_MEASURE_VL

2393:
2394: BEGIN
2395: SELECT uom_code
2396: INTO l_uom_code
2397: FROM MTL_UNITS_OF_MEASURE_VL
2398: WHERE UOM_CODE = P_TO_UOM_CODE
2399: AND BASE_UOM_FLAG = 'Y'
2400: AND NVL(disable_date, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);
2401: EXCEPTION

Line 2491: -- Fetch the p_to_unit_of_measure from MTL_UNITS_OF_MEASURE_VL.

2487: AND INVENTORY_ITEM_ID = P_ITEM_ID
2488: AND LOT_NUMBER = P_LOT_NUMBER
2489: AND TO_UOM_CODE = P_TO_UOM_CODE ;
2490: --AND to_unit_of_measure = p_to_unit_of_measure;
2491: -- Fetch the p_to_unit_of_measure from MTL_UNITS_OF_MEASURE_VL.
2492: EXCEPTION
2493: WHEN NO_DATA_FOUND THEN
2494: IF (L_DEBUG = 1) THEN
2495: INV_LOG_UTIL.TRACE('uom class conversion not exists', 'inv_uom_api_pub', '9');

Line 2534: -- Fetch the p_to_unit_of_measure from MTL_UNITS_OF_MEASURE_VL.

2530: AND LOT_NUMBER = P_LOT_NUMBER
2531: AND TO_UOM_CODE = P_TO_UOM_CODE
2532: AND from_uom_code = P_FROM_UOM_CODE ;
2533: --AND to_unit_of_measure = p_to_unit_of_measure;
2534: -- Fetch the p_to_unit_of_measure from MTL_UNITS_OF_MEASURE_VL.
2535: EXCEPTION
2536: WHEN NO_DATA_FOUND THEN
2537: IF (L_DEBUG = 1) THEN
2538: INV_LOG_UTIL.TRACE('No data found exception, lot conversion does not exists', 'inv_uom_api_pub', '9');

Line 3073: FROM MTL_UNITS_OF_MEASURE

3069: BEGIN
3070:
3071: SELECT UNIT_OF_MEASURE , UOM_CLASS
3072: INTO L_FROM_UNIT_OF_MEASURE , L_FROM_UOM_CLASS
3073: FROM MTL_UNITS_OF_MEASURE
3074: WHERE UOM_CODE = P_FROM_UOM_CODE;
3075:
3076: SELECT UNIT_OF_MEASURE , UOM_CLASS
3077: INTO L_TO_UNIT_OF_MEASURE , L_TO_UOM_CLASS

Line 3078: FROM MTL_UNITS_OF_MEASURE

3074: WHERE UOM_CODE = P_FROM_UOM_CODE;
3075:
3076: SELECT UNIT_OF_MEASURE , UOM_CLASS
3077: INTO L_TO_UNIT_OF_MEASURE , L_TO_UOM_CLASS
3078: FROM MTL_UNITS_OF_MEASURE
3079: WHERE UOM_CODE = P_TO_UOM_CODE;
3080:
3081: EXCEPTION
3082: WHEN OTHERS THEN