APPS.CCT_VALIDATION_PUB SQL Statements

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

Line: 61

      select value into l_iqd_web_callback from ieo_svr_values
      where server_id =
        (select server_id from ieo_svr_servers
         where type_id = 10110
          and member_svr_group_id =  p_server_group_id)
        and param_id = 10026;

Line: 70

      select value into l_iqd_web_callback from ieo_svr_values
      where server_id =
        (select server_id from ieo_svr_servers
         where type_id = 10110
          and member_svr_group_id =
            (select group_group_id from ieo_svr_groups where
             server_group_id = p_server_group_id))
        and param_id = 10026;

Line: 88

      SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
        FROM FND_NEW_MESSAGES
        WHERE LANGUAGE_CODE = p_env_lang
--        (SELECT LANGUAGE_CODE
--          FROM FND_LANGUAGES
--          WHERE NLS_LANGUAGE = p_env_lang)
        AND APPLICATION_ID = 172
      AND MESSAGE_NAME = l_msg_code;

Line: 106

    SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      FROM FND_NEW_MESSAGES
      WHERE LANGUAGE_CODE = p_env_lang
--      (SELECT LANGUAGE_CODE
--        FROM FND_LANGUAGES
--        WHERE NLS_LANGUAGE = p_env_lang)
      AND APPLICATION_ID = 172
    AND MESSAGE_NAME = l_msg_code;

Line: 144

  select param_id into l_param_id
    from IEO_SVR_PARAMS
    where param_name = p_param_name
	  AND type_id = p_type_id;

Line: 249

	  select LENGTH(l_temp1) into l_length from DUAL;

Line: 256

	    select INSTR(l_temp1, l_comma_str , l_begPos, 1) into l_endPos from DUAL;

Line: 259

	      select SUBSTR(l_temp1, l_begPos) into l_currVal from DUAL;

Line: 263

    		SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      	  	FROM FND_NEW_MESSAGES
      	  	WHERE LANGUAGE_CODE = p_env_lang
--      		(SELECT LANGUAGE_CODE
--        	   	FROM FND_LANGUAGES
--        	   	WHERE NLS_LANGUAGE = p_env_lang)
      			AND APPLICATION_ID = 172
   			AND MESSAGE_NAME = l_msg_code;

Line: 277

    		SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      	  	FROM FND_NEW_MESSAGES
      	  	WHERE LANGUAGE_CODE = p_env_lang
--      		(SELECT LANGUAGE_CODE
--        	   	FROM FND_LANGUAGES
--        	   	WHERE NLS_LANGUAGE = p_env_lang)
      			AND APPLICATION_ID = 172
   			AND MESSAGE_NAME = l_msg_code;

Line: 298

	      select SUBSTR(l_temp1, l_begPos, l_endPos - l_begPos) into l_currVal from DUAL;

Line: 302

    		SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      	  	FROM FND_NEW_MESSAGES
      	  	WHERE LANGUAGE_CODE = p_env_lang
--      		(SELECT LANGUAGE_CODE
--        	   	FROM FND_LANGUAGES
--        	   	WHERE NLS_LANGUAGE = p_env_lang)
      			AND APPLICATION_ID = 172
   			AND MESSAGE_NAME = l_msg_code;

Line: 316

    		SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      	  	FROM FND_NEW_MESSAGES
      	  	WHERE LANGUAGE_CODE = p_env_lang
--      		(SELECT LANGUAGE_CODE
--        	   	FROM FND_LANGUAGES
--        	   	WHERE NLS_LANGUAGE = p_env_lang)
      			AND APPLICATION_ID = 172
   			AND MESSAGE_NAME = l_msg_code;

Line: 353

    select count(*) into l_tempNum
      from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers
      where vals.server_id = servers.server_id
	    AND servers.type_id = l_its_server_type
	    AND vals.server_id <> p_server_id
            AND servers.member_svr_group_id = p_server_group_id
	    AND vals.param_id = l_mw_param_id
	    AND vals.value = l_mw_param;

Line: 365

    	SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      	  FROM FND_NEW_MESSAGES
      	  WHERE LANGUAGE_CODE = p_env_lang
