eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_PREFAB_STATISTICS_PUB SQL Statements

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

Line: 11


PROCEDURE INSERT_STATISTICS(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2        := FND_API.G_FALSE,

  p_policy_id           IN      jtf_prefab_statistics.policy_id%TYPE,
  p_wsh_po_id           IN      jtf_prefab_statistics.wsh_po_id%TYPE,
  p_start_time          IN      jtf_prefab_statistics.start_time%TYPE,
  p_end_time            IN      jtf_prefab_statistics.end_time%TYPE,
  p_last_update_time    IN      jtf_prefab_statistics.last_update_time%TYPE,
  p_pages_last_run      IN      jtf_prefab_statistics.pages_last_run%TYPE,
  p_pages_crawled       IN      jtf_prefab_statistics.pages_crawled%TYPE,
  p_refresh_rate        IN      jtf_prefab_statistics.refresh_rate%TYPE,
  p_system_status       IN      jtf_prefab_statistics.system_status%TYPE,
  p_error_status        IN      jtf_prefab_statistics.error_status%TYPE,
  p_depth               IN      jtf_prefab_statistics.depth%TYPE,
  p_disk_used           IN      jtf_prefab_statistics.disk_used%TYPE,
  p_avg_mem             IN      jtf_prefab_statistics.avg_mem%TYPE,
  p_avg_cpu             IN      jtf_prefab_statistics.avg_cpu%TYPE,
  p_hit_rate            IN      jtf_prefab_statistics.hit_rate%TYPE,

  p_object_version_number OUT  NOCOPY    NUMBER,

  x_return_status       OUT  NOCOPY     VARCHAR2,
  x_msg_count           OUT  NOCOPY     NUMBER,
  x_msg_data            OUT  NOCOPY     VARCHAR2
) AS
        -- local variables --
        l_api_name              CONSTANT VARCHAR2(30)   := 'INSERT_STATISTICS';

Line: 43


        CURSOR statistics_id IS SELECT jtf_prefab_statistics_s.NEXTVAL FROM sys.dual;

Line: 47


        SAVEPOINT INSERT_STATISTICS;

Line: 76


        INSERT INTO jtf_prefab_statistics (statistics_id,
                                             created_by,
                                             creation_date,
                                             last_updated_by,
                                             last_update_date,
                                             last_update_login,
                                             object_version_number,
                                             -- security_group_id,
                                             policy_id,
                                             wsh_po_id,
                                             start_time,
                                             end_time,
                                             last_update_time,
                                             pages_last_run,
                                             pages_crawled,
                                             refresh_rate,
                                             system_status,
                                             error_status,
                                             depth,
                                             disk_used,
                                             avg_mem,
                                             avg_cpu,
                                             hit_rate)
               VALUES (l_statistics_id,
                       G_USER_ID,
                       SYSDATE,
                       G_USER_ID,
                       SYSDATE,
                       G_LOGIN_ID,
                       p_object_version_number,
                       -- NULL,
                       p_policy_id,
                       p_wsh_po_id,
                       p_start_time,
                       p_end_time,
                       p_last_update_time,
                       p_pages_last_run,
                       p_pages_crawled,
                       p_refresh_rate,
                       p_system_status,
                       p_error_status,
                       p_depth,
                       p_disk_used,
                       p_avg_mem,
                       p_avg_cpu,
                       p_hit_rate);

Line: 138


                ROLLBACK TO INSERT_STATISTICS;

Line: 146


                ROLLBACK TO INSERT_STATISTICS;

Line: 154


                ROLLBACK TO INSERT_STATISTICS;

Line: 165


END INSERT_STATISTICS;

Line: 167


PROCEDURE UPDATE_STATISTICS(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2        := FND_API.G_FALSE,

  p_policy_id           IN      jtf_prefab_statistics.policy_id%TYPE,
  p_wsh_po_id           IN      jtf_prefab_statistics.wsh_po_id%TYPE,
  p_start_time          IN      jtf_prefab_statistics.start_time%TYPE,
  p_end_time            IN      jtf_prefab_statistics.end_time%TYPE,
  p_last_update_time    IN      jtf_prefab_statistics.last_update_time%TYPE,
  p_pages_last_run      IN      jtf_prefab_statistics.pages_last_run%TYPE,
  p_pages_crawled       IN      jtf_prefab_statistics.pages_crawled%TYPE,
  p_refresh_rate        IN      jtf_prefab_statistics.refresh_rate%TYPE,
  p_system_status       IN      jtf_prefab_statistics.system_status%TYPE,
  p_error_status        IN      jtf_prefab_statistics.error_status%TYPE,
  p_depth               IN      jtf_prefab_statistics.depth%TYPE,
  p_disk_used           IN      jtf_prefab_statistics.disk_used%TYPE,
  p_avg_mem             IN      jtf_prefab_statistics.avg_mem%TYPE,
  p_avg_cpu             IN      jtf_prefab_statistics.avg_cpu%TYPE,
  p_hit_rate            IN      jtf_prefab_statistics.hit_rate%TYPE,

  p_object_version_number IN OUT  NOCOPY     NUMBER,

  x_return_status       OUT  NOCOPY     VARCHAR2,
  x_msg_count           OUT  NOCOPY     NUMBER,
  x_msg_data            OUT  NOCOPY     VARCHAR2
) AS
        l_api_name              CONSTANT VARCHAR2(30)   := 'UPDATE_STATISTICS';

Line: 202


        SAVEPOINT UPDATE_STATISTICS;

