DBA Data[Home] [Help]

APPS.OKC_HST_PVT SQL Statements

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

Line: 101

  /* Commenting delete and update for bug 3723874 */
  /*
    DELETE FROM OKC_K_HISTORY_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_K_HISTORY_B B
         WHERE B.ID =T.ID
        );
Line: 110

    UPDATE OKC_K_HISTORY_TL T SET(
        COMMENTS) = (SELECT
                                  B.COMMENTS
                                FROM OKC_K_HISTORY_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 OKC_K_HISTORY_TL SUBB, OKC_K_HISTORY_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.COMMENTS <> SUBT.COMMENTS
                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
              ));
Line: 128

   /* Modifying Insert as per performance guidelines given in bug 3723874 */
    INSERT /*+ append parallel(tt) */ INTO OKC_K_HISTORY_TL tt (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        COMMENTS,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      select /*+ parallel(v) parallel(t) use_nl(t)  */ v.* from
      ( SELECT /*+ no_merge ordered parallel(b) */
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.COMMENTS,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKC_K_HISTORY_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
        ) v , OKC_K_HISTORY_TL t
        WHERE t.ID(+) = v.ID
        AND t.LANGUAGE(+) = v.LANGUAGE_CODE
	AND t.id IS NULL;
Line: 168

    SELECT
            ID,
            CHR_ID,
            CLE_ID,
            CONTRACT_VERSION,
            OBJECT_VERSION_NUMBER,
            OPN_CODE,
            STS_CODE_FROM,
            STS_CODE_TO,
            REASON_CODE,
            TRN_CODE,
            MANUAL_YN,
            COMMENTS,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            REQUEST_ID
      FROM Okc_K_History_V
     WHERE okc_k_history_v.id   = p_id;
Line: 213

              l_hstv_rec.last_updated_by,
              l_hstv_rec.last_update_date,
              l_hstv_rec.last_update_login,
              l_hstv_rec.program_application_id,
              l_hstv_rec.program_id,
              l_hstv_rec.program_update_date,
              l_hstv_rec.request_id;
Line: 261

    SELECT
            ID,
            CHR_ID,
            CLE_ID,
            CONTRACT_VERSION,
            STS_CODE_FROM,
            OPN_CODE,
            STS_CODE_TO,
            REASON_CODE,
            TRN_CODE,
            MANUAL_YN,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            OBJECT_VERSION_NUMBER,
            LAST_UPDATE_LOGIN,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            REQUEST_ID
      FROM Okc_K_History_B
     WHERE okc_k_history_b.id   = p_id;
Line: 303

              l_hst_rec.last_updated_by,
              l_hst_rec.last_update_date,
              l_hst_rec.object_version_number,
              l_hst_rec.last_update_login,
              l_hst_rec.program_application_id,
              l_hst_rec.program_id,
              l_hst_rec.program_update_date,
              l_hst_rec.request_id;
Line: 353

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            COMMENTS,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_K_History_Tl
     WHERE okc_k_history_tl.id  = p_id
       AND okc_k_history_tl.language = p_language;
Line: 380

              l_okc_k_history_tl_rec.last_updated_by,
              l_okc_k_history_tl_rec.last_update_date,
              l_okc_k_history_tl_rec.last_update_login;
Line: 467

    IF (l_hstv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_hstv_rec.last_updated_by := NULL;
Line: 470

    IF (l_hstv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_hstv_rec.last_update_date := NULL;
Line: 473

    IF (l_hstv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_hstv_rec.last_update_login := NULL;
Line: 482

    IF (l_hstv_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
      l_hstv_rec.program_update_date := NULL;
Line: 608

SELECT lookup_code
  FROM fnd_lookups
 WHERE lookup_type='OKC_STS_CHG_REASON'
   AND enabled_flag='Y'
   AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1)
   AND lookup_code = p_reason_code
UNION ALL
SELECT lookup_code
  FROM fnd_lookups
 WHERE lookup_type='OKS_CANCEL_REASON'
   AND enabled_flag='Y'
   AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active,SYSDATE+1)
   AND lookup_code = p_reason_code;
Line: 866

      SELECT 'x'
        FROM Okc_Statuses_B
       WHERE okc_statuses_b.code  = p_code;
Line: 878

      SELECT 'x'
        FROM Okc_K_Lines_B
       WHERE okc_k_lines_b.id     = p_id;
Line: 884

      SELECT 'x'
        FROM okc_k_headers_all_b  -- Modified by Jvorugan for Bug:4958537 Okc_K_Headers_B
       WHERE okc_k_headers_all_b.id   = p_id;
Line: 890

      SELECT 'x'
        FROM Okc_Operations_B
       WHERE okc_operations_b.code = p_code;
Line: 1004

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  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_hst_rec                      IN hst_rec_type,
    x_hst_rec                      OUT NOCOPY hst_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1318

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

    INSERT INTO OKC_K_HISTORY_B(
      id,
      chr_id,
      cle_id,
      contract_version,
      sts_code_from,
      opn_code,
      sts_code_to,
      reason_code,
      trn_code,
      manual_yn,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      object_version_number,
      last_update_login,
      program_application_id,
      program_id,
      program_update_date,
      request_id)
    VALUES (
      l_hst_rec.id,
      l_hst_rec.chr_id,
      l_hst_rec.cle_id,
      l_hst_rec.contract_version,
      l_hst_rec.sts_code_from,
      l_hst_rec.opn_code,
      l_hst_rec.sts_code_to,
      l_hst_rec.reason_code,
      l_hst_rec.trn_code,
      l_hst_rec.manual_yn,
      l_hst_rec.created_by,
      l_hst_rec.creation_date,
      l_hst_rec.last_updated_by,
      l_hst_rec.last_update_date,
      l_hst_rec.object_version_number,
      l_hst_rec.last_update_login,
      l_hst_rec.program_application_id,
      l_hst_rec.program_id,
      l_hst_rec.program_update_date,
      l_hst_rec.request_id);
Line: 1431

  END insert_row;
Line: 1435

  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_okc_k_history_tl_rec         IN okc_k_history_tl_rec_type,
    x_okc_k_history_tl_rec         OUT NOCOPY okc_k_history_tl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1444

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

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

      INSERT INTO OKC_K_HISTORY_TL(
        id,
        language,
        source_lang,
        comments,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_okc_k_history_tl_rec.id,
        l_okc_k_history_tl_rec.language,
        l_okc_k_history_tl_rec.source_lang,
        l_okc_k_history_tl_rec.comments,
        l_okc_k_history_tl_rec.created_by,
        l_okc_k_history_tl_rec.creation_date,
        l_okc_k_history_tl_rec.last_updated_by,
        l_okc_k_history_tl_rec.last_update_date,
        l_okc_k_history_tl_rec.last_update_login);
Line: 1544

  END insert_row;
Line: 1548

  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_hstv_rec                     IN hstv_rec_type,
    x_hstv_rec                     OUT NOCOPY hstv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1558

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

      l_hstv_rec.LAST_UPDATE_DATE := l_hstv_rec.CREATION_DATE;
Line: 1577

      l_hstv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1578

      l_hstv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1592

      SELECT trn_code
      FROM okc_k_headers_b
      WHERE id = p_hstv_rec.chr_id;
Line: 1682

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_hst_rec,
      lx_hst_rec
    );
Line: 1696

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_k_history_tl_rec,
      lx_okc_k_history_tl_rec
    );
Line: 1745

  END insert_row;
Line: 1749

  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_hstv_tbl                     IN hstv_tbl_type,
    x_hstv_tbl                     OUT NOCOPY hstv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1760

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

          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_hstv_rec                     => p_hstv_tbl(i),
            x_hstv_rec                     => x_hstv_tbl(i));
