eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_SCN_PVT SQL Statements

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

Line: 106


  	  select 'x'
	  from OKC_K_HEADERS_B
  	  where id = p_scnv_rec.chr_id;

Line: 187


      SELECT 'x'
        FROM FND_LOOKUP_VALUES satv
       WHERE satv.LOOKUP_CODE = p_scnv_rec.sat_code
         AND satv.lookup_type = 'OKC_ARTICLE_SET';

Line: 429


  	  select 'x'
	  from OKC_SECTIONS_B
  	  where id = p_scnv_rec.scn_id;

Line: 517


    DELETE FROM OKC_SECTIONS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_SECTIONS_B B
         WHERE B.ID = T.ID
        );

Line: 524


    UPDATE OKC_SECTIONS_TL T SET (
        HEADING) = (SELECT
                                  B.HEADING
                                FROM OKC_SECTIONS_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_SECTIONS_TL SUBB, OKC_SECTIONS_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.HEADING <> SUBT.HEADING
                      OR (SUBB.HEADING IS NULL AND SUBT.HEADING IS NOT NULL)
                      OR (SUBB.HEADING IS NOT NULL AND SUBT.HEADING IS NULL)
              ));

Line: 544


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

Line: 575


    DELETE FROM OKC_SECTIONS_TLH T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKC_SECTIONS_BH B
         WHERE B.ID = T.ID
           AND B.MAJOR_VERSION = T.MAJOR_VERSION
        );

Line: 583


    UPDATE OKC_SECTIONS_TLH T SET (
        HEADING) = (SELECT
                                  B.HEADING
                                FROM OKC_SECTIONS_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_SECTIONS_TLH SUBB, OKC_SECTIONS_TLH SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.MAJOR_VERSION = SUBT.MAJOR_VERSION
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.HEADING <> SUBT.HEADING
                      OR (SUBB.HEADING IS NULL AND SUBT.HEADING IS NOT NULL)
                      OR (SUBB.HEADING IS NOT NULL AND SUBT.HEADING IS NULL)
              ));

Line: 607


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

Line: 658


    SELECT
            ID,
            SCN_TYPE,
            CHR_ID,
            SAT_CODE,
            SECTION_SEQUENCE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            LABEL,
            SCN_ID,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Okc_Sections_B
     WHERE okc_sections_b.id    = p_id;

Line: 711


              l_scn_rec.LAST_UPDATED_BY,
              l_scn_rec.LAST_UPDATE_DATE,
              l_scn_rec.LAST_UPDATE_LOGIN,
              l_scn_rec.LABEL,
              l_scn_rec.SCN_ID,
              l_scn_rec.ATTRIBUTE_CATEGORY,
              l_scn_rec.ATTRIBUTE1,
              l_scn_rec.ATTRIBUTE2,
              l_scn_rec.ATTRIBUTE3,
              l_scn_rec.ATTRIBUTE4,
              l_scn_rec.ATTRIBUTE5,
              l_scn_rec.ATTRIBUTE6,
              l_scn_rec.ATTRIBUTE7,
              l_scn_rec.ATTRIBUTE8,
              l_scn_rec.ATTRIBUTE9,
              l_scn_rec.ATTRIBUTE10,
              l_scn_rec.ATTRIBUTE11,
              l_scn_rec.ATTRIBUTE12,
              l_scn_rec.ATTRIBUTE13,
              l_scn_rec.ATTRIBUTE14,
              l_scn_rec.ATTRIBUTE15;

Line: 762


    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            HEADING,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okc_Sections_Tl
     WHERE okc_sections_tl.id   = p_id
       AND okc_sections_tl.language = p_language;

Line: 797


              l_okc_sections_tl_rec.LAST_UPDATED_BY,
              l_okc_sections_tl_rec.LAST_UPDATE_DATE,
              l_okc_sections_tl_rec.LAST_UPDATE_LOGIN;

Line: 830


    SELECT
		ID,
		SCN_TYPE,
		CHR_ID,
		SAT_CODE,
		SECTION_SEQUENCE,
		LABEL,
		HEADING,
		SCN_ID,
		OBJECT_VERSION_NUMBER,
		SFWT_FLAG,
		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_sections_v
	WHERE okc_sections_v.id = p_id;

Line: 895


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

