APPS.JTF_FM_HISTORY_UTIL_PVT SQL Statements

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

Line: 9

 PROCEDURE delete_request_contents ( p_request_id    IN         NUMBER
                                   , x_return_status OUT NOCOPY VARCHAR2
                                   ) ;

Line: 13

 PROCEDURE delete_processed ( p_request_id    IN         NUMBER
                            , x_return_status OUT NOCOPY VARCHAR2
                            ) ;

Line: 17

 PROCEDURE delete_content_failures ( p_request_id    IN         NUMBER
                                   , x_return_status OUT NOCOPY VARCHAR2
                                   );

Line: 21

 PROCEDURE delete_email_stats ( p_request_id     IN         NUMBER
                              , x_return_status  OUT NOCOPY VARCHAR2
                              );

Line: 25

 PROCEDURE delete_request_history ( p_rowid          IN         ROWID
                                  , x_return_status  OUT NOCOPY VARCHAR2
                                  );

Line: 42

PROCEDURE DELETE_REQUEST_HISTORY(p_request_id   IN  NUMBER)
IS
BEGIN
DELETE  FROM JTF_FM_PROCESSED WHERE REQUEST_ID = p_request_id;

Line: 46

DELETE  FROM JTF_FM_REQUEST_CONTENTS WHERE REQUEST_ID = p_request_id;

Line: 47

DELETE  FROM JTF_FM_REQUEST_HISTORY WHERE HIST_REQ_ID = p_request_id;

Line: 51

END DELETE_REQUEST_HISTORY;

Line: 65

PROCEDURE delete_request_history_batch ( x_error_buffer     OUT NOCOPY VARCHAR2
                                       , x_return_code      OUT NOCOPY NUMBER
                                       , p_data_age         IN         NUMBER
                                       )
IS
CURSOR c_headers IS
       SELECT  hist_req_id request_id, ROWID, submit_dt_tm last_update_date
         FROM  jtf_fm_request_history_all
        WHERE  TRUNC(submit_dt_tm) <= TRUNC(SYSDATE) - p_data_age
     ORDER BY  hist_req_id ASC;

Line: 91

    l_message := 'Starting purging for request ID: '|| c_header_record.request_id ||' (Last Updated On: '|| TO_CHAR(c_header_record.last_update_date, 'DD-MON-RRRR') ||')';

Line: 95

      SAVEPOINT before_delete;

Line: 96

      delete_processed  ( p_request_id    => c_header_record.request_id
                        , x_return_status => l_return_status
                        );

Line: 105

      delete_request_contents ( p_request_id    => c_header_record.request_id
                              , x_return_status => l_return_status
                              );

Line: 115

      delete_content_failures ( p_request_id    => c_header_record.request_id
                              , x_return_status => l_return_status
                              );

Line: 125

      delete_email_stats ( p_request_id    => c_header_record.request_id
                         , x_return_status => l_return_status
                         );

Line: 134

      delete_request_history ( p_rowid         => c_header_record.rowid
                             , x_return_status => l_return_status
                             );

Line: 148

        ROLLBACK TO before_delete;

Line: 169

END delete_request_history_batch;

Line: 182

PROCEDURE delete_request_contents ( p_request_id    IN         NUMBER
                                  , x_return_status OUT NOCOPY VARCHAR2
                                  )
IS
l_message  VARCHAR2(4000);

Line: 189

  DELETE
    FROM  jtf_fm_request_contents
   WHERE  request_id = p_request_id  ;

Line: 203

END delete_request_contents ;

Line: 216

PROCEDURE delete_processed ( p_request_id    IN         NUMBER
                           , x_return_status OUT NOCOPY VARCHAR2
                           )
IS
l_count    NUMBER          DEFAULT 0;

Line: 223

  DELETE
    FROM  jtf_fm_processed
   WHERE  request_id = p_request_id  ;

Line: 237

END delete_processed ;

Line: 250

PROCEDURE delete_content_failures ( p_request_id    IN         NUMBER
                                  , x_return_status OUT NOCOPY VARCHAR2
                                  )
IS
l_count    NUMBER          DEFAULT 0;

Line: 257

  DELETE
    FROM  jtf_fm_content_failures
   WHERE  request_id = p_request_id  ;

Line: 271

END delete_content_failures ;

Line: 284

PROCEDURE delete_email_stats ( p_request_id     IN         NUMBER
                             , x_return_status  OUT NOCOPY VARCHAR2
                             )
IS
l_count    NUMBER          DEFAULT 0;

Line: 291

  DELETE
    FROM  jtf_fm_email_stats
   WHERE  request_id = p_request_id  ;

Line: 305

END delete_email_stats ;

Line: 318

PROCEDURE delete_request_history ( p_rowid          IN         ROWID
                                 , x_return_status  OUT NOCOPY VARCHAR2
                                 )
IS
l_count    NUMBER          DEFAULT 0;

Line: 325

  DELETE
    FROM  jtf_fm_request_history
   WHERE  ROWID = p_rowid;

Line: 339

END delete_request_history;

Line: 372

  UPDATE jtf_fm_request_history_all
  SET    purge_flag  = 'Y'
  WHERE  TRUNC(last_update_date) <= TRUNC(SYSDATE) - p_data_age
  ;

Line: 404

             SELECT  hist_req_id
             FROM    jtf_fm_request_history_all
             WHERE   purge_flag = 'Y'
             ORDER BY hist_req_id ASC;

Line: 419

            DELETE
            FROM   jtf_fm_request_contents
            WHERE  request_id = tab_request_id(i)
          ;

Line: 425

            DELETE
            FROM   jtf_fm_content_failures
            WHERE  request_id = tab_request_id(i)
          ;

Line: 431

            DELETE
            FROM   jtf_fm_email_stats
            WHERE  request_id = tab_request_id(i)
          ;

Line: 442

      DELETE
      FROM   jtf_fm_request_history_all
      WHERE  purge_flag = 'Y';

Line: 450

      DELETE
      FROM   jtf_fm_int_request_header
      WHERE  TRUNC(last_update_date) <= TRUNC(SYSDATE) - p_data_age
      ;

Line: 509

l_update_name          VARCHAR2(30);

Line: 534

  l_update_name := x_argument4;

Line: 542

    ad_parallel_updates_pkg.initialize_rowid_range
    (
      ad_parallel_updates_pkg.ROWID_RANGE
    , l_table_owner
    , l_table_name
    , l_update_name
    , x_worker_id
    , x_num_workers
    , x_batch_size
    , 0
    );

Line: 554

    ad_parallel_updates_pkg.get_rowid_range
    (
      l_start_rowid
    , l_end_rowid
    , l_any_rows_to_process
    , x_batch_size
    , TRUE
    );

Line: 565

      DELETE /*+ rowid(jfp) */
      FROM   jtf_fm_processed jtp
      WHERE  request_id IN ( SELECT /*+ index(jrh, jtf.jtf_fm_request_history_all_nu2) */ hist_req_id
                             FROM   jtf_fm_request_history_all jrh
                             WHERE  purge_flag = 'Y'
                            )
      AND ROWID BETWEEN l_start_rowid AND l_end_rowid
      ;

Line: 576

      ad_parallel_updates_pkg.processed_rowid_range
      (
        l_rows_processed
      , l_end_rowid
      );

Line: 584

      ad_parallel_updates_pkg.get_rowid_range
      (
        l_start_rowid
      , l_end_rowid
      , l_any_rows_to_process
      , x_batch_size
      , FALSE
      );