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 434: Insert or update mtl_lot_uom_class_conversions.

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

Line 1289: FROM mtl_lot_uom_class_conversions

1285: ======================================*/
1286:
1287: CURSOR c_get_conversions IS
1288: SELECT *
1289: FROM mtl_lot_uom_class_conversions
1290: WHERE nvl(disable_date, trunc(sysdate)+1) > trunc(sysdate)
1291: AND organization_id = p_from_organization_id
1292: AND lot_number = p_from_lot_number
1293: AND inventory_item_id = p_inventory_item_id;

Line 1295: l_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE;

1291: AND organization_id = p_from_organization_id
1292: AND lot_number = p_from_lot_number
1293: AND inventory_item_id = p_inventory_item_id;
1294:
1295: l_lot_uom_conv_rec mtl_lot_uom_class_conversions%ROWTYPE;
1296:
1297: /*======================================
1298: Cursor to Retrieve Reason_id.
1299: --tempy do not use until this is loaded

Line 1321: FROM mtl_lot_uom_class_conversions

1317: =========================================*/
1318:
1319: CURSOR c_check_exists IS
1320: SELECT 1
1321: FROM mtl_lot_uom_class_conversions
1322: WHERE organization_id = p_to_organization_id
1323: AND lot_number = p_to_lot_number
1324: AND inventory_item_id = p_inventory_item_id
1325: AND from_uom_code = l_lot_uom_conv_rec.from_uom_code