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

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

Line: 106


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CHECKLIST_NUMBER,
            DESCRIPTION,
            SHORT_DESCRIPTION,
            CHECKLIST_TYPE,
            START_DATE,
            END_DATE,
            STATUS_CODE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
-- start: Apr 25, 2005 cklee: Modification for okl.h
            CHECKLIST_PURPOSE_CODE,
            DECISION_DATE,
            CHECKLIST_OBJ_ID,
            CHECKLIST_OBJ_TYPE_CODE,
            CKL_ID
-- end: Apr 25, 2005 cklee: Modification for okl.h
      FROM OKL_CHECKLISTS
     WHERE OKL_CHECKLISTS.id  = p_id;

Line: 187


              l_clhv_rec.program_update_date,
              l_clhv_rec.created_by,
              l_clhv_rec.creation_date,
              l_clhv_rec.last_updated_by,
              l_clhv_rec.last_update_date,
              l_clhv_rec.last_update_login,
-- start: Apr 25, 2005 cklee: Modification for okl.h
              l_clhv_rec.CHECKLIST_PURPOSE_CODE,
              l_clhv_rec.DECISION_DATE,
              l_clhv_rec.CHECKLIST_OBJ_ID,
              l_clhv_rec.CHECKLIST_OBJ_TYPE_CODE,
              l_clhv_rec.CKL_ID
-- end: Apr 25, 2005 cklee: Modification for okl.h
              ;

Line: 242


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CHECKLIST_NUMBER,
            DESCRIPTION,
            SHORT_DESCRIPTION,
            CHECKLIST_TYPE,
            START_DATE,
            END_DATE,
            STATUS_CODE,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
-- start: Apr 25, 2005 cklee: Modification for okl.h
            CHECKLIST_PURPOSE_CODE,
            DECISION_DATE,
            CHECKLIST_OBJ_ID,
            CHECKLIST_OBJ_TYPE_CODE,
            CKL_ID
-- end: Apr 25, 2005 cklee: Modification for okl.h
      FROM Okl_Checklists
     WHERE okl_checklists.id    = p_id;

Line: 323


              l_clh_rec.program_update_date,
              l_clh_rec.created_by,
              l_clh_rec.creation_date,
              l_clh_rec.last_updated_by,
              l_clh_rec.last_update_date,
              l_clh_rec.last_update_login,
-- start: Apr 25, 2005 cklee: Modification for okl.h
              l_clh_rec.CHECKLIST_PURPOSE_CODE,
              l_clh_rec.DECISION_DATE,
              l_clh_rec.CHECKLIST_OBJ_ID,
              l_clh_rec.CHECKLIST_OBJ_TYPE_CODE,
              l_clh_rec.CKL_ID
-- end: Apr 25, 2005 cklee: Modification for okl.h
              ;

Line: 465


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

Line: 474


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

Line: 477


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

Line: 480


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

Line: 572


    SELECT 1
      FROM fnd_lookups lok
     WHERE lok.lookup_type = G_CHECKLIST_TYPE_LOOKUP_TYPE
     AND lok.lookup_code = p_checklist_type
    ;

Line: 732


    p_to.program_update_date := p_from.program_update_date;

Line: 735


    p_to.last_updated_by := p_from.last_updated_by;

Line: 736


    p_to.last_update_date := p_from.last_update_date;

Line: 737


    p_to.last_update_login := p_from.last_update_login;

Line: 781


    p_to.program_update_date := p_from.program_update_date;

Line: 784


    p_to.last_updated_by := p_from.last_updated_by;

Line: 785


    p_to.last_update_date := p_from.last_update_date;

Line: 786


    p_to.last_update_login := p_from.last_update_login;

Line: 1039


  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_clh_rec                      IN clh_rec_type,
    x_clh_rec                      OUT NOCOPY clh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1048


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

