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_POLICY_PUB SQL Statements

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

Line: 11


PROCEDURE INSERT_POLICY(
  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           OUT  NOCOPY    jtf_prefab_policies_b.policy_id%TYPE,
  p_policy_name         IN      jtf_prefab_policies_b.policy_name%TYPE,
  p_priority            IN      jtf_prefab_policies_b.priority%TYPE,
  p_description         IN      jtf_prefab_policies_tl.description%TYPE,
  p_enabled_flag        IN      jtf_prefab_policies_b.enabled_flag%TYPE,
  p_application_id      IN      jtf_prefab_policies_b.application_id%TYPE,
  p_all_applications_flag IN    jtf_prefab_policies_b.all_applications_flag%TYPE,
  p_depth               IN      jtf_prefab_policies_b.depth%TYPE,
  p_all_responsibilities_flag IN  jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
  p_all_users_flag      IN      jtf_prefab_policies_b.all_users_flag%TYPE,
  p_refresh_interval    IN      jtf_prefab_policies_b.refresh_interval%TYPE,
  p_interval_unit       IN      jtf_prefab_policies_b.interval_unit%TYPE,
  p_start_time          IN      jtf_prefab_policies_b.start_time%TYPE,
  p_end_time            IN      jtf_prefab_policies_b.end_time%TYPE,
  p_run_always_flag     IN      jtf_prefab_policies_b.run_always_flag%TYPE,

  p_object_version_number OUT  NOCOPY  jtf_prefab_policies_b.object_version_number%TYPE,

  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_POLICY';

Line: 44


          SELECT jtf_prefab_policies_b_s.NEXTVAL from dual;

Line: 47


        SAVEPOINT INSERT_POLICY;

Line: 75


        JTF_PREFAB_POLICIES_PKG.INSERT_ROW(l_row_id,
                                           p_policy_id,
                                           p_object_version_number,
                                           NULL,
                                           p_policy_name,
                                           p_priority,
                                           p_enabled_flag,
                                           p_application_id,
                                           p_all_applications_flag,
                                           p_depth,
                                           p_all_responsibilities_flag,
                                           p_all_users_flag,
                                           p_refresh_interval,
                                           p_interval_unit,
                                           p_start_time,
                                           p_end_time,
                                           p_run_always_flag,
                                           p_description,
                                           SYSDATE,
                                           G_USER_ID,
                                           SYSDATE,
                                           G_USER_ID,
                                           G_LOGIN_ID);

Line: 100


        INSERT INTO jtf_prefab_policies (policy_id,
                                         object_version_number,
                                         created_by,
                                         creation_date,
                                         last_updated_by,
                                         last_update_date,
                                         last_update_login,
                                         policy_name,
                                         application_id,
                                         -- security_group_id,
                                         priority,
                                         description,
                                         enabled_flag,
                                         application_id_col,
                                         all_applications_flag,
                                         depth,
                                         all_responsibilities_flag,
                                         all_users_flag,
                                         refresh_interval,
                                         interval_unit,
                                         start_time,
                                         end_time,
                                         run_always_flag)
        VALUES (p_policy_id,
                p_object_version_number,
                G_USER_ID,
                SYSDATE,
                G_USER_ID,
                SYSDATE,
                G_LOGIN_ID,
                p_policy_name,
                p_application_id,
                -- NULL,
                p_priority,
                p_description,
                p_enabled_flag,
                p_application_id_col,
                p_all_applications_flag,
                p_depth,
                p_all_responsibilities_flag,
                p_all_users_flag,
                p_refresh_interval,
                p_interval_unit,
                p_start_time,
                p_end_time,
                p_run_always_flag);

Line: 163


                ROLLBACK TO INSERT_POLICY;

Line: 171


                ROLLBACK TO INSERT_POLICY;

Line: 179


                ROLLBACK TO INSERT_POLICY;

Line: 190


END INSERT_POLICY;

Line: 192


PROCEDURE UPDATE_POLICY(
  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_policies_b.policy_id%TYPE,
  p_policy_name         IN      jtf_prefab_policies_b.policy_name%TYPE,
  p_priority            IN      jtf_prefab_policies_b.priority%TYPE,
  p_description         IN      jtf_prefab_policies_tl.description%TYPE,
  p_enabled_flag        IN      jtf_prefab_policies_b.enabled_flag%TYPE,
  p_application_id      IN      jtf_prefab_policies_b.application_id%TYPE,
  p_all_applications_flag IN      jtf_prefab_policies_b.all_applications_flag%TYPE,
  p_depth               IN      jtf_prefab_policies_b.depth%TYPE,
  p_all_responsibilities_flag IN  jtf_prefab_policies_b.all_responsibilities_flag%TYPE,
  p_all_users_flag      IN      jtf_prefab_policies_b.all_users_flag%TYPE,
  p_refresh_interval    IN      jtf_prefab_policies_b.refresh_interval%TYPE,
  p_interval_unit       IN      jtf_prefab_policies_b.interval_unit%TYPE,
  p_start_time          IN      jtf_prefab_policies_b.start_time%TYPE,
  p_end_time            IN      jtf_prefab_policies_b.end_time%TYPE,
  p_run_always_flag     IN      jtf_prefab_policies_b.run_always_flag%TYPE,

  p_object_version_number IN OUT  NOCOPY  jtf_prefab_policies_b.object_version_number%TYPE,

  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)   := 'UPDATE_POLICY';

Line: 225


        SAVEPOINT UPDATE_POLICY;

Line: 248


        JTF_PREFAB_POLICIES_PKG.UPDATE_ROW(p_policy_id,
                                           p_object_version_number,
                                           NULL,
                                           p_policy_name,
                                           p_priority,
                                           p_enabled_flag,
                                           p_application_id,
                                           p_all_applications_flag,
                                           p_depth,
                                           p_all_responsibilities_flag,
                                           p_all_users_flag,
                                           p_refresh_interval,
                                           p_interval_unit,
                                           p_start_time,
                                           p_end_time,
                                           p_run_always_flag,
                                           p_description,
                                           SYSDATE,
                                           G_USER_ID,
                                           G_LOGIN_ID);

Line: 270


        UPDATE jtf_prefab_policies
        SET object_version_number = p_object_version_number,
            last_updated_by = G_USER_ID,
            last_update_date = SYSDATE,
            last_update_login = G_LOGIN_ID,
            policy_name = p_policy_name,
            application_id = p_application_id,
            priority = p_priority,
            description = p_description,
            enabled_flag = p_enabled_flag,
            all_applications_flag = p_all_applications_flag,
            depth = p_depth,
            all_responsibilities_flag = p_all_responsibilities_flag,
            all_users_flag = p_all_users_flag,
            refresh_interval = p_refresh_interval,
            interval_unit = p_interval_unit,
            start_time = p_start_time,
            end_time = p_end_time,
            run_always_flag = p_run_always_flag
        WHERE policy_id = p_policy_id;

Line: 307


                ROLLBACK TO UPDATE_POLICY;

Line: 315


                ROLLBACK TO UPDATE_POLICY;

Line: 323


                ROLLBACK TO UPDATE_POLICY;

Line: 334


END UPDATE_POLICY;

Line: 336


procedure DELETE_POLICY(
  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_policies_b.policy_id%TYPE,

  p_object_version_number IN    jtf_prefab_policies_b.object_version_number%TYPE,

  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_POLICY';

Line: 354


        SAVEPOINT DELETE_POLICY;

Line: 377


        JTF_PREFAB_POLICIES_PKG.DELETE_ROW(p_policy_id);

Line: 380


        DELETE FROM jtf_prefab_policies
        WHERE policy_id = p_policy_id;

Line: 399


                ROLLBACK TO DELETE_POLICY;

Line: 407


                ROLLBACK TO DELETE_POLICY;

Line: 415


                ROLLBACK TO DELETE_POLICY;

Line: 426


END DELETE_POLICY;

Line: 428


PROCEDURE INSERT_UR_POLICY(
  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_ur_policies.policy_id%TYPE,
  p_userresp_id         IN      jtf_prefab_ur_policies.userresp_id%TYPE,
  p_userresp_type       IN      jtf_prefab_ur_policies.userresp_type%TYPE,

  p_object_version_number OUT  NOCOPY  jtf_prefab_ur_policies.object_version_number%TYPE,

  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_UR_POLICY';

Line: 449


        SAVEPOINT INSERT_UR_POLICY;

Line: 473


        INSERT INTO jtf_prefab_ur_policies (ur_policy_id,
                                            object_version_number,
                                            created_by,
                                            creation_date,
                                            last_updated_by,
                                            last_update_date,
                                            last_update_login,
                                            -- security_group_id,
                                            policy_id,
                                            userresp_id,
                                            userresp_type)
        VALUES (jtf_prefab_ur_policies_s.NEXTVAL,
                p_object_version_number,
                G_USER_ID,
                SYSDATE,
                G_USER_ID,
                SYSDATE,
                G_LOGIN_ID,
                -- NULL,
                p_policy_id,
                p_userresp_id,
                p_userresp_type);

Line: 511


                ROLLBACK TO INSERT_UR_POLICY;

Line: 519


                ROLLBACK TO INSERT_UR_POLICY;

Line: 527


                ROLLBACK TO INSERT_UR_POLICY;

Line: 538


END INSERT_UR_POLICY;

Line: 540


PROCEDURE DELETE_UR_POLICY (
  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_ur_policies.policy_id%TYPE,
  p_userresp_id         IN      jtf_prefab_ur_policies.userresp_id%TYPE,
  p_userresp_type       IN      jtf_prefab_ur_policies.userresp_type%TYPE,

  p_object_version_number IN    jtf_prefab_ur_policies.object_version_number%TYPE,

  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_UR_POLICY';

Line: 560


        SAVEPOINT DELETE_UR_POLICY;

Line: 583


        DELETE FROM jtf_prefab_ur_policies
        WHERE policy_id = p_policy_id
        AND   userresp_id = p_userresp_id
        AND   userresp_type = p_userresp_type;

Line: 603


                ROLLBACK TO DELETE_UR_POLICY;

Line: 611


                ROLLBACK TO DELETE_UR_POLICY;

Line: 619


                ROLLBACK TO DELETE_UR_POLICY;

Line: 630


END DELETE_UR_POLICY;

Line: 632


PROCEDURE DELETE_UR_POLICY (
  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_ur_policies.policy_id%TYPE,

  p_object_version_number IN    jtf_prefab_ur_policies.object_version_number%TYPE,

  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_UR_POLICY';

Line: 650


        SAVEPOINT DELETE_UR_POLICY;

Line: 673


        DELETE FROM jtf_prefab_ur_policies
        WHERE policy_id = p_policy_id;

Line: 691


                ROLLBACK TO DELETE_UR_POLICY;

Line: 699


                ROLLBACK TO DELETE_UR_POLICY;

Line: 707


                ROLLBACK TO DELETE_UR_POLICY;

Line: 718


END DELETE_UR_POLICY;

Line: 769


        UPDATE jtf_prefab_sys_policies
        SET object_version_number = p_object_version_number,
            last_updated_by = G_USER_ID,
            last_update_date = SYSDATE,
            last_update_login = G_LOGIN_ID,
            start_flag = p_start_flag,
            cpu = p_cpu,
            memory = p_memory,
            disk_location = p_disk_location,
            max_concurrency = p_max_concurrency,
            use_load_balancer_flag = p_use_load_balancer_flag,
            load_balancer_url = p_load_balancer_url,
            refresh_flag = p_refresh_flag,
            interceptor_enabled_flag = p_interceptor_enabled_flag,
            cache_memory = p_cache_memory;

Line: 788


          INSERT INTO jtf_prefab_sys_policies (sys_policy_id,
                                               object_version_number,
                                               created_by,
                                               creation_date,
                                               last_updated_by,
                                               last_update_date,
                                               last_update_login,
                                               -- security_group_id,
                                               start_flag,
                                               cpu,
                                               memory,
                                               disk_location,
                                               max_concurrency,
                                               use_load_balancer_flag,
                                               load_balancer_url,
                                               refresh_flag,
                                               interceptor_enabled_flag,
                                               cache_memory)
          VALUES (jtf_prefab_sys_policies_s.NEXTVAL,
                  p_object_version_number,
                  G_USER_ID,
                  SYSDATE,
                  G_USER_ID,
                  SYSDATE,
                  G_LOGIN_ID,
                  -- NULL,
                  p_start_flag,
                  p_cpu,
                  p_memory,
                  p_disk_location,
                  p_max_concurrency,
                  p_use_load_balancer_flag,
                  p_load_balancer_url,
                  p_refresh_flag,
                  p_interceptor_enabled_flag,
                  p_cache_memory);

Line: 870


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

  p_wsh_po_id           OUT  NOCOPY    jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
  p_hostname            IN      jtf_prefab_wsh_poes_b.hostname%TYPE,
  p_description         IN      jtf_prefab_wsh_poes_tl.description%TYPE,
  p_weight              IN      jtf_prefab_wsh_poes_b.weight%TYPE,
  p_load_pick_up_flag   IN      jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
  p_cache_size          IN      jtf_prefab_wsh_poes_b.cache_size%TYPE,
  p_wsh_type            IN      jtf_prefab_wsh_poes_b.wsh_type%TYPE,
  p_prefab_enabled_flag IN      jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,

  p_object_version_number OUT  NOCOPY  jtf_prefab_wsh_poes_b.object_version_number%TYPE,

  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_WSH_POLICY';

Line: 896


          SELECT jtf_prefab_wsh_poes_b_s.NEXTVAL from dual;

Line: 899


        SAVEPOINT INSERT_WSH_POLICY;

Line: 927


        JTF_PREFAB_WSH_POES_PKG.INSERT_ROW(l_row_id,
                                               p_wsh_po_id,
                                               p_object_version_number,
                                               NULL,
                                               p_hostname,
                                               p_weight,
                                               p_load_pick_up_flag,
                                               p_cache_size,
                                               p_wsh_type,
                                               p_prefab_enabled_flag,
                                               p_description,
                                               SYSDATE,
                                               G_USER_ID,
                                               SYSDATE,
                                               G_USER_ID,
                                               G_LOGIN_ID);

Line: 944


        INSERT INTO jtf_prefab_wsh_policies(wsh_policy_id,
                                            object_version_number,
                                            created_by,
                                            creation_date,
                                            last_updated_by,
                                            last_update_date,
                                            last_update_login,
                                            -- security_group_id,
                                            hostname,
                                            description,
                                            weight,
                                            load_pick_up_flag,
                                            prefab_enable_flag,
                                            prefetch_enable_flag,
                                            cache_enable_flag,
                                            cache_size,
                                            wsh_type)
        VALUES (p_wsh_policy_id,
                p_object_version_number,
                G_USER_ID,
                SYSDATE,
                G_USER_ID,
                SYSDATE,
                G_LOGIN_ID,
                -- NULL,
                p_hostname,
                p_description,
                p_weight,
                p_load_pick_up_flag,
                p_prefab_enable_flag,
                p_prefetch_enable_flag,
                p_cache_enable_flag,
                p_cache_size,
                p_wsh_type);

Line: 995


                ROLLBACK TO INSERT_WSH_POLICY;

Line: 1003


                ROLLBACK TO INSERT_WSH_POLICY;

Line: 1011


                ROLLBACK TO INSERT_WSH_POLICY;

Line: 1022


END INSERT_WSH_POLICY;

Line: 1024


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

  p_wsh_po_id           IN      jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,
  p_hostname            IN      jtf_prefab_wsh_poes_b.hostname%TYPE,
  p_description         IN      jtf_prefab_wsh_poes_tl.description%TYPE,
  p_weight              IN      jtf_prefab_wsh_poes_b.weight%TYPE,
  p_load_pick_up_flag   IN      jtf_prefab_wsh_poes_b.load_pick_up_flag%TYPE,
  p_cache_size          IN      jtf_prefab_wsh_poes_b.cache_size%TYPE,
  p_wsh_type            IN      jtf_prefab_wsh_poes_b.wsh_type%TYPE,
  p_prefab_enabled_flag IN      jtf_prefab_wsh_poes_b.prefab_enabled_flag%TYPE,

  p_object_version_number IN OUT  NOCOPY jtf_prefab_wsh_poes_b.object_version_number%TYPE,

  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)   := 'UPDATE_WSH_POLICY';

Line: 1050


        SAVEPOINT UPDATE_WSH_POLICY;

Line: 1072


        JTF_PREFAB_WSH_POES_PKG.UPDATE_ROW(p_wsh_po_id,
                                               p_object_version_number,
                                               NULL,
                                               p_hostname,
                                               p_weight,
                                               p_load_pick_up_flag,
                                               p_cache_size,
                                               p_wsh_type,
                                               p_prefab_enabled_flag,
                                               p_description,
                                               SYSDATE,
                                               G_USER_ID,
                                               G_LOGIN_ID);

Line: 1086


        UPDATE jtf_prefab_wsh_policies
        SET object_version_number = p_object_version_number,
            last_updated_by = G_USER_ID,
            last_update_date = SYSDATE,
            last_update_login = G_LOGIN_ID,
            description= p_description,
            weight = p_weight,
            load_pick_up_flag = p_load_pick_up_flag,
            prefab_enable_flag = p_prefab_enable_flag,
            prefetch_enable_flag = p_prefetch_enable_flag,
            cache_enable_flag = p_cache_enable_flag,
            cache_size = p_cache_size,
            wsh_type = p_wsh_type
        WHERE wsh_policy_id = p_wsh_policy_id;

Line: 1117


                ROLLBACK TO UPDATE_WSH_POLICY;

Line: 1125


                ROLLBACK TO UPDATE_WSH_POLICY;

Line: 1133


                ROLLBACK TO UPDATE_WSH_POLICY;

Line: 1144


END UPDATE_WSH_POLICY;

Line: 1146


procedure DELETE_WSH_POLICY(
  p_api_version         IN      NUMBER,
  p_init_msg_list       IN      VARCHAR2        := FND_API.G_FALSE,
  p_commit              IN      VARCHAR2        := FND_API.G_FALSE,

  p_wsh_po_id           IN      jtf_prefab_wsh_poes_b.wsh_po_id%TYPE,

  p_object_version_number IN    jtf_prefab_wsh_poes_b.object_version_number%TYPE,

  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_WSH_POLICY';

Line: 1164


        SAVEPOINT DELETE_WSH_POLICY;

Line: 1187


        JTF_PREFAB_WSH_POES_PKG.DELETE_ROW(p_wsh_po_id);

Line: 1190


        DELETE FROM jtf_prefab_wsh_policies
        WHERE wsh_policy_id = p_wsh_policy_id;

Line: 1194


        JTF_PREFAB_CACHE_PUB.DELETE_HOST_APPS_FOR_HOST(p_api_version,
                                                       p_init_msg_list,
                                                       p_commit,
                                                       p_wsh_po_id,
                                                       p_object_version_number,
                                                       x_return_status,
                                                       x_msg_count,
                                                       x_msg_data);

Line: 1218


                ROLLBACK TO DELETE_WSH_POLICY;

Line: 1226


                ROLLBACK TO DELETE_WSH_POLICY;

Line: 1234


                ROLLBACK TO DELETE_WSH_POLICY;

Line: 1245


END DELETE_WSH_POLICY;

Line: 1247


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

  p_wsh_po_id           IN      jtf_prefab_wshp_policies.wsh_po_id%TYPE,
  p_port                IN      jtf_prefab_wshp_policies.port%TYPE,

  p_object_version_number OUT  NOCOPY  jtf_prefab_wshp_policies.object_version_number%TYPE,

  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_WSHP_POLICY';

Line: 1267


        SAVEPOINT INSERT_WSHP_POLICY;

Line: 1291


        INSERT INTO jtf_prefab_wshp_policies (wshp_policy_id,
                                              object_version_number,
                                              created_by,
                                              creation_date,
                                              last_updated_by,
                                              last_update_date,
                                              last_update_login,
                                              -- security_group_id,
                                              wsh_po_id,
                                              port)
        VALUES (jtf_prefab_wshp_policies_s.NEXTVAL,
                p_object_version_number,
                G_USER_ID,
                SYSDATE,
                G_USER_ID,
                SYSDATE,
                G_LOGIN_ID,
                -- NULL,
                p_wsh_po_id,
                p_port);

Line: 1327


                ROLLBACK TO INSERT_WSHP_POLICY;

Line: 1335


                ROLLBACK TO INSERT_WSHP_POLICY;

Line: 1343


                ROLLBACK TO INSERT_WSHP_POLICY;

Line: 1354


END INSERT_WSHP_POLICY;

Line: 1356


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

  p_wsh_po_id           IN      jtf_prefab_wshp_policies.wsh_po_id%TYPE,
  p_port                IN      jtf_prefab_wshp_policies.port%TYPE,

  p_object_version_number IN    jtf_prefab_wshp_policies.object_version_number%TYPE,

  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_WSHP_POLICY';

Line: 1375


        SAVEPOINT DELETE_WSHP_POLICY;

Line: 1398


        DELETE FROM jtf_prefab_wshp_policies
        WHERE wsh_po_id = p_wsh_po_id
        AND   port = p_port;

Line: 1417


                ROLLBACK TO DELETE_WSHP_POLICY;

Line: 1425


                ROLLBACK TO DELETE_WSHP_POLICY;

Line: 1433


                ROLLBACK TO DELETE_WSHP_POLICY;

Line: 1444


END DELETE_WSHP_POLICY;

Line: 1446


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

  p_wsh_po_id           IN      jtf_prefab_wshp_policies.wsh_po_id%TYPE,

  p_object_version_number IN    jtf_prefab_wshp_policies.object_version_number%TYPE,

  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_WSHP_POLICY';

Line: 1464


        SAVEPOINT DELETE_WSHP_POLICY;

Line: 1487


        DELETE FROM jtf_prefab_wshp_policies
        WHERE wsh_po_id = p_wsh_po_id;

Line: 1505


                ROLLBACK TO DELETE_WSHP_POLICY;

Line: 1513


                ROLLBACK TO DELETE_WSHP_POLICY;

Line: 1521


                ROLLBACK TO DELETE_WSHP_POLICY;

Line: 1532


END DELETE_WSHP_POLICY;