DBA Data[Home] [Help]

APPS.OKC_TIME_PVT SQL Statements

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

Line: 16

/* The following delete and update statements are commented out */
/* as a quick workaround to fix the time-consuming table handler issue */
/* Eventually we'll need to turn them into a separate fix_language procedure */
/*

    DELETE FROM OKC_TIMEVALUES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_TIMEVALUES_B B
         WHERE B.ID = T.ID
        );
Line: 30

   /* Also it takes a lot of time doing this redundant update*/
   /* UPDATE OKC_TIMEVALUES_TL T SET (
        DESCRIPTION,
        SHORT_DESCRIPTION,
        COMMENTS,
        NAME) = (SELECT
                                  B.DESCRIPTION,
                                  B.SHORT_DESCRIPTION,
                                  B.COMMENTS,
                                  B.NAME
                                FROM OKC_TIMEVALUES_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_TIMEVALUES_TL SUBB, OKC_TIMEVALUES_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                      OR SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
                      OR SUBB.COMMENTS <> SUBT.COMMENTS
                      OR SUBB.NAME <> SUBT.NAME
                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                      OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
                      OR (SUBB.SHORT_DESCRIPTION IS NULL AND SUBT.SHORT_DESCRIPTION IS NOT NULL)
                      OR (SUBB.SHORT_DESCRIPTION IS NOT NULL AND SUBT.SHORT_DESCRIPTION IS NULL)
                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                      OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
                      OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
                      OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
              )); */
Line: 68

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

    DELETE FROM OKC_TIMEVALUES_TLH T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_TIMEVALUES_BH B
         WHERE B.ID = T.ID
           AND B.MAJOR_VERSION = T.MAJOR_VERSION
        );
Line: 114

    UPDATE OKC_TIMEVALUES_TLH T SET (
        DESCRIPTION,
        SHORT_DESCRIPTION,
        COMMENTS,
        NAME) = (SELECT
                                  B.DESCRIPTION,
                                  B.SHORT_DESCRIPTION,
                                  B.COMMENTS,
                                  B.NAME
                                FROM OKC_TIMEVALUES_TLH B
                               WHERE B.ID = T.ID
                                 AND B.MAJOR_VERSION = T.MAJOR_VERSION
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE (
              T.ID,
              T.MAJOR_VERSION,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.ID,
                  SUBT.MAJOR_VERSION,
                  SUBT.LANGUAGE
                FROM OKC_TIMEVALUES_TLH SUBB, OKC_TIMEVALUES_TLH SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
                      OR SUBB.SHORT_DESCRIPTION <> SUBT.SHORT_DESCRIPTION
                      OR SUBB.COMMENTS <> SUBT.COMMENTS
                      OR SUBB.NAME <> SUBT.NAME
                      OR (SUBB.DESCRIPTION IS NULL AND SUBT.DESCRIPTION IS NOT NULL)
                      OR (SUBB.DESCRIPTION IS NOT NULL AND SUBT.DESCRIPTION IS NULL)
                      OR (SUBB.SHORT_DESCRIPTION IS NULL AND SUBT.SHORT_DESCRIPTION IS NOT NULL)
                      OR (SUBB.SHORT_DESCRIPTION IS NOT NULL AND SUBT.SHORT_DESCRIPTION IS NULL)
                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                      OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
                      OR (SUBB.NAME IS NULL AND SUBT.NAME IS NOT NULL)
                      OR (SUBB.NAME IS NOT NULL AND SUBT.NAME IS NULL)
              ));
Line: 153

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

  PROCEDURE DELETE_TIMEVALUES_N_TASKS(
    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  ,
    p_tve_id                IN NUMBER) IS
    CURSOR tve_csr(p_tve_id IN NUMBER) is
--Bug 3122962
	SELECT TVE_TYPE, TVE_ID_OFFSET,TVE_ID_STARTED,TVE_ID_ENDED FROM OKC_TIMEVALUES
	 WHERE id = p_tve_id;
Line: 219

    l_api_name              CONSTANT VARCHAR2(30) := 'delete_timevalues_n_tasks';
Line: 241

	OKC_TIME_PVT.DELETE_TPA_RELTV(
       p_api_version	,
       p_init_msg_list   ,
       x_return_status   ,
       x_msg_count       ,
       x_msg_data        ,
       p_talv_evt_rec) ;
Line: 250

    OKC_TIME_PVT.DELETE_TPG_NAMED(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgnv_rec);
Line: 259

    OKC_TIME_PVT.DELETE_TPA_VALUE(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tavv_rec);
