APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on DUAL

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 1813: INTO l_user_string FROM DUAL;

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
1817: l_user_string:=l_client_id;

Line 1888: INTO l_code from dual;

1884: name specifying parent's id is generic */
1885:
1886: IF p_child_pubitem ='CSM_TASKS' THEN
1887: select decode(p_parent_pubitem,'CSM_INCIDENTS_ALL','SR','X')
1888: INTO l_code from dual;
1889:
1890: RETURN 'AND SOURCE_OBJECT_TYPE_CODE='''||l_code||'''';
1891: ELSIF p_child_pubitem = 'CSF_M_NOTES' THEN
1892: select decode(p_parent_pubitem,'CSM_INCIDENTS_ALL','SR','CSM_TASKS','TASK',

Line 1893: 'CSM_DEBRIEF_HEADERS', 'SD','X') INTO l_code from dual;

1889:
1890: RETURN 'AND SOURCE_OBJECT_TYPE_CODE='''||l_code||'''';
1891: ELSIF p_child_pubitem = 'CSF_M_NOTES' THEN
1892: select decode(p_parent_pubitem,'CSM_INCIDENTS_ALL','SR','CSM_TASKS','TASK',
1893: 'CSM_DEBRIEF_HEADERS', 'SD','X') INTO l_code from dual;
1894:
1895: RETURN 'AND SOURCE_OBJECT_CODE='''||l_code||'''';
1896: ELSIF p_child_pubitem = 'CSF_M_LOBS' THEN
1897: select decode(p_parent_pubitem,'CSM_INCIDENTS_ALL','CS_INCIDENTS','CSM_TASKS','JTF_TASKS_B',

Line 1898: 'CSM_DEBRIEF_HEADERS', 'CSF_DEBRIEF_HEADERS','X') INTO l_code from dual;

1894:
1895: RETURN 'AND SOURCE_OBJECT_CODE='''||l_code||'''';
1896: ELSIF p_child_pubitem = 'CSF_M_LOBS' THEN
1897: select decode(p_parent_pubitem,'CSM_INCIDENTS_ALL','CS_INCIDENTS','CSM_TASKS','JTF_TASKS_B',
1898: 'CSM_DEBRIEF_HEADERS', 'CSF_DEBRIEF_HEADERS','X') INTO l_code from dual;
1899:
1900: RETURN 'AND ENTITY_NAME='''||l_code||'''';
1901: END IF;
1902:

Line 2042: select CSM_DEFERRED_NFN_INFO_S.nextval into l_tracking_id from dual;

2038: END LOOP;
2039:
2040: CLOSE c_parent;
2041:
2042: select CSM_DEFERRED_NFN_INFO_S.nextval into l_tracking_id from dual;
2043:
2044:
2045: IF isRoot AND NOT CSM_UTIL_PKG.IS_HTML5_USER(p_user_name) THEN --notify/email user
2046: --Check if auto sync is enabled

Line 2234: INTO l_user_string FROM DUAL;

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.'
2238: ||' Sending email only to Technician - '|| l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERROR_ADMIN_SUB',FND_LOG.LEVEL_PROCEDURE);

Line 2382: INTO l_user_string FROM DUAL;

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.'
2386: ||' Sending email only to Technician - '|| l_client_id,'CSM_NOTIFICATION_EVENT_PKG.EMAIL_SYNC_ERRORS_CONC',FND_LOG.LEVEL_PROCEDURE);