APPS.MTL_LOT_UOM_CONV_PVT dependencies on MTL_LOT_UOM_CLASS_CONVERSIONS

Line 295: , p_lot_uom_conv_rec IN OUT NOCOPY mtl_lot_uom_class_conversions%ROWTYPE

291: ( p_action_type IN VARCHAR2
292: , p_update_type_indicator IN NUMBER DEFAULT 5
293: , p_reason_id IN NUMBER
294: , p_batch_id IN NUMBER
295: , p_lot_uom_conv_rec IN OUT NOCOPY mtl_lot_uom_class_conversions%ROWTYPE
296: , p_qty_update_tbl IN OUT NOCOPY mtl_lot_uom_conv_pub.quantity_update_rec_type
297: , x_return_status OUT NOCOPY VARCHAR2
298: , x_msg_count OUT NOCOPY NUMBER
299: , x_msg_data OUT NOCOPY VARCHAR2

Line 321: FROM mtl_lot_uom_class_conversions

317:
318:
319: CURSOR get_old_conv_Rate IS
320: SELECT conversion_rate, conversion_id
321: FROM mtl_lot_uom_class_conversions
322: WHERE organization_id = p_lot_uom_conv_rec.organization_id AND
323: inventory_item_id = p_lot_uom_conv_rec.inventory_item_id AND
324: lot_number = p_lot_uom_conv_rec.lot_number AND
325: from_uom_code = p_lot_uom_conv_rec.from_uom_code AND

Line 433: Insert or update mtl_lot_uom_class_conversions.

429:
430: SAVEPOINT PROCESS_CONVERSION_DATA;
431:
432: /*==================================================
433: Insert or update mtl_lot_uom_class_conversions.
434: ==================================================*/
435:
436: IF (p_action_type = 'I') THEN
437: l_old_conversion_rate := NULL;

Line 1271: FROM mtl_lot_uom_class_conversions

1267: ======================================*/
1268:
1269: CURSOR c_get_conversions IS
1270: SELECT *
1271: FROM mtl_lot_uom_class_conversions
1272: WHERE nvl(disable_date, trunc(sysdate)+1) > trunc(sysdate)
1273: AND organization_id = p_from_organization_id
1274: AND lot_number = p_from_lot_number
1275: AND inventory_item_id = p_inventory_item_id;

Line 1277: l_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE;

1273: AND organization_id = p_from_organization_id
1274: AND lot_number = p_from_lot_number
1275: AND inventory_item_id = p_inventory_item_id;
1276:
1277: l_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE;
1278:
1279: /*======================================
1280: Cursor to Retrieve Reason_id.
1281: --tempy do not use until this is loaded

Line 1303: FROM mtl_lot_uom_class_conversions

1299: =========================================*/
1300:
1301: CURSOR c_check_exists IS
1302: SELECT 1
1303: FROM mtl_lot_uom_class_conversions
1304: WHERE organization_id = p_to_organization_id
1305: AND lot_number = p_to_lot_number
1306: AND inventory_item_id = p_inventory_item_id
1307: AND from_uom_code = l_lot_uom_conv_rec.from_uom_code