1047: var_entity := 'WIP Job Status';
1048: open Plan_type_c(var_plan_id);
1049: fetch plan_type_c into l_plan_type;
1050: close plan_type_c;
1051: l_def_pref_id := msc_get_name.get_default_pref_id(var_user_id);
1052: var_impl_status_code:= msc_get_name.GET_preference('ORDERS_DEFAULT_JOB_STATUS', l_def_pref_id, l_plan_type);
1053: var_wip_class_code:= msc_get_name.GET_preference('JOB_CLASS_CODE', l_def_pref_id, l_plan_type);
1054: var_firm_jobs:= msc_get_name.GET_preference('ORDERS_FIRM_JOBS', l_def_pref_id, l_plan_type);
1055: /*
1048: open Plan_type_c(var_plan_id);
1049: fetch plan_type_c into l_plan_type;
1050: close plan_type_c;
1051: l_def_pref_id := msc_get_name.get_default_pref_id(var_user_id);
1052: var_impl_status_code:= msc_get_name.GET_preference('ORDERS_DEFAULT_JOB_STATUS', l_def_pref_id, l_plan_type);
1053: var_wip_class_code:= msc_get_name.GET_preference('JOB_CLASS_CODE', l_def_pref_id, l_plan_type);
1054: var_firm_jobs:= msc_get_name.GET_preference('ORDERS_FIRM_JOBS', l_def_pref_id, l_plan_type);
1055: /*
1056: OPEN job_status;
1049: fetch plan_type_c into l_plan_type;
1050: close plan_type_c;
1051: l_def_pref_id := msc_get_name.get_default_pref_id(var_user_id);
1052: var_impl_status_code:= msc_get_name.GET_preference('ORDERS_DEFAULT_JOB_STATUS', l_def_pref_id, l_plan_type);
1053: var_wip_class_code:= msc_get_name.GET_preference('JOB_CLASS_CODE', l_def_pref_id, l_plan_type);
1054: var_firm_jobs:= msc_get_name.GET_preference('ORDERS_FIRM_JOBS', l_def_pref_id, l_plan_type);
1055: /*
1056: OPEN job_status;
1057: FETCH job_status INTO var_impl_status_code, var_wip_class_code,
1050: close plan_type_c;
1051: l_def_pref_id := msc_get_name.get_default_pref_id(var_user_id);
1052: var_impl_status_code:= msc_get_name.GET_preference('ORDERS_DEFAULT_JOB_STATUS', l_def_pref_id, l_plan_type);
1053: var_wip_class_code:= msc_get_name.GET_preference('JOB_CLASS_CODE', l_def_pref_id, l_plan_type);
1054: var_firm_jobs:= msc_get_name.GET_preference('ORDERS_FIRM_JOBS', l_def_pref_id, l_plan_type);
1055: /*
1056: OPEN job_status;
1057: FETCH job_status INTO var_impl_status_code, var_wip_class_code,
1058: var_firm_jobs;