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 MSC_ANALYZE_PREFERENCE

Line 1507: from msc_analyze_preference

1503:
1504: procedure getWorkSheetPrefData(p_out_data in out nocopy maxCharTbl, p_refresh_flag number) is
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:

Line 1827: from msc_analyze_preference

1823: procedure save_item_folder(p_folder_name varchar, p_folder_value varchar, p_default_flag number, p_public_flag number) is
1824: pragma autonomous_transaction;
1825: cursor c_count (p_module_name varchar2, p_name varchar) is
1826: select count(*)
1827: from msc_analyze_preference
1828: where module = p_module_name
1829: and name = p_name;
1830:
1831: l_temp number;

Line 1842: update msc_analyze_preference

1838: fetch c_count into l_temp;
1839: close c_count;
1840:
1841: if (l_temp <> 0) then
1842: update msc_analyze_preference
1843: set defaultset = to_char(l_default_flag),
1844: public_flag = l_public_flag,
1845: value = p_folder_value
1846: where name = p_folder_name

Line 1849: insert into msc_analyze_preference

1845: value = p_folder_value
1846: where name = p_folder_name
1847: and module = c_sda_save_item_folder;
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,

Line 1864: from msc_analyze_preference

1860: pragma autonomous_transaction;
1861:
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:

Line 1878: delete from msc_analyze_preference

1874: fetch c_count into l_temp;
1875: close c_count;
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:

Line 1883: insert into 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,
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);

Line 1897: delete from msc_analyze_preference

1893: fetch c_count into l_temp;
1894: close c_count;
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:

Line 1902: insert into 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,
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);

Line 1916: from msc_analyze_preference

1912: p_save_settings_list out nocopy varchar2) is
1913:
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);

Line 1943: from msc_analyze_preference

1939: pragma autonomous_transaction;
1940:
1941: cursor c_count is
1942: select count(*)
1943: from msc_analyze_preference
1944: where module = c_sda_pref_set
1945: and name = p_name;
1946: l_temp number;
1947: begin

Line 1954: insert into msc_analyze_preference

1950: fetch c_count into l_temp;
1951: close c_count;
1952:
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);

Line 1960: insert into msc_analyze_preference

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

Line 1966: insert into msc_analyze_preference

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

Line 1972: insert into msc_analyze_preference

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

Line 1978: insert into msc_analyze_preference

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

Line 1984: insert into msc_analyze_preference

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

Line 1990: insert into msc_analyze_preference

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

Line 1996: update msc_analyze_preference

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
1998: where module = c_sda_pref_set and name = p_name and key = c_keys_days;
1999:
2000: update msc_analyze_preference

Line 2000: update msc_analyze_preference

1996: update msc_analyze_preference
1997: set value = p_days
1998: where module = c_sda_pref_set and name = p_name and key = c_keys_days;
1999:
2000: update msc_analyze_preference
2001: set value = p_weeks
2002: where module = c_sda_pref_set and name = p_name and key = c_keys_weeks;
2003:
2004: update msc_analyze_preference

Line 2004: update msc_analyze_preference

2000: update msc_analyze_preference
2001: set value = p_weeks
2002: where module = c_sda_pref_set and name = p_name and key = c_keys_weeks;
2003:
2004: update msc_analyze_preference
2005: set value = p_periods
2006: where module = c_sda_pref_set and name = p_name and key = c_keys_periods;
2007:
2008: update msc_analyze_preference

Line 2008: update msc_analyze_preference

2004: update msc_analyze_preference
2005: set value = p_periods
2006: where module = c_sda_pref_set and name = p_name and key = c_keys_periods;
2007:
2008: update msc_analyze_preference
2009: set value = p_factor
2010: where module = c_sda_pref_set and name = p_name and key = c_keys_factor;
2011:
2012: update msc_analyze_preference

Line 2012: update msc_analyze_preference

2008: update msc_analyze_preference
2009: set value = p_factor
2010: where module = c_sda_pref_set and name = p_name and key = c_keys_factor;
2011:
2012: update msc_analyze_preference
2013: set value = p_decimal_places
2014: where module = c_sda_pref_set and name = p_name and key = c_keys_decimals;
2015:
2016: update msc_analyze_preference

Line 2016: update msc_analyze_preference

2012: update msc_analyze_preference
2013: set value = p_decimal_places
2014: where module = c_sda_pref_set and name = p_name and key = c_keys_decimals;
2015:
2016: update msc_analyze_preference
2017: set value = p_sd_row_list
2018: where module = c_sda_pref_set and name = p_name and key = c_keys_sd;
2019:
2020: update msc_analyze_preference

Line 2020: update msc_analyze_preference

2016: update msc_analyze_preference
2017: set value = p_sd_row_list
2018: where module = c_sda_pref_set and name = p_name and key = c_keys_sd;
2019:
2020: update msc_analyze_preference
2021: set value = p_fcst_row_list
2022: where module = c_sda_pref_set and name = p_name and key = c_keys_fcst;
2023: end if;
2024: commit;