DBA Data[Home] [Help]

APPS.OKL_IRK_PVT SQL Statements

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

Line: 101

    SELECT
            ID,
            RANKING_SEQ,
            OBJECT_VERSION_NUMBER,
            DATE_FROM,
            DATE_TO,
            ISU_ID,
            IC_CODE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Insurer_Rankings_V
     WHERE okl_insurer_rankings_v.id = p_id;
Line: 164

              l_irkv_rec.last_updated_by,
              l_irkv_rec.last_update_date,
              l_irkv_rec.last_update_login;
Line: 208

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            RANKING_SEQ,
            DATE_FROM,
            DATE_TO,
            ISU_ID,
            IC_CODE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Insurer_Rankings
     WHERE okl_insurer_rankings.id = p_id;
Line: 271

              l_irk_rec.last_updated_by,
              l_irk_rec.last_update_date,
              l_irk_rec.last_update_login;
Line: 390

    IF (l_irkv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_irkv_rec.last_updated_by := NULL;
Line: 393

    IF (l_irkv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_irkv_rec.last_update_date := NULL;
Line: 396

    IF (l_irkv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_irkv_rec.last_update_login := NULL;
Line: 751

            SELECT 'x'
       FROM OKX_COUNTRIES_V
       WHERE id1 = p_irkv_rec.ic_code;
Line: 755

      SELECT 'x'
        FROM OKX_INS_PROVIDER_V
       WHERE OKX_INS_PROVIDER_V.PARTY_ID = p_isu_id;
Line: 760

      SELECT 'x'
        FROM okl_insurer_rankings
       WHERE okl_insurer_rankings.id <> p_irkv_rec.id
         and  okl_insurer_rankings.ic_code = p_irkv_rec.ic_code
	  AND	  okl_insurer_rankings.RANKING_SEQ = p_irkv_rec.RANKING_SEQ
    And    okl_insurer_rankings.date_from <= p_irkv_rec.date_from
    AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
Line: 771

    SELECT 'x'
    FROM okl_insurer_rankings
    WHERE okl_insurer_rankings.id <> p_irkv_rec.id
    AND  okl_insurer_rankings.ic_code = p_irkv_rec.ic_code
    AND  okl_insurer_rankings.ISU_ID = p_irkv_rec.ISU_ID
    And    okl_insurer_rankings.date_from <= p_irkv_rec.date_from
    AND ( p_irkv_rec.date_from <= nvl(okl_insurer_rankings.date_to,p_irkv_rec.date_from)) ;
Line: 967

        p_to.last_updated_by := p_from.last_updated_by;
Line: 968

        p_to.last_update_date := p_from.last_update_date;
Line: 969

        p_to.last_update_login := p_from.last_update_login;
Line: 1001

        p_to.last_updated_by := p_from.last_updated_by;
Line: 1002

        p_to.last_update_date := p_from.last_update_date;
Line: 1003

        p_to.last_update_login := p_from.last_update_login;
Line: 1249

      PROCEDURE insert_row(
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irk_rec                      IN irk_rec_type,
        x_irk_rec                      OUT NOCOPY irk_rec_type) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 1258

        l_api_name                     CONSTANT VARCHAR2(30) := 'B_insert_row';
Line: 1294

        INSERT INTO OKL_INSURER_RANKINGS(
          id,
          object_version_number,
          ranking_seq,
          date_from,
          date_to,
          isu_id,
          ic_code,
          attribute_category,
          attribute1,
          attribute2,
          attribute3,
          attribute4,
          attribute5,
          attribute6,
          attribute7,
          attribute8,
          attribute9,
          attribute10,
          attribute11,
          attribute12,
          attribute13,
          attribute14,
          attribute15,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_irk_rec.id,
          l_irk_rec.object_version_number,
          l_irk_rec.ranking_seq,
          l_irk_rec.date_from,
          l_irk_rec.date_to,
          l_irk_rec.isu_id,
          l_irk_rec.ic_code,
          l_irk_rec.attribute_category,
          l_irk_rec.attribute1,
          l_irk_rec.attribute2,
          l_irk_rec.attribute3,
          l_irk_rec.attribute4,
          l_irk_rec.attribute5,
          l_irk_rec.attribute6,
          l_irk_rec.attribute7,
          l_irk_rec.attribute8,
          l_irk_rec.attribute9,
          l_irk_rec.attribute10,
          l_irk_rec.attribute11,
          l_irk_rec.attribute12,
          l_irk_rec.attribute13,
          l_irk_rec.attribute14,
          l_irk_rec.attribute15,
          l_irk_rec.created_by,
          l_irk_rec.creation_date,
          l_irk_rec.last_updated_by,
          l_irk_rec.last_update_date,
          l_irk_rec.last_update_login);
Line: 1387

      END insert_row;
Line: 1391

      PROCEDURE insert_row(
        p_api_version                  IN NUMBER,
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irkv_rec                     IN irkv_rec_type,
        x_irkv_rec                     OUT NOCOPY irkv_rec_type) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 1401

        l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 1417

          l_irkv_rec.LAST_UPDATE_DATE := l_irkv_rec.CREATION_DATE;
Line: 1418

          l_irkv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1419

          l_irkv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1483

        insert_row(
          p_init_msg_list,
          l_return_status,
          x_msg_count,
          x_msg_data,
          l_irk_rec,
          lx_irk_rec
        );
Line: 1532

      END insert_row;
Line: 1536

      PROCEDURE insert_row(
        p_api_version                  IN NUMBER,
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irkv_tbl                     IN irkv_tbl_type,
        x_irkv_tbl                     OUT NOCOPY irkv_tbl_type,
        px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 1547

        l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
Line: 1561

              insert_row (
                p_api_version                  => p_api_version,
                p_init_msg_list                => OKC_API.G_FALSE,
                x_return_status                => l_error_rec.error_type,
                x_msg_count                    => l_error_rec.msg_count,
                x_msg_data                     => l_error_rec.msg_data,
                p_irkv_rec                     => p_irkv_tbl(i),
                x_irkv_rec                     => x_irkv_tbl(i));
Line: 1629

      END insert_row;
Line: 1634

      PROCEDURE insert_row(
        p_api_version                  IN NUMBER,
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irkv_tbl                     IN irkv_tbl_type,
        x_irkv_tbl                     OUT NOCOPY irkv_tbl_type) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 1644

        l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 1651

          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_irkv_tbl                     => p_irkv_tbl,
            x_irkv_tbl                     => x_irkv_tbl,
            px_error_tbl                   => l_error_tbl);
Line: 1693

      END insert_row;
Line: 1711

        SELECT OBJECT_VERSION_NUMBER
          FROM OKL_INSURER_RANKINGS
         WHERE ID = p_irk_rec.id
           AND OBJECT_VERSION_NUMBER = p_irk_rec.object_version_number
        FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1718

        SELECT OBJECT_VERSION_NUMBER
          FROM OKL_INSURER_RANKINGS
         WHERE ID = p_irk_rec.id;
Line: 1759

          OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1768

          OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 2048

      PROCEDURE update_row(
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irk_rec                      IN irk_rec_type,
        x_irk_rec                      OUT NOCOPY irk_rec_type) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 2057

        l_api_name                     CONSTANT VARCHAR2(30) := 'B_update_row';
Line: 2177

            IF (x_irk_rec.last_updated_by = OKC_API.G_MISS_NUM)
            THEN
              x_irk_rec.last_updated_by := l_irk_rec.last_updated_by;
Line: 2181

            IF (x_irk_rec.last_update_date = OKC_API.G_MISS_DATE)
            THEN
              x_irk_rec.last_update_date := l_irk_rec.last_update_date;
Line: 2185

            IF (x_irk_rec.last_update_login = OKC_API.G_MISS_NUM)
            THEN
              x_irk_rec.last_update_login := l_irk_rec.last_update_login;
Line: 2231

        UPDATE OKL_INSURER_RANKINGS
        SET OBJECT_VERSION_NUMBER = l_def_irk_rec.object_version_number,
            RANKING_SEQ = l_def_irk_rec.ranking_seq,
            DATE_FROM = l_def_irk_rec.date_from,
            DATE_TO = l_def_irk_rec.date_to,
            ISU_ID = l_def_irk_rec.isu_id,
            IC_CODE = l_def_irk_rec.ic_code,
            ATTRIBUTE_CATEGORY = l_def_irk_rec.attribute_category,
            ATTRIBUTE1 = l_def_irk_rec.attribute1,
            ATTRIBUTE2 = l_def_irk_rec.attribute2,
            ATTRIBUTE3 = l_def_irk_rec.attribute3,
            ATTRIBUTE4 = l_def_irk_rec.attribute4,
            ATTRIBUTE5 = l_def_irk_rec.attribute5,
            ATTRIBUTE6 = l_def_irk_rec.attribute6,
            ATTRIBUTE7 = l_def_irk_rec.attribute7,
            ATTRIBUTE8 = l_def_irk_rec.attribute8,
            ATTRIBUTE9 = l_def_irk_rec.attribute9,
            ATTRIBUTE10 = l_def_irk_rec.attribute10,
            ATTRIBUTE11 = l_def_irk_rec.attribute11,
            ATTRIBUTE12 = l_def_irk_rec.attribute12,
            ATTRIBUTE13 = l_def_irk_rec.attribute13,
            ATTRIBUTE14 = l_def_irk_rec.attribute14,
            ATTRIBUTE15 = l_def_irk_rec.attribute15,
            CREATED_BY = l_def_irk_rec.created_by,
            CREATION_DATE = l_def_irk_rec.creation_date,
            LAST_UPDATED_BY = l_def_irk_rec.last_updated_by,
            LAST_UPDATE_DATE = l_def_irk_rec.last_update_date,
            LAST_UPDATE_LOGIN = l_def_irk_rec.last_update_login
        WHERE ID = l_def_irk_rec.id;
Line: 2295

      END update_row;
Line: 2299

      PROCEDURE update_row(
        p_api_version                  IN NUMBER,
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irkv_rec                     IN irkv_rec_type,
        x_irkv_rec                     OUT NOCOPY irkv_rec_type) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 2309

        l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 2325

          l_irkv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2326

          l_irkv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2327

          l_irkv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2442

            IF (x_irkv_rec.last_updated_by = OKC_API.G_MISS_NUM)
            THEN
              x_irkv_rec.last_updated_by := l_db_irkv_rec.last_updated_by;
Line: 2446

            IF (x_irkv_rec.last_update_date = OKC_API.G_MISS_DATE)
            THEN
              x_irkv_rec.last_update_date := l_db_irkv_rec.last_update_date;
Line: 2450

            IF (x_irkv_rec.last_update_login = OKC_API.G_MISS_NUM)
            THEN
              x_irkv_rec.last_update_login := l_db_irkv_rec.last_update_login;
Line: 2540

        update_row(
          p_init_msg_list,
          l_return_status,
          x_msg_count,
          x_msg_data,
          l_irk_rec,
          lx_irk_rec
        );
Line: 2588

      END update_row;
Line: 2592

      PROCEDURE update_row(
        p_api_version                  IN NUMBER,
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irkv_tbl                     IN irkv_tbl_type,
        x_irkv_tbl                     OUT NOCOPY irkv_tbl_type,
        px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 2603

        l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
Line: 2617

              update_row (
                p_api_version                  => p_api_version,
                p_init_msg_list                => OKC_API.G_FALSE,
                x_return_status                => l_error_rec.error_type,
                x_msg_count                    => l_error_rec.msg_count,
                x_msg_data                     => l_error_rec.msg_data,
                p_irkv_rec                     => p_irkv_tbl(i),
                x_irkv_rec                     => x_irkv_tbl(i));
Line: 2685

      END update_row;
Line: 2690

      PROCEDURE update_row(
        p_api_version                  IN NUMBER,
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irkv_tbl                     IN irkv_tbl_type,
        x_irkv_tbl                     OUT NOCOPY irkv_tbl_type) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 2700

        l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 2707

          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_irkv_tbl                     => p_irkv_tbl,
            x_irkv_tbl                     => x_irkv_tbl,
            px_error_tbl                   => l_error_tbl);
Line: 2749

      END update_row;
Line: 2757

      PROCEDURE delete_row(
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irk_rec                      IN irk_rec_type) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 2765

        l_api_name                     CONSTANT VARCHAR2(30) := 'B_delete_row';
Line: 2780

        DELETE FROM OKL_INSURER_RANKINGS
         WHERE ID = p_irk_rec.id;
Line: 2816

      END delete_row;
Line: 2820

      PROCEDURE delete_row(
        p_api_version                  IN NUMBER,
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irkv_rec                     IN irkv_rec_type) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 2829

        l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 2853

        delete_row(
          p_init_msg_list,
          l_return_status,
          x_msg_count,
          x_msg_data,
          l_irk_rec
        );
Line: 2898

      END delete_row;
Line: 2902

      PROCEDURE delete_row(
        p_api_version                  IN NUMBER,
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irkv_tbl                     IN irkv_tbl_type,
        px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 2912

        l_api_name                     CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
Line: 2926

              delete_row (
                p_api_version                  => p_api_version,
                p_init_msg_list                => OKC_API.G_FALSE,
                x_return_status                => l_error_rec.error_type,
                x_msg_count                    => l_error_rec.msg_count,
                x_msg_data                     => l_error_rec.msg_data,
                p_irkv_rec                     => p_irkv_tbl(i));
Line: 2993

      END delete_row;
Line: 2998

      PROCEDURE delete_row(
        p_api_version                  IN NUMBER,
        p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
        x_return_status                OUT NOCOPY VARCHAR2,
        x_msg_count                    OUT NOCOPY NUMBER,
        x_msg_data                     OUT NOCOPY VARCHAR2,
        p_irkv_tbl                     IN irkv_tbl_type) IS

        l_api_version                  CONSTANT NUMBER := 1;
Line: 3007

        l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 3014

          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_irkv_tbl                     => p_irkv_tbl,
            px_error_tbl                   => l_error_tbl);
Line: 3055

      END delete_row;