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

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

Line: 27


      SELECT 'x'
        FROM okc_class_operations
       WHERE id = p_cop_id;

Line: 123


  	  select 'x'
	  from OKC_K_HEADERS_B
  	  where id = p_oiev_rec.target_chr_id;

Line: 279


   SELECT '!'
   FROM JTF_OBJECTS_B
   WHERE object_code = p_oiev_rec.jtot_object1_code
   AND sysdate between nvl(start_date_active,sysdate) and nvl(end_date_active,sysdate);

Line: 345


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

Line: 381


  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_oiev_rec.object1_id1, p_oiev_rec.object1_id2;

Line: 455


    SELECT OKC_OPERATION_INSTANCES_S1.nextval
    FROM dual;

Line: 508


    SELECT
            ID,
            COP_ID,
            STATUS_CODE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            NAME,
            TARGET_CHR_ID,
		  REQUEST_ID,
		  PROGRAM_APPLICATION_ID,
		  PROGRAM_ID,
		  PROGRAM_UPDATE_DATE,
		  JTOT_OBJECT1_CODE,
                  OBJECT1_ID1,
                  OBJECT1_ID2,
-- R12 Data Model Changes 4485150 Start
            BATCH_ID
-- R12 Data Model Changes 4485150 End
      FROM Okc_Operation_Instances
     WHERE okc_operation_instances.id = p_id;

Line: 551


              l_oie_rec.LAST_UPDATED_BY,
              l_oie_rec.LAST_UPDATE_DATE,
              l_oie_rec.LAST_UPDATE_LOGIN,
              l_oie_rec.NAME,
              l_oie_rec.TARGET_CHR_ID,
		    l_oie_rec.REQUEST_ID,
		    l_oie_rec.PROGRAM_APPLICATION_ID,
		    l_oie_rec.PROGRAM_ID,
		    l_oie_rec.PROGRAM_UPDATE_DATE,
		    l_oie_rec.JTOT_OBJECT1_CODE,
		    l_oie_rec.OBJECT1_ID1,
		    l_oie_rec.OBJECT1_ID2,
-- R12 Data Model Changes 4485150 Start
            l_oie_rec.batch_id;

Line: 597


    SELECT
            ID,
            NAME,
            COP_ID,
            STATUS_CODE,
            TARGET_CHR_ID,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            JTOT_OBJECT1_CODE,
            OBJECT1_ID1,
            OBJECT1_ID2
      FROM Okc_Operation_Instances_V
     WHERE okc_operation_instances_v.id = p_id;

Line: 635


              l_oiev_rec.LAST_UPDATED_BY,
              l_oiev_rec.LAST_UPDATE_DATE,
              l_oiev_rec.LAST_UPDATE_LOGIN,
              l_oiev_rec.JTOT_OBJECT1_CODE,
              l_oiev_rec.OBJECT1_ID1,
              l_oiev_rec.OBJECT1_ID2;

Line: 698


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

Line: 701


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

Line: 704


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

Line: 857


    p_to.last_updated_by := p_from.last_updated_by;

Line: 858


    p_to.last_update_date := p_from.last_update_date;

Line: 859


    p_to.last_update_login := p_from.last_update_login;

Line: 880


    p_to.last_updated_by := p_from.last_updated_by;

Line: 881


    p_to.last_update_date := p_from.last_update_date;

Line: 882


    p_to.last_update_login := p_from.last_update_login;

Line: 1114


  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_oie_rec                      IN oie_rec_type,
    x_oie_rec                      OUT NOCOPY oie_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1123


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

Line: 1145


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

Line: 1167


    INSERT INTO OKC_OPERATION_INSTANCES(
        id,
        cop_id,
        status_code,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        name,
        target_chr_id,
	   request_id,
	   program_application_id,
	   program_id,
	   program_update_date,
           jtot_object1_code,
           object1_id1,
           object1_id2,
-- R12 Data Model Changes 4485150 Start
           batch_id
-- R12 Data Model Changes 4485150 End
)
      VALUES (
        l_oie_rec.id,
        l_oie_rec.cop_id,
        l_oie_rec.status_code,
        l_oie_rec.object_version_number,
        l_oie_rec.created_by,
        l_oie_rec.creation_date,
        l_oie_rec.last_updated_by,
        l_oie_rec.last_update_date,
        l_oie_rec.last_update_login,
        l_oie_rec.name,
        l_oie_rec.target_chr_id,
        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),
        l_oie_rec.jtot_object1_code,
        l_oie_rec.object1_id1,
        l_oie_rec.object1_id2,
-- R12 Data Model Changes 4485150 Start
        l_oie_rec.batch_id
-- R12 Data Model Changes 4485150 End
);

Line: 1219


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

Line: 1227


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

Line: 1243


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

Line: 1259


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

Line: 1273


  END insert_row;

Line: 1277


  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_oiev_rec                      IN oiev_rec_type,
    x_oiev_rec                      OUT NOCOPY oiev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1287


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

Line: 1304


      l_oiev_rec.LAST_UPDATE_DATE := l_oiev_rec.CREATION_DATE;

Line: 1305


      l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1306


      l_oiev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1330


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

Line: 1380


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_oie_rec,
      lx_oie_rec
    );

Line: 1399


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

Line: 1407


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

Line: 1423


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