Line: 988


    IF (l_scnv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_scnv_rec.last_updated_by := NULL;

Line: 991


    IF (l_scnv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_scnv_rec.last_update_date := NULL;

Line: 994


    IF (l_scnv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_scnv_rec.last_update_login := NULL;

Line: 1189


    SELECT 'x'
    FROM   okc_sections_v
    WHERE  chr_id           = p_scnv_rec.CHR_ID
    AND    sat_code         = p_scnv_rec.SAT_CODE
    AND    section_sequence = p_scnv_rec.SECTION_SEQUENCE
    AND    scn_id           = p_scnv_rec.SCN_ID
    AND    id              <> NVL(p_scnv_rec.ID,-9999);

Line: 1198


    SELECT 'x'
    FROM   okc_sections_b
    WHERE  chr_id           = p_scnv_rec.CHR_ID
    AND    sat_code         = p_scnv_rec.SAT_CODE
    AND    section_sequence = p_scnv_rec.SECTION_SEQUENCE
    AND    scn_id          IS NULL
    AND    id              <> NVL(p_scnv_rec.ID,-9999);

Line: 1293


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1294


    p_to.last_update_date := p_from.last_update_date;

Line: 1295


    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: 1334


    p_to.last_update_login := p_from.last_update_login;

Line: 1368


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1369


    p_to.last_update_date := p_from.last_update_date;

Line: 1370


    p_to.last_update_login := p_from.last_update_login;

Line: 1386


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1387


    p_to.last_update_date := p_from.last_update_date;

Line: 1388


    p_to.last_update_login := p_from.last_update_login;

Line: 1601


  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_scn_rec                      IN scn_rec_type,
    x_scn_rec                      OUT NOCOPY scn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1610


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

Line: 1632


       okc_debug.log('5200: Entered insert_row', 2);

Line: 1654


    INSERT INTO OKC_SECTIONS_B(
        id,
        scn_type,
        chr_id,
        sat_code,
        section_sequence,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        label,
        scn_id,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15)
      VALUES (
        l_scn_rec.id,
        l_scn_rec.scn_type,
        l_scn_rec.chr_id,
        l_scn_rec.sat_code,
        l_scn_rec.section_sequence,
        l_scn_rec.object_version_number,
        l_scn_rec.created_by,
        l_scn_rec.creation_date,
        l_scn_rec.last_updated_by,
        l_scn_rec.last_update_date,
        l_scn_rec.last_update_login,
        l_scn_rec.label,
        l_scn_rec.scn_id,
        l_scn_rec.attribute_category,
        l_scn_rec.attribute1,
        l_scn_rec.attribute2,
        l_scn_rec.attribute3,
        l_scn_rec.attribute4,
        l_scn_rec.attribute5,
        l_scn_rec.attribute6,
        l_scn_rec.attribute7,
        l_scn_rec.attribute8,
        l_scn_rec.attribute9,
        l_scn_rec.attribute10,
        l_scn_rec.attribute11,
        l_scn_rec.attribute12,
        l_scn_rec.attribute13,
        l_scn_rec.attribute14,
        l_scn_rec.attribute15);

Line: 1720


       okc_debug.log('5300: Leaving  insert_row', 2);

Line: 1728


       okc_debug.log('5400: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 1744


       okc_debug.log('5500: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 1760


       okc_debug.log('5600: Exiting insert_row:OTHERS Exception', 2);

Line: 1774


  END insert_row;

Line: 1778


  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_sections_tl_rec          IN okc_sections_tl_rec_type,
    x_okc_sections_tl_rec          OUT NOCOPY okc_sections_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1787


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

Line: 1792


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

Line: 1815


       okc_debug.log('5800: Entered insert_row', 2);

Line: 1839


      INSERT INTO OKC_SECTIONS_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          heading,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login)
        VALUES (
          l_okc_sections_tl_rec.id,
          l_okc_sections_tl_rec.language,
          l_okc_sections_tl_rec.source_lang,
          l_okc_sections_tl_rec.sfwt_flag,
          l_okc_sections_tl_rec.heading,
          l_okc_sections_tl_rec.created_by,
          l_okc_sections_tl_rec.creation_date,
          l_okc_sections_tl_rec.last_updated_by,
          l_okc_sections_tl_rec.last_update_date,
          l_okc_sections_tl_rec.last_update_login);

Line: 1867


       okc_debug.log('5900: Leaving  insert_row', 2);

Line: 1875


       okc_debug.log('6000: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 1891


       okc_debug.log('6100: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 1907


       okc_debug.log('6200: Exiting insert_row:OTHERS Exception', 2);

Line: 1921


  END insert_row;

Line: 1925


  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_scnv_rec                     IN scnv_rec_type,
    x_scnv_rec                     OUT NOCOPY scnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1935


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

Line: 1954


      l_scnv_rec.LAST_UPDATE_DATE := l_scnv_rec.CREATION_DATE;

Line: 1955


      l_scnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1956


      l_scnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1990


       okc_debug.log('6500: Entered insert_row', 2);

Line: 2041


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_scn_rec,
      lx_scn_rec
    );

Line: 2055


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_sections_tl_rec,
      lx_okc_sections_tl_rec
    );

Line: 2074


       okc_debug.log('6600: Leaving  insert_row', 2);

Line: 2082


       okc_debug.log('6700: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2098


       okc_debug.log('6800: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 2114


       okc_debug.log('6900: Exiting insert_row:OTHERS Exception', 2);

Line: 2128


  END insert_row;

Line: 2132


  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_scnv_tbl                     IN scnv_tbl_type,
    x_scnv_tbl                     OUT NOCOPY scnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2142


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

Line: 2149


       okc_debug.log('7000: Entered insert_row', 2);

Line: 2157


        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_scnv_rec                     => p_scnv_tbl(i),
          x_scnv_rec                     => x_scnv_tbl(i));

Line: 2171


       okc_debug.log('7100: Leaving  insert_row', 2);

Line: 2179


       okc_debug.log('7200: Exiting insert_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2195


       okc_debug.log('7300: Exiting insert_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 2211


       okc_debug.log('7400: Exiting insert_row:OTHERS Exception', 2);

Line: 2225


  END insert_row;

Line: 2243


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_SECTIONS_B
     WHERE ID = p_scn_rec.id
       AND OBJECT_VERSION_NUMBER = p_scn_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2250


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_SECTIONS_B
    WHERE ID = p_scn_rec.id;

Line: 2308


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2317


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2391


    SELECT *
      FROM OKC_SECTIONS_TL
     WHERE ID = p_okc_sections_tl_rec.id
    FOR UPDATE NOWAIT;

Line: 2444


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2731


  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_scn_rec                      IN scn_rec_type,
    x_scn_rec                      OUT NOCOPY scn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2740


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

Line: 2800


      IF (x_scn_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_scn_rec.last_updated_by := l_scn_rec.last_updated_by;

Line: 2804


      IF (x_scn_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_scn_rec.last_update_date := l_scn_rec.last_update_date;

Line: 2808


      IF (x_scn_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_scn_rec.last_update_login := l_scn_rec.last_update_login;

Line: 2910


       okc_debug.log('10300: Entered update_row', 2);

Line: 2938


    UPDATE  OKC_SECTIONS_B
    SET SCN_TYPE = l_def_scn_rec.scn_type,
        CHR_ID = l_def_scn_rec.chr_id,
        SAT_CODE = l_def_scn_rec.sat_code,
        SECTION_SEQUENCE = l_def_scn_rec.section_sequence,
        OBJECT_VERSION_NUMBER = l_def_scn_rec.object_version_number,
        CREATED_BY = l_def_scn_rec.created_by,
        CREATION_DATE = l_def_scn_rec.creation_date,
        LAST_UPDATED_BY = l_def_scn_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_scn_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_scn_rec.last_update_login,
        LABEL = l_def_scn_rec.label,
        SCN_ID = l_def_scn_rec.scn_id,
        ATTRIBUTE_CATEGORY = l_def_scn_rec.attribute_category,
        ATTRIBUTE1 = l_def_scn_rec.attribute1,
        ATTRIBUTE2 = l_def_scn_rec.attribute2,
        ATTRIBUTE3 = l_def_scn_rec.attribute3,
        ATTRIBUTE4 = l_def_scn_rec.attribute4,
        ATTRIBUTE5 = l_def_scn_rec.attribute5,
        ATTRIBUTE6 = l_def_scn_rec.attribute6,
        ATTRIBUTE7 = l_def_scn_rec.attribute7,
        ATTRIBUTE8 = l_def_scn_rec.attribute8,
        ATTRIBUTE9 = l_def_scn_rec.attribute9,
        ATTRIBUTE10 = l_def_scn_rec.attribute10,
        ATTRIBUTE11 = l_def_scn_rec.attribute11,
        ATTRIBUTE12 = l_def_scn_rec.attribute12,
        ATTRIBUTE13 = l_def_scn_rec.attribute13,
        ATTRIBUTE14 = l_def_scn_rec.attribute14,
        ATTRIBUTE15 = l_def_scn_rec.attribute15
    WHERE ID = l_def_scn_rec.id;

Line: 2973


       okc_debug.log('10400: Leaving  update_row', 2);

Line: 2981


       okc_debug.log('10500: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 2997


       okc_debug.log('10600: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3013


       okc_debug.log('10700: Exiting update_row:OTHERS Exception', 2);

Line: 3027


  END update_row;

Line: 3031


  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_sections_tl_rec          IN okc_sections_tl_rec_type,
    x_okc_sections_tl_rec          OUT NOCOPY okc_sections_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3040


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

Line: 3096


      IF (x_okc_sections_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_okc_sections_tl_rec.last_updated_by := l_okc_sections_tl_rec.last_updated_by;

Line: 3100


      IF (x_okc_sections_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_okc_sections_tl_rec.last_update_date := l_okc_sections_tl_rec.last_update_date;

Line: 3104


      IF (x_okc_sections_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_okc_sections_tl_rec.last_update_login := l_okc_sections_tl_rec.last_update_login;

Line: 3136


       okc_debug.log('11000: Entered update_row', 2);

Line: 3164


    UPDATE  OKC_SECTIONS_TL
    SET HEADING = l_def_okc_sections_tl_rec.heading,
        CREATED_BY = l_def_okc_sections_tl_rec.created_by,
        CREATION_DATE = l_def_okc_sections_tl_rec.creation_date,
        LAST_UPDATED_BY = l_def_okc_sections_tl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_okc_sections_tl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_okc_sections_tl_rec.last_update_login
    WHERE ID = l_def_okc_sections_tl_rec.id
      AND SOURCE_LANG = USERENV('LANG');

Line: 3174


    UPDATE  OKC_SECTIONS_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = l_def_okc_sections_tl_rec.id
      AND SOURCE_LANG <> USERENV('LANG');

Line: 3184


       okc_debug.log('11100: Leaving  update_row', 2);

Line: 3192


       okc_debug.log('11200: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3208


       okc_debug.log('11300: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3224


       okc_debug.log('11400: Exiting update_row:OTHERS Exception', 2);

Line: 3238


  END update_row;

Line: 3242


  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_scnv_rec                     IN scnv_rec_type,
    x_scnv_rec                     OUT NOCOPY scnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3252


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

Line: 3269


      l_scnv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3270


      l_scnv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3271


      l_scnv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3346


      IF (x_scnv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_scnv_rec.last_updated_by := l_scnv_rec.last_updated_by;

Line: 3350


      IF (x_scnv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_scnv_rec.last_update_date := l_scnv_rec.last_update_date;

Line: 3354


      IF (x_scnv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_scnv_rec.last_update_login := l_scnv_rec.last_update_login;

Line: 3424


       okc_debug.log('11100: Leaving  update_row', 2);

Line: 3450


       okc_debug.log('11800: Entered update_row', 2);

Line: 3505


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_sections_tl_rec,
      lx_okc_sections_tl_rec
    );

Line: 3519


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_scn_rec,
      lx_scn_rec
    );

Line: 3538


       okc_debug.log('11900: Leaving  update_row', 2);

Line: 3546


       okc_debug.log('12000: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3562


       okc_debug.log('12100: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3578


       okc_debug.log('12200: Exiting update_row:OTHERS Exception', 2);

Line: 3592


  END update_row;

Line: 3596


  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_scnv_tbl                     IN scnv_tbl_type,
    x_scnv_tbl                     OUT NOCOPY scnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3606


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

Line: 3613


       okc_debug.log('12300: Entered update_row', 2);

Line: 3621


        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_scnv_rec                     => p_scnv_tbl(i),
          x_scnv_rec                     => x_scnv_tbl(i));

Line: 3635


   okc_debug.log('12400: Leaving  update_row', 2);

Line: 3643


       okc_debug.log('12500: Exiting update_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3659


       okc_debug.log('12600: Exiting update_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3675


       okc_debug.log('12700: Exiting update_row:OTHERS Exception', 2);

Line: 3689


  END update_row;

Line: 3697


  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_scn_rec                      IN scn_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3705


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

Line: 3713


       okc_debug.log('12800: Entered delete_row', 2);

Line: 3725


    DELETE FROM OKC_SECTIONS_B
     WHERE ID = l_scn_rec.id;

Line: 3731


       okc_debug.log('12900: Leaving  delete_row', 2);

Line: 3739


       okc_debug.log('13000: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3755


       okc_debug.log('13100: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3771


       okc_debug.log('13200: Exiting delete_row:OTHERS Exception', 2);

Line: 3785


  END delete_row;

Line: 3789


  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_sections_tl_rec          IN okc_sections_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3797


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

Line: 3820


       okc_debug.log('13400: Entered delete_row', 2);

Line: 3842


    DELETE FROM OKC_SECTIONS_TL
     WHERE ID = l_okc_sections_tl_rec.id;

Line: 3848


       okc_debug.log('13500: Leaving  delete_row', 2);

Line: 3856


       okc_debug.log('13600: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3872


       okc_debug.log('13700: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 3888


       okc_debug.log('13800: Exiting delete_row:OTHERS Exception', 2);

Line: 3902


  END delete_row;

Line: 3906


  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_scnv_rec                     IN scnv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3915


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

Line: 3924


       okc_debug.log('13900: Entered delete_row', 2);

Line: 3947


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okc_sections_tl_rec
    );

Line: 3959


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_scn_rec
    );

Line: 3974


       okc_debug.log('14000: Leaving  delete_row', 2);

Line: 3982


       okc_debug.log('14100: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 3998


       okc_debug.log('14200: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 4014


       okc_debug.log('14300: Exiting delete_row:OTHERS Exception', 2);

Line: 4028


  END delete_row;

Line: 4032


  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_scnv_tbl                     IN scnv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 4041


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

Line: 4048


       okc_debug.log('14400: Entered delete_row', 2);

Line: 4056


        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_scnv_rec                     => p_scnv_tbl(i));

Line: 4069


       okc_debug.log('14500: Leaving  delete_row', 2);

Line: 4077


       okc_debug.log('14600: Exiting delete_row:OKC_API.G_EXCEPTION_ERROR Exception', 2);

Line: 4093


       okc_debug.log('14700: Exiting delete_row:OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

Line: 4109


       okc_debug.log('14800: Exiting delete_row:OTHERS Exception', 2);

Line: 4123


  END delete_row;

Line: 4144


INSERT INTO okc_sections_bh
  (
      major_version,
      id,
      scn_type,
      chr_id,
      sat_code,
      section_sequence,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      label,
      scn_id,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
)
  SELECT
      p_major_version,
      id,
      scn_type,
      chr_id,
      sat_code,
      section_sequence,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      label,
      scn_id,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
  FROM okc_sections_b
WHERE chr_id = p_chr_id;

Line: 4215


INSERT INTO okc_sections_tlh
  (
      major_version,
      id,
      language,
      source_lang,
      sfwt_flag,
      heading,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      p_major_version,
      id,
      language,
      source_lang,
      sfwt_flag,
      heading,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_sections_tl
WHERE id in (SELECT id
			FROM okc_sections_b
		    WHERE chr_id= p_chr_id);

Line: 4295


INSERT INTO okc_sections_tl
  (
      id,
      language,
      source_lang,
      sfwt_flag,
      heading,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
)
  SELECT
      id,
      language,
      source_lang,
      sfwt_flag,
      heading,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login
  FROM okc_sections_tlh
WHERE id in (SELECT id
			FROM okc_sections_bh
		    WHERE chr_id = p_chr_id)
  AND major_version = p_major_version;

Line: 4329


INSERT INTO okc_sections_b
  (
      id,
      scn_type,
      chr_id,
      sat_code,
      section_sequence,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      label,
      scn_id,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
)
  SELECT
      id,
      scn_type,
      chr_id,
      sat_code,
      section_sequence,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      label,
      scn_id,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
  FROM okc_sections_bh
WHERE chr_id = p_chr_id
  AND major_version = p_major_version;