DBA Data[Home] [Help]

APPS.OKL_CLM_PVT SQL Statements

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

Line: 73

          select org_id
          from okl_ins_policies_b
          where id = p_id;
Line: 109

      DELETE FROM OKL_INS_CLAIMS_TL T
       WHERE NOT EXISTS (
          SELECT NULL
            FROM OKL_INS_CLAIMS_ALL_B  B        --fixed bug 3321017 by kmotepal
           WHERE B.ID =T.ID
          );
Line: 115

      UPDATE OKL_INS_CLAIMS_TL T SET(
          DESCRIPTION,
          POLICE_REPORT,
          COMMENTS) = (SELECT
                                    B.DESCRIPTION,
                                    B.POLICE_REPORT,
                                    B.COMMENTS
                                  FROM OKL_INS_CLAIMS_TL B
                                 WHERE B.ID = T.ID
                                   AND B.LANGUAGE = T.SOURCE_LANG)
        WHERE ( T.ID,
                T.LANGUAGE)
            IN (SELECT
                    SUBT.ID,
                    SUBT.LANGUAGE
                  FROM OKL_INS_CLAIMS_TL SUBB, OKL_INS_CLAIMS_TL SUBT
                 WHERE SUBB.ID = SUBT.ID
                   AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                   AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                        OR SUBB.POLICE_REPORT <> SUBT.POLICE_REPORT
                        OR SUBB.COMMENTS <> SUBT.COMMENTS
                        OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                        OR (SUBB.POLICE_REPORT IS NULL AND SUBT.POLICE_REPORT IS NOT NULL)
                        OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                ));
Line: 140

      INSERT INTO OKL_INS_CLAIMS_TL (
          ID,
          LANGUAGE,
          DESCRIPTION,
          POLICE_REPORT,
          COMMENTS,
          SOURCE_LANG,
          SFWT_FLAG,
          CREATED_BY,
          CREATION_DATE,
          LAST_UPDATED_BY,
          LAST_UPDATE_DATE,
          LAST_UPDATE_LOGIN)
        SELECT
              B.ID,
              L.LANGUAGE_CODE,
              B.DESCRIPTION,
              B.POLICE_REPORT,
              B.COMMENTS,
              B.SOURCE_LANG,
              B.SFWT_FLAG,
              B.CREATED_BY,
              B.CREATION_DATE,
              B.LAST_UPDATED_BY,
              B.LAST_UPDATE_DATE,
              B.LAST_UPDATE_LOGIN
          FROM OKL_INS_CLAIMS_TL B, FND_LANGUAGES L
         WHERE L.INSTALLED_FLAG IN ('I', 'B')
           AND B.LANGUAGE = USERENV('LANG')
           AND NOT EXISTS (
                      SELECT NULL
                        FROM OKL_INS_CLAIMS_TL T
                       WHERE T.ID = B.ID
                         AND T.LANGUAGE = L.LANGUAGE_CODE
                      );
Line: 184

      SELECT
              ID,
              OBJECT_VERSION_NUMBER,
              SFWT_FLAG,
              IPY_ID,
              LTP_CODE,
              CSU_CODE,
              CLAIM_NUMBER,
              CLAIM_DATE,
              LOSS_DATE,
              DESCRIPTION,
              POLICE_CONTACT,
              POLICE_REPORT,
              AMOUNT,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              HOLD_DATE,
              ORG_ID,
              REQUEST_ID,
              PROGRAM_APPLICATION_ID,
              PROGRAM_ID,
              PROGRAM_UPDATE_DATE,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okl_Ins_Claims_V
       WHERE okl_ins_claims_v.id  = p_id;
Line: 268

                l_clmv_rec.program_update_date,
                l_clmv_rec.created_by,
                l_clmv_rec.creation_date,
                l_clmv_rec.last_updated_by,
                l_clmv_rec.last_update_date,
                l_clmv_rec.last_update_login;