Line: 1439


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

Line: 1453


  END insert_row;

Line: 1457


  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_oiev_tbl                      IN oiev_tbl_type,
    x_oiev_tbl                      OUT NOCOPY oiev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1467


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

Line: 1475


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

Line: 1483


        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_oiev_rec                      => p_oiev_tbl(i),
          x_oiev_rec                      => x_oiev_tbl(i));

Line: 1507


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

Line: 1515


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

Line: 1531


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

Line: 1547


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

Line: 1561


  END insert_row;

Line: 1579


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_OPERATION_INSTANCES
     WHERE ID = p_oie_rec.id
       AND OBJECT_VERSION_NUMBER = p_oie_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1586


    SELECT OBJECT_VERSION_NUMBER
      FROM OKC_OPERATION_INSTANCES
    WHERE ID = p_oie_rec.id;

Line: 1641


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1650


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1935


  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_oie_rec                      IN oie_rec_type,
    x_oie_rec                      OUT NOCOPY oie_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 1944


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

Line: 1996


      IF (x_oie_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_oie_rec.last_updated_by := l_oie_rec.last_updated_by;

Line: 2000


      IF (x_oie_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_oie_rec.last_update_date := l_oie_rec.last_update_date;

Line: 2004


      IF (x_oie_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_oie_rec.last_update_login := l_oie_rec.last_update_login;

Line: 2028


      IF (x_oie_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_oie_rec.program_update_date := l_oie_rec.program_update_date;

Line: 2077


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

Line: 2105


    UPDATE  OKC_OPERATION_INSTANCES
    SET COP_ID = l_def_oie_rec.cop_id,
        STATUS_CODE = l_def_oie_rec.status_code,
        OBJECT_VERSION_NUMBER = l_def_oie_rec.object_version_number,
        CREATED_BY = l_def_oie_rec.created_by,
        CREATION_DATE = l_def_oie_rec.creation_date,
        LAST_UPDATED_BY = l_def_oie_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_oie_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_oie_rec.last_update_login,
        NAME = l_def_oie_rec.name,
        TARGET_CHR_ID = l_def_oie_rec.target_chr_id,

        REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),l_def_oie_rec.request_id),
	   PROGRAM_APPLICATION_ID = NVL(decode(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),l_def_oie_rec.program_application_id),
        PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),l_def_oie_rec.program_id),
        PROGRAM_UPDATE_DATE = decode(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),NULL,l_def_oie_rec.program_update_date,SYSDATE),
        JTOT_OBJECT1_CODE = l_def_oie_rec.jtot_object1_code,
        OBJECT1_ID1 = l_def_oie_rec.object1_id1,
        OBJECT1_ID2 = l_def_oie_rec.object1_id2,
-- R12 Data Model Changes 4485150 Start
        BATCH_ID = l_def_oie_rec.batch_id
-- R12 Data Model Changes 4485150 End
    WHERE ID = l_def_oie_rec.id;

Line: 2133


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

Line: 2141


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

Line: 2157


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

Line: 2173


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

Line: 2187


  END update_row;

Line: 2191


  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_oiev_rec                      IN oiev_rec_type,
    x_oiev_rec                      OUT NOCOPY oiev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2201


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

Line: 2221


      l_oiev_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2222


      l_oiev_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2223


      l_oiev_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2282


      IF (x_oiev_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_oiev_rec.last_updated_by := l_oiev_rec.last_updated_by;

Line: 2286


      IF (x_oiev_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_oiev_rec.last_update_date := l_oiev_rec.last_update_date;

Line: 2290


      IF (x_oiev_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_oiev_rec.last_update_login := l_oiev_rec.last_update_login;

Line: 2334


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

Line: 2388


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_oie_rec,
      lx_oie_rec
    );

Line: 2406


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

Line: 2414


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

Line: 2430


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

Line: 2446


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

Line: 2460


  END update_row;

Line: 2464


  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_oiev_tbl                      IN oiev_tbl_type,
    x_oiev_tbl                      OUT NOCOPY oiev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2474


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

Line: 2482


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

Line: 2490


        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_oiev_rec                      => p_oiev_tbl(i),
          x_oiev_rec                      => x_oiev_tbl(i));

Line: 2514


    okc_debug.log('9800: Exiting update_row', 2);

Line: 2522


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

Line: 2538


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

Line: 2554


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

Line: 2568


  END update_row;

Line: 2576


  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_oie_rec                      IN oie_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2584


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

Line: 2592


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

Line: 2604


    DELETE FROM OKC_OPERATION_INSTANCES
     WHERE ID = l_oie_rec.id;

Line: 2610


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

Line: 2618


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

Line: 2634


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

Line: 2650


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

Line: 2664


  END delete_row;

Line: 2668


  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_oiev_rec                      IN oiev_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2677


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

Line: 2685


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

Line: 2707


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

Line: 2722


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

Line: 2730


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

Line: 2746


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

Line: 2762


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

Line: 2776


  END delete_row;

Line: 2780


  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_oiev_tbl                      IN oiev_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2789


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

Line: 2797


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

Line: 2805


        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_oiev_rec                      => p_oiev_tbl(i));

Line: 2828


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

Line: 2836


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

Line: 2852


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

Line: 2868


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

Line: 2882


  END delete_row;