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

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

Line: 60


    SELECT
            ID,
            CLE_ID,
            CHR_ID,
            CLE_ID_FOR,
            DNZ_CHR_ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            UOM_CODE,
            EXCEPTION_YN,
            NUMBER_OF_ITEMS,
            UPG_ORIG_SYSTEM_REF,
            UPG_ORIG_SYSTEM_REF_ID,
            PRICED_ITEM_YN,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE
      FROM Okc_K_Items
     WHERE okc_k_items.id       = p_id;

Line: 117


              l_cim_rec.LAST_UPDATED_BY,
              l_cim_rec.LAST_UPDATE_DATE,
              l_cim_rec.LAST_UPDATE_LOGIN,
              l_cim_rec.REQUEST_ID,
              l_cim_rec.PROGRAM_APPLICATION_ID,
              l_cim_rec.PROGRAM_ID,
              l_cim_rec.PROGRAM_UPDATE_DATE;

Line: 153


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CLE_ID,
            CHR_ID,
            CLE_ID_FOR,
            DNZ_CHR_ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            UOM_CODE,
            EXCEPTION_YN,
            NUMBER_OF_ITEMS,
            UPG_ORIG_SYSTEM_REF,
            UPG_ORIG_SYSTEM_REF_ID,
            PRICED_ITEM_YN,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE
      FROM Okc_K_Items_V
     WHERE okc_k_items_v.id     = p_id;

Line: 210


              l_cimv_rec.LAST_UPDATED_BY,
              l_cimv_rec.LAST_UPDATE_DATE,
              l_cimv_rec.LAST_UPDATE_LOGIN,
              l_cimv_rec.REQUEST_ID,
              l_cimv_rec.PROGRAM_APPLICATION_ID,
              l_cimv_rec.PROGRAM_ID,
              l_cimv_rec.PROGRAM_UPDATE_DATE;

Line: 302


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

Line: 305


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

Line: 308


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

Line: 320


    IF (l_cimv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
        l_cimv_rec.program_update_date := NULL;

Line: 349


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

Line: 425


  select 'x'
  from OKC_K_LINES_B
  where id = p_cimv_rec.cle_id_for;

Line: 486


  select 'x'
  from  OKC_K_HEADERS_ALL_B   -- Modiifed by jvorugan for Bug: 4645341 OKC_K_HEADERS_B
  where id = p_cimv_rec.chr_id;

Line: 610


  select 'x'
  from OKX_UNITS_OF_MEASURE_V
  where UOM_CODE = p_cimv_rec.UOM_CODE;

Line: 673


select '!'
from
	okc_k_lines_b LN
	,okc_line_styles_b SL
	,okc_line_style_sources SS
where
	LN.ID = p_cimv_rec.cle_id
	and SL.id = LN.LSE_ID
	and SS.LSE_ID = SL.id
	and SS.jtot_object_code = p_cimv_rec.JTOT_OBJECT1_CODE
	and sysdate>=SS.start_date
	and (SS.end_date is NULL or SS.end_date>=sysdate)
;

Line: 749


select
	from_table
	,trim(where_clause) where_clause
from
	jtf_objects_vl OB
where
	OB.OBJECT_CODE = p_cimv_rec.jtot_object1_code
;

Line: 787


  EXECUTE IMMEDIATE 'select ''x'' from '||l_from_table||
	' where id1=:object1_id1 and id2=:object1_id2'||l_where_clause
	into l_dummy_var
	USING p_cimv_rec.object1_id1, p_cimv_rec.object1_id2;

Line: 867


    select '!'
    from okc_k_headers_all_b -- Modified by Jvorugan for Bug:4645341 okc_k_headers_b
    where id = p_cimv_rec.dnz_chr_id;

Line: 1086


   select lse_id
   from   okc_k_lines_b
   where  id = p_cimv_rec.cle_id;

Line: 1091


    select access_level
    from okc_line_styles_b
    where id = p_id;

Line: 1205


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1206


    p_to.last_update_date := p_from.last_update_date;

Line: 1207


    p_to.last_update_login := p_from.last_update_login;

Line: 1211


    p_to.program_update_date := p_from.program_update_date;

Line: 1239


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1240


    p_to.last_update_date := p_from.last_update_date;

Line: 1241


    p_to.last_update_login := p_from.last_update_login;

Line: 1245


    p_to.program_update_date := p_from.program_update_date;

Line: 1460


  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_cim_rec                      IN cim_rec_type,
    x_cim_rec                      OUT NOCOPY cim_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1469


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

Line: 1492


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

Line: 1514


    INSERT INTO OKC_K_ITEMS(
        id,
        cle_id,
        chr_id,
        cle_id_for,
        dnz_chr_id,
        object1_id1,
        object1_id2,
        jtot_object1_code,
        uom_code,
        exception_yn,
        number_of_items,
        upg_orig_system_ref,
        upg_orig_system_ref_id,
        priced_item_yn,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        request_id,
        program_application_id,
        program_id,
        program_update_date
	   )
      VALUES (
        l_cim_rec.id,
        l_cim_rec.cle_id,
        l_cim_rec.chr_id,
        l_cim_rec.cle_id_for,
        l_cim_rec.dnz_chr_id,
        l_cim_rec.object1_id1,
        l_cim_rec.object1_id2,
        l_cim_rec.jtot_object1_code,
        l_cim_rec.uom_code,
        l_cim_rec.exception_yn,
        l_cim_rec.number_of_items,
        l_cim_rec.upg_orig_system_ref,
        l_cim_rec.upg_orig_system_ref_id,
        l_cim_rec.priced_item_yn,
        l_cim_rec.object_version_number,
        l_cim_rec.created_by,
        l_cim_rec.creation_date,
        l_cim_rec.last_updated_by,
        l_cim_rec.last_update_date,
        l_cim_rec.last_update_login,
decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE) );

