APPS.FEM_DATABASE_UTIL_PKG SQL Statements

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

Line: 206

         INSERT into fem_ddl_log
           (request_id,
            object_id,
            exec_seq,
            timestamp,
            procedure_name,
            status,
            sql_error_msg,
            sql_statement,
            created_by,
            creation_date,
            last_updated_by,
            last_update_date,
            last_update_login)
         VALUES
           (p_request_id,
            p_object_id,
            fem_ddl_log_s.nextval,
            TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'),
            p_proc_name,
            'S',
            NULL,
            v_command_short,
            c_user_id,
            SYSDATE,
            c_user_id,
            SYSDATE,
            c_login_id);

Line: 278

            INSERT into fem_ddl_log
              (request_id,
               object_id,
               exec_seq,
               timestamp,
               procedure_name,
               status,
               sql_error_msg,
               sql_statement,
               created_by,
               creation_date,
               last_updated_by,
               last_update_date,
               last_update_login)
            VALUES
              (p_request_id,
               p_object_id,
               fem_ddl_log_s.nextval,
               TO_CHAR(SYSDATE, 'YYYY-MM-DD HH24:MI:SS'),
               p_proc_name,
               'F',
               v_sqlerrm,
               v_command_short,
               c_user_id,
               SYSDATE,
               c_user_id,
               SYSDATE,
               c_login_id);

Line: 361

   SELECT table_name,table_owner
   INTO x_tab_name,x_tab_owner
   FROM user_synonyms
   WHERE synonym_name = p_syn_name;

Line: 717

   SELECT object_type_code
   INTO v_pb_object_type
   FROM fem_object_catalog_b
   WHERE object_id = v_pb_object_id;

Line: 759

      SELECT default_tablespace
      INTO v_tablespace
      FROM user_users
      WHERE username = USER;

Line: 781

      SELECT initial_extent
      INTO v_initial_extent
      FROM user_tablespaces
      WHERE tablespace_name = v_tablespace;

Line: 803

      SELECT next_extent
      INTO v_next_extent
      FROM user_tablespaces
      WHERE tablespace_name = v_tablespace;

Line: 829

   IF INSTR(UPPER(p_table_def), 'AS SELECT') > 0 THEN

   -- p_table_def is specified using the AS SELECT format
      v_sql_statement := 'CREATE TABLE ' || v_fnd_schema || '.' ||
                         p_table_name ||
                         v_physical_clause || p_table_def;

Line: 865

      INSERT INTO fem_pl_temp_objects
        (request_id,
         object_id,
         object_type,
         object_name,
         created_by,
         creation_date,
         last_updated_by,
         last_update_date,
         last_update_login)
      VALUES
        (p_request_id,
         p_object_id,
         'TABLE',
         p_table_name,
         c_user_id,
         SYSDATE,
         c_user_id,
         SYSDATE,
         c_login_id);

Line: 887

         UPDATE fem_pl_temp_objects
         SET created_by        = c_user_id,
             creation_date     = SYSDATE,
             last_updated_by   = c_user_id,
             last_update_date  = SYSDATE,
             last_update_login = c_login_id
         WHERE request_id  = p_request_id
           AND object_id   = p_object_id
           AND object_type = 'TABLE'
           AND object_name = p_table_name;

Line: 1076

   SELECT object_type_code
   INTO v_pb_object_type
   FROM fem_object_catalog_b
   WHERE object_id = v_pb_object_id;

Line: 1118

      SELECT default_tablespace
      INTO v_tablespace
      FROM user_users
      WHERE username = USER;

Line: 1140

      SELECT initial_extent
      INTO v_initial_extent
      FROM user_tablespaces
      WHERE tablespace_name = v_tablespace;

Line: 1162

      SELECT next_extent
      INTO v_next_extent
      FROM user_tablespaces
      WHERE tablespace_name = v_tablespace;

Line: 1223

      INSERT INTO fem_pl_temp_objects
        (request_id,
         object_id,
         object_type,
         object_name,
         created_by,
         creation_date,
         last_updated_by,
         last_update_date,
         last_update_login)
      VALUES
        (p_request_id,
         p_object_id,
         'INDEX',
         p_index_name,
         c_user_id,
         SYSDATE,
         c_user_id,
         SYSDATE,
         c_login_id);

Line: 1245

         UPDATE fem_pl_temp_objects
         SET created_by        = c_user_id,
             creation_date     = SYSDATE,
             last_updated_by   = c_user_id,
             last_update_date  = SYSDATE,
             last_update_login = c_login_id
         WHERE request_id = p_request_id
           AND object_id  = p_object_id
           AND object_type = 'INDEX'
           AND object_name = p_index_name;

Line: 1389

   SELECT object_type_code
   INTO v_pb_object_type
   FROM fem_object_catalog_b
   WHERE object_id = v_pb_object_id;

Line: 1440

      INSERT INTO fem_pl_temp_objects
        (request_id,
         object_id,
         object_type,
         object_name,
         created_by,
         creation_date,
         last_updated_by,
         last_update_date,
         last_update_login)
      VALUES
        (p_request_id,
         p_object_id,
         'VIEW',
         p_view_name,
         c_user_id,
         SYSDATE,
         c_user_id,
         SYSDATE,
         c_login_id);

Line: 1462

         UPDATE fem_pl_temp_objects
         SET created_by        = c_user_id,
             creation_date     = SYSDATE,
             last_updated_by   = c_user_id,
             last_update_date  = SYSDATE,
             last_update_login = c_login_id
         WHERE request_id = p_request_id
           AND object_id  = p_object_id
           AND object_type = 'VIEW'
           AND object_name = p_view_name;

Line: 1580

      SELECT object_type, object_name
      FROM fem_pl_temp_objects
      WHERE request_id = p_request_id
        AND object_id  = p_object_id
        AND object_type = cp_obj_type
      ORDER BY object_name;

Line: 1622

   SELECT object_type_code
   INTO v_pb_object_type
   FROM fem_object_catalog_b
   WHERE object_id = v_pb_object_id;

Line: 1691

   DELETE FROM fem_pl_temp_objects tobj
   WHERE request_id  = p_request_id
     AND object_id   = p_object_id
     AND object_type = 'VIEW'
     AND NOT EXISTS
        (SELECT NULL
         FROM user_views
         WHERE view_name = tobj.object_name);

Line: 1736

   DELETE FROM fem_pl_temp_objects tobj
   WHERE request_id  = p_request_id
     AND object_id   = p_object_id
     AND object_type = 'INDEX'
     AND NOT EXISTS
        (SELECT NULL
         FROM user_indexes
         WHERE index_name = tobj.object_name);

Line: 1809

   DELETE FROM fem_pl_temp_objects tobj
   WHERE request_id  = p_request_id
     AND object_id   = p_object_id
     AND object_type = 'TABLE'
     AND NOT EXISTS
        (SELECT NULL
         FROM user_tables
         WHERE table_name = tobj.object_name);