APPS.WF_PREF SQL Statements

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

Line: 172

SELECT nls_language, nls_territory, code
FROM   wf_languages
WHERE  nls_language like c_find_criteria
AND    installed_flag = 'Y'
ORDER  BY nls_language;

Line: 184

      SELECT COUNT(*)
      INTO   l_row_count
      FROM   wf_languages
      WHERE  nls_language like p_find_criteria||'%'
      AND    installed_flag = 'Y';

Line: 248

SELECT
 nls_territory,
 nls_language,
 code
FROM   wf_languages
WHERE  nls_territory like c_find_criteria
AND    installed_flag = 'Y'
ORDER  BY nls_language;

Line: 264

      SELECT COUNT(*)
      INTO   l_row_count
      FROM   wf_languages
      WHERE  nls_territory like p_find_criteria||'%'
      AND    installed_flag = 'Y';

Line: 328

SELECT
node_id,
node_name,
node_description
FROM   fnd_dm_nodes
WHERE  node_name like p_find_criteria||'%'
ORDER  BY node_name;

Line: 343

      SELECT COUNT(*)
      INTO   l_row_count
      FROM   fnd_dm_nodes
      WHERE  node_name like p_find_criteria||'%';

Line: 391

PROCEDURE update_pref (
p_admin_role            IN VARCHAR2,
p_display_admin_role    IN VARCHAR2,
p_web_agent             IN VARCHAR2,
p_edit_defaults         IN VARCHAR2,
p_language              IN VARCHAR2,
p_territory             IN VARCHAR2,
p_date_format           IN VARCHAR2,
p_dm_node_id            IN VARCHAR2,
p_dm_home               IN VARCHAR2,
p_mailtype              IN VARCHAR2,
p_classid               IN VARCHAR2,
p_plugin_loc            IN VARCHAR2,
p_plugin_ver            IN VARCHAR2,
p_system_guid           IN VARCHAR2,
p_system_name           IN VARCHAR2,
p_system_status         IN VARCHAR2,
p_ldap_host             IN VARCHAR2,
p_ldap_port             IN VARCHAR2,
p_ldap_user             IN VARCHAR2,
p_ldap_opwd             IN VARCHAR2,
p_ldap_npwd             IN VARCHAR2,
p_ldap_rpwd             IN VARCHAR2,
p_ldap_log_base         IN VARCHAR2,
p_ldap_user_base        IN VARCHAR2,
p_text_signon           IN VARCHAR2
) IS

BEGIN
  null;

Line: 421

END update_pref;

Line: 427

PROCEDURE update_pref_fwk (
p_admin_role            IN VARCHAR2,
p_display_admin_role    IN VARCHAR2,
p_web_agent             IN VARCHAR2,
p_edit_defaults         IN VARCHAR2,
p_language              IN VARCHAR2,
p_territory             IN VARCHAR2,
p_date_format           IN VARCHAR2,
p_dm_node_id            IN VARCHAR2,
p_dm_home               IN VARCHAR2,
p_mailtype              IN VARCHAR2,
p_classid               IN VARCHAR2,
p_plugin_loc            IN VARCHAR2,
p_plugin_ver            IN VARCHAR2,
p_system_guid           IN VARCHAR2,
p_system_name           IN VARCHAR2,
p_system_status         IN VARCHAR2,
p_ldap_host             IN VARCHAR2,
p_ldap_port             IN VARCHAR2,
p_ldap_user             IN VARCHAR2,
p_ldap_opwd             IN VARCHAR2,
p_ldap_npwd             IN VARCHAR2,
p_ldap_rpwd             IN VARCHAR2,
p_ldap_log_base         IN VARCHAR2,
p_ldap_user_base        IN VARCHAR2,
p_text_signon           IN VARCHAR2,
p_num_format            IN VARCHAR2,
p_browser_dll_loc       IN VARCHAR2,
p_err_msg               OUT NOCOPY VARCHAR2
) IS

  l_row_count   number := 0;