Line: 225


        SELECT object_version_number INTO l_object_version
        FROM jtf_prefab_statistics
        WHERE application_id = p_application_id;

Line: 237


        UPDATE jtf_prefab_statistics
        SET last_updated_by = G_USER_ID,
            last_update_date = SYSDATE,
            last_update_login = G_LOGIN_ID,
            object_version_number = p_object_version_number,
            start_time = p_start_time,
            end_time = p_end_time,
            last_update_time = p_last_update_time,
            pages_last_run = p_pages_last_run,
            pages_crawled = p_pages_crawled,
            refresh_rate = p_refresh_rate,
            system_status = p_system_status,
            error_status = p_error_status,
            depth = p_depth,
            disk_used = p_disk_used,
            avg_mem = p_avg_mem,
            avg_cpu = p_avg_cpu,
            hit_rate = p_hit_rate
        WHERE policy_id = p_policy_id AND wsh_po_id = p_wsh_po_id;

Line: 272


                ROLLBACK TO UPDATE_STATISTICS;

Line: 280


                ROLLBACK TO UPDATE_STATISTICS;

Line: 288


                ROLLBACK TO UPDATE_STATISTICS;

Line: 299


END UPDATE_STATISTICS;

Line: 301


PROCEDURE DELETE_STATISTICS(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2        := FND_API.G_FALSE,

  p_policy_id           IN      NUMBER,
  p_wsh_po_id           IN      NUMBER,

  p_object_version_number      IN      NUMBER,

  x_return_status       OUT  NOCOPY     VARCHAR2,
  x_msg_count           OUT  NOCOPY     NUMBER,
  x_msg_data            OUT  NOCOPY     VARCHAR2
) AS
        l_api_name              CONSTANT VARCHAR2(30) := 'DELETE_STATISTICS';

Line: 321


        SAVEPOINT DELETE_STATISTICS;

Line: 344


        SELECT object_version_number INTO l_object_version
        FROM jtf_prefab_statistics
        WHERE application_id = p_application_id;

Line: 353


        DELETE FROM jtf_prefab_statistics
        WHERE policy_id = p_policy_id AND wsh_po_id = p_wsh_po_id;

Line: 371


                ROLLBACK TO DELETE_STATISTICS;

Line: 379


                ROLLBACK TO DELETE_STATISTICS;

Line: 387


                ROLLBACK TO DELETE_STATISTICS;

Line: 398


END DELETE_STATISTICS;

Line: 400


PROCEDURE SELECT_STATISTICS(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2        := FND_API.G_FALSE,

  p_policy_id           IN      jtf_prefab_statistics.policy_id%TYPE,
  p_wsh_po_id           IN      jtf_prefab_statistics.wsh_po_id%TYPE,
  p_start_time          OUT  NOCOPY     jtf_prefab_statistics.start_time%TYPE,
  p_end_time            OUT  NOCOPY     jtf_prefab_statistics.end_time%TYPE,
  p_last_update_time    OUT  NOCOPY     jtf_prefab_statistics.last_update_time%TYPE,
  p_pages_last_run      OUT  NOCOPY     jtf_prefab_statistics.pages_last_run%TYPE,
  p_pages_crawled       OUT  NOCOPY     jtf_prefab_statistics.pages_crawled%TYPE,
  p_refresh_rate        OUT  NOCOPY     jtf_prefab_statistics.refresh_rate%TYPE,
  p_system_status       OUT  NOCOPY     jtf_prefab_statistics.system_status%TYPE,
  p_error_status        OUT  NOCOPY     jtf_prefab_statistics.error_status%TYPE,
  p_depth               OUT  NOCOPY     jtf_prefab_statistics.depth%TYPE,
  p_disk_used           OUT  NOCOPY     jtf_prefab_statistics.disk_used%TYPE,
  p_avg_mem             OUT  NOCOPY     jtf_prefab_statistics.avg_mem%TYPE,
  p_avg_cpu             OUT  NOCOPY     jtf_prefab_statistics.avg_cpu%TYPE,
  p_hit_rate            OUT  NOCOPY     jtf_prefab_statistics.hit_rate%TYPE,

  p_object_version_number OUT  NOCOPY   NUMBER,
  p_row_count           OUT  NOCOPY     NUMBER,

  x_return_status       OUT  NOCOPY     VARCHAR2,
  x_msg_count           OUT  NOCOPY     NUMBER,
  x_msg_data            OUT  NOCOPY     VARCHAR2
) AS
        -- local variables --
        l_api_name              CONSTANT VARCHAR2(30)   := 'SELECT_STATISTICS';

Line: 433


        SAVEPOINT SELECT_STATISTICS;

Line: 456


        SELECT start_time, end_time, last_update_time,
               pages_last_run, pages_crawled, refresh_rate,
               system_status, error_status, depth, disk_used,
               avg_mem, avg_cpu, hit_rate,
               object_version_number
        INTO p_start_time, p_end_time, p_last_update_time,
               p_pages_last_run, p_pages_crawled, p_refresh_rate,
               p_system_status, p_error_status, p_depth, p_disk_used,
               p_avg_mem, p_avg_cpu, p_hit_rate,
               p_object_version_number
        FROM jtf_prefab_statistics
        WHERE policy_id = p_policy_id AND wsh_po_id = p_wsh_po_id;

Line: 486


                ROLLBACK TO SELECT_STATISTICS;

Line: 494


                ROLLBACK TO SELECT_STATISTICS;

Line: 502


                ROLLBACK TO SELECT_STATISTICS;

Line: 513


END SELECT_STATISTICS;