Line: 1570


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

Line: 1578


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

Line: 1594


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

Line: 1610


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

Line: 1624


  END insert_row;

Line: 1628


  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_cimv_rec                     IN cimv_rec_type,
    x_cimv_rec                     OUT NOCOPY cimv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1638


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

Line: 1655


      l_cimv_rec.LAST_UPDATE_DATE := l_cimv_rec.CREATION_DATE;

Line: 1656


      l_cimv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1657


      l_cimv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1681


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

Line: 1731


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cim_rec,
      lx_cim_rec
    );

Line: 1750


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

Line: 1758


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

Line: 1774


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

Line: 1790


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

Line: 1804


  END insert_row;

Line: 1808


  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_cimv_tbl                     IN cimv_tbl_type,
    x_cimv_tbl                     OUT NOCOPY cimv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1818


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

Line: 1825


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

Line: 1833


        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_cimv_rec                     => p_cimv_tbl(i),
          x_cimv_rec                     => x_cimv_tbl(i));

Line: 1847


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

Line: 1855


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

Line: 1871


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

Line: 1887


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

Line: 1901


  END insert_row;

Line: 1919


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_ITEMS
     WHERE ID = p_cim_rec.id
       AND OBJECT_VERSION_NUMBER = p_cim_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1926


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_K_ITEMS
    WHERE ID = p_cim_rec.id;

Line: 1991


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2000


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2274


  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_cim_rec                      IN cim_rec_type,
    x_cim_rec                      OUT NOCOPY cim_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2283


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