Line: 314

      SELECT
              ID,
              CLAIM_NUMBER,
              CSU_CODE,
              IPY_ID,
              LTP_CODE,
              PROGRAM_UPDATE_DATE,
              CLAIM_DATE,
              PROGRAM_ID,
              LOSS_DATE,
              POLICE_CONTACT,
              AMOUNT,
              OBJECT_VERSION_NUMBER,
              REQUEST_ID,
              PROGRAM_APPLICATION_ID,
              ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15,
              HOLD_DATE,
              ORG_ID,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okl_Ins_Claims_B
       WHERE okl_ins_claims_b.id  = p_id;
Line: 366

                l_clm_rec.program_update_date,
                l_clm_rec.claim_date,
                l_clm_rec.program_id,
                l_clm_rec.loss_date,
                l_clm_rec.police_contact,
                l_clm_rec.amount,
                l_clm_rec.object_version_number,
                l_clm_rec.request_id,
                l_clm_rec.program_application_id,
                l_clm_rec.attribute_category,
                l_clm_rec.attribute1,
                l_clm_rec.attribute2,
                l_clm_rec.attribute3,
                l_clm_rec.attribute4,
                l_clm_rec.attribute5,
                l_clm_rec.attribute6,
                l_clm_rec.attribute7,
                l_clm_rec.attribute8,
                l_clm_rec.attribute9,
                l_clm_rec.attribute10,
                l_clm_rec.attribute11,
                l_clm_rec.attribute12,
                l_clm_rec.attribute13,
                l_clm_rec.attribute14,
                l_clm_rec.attribute15,
                l_clm_rec.hold_date,
                l_clm_rec.org_id,
                l_clm_rec.created_by,
                l_clm_rec.creation_date,
                l_clm_rec.last_updated_by,
                l_clm_rec.last_update_date,
                l_clm_rec.last_update_login;
Line: 439

      SELECT
              ID,
              LANGUAGE,
              DESCRIPTION,
              POLICE_REPORT,
              COMMENTS,
              SOURCE_LANG,
              SFWT_FLAG,
              CREATED_BY,
              CREATION_DATE,
              LAST_UPDATED_BY,
              LAST_UPDATE_DATE,
              LAST_UPDATE_LOGIN
        FROM Okl_Ins_Claims_Tl
       WHERE okl_ins_claims_tl.id = p_id
         AND okl_ins_claims_tl.language = p_language;
Line: 472

                l_okl_ins_claims_tl_rec.last_updated_by,
                l_okl_ins_claims_tl_rec.last_update_date,
                l_okl_ins_claims_tl_rec.last_update_login;
