APPS.FND_OAM_COLLECTION dependencies on FND_OAM_SVCI_INFO

Line 138: v_collection_enabled_flag fnd_oam_svci_info.collection_enabled_flag%TYPE;

134: FUNCTION is_collection_enabled (
135: p_application_id number,
136: p_concurrent_queue_name varchar2) RETURN boolean
137: IS
138: v_collection_enabled_flag fnd_oam_svci_info.collection_enabled_flag%TYPE;
139: v_retu boolean := TRUE;
140: BEGIN
141: select nvl(collection_enabled_flag, 'Y')
142: into v_collection_enabled_flag

Line 143: from fnd_oam_svci_info

139: v_retu boolean := TRUE;
140: BEGIN
141: select nvl(collection_enabled_flag, 'Y')
142: into v_collection_enabled_flag
143: from fnd_oam_svci_info
144: where application_id = p_application_id
145: and concurrent_queue_name = p_concurrent_queue_name;
146: if (v_collection_enabled_flag = 'N') then
147: v_retu := FALSE;

Line 268: l_threshold_value fnd_oam_svci_info.threshold_value%TYPE;

264: p_concurrent_queue_name varchar2)
265: RETURN boolean
266: IS
267: v_retu boolean := FALSE;
268: l_threshold_value fnd_oam_svci_info.threshold_value%TYPE;
269: BEGIN
270: --if (is_alert_enabled(p_application_id, p_concurrent_queue_name)) then
271: select threshold_value
272: into l_threshold_value

Line 273: from fnd_oam_svci_info

269: BEGIN
270: --if (is_alert_enabled(p_application_id, p_concurrent_queue_name)) then
271: select threshold_value
272: into l_threshold_value
273: from fnd_oam_svci_info
274: where application_id = p_application_id
275: and concurrent_queue_name = p_concurrent_queue_name;
276:
277: if (l_threshold_value is not null) then

Line 1935: fnd_oam_svci_info fsi

1931: fcq.concurrent_queue_id concurrent_queue_id,
1932: foa.status_code status_code
1933: from fnd_oam_app_sys_status foa,
1934: fnd_concurrent_queues fcq,
1935: fnd_oam_svci_info fsi
1936: where foa.application_id = fcq.application_id
1937: and foa.concurrent_queue_name = fcq.concurrent_queue_name
1938: and foa.application_id = fsi.application_id (+)
1939: and foa.concurrent_queue_name = fsi.concurrent_queue_name (+)