APPS.INV_RSV_DETAIL_STAGE_PVT dependencies on INV_CACHE

Line 52: IF inv_cache.set_org_rec(l_rsv_rec.organization_id) THEN

48: debug_print('Checking whether the reservations are allowed or not ');
49: END IF;
50:
51: -- Check whether the onhand is reservable or not
52: IF inv_cache.set_org_rec(l_rsv_rec.organization_id) THEN
53: l_default_org_status_id := inv_cache.org_rec.default_status_id;
54: END IF;
55:
56: IF (l_debug = 1) THEN

Line 53: l_default_org_status_id := inv_cache.org_rec.default_status_id;

49: END IF;
50:
51: -- Check whether the onhand is reservable or not
52: IF inv_cache.set_org_rec(l_rsv_rec.organization_id) THEN
53: l_default_org_status_id := inv_cache.org_rec.default_status_id;
54: END IF;
55:
56: IF (l_debug = 1) THEN
57: debug_print('Default Org status id is :' || l_default_org_status_id );

Line 438: IF INV_CACHE.item_rec.revision_qty_control_code = inv_reservation_global.g_revision_control_yes THEN

434: IF (l_debug = 1) THEN
435: debug_print('Inside Get atr ');
436: END IF;
437:
438: IF INV_CACHE.item_rec.revision_qty_control_code = inv_reservation_global.g_revision_control_yes THEN
439: l_rev_control := TRUE;
440: ELSE
441: l_rev_control := FALSE;
442: END IF;

Line 444: IF INV_CACHE.item_rec.lot_control_code = inv_reservation_global.g_lot_control_yes THEN

440: ELSE
441: l_rev_control := FALSE;
442: END IF;
443:
444: IF INV_CACHE.item_rec.lot_control_code = inv_reservation_global.g_lot_control_yes THEN
445: l_lot_control := TRUE;
446: ELSE
447: l_lot_control := FALSE;
448: END IF;

Line 450: IF INV_CACHE.item_rec.serial_number_control_code <> inv_reservation_global.g_serial_control_predefined THEN

446: ELSE
447: l_lot_control := FALSE;
448: END IF;
449:
450: IF INV_CACHE.item_rec.serial_number_control_code <> inv_reservation_global.g_serial_control_predefined THEN
451: l_ser_control := TRUE;
452: ELSE
453: l_ser_control := FALSE;
454: END IF;

Line 805: l_return_value := INV_CACHE.set_item_rec (l_rsv_rec.organization_id, l_rsv_rec.inventory_item_id);

801: RETURN;
802: END IF;
803:
804: -- set the item cache
805: l_return_value := INV_CACHE.set_item_rec (l_rsv_rec.organization_id, l_rsv_rec.inventory_item_id);
806: If NOT l_return_value THEN
807: IF (l_debug = 1) THEN
808: debug_print('Exception occurred while setting the item cache');
809: END IF;

Line 813: l_primary_uom := INV_CACHE.item_rec.primary_uom_code;

809: END IF;
810: RAISE fnd_api.g_exc_unexpected_error;
811: End If;
812:
813: l_primary_uom := INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom := INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code := INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code := INV_CACHE.item_rec.lot_control_code;
817: l_serial_number_control_code := INV_CACHE.item_rec.serial_number_control_code;

Line 814: l_secondary_uom := INV_CACHE.item_rec.secondary_uom_code;

810: RAISE fnd_api.g_exc_unexpected_error;
811: End If;
812:
813: l_primary_uom := INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom := INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code := INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code := INV_CACHE.item_rec.lot_control_code;
817: l_serial_number_control_code := INV_CACHE.item_rec.serial_number_control_code;
818:

Line 815: l_revision_control_code := INV_CACHE.item_rec.revision_qty_control_code;

811: End If;
812:
813: l_primary_uom := INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom := INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code := INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code := INV_CACHE.item_rec.lot_control_code;
817: l_serial_number_control_code := INV_CACHE.item_rec.serial_number_control_code;
818:
819: IF (l_debug = 1) THEN

Line 816: l_lot_control_code := INV_CACHE.item_rec.lot_control_code;

812:
813: l_primary_uom := INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom := INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code := INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code := INV_CACHE.item_rec.lot_control_code;
817: l_serial_number_control_code := INV_CACHE.item_rec.serial_number_control_code;
818:
819: IF (l_debug = 1) THEN
820: debug_print('Printing values from the item cache');

Line 817: l_serial_number_control_code := INV_CACHE.item_rec.serial_number_control_code;

813: l_primary_uom := INV_CACHE.item_rec.primary_uom_code;
814: l_secondary_uom := INV_CACHE.item_rec.secondary_uom_code;
815: l_revision_control_code := INV_CACHE.item_rec.revision_qty_control_code;
816: l_lot_control_code := INV_CACHE.item_rec.lot_control_code;
817: l_serial_number_control_code := INV_CACHE.item_rec.serial_number_control_code;
818:
819: IF (l_debug = 1) THEN
820: debug_print('Printing values from the item cache');
821: debug_print('l_primary_uom : '|| l_primary_uom);