Line: 506

     SELECT count(*)
     INTO   l_row_count
     FROM   wf_languages
     WHERE  nls_language = p_language
     AND    installed_flag = 'Y';

Line: 523

     SELECT count(*)
     INTO   l_combo_count
     FROM   wf_languages
     WHERE  nls_language = p_language
     AND    nls_territory = p_territory
     AND    installed_flag = 'Y';

Line: 557

     SELECT count(*)
     INTO   l_row_count
     FROM   wf_languages
     WHERE  nls_territory = p_territory
     AND    installed_flag = 'Y';

Line: 588

     SELECT TO_CHAR(sysdate, RTRIM(p_date_format))
     INTO   l_test_date
     FROM   dual;

Line: 703

         UPDATE wf_resources
         SET    text = UPPER(l_name)
         WHERE  type = 'WFTKN'
         AND    name = 'WF_ADMIN_ROLE';

Line: 715

      UPDATE wf_resources
      SET    text = p_web_agent
      WHERE  type = 'WFTKN'
      AND    name = 'WF_WEB_AGENT';

Line: 722

       ** It is no longer possible to update jinitiator info
       ** from the Global Preferences page

      -- Update the jinitiator info
      UPDATE wf_resources
      SET    text = p_classid
      WHERE  type = 'WFTKN'
      AND    name = 'WF_CLASSID';

Line: 731

      UPDATE wf_resources
      SET    text = p_plugin_loc
      WHERE  type = 'WFTKN'
      AND    name = 'WF_PLUGIN_DOWNLOAD';

Line: 736

      UPDATE wf_resources
      SET    text = p_plugin_ver
      WHERE  type = 'WFTKN'
      AND    name = 'WF_PLUGIN_VERSION';

Line: 751

          Wf_Resources_Pkg.Update_Row(
          x_type=>'WFTKN',
          x_name=>'WF_SYSTEM_GUID',
          x_protect_level=>0,
          x_custom_level=>0,
          x_id=>0,
          x_text=>rawtohex(l_sguid)
          );

Line: 761

            Wf_Resources_Pkg.Insert_Row(
            x_rowid=>rowid,
            x_type=>'WFTKN',
            x_name=>'WF_SYSTEM_GUID',
            x_protect_level=>0,
            x_custom_level=>0,
            x_id=>0,
            x_text=>rawtohex(l_sguid)
            );

Line: 775

          Wf_Resources_Pkg.Update_Row(
          x_type=>'WFTKN',
          x_name=>'WF_SYSTEM_STATUS',
          x_protect_level=>0,
          x_custom_level=>0,
          x_id=>0,
          x_text=>p_system_status
        );

Line: 785

          Wf_Resources_Pkg.Insert_Row(
            x_rowid=>rowid,
            x_type=>'WFTKN',
            x_name=>'WF_SYSTEM_STATUS',
            x_protect_level=>0,
            x_custom_level=>0,
            x_id=>0,
            x_text=>p_system_status
          );

Line: 810

    wf_core.context('Wf_Pref', 'update_pref',
                    p_language ,
                    p_territory   ,
                    p_admin_role,
                    p_display_admin_role   );

Line: 817

END update_pref_fwk;

Line: 830

   SELECT MAX(PREFERENCE_VALUE)
   INTO   l_preference_value
   FROM   FND_USER_PREFERENCES
   WHERE  USER_NAME = p_user_name
   AND    PREFERENCE_NAME = p_preference_name
   AND    MODULE_NAME = 'WF';

Line: 841

      SELECT MAX(PREFERENCE_VALUE)
      INTO   l_preference_value
      FROM   FND_USER_PREFERENCES
      WHERE  USER_NAME = '-WF_DEFAULT-'
      AND    PREFERENCE_NAME = p_preference_name
      AND    MODULE_NAME = 'WF';