APPS.JTF_PREFAB_FILTER_PUB SQL Statements

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

Line: 11

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

  p_filter_id           OUT NOCOPY jtf_prefab_filters_b.filter_id%TYPE,
  p_filter_name         IN jtf_prefab_filters_b.filter_name%TYPE,
  p_application_id      IN jtf_prefab_filters_b.application_id%TYPE,
  p_description         IN jtf_prefab_filters_tl.description%TYPE,
  p_filter_string       IN jtf_prefab_filters_b.filter_string%TYPE,
  p_exclusion_flag      IN jtf_prefab_filters_b.exclusion_flag%TYPE,
  p_enabled_flag        IN jtf_prefab_filters_b.enabled_flag%TYPE,

  p_object_version_number OUT NOCOPY jtf_prefab_filters_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_FILTER';

Line: 36

          SELECT jtf_prefab_filters_b_s.NEXTVAL from dual;

Line: 39

        SAVEPOINT INSERT_FILTER;

Line: 67

        JTF_PREFAB_FILTERS_PKG.INSERT_ROW(l_row_id,
                                          p_filter_id,
                                          p_object_version_number,
                                          NULL,
                                          p_application_id,
                                          p_filter_name,
                                          p_filter_string,
                                          p_exclusion_flag,
                                          p_enabled_flag,
                                          p_description,
                                          SYSDATE,
                                          G_USER_ID,
                                          SYSDATE,
                                          G_USER_ID,
                                          G_LOGIN_ID);

Line: 83

        INSERT INTO jtf_prefab_filters (filter_id,
                                         object_version_number,
                                         created_by,
                                         creation_date,
                                         last_updated_by,
                                         last_update_date,
                                         last_update_login,
                                         security_group_id,
                                         filter_name,
                                         application_id,
                                         application_id_for_filter,
                                         description,
                                         filter_string,
                                         exclusion_flag,
                                         enabled_flag)
        VALUES (p_filter_id,
                p_object_version_number,
                G_USER_ID,
                SYSDATE,
                G_USER_ID,
                SYSDATE,
                G_LOGIN_ID,
                NULL,
                p_filter_name,
                p_application_id,
                p_application_id_for_filter,
                p_description,
                p_filter_string,
                p_exclusion_flag,
                p_enabled_flag);

Line: 130

                ROLLBACK TO INSERT_FILTER;

Line: 138

                ROLLBACK TO INSERT_FILTER;

Line: 146

                ROLLBACK TO INSERT_FILTER;

Line: 157

END INSERT_FILTER;

Line: 159

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

  p_filter_id           IN jtf_prefab_filters_b.filter_id%TYPE,
  p_filter_name         IN jtf_prefab_filters_b.filter_name%TYPE,
  p_application_id      IN jtf_prefab_filters_b.application_id%TYPE,
  p_description         IN jtf_prefab_filters_tl.description%TYPE,
  p_filter_string       IN jtf_prefab_filters_b.filter_string%TYPE,
  p_exclusion_flag      IN jtf_prefab_filters_b.exclusion_flag%TYPE,
  p_enabled_flag        IN jtf_prefab_filters_b.enabled_flag%TYPE,

  p_object_version_number IN OUT NOCOPY jtf_prefab_filters_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_FILTER';

Line: 184

        SAVEPOINT UPDATE_FILTER;

Line: 207

        JTF_PREFAB_FILTERS_PKG.UPDATE_ROW(p_filter_id,
                                          p_object_version_number,
                                          NULL,
                                          p_application_id,
                                          p_filter_name,
                                          p_filter_string,
                                          p_exclusion_flag,
                                          p_enabled_flag,
                                          p_description,
                                          SYSDATE,
                                          G_USER_ID,
                                          G_LOGIN_ID);

Line: 221

        UPDATE jtf_prefab_filters
        SET object_version_number = p_object_version_number,
            last_updated_by = G_USER_ID,
            last_update_date = SYSDATE,
            last_update_login = G_LOGIN_ID,
            filter_name = p_filter_name,
            application_id = p_application_id,
            application_id_for_filter = p_application_id_for_filter,
            description = p_description,
            filter_string = p_filter_string,
            exclusion_flag = p_exclusion_flag,
            enabled_flag = p_enabled_flag
        WHERE filter_id = p_filter_id;

Line: 251

                ROLLBACK TO UPDATE_FILTER;

Line: 259

                ROLLBACK TO UPDATE_FILTER;

Line: 267

                ROLLBACK TO UPDATE_FILTER;

Line: 278

END UPDATE_FILTER;

Line: 280

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

  p_filter_id           IN      jtf_prefab_filters_b.filter_id%TYPE,

  p_object_version_number IN    jtf_prefab_filters_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_FILTER';

Line: 299

        SAVEPOINT DELETE_FILTER;

Line: 322

        JTF_PREFAB_FILTERS_PKG.DELETE_ROW(p_filter_id);

Line: 325

        DELETE FROM jtf_prefab_filters
        WHERE filter_id = p_filter_id;

Line: 344

                ROLLBACK TO DELETE_FILTER;

Line: 352

                ROLLBACK TO DELETE_FILTER;

Line: 360

                ROLLBACK TO DELETE_FILTER;

Line: 371

END DELETE_FILTER;