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 346: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers

342: -- No route point defined => Make sure no other ITS Servers
343: -- has the same MW defined
344: --dbms_output.put_line('l_rp_params.count <= 0 ');
345: select count(*) into l_tempNum
346: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers
347: where vals.server_id = servers.server_id
348: AND servers.type_id = l_its_server_type
349: AND vals.server_id <> p_server_id
350: AND servers.member_svr_group_id = p_server_group_id

Line 373: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers

369: -- Retrieve the number of other ITS Servers
370: -- monitoring the same middlewares and monitoring
371: -- all the route points
372: select count(*) into l_tempNum
373: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers
374: where vals.server_id = servers.server_id
375: AND servers.type_id = l_its_server_type
376: AND servers.server_id <> p_server_id
377: AND servers.member_svr_group_id = p_server_group_id

Line 382: from IEO_SVR_VALUES v

378: AND vals.param_id = l_mw_param_id
379: AND vals.value = l_mw_param
380: AND not exists (
381: select 1
382: from IEO_SVR_VALUES v
383: where v.server_id = servers.server_id
384: AND v.param_id = l_rp_param_id);
385:
386: IF l_tempNum > 0 THEN

Line 441: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers

437: END IF;
438:
439: -- 2) Check if the route point is already taken by other ITS Servers
440: select count(*) into l_tempNum
441: from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers
442: where vals.server_id = servers.server_id
443: AND vals.server_id <> p_server_id
444: AND servers.member_svr_group_id = p_server_group_id
445: AND vals.param_id = l_rp_param_id

Line 567: select value from ieo_svr_values

563: then
564: begin
565: l_send_error := 0;
566: declare cursor c1 is
567: select value from ieo_svr_values
568: where server_id in
569: (select server_id from ieo_svr_servers
570: where type_id = 10001
571: and member_svr_group_id = p_server_group_id)

Line 584: select value from ieo_svr_values

580: end loop;
581: end;
582:
583: declare cursor c2 is
584: select value from ieo_svr_values
585: where server_id in
586: (select server_id from ieo_svr_servers
587: where type_id = 10001
588: and member_svr_group_id = p_server_group_id)