APPS.MTL_LOT_UOM_CONV_PKG dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 54: INSERT INTO MTL_LOT_UOM_CLASS_CONVERSIONS(

50: CLOSE GET_CONV_SEQ;
51: END IF;
52:
53:
54: INSERT INTO MTL_LOT_UOM_CLASS_CONVERSIONS(
55: CONVERSION_ID,
56: LOT_NUMBER,
57: ORGANIZATION_ID,
58: INVENTORY_ITEM_ID,

Line 155: UPDATE MTL_LOT_UOM_CLASS_CONVERSIONS SET

151:
152: BEGIN
153:
154: x_return_status := FND_API.G_RET_STS_SUCCESS;
155: UPDATE MTL_LOT_UOM_CLASS_CONVERSIONS SET
156: LOT_NUMBER = X_LOT_NUMBER,
157: ORGANIZATION_ID = X_ORGANIZATION_ID,
158: INVENTORY_ITEM_ID = X_INVENTORY_ITEM_ID,
159: FROM_UNIT_OF_MEASURE = X_FROM_UNIT_OF_MEASURE,

Line 216: UPDATE MTL_LOT_UOM_CLASS_CONVERSIONS SET

212:
213: BEGIN
214:
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216: UPDATE MTL_LOT_UOM_CLASS_CONVERSIONS SET
217: DISABLE_DATE = X_DISABLE_DATE,
218: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
219: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
220: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 268: FROM mtl_lot_uom_class_conversions

264: )
265: IS
266: CURSOR c IS
267: SELECT *
268: FROM mtl_lot_uom_class_conversions
269: WHERE conversion_id = x_conversion_id
270: AND organization_id = x_organization_id
271: FOR UPDATE OF organization_id NOWAIT;
272: