eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_SDA_UTILS dependencies on FND_GLOBAL

Line 1231: and user_id = fnd_global.user_id

1227: cursor c_pref_id is
1228: select preference_id
1229: from msc_user_preferences
1230: where default_flag =1
1231: and user_id = fnd_global.user_id
1232: and nvl(plan_type,-1) = p_plan_type;
1233:
1234: begin
1235: open c_pref_id;

Line 1239: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);

1235: open c_pref_id;
1236: fetch c_pref_id into l_def_pref_id;
1237: close c_pref_id;
1238: if (l_def_pref_id is null) then
1239: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
1240: end if;
1241:
1242: l_pref_value:= msc_get_name.get_preference(p_preference,l_def_pref_id, p_plan_type);
1243: return l_pref_value;

Line 1509: and userid= fnd_global.user_id

1505: cursor c_userpref_cur is
1506: select name, key, nvl(value, c_null_space) value
1507: from msc_analyze_preference
1508: where module = c_sda_pref_set
1509: and userid= fnd_global.user_id
1510: order by name, key;
1511:
1512: l_one_record varchar2(32000);
1513: l_out_data_index number := 1;

Line 1852: values (fnd_global.user_id, p_folder_name, c_sda_save_item_folder, c_sda_save_item_folder, p_folder_value,

1848: else
1849: insert into msc_analyze_preference
1850: (userid, name, module, key, value, defaultset, public_flag,
1851: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1852: values (fnd_global.user_id, p_folder_name, c_sda_save_item_folder, c_sda_save_item_folder, p_folder_value,
1853: to_char(l_default_flag), l_public_flag,
1854: sysdate, -1, sysdate, -1, -1);
1855: end if;
1856: commit;

Line 1866: and userid = fnd_global.user_id;

1862: cursor c_count (p_module_name varchar2) is
1863: select count(*)
1864: from msc_analyze_preference
1865: where module = p_module_name
1866: and userid = fnd_global.user_id;
1867: l_temp number;
1868:
1869: begin
1870: commit;

Line 1880: and userid = fnd_global.user_id;

1876:
1877: if (l_temp <> 0) then
1878: delete from msc_analyze_preference
1879: where module = c_sda_save_item_folder
1880: and userid = fnd_global.user_id;
1881: end if;
1882:
1883: insert into msc_analyze_preference
1884: (userid, name, module, key, value, defaultset,

Line 1886: values (fnd_global.user_id, c_sda_save_item_folder, c_sda_save_item_folder, c_sda_save_item_folder, p_event_list, 'N',

1882:
1883: insert into msc_analyze_preference
1884: (userid, name, module, key, value, defaultset,
1885: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1886: values (fnd_global.user_id, c_sda_save_item_folder, c_sda_save_item_folder, c_sda_save_item_folder, p_event_list, 'N',
1887: sysdate, -1, sysdate, -1, -1);
1888: end if;
1889: */
1890:

Line 1899: and userid = fnd_global.user_id;

1895:
1896: if (l_temp <> 0) then
1897: delete from msc_analyze_preference
1898: where module = c_sda_save_settings
1899: and userid = fnd_global.user_id;
1900: end if;
1901:
1902: insert into msc_analyze_preference
1903: (userid, name, module, key, value, defaultset,

Line 1905: values (fnd_global.user_id, c_sda_save_settings, c_sda_save_settings, c_sda_save_settings, p_event_list, 'N',

1901:
1902: insert into msc_analyze_preference
1903: (userid, name, module, key, value, defaultset,
1904: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1905: values (fnd_global.user_id, c_sda_save_settings, c_sda_save_settings, c_sda_save_settings, p_event_list, 'N',
1906: sysdate, -1, sysdate, -1, -1);
1907: end if;
1908: commit;
1909: end update_close_settings;

Line 1918: and userid = fnd_global.user_id;

1914: cursor c_pref (p_module_name varchar2) is
1915: select value
1916: from msc_analyze_preference
1917: where module = p_module_name
1918: and userid = fnd_global.user_id;
1919: begin
1920: open c_pref(c_sda_save_item_folder);
1921: fetch c_pref into p_item_folder_save_list;
1922: close c_pref;

Line 1957: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_days, p_days, 'N',

1953: if (l_temp = 0) then
1954: insert into msc_analyze_preference
1955: (userid, name, module, key, value, defaultset,
1956: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1957: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_days, p_days, 'N',
1958: sysdate, -1, sysdate, -1, -1);
1959:
1960: insert into msc_analyze_preference
1961: (userid, name, module, key, value, defaultset,

Line 1963: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_weeks, p_weeks, 'N',

1959:
1960: insert into msc_analyze_preference
1961: (userid, name, module, key, value, defaultset,
1962: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1963: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_weeks, p_weeks, 'N',
1964: sysdate, -1, sysdate, -1, -1);
1965:
1966: insert into msc_analyze_preference
1967: (userid, name, module, key, value, defaultset,

Line 1969: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_periods, p_periods, 'N',

1965:
1966: insert into msc_analyze_preference
1967: (userid, name, module, key, value, defaultset,
1968: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1969: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_periods, p_periods, 'N',
1970: sysdate, -1, sysdate, -1, -1);
1971:
1972: insert into msc_analyze_preference
1973: (userid, name, module, key, value, defaultset,

Line 1975: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_factor, p_factor, 'N',

1971:
1972: insert into msc_analyze_preference
1973: (userid, name, module, key, value, defaultset,
1974: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1975: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_factor, p_factor, 'N',
1976: sysdate, -1, sysdate, -1, -1);
1977:
1978: insert into msc_analyze_preference
1979: (userid, name, module, key, value, defaultset,

Line 1981: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_decimals, p_decimal_places, 'N',

1977:
1978: insert into msc_analyze_preference
1979: (userid, name, module, key, value, defaultset,
1980: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1981: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_decimals, p_decimal_places, 'N',
1982: sysdate, -1, sysdate, -1, -1);
1983:
1984: insert into msc_analyze_preference
1985: (userid, name, module, key, value, defaultset,

Line 1987: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_sd, p_sd_row_list, 'N',

1983:
1984: insert into msc_analyze_preference
1985: (userid, name, module, key, value, defaultset,
1986: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1987: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_sd, p_sd_row_list, 'N',
1988: sysdate, -1, sysdate, -1, -1);
1989:
1990: insert into msc_analyze_preference
1991: (userid, name, module, key, value, defaultset,

Line 1993: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_fcst, p_fcst_row_list, 'N',

1989:
1990: insert into msc_analyze_preference
1991: (userid, name, module, key, value, defaultset,
1992: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1993: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_fcst, p_fcst_row_list, 'N',
1994: sysdate, -1, sysdate, -1, -1);
1995: else
1996: update msc_analyze_preference
1997: set value = p_days