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 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 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 577: (select server_id from ieo_svr_servers

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

Line 594: (select server_id from ieo_svr_servers

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