APPS.CCT_AQ_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

l_serverLastUpdateDate DATE;

Line: 17

SELECT STATUS, LAST_UPDATE_DATE into l_serverStatus, l_serverLastUpdateDate
FROM IEO_SVR_RT_INFO
WHERE SERVER_ID = l_server_id;

Line: 22

    ((( sysdate - l_serverLastUpdateDate )*24*60*60*1000) < l_refreshRate)) THEN
        --dbms_output.put_line ('End is_server_up, returning 0');

Line: 93

select server_group_id into p_server_group_id from ieo_svr_groups
  where group_name = p_server_group_name;

Line: 210

select group_group_id into curr_group_group_id from ieo_svr_groups where group_name = curr_server_group_name;

Line: 213

	select group_name ,
	group_group_id into  curr_server_group_name,curr_group_group_id
    from ieo_svr_groups
	where server_group_id = curr_group_group_id;

Line: 307

	select group_name into x_server_group_name from ieo_svr_groups where
	server_group_id = message.server_group_id;

Line: 450

    select server_id into l_iqdServerId from ieo_svr_servers
    where member_svr_group_id =
    (select server_group_id from ieo_svr_groups where group_name = l_root_server_group_name)
    and type_id = 10110 ;

Line: 457

    select value into l_isWebCallback from ieo_svr_values
    where param_id = (select param_id from ieo_svr_params
        where type_id = 10110 and param_name = 'IS_WEB_CALLBACK')
    and server_id = l_iqdServerId;

Line: 617

    CCT_QDE_PUB.UPDATE_ROUTE_RESULT
       (p_api_version => p_api_version,
        p_init_msg_list => p_init_msg_list,
        p_commit => p_commit,
        p_item_id => l_item_id,
        p_item_type => CCT_MEDIA_TYPES_PUB.G_BASIC_WEB_CALLBACK,
        p_classification => 'unClassified',
        p_route_result => null,
        p_is_route_to_all => 'Y',
        p_is_reroute => 'N',
        p_kvp => l_kvp,
        x_return_status	=> x_return_status,
        x_msg_count	=> x_msg_count,
        x_msg_data	=> x_msg_data);

Line: 792

	select group_name into l_local_server_group_name from ieo_svr_groups where server_group_id = p_server_group_id;