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.CSM_NOTIFICATION_EVENT_PKG dependencies on FND_PROFILE

Line 24: select sysdate - fnd_profile.value('CSM_PURGE_INTERVAL') as DT from dual);

20: (SELECT nvl(last_run_date, (sysdate - 365*50)) as DT FROM jtm_con_request_data
21: WHERE package_name = 'CSM_NOTIFICATION_EVENT_PKG'
22: AND procedure_name = 'DOWNLOAD_MULTIPLAT_NFN'
23: UNION ALL
24: select sysdate - fnd_profile.value('CSM_PURGE_INTERVAL') as DT from dual);
25:
26: l_run_date date;
27: l_upd_date date;
28: l_sqlerrno varchar2(20);

Line 384: select profile_option_value from fnd_profile_option_values where profile_option_id in

380: AND procedure_name = 'PURGE_NOTIFICATION_CONC'
381: FOR UPDATE OF last_run_date NOWAIT;
382:
383: CURSOR c_purge_days IS
384: select profile_option_value from fnd_profile_option_values where profile_option_id in
385: (select profile_option_id from fnd_profile_options where profile_option_name='CSM_PURGE_INTERVAL')
386: and level_id=10001;
387:
388: l_days NUMBER;

Line 385: (select profile_option_id from fnd_profile_options where profile_option_name='CSM_PURGE_INTERVAL')

381: FOR UPDATE OF last_run_date NOWAIT;
382:
383: CURSOR c_purge_days IS
384: select profile_option_value from fnd_profile_option_values where profile_option_id in
385: (select profile_option_id from fnd_profile_options where profile_option_name='CSM_PURGE_INTERVAL')
386: and level_id=10001;
387:
388: l_days NUMBER;
389:

Line 1549: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',l_usr_tab(I),l_resp_id,l_app_id));

1545: OPEN c_get_resp_id(l_usr_tab(I));
1546: FETCH c_get_resp_id INTO l_app_id,l_resp_id;
1547: CLOSE c_get_resp_id;
1548:
1549: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',l_usr_tab(I),l_resp_id,l_app_id));
1550:
1551: IF l_timeout > 0 THEN
1552: --timer logic - Fixed 3 tries + 1 original email
1553: wf_event_t.initialize(l_wftimer);

Line 1676: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_'||l_count,

1672: else
1673: l_count := l_try;
1674: end if;
1675:
1676: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_'||l_count,
1677: asg_base.get_user_id(substr(l_role,5,length(l_role)-9)),l_resp_id,l_app_id));
1678:
1679: --try sending Email again
1680: wf_notification.forward(l_nid,l_role);

Line 1729: select to_number(profile_option_value) INTO l_server_tz from fnd_profile_option_values where profile_option_id in

1725: l_increment NUMBER;
1726: l_float NUMBER;
1727: l_dev VARCHAR2(10);
1728: BEGIN
1729: select to_number(profile_option_value) INTO l_server_tz from fnd_profile_option_values where profile_option_id in
1730: (select profile_option_id from fnd_profile_options where profile_option_name in ('SERVER_TIMEZONE_ID'))
1731: and level_id=10001;
1732:
1733: select next_day(add_months('1-JAN'||to_char(sysdate,'YYYY'),begin_dst_month-1) + ((begin_dst_week_of_month-1)*7)-1,

Line 1730: (select profile_option_id from fnd_profile_options where profile_option_name in ('SERVER_TIMEZONE_ID'))

1726: l_float NUMBER;
1727: l_dev VARCHAR2(10);
1728: BEGIN
1729: select to_number(profile_option_value) INTO l_server_tz from fnd_profile_option_values where profile_option_id in
1730: (select profile_option_id from fnd_profile_options where profile_option_name in ('SERVER_TIMEZONE_ID'))
1731: and level_id=10001;
1732:
1733: select next_day(add_months('1-JAN'||to_char(sysdate,'YYYY'),begin_dst_month-1) + ((begin_dst_week_of_month-1)*7)-1,
1734: decode(begin_dst_day_of_week, 1,'SUNDAY',2,'MONDAY',3,'TUESDAY',4,'WEDNESDAY',5,'THURSDAY',6,'FRIDAY',7,'SATURDAY')) + (begin_dst_hour/24) DST_BEGIN_DATE,

Line 1812: SELECT fnd_profile.value_specific('CSM_NOTIFY_DEFERRED',NULL,l_resp_id,l_app_id)

1808: OPEN c_get_resp_id(l_client_id);
1809: FETCH c_get_resp_id INTO l_app_id,l_resp_id;
1810: CLOSE c_get_resp_id;
1811:
1812: SELECT fnd_profile.value_specific('CSM_NOTIFY_DEFERRED',NULL,l_resp_id,l_app_id)
1813: INTO l_user_string FROM DUAL;
1814:
1815: IF CSM_UTIL_PKG.IS_HTML5_USER(l_client_id) THEN --for htm users send report
1816: IF l_user_string IS NULL THEN

Line 2095: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',asg_base.get_user_id(p_user_name),l_resp_id,l_app_id));

2091: OPEN c_get_resp_id(p_user_name);
2092: FETCH c_get_resp_id INTO l_app_id,l_resp_id;
2093: CLOSE c_get_resp_id;
2094:
2095: l_timeout := to_number(fnd_profile.value_specific('CSM_ALERT_TIMEOUT_1',asg_base.get_user_id(p_user_name),l_resp_id,l_app_id));
2096:
2097: IF l_timeout > 0 THEN
2098: --timer logic - Fixed 3 tries + 1 original email
2099: wf_event_t.initialize(l_wftimer);

Line 2233: SELECT fnd_profile.value_specific('CSM_NFN_SYNC_ERROR',NULL,l_resp_id,l_app_id)

2229: OPEN c_get_resp_id(l_client_id);
2230: FETCH c_get_resp_id INTO l_app_id,l_resp_id;
2231: CLOSE c_get_resp_id;
2232:
2233: SELECT fnd_profile.value_specific('CSM_NFN_SYNC_ERROR',NULL,l_resp_id,l_app_id)
2234: INTO l_user_string FROM DUAL;
2235:
2236: IF l_user_string IS NULL THEN
2237: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL for technician.'

Line 2381: SELECT fnd_profile.value_specific('CSM_NFN_SYNC_ERROR',NULL,l_resp_id,l_app_id)

2377: OPEN c_get_resp_id(l_client_id);
2378: FETCH c_get_resp_id INTO l_app_id,l_resp_id;
2379: CLOSE c_get_resp_id;
2380:
2381: SELECT fnd_profile.value_specific('CSM_NFN_SYNC_ERROR',NULL,l_resp_id,l_app_id)
2382: INTO l_user_string FROM DUAL;
2383:
2384: IF l_user_string IS NULL THEN
2385: CSM_UTIL_PKG.LOG('No email is sent to the administrator since the profile CSM_NFN_SYNC_ERROR is NULL for technician.'