2285:
2286: l_fl_ctr := nvl(l_fl_forecast_line_id_tab.last+1,1);
2287: l_stage := 6300;
2288: -- hr_utility.trace(to_char(l_stage));
2289: SELECT pa_org_forecast_lines_s.NEXTVAL
2290: INTO l_fl_new_seq
2291: FROM DUAL;
2292:
2293: l_stage := 6400;
2363:
2364: l_stage := 6600;
2365: -- hr_utility.trace(to_char(l_stage));
2366: l_fl_ctr := nvl(l_fl_forecast_line_id_tab.last+1,1);
2367: SELECT pa_org_forecast_lines_s.NEXTVAL
2368: INTO l_fl_new_seq
2369: FROM DUAL;
2370: l_stage := 6700;
2371: -- hr_utility.trace(to_char(l_stage));