You got some kind of compilation error in the script, thats the reason you are facing this problem.

You have two problems in the script.

The first problem (see listing below) is that "Start With" is missing a comparison. For instance: start with manager = 'Greg.'
FOR inner_loop IN ( SELECT DISTINCT subord
FROM stsc.bom
START WITH skudc_planorder_cursor.item
CONNECT BY PRIOR subord = skudc_planorder_cursor.item

The second problem (see listing below) is that you are using the variable "inner_loop.subord" as a loop index variable. This is not allowed for an IF statement:
IF inner_loop.subord IN ( SELECT item FROM stsc.item
WHERE scen = 0
AND item.product_type IN
( SELECT param2
FROM springs.si_jde_user_proc_params
WHERE UPPER(TRIM(key1)) = 'ADJPLANLT'
AND UPPER(TRIM(key2)) = 'OVERRIDE'
AND TRIM(key3) IS NULL)
) THEN
n_count_subords := n_count_subords + 1;
END IF;