APPS.CCT_VALIDATION_PUB dependencies on IEO_SVR_SERVERS

Line 63: (select server_id from ieo_svr_servers

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)
66: and param_id = 10026;
67: exception

Line 72: (select server_id from ieo_svr_servers

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 =
75: (select group_group_id from ieo_svr_groups where
76: server_group_id = p_server_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 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 569: (select server_id from ieo_svr_servers

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)
572: and param_id = 10201;
573: -- OTM PREVIEW MODE PARAM

Line 586: (select server_id from ieo_svr_servers

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)
589: and param_id = 10202;
590: -- OTM Param Max Preview Time