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 1049: from msc_analyze_preference

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

Line 1364: from msc_analyze_preference

1360: procedure save_item_folder(p_folder_name varchar, p_folder_value varchar, p_default_flag number, p_public_flag number) is
1361: pragma autonomous_transaction;
1362: cursor c_count (p_module_name varchar2, p_name varchar) is
1363: select count(*)
1364: from msc_analyze_preference
1365: where module = p_module_name
1366: and name = p_name;
1367:
1368: l_temp number;

Line 1379: update msc_analyze_preference

1375: fetch c_count into l_temp;
1376: close c_count;
1377:
1378: if (l_temp <> 0) then
1379: update msc_analyze_preference
1380: set defaultset = to_char(l_default_flag),
1381: public_flag = l_public_flag,
1382: value = p_folder_value
1383: where name = p_folder_name

Line 1386: insert into msc_analyze_preference

1382: value = p_folder_value
1383: where name = p_folder_name
1384: and module = c_sda_save_item_folder;
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,

Line 1401: from msc_analyze_preference

1397: pragma autonomous_transaction;
1398:
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:

Line 1415: delete from msc_analyze_preference

1411: fetch c_count into l_temp;
1412: close c_count;
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:

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

Line 1434: delete from msc_analyze_preference

1430: fetch c_count into l_temp;
1431: close c_count;
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:

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

Line 1453: from msc_analyze_preference

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

Line 1480: from msc_analyze_preference

1476: pragma autonomous_transaction;
1477:
1478: cursor c_count is
1479: select count(*)
1480: from msc_analyze_preference
1481: where module = c_sda_pref_set
1482: and name = p_name;
1483: l_temp number;
1484: begin

Line 1491: insert into msc_analyze_preference

1487: fetch c_count into l_temp;
1488: close c_count;
1489:
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);

Line 1497: insert into msc_analyze_preference

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

Line 1503: insert into msc_analyze_preference

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

Line 1509: insert into msc_analyze_preference

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

Line 1515: insert into msc_analyze_preference

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

Line 1521: insert into msc_analyze_preference

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

Line 1527: insert into msc_analyze_preference

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

Line 1533: update msc_analyze_preference

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
1535: where module = c_sda_pref_set and name = p_name and key = c_keys_days;
1536:
1537: update msc_analyze_preference

Line 1537: update msc_analyze_preference

1533: update msc_analyze_preference
1534: set value = p_days
1535: where module = c_sda_pref_set and name = p_name and key = c_keys_days;
1536:
1537: update msc_analyze_preference
1538: set value = p_weeks
1539: where module = c_sda_pref_set and name = p_name and key = c_keys_weeks;
1540:
1541: update msc_analyze_preference

Line 1541: update msc_analyze_preference

1537: update msc_analyze_preference
1538: set value = p_weeks
1539: where module = c_sda_pref_set and name = p_name and key = c_keys_weeks;
1540:
1541: update msc_analyze_preference
1542: set value = p_periods
1543: where module = c_sda_pref_set and name = p_name and key = c_keys_periods;
1544:
1545: update msc_analyze_preference

Line 1545: update msc_analyze_preference

1541: update msc_analyze_preference
1542: set value = p_periods
1543: where module = c_sda_pref_set and name = p_name and key = c_keys_periods;
1544:
1545: update msc_analyze_preference
1546: set value = p_factor
1547: where module = c_sda_pref_set and name = p_name and key = c_keys_factor;
1548:
1549: update msc_analyze_preference

Line 1549: update msc_analyze_preference

1545: update msc_analyze_preference
1546: set value = p_factor
1547: where module = c_sda_pref_set and name = p_name and key = c_keys_factor;
1548:
1549: update msc_analyze_preference
1550: set value = p_decimal_places
1551: where module = c_sda_pref_set and name = p_name and key = c_keys_decimals;
1552:
1553: update msc_analyze_preference

Line 1553: update msc_analyze_preference

1549: update msc_analyze_preference
1550: set value = p_decimal_places
1551: where module = c_sda_pref_set and name = p_name and key = c_keys_decimals;
1552:
1553: update msc_analyze_preference
1554: set value = p_sd_row_list
1555: where module = c_sda_pref_set and name = p_name and key = c_keys_sd;
1556:
1557: update msc_analyze_preference

Line 1557: update msc_analyze_preference

1553: update msc_analyze_preference
1554: set value = p_sd_row_list
1555: where module = c_sda_pref_set and name = p_name and key = c_keys_sd;
1556:
1557: update msc_analyze_preference
1558: set value = p_fcst_row_list
1559: where module = c_sda_pref_set and name = p_name and key = c_keys_fcst;
1560: end if;
1561: commit;