Line: 268

    OKC_TIME_PVT.DELETE_TPG_DELIMITED(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgdv_ext_rec);
Line: 277

    OKC_TIME_PVT.DELETE_CYCLE(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_cylv_ext_rec);
Line: 289

      OKC_TIME_PVT.DELETE_IA_STARTEND(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_isev_ext_rec);
Line: 301

    OKC_TIME_PVT.DELETE_IG_STARTEND(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_igsv_ext_rec);
Line: 310

    OKC_TIME_RES_PUB.Delete_Res_Time_N_Tasks(
      p_tve_id,
      sysdate,
      p_api_version,
      p_init_msg_list,
      x_return_status);
Line: 329

  END DELETE_TIMEVALUES_N_TASKS;
Line: 352

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

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

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

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

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

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

    okc_tal_pvt.insert_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_talv_rec,
      x_talv_rec);
Line: 438

  PROCEDURE UPDATE_TPA_RELTV(
    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_talv_rec	    IN talv_rec_type,
    x_talv_rec          OUT NOCOPY talv_rec_type) IS
  BEGIN
    okc_tal_pvt.update_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_talv_rec,
      x_talv_rec);
Line: 455

  END UPDATE_TPA_RELTV;
Line: 456

  PROCEDURE DELETE_TPA_RELTV(
    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_talv_rec	    IN talv_rec_type) IS
  BEGIN
    okc_tal_pvt.delete_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_talv_rec);
Line: 471

  END DELETE_TPA_RELTV;
Line: 538

    okc_tal_pvt.insert_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_talv_rec,
      x_talv_rec);
Line: 551

  PROCEDURE UPDATE_TPA_RELTV(
    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_talv_evt_rec	    IN talv_event_rec_type,
    x_talv_evt_rec          OUT NOCOPY talv_event_rec_type) IS
    p_talv_rec	            talv_rec_type;
Line: 567

    OKC_TIME_pub.update_tpg_named(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgnv_rec,
      x_tgnv_rec);
Line: 580

    okc_tal_pvt.update_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_talv_rec,
      x_talv_rec);
Line: 592

  END UPDATE_TPA_RELTV;
Line: 593

  PROCEDURE DELETE_TPA_RELTV(
    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_talv_evt_rec	    IN talv_event_rec_type) IS
    p_talv_rec	            talv_rec_type;
Line: 606

    OKC_TIME_pub.delete_tpg_named(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgnv_rec);
Line: 617

    okc_tal_pvt.delete_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_talv_rec);
Line: 624

  END DELETE_TPA_RELTV;
Line: 691

    okc_tav_pvt.insert_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tavv_rec,
      x_tavv_rec);
Line: 700

  PROCEDURE UPDATE_TPA_VALUE(
    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_tavv_rec	    IN tavv_rec_type,
    x_tavv_rec          OUT NOCOPY tavv_rec_type) IS
  BEGIN
    okc_tav_pvt.update_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tavv_rec,
      x_tavv_rec);
Line: 717

  END UPDATE_TPA_VALUE;
Line: 718

  PROCEDURE DELETE_TPA_VALUE(
    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_tavv_rec	    IN tavv_rec_type) IS
  BEGIN
    okc_tav_pvt.delete_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tavv_rec);
Line: 733

  END DELETE_TPA_VALUE;
Line: 788

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

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

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

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

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

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

    okc_tgd_pvt.insert_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgdv_rec,
      x_tgdv_rec);
Line: 915

  PROCEDURE UPDATE_TPG_DELIMITED(
    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_tgdv_ext_rec	    IN tgdv_extended_rec_type,
    x_tgdv_ext_rec          OUT NOCOPY tgdv_extended_rec_type) IS
    p_tgdv_rec	            tgdv_rec_type;
Line: 926

    l_api_name              CONSTANT VARCHAR2(30) := 'update_tpg_delimited';
Line: 930

      SELECT tve_id_limited, dnz_chr_id
        FROM okc_timevalues
       WHERE id = p_id
	   and tve_type = 'TGD';
Line: 935

      SELECT id, start_date, end_date
        FROM okc_time_ia_startend_val_v
       WHERE id = p_id;
Line: 977

        OKC_TIME_pub.delete_ia_startend(
          p_api_version,
          p_init_msg_list,
          x_return_status,
          x_msg_count,
          x_msg_data,
          p_isev_ext_rec);
Line: 1002

          OKC_TIME_pub.update_ia_startend(
            p_api_version,
            p_init_msg_list,
            x_return_status,
            x_msg_count,
            x_msg_data,
            p_isev_ext_rec,
            x_isev_ext_rec);
