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.IEX_IOH_PVT SQL Statements

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

Line: 103


    SELECT
            ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            ACTION,
            STATUS,
            COMMENTS,
            REQUEST_DATE,
            PROCESS_DATE,
            EXT_AGNCY_ID,
            REVIEW_DATE,
            RECALL_DATE,
            AUTOMATIC_RECALL_FLAG,
            REVIEW_BEFORE_RECALL_FLAG,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Iex_Open_Int_Hst_V
     WHERE iex_open_int_hst_v.id = p_id;

Line: 173


              l_iohv_rec.program_update_date,
              l_iohv_rec.attribute_category,
              l_iohv_rec.attribute1,
              l_iohv_rec.attribute2,
              l_iohv_rec.attribute3,
              l_iohv_rec.attribute4,
              l_iohv_rec.attribute5,
              l_iohv_rec.attribute6,
              l_iohv_rec.attribute7,
              l_iohv_rec.attribute8,
              l_iohv_rec.attribute9,
              l_iohv_rec.attribute10,
              l_iohv_rec.attribute11,
              l_iohv_rec.attribute12,
              l_iohv_rec.attribute13,
              l_iohv_rec.attribute14,
              l_iohv_rec.attribute15,
              l_iohv_rec.created_by,
              l_iohv_rec.creation_date,
              l_iohv_rec.last_updated_by,
              l_iohv_rec.last_update_date,
              l_iohv_rec.last_update_login;

Line: 236


    SELECT
            ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            ACTION,
            STATUS,
            COMMENTS,
            REQUEST_DATE,
            PROCESS_DATE,
            EXT_AGNCY_ID,
            REVIEW_DATE,
            RECALL_DATE,
            AUTOMATIC_RECALL_FLAG,
            REVIEW_BEFORE_RECALL_FLAG,
            OBJECT_VERSION_NUMBER,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Iex_Open_Int_Hst
     WHERE iex_open_int_hst.id  = p_id;

Line: 306


              l_ioh_rec.program_update_date,
              l_ioh_rec.attribute_category,
              l_ioh_rec.attribute1,
              l_ioh_rec.attribute2,
              l_ioh_rec.attribute3,
              l_ioh_rec.attribute4,
              l_ioh_rec.attribute5,
              l_ioh_rec.attribute6,
              l_ioh_rec.attribute7,
              l_ioh_rec.attribute8,
              l_ioh_rec.attribute9,
              l_ioh_rec.attribute10,
              l_ioh_rec.attribute11,
              l_ioh_rec.attribute12,
              l_ioh_rec.attribute13,
              l_ioh_rec.attribute14,
              l_ioh_rec.attribute15,
              l_ioh_rec.created_by,
              l_ioh_rec.creation_date,
              l_ioh_rec.last_updated_by,
              l_ioh_rec.last_update_date,
              l_ioh_rec.last_update_login;

Line: 426


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

Line: 483


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

Line: 486


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

Line: 489


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

Line: 846


    p_to.program_update_date := p_from.program_update_date;

Line: 865


    p_to.last_updated_by := p_from.last_updated_by;

Line: 866


    p_to.last_update_date := p_from.last_update_date;

Line: 867


    p_to.last_update_login := p_from.last_update_login;

Line: 893


    p_to.program_update_date := p_from.program_update_date;

Line: 912


    p_to.last_updated_by := p_from.last_updated_by;

Line: 913


    p_to.last_update_date := p_from.last_update_date;

Line: 914


    p_to.last_update_login := p_from.last_update_login;

Line: 1160


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ioh_rec                      IN ioh_rec_type,
    x_ioh_rec                      OUT NOCOPY ioh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1169


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

