APPS.ASG_PERF SQL Statements

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

Line: 56

    select instance_name into l_db_instance
    from v$instance;

Line: 110

    l_query_string := 'insert into ' || asg_base.G_OLITE_SCHEMA ||
                                   '.c$pub_list_q(name, comp_ref) ' ||
                      ' values (:1, :2)';

Line: 120

      SELECT max(transaction_id) into g_last_tran_id
      FROM asg_system_dirty_queue
      WHERE client_id  = p_user_name;

Line: 131

    select sysdate into l_begin_date from dual;

Line: 136

    select sysdate into l_end_date from dual;

Line: 156

    select sysdate into l_begin_date from dual;

Line: 159

    l_query_string := 'SELECT count(*) ' ||
                      ' FROM mobileadmin.ctm$' ||p_pub_item ||
                      ' WHERE clid$$cs = :1 AND ' ||
                      '      tranid$$ > :2';

Line: 166

    select sysdate into l_end_date from dual;

Line: 192

    l_query_string := 'insert into ' || asg_base.G_OLITE_SCHEMA ||
                                   '.c$pub_list_q(name, comp_ref) ' ||
                      ' select publication_item, ''' || l_comp_ref || '''' ||
                      ' from ' || asg_base.G_OLITE_SCHEMA ||
                      '.c$all_client_items ' ||
                      ' where clientid = :1 ' ||
                      ' and publication_item in ' ||
                      '     (select name from asg_pub_item)';

Line: 207

      SELECT max(transaction_id) into g_last_tran_id
      FROM asg_system_dirty_queue
      WHERE client_id  = p_user_name;

Line: 220

    select sysdate into l_begin_date from dual;

Line: 225

    select sysdate into l_end_date from dual;

Line: 243

  l_select_pi_sqlstring   VARCHAR2(4000);

Line: 247

    l_select_pi_sqlstring :=
                  'SELECT name ' ||
                  'FROM ' || asg_base.G_OLITE_SCHEMA ||'.' ||'c$pub_list_q';

Line: 252

    DBMS_SQL.PARSE (l_cursor_id, l_select_pi_sqlstring, DBMS_SQL.v7);

Line: 274

    l_query_string := 'DELETE FROM ' || asg_base.G_OLITE_SCHEMA ||
                      '.c$pub_list_q';