[Home] [Help]
1333: v_slc_type,
1334: v_part_code,
1335: v_num_procs,
1336: v_fetch_limit
1337: FROM fem_mp_process_options
1338: WHERE object_type_code = v_obj_type
1339: AND step_name = p_eng_step
1340: AND object_id = p_rule_id;
1341: EXCEPTION
1352: v_slc_type,
1353: v_part_code,
1354: v_num_procs,
1355: v_fetch_limit
1356: FROM fem_mp_process_options
1357: WHERE object_type_code = v_obj_type
1358: AND step_name = 'ALL'
1359: AND object_id = p_rule_id;
1360: EXCEPTION
1371: v_slc_type,
1372: v_part_code,
1373: v_num_procs,
1374: v_fetch_limit
1375: FROM fem_mp_process_options
1376: WHERE object_type_code = v_obj_type
1377: AND step_name = p_eng_step
1378: AND object_id IS NULL;
1379: EXCEPTION
1390: v_slc_type,
1391: v_part_code,
1392: v_num_procs,
1393: v_fetch_limit
1394: FROM fem_mp_process_options P
1395: WHERE object_type_code = v_obj_type
1396: AND step_name = 'ALL'
1397: AND object_id IS NULL;
1398: EXCEPTION