APPS.MSC_SELECT_ALL_FOR_RELEASE_PUB dependencies on FND_GLOBAL

Line 458: last_updated_by = fnd_global.user_id,

454: nvl(implement_unit_number,unit_number), null),
455: load_type = p_load_type,
456: status = 0,
457: applied = 2,
458: last_updated_by = fnd_global.user_id,
459: implement_status_code =
460: -- bug 4410222, For cancelled discrete jobs, set implement_status_code to 7
461: decode(order_type, 3,
462: decode(disposition_status_type,2, 7,

Line 528: last_updated_by = fnd_global.user_id

524: release_status = 1,
525: implement_as =4,
526: status = 0,
527: applied = 2,
528: last_updated_by = fnd_global.user_id
529: where transaction_id = p_transaction_id
530: and plan_id = p_plan_id;
531:
532: END IF; --IF p_order_type in (1, 2, 3, 5, 51, 53)

Line 590: last_updated_by = fnd_global.user_id,

586: reschedule_flag = 1,
587: release_status = 1,
588: status = 0,
589: applied =2,
590: last_updated_by = fnd_global.user_id,
591: release_errors = NULL
592: where plan_id = p_plan_id
593: and demand_id = p_transaction_id
594: and sr_instance_id = p_inst_id;

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