APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_GET_NAME

Line 309: if p_action = msc_get_name.lookup_meaning('MRP_ACTIONS',6) then -- None

305: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_IN_SOURCE_PLAN');
306: end if;
307: end if; -- if p_in_source_plan = 1 then
308:
309: if p_action = msc_get_name.lookup_meaning('MRP_ACTIONS',6) then -- None
310: if (p_plan_type = 8 and p_order_type = 51) then
311: null;
312: else
313: p_rel_error := p_rel_error ||' '||

Line 464: p_load_type := msc_get_name.load_type(

460: and plan_id = p_plan_id;
461:
462: END IF; -- IF p_impl_as = 3 then
463:
464: p_load_type := msc_get_name.load_type(
465: p_plan_type,
466: p_plan_id,
467: 'MSC_SUPPLIES',
468: p_transaction_id,

Line 732: ' from '||msc_get_name.get_order_view(p_plan_type, p_plan_id) ||

728: 'quantity_rate , '||
729: ' source_table ,'||
730: ' null, '|| -- dest_inst_id in DRP plan
731: ' null ' || -- dest_org_id in DRP plan
732: ' from '||msc_get_name.get_order_view(p_plan_type, p_plan_id) ||
733: ' where ' || p_where_clause ||
734: ' and order_type IN (1, 2, 3, 5, 13, 51, 53, 76,77,78)'||
735: ' and source_table = ''MSC_SUPPLIES''' ||
736: ' and nvl(release_time_fence_code,-1) <> 7 ' ||

Line 817: p_def_job_status:= msc_get_name.GET_preference(

813: fetch plan_type_c into p_plan_type;
814: close plan_type_c;
815: end if;
816: if p_def_job_status is null then
817: p_def_job_status:= msc_get_name.GET_preference(
818: 'ORDERS_DEFAULT_JOB_STATUS',
819: msc_get_name.get_default_pref_id(fnd_global.user_id),
820: p_plan_type);
821: p_def_job_status := nvl(p_def_job_status, 1);

Line 819: msc_get_name.get_default_pref_id(fnd_global.user_id),

815: end if;
816: if p_def_job_status is null then
817: p_def_job_status:= msc_get_name.GET_preference(
818: 'ORDERS_DEFAULT_JOB_STATUS',
819: msc_get_name.get_default_pref_id(fnd_global.user_id),
820: p_plan_type);
821: p_def_job_status := nvl(p_def_job_status, 1);
822: p_wip_class_code := msc_get_name.GET_preference(
823: 'ORDERS_JOB_CLASS_CODE',

Line 822: p_wip_class_code := msc_get_name.GET_preference(

818: 'ORDERS_DEFAULT_JOB_STATUS',
819: msc_get_name.get_default_pref_id(fnd_global.user_id),
820: p_plan_type);
821: p_def_job_status := nvl(p_def_job_status, 1);
822: p_wip_class_code := msc_get_name.GET_preference(
823: 'ORDERS_JOB_CLASS_CODE',
824: msc_get_name.get_default_pref_id(fnd_global.user_id),
825: p_plan_type);
826: end if;

Line 824: msc_get_name.get_default_pref_id(fnd_global.user_id),

820: p_plan_type);
821: p_def_job_status := nvl(p_def_job_status, 1);
822: p_wip_class_code := msc_get_name.GET_preference(
823: 'ORDERS_JOB_CLASS_CODE',
824: msc_get_name.get_default_pref_id(fnd_global.user_id),
825: p_plan_type);
826: end if;
827:
828: verify_release_error;