APPS.IEM_PARSER_PVT SQL Statements

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

Line: 100

        SELECT VALUE from IEM_MS_MSGBODYS where p_message_id = message_id;

Line: 201

      select upper(ixv_value) wrd
      from ctxsys.ctx_index_values
      where ( ixv_index_name = upper ( idx_name )
              or ( ixv_index_owner||'.'||ixv_index_name = upper ( idx_name ))
            )
      and ixv_attribute = 'STOP_WORD';

Line: 331

        retlist.delete(maxi);

Line: 364

    ' select object_name from ec_ana_explain ' ||
    ' where explain_id = 1 '               ||
    ' and position = 1 '                   ||
    ' and parent_id = 1' ) into retval;

Line: 389

      'select root from ec_ana_roots where token = :t1')
      into retval using term;

Line: 402

         execute immediate('insert into ec_ana_roots (token, root) values (:t1, :t2)')
           using term, retval;

Line: 409

      ' select object_name from ec_ana_explain ' ||
      ' where explain_id = 1 '               ||
      ' and position = 1 '                   ||
      ' and parent_id = 1' ) into retval;

Line: 418

    execute immediate('insert into ec_ana_roots (token, root) values (:t1, :t2)')
      using term, retval;

Line: 782

              matchcnt := matchcnt + 1; -- update match count and move on

Line: 799

              matchcnt := matchcnt + 1; -- update match count and move on

Line: 816

              matchcnt := matchcnt + 1; -- update match count and move on