Line: 1020

    okc_tgd_pvt.update_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgdv_rec,
      x_tgdv_rec);
Line: 1041

  END UPDATE_TPG_DELIMITED;
Line: 1042

  PROCEDURE DELETE_TPG_DELIMITED(
    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_tgdv_ext_rec	    IN tgdv_extended_rec_type) IS
    p_tgdv_rec	            tgdv_rec_type;
Line: 1055

      SELECT id, tve_id_limited
        FROM okc_timevalues
       WHERE id = p_id
	   AND tve_type = 'TGD';
Line: 1069

      OKC_TIME_pub.delete_ia_startend(
        p_api_version,
        p_init_msg_list,
        x_return_status,
        x_msg_count,
        x_msg_data,
        p_isev_ext_rec);
Line: 1081

    okc_tgd_pvt.delete_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgdv_rec);
Line: 1088

  END DELETE_TPG_DELIMITED;
Line: 1141

    okc_tgn_pvt.insert_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgnv_rec,
      x_tgnv_rec);
Line: 1150

  PROCEDURE UPDATE_TPG_NAMED(
    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_tgnv_rec	    IN tgnv_rec_type,
    x_tgnv_rec          OUT NOCOPY tgnv_rec_type) IS
  BEGIN
    okc_tgn_pvt.update_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgnv_rec,
      x_tgnv_rec);
Line: 1167

  END UPDATE_TPG_NAMED;
Line: 1168

  PROCEDURE DELETE_TPG_NAMED(
    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_tgnv_rec	    IN tgnv_rec_type) IS
  BEGIN
    okc_tgn_pvt.delete_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgnv_rec);
Line: 1183

  END DELETE_TPG_NAMED;
Line: 1244

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

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

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

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

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

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

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

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

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

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

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

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

    okc_ise_pvt.insert_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_isev_rec,
      x_isev_rec);
Line: 1468

  PROCEDURE UPDATE_IA_STARTEND(
    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_isev_ext_rec	    IN isev_extended_rec_type,
    x_isev_ext_rec          OUT NOCOPY isev_extended_rec_type) IS
    p_tavv_rec          tavv_rec_type;
Line: 1481

    l_api_name              CONSTANT VARCHAR2(30) := 'update_ia_startend';
Line: 1484

      SELECT start_date
        FROM okc_time_ia_startend_val_v
       WHERE id = p_id ;
Line: 1534

    okc_ise_pvt.update_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_isev_rec,
      x_isev_rec);
Line: 1549

       OKC_TIME_pub.update_tpa_value(
         p_api_version,
         p_init_msg_list,
         x_return_status,
         x_msg_count,
         x_msg_data,
         p_tavv_rec,
         x_tavv_rec);
Line: 1569

  END UPDATE_IA_STARTEND;
Line: 1571

  PROCEDURE DELETE_IA_STARTEND(
    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_isev_ext_rec	    IN isev_extended_rec_type) IS
    p_isev_rec              isev_rec_type;
Line: 1583

      SELECT tve_id_started
        FROM okc_timevalues
       WHERE id = p_id
	   AND tve_type = 'ISE';
Line: 1588

    l_api_name              CONSTANT VARCHAR2(30) := 'delete_ia_startend';
Line: 1607

    OKC_TIME_pub.delete_tpa_value(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tavv_rec);
Line: 1618

    okc_ise_pvt.delete_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_isev_rec);
Line: 1636

  END DELETE_IA_STARTEND;
Line: 1739

    okc_ise_pvt.insert_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_isev_rec,
      x_isev_rec);
Line: 1753

  PROCEDURE UPDATE_IA_STARTEND(
    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_isev_rel_rec	    IN isev_reltv_rec_type,
    x_isev_rel_rec          OUT NOCOPY isev_reltv_rec_type) IS
    p_talv_rec          talv_rec_type;
Line: 1766

    l_api_name              CONSTANT VARCHAR2(30) := 'update_ia_startend';
Line: 1789

    okc_ise_pvt.update_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_isev_rec,
      x_isev_rec);
Line: 1812

    OKC_TIME_pub.update_tpa_reltv(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_talv_rec,
      x_talv_rec);
Line: 1820

  END UPDATE_IA_STARTEND;
Line: 1822

  PROCEDURE DELETE_IA_STARTEND(
    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_isev_rel_rec	    IN isev_reltv_rec_type) IS
    p_isev_rec              isev_rec_type;
Line: 1834

      SELECT tve_id_started
        FROM okc_timevalues
       WHERE id = p_id
	   AND tve_type = 'ISE';