Line: 1084


    INSERT INTO OKL_CHECKLISTS(
      id,
      object_version_number,
      checklist_number,
      description,
      short_description,
      checklist_type,
      start_date,
      end_date,
      status_code,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      org_id,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
-- start: Apr 25, 2005 cklee: Modification for okl.h
      CHECKLIST_PURPOSE_CODE,
      DECISION_DATE,
      CHECKLIST_OBJ_ID,
      CHECKLIST_OBJ_TYPE_CODE,
      CKL_ID
-- end: Apr 25, 2005 cklee: Modification for okl.h
      )

    VALUES (
      l_clh_rec.id,
      l_clh_rec.object_version_number,
      l_clh_rec.checklist_number,
      l_clh_rec.description,
      l_clh_rec.short_description,
      l_clh_rec.checklist_type,
      l_clh_rec.start_date,
      l_clh_rec.end_date,
      l_clh_rec.status_code,
      l_clh_rec.attribute_category,
      l_clh_rec.attribute1,
      l_clh_rec.attribute2,
      l_clh_rec.attribute3,
      l_clh_rec.attribute4,
      l_clh_rec.attribute5,
      l_clh_rec.attribute6,
      l_clh_rec.attribute7,
      l_clh_rec.attribute8,
      l_clh_rec.attribute9,
      l_clh_rec.attribute10,
      l_clh_rec.attribute11,
      l_clh_rec.attribute12,
      l_clh_rec.attribute13,
      l_clh_rec.attribute14,
      l_clh_rec.attribute15,
      l_clh_rec.org_id,
      l_clh_rec.request_id,
      l_clh_rec.program_application_id,
      l_clh_rec.program_id,
      l_clh_rec.program_update_date,
      l_clh_rec.created_by,
      l_clh_rec.creation_date,
      l_clh_rec.last_updated_by,
      l_clh_rec.last_update_date,
      l_clh_rec.last_update_login,
-- start: Apr 25, 2005 cklee: Modification for okl.h
      l_clh_rec.CHECKLIST_PURPOSE_CODE,
      l_clh_rec.DECISION_DATE,
      l_clh_rec.CHECKLIST_OBJ_ID,
      l_clh_rec.CHECKLIST_OBJ_TYPE_CODE,
      l_clh_rec.CKL_ID
-- end: Apr 25, 2005 cklee: Modification for okl.h
      );

Line: 1208


  END insert_row;

Line: 1212


  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_clhv_rec                     IN clhv_rec_type,
    x_clhv_rec                     OUT NOCOPY clhv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1222


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

Line: 1242


      l_clhv_rec.LAST_UPDATE_DATE := l_clhv_rec.CREATION_DATE;

Line: 1243


      l_clhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1244


      l_clhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1260


      SELECT 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)
      INTO   x_clhv_rec.REQUEST_ID
            ,x_clhv_rec.PROGRAM_APPLICATION_ID
            ,x_clhv_rec.PROGRAM_ID
            ,x_clhv_rec.PROGRAM_UPDATE_DATE
      FROM DUAL;

Line: 1324


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_clh_rec,
      lx_clh_rec
    );

Line: 1378


  END insert_row;

Line: 1382


  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_clhv_tbl                     IN clhv_tbl_type,
    x_clhv_tbl                     OUT NOCOPY clhv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1393


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

Line: 1407


          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_clhv_rec                     => p_clhv_tbl(i),
            x_clhv_rec                     => x_clhv_tbl(i));

Line: 1475


  END insert_row;

Line: 1480


  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_clhv_tbl                     IN clhv_tbl_type,
    x_clhv_tbl                     OUT NOCOPY clhv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1490


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

Line: 1497


      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_clhv_tbl                     => p_clhv_tbl,
        x_clhv_tbl                     => x_clhv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1539


  END insert_row;

Line: 1557


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CHECKLISTS
     WHERE ID = p_clh_rec.id
       AND OBJECT_VERSION_NUMBER = p_clh_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1564


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CHECKLISTS
     WHERE ID = p_clh_rec.id;

Line: 1605


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1614


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1894


  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_clh_rec                      IN clh_rec_type,
    x_clh_rec                      OUT NOCOPY clh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1903


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

