APPS.WF_MAILER_PARAMETER SQL Statements

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

Line: 24

         select VALUE
         into lValue
         from WF_MAILER_PARAMETERS
         where NAME = pName
           and PARAMETER = pParam;

Line: 31

            select VALUE
            into lValue
            from WF_MAILER_PARAMETERS wp
            where NAME = DEFAULT_NAME
              and parameter = pParam;

Line: 151

      SELECT name, parameter, value, required
        FROM wf_mailer_parameters
       WHERE name = pName
       UNION
      SELECT pName name, parameter, value, required
        FROM wf_mailer_parameters
       WHERE name = '-WF_DEFAULT-'
         AND parameter NOT IN (SELECT parameter
                          FROM wf_mailer_parameters
                          WHERE name = pName);

Line: 165

      pParams.DELETE;

Line: 191

        SELECT COUNT(*)
        INTO lexists
        FROM wf_mailer_parameters
        WHERE name = pName
          AND parameter = pParameter;

Line: 196

        UPDATE wf_mailer_parameters
        SET value = pValue,
            required = pRequired,
            cb = pCB,
            allow_reload = pAllowReload
        WHERE name = pName
          AND parameter = pParameter;

Line: 208

        INSERT INTO wf_mailer_parameters
        (name, parameter, value, required, cb, allow_reload)
        VALUES (pName, pParameter, pValue, pRequired, pCB, pAllowReload);

Line: 227

         UPDATE wf_mailer_parameters
         SET value = pvalue
         where name = pName
           and parameter = pParam;

Line: 232

            INSERT INTO
               wf_mailer_parameters
               (name, parameter, value, required, cb, allow_reload)
               SELECT pName,
               pParam,
               pvalue,
               wp.required,
               wp.cb,
               wp.allow_reload
               FROM wf_mailer_parameters wp
               WHERE NAME = default_name
                 and parameter = pParam;

Line: 247

         DELETE wf_mailer_parameters
         WHERE name = pName
           AND parameter = pParam;

Line: 273

         SELECT cb
         INTO funName
         FROM wf_mailer_parameters
         WHERE name = default_name
           AND parameter = pParam;

Line: 363

        SELECT name, tag_id, action, pattern
        FROM wf_mailer_tags
        WHERE name = pServiceName
        UNION
        SELECT name, tag_id, action, pattern
        FROM wf_mailer_tags
        WHERE name = '-WF_DEFAULT-';

Line: 384

      SELECT name, tag_id, pattern, action
      FROM wf_mailer_tags
      WHERE name = lName;

Line: 432

         select count(1)
         into   tagExists
         from   wf_mailer_tags
         WHERE  tag_id  = pTag_id;

Line: 439

	       DELETE wf_mailer_tags
	       WHERE name = pName
	       AND tag_id = ptag_id;

Line: 443

	      UPDATE wf_mailer_tags
	      SET action = paction,
		  pattern = ppattern
	      WHERE name = pName
	      AND tag_id = ptag_id;

Line: 452

	   INSERT INTO wf_mailer_tags
		    (name,
		    tag_id,
		    action,
		    pattern)
             VALUES (pName,
                     pTag_id,
                     paction,
                     ppattern);

Line: 466

         select count(1)
         into   tagExists
         from   wf_mailer_tags
         where  action  = paction
	 and    pattern = ppattern
	 and    name    = pName  ;

Line: 473

	 --  Insert unique tags
	 if(nvl(tagExists, 0) = 0) then
           INSERT INTO wf_mailer_tags
		    (name,
		    tag_id,
		    action,
		    pattern)
             VALUES (pName,
                     wf_mailer_tags_s.nextval,
                     paction,
                     ppattern);

Line: 824

      SELECT value, required
      into l_default, l_required
      FROM wf_mailer_parameters
      WHERE name = default_name
        AND parameter = pParam;

Line: 865

            SELECT pValue
            INTO numVal
            FROM sys.dual;

Line: 951

         SELECT 1 into valid
         FROM sys.dual
               WHERE pValue like '%%%s%-t%-F%"%%s"%<%%%s';

Line: 988

	SELECT component_id
	FROM FND_SVC_COMPONENTS
	WHERE
		l_corrid like correlation_id and
		component_type = 'WF_MAILER'
	order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;

Line: 996

	SELECT component_id
	FROM FND_SVC_COMPONENTS
	WHERE
		correlation_id is null and
		component_type = 'WF_MAILER'
	order by DECODE(component_status, 'RUNNING', 1, 'NOT_CONFIGURED', 3, 2) ASC ;