Line: 1839

    l_api_name              CONSTANT VARCHAR2(30) := 'delete_ia_startend';
Line: 1858

    OKC_TIME_pub.delete_tpa_reltv(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_talv_rec);
Line: 1869

    okc_ise_pvt.delete_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_isev_rec);
Line: 1876

  END DELETE_IA_STARTEND;
Line: 1937

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

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

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

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

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

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

    okc_igs_pvt.insert_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_igsv_rec,
      x_igsv_rec);
Line: 2073

  PROCEDURE UPDATE_IG_STARTEND(
    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_igsv_ext_rec	    IN igsv_extended_rec_type,
    x_igsv_ext_rec          OUT NOCOPY igsv_extended_rec_type) IS
    p_tgdv_ext_rec          tgdv_extended_rec_type;
Line: 2089

    okc_igs_pvt.update_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_igsv_rec,
      x_igsv_rec);
Line: 2109

    OKC_TIME_pub.update_tpg_delimited(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgdv_ext_rec,
      x_tgdv_ext_rec);
Line: 2128

    OKC_TIME_pub.update_tpg_delimited(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgdv_ext_rec,
      x_tgdv_ext_rec);
Line: 2136

  END UPDATE_IG_STARTEND;
Line: 2137

  PROCEDURE DELETE_IG_STARTEND(
    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_igsv_ext_rec	    IN igsv_extended_rec_type) IS
    p_igsv_rec              igsv_rec_type;
Line: 2151

    okc_igs_pvt.delete_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_igsv_rec);
Line: 2162

    OKC_TIME_pub.delete_tpg_delimited(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgdv_ext_rec);
Line: 2173

    OKC_TIME_pub.delete_tpg_delimited(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_tgdv_ext_rec);
Line: 2183

  END DELETE_IG_STARTEND;
Line: 2235

    okc_spn_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_spnv_rec,
    x_spnv_rec);
Line: 2244

  PROCEDURE UPDATE_SPAN(
    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_spnv_rec		    IN spnv_rec_type,
    x_spnv_rec              OUT NOCOPY spnv_rec_type) IS
  BEGIN
    okc_spn_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_spnv_rec,
    x_spnv_rec);
Line: 2261

  END UPDATE_SPAN;
Line: 2262

  PROCEDURE DELETE_SPAN(
    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_spnv_rec		    IN spnv_rec_type) IS
  BEGIN
    okc_spn_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_spnv_rec);
Line: 2277

  END DELETE_SPAN;
Line: 2324

    okc_tcu_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_tcuv_rec,
    x_tcuv_rec);
Line: 2333

  PROCEDURE UPDATE_TIME_CODE_UNITS(
    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_tcuv_rec		    IN tcuv_rec_type,
    x_tcuv_rec              OUT NOCOPY tcuv_rec_type) IS
  BEGIN
    okc_tcu_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_tcuv_rec,
    x_tcuv_rec);
Line: 2350

  END UPDATE_TIME_CODE_UNITS;
Line: 2351

  PROCEDURE DELETE_TIME_CODE_UNITS(
    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_tcuv_rec		    IN tcuv_rec_type) IS
  BEGIN
    okc_tcu_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_tcuv_rec);
Line: 2366

  END DELETE_TIME_CODE_UNITS;
Line: 2415

    okc_rtv_pvt.insert_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rtvv_rec,
    x_rtvv_rec);
Line: 2425

  PROCEDURE UPDATE_RESOLVED_TIMEVALUES(
    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_rtvv_rec		    IN rtvv_rec_type,
    x_rtvv_rec              OUT NOCOPY rtvv_rec_type) IS
  BEGIN
    okc_rtv_pvt.update_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rtvv_rec,
    x_rtvv_rec);
Line: 2442

  END UPDATE_RESOLVED_TIMEVALUES;
Line: 2444

  PROCEDURE DELETE_RESOLVED_TIMEVALUES(
    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_rtvv_rec		    IN rtvv_rec_type) IS
  BEGIN
    okc_rtv_pvt.delete_row(
    p_api_version,
    p_init_msg_list,
    x_return_status,
    x_msg_count,
    x_msg_data,
    p_rtvv_rec);
Line: 2459

  END DELETE_RESOLVED_TIMEVALUES;
Line: 2516

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

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

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

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

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

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

    okc_cyl_pvt.insert_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_cylv_rec,
      x_cylv_rec);
