APPS.INV_LABEL_PVT4 dependencies on INV_CACHE

Line 2815: IF(inv_cache.set_org_rec(v_lpn_content.organization_id))THEN

2811: l_parent_lpn := l_lpn_info.parent_lpn;
2812: END IF;
2813: --LPN STATUS project
2814:
2815: IF(inv_cache.set_org_rec(v_lpn_content.organization_id))THEN
2816: IF((inv_cache.org_rec.default_status_id) IS NOT NULL)THEN
2817: l_onhand_status_enabled := 1;
2818: l_default_org_status_id := inv_cache.org_rec.default_status_id ;
2819: l_serial_controlled := 0;

Line 2816: IF((inv_cache.org_rec.default_status_id) IS NOT NULL)THEN

2812: END IF;
2813: --LPN STATUS project
2814:
2815: IF(inv_cache.set_org_rec(v_lpn_content.organization_id))THEN
2816: IF((inv_cache.org_rec.default_status_id) IS NOT NULL)THEN
2817: l_onhand_status_enabled := 1;
2818: l_default_org_status_id := inv_cache.org_rec.default_status_id ;
2819: l_serial_controlled := 0;
2820: IF (l_debug = 1) THEN

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

2814:
2815: IF(inv_cache.set_org_rec(v_lpn_content.organization_id))THEN
2816: IF((inv_cache.org_rec.default_status_id) IS NOT NULL)THEN
2817: l_onhand_status_enabled := 1;
2818: l_default_org_status_id := inv_cache.org_rec.default_status_id ;
2819: l_serial_controlled := 0;
2820: IF (l_debug = 1) THEN
2821: trace('Org is onhand status enabled');
2822: END IF;

Line 2832: IF inv_cache.set_item_rec(v_lpn_content.organization_id, v_lpn_content.inventory_item_id) THEN

2828: END IF;
2829:
2830: IF (l_onhand_status_enabled = 1 )THEN
2831: l_item_info.lot_number_status := NULL;
2832: IF inv_cache.set_item_rec(v_lpn_content.organization_id, v_lpn_content.inventory_item_id) THEN
2833: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2834: l_serial_controlled := 1; -- Item is serial controlled
2835: IF (l_debug = 1) THEN
2836: trace('Item is seiarl controlled so not consedring on hand status');

Line 2833: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN

2829:
2830: IF (l_onhand_status_enabled = 1 )THEN
2831: l_item_info.lot_number_status := NULL;
2832: IF inv_cache.set_item_rec(v_lpn_content.organization_id, v_lpn_content.inventory_item_id) THEN
2833: IF (inv_cache.item_rec.serial_number_control_code in (2,5)) THEN
2834: l_serial_controlled := 1; -- Item is serial controlled
2835: IF (l_debug = 1) THEN
2836: trace('Item is seiarl controlled so not consedring on hand status');
2837: END IF;