APPS.MSC_GET_NAME dependencies on FND_GLOBAL

Line 1451: --WHERE user_id = fnd_global.user_id;

1447: --CURSOR OPTIONS_C IS
1448: --SELECT NVL(orders_release_configs,'N'),
1449: -- NVL(orders_release_phantoms,'N')
1450: --FROM msc_workbench_display_options
1451: --WHERE user_id = fnd_global.user_id;
1452:
1453: CURSOR internal_sales(p_plan_id number,
1454: p_tran_id number, p_inst_id number) IS
1455: select ms.disposition_status_type,

Line 1608: l_pref_id := get_default_pref_id(fnd_global.user_id,l_plan_type);

1604: END IF;
1605:
1606: IF arg_base_item_id IS NOT NULL
1607: OR arg_wip_supply_type = 6 THEN
1608: l_pref_id := get_default_pref_id(fnd_global.user_id,l_plan_type);
1609: l_configs := GET_preference('ORDERS_RELEASE_CONFIGS',
1610: l_pref_id,
1611: l_plan_type );
1612: l_phantoms := GET_preference('ORDERS_RELEASE_PHANTOMS',

Line 4800: l_pref_id := get_default_pref_id(fnd_global.user_id,p_plan_type);

4796: p_plan_type in number) return varchar2 is
4797: l_value varchar2(300);
4798: l_pref_id number;
4799: begin
4800: l_pref_id := get_default_pref_id(fnd_global.user_id,p_plan_type);
4801: l_value := GET_preference(p_key,
4802: l_pref_id,
4803: p_plan_type );
4804: return l_value;

Line 5830: --WHERE user_id = fnd_global.user_id;

5826: --CURSOR OPTIONS_C IS
5827: --SELECT NVL(orders_release_configs,'N'),
5828: -- NVL(orders_release_phantoms,'N')
5829: --FROM msc_workbench_display_options
5830: --WHERE user_id = fnd_global.user_id;
5831:
5832: CURSOR internal_sales(p_plan_id number,
5833: p_tran_id number, p_inst_id number) IS
5834: select ms.disposition_status_type,

Line 5925: l_pref_id := get_default_pref_id(fnd_global.user_id,l_plan_type);

5921: if (l_plan_type in (101,102,103,104,105)) then -- RP Plan bug 9478924
5922: l_configs:='Y';
5923: l_phantoms := 'N';
5924: else
5925: l_pref_id := get_default_pref_id(fnd_global.user_id,l_plan_type);
5926: l_configs := GET_preference('ORDERS_RELEASE_CONFIGS',
5927: l_pref_id,
5928: l_plan_type );
5929: