APPS.AS_UTILITY_PVT SQL Statements

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

Line: 386

        SELECT  application_id
        FROM    fnd_application_vl
        WHERE   application_short_name = x_short_name;

Line: 391

        SELECT  msg.message_number
        FROM    fnd_new_messages msg, fnd_languages_vl lng
        WHERE   msg.message_name = x_msg
          and   msg.application_id = x_id
          and   lng.LANGUAGE_CODE = msg.language_code
          and   lng.language_id = x_lang_id;

Line: 831

   UPDATE as_conc_request_messages
     SET index_text = p_indRec.indSql
     WHERE index_name = p_indRec.index_name
     AND index_owner = p_indRec.index_owner;

Line: 837

        INSERT INTO as_conc_request_messages
          (conc_request_message_id, creation_date, created_by, table_name, table_owner, index_name, index_owner, index_text)
        VALUES (AS_CONC_REQUEST_MESSAGES_S.nextval, sysdate, nvl(fnd_global.user_id,-1), p_indRec.tbl_name, p_indRec.tbl_owner, p_indRec.index_name,p_indRec.index_owner, p_indRec.indSql);

Line: 870

    SELECT col.column_position cp, decode(ind.uniqueness,'UNIQUE','UNIQUE ',null) uniq,
       ind.owner, col.index_name indname, col.column_name colname,
       ceil(ind.initial_extent/1048576) intext, ceil(nvl(ind.next_extent/1048576,1)) nextext,
       ind.min_extents minext, ind.max_extents maxext, nvl(ind.pct_increase,0) pct,
       nvl(ind.ini_trans,1) ini_trans, nvl(ind.max_trans,255) max_trans,
       nvl(ind.pct_free,20) pct_free, nvl(ind.freelists,1) freelists, ind.tablespace_name ts, ind.degree
    FROM dba_ind_columns  col, dba_indexes ind
    WHERE ind.table_owner = p_tbl_owner
    AND ind.table_name = p_tbl_name
    AND ind.index_type = 'NORMAL'
    AND col.index_owner = ind.owner
    AND col.index_name = ind.index_name
    AND ind.status = 'VALID'
    ORDER BY indname,cp;

Line: 886

    SELECT exp.column_position cp, decode(ind.uniqueness,'UNIQUE','UNIQUE ',null) uniq,
       ind.owner, exp.index_name indname, exp.column_expression colname,
       ceil(ind.initial_extent/1048576) intext, ceil(nvl(ind.next_extent/1048576,1)) nextext,
       ind.min_extents minext, ind.max_extents maxext, nvl(ind.pct_increase,0) pct,
       nvl(ind.ini_trans,1) ini_trans, nvl(ind.max_trans,255) max_trans,
       nvl(ind.pct_free,20) pct_free, nvl(ind.freelists,1) freelists, ind.tablespace_name ts, ind.degree
    FROM dba_ind_expressions exp, dba_indexes ind
    WHERE ind.table_owner =  p_tbl_owner
    AND ind.table_name = p_tbl_name
    AND ind.index_type = 'FUNCTION-BASED NORMAL'
    AND exp.index_owner = ind.owner
    AND exp.index_name = ind.index_name
    AND ind.status = 'VALID'
    ORDER BY indname,cp;

Line: 944

    SELECT index_name indname, index_owner owner, index_text indSql
    FROM as_conc_request_messages o
    WHERE table_name = p_tbl_name
    AND table_owner = p_tbl_owner
    AND NOT EXISTS (SELECT 'e' FROM dba_indexes i
                    WHERE i.index_name = o.index_name
                    AND i.owner = o.index_owner);

Line: 953

    SELECT index_name indname, index_owner owner, index_text indSql
    FROM as_conc_request_messages o
    WHERE table_name = p_tbl_name
    AND table_owner = p_tbl_owner
    AND EXISTS (SELECT 'e' FROM dba_indexes i
                    WHERE i.index_name = o.index_name
                    AND i.owner = o.index_owner);

Line: 976

      DELETE FROM as_conc_request_messages where table_name = p_table_name and table_owner = p_table_owner;