APPS.CCT_VALIDATION_PUB dependencies on IEO_SVR_VALUES

Line 61: select value into l_iqd_web_callback from ieo_svr_values

57: (UPPER(p_param_values(l_preview_wc_idx)) = UPPER('true'))) then
58: l_preview_enabled := 1;
59: -- preview webcallback should be true only if iqd web callback is enabled
60: begin
61: select value into l_iqd_web_callback from ieo_svr_values
62: where server_id =
63: (select server_id from ieo_svr_servers
64: where type_id = 10110
65: and member_svr_group_id = p_server_group_id)

Line 70: select value into l_iqd_web_callback from ieo_svr_values

66: and param_id = 10026;
67: exception
68: when NO_DATA_FOUND then
69: begin
70: select value into l_iqd_web_callback from ieo_svr_values
71: where server_id =
72: (select server_id from ieo_svr_servers
73: where type_id = 10110
74: and member_svr_group_id =

Line 354: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers

350: -- No route point defined => Make sure no other ITS Servers
351: -- has the same MW defined
352: --dbms_output.put_line('l_rp_params.count <= 0 ');
353: select count(*) into l_tempNum
354: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers
355: where vals.server_id = servers.server_id
356: AND servers.type_id = l_its_server_type
357: AND vals.server_id <> p_server_id
358: AND servers.member_svr_group_id = p_server_group_id

Line 381: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers

377: -- Retrieve the number of other ITS Servers
378: -- monitoring the same middlewares and monitoring
379: -- all the route points
380: select count(*) into l_tempNum
381: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers
382: where vals.server_id = servers.server_id
383: AND servers.type_id = l_its_server_type
384: AND servers.server_id <> p_server_id
385: AND servers.member_svr_group_id = p_server_group_id

Line 390: from IEO_SVR_VALUES v

386: AND vals.param_id = l_mw_param_id
387: AND vals.value = l_mw_param
388: AND not exists (
389: select 1
390: from IEO_SVR_VALUES v
391: where v.server_id = servers.server_id
392: AND v.param_id = l_rp_param_id);
393:
394: IF l_tempNum > 0 THEN

Line 449: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers

445: END IF;
446:
447: -- 2) Check if the route point is already taken by other ITS Servers
448: select count(*) into l_tempNum
449: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers
450: where vals.server_id = servers.server_id
451: AND vals.server_id <> p_server_id
452: AND servers.member_svr_group_id = p_server_group_id
453: AND vals.param_id = l_rp_param_id

Line 575: select value from ieo_svr_values

571: then
572: begin
573: l_send_error := 0;
574: declare cursor c1 is
575: select value from ieo_svr_values
576: where server_id in
577: (select server_id from ieo_svr_servers
578: where type_id = 10001
579: and member_svr_group_id = p_server_group_id)

Line 592: select value from ieo_svr_values

588: end loop;
589: end;
590:
591: declare cursor c2 is
592: select value from ieo_svr_values
593: where server_id in
594: (select server_id from ieo_svr_servers
595: where type_id = 10001
596: and member_svr_group_id = p_server_group_id)