APPS.INV_UOM_API_PUB dependencies on MTL_UNITS_OF_MEASURE_TL

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 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 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 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 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);