APPS.WF_CORE SQL Statements

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

Line: 127

      SELECT TEXT INTO mesg_text
      FROM WF_RESOURCES
      WHERE TYPE = mtype
      and NAME = mname
      and LANGUAGE = userenv('LANG');

Line: 198

        select TEXT
          into buf
          from WF_RESOURCES
         where TYPE = Get_Message.msgtype
           and NAME = Get_Message.msgname
           and LANGUAGE = 'US';

Line: 207

        select TEXT
          into buf
          from WF_RESOURCES
         where TYPE = Get_Message.msgtype
           and NAME = Get_Message.msgname
           and LANGUAGE = userenv('LANG');

Line: 288

    SELECT ID
    INTO wf_core.error_number
    FROM WF_RESOURCES
    WHERE TYPE = 'WFERR'
    and NAME = Raise.name
    and LANGUAGE = userenv('LANG');

Line: 633

                select  meaning
                into    l_meaning
                from    wf_lookups
                where   lookup_type = result_type
                and     lookup_code = result_code;

Line: 644

                        select  meaning
                        into    l_meaning
                        from    wf_lookups
                        where   lookup_type = 'WFENG_RESULT'
                        and     lookup_code = result_code;

Line: 869

   SELECT to_number(substr(version,1, instr(version,'.',1,1) -1))
   INTO   g_oracle_major_version
   FROM   v$instance;

Line: 875

         SELECT  value
         INTO    g_aq_tm_processes
         FROM    v$parameter
         WHERE   name = 'aq_tm_processes';

Line: 959

    select value into gwf_nls_numeric_characters
    from v$nls_parameters where parameter ='NLS_NUMERIC_CHARACTERS';