Line: 2654

    UPDATE OKC_TIMEVALUES
    SET SPN_ID = x_cylv_ext_rec.spn_id
    WHERE TVE_TYPE = 'CYL'
    AND id = x_cylv_ext_rec.id;
Line: 2660

  PROCEDURE UPDATE_CYCLE(
    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_cylv_ext_rec		   IN cylv_extended_rec_type,
    x_cylv_ext_rec          OUT NOCOPY cylv_extended_rec_type) IS
    p_cylv_rec              cylv_rec_type;
Line: 2675

    l_api_name              CONSTANT VARCHAR2(30) := 'update_cycle';
Line: 2677

      SELECT tve_id_limited, dnz_chr_id
        FROM okc_timevalues
       WHERE id = p_id
	  AND tve_type = 'CYL';
Line: 2682

      SELECT id, start_date, end_date
        FROM okc_time_ia_startend_val_v
       WHERE id = p_id;
Line: 2722

        OKC_TIME_pub.delete_ia_startend(
          p_api_version,
          p_init_msg_list,
          x_return_status,
          x_msg_count,
          x_msg_data,
          p_isev_ext_rec);
Line: 2745

          OKC_TIME_pub.update_ia_startend(
            p_api_version,
            p_init_msg_list,
            x_return_status,
            x_msg_count,
            x_msg_data,
            p_isev_ext_rec,
            x_isev_ext_rec);
Line: 2760

    okc_cyl_pvt.update_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_cylv_rec,
      x_cylv_rec);
Line: 2778

    OKC_TIME_pub.update_span(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_spnv_rec,
      x_spnv_rec);
Line: 2789

  END UPDATE_CYCLE;
Line: 2791

  PROCEDURE DELETE_CYCLE(
    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_cylv_ext_rec          IN cylv_extended_rec_type) IS
    p_cylv_rec              cylv_rec_type;
Line: 2804

      SELECT id, tve_id_limited, spn_id
        FROM okc_timevalues
       WHERE id = p_id
	    AND tve_type = 'CYL';
Line: 2818

      OKC_TIME_pub.delete_ia_startend(
        p_api_version,
        p_init_msg_list,
        x_return_status,
        x_msg_count,
        x_msg_data,
        p_isev_ext_rec);
Line: 2835

    OKC_TIME_pub.delete_span(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_spnv_rec);
Line: 2846

    okc_cyl_pvt.delete_row(
      p_api_version,
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      p_cylv_rec);
Line: 2856

  END DELETE_CYCLE;
Line: 2914

PROCEDURE INSERT_IGS_ROW_UPG(p_igsv_ext_tbl IN igsv_ext_tbl_type) IS
  l_tabsize NUMBER := p_igsv_ext_tbl.COUNT;
Line: 2966

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;
Line: 2967

  in_last_update_date              OKC_DATATYPES.DateTabTyp;
Line: 2968

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;
Line: 3027

    in_last_updated_by          (j) := p_igsv_ext_tbl(i).last_updated_by;
Line: 3028

    in_last_update_date         (j) := p_igsv_ext_tbl(i).last_update_date;
Line: 3029

    in_last_update_login        (j) := p_igsv_ext_tbl(i).last_update_login;
Line: 3081

    in_last_updated_by          (j) := p_igsv_ext_tbl(i).last_updated_by;
Line: 3082

    in_last_update_date         (j) := p_igsv_ext_tbl(i).last_update_date;
Line: 3083

    in_last_update_login        (j) := p_igsv_ext_tbl(i).last_update_login;
Line: 3134

    in_last_updated_by          (j) := p_igsv_ext_tbl(i).last_updated_by;
Line: 3135

    in_last_update_date         (j) := p_igsv_ext_tbl(i).last_update_date;
Line: 3136

    in_last_update_login        (j) := p_igsv_ext_tbl(i).last_update_login;
Line: 3141

    INSERT
      INTO OKC_TIMEVALUES
      (
        id,
        spn_id,
        tve_id_offset,
        tve_id_generated_by,
        tve_id_started,
        tve_id_ended,
        tve_id_limited,
        cnh_id,
        dnz_chr_id,
        tve_type,
        tze_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        uom_code,
        duration,
        operator,
        before_after,
        datetime,
        month,
        day,
        hour,
        minute,
        second,
        interval_yn,
        last_update_login,
        nth,
        day_of_week,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
--Bug 3122962
        name,
        description,
        short_description,
        comments
     )
     VALUES (
        DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
        DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
        DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
        DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
        DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
        DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
        DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
        DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
        DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
        DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
        DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
        DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
        DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
        DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
        DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
        DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
        DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
        DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
        DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
        DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
        DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
        DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
        DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
        DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
        DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
        DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
        DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
        DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
        DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
        DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
        DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
        DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
        DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
        DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
        DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
        DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
        DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
        DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
        DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
        DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
        DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
        DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
        DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
        DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
        DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
        DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
--Bug 3122962
        DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
        DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
        DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
        DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
     );
