APPS.INV_UOM_API_PUB dependencies on MTL_UOM_CONVERSIONS

Line 1097: -- Code logic to insert MTL_UOM_CONVERSIONS table.

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
1101: (

Line 1100: INTO MTL_UOM_CONVERSIONS

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
1101: (
1102: INVENTORY_ITEM_ID,
1103: UNIT_OF_MEASURE,
1104: UOM_CODE,

Line 1129: -- End of Code logic to insert MTL_UOM_CONVERSIONS table.

1125: 1,
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

Line 2159: UPDATE MTL_UOM_CONVERSIONS

2155: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
2156:
2157: IF L_FROM_CLASS = L_TO_CLASS THEN -- standard intra class conversion.
2158:
2159: UPDATE MTL_UOM_CONVERSIONS
2160: SET DISABLE_DATE = P_DISABLE_DATE
2161: WHERE INVENTORY_ITEM_ID = NVL(P_ITEM_ID,0)
2162: AND UOM_CODE = P_TO_UOM_CODE;
2163: ELSE

Line 2212: FROM MTL_UOM_CONVERSIONS

2208: BEGIN
2209:
2210: SELECT 1
2211: INTO L_COUNT
2212: FROM MTL_UOM_CONVERSIONS
2213: WHERE INVENTORY_ITEM_ID = nvl(P_ITEM_ID,0)
2214: AND UOM_CODE = P_TO_UOM_CODE ;
2215: EXCEPTION
2216: WHEN OTHERS THEN

Line 2220: UPDATE MTL_UOM_CONVERSIONS

2216: WHEN OTHERS THEN
2217: RAISE L_CONV_NOT_EXISTS;
2218: END;
2219:
2220: UPDATE MTL_UOM_CONVERSIONS
2221: SET CONVERSION_RATE = P_UOM_RATE,
2222: DISABLE_DATE = P_DISABLE_DATE
2223: WHERE INVENTORY_ITEM_ID = nvl(P_ITEM_ID,0)
2224: AND UOM_CODE = P_TO_UOM_CODE ;