APPS.CCT_AQ_PUB dependencies on IEO_SVR_GROUPS

Line 93: select server_group_id into p_server_group_id from ieo_svr_groups

89:
90: -- Assemble Data into Object
91:
92:
93: select server_group_id into p_server_group_id from ieo_svr_groups
94: where group_name = p_server_group_name;
95:
96:
97: IF p_server_group_id IS NULL then

Line 210: select group_group_id into curr_group_group_id from ieo_svr_groups where group_name = curr_server_group_name;

206: IF p_server_group_name IS NULL then
207: raise server_group_name_null;
208: END IF;
209: curr_server_group_name := p_server_group_name;
210: select group_group_id into curr_group_group_id from ieo_svr_groups where group_name = curr_server_group_name;
211: WHILE (true)
212: LOOP
213: select group_name ,
214: group_group_id into curr_server_group_name,curr_group_group_id

Line 215: from ieo_svr_groups

211: WHILE (true)
212: LOOP
213: select group_name ,
214: group_group_id into curr_server_group_name,curr_group_group_id
215: from ieo_svr_groups
216: where server_group_id = curr_group_group_id;
217:
218: END LOOP;
219:

Line 307: select group_name into x_server_group_name from ieo_svr_groups where

303: payload => message,
304: msgid => message_handle);
305: --dbms_output.put_line('DEQUEUE_ITEM: Dequeue done');
306: x_xml_data1 := message.xml_data1;
307: select group_name into x_server_group_name from ieo_svr_groups where
308: server_group_id = message.server_group_id;
309: --dbms_output.put_line('DEQUEUE_ITEM: Select done');
310:
311: -- End of API body.

Line 452: (select server_group_id from ieo_svr_groups where group_name = l_root_server_group_name)

448: BEGIN
449:
450: select server_id into l_iqdServerId from ieo_svr_servers
451: where member_svr_group_id =
452: (select server_group_id from ieo_svr_groups where group_name = l_root_server_group_name)
453: and type_id = 10110 ;
454:
455: --dbms_output.put_line('ENQUEUE_WEB_CALLBACK_ITEM: IQD Server id =' || l_iqdServerId );
456: begin

Line 792: select group_name into l_local_server_group_name from ieo_svr_groups where server_group_id = p_server_group_id;

788:
789: -- Assemble Data into Object
790:
791: IF (p_server_group_id IS NOT NULL) THEN
792: select group_name into l_local_server_group_name from ieo_svr_groups where server_group_id = p_server_group_id;
793: IF (l_local_server_group_name IS NULL) THEN
794: raise server_group_undefined;
795: END IF;
796: l_xml_data1 := l_key_local_server_group_name || ':' || l_local_server_group_name;