Line: 3254

      INSERT INTO OKC_TIMEVALUES_TL(
        id,
        language,
        source_lang,
        sfwt_flag,
        description,
        short_description,
        comments,
        name,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
     )
     VALUES (
        DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
        OKC_UTIL.g_language_code(lang_i),
        l_source_lang,
        DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
        DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
        DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
        DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
        DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
        DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
        DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
        DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
        DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
        DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
      );
Line: 3289

END INSERT_IGS_ROW_UPG;
Line: 3291

PROCEDURE INSERT_TGD_ROW_UPG(p_tgdv_ext_tbl IN tgdv_ext_tbl_type) IS
  l_tabsize NUMBER := p_tgdv_ext_tbl.COUNT;
Line: 3343

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;
Line: 3344

  in_last_update_date              OKC_DATATYPES.DateTabTyp;
Line: 3345

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;
Line: 3400

    in_last_updated_by          (j) := p_tgdv_ext_tbl(i).last_updated_by;
Line: 3401

    in_last_update_date         (j) := p_tgdv_ext_tbl(i).last_update_date;
Line: 3402

    in_last_update_login        (j) := p_tgdv_ext_tbl(i).last_update_login;
Line: 3407

    INSERT
      INTO OKC_TIMEVALUES
      (
        id,
        spn_id,
        tve_id_offset,
        tve_id_generated_by,
        tve_id_started,
        tve_id_ended,
        tve_id_limited,
        cnh_id,
        dnz_chr_id,
        tve_type,
        tze_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        uom_code,
        duration,
        operator,
        before_after,
        datetime,
        month,
        day,
        hour,
        minute,
        second,
        interval_yn,
        last_update_login,
        nth,
        day_of_week,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
--Bug 3122962
        name,
        description,
        short_description,
        comments
     )
     VALUES (
        DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
        DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
        DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
        DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
        DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
        DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
        DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
        DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
        DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
        DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
        DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
        DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
        DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
        DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
        DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
        DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
        DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
        DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
        DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
        DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
        DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
        DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
        DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
        DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
        DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
        DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
        DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
        DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
        DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
        DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
        DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
        DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
        DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
        DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
        DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
        DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
        DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
        DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
        DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
        DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
        DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
        DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
        DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
        DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
        DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
        DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
--Bug 3122962
        DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
        DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
        DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
        DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
     );
Line: 3519

      INSERT INTO OKC_TIMEVALUES_TL(
        id,
        language,
        source_lang,
        sfwt_flag,
        description,
        short_description,
        comments,
        name,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
     )
     VALUES (
        DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
        OKC_UTIL.g_language_code(lang_i),
        l_source_lang,
        DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
        DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
        DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
        DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
        DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
        DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
        DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
        DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
        DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
        DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
      );
Line: 3554

END INSERT_TGD_ROW_UPG;
Line: 3556

PROCEDURE INSERT_ISE_ROW_UPG(p_isev_ext_tbl IN isev_ext_tbl_type) IS
  l_tabsize NUMBER := p_isev_ext_tbl.COUNT;
Line: 3607

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;
Line: 3608

  in_last_update_date              OKC_DATATYPES.DateTabTyp;
Line: 3609

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;
Line: 3669

    in_last_updated_by          (j) := p_isev_ext_tbl(i).last_updated_by;
Line: 3670

    in_last_update_date         (j) := p_isev_ext_tbl(i).last_update_date;
Line: 3671

    in_last_update_login        (j) := p_isev_ext_tbl(i).last_update_login;
Line: 3737

    in_last_updated_by          (j) := p_isev_ext_tbl(i).last_updated_by;
Line: 3738

    in_last_update_date         (j) := p_isev_ext_tbl(i).last_update_date;
Line: 3739

    in_last_update_login        (j) := p_isev_ext_tbl(i).last_update_login;