Line: 2039


        IF (x_clh_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_clh_rec.program_update_date := l_clh_rec.program_update_date;

Line: 2051


        IF (x_clh_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_clh_rec.last_updated_by := l_clh_rec.last_updated_by;

Line: 2055


        IF (x_clh_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_clh_rec.last_update_date := l_clh_rec.last_update_date;

Line: 2059


        IF (x_clh_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_clh_rec.last_update_login := l_clh_rec.last_update_login;

Line: 2124


    UPDATE OKL_CHECKLISTS
    SET OBJECT_VERSION_NUMBER = l_def_clh_rec.object_version_number,
        CHECKLIST_NUMBER = l_def_clh_rec.checklist_number,
        DESCRIPTION = l_def_clh_rec.description,
        SHORT_DESCRIPTION = l_def_clh_rec.short_description,
        CHECKLIST_TYPE = l_def_clh_rec.checklist_type,
        START_DATE = l_def_clh_rec.start_date,
        END_DATE = l_def_clh_rec.end_date,
        STATUS_CODE = l_def_clh_rec.status_code,
        ATTRIBUTE_CATEGORY = l_def_clh_rec.attribute_category,
        ATTRIBUTE1 = l_def_clh_rec.attribute1,
        ATTRIBUTE2 = l_def_clh_rec.attribute2,
        ATTRIBUTE3 = l_def_clh_rec.attribute3,
        ATTRIBUTE4 = l_def_clh_rec.attribute4,
        ATTRIBUTE5 = l_def_clh_rec.attribute5,
        ATTRIBUTE6 = l_def_clh_rec.attribute6,
        ATTRIBUTE7 = l_def_clh_rec.attribute7,
        ATTRIBUTE8 = l_def_clh_rec.attribute8,
        ATTRIBUTE9 = l_def_clh_rec.attribute9,
        ATTRIBUTE10 = l_def_clh_rec.attribute10,
        ATTRIBUTE11 = l_def_clh_rec.attribute11,
        ATTRIBUTE12 = l_def_clh_rec.attribute12,
        ATTRIBUTE13 = l_def_clh_rec.attribute13,
        ATTRIBUTE14 = l_def_clh_rec.attribute14,
        ATTRIBUTE15 = l_def_clh_rec.attribute15,
        ORG_ID = l_def_clh_rec.org_id,
        REQUEST_ID = l_def_clh_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_clh_rec.program_application_id,
        PROGRAM_ID = l_def_clh_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_clh_rec.program_update_date,
        CREATED_BY = l_def_clh_rec.created_by,
        CREATION_DATE = l_def_clh_rec.creation_date,
        LAST_UPDATED_BY = l_def_clh_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_clh_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_clh_rec.last_update_login,
-- start: Apr 25, 2005 cklee: Modification for okl.h
        CHECKLIST_PURPOSE_CODE = l_def_clh_rec.CHECKLIST_PURPOSE_CODE,
        DECISION_DATE = l_def_clh_rec.DECISION_DATE,
        CHECKLIST_OBJ_ID = l_def_clh_rec.CHECKLIST_OBJ_ID,
        CHECKLIST_OBJ_TYPE_CODE = l_def_clh_rec.CHECKLIST_OBJ_TYPE_CODE,
        CKL_ID = l_def_clh_rec.CKL_ID
-- end: Apr 25, 2005 cklee: Modification for okl.h

    WHERE ID = l_def_clh_rec.id;

Line: 2203


  END update_row;

Line: 2207


  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_clhv_rec                     IN clhv_rec_type,
    x_clhv_rec                     OUT NOCOPY clhv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2217


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

Line: 2232


      l_clhv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2233


      l_clhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2234


      l_clhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2365


        IF (x_clhv_rec.program_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_clhv_rec.program_update_date := l_db_clhv_rec.program_update_date;

Line: 2377


        IF (x_clhv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_clhv_rec.last_updated_by := l_db_clhv_rec.last_updated_by;

Line: 2381


        IF (x_clhv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_clhv_rec.last_update_date := l_db_clhv_rec.last_update_date;

Line: 2385


        IF (x_clhv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_clhv_rec.last_update_login := l_db_clhv_rec.last_update_login;

Line: 2491


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_clh_rec,
      lx_clh_rec
    );

Line: 2539


  END update_row;

Line: 2543


  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_clhv_tbl                     IN clhv_tbl_type,
    x_clhv_tbl                     OUT NOCOPY clhv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2554


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

Line: 2568


          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_clhv_rec                     => p_clhv_tbl(i),
            x_clhv_rec                     => x_clhv_tbl(i));

Line: 2636


  END update_row;

Line: 2641


  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_clhv_tbl                     IN clhv_tbl_type,
    x_clhv_tbl                     OUT NOCOPY clhv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2651


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

Line: 2658


      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_clhv_tbl                     => p_clhv_tbl,
        x_clhv_tbl                     => x_clhv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2700


  END update_row;

Line: 2708


  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_clh_rec                      IN clh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2716


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

Line: 2731


    DELETE FROM OKL_CHECKLISTS
     WHERE ID = p_clh_rec.id;

Line: 2767


  END delete_row;

Line: 2771


  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_clhv_rec                     IN clhv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2780


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

Line: 2804


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

Line: 2849


  END delete_row;

Line: 2853


  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_clhv_tbl                     IN clhv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2863


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

Line: 2877


          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_clhv_rec                     => p_clhv_tbl(i));

Line: 2944


  END delete_row;

Line: 2949


  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_clhv_tbl                     IN clhv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2958


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

Line: 2965


      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_clhv_tbl                     => p_clhv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3006


  END delete_row;