--      		(SELECT LANGUAGE_CODE
--        	   FROM FND_LANGUAGES
--        	   WHERE NLS_LANGUAGE = p_env_lang)
      		AND APPLICATION_ID = 172
   		AND MESSAGE_NAME = l_msg_code;

Line: 380

    select count(*) into l_tempNum
      from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers
      where vals.server_id = servers.server_id
	    AND servers.type_id = l_its_server_type
	    AND servers.server_id <> p_server_id
            AND servers.member_svr_group_id = p_server_group_id
	    AND vals.param_id = l_mw_param_id
	    AND vals.value = l_mw_param
	    AND not exists (
		select 1
		  from IEO_SVR_VALUES v
		  where v.server_id = servers.server_id
		        AND v.param_id = l_rp_param_id);

Line: 397

    	SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      	  FROM FND_NEW_MESSAGES
      	  WHERE LANGUAGE_CODE = p_env_lang
--      		(SELECT LANGUAGE_CODE
--        	   FROM FND_LANGUAGES
--        	   WHERE NLS_LANGUAGE = p_env_lang)
      		AND APPLICATION_ID = 172
   		AND MESSAGE_NAME = l_msg_code;

Line: 414

    SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      FROM FND_NEW_MESSAGES
      	  WHERE LANGUAGE_CODE = p_env_lang
--      		(SELECT LANGUAGE_CODE
--        	   FROM FND_LANGUAGES
--        	   WHERE NLS_LANGUAGE = p_env_lang)
        AND APPLICATION_ID = 172
   	AND MESSAGE_NAME = l_msg_code;

Line: 430

    select INSTR(l_temp, l_mw_param, 1, 1) into l_endPos from DUAL;

Line: 435

    	SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      	  FROM FND_NEW_MESSAGES
      	  WHERE LANGUAGE_CODE = p_env_lang
--      		(SELECT LANGUAGE_CODE
--        	   FROM FND_LANGUAGES
--        	   WHERE NLS_LANGUAGE = p_env_lang)
      		AND APPLICATION_ID = 172
   		AND MESSAGE_NAME = l_msg_code;

Line: 448

    select count(*) into l_tempNum
      from IEO_SVR_VALUES vals, IEO_SVR_SERVERS servers
      where vals.server_id = servers.server_id
	    AND vals.server_id <> p_server_id
            AND servers.member_svr_group_id = p_server_group_id
	    AND vals.param_id = l_rp_param_id
	    AND vals.value like  '%' || l_rp_params(i) || '%';

Line: 459

    	SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      	  FROM FND_NEW_MESSAGES
      	  WHERE LANGUAGE_CODE = p_env_lang
--      		(SELECT LANGUAGE_CODE
--        	   FROM FND_LANGUAGES
--        	   WHERE NLS_LANGUAGE = p_env_lang)
      		AND APPLICATION_ID = 172
   		AND MESSAGE_NAME = l_msg_code;

Line: 558

    SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
      FROM FND_NEW_MESSAGES
      WHERE LANGUAGE_CODE = p_env_lang
--      (SELECT LANGUAGE_CODE
--        FROM FND_LANGUAGES
--        WHERE NLS_LANGUAGE = p_env_lang)
      AND APPLICATION_ID = 172
    AND MESSAGE_NAME = l_msg_code;

Line: 575

    select value from ieo_svr_values
    where server_id in
    (select server_id from ieo_svr_servers
     where type_id = 10001
      and member_svr_group_id =  p_server_group_id)
    and param_id = 10201;

Line: 592

    select value from ieo_svr_values
    where server_id in
    (select server_id from ieo_svr_servers
     where type_id = 10001
      and member_svr_group_id =  p_server_group_id)
    and param_id = 10202;

Line: 612

      SELECT MESSAGE_TEXT into x_err_msgs(x_err_msgs.count)
        FROM FND_NEW_MESSAGES
        WHERE LANGUAGE_CODE = p_env_lang
      AND APPLICATION_ID = 172
      AND MESSAGE_NAME = l_msg_code;