1271: SELECT 1
1272: FROM dual
1273: WHERE g_resource_class_flag = 'N' ;
1274:
1275: l_res_list_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1276: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
1277: l_format NUMBER;
1278: l_eff_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1279: l_res_prec_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1274:
1275: l_res_list_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1276: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
1277: l_format NUMBER;
1278: l_eff_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1279: l_res_prec_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1280: l_eff_res_class_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- added for cbs project
1281:
1282: l_SQL_statement VARCHAR2 (2000);
1275: l_res_list_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1276: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
1277: l_format NUMBER;
1278: l_eff_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1279: l_res_prec_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1280: l_eff_res_class_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- added for cbs project
1281:
1282: l_SQL_statement VARCHAR2 (2000);
1283:
1276: l_res_class_formats PA_RESOURCE_PREC_PUB.plan_res_formats;
1277: l_format NUMBER;
1278: l_eff_formats SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1279: l_res_prec_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1280: l_eff_res_class_id SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(); -- added for cbs project
1281:
1282: l_SQL_statement VARCHAR2 (2000);
1283:
1284: l_run_number NUMBER := 0;