13596: END IF;
13597:
13598: FOR i IN c_all_items(l_org_id)
13599: LOOP
13600: IF ( inv_cache.set_item_rec(l_org_id,i.inventory_item_id)) THEN
13601: l_lot_control_code := inv_cache.item_rec.lot_control_code ;
13602: IF (l_lot_control_code = 2 )THEN
13603: l_progress := '5';
13604: IF (l_debug = 1) THEN
13597:
13598: FOR i IN c_all_items(l_org_id)
13599: LOOP
13600: IF ( inv_cache.set_item_rec(l_org_id,i.inventory_item_id)) THEN
13601: l_lot_control_code := inv_cache.item_rec.lot_control_code ;
13602: IF (l_lot_control_code = 2 )THEN
13603: l_progress := '5';
13604: IF (l_debug = 1) THEN
13605: DEBUG(' inside loop for lpn => '||p_lpn_id , 4);