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 791: and user_id = fnd_global.user_id

787: cursor c_pref_id is
788: select preference_id
789: from msc_user_preferences
790: where default_flag =1
791: and user_id = fnd_global.user_id
792: and nvl(plan_type,-1) = p_plan_type;
793:
794: begin
795: open c_pref_id;

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

795: open c_pref_id;
796: fetch c_pref_id into l_def_pref_id;
797: close c_pref_id;
798: if (l_def_pref_id is null) then
799: l_def_pref_id := msc_get_name.get_default_pref_id(fnd_global.user_id);
800: end if;
801:
802: l_pref_value:= msc_get_name.get_preference(p_preference,l_def_pref_id, p_plan_type);
803: return l_pref_value;

Line 1051: and userid= fnd_global.user_id

1047: cursor c_userpref_cur is
1048: select name, key, nvl(value, c_null_space) value
1049: from msc_analyze_preference
1050: where module = c_sda_pref_set
1051: and userid= fnd_global.user_id
1052: order by name, key;
1053:
1054: l_one_record varchar2(32000);
1055: l_out_data_index number := 1;

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

1385: else
1386: insert into msc_analyze_preference
1387: (userid, name, module, key, value, defaultset, public_flag,
1388: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1389: values (fnd_global.user_id, p_folder_name, c_sda_save_item_folder, c_sda_save_item_folder, p_folder_value,
1390: to_char(l_default_flag), l_public_flag,
1391: sysdate, -1, sysdate, -1, -1);
1392: end if;
1393: commit;

Line 1403: and userid = fnd_global.user_id;

1399: cursor c_count (p_module_name varchar2) is
1400: select count(*)
1401: from msc_analyze_preference
1402: where module = p_module_name
1403: and userid = fnd_global.user_id;
1404: l_temp number;
1405:
1406: begin
1407: commit;

Line 1417: and userid = fnd_global.user_id;

1413:
1414: if (l_temp <> 0) then
1415: delete from msc_analyze_preference
1416: where module = c_sda_save_item_folder
1417: and userid = fnd_global.user_id;
1418: end if;
1419:
1420: insert into msc_analyze_preference
1421: (userid, name, module, key, value, defaultset,

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

1419:
1420: insert into msc_analyze_preference
1421: (userid, name, module, key, value, defaultset,
1422: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1423: values (fnd_global.user_id, c_sda_save_item_folder, c_sda_save_item_folder, c_sda_save_item_folder, p_event_list, 'N',
1424: sysdate, -1, sysdate, -1, -1);
1425: end if;
1426: */
1427:

Line 1436: and userid = fnd_global.user_id;

1432:
1433: if (l_temp <> 0) then
1434: delete from msc_analyze_preference
1435: where module = c_sda_save_settings
1436: and userid = fnd_global.user_id;
1437: end if;
1438:
1439: insert into msc_analyze_preference
1440: (userid, name, module, key, value, defaultset,

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

1438:
1439: insert into msc_analyze_preference
1440: (userid, name, module, key, value, defaultset,
1441: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1442: values (fnd_global.user_id, c_sda_save_settings, c_sda_save_settings, c_sda_save_settings, p_event_list, 'N',
1443: sysdate, -1, sysdate, -1, -1);
1444: end if;
1445: commit;
1446: end update_close_settings;

Line 1455: and userid = fnd_global.user_id;

1451: cursor c_pref (p_module_name varchar2) is
1452: select value
1453: from msc_analyze_preference
1454: where module = p_module_name
1455: and userid = fnd_global.user_id;
1456: begin
1457: open c_pref(c_sda_save_item_folder);
1458: fetch c_pref into p_item_folder_save_list;
1459: close c_pref;

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

1490: if (l_temp = 0) then
1491: insert into msc_analyze_preference
1492: (userid, name, module, key, value, defaultset,
1493: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1494: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_days, p_days, 'N',
1495: sysdate, -1, sysdate, -1, -1);
1496:
1497: insert into msc_analyze_preference
1498: (userid, name, module, key, value, defaultset,

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

1496:
1497: insert into msc_analyze_preference
1498: (userid, name, module, key, value, defaultset,
1499: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1500: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_weeks, p_weeks, 'N',
1501: sysdate, -1, sysdate, -1, -1);
1502:
1503: insert into msc_analyze_preference
1504: (userid, name, module, key, value, defaultset,

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

1502:
1503: insert into msc_analyze_preference
1504: (userid, name, module, key, value, defaultset,
1505: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1506: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_periods, p_periods, 'N',
1507: sysdate, -1, sysdate, -1, -1);
1508:
1509: insert into msc_analyze_preference
1510: (userid, name, module, key, value, defaultset,

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

1508:
1509: insert into msc_analyze_preference
1510: (userid, name, module, key, value, defaultset,
1511: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1512: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_factor, p_factor, 'N',
1513: sysdate, -1, sysdate, -1, -1);
1514:
1515: insert into msc_analyze_preference
1516: (userid, name, module, key, value, defaultset,

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

1514:
1515: insert into msc_analyze_preference
1516: (userid, name, module, key, value, defaultset,
1517: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1518: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_decimals, p_decimal_places, 'N',
1519: sysdate, -1, sysdate, -1, -1);
1520:
1521: insert into msc_analyze_preference
1522: (userid, name, module, key, value, defaultset,

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

1520:
1521: insert into msc_analyze_preference
1522: (userid, name, module, key, value, defaultset,
1523: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1524: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_sd, p_sd_row_list, 'N',
1525: sysdate, -1, sysdate, -1, -1);
1526:
1527: insert into msc_analyze_preference
1528: (userid, name, module, key, value, defaultset,

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

1526:
1527: insert into msc_analyze_preference
1528: (userid, name, module, key, value, defaultset,
1529: last_update_date, last_updated_by, creation_date, created_by, last_update_login)
1530: values (fnd_global.user_id, p_name, c_sda_pref_set, c_keys_fcst, p_fcst_row_list, 'N',
1531: sysdate, -1, sysdate, -1, -1);
1532: else
1533: update msc_analyze_preference
1534: set value = p_days