Line: 618

      IF (l_clmv_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
        l_clmv_rec.program_update_date := NULL;
Line: 627

      IF (l_clmv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
        l_clmv_rec.last_updated_by := NULL;
Line: 630

      IF (l_clmv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
        l_clmv_rec.last_update_date := NULL;
Line: 633

      IF (l_clmv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
        l_clmv_rec.last_update_login := NULL;
Line: 755

        SELECT 'x'
        FROM OKL_INS_POLICIES_V
        WHERE id = p_ipy_id;
Line: 1183

          CURSOR okl_clmv_inav_fk_csr (      SELECT 'x'
            FROM Okl_Ins_Assets_V
           WHERE       l_okl_clmv_inav_fk
           okl_clmv_inav_fk_csr%ROWTYPE;
Line: 1188

          SELECT 'x'
            FROM Fnd_Common_Lookups
           WHERE fnd_common_lookups.lookup_code = p_lookup_code;
Line: 1251

        SELECT 'x'
        FROM   okl_ins_claims_v
        WHERE  ipy_id = p_clmv_rec.ipy_id
        AND    claim_number = p_clmv_rec.claim_number
        AND    ID <> p_clmv_rec.id;
Line: 1333

      p_to.program_update_date := p_from.program_update_date;
Line: 1362

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

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

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

      p_to.program_update_date := p_from.program_update_date;
Line: 1405

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

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

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

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

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

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

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

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

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

    PROCEDURE insert_row(
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clm_rec                      IN clm_rec_type,
      x_clm_rec                      OUT NOCOPY clm_rec_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 1686

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

      INSERT INTO OKL_INS_CLAIMS_B(
        id,
        claim_number,
        csu_code,
        ipy_id,
        ltp_code,
        program_update_date,
        claim_date,
        program_id,
        loss_date,
        police_contact,
        amount,
        object_version_number,
        request_id,
        program_application_id,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
        hold_date,
        org_id,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_clm_rec.id,
        l_clm_rec.claim_number,
        l_clm_rec.csu_code,
        l_clm_rec.ipy_id,
        l_clm_rec.ltp_code,
        l_clm_rec.program_update_date,
        l_clm_rec.claim_date,
        l_clm_rec.program_id,
        l_clm_rec.loss_date,
        l_clm_rec.police_contact,
        l_clm_rec.amount,
        l_clm_rec.object_version_number,
        l_clm_rec.request_id,
        l_clm_rec.program_application_id,
        l_clm_rec.attribute_category,
        l_clm_rec.attribute1,
        l_clm_rec.attribute2,
        l_clm_rec.attribute3,
        l_clm_rec.attribute4,
        l_clm_rec.attribute5,
        l_clm_rec.attribute6,
        l_clm_rec.attribute7,
        l_clm_rec.attribute8,
        l_clm_rec.attribute9,
        l_clm_rec.attribute10,
        l_clm_rec.attribute11,
        l_clm_rec.attribute12,
        l_clm_rec.attribute13,
        l_clm_rec.attribute14,
        l_clm_rec.attribute15,
        l_clm_rec.hold_date,
        l_clm_rec.org_id,
        l_clm_rec.created_by,
        l_clm_rec.creation_date,
        l_clm_rec.last_updated_by,
        l_clm_rec.last_update_date,
        l_clm_rec.last_update_login);
Line: 1835

    END insert_row;
Line: 1839

    PROCEDURE insert_row(
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_okl_ins_claims_tl_rec        IN okl_ins_claims_tl_rec_type,
      x_okl_ins_claims_tl_rec        OUT NOCOPY okl_ins_claims_tl_rec_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 1847

      l_api_name                     CONSTANT VARCHAR2(30) := 'TL_insert_row';
Line: 1852

        SELECT *
          FROM FND_LANGUAGES
         WHERE INSTALLED_FLAG IN ('I', 'B');
Line: 1891

        INSERT INTO OKL_INS_CLAIMS_TL(
          id,
          language,
          description,
          police_report,
          comments,
          source_lang,
          sfwt_flag,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okl_ins_claims_tl_rec.id,
          l_okl_ins_claims_tl_rec.language,
          l_okl_ins_claims_tl_rec.description,
          l_okl_ins_claims_tl_rec.police_report,
          l_okl_ins_claims_tl_rec.comments,
          l_okl_ins_claims_tl_rec.source_lang,
          l_okl_ins_claims_tl_rec.sfwt_flag,
          l_okl_ins_claims_tl_rec.created_by,
          l_okl_ins_claims_tl_rec.creation_date,
          l_okl_ins_claims_tl_rec.last_updated_by,
          l_okl_ins_claims_tl_rec.last_update_date,
          l_okl_ins_claims_tl_rec.last_update_login);
Line: 1953

    END insert_row;
Line: 1957

    PROCEDURE insert_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clmv_rec                     IN clmv_rec_type,
      x_clmv_rec                     OUT NOCOPY clmv_rec_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 1966

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

      SELECT nvl(max(to_number(substrb(clmb.claim_number,instr(clmb.claim_number,'-')+1,
             length(clmb.claim_number)))) + 1,-1) SEQUENCE_NUMBER
      FROM   okl_ins_claims_b clmb,okl_ins_policies_b ipyb
      WHERE  clmb.ipy_id = ipyb.id
            and clmb.claim_number like c_claim_like
            and ipyb.ipy_type = c_ipy_type
            and ipyb.id = c_ipy_id;
Line: 2005

           SELECT policy_number ,ipy_type, authoring_org_id -- bug 7335139
            FROM OKL_INS_POLICIES_all_b ins, okc_k_headers_all_b chr -- bug 7335139
           WHERE ins.ID = p_ipy_id
           and ins.khr_id = chr.id; -- bug 7335139
Line: 2048

         select 'x'
         from okl_Ins_claims_b
         where claim_number = c_claim_number;
Line: 2109

        l_clmv_rec.LAST_UPDATE_DATE := l_clmv_rec.CREATION_DATE;
Line: 2110

        l_clmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2111

        l_clmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2209

      insert_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_clm_rec,
        lx_clm_rec
      );
Line: 2223

      insert_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_okl_ins_claims_tl_rec,
        lx_okl_ins_claims_tl_rec
      );
Line: 2272

    END insert_row;
Line: 2276

    PROCEDURE insert_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clmv_tbl                     IN clmv_tbl_type,
      x_clmv_tbl                     OUT NOCOPY clmv_tbl_type,
      px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 2286

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

            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_clmv_rec                     => p_clmv_tbl(i),
              x_clmv_rec                     => x_clmv_tbl(i));
Line: 2368

    END insert_row;
Line: 2372

    PROCEDURE insert_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clmv_tbl                     IN clmv_tbl_type,
      x_clmv_tbl                     OUT NOCOPY clmv_tbl_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 2381

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

        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_clmv_tbl                     => p_clmv_tbl,
          x_clmv_tbl                     => x_clmv_tbl,
          px_error_tbl                   => l_error_tbl);
Line: 2430

    END insert_row;
Line: 2446

      SELECT OBJECT_VERSION_NUMBER
        FROM OKL_INS_CLAIMS_B
       WHERE ID = p_clm_rec.id
         AND OBJECT_VERSION_NUMBER = p_clm_rec.object_version_number
      FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 2452

      SELECT OBJECT_VERSION_NUMBER
        FROM OKL_INS_CLAIMS_B
       WHERE ID = p_clm_rec.id;
Line: 2492

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

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

      SELECT *
        FROM OKL_INS_CLAIMS_TL
       WHERE ID = p_okl_ins_claims_tl_rec.id
      FOR UPDATE NOWAIT;
Line: 2584

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

    PROCEDURE update_row(
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clm_rec                      IN clm_rec_type,
      x_clm_rec                      OUT NOCOPY clm_rec_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 2883

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

          IF (x_clm_rec.program_update_date = OKC_API.G_MISS_DATE)
          THEN
            x_clm_rec.program_update_date := l_clm_rec.program_update_date;
Line: 3039

          IF (x_clm_rec.last_updated_by = OKC_API.G_MISS_NUM)
          THEN
            x_clm_rec.last_updated_by := l_clm_rec.last_updated_by;
Line: 3043

          IF (x_clm_rec.last_update_date = OKC_API.G_MISS_DATE)
          THEN
            x_clm_rec.last_update_date := l_clm_rec.last_update_date;
Line: 3047

          IF (x_clm_rec.last_update_login = OKC_API.G_MISS_NUM)
          THEN
            x_clm_rec.last_update_login := l_clm_rec.last_update_login;
Line: 3095

      UPDATE OKL_INS_CLAIMS_B
      SET CLAIM_NUMBER = l_def_clm_rec.claim_number,
          CSU_CODE = l_def_clm_rec.csu_code,
          IPY_ID = l_def_clm_rec.ipy_id,
          LTP_CODE = l_def_clm_rec.ltp_code,
          PROGRAM_UPDATE_DATE = l_def_clm_rec.program_update_date,
          CLAIM_DATE = l_def_clm_rec.claim_date,
          PROGRAM_ID = l_def_clm_rec.program_id,
          LOSS_DATE = l_def_clm_rec.loss_date,
          POLICE_CONTACT = l_def_clm_rec.police_contact,
          AMOUNT = l_def_clm_rec.amount,
          OBJECT_VERSION_NUMBER = l_def_clm_rec.object_version_number,
          REQUEST_ID = l_def_clm_rec.request_id,
          PROGRAM_APPLICATION_ID = l_def_clm_rec.program_application_id,
          ATTRIBUTE_CATEGORY = l_def_clm_rec.attribute_category,
          ATTRIBUTE1 = l_def_clm_rec.attribute1,
          ATTRIBUTE2 = l_def_clm_rec.attribute2,
          ATTRIBUTE3 = l_def_clm_rec.attribute3,
          ATTRIBUTE4 = l_def_clm_rec.attribute4,
          ATTRIBUTE5 = l_def_clm_rec.attribute5,
          ATTRIBUTE6 = l_def_clm_rec.attribute6,
          ATTRIBUTE7 = l_def_clm_rec.attribute7,
          ATTRIBUTE8 = l_def_clm_rec.attribute8,
          ATTRIBUTE9 = l_def_clm_rec.attribute9,
          ATTRIBUTE10 = l_def_clm_rec.attribute10,
          ATTRIBUTE11 = l_def_clm_rec.attribute11,
          ATTRIBUTE12 = l_def_clm_rec.attribute12,
          ATTRIBUTE13 = l_def_clm_rec.attribute13,
          ATTRIBUTE14 = l_def_clm_rec.attribute14,
          ATTRIBUTE15 = l_def_clm_rec.attribute15,
          HOLD_DATE = l_def_clm_rec.hold_date,
          ORG_ID = l_def_clm_rec.org_id,
          CREATED_BY = l_def_clm_rec.created_by,
          CREATION_DATE = l_def_clm_rec.creation_date,
          LAST_UPDATED_BY = l_def_clm_rec.last_updated_by,
          LAST_UPDATE_DATE = l_def_clm_rec.last_update_date,
          LAST_UPDATE_LOGIN = l_def_clm_rec.last_update_login
      WHERE ID = l_def_clm_rec.id;
Line: 3167

    END update_row;
Line: 3171

    PROCEDURE update_row(
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_okl_ins_claims_tl_rec        IN okl_ins_claims_tl_rec_type,
      x_okl_ins_claims_tl_rec        OUT NOCOPY okl_ins_claims_tl_rec_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 3179

      l_api_name                     CONSTANT VARCHAR2(30) := 'TL_update_row';
Line: 3235

          IF (x_okl_ins_claims_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
          THEN
            x_okl_ins_claims_tl_rec.last_updated_by := l_okl_ins_claims_tl_rec.last_updated_by;
Line: 3239

          IF (x_okl_ins_claims_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
          THEN
            x_okl_ins_claims_tl_rec.last_update_date := l_okl_ins_claims_tl_rec.last_update_date;
Line: 3243

          IF (x_okl_ins_claims_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
          THEN
            x_okl_ins_claims_tl_rec.last_update_login := l_okl_ins_claims_tl_rec.last_update_login;
Line: 3290

      UPDATE OKL_INS_CLAIMS_TL
      SET DESCRIPTION = l_def_okl_ins_claims_tl_rec.description,
          SOURCE_LANG = l_def_okl_ins_claims_tl_rec.source_lang, --Smoduga added for bug 3637102
          POLICE_REPORT = l_def_okl_ins_claims_tl_rec.police_report,
          COMMENTS = l_def_okl_ins_claims_tl_rec.comments,
          CREATED_BY = l_def_okl_ins_claims_tl_rec.created_by,
          CREATION_DATE = l_def_okl_ins_claims_tl_rec.creation_date,
          LAST_UPDATED_BY = l_def_okl_ins_claims_tl_rec.last_updated_by,
          LAST_UPDATE_DATE = l_def_okl_ins_claims_tl_rec.last_update_date,
          LAST_UPDATE_LOGIN = l_def_okl_ins_claims_tl_rec.last_update_login
      WHERE ID = l_def_okl_ins_claims_tl_rec.id
        AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE); --Fix for 3637102 added
Line: 3303

      UPDATE OKL_INS_CLAIMS_TL
      SET SFWT_FLAG = 'Y'
      WHERE ID = l_def_okl_ins_claims_tl_rec.id
        AND SOURCE_LANG <> USERENV('LANG');
Line: 3341

    END update_row;
Line: 3345

    PROCEDURE update_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clmv_rec                     IN clmv_rec_type,
      x_clmv_rec                     OUT NOCOPY clmv_rec_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 3354

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

        l_clmv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 3372

        l_clmv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 3373

        l_clmv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3524

          IF (x_clmv_rec.program_update_date = OKC_API.G_MISS_DATE)
          THEN
            x_clmv_rec.program_update_date := l_db_clmv_rec.program_update_date;
Line: 3536

          IF (x_clmv_rec.last_updated_by = OKC_API.G_MISS_NUM)
          THEN
            x_clmv_rec.last_updated_by := l_db_clmv_rec.last_updated_by;
Line: 3540

          IF (x_clmv_rec.last_update_date = OKC_API.G_MISS_DATE)
          THEN
            x_clmv_rec.last_update_date := l_db_clmv_rec.last_update_date;
Line: 3544

          IF (x_clmv_rec.last_update_login = OKC_API.G_MISS_NUM)
          THEN
            x_clmv_rec.last_update_login := l_db_clmv_rec.last_update_login;
Line: 3630

      update_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_clm_rec,
        lx_clm_rec
      );
Line: 3644

      update_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_okl_ins_claims_tl_rec,
        lx_okl_ins_claims_tl_rec
      );
Line: 3692

    END update_row;
Line: 3696

    PROCEDURE update_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clmv_tbl                     IN clmv_tbl_type,
      x_clmv_tbl                     OUT NOCOPY clmv_tbl_type,
      px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 3706

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

            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_clmv_rec                     => p_clmv_tbl(i),
              x_clmv_rec                     => x_clmv_tbl(i));
Line: 3788

    END update_row;
Line: 3792

    PROCEDURE update_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clmv_tbl                     IN clmv_tbl_type,
      x_clmv_tbl                     OUT NOCOPY clmv_tbl_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 3801

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

        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_clmv_tbl                     => p_clmv_tbl,
          x_clmv_tbl                     => x_clmv_tbl,
          px_error_tbl                   => l_error_tbl);
Line: 3850

    END update_row;
Line: 3857

    PROCEDURE delete_row(
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clm_rec                      IN clm_rec_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 3864

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

      DELETE FROM OKL_INS_CLAIMS_B
       WHERE ID = p_clm_rec.id;
Line: 3913

    END delete_row;
Line: 3917

    PROCEDURE delete_row(
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_okl_ins_claims_tl_rec        IN okl_ins_claims_tl_rec_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 3924

      l_api_name                     CONSTANT VARCHAR2(30) := 'TL_delete_row';
Line: 3938

      DELETE FROM OKL_INS_CLAIMS_TL
       WHERE ID = p_okl_ins_claims_tl_rec.id;
Line: 3973

    END delete_row;
Line: 3977

    PROCEDURE delete_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clmv_rec                     IN clmv_rec_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 3985

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

      delete_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_okl_ins_claims_tl_rec
      );
Line: 4023

      delete_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_clm_rec
      );
Line: 4068

    END delete_row;
Line: 4072

    PROCEDURE delete_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clmv_tbl                     IN clmv_tbl_type,
      px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 4081

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

            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_clmv_rec                     => p_clmv_tbl(i));
Line: 4162

    END delete_row;
Line: 4166

    PROCEDURE delete_row(
      p_api_version                  IN NUMBER,
      p_init_msg_list                IN VARCHAR2 ,
      x_return_status                OUT NOCOPY VARCHAR2,
      x_msg_count                    OUT NOCOPY NUMBER,
      x_msg_data                     OUT NOCOPY VARCHAR2,
      p_clmv_tbl                     IN clmv_tbl_type) IS
      l_api_version                  CONSTANT NUMBER := 1;
Line: 4174

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

        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_clmv_tbl                     => p_clmv_tbl,
          px_error_tbl                   => l_error_tbl);
Line: 4222

    END delete_row;