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_SCC_PVT SQL Statements

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

Line: 23


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

Line: 115


  	  select 'x'
	  from OKC_K_ARTICLES_B
  	  where id = p_sccv_rec.cat_id;

Line: 194


  	  select 'x'
	  from OKC_K_LINES_B
  	  where id = p_sccv_rec.cle_id;

Line: 273


  	  select 'x'
	  from OKC_STD_ARTICLES_B
  	  where id = p_sccv_rec.sae_id;

Line: 359


    SELECT 'x'
    FROM   okc_section_contents
    WHERE  scn_id           = p_sccv_rec.SCN_ID
    AND    content_sequence = p_sccv_rec.CONTENT_SEQUENCE
    AND    id <> NVL(p_sccv_rec.ID,-9999);

Line: 464


    SELECT
            ID,
            SCN_ID,
            CONTENT_SEQUENCE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            LABEL,
            CAT_ID,
            CLE_ID,
            SAE_ID,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Okc_Section_Contents
     WHERE okc_section_contents.id = p_id;

Line: 515


              l_scc_rec.LAST_UPDATED_BY,
              l_scc_rec.LAST_UPDATE_DATE,
              l_scc_rec.LAST_UPDATE_LOGIN,
              l_scc_rec.LABEL,
              l_scc_rec.CAT_ID,
              l_scc_rec.CLE_ID,
              l_scc_rec.SAE_ID,
              l_scc_rec.ATTRIBUTE_CATEGORY,
              l_scc_rec.ATTRIBUTE1,
              l_scc_rec.ATTRIBUTE2,
              l_scc_rec.ATTRIBUTE3,
              l_scc_rec.ATTRIBUTE4,
              l_scc_rec.ATTRIBUTE5,
              l_scc_rec.ATTRIBUTE6,
              l_scc_rec.ATTRIBUTE7,
              l_scc_rec.ATTRIBUTE8,
              l_scc_rec.ATTRIBUTE9,
              l_scc_rec.ATTRIBUTE10,
              l_scc_rec.ATTRIBUTE11,
              l_scc_rec.ATTRIBUTE12,
              l_scc_rec.ATTRIBUTE13,
              l_scc_rec.ATTRIBUTE14,
              l_scc_rec.ATTRIBUTE15;

Line: 569


    SELECT
		ID,
		SCN_ID,
		LABEL,
		CAT_ID,
		CLE_ID,
		SAE_ID,
		CONTENT_SEQUENCE,
		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_section_contents_v
    WHERE okc_section_contents_v.id = p_id;

Line: 631


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

Line: 719


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

Line: 722


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

Line: 725


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

Line: 905


		SELECT count(*)
		FROM okc_section_contents_v
		WHERE cat_id = p_sccv_rec.CAT_ID
		AND scn_id IN (SELECT id
				     FROM okc_sections_b
					WHERE chr_id = (SELECT chr_id
								 FROM okc_sections_b
								 WHERE id = p_sccv_rec.SCN_ID))
          AND id <> p_sccv_rec.id;

Line: 957


    p_to.last_updated_by := p_from.last_updated_by;

Line: 958


    p_to.last_update_date := p_from.last_update_date;

Line: 959


    p_to.last_update_login := p_from.last_update_login;

Line: 996


    p_to.last_updated_by := p_from.last_updated_by;

Line: 997


    p_to.last_update_date := p_from.last_update_date;

Line: 998


    p_to.last_update_login := p_from.last_update_login;

Line: 1234


  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_scc_rec                      IN scc_rec_type,
    x_scc_rec                      OUT NOCOPY scc_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1243


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

Line: 1265


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