Line: 3744

    INSERT
      INTO OKC_TIMEVALUES
      (
        id,
        spn_id,
        tve_id_offset,
        tve_id_generated_by,
        tve_id_started,
        tve_id_ended,
        tve_id_limited,
        cnh_id,
        dnz_chr_id,
        tve_type,
        tze_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        uom_code,
        duration,
        operator,
        before_after,
        datetime,
        month,
        day,
        hour,
        minute,
        second,
        interval_yn,
        last_update_login,
        nth,
        day_of_week,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
--Bug 3122962
        name,
        description,
        short_description,
        comments
     )
     VALUES (
        DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
        DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
        DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
        DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
        DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
        DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
        DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
        DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
        DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
        DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
        DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
        DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
        DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
        DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
        DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
        DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
        DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
        DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
        DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
        DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
        DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
        DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
        DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
        DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
        DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
        DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
        DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
        DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
        DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
        DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
        DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
        DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
        DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
        DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
        DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
        DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
        DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
        DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
        DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
        DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
        DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
        DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
        DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
        DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
        DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
        DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
--Bug 3122962
        DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
        DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
        DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
        DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
     );
Line: 3856

      INSERT INTO OKC_TIMEVALUES_TL(
        id,
        language,
        source_lang,
        sfwt_flag,
        description,
        short_description,
        comments,
        name,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
     )
     VALUES (
        DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
        OKC_UTIL.g_language_code(lang_i),
        l_source_lang,
        DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
        DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
        DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
        DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
        DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
        DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
        DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
        DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
        DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
        DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
      );
Line: 3891

END INSERT_ISE_ROW_UPG;
Line: 3893

PROCEDURE INSERT_ISE_ROW_UPG(p_isev_rel_tbl IN isev_rel_tbl_type) IS
  l_tabsize NUMBER := p_isev_rel_tbl.COUNT;
Line: 3944

  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;
Line: 3945

  in_last_update_date              OKC_DATATYPES.DateTabTyp;
Line: 3946

  in_last_update_login             OKC_DATATYPES.NumberTabTyp;
Line: 4011

    in_last_updated_by          (j) := p_isev_rel_tbl(i).last_updated_by;
Line: 4012

    in_last_update_date         (j) := p_isev_rel_tbl(i).last_update_date;
Line: 4013

    in_last_update_login        (j) := p_isev_rel_tbl(i).last_update_login;
Line: 4079

    in_last_updated_by          (j) := p_isev_rel_tbl(i).last_updated_by;
Line: 4080

    in_last_update_date         (j) := p_isev_rel_tbl(i).last_update_date;
Line: 4081

    in_last_update_login        (j) := p_isev_rel_tbl(i).last_update_login;
