APPS.OKI_DBI_SCM_RSG_API_PVT SQL Statements

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

Line: 39

    SELECT version
      INTO l_version
      FROM v$instance;

Line: 118

  SELECT *
    FROM oki_dbi_indexes
   WHERE table_name = p_table_name;

Line: 123

  SELECT index_name
    FROM all_indexes
   WHERE table_name = p_table_name
   AND OWNER = p_owner;

Line: 132

  SELECT count(1)
    INTO l_index_exists
    FROM all_indexes
   WHERE table_name = p_table_name
   AND OWNER = p_owner;

Line: 138

  SELECT count(1)
    INTO l_rows
    FROM oki_dbi_indexes
   WHERE table_name = p_table_name;

Line: 155

    BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('Inserting Index definitions into oki_dbi_indexes - '
                                        || FND_DATE.Date_To_DisplayDt(sysdate));

Line: 158

      USING ( select table_name, index_name from all_indexes
              where table_name = p_table_name AND OWNER = p_owner ) s
      ON (b.index_name = s.index_name AND b.table_name = s.table_name)
      WHEN MATCHED THEN
         UPDATE
           SET create_stmt = DBMS_METADATA.Get_Ddl('INDEX', s.index_name)
      WHEN NOT MATCHED THEN
         INSERT
            (table_name,
             index_name,
             create_stmt,
             creation_date,
             created_by,
             last_update_date,
             last_updated_by,
             last_update_login)
          VALUES
          (p_table_name,
           s.index_name,
           DBMS_METADATA.Get_Ddl('INDEX', s.index_name),
           SYSDATE,
           -1,
           SYSDATE,
           -1,
           -1);

Line: 185

       BIS_BIA_RSG_CUSTOM_API_MGMNT.Log('FINISHED: Inserting Index definitions into oki_dbi_indexes for - '|| p_table_name
                                        || ',  ' || FND_DATE.Date_To_DisplayDt(sysdate));

Line: 218

    SELECT index_name,
           create_stmt
      FROM oki_dbi_indexes
     WHERE table_name = p_table_name;

Line: 224

    SELECT index_name
      FROM all_indexes
     WHERE table_name like p_table_name
     AND OWNER = p_owner   ;

Line: 261

  DELETE FROM oki_dbi_indexes
   WHERE table_name = p_table_name;