APPS.INV_UOM_API_PUB dependencies on MTL_UOM_CLASS_CONVERSIONS

Line 1130: -- Code logic to insert MTL_UOM_CLASS_CONVERSIONS table.

1126: 'N'
1127: );
1128: END;
1129: -- End of Code logic to insert MTL_UOM_CONVERSIONS table.
1130: -- Code logic to insert MTL_UOM_CLASS_CONVERSIONS table.
1131: BEGIN
1132: INSERT
1133: INTO MTL_UOM_CLASS_CONVERSIONS
1134: (

Line 1133: INTO MTL_UOM_CLASS_CONVERSIONS

1129: -- End of Code logic to insert MTL_UOM_CONVERSIONS table.
1130: -- Code logic to insert MTL_UOM_CLASS_CONVERSIONS table.
1131: BEGIN
1132: INSERT
1133: INTO MTL_UOM_CLASS_CONVERSIONS
1134: (
1135: INVENTORY_ITEM_ID,
1136: FROM_UNIT_OF_MEASURE,
1137: FROM_UOM_CODE,

Line 1213: -- End of Code logic to insert MTL_UOM_CLASS_CONVERSIONS table.

1209: END IF;
1210:
1211: END IF;
1212:
1213: -- End of Code logic to insert MTL_UOM_CLASS_CONVERSIONS table.
1214: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS ;
1215:
1216: COMMIT;
1217:

Line 2165: UPDATE MTL_UOM_CLASS_CONVERSIONS

2161: WHERE INVENTORY_ITEM_ID = NVL(P_ITEM_ID,0)
2162: AND UOM_CODE = P_TO_UOM_CODE;
2163: ELSE
2164:
2165: UPDATE MTL_UOM_CLASS_CONVERSIONS
2166: SET DISABLE_DATE = P_DISABLE_DATE
2167: WHERE INVENTORY_ITEM_ID = NVL(P_ITEM_ID,0)
2168: AND FROM_UOM_CODE = P_FROM_UOM_CODE
2169: AND TO_UOM_CODE = P_TO_UOM_CODE;

Line 2239: FROM MTL_UOM_CLASS_CONVERSIONS

2235: BEGIN
2236:
2237: SELECT 1
2238: INTO L_COUNT
2239: FROM MTL_UOM_CLASS_CONVERSIONS
2240: WHERE INVENTORY_ITEM_ID = P_ITEM_ID
2241: AND FROM_UOM_CODE = P_FROM_UOM_CODE
2242: AND TO_UOM_CODE = P_TO_UOM_CODE ;
2243: -- AND NVL(DISABLE_DATE, TRUNC(SYSDATE) + 1) > TRUNC(SYSDATE);

Line 2249: UPDATE MTL_UOM_CLASS_CONVERSIONS

2245: WHEN OTHERS THEN
2246: RAISE L_CONV_NOT_EXISTS;
2247: END;
2248:
2249: UPDATE MTL_UOM_CLASS_CONVERSIONS
2250: SET CONVERSION_RATE = P_UOM_RATE,
2251: DISABLE_DATE = P_DISABLE_DATE
2252: WHERE INVENTORY_ITEM_ID = P_ITEM_ID
2253: AND FROM_UOM_CODE = P_FROM_UOM_CODE