Line: 4086

    INSERT
      INTO OKC_TIMEVALUES
      (
        id,
        spn_id,
        tve_id_offset,
        tve_id_generated_by,
        tve_id_started,
        tve_id_ended,
        tve_id_limited,
        cnh_id,
        dnz_chr_id,
        tve_type,
        tze_id,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        uom_code,
        duration,
        operator,
        before_after,
        datetime,
        month,
        day,
        hour,
        minute,
        second,
        interval_yn,
        last_update_login,
        nth,
        day_of_week,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15,
--Bug 3122962
        name,
        description,
        short_description,
        comments
     )
     VALUES (
        DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
        DECODE(in_spn_id(i),OKC_API.G_MISS_NUM,NULL,in_spn_id(i)),
        DECODE(in_tve_id_offset(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_offset(i)),
        DECODE(in_tve_id_generated_by(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_generated_by(i)),
        DECODE(in_tve_id_started(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_started(i)),
        DECODE(in_tve_id_ended(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_ended(i)),
        DECODE(in_tve_id_limited(i),OKC_API.G_MISS_NUM,NULL,in_tve_id_limited(i)),
        DECODE(in_cnh_id(i),OKC_API.G_MISS_NUM,NULL,in_cnh_id(i)),
        DECODE(in_dnz_chr_id(i),OKC_API.G_MISS_NUM,NULL,in_dnz_chr_id(i)),
        DECODE(in_tve_type(i),OKC_API.G_MISS_CHAR,NULL,in_tve_type(i)),
        DECODE(in_tze_id(i),OKC_API.G_MISS_NUM,NULL,in_tze_id(i)),
        DECODE(in_object_version_number(i),OKC_API.G_MISS_NUM,NULL,in_object_version_number(i)),
        DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
        DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
        DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
        DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
        DECODE(in_uom_code(i),OKC_API.G_MISS_CHAR,NULL,in_uom_code(i)),
        DECODE(in_duration(i),OKC_API.G_MISS_NUM,NULL,in_duration(i)),
        DECODE(in_operator(i),OKC_API.G_MISS_CHAR,NULL,in_operator(i)),
        DECODE(in_before_after(i),OKC_API.G_MISS_CHAR,NULL,in_before_after(i)),
        DECODE(in_datetime(i),OKC_API.G_MISS_DATE,NULL,in_datetime(i)),
        DECODE(in_month(i),OKC_API.G_MISS_NUM,NULL,in_month(i)),
        DECODE(in_day(i),OKC_API.G_MISS_NUM,NULL,in_day(i)),
        DECODE(in_hour(i),OKC_API.G_MISS_NUM,NULL,in_hour(i)),
        DECODE(in_minute(i),OKC_API.G_MISS_NUM,NULL,in_minute(i)),
        DECODE(in_second(i),OKC_API.G_MISS_NUM,NULL,in_second(i)),
        DECODE(in_interval_yn(i),OKC_API.G_MISS_CHAR,NULL,in_interval_yn(i)),
        DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i)),
        DECODE(in_nth(i),OKC_API.G_MISS_NUM,NULL,in_nth(i)),
        DECODE(in_day_of_week(i),OKC_API.G_MISS_CHAR,NULL,in_day_of_week(i)),
        DECODE(in_attribute_category(i),OKC_API.G_MISS_CHAR,NULL,in_attribute_category(i)),
        DECODE(in_attribute1(i),OKC_API.G_MISS_CHAR,NULL,in_attribute1(i)),
        DECODE(in_attribute2(i),OKC_API.G_MISS_CHAR,NULL,in_attribute2(i)),
        DECODE(in_attribute3(i),OKC_API.G_MISS_CHAR,NULL,in_attribute3(i)),
        DECODE(in_attribute4(i),OKC_API.G_MISS_CHAR,NULL,in_attribute4(i)),
        DECODE(in_attribute5(i),OKC_API.G_MISS_CHAR,NULL,in_attribute5(i)),
        DECODE(in_attribute6(i),OKC_API.G_MISS_CHAR,NULL,in_attribute6(i)),
        DECODE(in_attribute7(i),OKC_API.G_MISS_CHAR,NULL,in_attribute7(i)),
        DECODE(in_attribute8(i),OKC_API.G_MISS_CHAR,NULL,in_attribute8(i)),
        DECODE(in_attribute9(i),OKC_API.G_MISS_CHAR,NULL,in_attribute9(i)),
        DECODE(in_attribute10(i),OKC_API.G_MISS_CHAR,NULL,in_attribute10(i)),
        DECODE(in_attribute11(i),OKC_API.G_MISS_CHAR,NULL,in_attribute11(i)),
        DECODE(in_attribute12(i),OKC_API.G_MISS_CHAR,NULL,in_attribute12(i)),
        DECODE(in_attribute13(i),OKC_API.G_MISS_CHAR,NULL,in_attribute13(i)),
        DECODE(in_attribute14(i),OKC_API.G_MISS_CHAR,NULL,in_attribute14(i)),
        DECODE(in_attribute15(i),OKC_API.G_MISS_CHAR,NULL,in_attribute15(i)),
--Bug 3122962
        DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
        DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
        DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
        DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i))
     );
Line: 4198

      INSERT INTO OKC_TIMEVALUES_TL(
        id,
        language,
        source_lang,
        sfwt_flag,
        description,
        short_description,
        comments,
        name,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login
     )
     VALUES (
        DECODE(in_id(i),OKC_API.G_MISS_NUM,NULL,in_id(i)),
        OKC_UTIL.g_language_code(lang_i),
        l_source_lang,
        DECODE(in_sfwt_flag(i),OKC_API.G_MISS_CHAR,NULL,in_sfwt_flag(i)),
        DECODE(in_description(i),OKC_API.G_MISS_CHAR,NULL,in_description(i)),
        DECODE(in_short_description(i),OKC_API.G_MISS_CHAR,NULL,in_short_description(i)),
        DECODE(in_comments(i),OKC_API.G_MISS_CHAR,NULL,in_comments(i)),
        DECODE(in_name(i),OKC_API.G_MISS_CHAR,NULL,in_name(i)),
        DECODE(in_created_by(i),OKC_API.G_MISS_NUM,NULL,in_created_by(i)),
        DECODE(in_creation_date(i),OKC_API.G_MISS_DATE,NULL,in_creation_date(i)),
        DECODE(in_last_updated_by(i),OKC_API.G_MISS_NUM,NULL,in_last_updated_by(i)),
        DECODE(in_last_update_date(i),OKC_API.G_MISS_DATE,NULL,in_last_update_date(i)),
        DECODE(in_last_update_login(i),OKC_API.G_MISS_NUM,NULL,in_last_update_login(i))
      );
Line: 4233

END INSERT_ise_ROW_UPG;