Line: 1287


    INSERT INTO OKC_SECTION_CONTENTS(
        id,
        scn_id,
        content_sequence,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        label,
        cat_id,
        cle_id,
        sae_id,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15)
      VALUES (
        l_scc_rec.id,
        l_scc_rec.scn_id,
        l_scc_rec.content_sequence,
        l_scc_rec.object_version_number,
        l_scc_rec.created_by,
        l_scc_rec.creation_date,
        l_scc_rec.last_updated_by,
        l_scc_rec.last_update_date,
        l_scc_rec.last_update_login,
        l_scc_rec.label,
        l_scc_rec.cat_id,
        l_scc_rec.cle_id,
        l_scc_rec.sae_id,
        l_scc_rec.attribute_category,
        l_scc_rec.attribute1,
        l_scc_rec.attribute2,
        l_scc_rec.attribute3,
        l_scc_rec.attribute4,
        l_scc_rec.attribute5,
        l_scc_rec.attribute6,
        l_scc_rec.attribute7,
        l_scc_rec.attribute8,
        l_scc_rec.attribute9,
        l_scc_rec.attribute10,
        l_scc_rec.attribute11,
        l_scc_rec.attribute12,
        l_scc_rec.attribute13,
        l_scc_rec.attribute14,
        l_scc_rec.attribute15);

Line: 1352


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

Line: 1360


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

Line: 1376


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

Line: 1392


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

Line: 1406


  END insert_row;

Line: 1410


  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_sccv_rec                     IN sccv_rec_type,
    x_sccv_rec                     OUT NOCOPY sccv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1420


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

Line: 1437


      l_sccv_rec.LAST_UPDATE_DATE := l_sccv_rec.CREATION_DATE;

Line: 1438


      l_sccv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1439


      l_sccv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1462


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

Line: 1512


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_scc_rec,
      lx_scc_rec
    );

Line: 1531


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

Line: 1539


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

Line: 1555


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

Line: 1571


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

Line: 1585


  END insert_row;

Line: 1589


  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_sccv_tbl                     IN sccv_tbl_type,
    x_sccv_tbl                     OUT NOCOPY sccv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1599


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

Line: 1606


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

Line: 1614


        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_sccv_rec                     => p_sccv_tbl(i),
          x_sccv_rec                     => x_sccv_tbl(i));

Line: 1628


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

Line: 1636


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

Line: 1652


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

Line: 1668


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

Line: 1682


  END insert_row;

Line: 1700


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_SECTION_CONTENTS
     WHERE ID = p_scc_rec.id
       AND OBJECT_VERSION_NUMBER = p_scc_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1707


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_SECTION_CONTENTS
    WHERE ID = p_scc_rec.id;

Line: 1776


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1785


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2059


  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_scc_rec                      IN scc_rec_type,
    x_scc_rec                      OUT NOCOPY scc_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2068


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