Line: 1842

  END insert_row;
Line: 1847

  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_hstv_tbl                     IN hstv_tbl_type,
    x_hstv_tbl                     OUT NOCOPY hstv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1857

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

      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_hstv_tbl                     => p_hstv_tbl,
        x_hstv_tbl                     => x_hstv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 1906

  END insert_row;
Line: 1924

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_HISTORY_B
     WHERE ID = p_hst_rec.id
       AND OBJECT_VERSION_NUMBER = p_hst_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1931

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_HISTORY_B
     WHERE ID = p_hst_rec.id;
Line: 1972

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

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

    SELECT *
      FROM OKC_K_HISTORY_TL
     WHERE ID = p_okc_k_history_tl_rec.id
    FOR UPDATE NOWAIT;
Line: 2067

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

  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_hst_rec                      IN hst_rec_type,
    x_hst_rec                      OUT NOCOPY hst_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2370

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

        IF (x_hst_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_hst_rec.last_updated_by := l_hst_rec.last_updated_by;
Line: 2442

        IF (x_hst_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_hst_rec.last_update_date := l_hst_rec.last_update_date;
Line: 2450

        IF (x_hst_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_hst_rec.last_update_login := l_hst_rec.last_update_login;
Line: 2462

        IF (x_hst_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_hst_rec.program_update_date := l_hst_rec.program_update_date;
Line: 2512

    UPDATE OKC_K_HISTORY_B
    SET CHR_ID = l_def_hst_rec.chr_id,
        CLE_ID = l_def_hst_rec.cle_id,
        CONTRACT_VERSION = l_def_hst_rec.contract_version,
        STS_CODE_FROM = l_def_hst_rec.sts_code_from,
        OPN_CODE = l_def_hst_rec.opn_code,
        STS_CODE_TO = l_def_hst_rec.sts_code_to,
        REASON_CODE = l_def_hst_rec.reason_code,
        TRN_CODE = l_def_hst_rec.trn_code,
        MANUAL_YN = l_def_hst_rec.manual_yn,
        CREATED_BY = l_def_hst_rec.created_by,
        CREATION_DATE = l_def_hst_rec.creation_date,
        LAST_UPDATED_BY = l_def_hst_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_hst_rec.last_update_date,
        OBJECT_VERSION_NUMBER = l_def_hst_rec.object_version_number,
        LAST_UPDATE_LOGIN = l_def_hst_rec.last_update_login,
        PROGRAM_APPLICATION_ID = l_def_hst_rec.program_application_id,
        PROGRAM_ID = l_def_hst_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_hst_rec.program_update_date,
        REQUEST_ID = l_def_hst_rec.request_id
    WHERE ID = l_def_hst_rec.id;
Line: 2568

  END update_row;
Line: 2572

  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_okc_k_history_tl_rec         IN okc_k_history_tl_rec_type,
    x_okc_k_history_tl_rec         OUT NOCOPY okc_k_history_tl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2581

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

        IF (x_okc_k_history_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_okc_k_history_tl_rec.last_updated_by := l_okc_k_history_tl_rec.last_updated_by;
Line: 2629

        IF (x_okc_k_history_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_okc_k_history_tl_rec.last_update_date := l_okc_k_history_tl_rec.last_update_date;
Line: 2633

        IF (x_okc_k_history_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_okc_k_history_tl_rec.last_update_login := l_okc_k_history_tl_rec.last_update_login;
Line: 2680

    UPDATE OKC_K_HISTORY_TL
    SET COMMENTS = l_def_okc_k_history_tl_rec.comments,
        CREATED_BY = l_def_okc_k_history_tl_rec.created_by,
        CREATION_DATE = l_def_okc_k_history_tl_rec.creation_date,
        LAST_UPDATED_BY = l_def_okc_k_history_tl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_okc_k_history_tl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_okc_k_history_tl_rec.last_update_login
    WHERE ID = l_def_okc_k_history_tl_rec.id
      AND SOURCE_LANG = USERENV('LANG');
Line: 2731

  END update_row;
Line: 2735

  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_hstv_rec                     IN hstv_rec_type,
    x_hstv_rec                     OUT NOCOPY hstv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2745

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

      l_hstv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2763

      l_hstv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2764

      l_hstv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2835

        IF (x_hstv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_hstv_rec.last_updated_by := l_db_hstv_rec.last_updated_by;
Line: 2839

        IF (x_hstv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_hstv_rec.last_update_date := l_db_hstv_rec.last_update_date;
Line: 2843

        IF (x_hstv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_hstv_rec.last_update_login := l_db_hstv_rec.last_update_login;
Line: 2855

        IF (x_hstv_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_hstv_rec.program_update_date := l_db_hstv_rec.program_update_date;
Line: 2945

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_hst_rec,
      lx_hst_rec
    );
Line: 2959

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_k_history_tl_rec,
      lx_okc_k_history_tl_rec
    );
Line: 3007

  END update_row;
Line: 3011

  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_hstv_tbl                     IN hstv_tbl_type,
    x_hstv_tbl                     OUT NOCOPY hstv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3022

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

          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_hstv_rec                     => p_hstv_tbl(i),
            x_hstv_rec                     => x_hstv_tbl(i));
Line: 3104

  END update_row;
Line: 3109

  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_hstv_tbl                     IN hstv_tbl_type,
    x_hstv_tbl                     OUT NOCOPY hstv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3119

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

      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_hstv_tbl                     => p_hstv_tbl,
        x_hstv_tbl                     => x_hstv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 3168

  END update_row;
Line: 3176

  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_hst_rec                      IN hst_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3184

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

    DELETE FROM OKC_K_HISTORY_B
     WHERE ID = p_hst_rec.id;
Line: 3235

  END delete_row;
Line: 3239

  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_okc_k_history_tl_rec         IN okc_k_history_tl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3247

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

    DELETE FROM OKC_K_HISTORY_TL
     WHERE ID = p_okc_k_history_tl_rec.id;
Line: 3298

  END delete_row;
Line: 3302

  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_hstv_rec                     IN hstv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3311

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_k_history_tl_rec
    );
Line: 3349

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_hst_rec
    );
Line: 3394

  END delete_row;
Line: 3398

  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_hstv_tbl                     IN hstv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3408

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

          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_hstv_rec                     => p_hstv_tbl(i));
Line: 3489

  END delete_row;
Line: 3494

  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_hstv_tbl                     IN hstv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3503

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

      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_hstv_tbl                     => p_hstv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 3551

  END delete_row;
Line: 3560

  PROCEDURE delete_all_rows(
    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_chr_id                       IN NUMBER) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3568

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_delete_all_rows';
Line: 3583

    DELETE FROM OKC_K_HISTORY_TL
         WHERE ID IN (SELECT ID
                      FROM OKC_K_HISTORY_B
                      WHERE CHR_ID = p_chr_id);
Line: 3588

    DELETE FROM OKC_K_HISTORY_B
     WHERE CHR_ID = p_chr_id;
Line: 3624

  END delete_all_rows;
Line: 3628

  PROCEDURE delete_all_rows(
    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_chr_id                       IN NUMBER) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3637

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_all_rows';
Line: 3656

    delete_all_rows(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      p_chr_id    );
Line: 3701

  END delete_all_rows;