Line: 1205


    INSERT INTO IEX_OPEN_INT_HST(
      id,
      object1_id1,
      object1_id2,
      jtot_object1_code,
      action,
      status,
      comments,
      request_date,
      process_date,
      ext_agncy_id,
      review_date,
      recall_date,
      automatic_recall_flag,
      review_before_recall_flag,
      object_version_number,
      org_id,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_ioh_rec.id,
      l_ioh_rec.object1_id1,
      l_ioh_rec.object1_id2,
      l_ioh_rec.jtot_object1_code,
      l_ioh_rec.action,
      l_ioh_rec.status,
      l_ioh_rec.comments,
      l_ioh_rec.request_date,
      l_ioh_rec.process_date,
      l_ioh_rec.ext_agncy_id,
      l_ioh_rec.review_date,
      l_ioh_rec.recall_date,
      l_ioh_rec.automatic_recall_flag,
      l_ioh_rec.review_before_recall_flag,
      l_ioh_rec.object_version_number,
      l_ioh_rec.org_id,
      l_ioh_rec.request_id,
      l_ioh_rec.program_application_id,
      l_ioh_rec.program_id,
      l_ioh_rec.program_update_date,
      l_ioh_rec.attribute_category,
      l_ioh_rec.attribute1,
      l_ioh_rec.attribute2,
      l_ioh_rec.attribute3,
      l_ioh_rec.attribute4,
      l_ioh_rec.attribute5,
      l_ioh_rec.attribute6,
      l_ioh_rec.attribute7,
      l_ioh_rec.attribute8,
      l_ioh_rec.attribute9,
      l_ioh_rec.attribute10,
      l_ioh_rec.attribute11,
      l_ioh_rec.attribute12,
      l_ioh_rec.attribute13,
      l_ioh_rec.attribute14,
      l_ioh_rec.attribute15,
      l_ioh_rec.created_by,
      l_ioh_rec.creation_date,
      l_ioh_rec.last_updated_by,
      l_ioh_rec.last_update_date,
      l_ioh_rec.last_update_login);

Line: 1324


  END insert_row;

Line: 1328


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_iohv_rec                     IN iohv_rec_type,
    x_iohv_rec                     OUT NOCOPY iohv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1338


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

Line: 1354


      l_iohv_rec.LAST_UPDATE_DATE := l_iohv_rec.CREATION_DATE;

Line: 1355


      l_iohv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1356


      l_iohv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1420


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ioh_rec,
      lx_ioh_rec
    );

Line: 1469


  END insert_row;

Line: 1473


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_iohv_tbl                     IN iohv_tbl_type,
    x_iohv_tbl                     OUT NOCOPY iohv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1484


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

Line: 1498


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_iohv_rec                     => p_iohv_tbl(i),
            x_iohv_rec                     => x_iohv_tbl(i));

Line: 1566


  END insert_row;

Line: 1571


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_iohv_tbl                     IN iohv_tbl_type,
    x_iohv_tbl                     OUT NOCOPY iohv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1581


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

Line: 1588


      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_iohv_tbl                     => p_iohv_tbl,
        x_iohv_tbl                     => x_iohv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1630


  END insert_row;

Line: 1648


    SELECT OBJECT_VERSION_NUMBER
      FROM IEX_OPEN_INT_HST
     WHERE ID = p_ioh_rec.id
       AND OBJECT_VERSION_NUMBER = p_ioh_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1655


    SELECT OBJECT_VERSION_NUMBER
      FROM IEX_OPEN_INT_HST
     WHERE ID = p_ioh_rec.id;

Line: 1696


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1705


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1985


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ioh_rec                      IN ioh_rec_type,
    x_ioh_rec                      OUT NOCOPY ioh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1994


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

