APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on FND_GLOBAL

Line 531: last_updated_by = fnd_global.user_id,

527: nvl(implement_unit_number,unit_number), null),
528: load_type = p_load_type,
529: status = 0,
530: applied = 2,
531: last_updated_by = fnd_global.user_id,
532: implement_status_code =
533: -- bug 4410222, For cancelled discrete jobs, set implement_status_code to 7
534: decode(order_type, 3,
535: decode(disposition_status_type,2, 7,

Line 601: last_updated_by = fnd_global.user_id

597: release_status = 1,
598: implement_as =4,
599: status = 0,
600: applied = 2,
601: last_updated_by = fnd_global.user_id
602: where transaction_id = p_transaction_id
603: and plan_id = p_plan_id;
604:
605: END IF; --IF p_order_type in (1, 2, 3, 5, 51, 53)

Line 663: last_updated_by = fnd_global.user_id,

659: reschedule_flag = 1,
660: release_status = 1,
661: status = 0,
662: applied =2,
663: last_updated_by = fnd_global.user_id,
664: release_errors = NULL
665: where plan_id = p_plan_id
666: and demand_id = p_transaction_id
667: and sr_instance_id = p_inst_id;

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 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;