Line: 2120


      IF (x_scc_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_scc_rec.last_updated_by := l_scc_rec.last_updated_by;

Line: 2124


      IF (x_scc_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_scc_rec.last_update_date := l_scc_rec.last_update_date;

Line: 2128


      IF (x_scc_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_scc_rec.last_update_login := l_scc_rec.last_update_login;

Line: 2239


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

Line: 2267


    UPDATE  OKC_SECTION_CONTENTS
    SET SCN_ID = l_def_scc_rec.scn_id,
        CONTENT_SEQUENCE = l_def_scc_rec.content_sequence,
        OBJECT_VERSION_NUMBER = l_def_scc_rec.object_version_number,
        CREATED_BY = l_def_scc_rec.created_by,
        CREATION_DATE = l_def_scc_rec.creation_date,
        LAST_UPDATED_BY = l_def_scc_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_scc_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_scc_rec.last_update_login,
        LABEL = l_def_scc_rec.label,
        CAT_ID = l_def_scc_rec.cat_id,
        CLE_ID = l_def_scc_rec.cle_id,
        SAE_ID = l_def_scc_rec.sae_id,
        ATTRIBUTE_CATEGORY = l_def_scc_rec.attribute_category,
        ATTRIBUTE1 = l_def_scc_rec.attribute1,
        ATTRIBUTE2 = l_def_scc_rec.attribute2,
        ATTRIBUTE3 = l_def_scc_rec.attribute3,
        ATTRIBUTE4 = l_def_scc_rec.attribute4,
        ATTRIBUTE5 = l_def_scc_rec.attribute5,
        ATTRIBUTE6 = l_def_scc_rec.attribute6,
        ATTRIBUTE7 = l_def_scc_rec.attribute7,
        ATTRIBUTE8 = l_def_scc_rec.attribute8,
        ATTRIBUTE9 = l_def_scc_rec.attribute9,
        ATTRIBUTE10 = l_def_scc_rec.attribute10,
        ATTRIBUTE11 = l_def_scc_rec.attribute11,
        ATTRIBUTE12 = l_def_scc_rec.attribute12,
        ATTRIBUTE13 = l_def_scc_rec.attribute13,
        ATTRIBUTE14 = l_def_scc_rec.attribute14,
        ATTRIBUTE15 = l_def_scc_rec.attribute15
    WHERE ID = l_def_scc_rec.id;

Line: 2302


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

Line: 2310


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

Line: 2326


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

Line: 2342


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

Line: 2356


  END update_row;

Line: 2360


  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_sccv_rec                     IN sccv_rec_type,
    x_sccv_rec                     OUT NOCOPY sccv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2370


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

Line: 2385


      l_sccv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2386


      l_sccv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2387


      l_sccv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2454


      IF (x_sccv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sccv_rec.last_updated_by := l_sccv_rec.last_updated_by;

Line: 2458


      IF (x_sccv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sccv_rec.last_update_date := l_sccv_rec.last_update_date;

Line: 2462


      IF (x_sccv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sccv_rec.last_update_login := l_sccv_rec.last_update_login;

Line: 2558


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

Line: 2612


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_scc_rec,
      lx_scc_rec
    );

Line: 2630


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

Line: 2638


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

Line: 2654


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

Line: 2670


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

Line: 2685


  END update_row;

Line: 2689


  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_sccv_tbl                     IN sccv_tbl_type,
    x_sccv_tbl                     OUT NOCOPY sccv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2699


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

Line: 2706


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

Line: 2714


        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_sccv_rec                     => p_sccv_tbl(i),
          x_sccv_rec                     => x_sccv_tbl(i));

Line: 2728


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

Line: 2736


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

Line: 2752


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

Line: 2768


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

Line: 2782


  END update_row;

Line: 2790


  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_scc_rec                      IN scc_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2798


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

Line: 2806


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

Line: 2818


    DELETE FROM OKC_SECTION_CONTENTS
     WHERE ID = l_scc_rec.id;

Line: 2824


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

Line: 2832


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

Line: 2848


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

Line: 2864


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

Line: 2878


  END delete_row;

Line: 2882


  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_sccv_rec                     IN sccv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2891


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

Line: 2899


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

Line: 2921


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

Line: 2936


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

Line: 2944


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

Line: 2960


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

Line: 2976


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

Line: 2990


  END delete_row;

Line: 2994


  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_sccv_tbl                     IN sccv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3003


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

Line: 3010


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

Line: 3018


        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_sccv_rec                     => p_sccv_tbl(i));

Line: 3031


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

Line: 3039


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

Line: 3055


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

Line: 3071


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

Line: 3085


  END delete_row;

Line: 3105


INSERT INTO okc_section_contents_h
  (
      major_version,
      id,
      scn_id,
      content_sequence,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      label,
      cat_id,
      cle_id,
      sae_id,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
)
  SELECT
      p_major_version,
      id,
      scn_id,
      content_sequence,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      label,
      cat_id,
      cle_id,
      sae_id,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
  FROM okc_section_contents
WHERE scn_id in (SELECT id
			    FROM okc_sections_b
			   WHERE CHR_ID=p_chr_id);

Line: 3231


INSERT INTO okc_section_contents
  (
      id,
      scn_id,
      content_sequence,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      label,
      cat_id,
      cle_id,
      sae_id,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
)
  SELECT
      id,
      scn_id,
      content_sequence,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      label,
      cat_id,
      cle_id,
      sae_id,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15
  FROM okc_section_contents_h
WHERE scn_id in (SELECT id
			    FROM okc_sections_bh
			   WHERE chr_id = p_chr_id)
  AND major_version = p_major_version;