Line: 2090


        IF (x_ioh_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_ioh_rec.program_update_date := l_ioh_rec.program_update_date;

Line: 2166


        IF (x_ioh_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_ioh_rec.last_updated_by := l_ioh_rec.last_updated_by;

Line: 2170


        IF (x_ioh_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_ioh_rec.last_update_date := l_ioh_rec.last_update_date;

Line: 2174


        IF (x_ioh_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_ioh_rec.last_update_login := l_ioh_rec.last_update_login;

Line: 2220


    UPDATE IEX_OPEN_INT_HST
    SET OBJECT1_ID1 = l_def_ioh_rec.object1_id1,
        OBJECT1_ID2 = l_def_ioh_rec.object1_id2,
        JTOT_OBJECT1_CODE = l_def_ioh_rec.jtot_object1_code,
        ACTION = l_def_ioh_rec.action,
        STATUS = l_def_ioh_rec.status,
        COMMENTS = l_def_ioh_rec.comments,
        REQUEST_DATE = l_def_ioh_rec.request_date,
        PROCESS_DATE = l_def_ioh_rec.process_date,
        EXT_AGNCY_ID = l_def_ioh_rec.ext_agncy_id,
        REVIEW_DATE = l_def_ioh_rec.review_date,
        RECALL_DATE = l_def_ioh_rec.recall_date,
        AUTOMATIC_RECALL_FLAG = l_def_ioh_rec.automatic_recall_flag,
        REVIEW_BEFORE_RECALL_FLAG = l_def_ioh_rec.review_before_recall_flag,
        OBJECT_VERSION_NUMBER = l_def_ioh_rec.object_version_number,
        ORG_ID = l_def_ioh_rec.org_id,
        REQUEST_ID = l_def_ioh_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_ioh_rec.program_application_id,
        PROGRAM_ID = l_def_ioh_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_ioh_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_ioh_rec.attribute_category,
        ATTRIBUTE1 = l_def_ioh_rec.attribute1,
        ATTRIBUTE2 = l_def_ioh_rec.attribute2,
        ATTRIBUTE3 = l_def_ioh_rec.attribute3,
        ATTRIBUTE4 = l_def_ioh_rec.attribute4,
        ATTRIBUTE5 = l_def_ioh_rec.attribute5,
        ATTRIBUTE6 = l_def_ioh_rec.attribute6,
        ATTRIBUTE7 = l_def_ioh_rec.attribute7,
        ATTRIBUTE8 = l_def_ioh_rec.attribute8,
        ATTRIBUTE9 = l_def_ioh_rec.attribute9,
        ATTRIBUTE10 = l_def_ioh_rec.attribute10,
        ATTRIBUTE11 = l_def_ioh_rec.attribute11,
        ATTRIBUTE12 = l_def_ioh_rec.attribute12,
        ATTRIBUTE13 = l_def_ioh_rec.attribute13,
        ATTRIBUTE14 = l_def_ioh_rec.attribute14,
        ATTRIBUTE15 = l_def_ioh_rec.attribute15,
        CREATED_BY = l_def_ioh_rec.created_by,
        CREATION_DATE = l_def_ioh_rec.creation_date,
        LAST_UPDATED_BY = l_def_ioh_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_ioh_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_ioh_rec.last_update_login
    WHERE ID = l_def_ioh_rec.id;

Line: 2297


  END update_row;

Line: 2301


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_iohv_rec                     IN iohv_rec_type,
    x_iohv_rec                     OUT NOCOPY iohv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2311


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

Line: 2326


      l_iohv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2327


      l_iohv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2328


      l_iohv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2423


        IF (x_iohv_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_iohv_rec.program_update_date := l_db_iohv_rec.program_update_date;

Line: 2499


        IF (x_iohv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_iohv_rec.last_updated_by := l_db_iohv_rec.last_updated_by;

Line: 2503


        IF (x_iohv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_iohv_rec.last_update_date := l_db_iohv_rec.last_update_date;

Line: 2507


        IF (x_iohv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_iohv_rec.last_update_login := l_db_iohv_rec.last_update_login;

Line: 2592


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ioh_rec,
      lx_ioh_rec
    );

Line: 2640


  END update_row;

Line: 2644


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_iohv_tbl                     IN iohv_tbl_type,
    x_iohv_tbl                     OUT NOCOPY iohv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2655


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

Line: 2669


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_iohv_rec                     => p_iohv_tbl(i),
            x_iohv_rec                     => x_iohv_tbl(i));

Line: 2737


  END update_row;

Line: 2742


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_iohv_tbl                     IN iohv_tbl_type,
    x_iohv_tbl                     OUT NOCOPY iohv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2752


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

Line: 2759


      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_iohv_tbl                     => p_iohv_tbl,
        x_iohv_tbl                     => x_iohv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2801


  END update_row;

Line: 2809


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_ioh_rec                      IN ioh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2817


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

Line: 2832


    DELETE FROM IEX_OPEN_INT_HST
     WHERE ID = p_ioh_rec.id;

Line: 2868


  END delete_row;

Line: 2872


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_iohv_rec                     IN iohv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2881


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

Line: 2905


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_ioh_rec
    );

Line: 2950


  END delete_row;

Line: 2954


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_iohv_tbl                     IN iohv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2964


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

Line: 2978


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_iohv_rec                     => p_iohv_tbl(i));

Line: 3045


  END delete_row;

Line: 3050


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_iohv_tbl                     IN iohv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3059


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

Line: 3066


      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_iohv_tbl                     => p_iohv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3107


  END delete_row;