Line: 2379


      IF (x_cim_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cim_rec.last_updated_by := l_cim_rec.last_updated_by;

Line: 2383


      IF (x_cim_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cim_rec.last_update_date := l_cim_rec.last_update_date;

Line: 2387


      IF (x_cim_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cim_rec.last_update_login := l_cim_rec.last_update_login;

Line: 2403


      IF (x_cim_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cim_rec.program_update_date := l_cim_rec.program_update_date ;

Line: 2434


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

Line: 2462


    UPDATE  OKC_K_ITEMS
    SET CLE_ID = l_def_cim_rec.cle_id,
        CHR_ID = l_def_cim_rec.chr_id,
        CLE_ID_FOR = l_def_cim_rec.cle_id_for,
        DNZ_CHR_ID = l_def_cim_rec.dnz_chr_id,
        OBJECT1_ID1 = l_def_cim_rec.object1_id1,
        OBJECT1_ID2 = l_def_cim_rec.object1_id2,
        JTOT_OBJECT1_CODE = l_def_cim_rec.jtot_object1_code,
        UOM_CODE = l_def_cim_rec.uom_code,
        EXCEPTION_YN = l_def_cim_rec.exception_yn,
        NUMBER_OF_ITEMS = l_def_cim_rec.number_of_items,
        UPG_ORIG_SYSTEM_REF = l_def_cim_rec.upg_orig_system_ref,
        UPG_ORIG_SYSTEM_REF_ID = l_def_cim_rec.upg_orig_system_ref_id,
        PRICED_ITEM_YN = l_def_cim_rec.priced_item_yn,
        OBJECT_VERSION_NUMBER = l_def_cim_rec.object_version_number,
        CREATED_BY = l_def_cim_rec.created_by,
        CREATION_DATE = l_def_cim_rec.creation_date,
        LAST_UPDATED_BY = l_def_cim_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cim_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cim_rec.last_update_login,
        PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_cim_rec.program_id ),
REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_cim_rec.request_id),
PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_cim_rec.program_update_date,SYSDATE),
PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_cim_rec.program_application_id)
    WHERE ID = l_def_cim_rec.id;

Line: 2492


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

Line: 2500


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

Line: 2516


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

Line: 2532


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

Line: 2546


  END update_row;

Line: 2550


  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_cimv_rec                     IN cimv_rec_type,
    x_cimv_rec                     OUT NOCOPY cimv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2560


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

