APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on MSC_GET_NAME

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

237: FND_MESSAGE.GET_STRING('MRP', 'MRP_REL_ALL_IN_SOURCE_PLAN');
238: end if;
239: end if; -- if p_in_source_plan = 1 then
240:
241: if p_action = msc_get_name.lookup_meaning('MRP_ACTIONS',6) then -- None
242: if (p_plan_type = 8 and p_order_type = 51) then
243: null;
244: else
245: p_rel_error := p_rel_error ||' '||

Line 391: p_load_type := msc_get_name.load_type(

387: and plan_id = p_plan_id;
388:
389: END IF; -- IF p_impl_as = 3 then
390:
391: p_load_type := msc_get_name.load_type(
392: p_plan_type,
393: p_plan_id,
394: 'MSC_SUPPLIES',
395: p_transaction_id,

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

646: 'task_id, ' ||
647: 'unit_number, ' ||
648: 'lots_exist, '||
649: 'quantity_rate '||
650: ' from '||msc_get_name.get_order_view(p_plan_type, p_plan_id) ||
651: ' where ' || p_where_clause ||
652: ' and order_type IN (1, 2, 3, 5, 13, 51, 53, 76,77,78)'||
653: ' and source_table = ''MSC_SUPPLIES''' ||
654: ' and nvl(release_time_fence_code,-1) <> 7' ||

Line 677: p_def_job_status:= msc_get_name.GET_preference(

673: fetch plan_type_c into p_plan_type;
674: close plan_type_c;
675: end if;
676: if p_def_job_status is null then
677: p_def_job_status:= msc_get_name.GET_preference(
678: 'ORDERS_DEFAULT_JOB_STATUS',
679: msc_get_name.get_default_pref_id(fnd_global.user_id),
680: p_plan_type);
681: p_def_job_status := nvl(p_def_job_status, 1);

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

675: end if;
676: if p_def_job_status is null then
677: p_def_job_status:= msc_get_name.GET_preference(
678: 'ORDERS_DEFAULT_JOB_STATUS',
679: msc_get_name.get_default_pref_id(fnd_global.user_id),
680: p_plan_type);
681: p_def_job_status := nvl(p_def_job_status, 1);
682: p_wip_class_code := msc_get_name.GET_preference(
683: 'ORDERS_JOB_CLASS_CODE',

Line 682: p_wip_class_code := msc_get_name.GET_preference(

678: 'ORDERS_DEFAULT_JOB_STATUS',
679: msc_get_name.get_default_pref_id(fnd_global.user_id),
680: p_plan_type);
681: p_def_job_status := nvl(p_def_job_status, 1);
682: p_wip_class_code := msc_get_name.GET_preference(
683: 'ORDERS_JOB_CLASS_CODE',
684: msc_get_name.get_default_pref_id(fnd_global.user_id),
685: p_plan_type);
686: end if;

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

680: p_plan_type);
681: p_def_job_status := nvl(p_def_job_status, 1);
682: p_wip_class_code := msc_get_name.GET_preference(
683: 'ORDERS_JOB_CLASS_CODE',
684: msc_get_name.get_default_pref_id(fnd_global.user_id),
685: p_plan_type);
686: end if;
687:
688: verify_release_error;