DBA Data[Home] [Help]

APPS.OKC_SAE_PVT SQL Statements

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

Line: 57

/* 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_STD_ARTICLES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_STD_ARTICLES_B B
         WHERE B.ID = T.ID
        );
Line: 69

    UPDATE OKC_STD_ARTICLES_TL T SET (
        NAME) = (SELECT
                                  B.NAME
                                FROM OKC_STD_ARTICLES_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_STD_ARTICLES_TL SUBB, OKC_STD_ARTICLES_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.NAME <> SUBT.NAME
              ));
Line: 88

    INSERT INTO OKC_STD_ARTICLES_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        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.NAME,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKC_STD_ARTICLES_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKC_STD_ARTICLES_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );
Line: 135

    SELECT
            ID,
            SBT_CODE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Okc_Std_Articles_B
     WHERE okc_std_articles_b.id = p_id;
Line: 180

              l_sae_rec.LAST_UPDATED_BY,
              l_sae_rec.LAST_UPDATE_DATE,
              l_sae_rec.LAST_UPDATE_LOGIN,
              l_sae_rec.ATTRIBUTE_CATEGORY,
              l_sae_rec.ATTRIBUTE1,
              l_sae_rec.ATTRIBUTE2,
              l_sae_rec.ATTRIBUTE3,
              l_sae_rec.ATTRIBUTE4,
              l_sae_rec.ATTRIBUTE5,
              l_sae_rec.ATTRIBUTE6,
              l_sae_rec.ATTRIBUTE7,
              l_sae_rec.ATTRIBUTE8,
              l_sae_rec.ATTRIBUTE9,
              l_sae_rec.ATTRIBUTE10,
              l_sae_rec.ATTRIBUTE11,
              l_sae_rec.ATTRIBUTE12,
              l_sae_rec.ATTRIBUTE13,
              l_sae_rec.ATTRIBUTE14,
              l_sae_rec.ATTRIBUTE15;
Line: 229

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            NAME,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Std_Articles_Tl
     WHERE okc_std_articles_tl.id = p_id
       AND okc_std_articles_tl.language = p_language;
Line: 264

              l_okc_std_articles_tl_rec.LAST_UPDATED_BY,
              l_okc_std_articles_tl_rec.LAST_UPDATE_DATE,
              l_okc_std_articles_tl_rec.LAST_UPDATE_LOGIN;
Line: 296

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            SBT_CODE,
            NAME,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Std_Articles_V
     WHERE okc_std_articles_v.id = p_id;
Line: 361

              l_saev_rec.LAST_UPDATED_BY,
              l_saev_rec.LAST_UPDATE_DATE,
              l_saev_rec.LAST_UPDATE_LOGIN;
Line: 465

    IF (l_saev_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_saev_rec.last_updated_by := NULL;
Line: 468

    IF (l_saev_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_saev_rec.last_update_date := NULL;
Line: 471

    IF (l_saev_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_saev_rec.last_update_login := NULL;
Line: 499

 Cursor l_ate_csr is select '1'
       from okc_k_articles_b ate
       where ate.sav_sae_id=p_saev_rec.id;
Line: 873

    cursor c1 is select id  from okc_std_articles_v where UPPER(name)=UPPER(p_saev_rec.name);
Line: 1077

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

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

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

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

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

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

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

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

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

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

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

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

  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_sae_rec                      IN sae_rec_type,
    x_sae_rec                      OUT NOCOPY sae_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1388

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

       okc_debug.log('5600: Entered insert_row', 2);
Line: 1432

    INSERT INTO OKC_STD_ARTICLES_B(
        id,
        sbt_code,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15)
      VALUES (
        l_sae_rec.id,
        l_sae_rec.sbt_code,
        l_sae_rec.object_version_number,
        l_sae_rec.created_by,
        l_sae_rec.creation_date,
        l_sae_rec.last_updated_by,
        l_sae_rec.last_update_date,
        l_sae_rec.last_update_login,
        l_sae_rec.attribute_category,
        l_sae_rec.attribute1,
        l_sae_rec.attribute2,
        l_sae_rec.attribute3,
        l_sae_rec.attribute4,
        l_sae_rec.attribute5,
        l_sae_rec.attribute6,
        l_sae_rec.attribute7,
        l_sae_rec.attribute8,
        l_sae_rec.attribute9,
        l_sae_rec.attribute10,
        l_sae_rec.attribute11,
        l_sae_rec.attribute12,
        l_sae_rec.attribute13,
        l_sae_rec.attribute14,
        l_sae_rec.attribute15);
Line: 1487

       okc_debug.log('5700: Leaving  insert_row', 2);
Line: 1495

       okc_debug.log('5800: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 1511

       okc_debug.log('5900: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 1527

       okc_debug.log('6000: Exiting insert_row:OTHERS Exception', 2);
Line: 1541

  END insert_row;
Line: 1545

  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_std_articles_tl_rec      IN okc_std_articles_tl_rec_type,
    x_okc_std_articles_tl_rec      OUT NOCOPY okc_std_articles_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1554

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

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

       okc_debug.log('6200: Entered insert_row', 2);
Line: 1608

      INSERT INTO OKC_STD_ARTICLES_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          name,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okc_std_articles_tl_rec.id,
          l_okc_std_articles_tl_rec.language,
          l_okc_std_articles_tl_rec.source_lang,
          l_okc_std_articles_tl_rec.sfwt_flag,
          l_okc_std_articles_tl_rec.name,
          l_okc_std_articles_tl_rec.created_by,
          l_okc_std_articles_tl_rec.creation_date,
          l_okc_std_articles_tl_rec.last_updated_by,
          l_okc_std_articles_tl_rec.last_update_date,
          l_okc_std_articles_tl_rec.last_update_login);
Line: 1636

       okc_debug.log('6300: Leaving  insert_row', 2);
Line: 1644

       okc_debug.log('6400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 1660

       okc_debug.log('6500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 1676

       okc_debug.log('6600: Exiting insert_row:OTHERS Exception', 2);
Line: 1690

  END insert_row;
Line: 1694

  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_saev_rec                     IN saev_rec_type,
    x_saev_rec                     OUT NOCOPY saev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1704

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

      l_saev_rec.LAST_UPDATE_DATE := l_saev_rec.creation_date;
Line: 1725

      l_saev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1726

      l_saev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1756

       okc_debug.log('6900: Entered insert_row', 2);
Line: 1807

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sae_rec,
      lx_sae_rec
    );
Line: 1821

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_std_articles_tl_rec,
      lx_okc_std_articles_tl_rec
    );
Line: 1841

       okc_debug.log('7000: Leaving  insert_row', 2);
Line: 1849

       okc_debug.log('7100: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 1865

       okc_debug.log('7200: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 1881

       okc_debug.log('7300: Exiting insert_row:OTHERS Exception', 2);
Line: 1895

  END insert_row;
Line: 1899

  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_saev_tbl                     IN saev_tbl_type,
    x_saev_tbl                     OUT NOCOPY saev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1909

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

       okc_debug.log('7400: Entered insert_row', 2);
Line: 1923

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => p_init_msg_list,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_saev_rec                     => p_saev_tbl(i),
          x_saev_rec                     => x_saev_tbl(i));
Line: 1937

       okc_debug.log('7500: Leaving  insert_row', 2);
Line: 1945

       okc_debug.log('7600: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 1961

       okc_debug.log('7700: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 1977

       okc_debug.log('7800: Exiting insert_row:OTHERS Exception', 2);
Line: 1991

  END insert_row;
Line: 2009

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_STD_ARTICLES_B
     WHERE ID = p_sae_rec.id
       AND OBJECT_VERSION_NUMBER = p_sae_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 2016

    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_STD_ARTICLES_B
    WHERE ID = p_sae_rec.id;
Line: 2081

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

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

    SELECT *
      FROM OKC_STD_ARTICLES_TL
     WHERE ID = p_okc_std_articles_tl_rec.id
    FOR UPDATE NOWAIT;
Line: 2224

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

  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_sae_rec                      IN sae_rec_type,
    x_sae_rec                      OUT NOCOPY sae_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2520

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

      IF (x_sae_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sae_rec.last_updated_by := l_sae_rec.last_updated_by;
Line: 2572

      IF (x_sae_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sae_rec.last_update_date := l_sae_rec.last_update_date;
Line: 2576

      IF (x_sae_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sae_rec.last_update_login := l_sae_rec.last_update_login;
Line: 2671

       okc_debug.log('10700: Entered update_row', 2);
Line: 2699

    UPDATE  OKC_STD_ARTICLES_B
    SET SBT_CODE = l_def_sae_rec.sbt_code,
        OBJECT_VERSION_NUMBER = l_def_sae_rec.object_version_number,
        CREATED_BY = l_def_sae_rec.created_by,
        CREATION_DATE = l_def_sae_rec.creation_date,
        LAST_UPDATED_BY = l_def_sae_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_sae_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_sae_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_sae_rec.attribute_category,
        ATTRIBUTE1 = l_def_sae_rec.attribute1,
        ATTRIBUTE2 = l_def_sae_rec.attribute2,
        ATTRIBUTE3 = l_def_sae_rec.attribute3,
        ATTRIBUTE4 = l_def_sae_rec.attribute4,
        ATTRIBUTE5 = l_def_sae_rec.attribute5,
        ATTRIBUTE6 = l_def_sae_rec.attribute6,
        ATTRIBUTE7 = l_def_sae_rec.attribute7,
        ATTRIBUTE8 = l_def_sae_rec.attribute8,
        ATTRIBUTE9 = l_def_sae_rec.attribute9,
        ATTRIBUTE10 = l_def_sae_rec.attribute10,
        ATTRIBUTE11 = l_def_sae_rec.attribute11,
        ATTRIBUTE12 = l_def_sae_rec.attribute12,
        ATTRIBUTE13 = l_def_sae_rec.attribute13,
        ATTRIBUTE14 = l_def_sae_rec.attribute14,
        ATTRIBUTE15 = l_def_sae_rec.attribute15
    WHERE ID = l_def_sae_rec.id;
Line: 2729

    okc_debug.log('10800: Leaving  update_row', 2);
Line: 2737

       okc_debug.log('10900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2753

       okc_debug.log('11000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2769

       okc_debug.log('11100: Exiting update_row:OTHERS Exception', 2);
Line: 2784

  END update_row;
Line: 2788

  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_std_articles_tl_rec      IN okc_std_articles_tl_rec_type,
    x_okc_std_articles_tl_rec      OUT NOCOPY okc_std_articles_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2797

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

      IF (x_okc_std_articles_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_okc_std_articles_tl_rec.last_updated_by := l_okc_std_articles_tl_rec.last_updated_by;
Line: 2857

      IF (x_okc_std_articles_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_okc_std_articles_tl_rec.last_update_date := l_okc_std_articles_tl_rec.last_update_date;
Line: 2861

      IF (x_okc_std_articles_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_okc_std_articles_tl_rec.last_update_login := l_okc_std_articles_tl_rec.last_update_login;
Line: 2896

       okc_debug.log('11400: Entered update_row', 2);
Line: 2924

    UPDATE  OKC_STD_ARTICLES_TL
    SET NAME = ldefokcstdarticlestlrec.name,
        CREATED_BY = ldefokcstdarticlestlrec.created_by,
        CREATION_DATE = ldefokcstdarticlestlrec.creation_date,
        LAST_UPDATED_BY = ldefokcstdarticlestlrec.last_updated_by,
        LAST_UPDATE_DATE = ldefokcstdarticlestlrec.last_update_date,
        LAST_UPDATE_LOGIN = ldefokcstdarticlestlrec.last_update_login
--added after tapi
       ,SOURCE_LANG  =     ldefokcstdarticlestlrec.source_lang
--end added after tapi
    WHERE ID = ldefokcstdarticlestlrec.id
--commented after tapi replaced with following
      --AND SOURCE_LANG = USERENV('LANG');
Line: 2940

    UPDATE  OKC_STD_ARTICLES_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = ldefokcstdarticlestlrec.id
      AND SOURCE_LANG <> USERENV('LANG');
Line: 2949

       okc_debug.log('11500: Leaving  update_row', 2);
Line: 2957

       okc_debug.log('11600: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 2973

       okc_debug.log('11700: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 2989

       okc_debug.log('11800: Exiting update_row:OTHERS Exception', 2);
Line: 3003

  END update_row;
Line: 3007

  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_saev_rec                     IN saev_rec_type,
    x_saev_rec                     OUT NOCOPY saev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3017

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

      l_saev_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 3035

      l_saev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 3036

      l_saev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3155

      IF (x_saev_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_saev_rec.last_updated_by := l_saev_rec.last_updated_by;
Line: 3159

      IF (x_saev_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_saev_rec.last_update_date := l_saev_rec.last_update_date;
Line: 3163

      IF (x_saev_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_saev_rec.last_update_login := l_saev_rec.last_update_login;
Line: 3201

       okc_debug.log('12200: Entered update_row', 2);
Line: 3256

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_std_articles_tl_rec,
      lx_okc_std_articles_tl_rec
    );
Line: 3270

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sae_rec,
      lx_sae_rec
    );
Line: 3289

       okc_debug.log('12300: Leaving  update_row', 2);
Line: 3297

       okc_debug.log('12400: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 3313

       okc_debug.log('12500: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 3329

       okc_debug.log('12600: Exiting update_row:OTHERS Exception', 2);
Line: 3343

  END update_row;
Line: 3347

  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_saev_tbl                     IN saev_tbl_type,
    x_saev_tbl                     OUT NOCOPY saev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3357

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

       okc_debug.log('12700: Entered update_row', 2);
Line: 3371

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => p_init_msg_list,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_saev_rec                     => p_saev_tbl(i),
          x_saev_rec                     => x_saev_tbl(i));
Line: 3385

       okc_debug.log('12800: Leaving  update_row', 2);
Line: 3393

       okc_debug.log('12900: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 3409

       okc_debug.log('13000: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 3425

       okc_debug.log('13100: Exiting update_row:OTHERS Exception', 2);
Line: 3439

  END update_row;
Line: 3447

  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_sae_rec                      IN sae_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3455

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

       okc_debug.log('13200: Entered delete_row', 2);
Line: 3475

    DELETE FROM OKC_STD_ARTICLES_B
     WHERE ID = l_sae_rec.id;
Line: 3481

       okc_debug.log('13300: Leaving  delete_row', 2);
Line: 3489

       okc_debug.log('13400: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 3505

       okc_debug.log('13500: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 3521

       okc_debug.log('13600: Exiting delete_row:OTHERS Exception', 2);
Line: 3535

  END delete_row;
Line: 3539

  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_std_articles_tl_rec      IN okc_std_articles_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3547

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

       okc_debug.log('13800: Entered delete_row', 2);
Line: 3598

    DELETE FROM OKC_STD_ARTICLES_TL
     WHERE ID = l_okc_std_articles_tl_rec.id;
Line: 3604

       okc_debug.log('13900: Leaving  delete_row', 2);
Line: 3612

       okc_debug.log('14000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 3628

       okc_debug.log('14100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 3644

       okc_debug.log('14200: Exiting delete_row:OTHERS Exception', 2);
Line: 3658

  END delete_row;
Line: 3662

  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_saev_rec                     IN saev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3671

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

       okc_debug.log('14300: Entered delete_row', 2);
Line: 3703

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_std_articles_tl_rec
    );
Line: 3715

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sae_rec
    );
Line: 3730

       okc_debug.log('14400: Leaving  delete_row', 2);
Line: 3738

       okc_debug.log('14500: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 3754

       okc_debug.log('14600: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 3770

       okc_debug.log('14700: Exiting delete_row:OTHERS Exception', 2);
Line: 3784

  END delete_row;
Line: 3788

  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_saev_tbl                     IN saev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3797

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

       okc_debug.log('14800: Entered delete_row', 2);
Line: 3811

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => p_init_msg_list,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_saev_rec                     => p_saev_tbl(i));
Line: 3824

       okc_debug.log('14900: Leaving  delete_row', 2);
Line: 3832

       okc_debug.log('15000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);
Line: 3848

       okc_debug.log('15100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
Line: 3864

       okc_debug.log('15200: Exiting delete_row:OTHERS Exception', 2);
Line: 3878

  END delete_row;