APPS.BIM_UTL_PKG SQL Statements

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

Line: 92

    INSERT INTO
    bim_rep_history
       (creation_date,
        last_update_date,
        created_by,
        last_updated_by,
        object_last_updated_date,
        object,
        start_date,
        end_date)
 VALUES
       (sysdate,
        sysdate,
        l_user_id,
        l_user_id,
        sysdate,
        p_object,
        p_start_time,
        p_end_time);

Line: 114

   FND_MESSAGE.Set_Name ('AMS', 'AMS_REP_INSERT_ERROR');

Line: 168

    SELECT    i.tablespace, i.index_tablespace, u.oracle_username
    FROM      fnd_product_installations i, fnd_application a,
	      fnd_oracle_userid u
    WHERE     a.application_short_name = 'BIM'
    AND       a.application_id = i.application_id
    AND       u.oracle_id = i.oracle_id;

Line: 176

    SELECT    a.owner,a.index_name,b.table_name,a.uniqueness,b.column_name,
              b.column_position,a.pct_free,a.ini_trans,a.max_trans,
              a.initial_extent,a.next_extent,a.min_extents,a.max_extents,
              a.pct_increase
    FROM      all_ind_columns b, all_indexes a
    WHERE     a.index_name = b.index_name
    AND       a.owner = l_schema
    AND       a.owner = b.index_owner
    AND       b.table_name =upper(p_name)
    ORDER BY  a.index_name,b.column_position;

Line: 188

    SELECT   count(*)
    FROM     bim_all_indexes
    WHERE    table_name =upper(p_name);

Line: 238

   /* Insert the indexes parameters into bim_all_indexes. */

   j:=1;

Line: 253

    INSERT into bim_all_indexes (
       owner
      ,index_name
      ,table_name
      ,column_name
      ,index_tablespace
      ,pct_free
      ,ini_trans
      ,max_trans
      ,initial_extent
      ,next_extent
      ,min_extents
      ,max_extents
      ,pct_increase
      ,uniqueness)
      SELECT l_owner(j)
            ,l_index_name(j)
            ,l_index_table_name(j)
            ,l_col_num
            ,l_index_tablespace
            ,l_pct_free(j)
            ,l_ini_trans(j)
            ,l_max_trans(j)
            ,l_initial_extent(j)
            ,l_next_extent(j)
            ,l_min_extents(j)
            ,l_max_extents(j)
            ,l_pct_increase(j)
            ,is_unique
      FROM DUAL;

Line: 289

   ams_utility_pvt.write_conc_log('error inserting into bim_all_index:'||sqlerrm(sqlcode));

Line: 309

    SELECT uniqueness
    ,owner
    ,index_name
    ,table_name
    ,index_tablespace
    ,column_name
    ,pct_free
    ,ini_trans
    ,max_trans
    ,initial_extent
    ,next_extent
    ,min_extents
    ,max_extents
    ,pct_increase
    FROM bim_all_indexes
    WHERE table_name =UPPER(p_name);

Line: 327

    SELECT   count(*)
    FROM     bim_all_indexes
    WHERE    table_name =upper(p_name);

Line: 367

     DELETE bim_all_indexes where table_name =UPPER(p_table_name);