Line: 2575


      l_cimv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2576


      l_cimv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2577


      l_cimv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2673


      IF (x_cimv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_cimv_rec.last_updated_by := l_cimv_rec.last_updated_by;

Line: 2677


      IF (x_cimv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cimv_rec.last_update_date := l_cimv_rec.last_update_date;

Line: 2681


      IF (x_cimv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_cimv_rec.last_update_login := l_cimv_rec.last_update_login;

Line: 2699


      IF (x_cimv_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_cimv_rec.program_update_date := l_cimv_rec.program_update_date;

Line: 2732


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

Line: 2786


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_cim_rec,
      lx_cim_rec
    );

Line: 2804


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

Line: 2812


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

Line: 2828


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

Line: 2844


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

Line: 2858


  END update_row;

Line: 2862


  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_cimv_tbl                     IN cimv_tbl_type,
    x_cimv_tbl                     OUT NOCOPY cimv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2872


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

Line: 2879


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

Line: 2887


        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_cimv_rec                     => p_cimv_tbl(i),
          x_cimv_rec                     => x_cimv_tbl(i));

Line: 2901


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

Line: 2909


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

Line: 2925


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

Line: 2941


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

Line: 2955


  END update_row;

Line: 2963


  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_cim_rec                      IN cim_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2971


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

Line: 2979


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

Line: 2991


    DELETE FROM OKC_K_ITEMS
     WHERE ID = l_cim_rec.id;

Line: 2997


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

Line: 3005


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

Line: 3021


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

Line: 3037


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

Line: 3051


  END delete_row;

Line: 3055


  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_cimv_rec                     IN cimv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3064


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

Line: 3072


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

Line: 3094


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

Line: 3109


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

Line: 3117


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

Line: 3133


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

Line: 3149


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

Line: 3163


  END delete_row;

Line: 3167


  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_cimv_tbl                     IN cimv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3176


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

Line: 3183


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

Line: 3191


        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_cimv_rec                     => p_cimv_tbl(i));

Line: 3204


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

Line: 3212


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

Line: 3228


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

Line: 3244


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

Line: 3258


  END delete_row;

Line: 3263


PROCEDURE INSERT_ROW_UPG(x_return_status OUT NOCOPY VARCHAR2, p_cimv_tbl cimv_tbl_type) IS
  l_tabsize NUMBER := p_cimv_tbl.COUNT;

Line: 3284


  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 3285


  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 3286


  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 3290


  in_program_update_date           OKC_DATATYPES.DateTabTyp;

Line: 3300


       okc_debug.log('12500: Entered INSERT_ROW_UPG', 2);

Line: 3340


    in_last_updated_by          (j) := p_cimv_tbl(i).last_updated_by;

Line: 3341


    in_last_update_date         (j) := p_cimv_tbl(i).last_update_date;

Line: 3342


    in_last_update_login        (j) := p_cimv_tbl(i).last_update_login;

Line: 3346


    in_program_update_date      (j) := p_cimv_tbl(i).program_update_date;

Line: 3353


    INSERT
      INTO OKC_K_ITEMS
      (
        id,
        cle_id,
        chr_id,
        cle_id_for,
        dnz_chr_id,
        object1_id1,
        object1_id2,
        jtot_object1_code,
        uom_code,
        exception_yn,
        number_of_items,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        upg_orig_system_ref,
        upg_orig_system_ref_id,
        priced_item_yn,
        request_id,
        program_application_id,
        program_id,
        program_update_date
     )
     VALUES (
        in_id(i),
        in_cle_id(i),
        in_chr_id(i),
        in_cle_id_for(i),
        in_dnz_chr_id(i),
        in_object1_id1(i),
        in_object1_id2(i),
        in_jtot_object1_code(i),
        in_uom_code(i),
        in_exception_yn(i),
        in_number_of_items(i),
        in_object_version_number(i),
        in_created_by(i),
        in_creation_date(i),
        in_last_updated_by(i),
        in_last_update_date(i),
        in_last_update_login(i),
        in_upg_orig_system_ref(i),
        in_upg_orig_system_ref_id(i),
        in_priced_item_yn(i),
        in_request_id(i),
        in_program_application_id(i),
        in_program_id(i),
        in_program_update_date(i)
     );

Line: 3409


       okc_debug.log('12600: Leaving INSERT_ROW_UPG', 2);

Line: 3427


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

Line: 3433


END INSERT_ROW_UPG;

Line: 3453


INSERT INTO okc_k_items_h
  (
      major_version,
      id,
      cle_id,
      chr_id,
      cle_id_for,
      dnz_chr_id,
      object1_id1,
      object1_id2,
      jtot_object1_code,
      uom_code,
      exception_yn,
      number_of_items,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      priced_item_yn,
      request_id,
      program_id,
      Program_application_id,
      program_update_date
)
  SELECT
      p_major_version,
      id,
      cle_id,
      chr_id,
      cle_id_for,
      dnz_chr_id,
      object1_id1,
      object1_id2,
      jtot_object1_code,
      uom_code,
      exception_yn,
      number_of_items,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      priced_item_yn,
      request_id,
      program_id,
      Program_application_id,
      program_update_date
  FROM okc_k_items
WHERE dnz_chr_id = p_chr_id;

Line: 3555


INSERT INTO okc_k_items
  (
      id,
      cle_id,
      chr_id,
      cle_id_for,
      dnz_chr_id,
      object1_id1,
      object1_id2,
      jtot_object1_code,
      uom_code,
      exception_yn,
      number_of_items,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      priced_item_yn,
      request_id,
      program_id,
      Program_application_id,
      program_update_date
)
  SELECT
      id,
      cle_id,
      chr_id,
      cle_id_for,
      dnz_chr_id,
      object1_id1,
      object1_id2,
      jtot_object1_code,
      uom_code,
      exception_yn,
      number_of_items,
      object_version_number,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      priced_item_yn,
      request_id,
      program_id,
      Program_application_id,
      program_update_date
  FROM okc_k_items_h
WHERE dnz_chr_id = p_chr_id
  AND major_version = p_major_version;