APPS.PO_WF_FUN SQL Statements

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

Line: 10

  select instr(in_str, ''''), instr(in_str,'''',1,2)
  into x_left, x_right
  from dual;

Line: 14

  select substr(in_str,x_left+1, x_right-x_left-1)
  into out_str
  from dual;

Line: 43

      SELECT oracle_username
      INTO l_apps_schema_name
      FROM fnd_oracle_userid
      WHERE read_only_flag = 'U';

Line: 59

      select display_name
        into x_item_type_name
        from wf_item_types_tl
       where name = x_wf_function.item_type
         and language = 'US';

Line: 65

      select distinct display_name
        into x_function_name
        from wf_activities_tl
       where item_type = x_wf_function.item_type
         and name      = x_wf_function.name
         and language = 'US' ;

Line: 72

      select min(line)
        into x_line_s
        from all_source
       where name= x_wf_function.package_name
         and owner= l_apps_schema_name  --bug4025028
         and type='PACKAGE BODY'
         and upper(text) like '%PROCEDURE'||'% '||x_wf_function.procedure_name||'%' ;

Line: 80

      select max(line)
        into x_line_e
        from all_source
       where name= x_wf_function.package_name
         and owner= l_apps_schema_name --bug4025028
         and type='PACKAGE BODY'
         and (upper(text) like '%END'||'% '||x_wf_function.procedure_name||'%');

Line: 106

           select text
             into x_text
             from all_source
            where name = x_wf_function.package_name
              and owner= l_apps_schema_name --bug4025028
              and type='PACKAGE BODY'
              and line >=x_wf_function_code.line and line <= (x_wf_function_code.line+5)
              and upper(text) like '%ANAME%';

Line: 119

           select text
             into x_text
             from all_source
            where name = x_wf_function.package_name
              and owner= l_apps_schema_name --bug4025028
              and type='PACKAGE BODY'
              and line >=x_wf_function_code.line and line <= (x_wf_function_code.line+3)
              and upper(text) like '%ANAME%';