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

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

Line: 101


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CKL_ID,
            TODO_ITEM_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
            MANDATORY_FLAG,
            USER_COMPLETE_FLAG,
            ADMIN_NOTE,
            USER_NOTE,
            DNZ_CHECKLIST_OBJ_ID,
            FUNCTION_ID,
            FUNCTION_VALIDATE_RSTS,
            FUNCTION_VALIDATE_MSG,
            INST_CHECKLIST_TYPE
-- end: Apr 25, 2005 cklee: Modification for okl.h
--Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
           ,APPEAL_FLAG
      FROM OKL_CHECKLIST_DETAILS
     WHERE OKL_CHECKLIST_DETAILS.id = p_id;

Line: 178


              l_cldv_rec.program_update_date,
              l_cldv_rec.created_by,
              l_cldv_rec.creation_date,
              l_cldv_rec.last_updated_by,
              l_cldv_rec.last_update_date,
              l_cldv_rec.last_update_login,
-- start: Apr 25, 2005 cklee: Modification for okl.h
              l_cldv_rec.MANDATORY_FLAG,
              l_cldv_rec.USER_COMPLETE_FLAG,
              l_cldv_rec.ADMIN_NOTE,
              l_cldv_rec.USER_NOTE,
              l_cldv_rec.DNZ_CHECKLIST_OBJ_ID,
              l_cldv_rec.FUNCTION_ID,
              l_cldv_rec.FUNCTION_VALIDATE_RSTS,
              l_cldv_rec.FUNCTION_VALIDATE_MSG,
              l_cldv_rec.INST_CHECKLIST_TYPE
-- end: Apr 25, 2005 cklee: Modification for okl.h
--Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
             ,l_cldv_rec.APPEAL_FLAG
              ;

Line: 239


    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            CKL_ID,
            TODO_ITEM_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
            MANDATORY_FLAG,
            USER_COMPLETE_FLAG,
            ADMIN_NOTE,
            USER_NOTE,
            DNZ_CHECKLIST_OBJ_ID,
            FUNCTION_ID,
            FUNCTION_VALIDATE_RSTS,
            FUNCTION_VALIDATE_MSG,
            INST_CHECKLIST_TYPE
-- end: Apr 25, 2005 cklee: Modification for okl.h
--Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
           ,APPEAL_FLAG
      FROM Okl_Checklist_Details
     WHERE okl_checklist_details.id = p_id;

Line: 316


              l_cld_rec.program_update_date,
              l_cld_rec.created_by,
              l_cld_rec.creation_date,
              l_cld_rec.last_updated_by,
              l_cld_rec.last_update_date,
              l_cld_rec.last_update_login,
-- start: Apr 25, 2005 cklee: Modification for okl.h
              l_cld_rec.MANDATORY_FLAG,
              l_cld_rec.USER_COMPLETE_FLAG,
              l_cld_rec.ADMIN_NOTE,
              l_cld_rec.USER_NOTE,
              l_cld_rec.DNZ_CHECKLIST_OBJ_ID,
              l_cld_rec.FUNCTION_ID,
              l_cld_rec.FUNCTION_VALIDATE_RSTS,
              l_cld_rec.FUNCTION_VALIDATE_MSG,
              l_cld_rec.INST_CHECKLIST_TYPE
-- end: Apr 25, 2005 cklee: Modification for okl.h
--Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
             ,l_cld_rec.APPEAL_FLAG
              ;

Line: 449


    IF (l_cldv_rec.program_update_date = OKL_API.G_MISS_DATE ) THEN
      l_cldv_rec.program_update_date := NULL;

Line: 458


    IF (l_cldv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_cldv_rec.last_updated_by := NULL;

Line: 461


    IF (l_cldv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_cldv_rec.last_update_date := NULL;

Line: 464


    IF (l_cldv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_cldv_rec.last_update_login := NULL;

Line: 544


    SELECT 1
      FROM okl_checklists clh
     WHERE clh.id = p_ckl_id
    ;

Line: 599


    SELECT 1
      FROM fnd_lookups lok
      WHERE lok.lookup_type = 'OKL_TODO_ITEMS'
     AND   lok.lookup_code = p_todo_item_code
    ;

Line: 756


    p_to.program_update_date := p_from.program_update_date;

Line: 759


    p_to.last_updated_by := p_from.last_updated_by;

Line: 760


    p_to.last_update_date := p_from.last_update_date;

Line: 761


    p_to.last_update_login := p_from.last_update_login;

Line: 805


    p_to.program_update_date := p_from.program_update_date;

Line: 808


    p_to.last_updated_by := p_from.last_updated_by;

Line: 809


    p_to.last_update_date := p_from.last_update_date;

Line: 810


    p_to.last_update_login := p_from.last_update_login;

Line: 1069


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cld_rec                      IN cld_rec_type,
    x_cld_rec                      OUT NOCOPY cld_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1078


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

Line: 1114


    INSERT INTO OKL_CHECKLIST_DETAILS(
      id,
      object_version_number,
      ckl_id,
      todo_item_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
      MANDATORY_FLAG,
      USER_COMPLETE_FLAG,
      ADMIN_NOTE,
      USER_NOTE,
      DNZ_CHECKLIST_OBJ_ID,
      FUNCTION_ID,
      FUNCTION_VALIDATE_RSTS,
      FUNCTION_VALIDATE_MSG,
      INST_CHECKLIST_TYPE
-- end: Apr 25, 2005 cklee: Modification for okl.h
--Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
     ,APPEAL_FLAG
      )
    VALUES (
      l_cld_rec.id,
      l_cld_rec.object_version_number,
      l_cld_rec.ckl_id,
      l_cld_rec.todo_item_code,
      l_cld_rec.attribute_category,
      l_cld_rec.attribute1,
      l_cld_rec.attribute2,
      l_cld_rec.attribute3,
      l_cld_rec.attribute4,
      l_cld_rec.attribute5,
      l_cld_rec.attribute6,
      l_cld_rec.attribute7,
      l_cld_rec.attribute8,
      l_cld_rec.attribute9,
      l_cld_rec.attribute10,
      l_cld_rec.attribute11,
      l_cld_rec.attribute12,
      l_cld_rec.attribute13,
      l_cld_rec.attribute14,
      l_cld_rec.attribute15,
      l_cld_rec.org_id,
      l_cld_rec.request_id,
      l_cld_rec.program_application_id,
      l_cld_rec.program_id,
      l_cld_rec.program_update_date,
      l_cld_rec.created_by,
      l_cld_rec.creation_date,
      l_cld_rec.last_updated_by,
      l_cld_rec.last_update_date,
      l_cld_rec.last_update_login,
-- start: Apr 25, 2005 cklee: Modification for okl.h
      l_cld_rec.MANDATORY_FLAG,
      l_cld_rec.USER_COMPLETE_FLAG,
      l_cld_rec.ADMIN_NOTE,
      l_cld_rec.USER_NOTE,
      l_cld_rec.DNZ_CHECKLIST_OBJ_ID,
      l_cld_rec.FUNCTION_ID,
      l_cld_rec.FUNCTION_VALIDATE_RSTS,
      l_cld_rec.FUNCTION_VALIDATE_MSG,
      l_cld_rec.INST_CHECKLIST_TYPE
-- end: Apr 25, 2005 cklee: Modification for okl.h
--Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
     ,l_cld_rec.APPEAL_FLAG
      );

Line: 1239


  END insert_row;

Line: 1243


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cldv_rec                     IN cldv_rec_type,
    x_cldv_rec                     OUT NOCOPY cldv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1253


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

Line: 1269


      l_cldv_rec.LAST_UPDATE_DATE := l_cldv_rec.CREATION_DATE;

Line: 1270


      l_cldv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1271


      l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1287


      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_cldv_rec.REQUEST_ID
            ,x_cldv_rec.PROGRAM_APPLICATION_ID
            ,x_cldv_rec.PROGRAM_ID
            ,x_cldv_rec.PROGRAM_UPDATE_DATE
      FROM DUAL;

Line: 1348


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cld_rec,
      lx_cld_rec
    );

Line: 1397


  END insert_row;

Line: 1401


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cldv_tbl                     IN cldv_tbl_type,
    x_cldv_tbl                     OUT NOCOPY cldv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1412


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

Line: 1426


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_cldv_rec                     => p_cldv_tbl(i),
            x_cldv_rec                     => x_cldv_tbl(i));

Line: 1494


  END insert_row;

Line: 1499


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cldv_tbl                     IN cldv_tbl_type,
    x_cldv_tbl                     OUT NOCOPY cldv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1509


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

Line: 1516


      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_cldv_tbl                     => p_cldv_tbl,
        x_cldv_tbl                     => x_cldv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1558


  END insert_row;

Line: 1576


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CHECKLIST_DETAILS
     WHERE ID = p_cld_rec.id
       AND OBJECT_VERSION_NUMBER = p_cld_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1583


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CHECKLIST_DETAILS
     WHERE ID = p_cld_rec.id;

Line: 1624


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1633


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1913


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cld_rec                      IN cld_rec_type,
    x_cld_rec                      OUT NOCOPY cld_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1922


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

Line: 2038


        IF (x_cld_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cld_rec.program_update_date := l_cld_rec.program_update_date;

Line: 2050


        IF (x_cld_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cld_rec.last_updated_by := l_cld_rec.last_updated_by;

Line: 2054


        IF (x_cld_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cld_rec.last_update_date := l_cld_rec.last_update_date;

Line: 2058


        IF (x_cld_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cld_rec.last_update_login := l_cld_rec.last_update_login;

Line: 2148


    UPDATE OKL_CHECKLIST_DETAILS
    SET OBJECT_VERSION_NUMBER = l_def_cld_rec.object_version_number,
        CKL_ID = l_def_cld_rec.ckl_id,
        TODO_ITEM_CODE = l_def_cld_rec.todo_item_code,
        ATTRIBUTE_CATEGORY = l_def_cld_rec.attribute_category,
        ATTRIBUTE1 = l_def_cld_rec.attribute1,
        ATTRIBUTE2 = l_def_cld_rec.attribute2,
        ATTRIBUTE3 = l_def_cld_rec.attribute3,
        ATTRIBUTE4 = l_def_cld_rec.attribute4,
        ATTRIBUTE5 = l_def_cld_rec.attribute5,
        ATTRIBUTE6 = l_def_cld_rec.attribute6,
        ATTRIBUTE7 = l_def_cld_rec.attribute7,
        ATTRIBUTE8 = l_def_cld_rec.attribute8,
        ATTRIBUTE9 = l_def_cld_rec.attribute9,
        ATTRIBUTE10 = l_def_cld_rec.attribute10,
        ATTRIBUTE11 = l_def_cld_rec.attribute11,
        ATTRIBUTE12 = l_def_cld_rec.attribute12,
        ATTRIBUTE13 = l_def_cld_rec.attribute13,
        ATTRIBUTE14 = l_def_cld_rec.attribute14,
        ATTRIBUTE15 = l_def_cld_rec.attribute15,
        ORG_ID = l_def_cld_rec.org_id,
        REQUEST_ID = l_def_cld_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_cld_rec.program_application_id,
        PROGRAM_ID = l_def_cld_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_cld_rec.program_update_date,
        CREATED_BY = l_def_cld_rec.created_by,
        CREATION_DATE = l_def_cld_rec.creation_date,
        LAST_UPDATED_BY = l_def_cld_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cld_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cld_rec.last_update_login,
-- start: Apr 25, 2005 cklee: Modification for okl.h
        MANDATORY_FLAG = l_def_cld_rec.MANDATORY_FLAG,
        USER_COMPLETE_FLAG = l_def_cld_rec.USER_COMPLETE_FLAG,
        ADMIN_NOTE = l_def_cld_rec.ADMIN_NOTE,
        USER_NOTE = l_def_cld_rec.USER_NOTE,
        DNZ_CHECKLIST_OBJ_ID = l_def_cld_rec.DNZ_CHECKLIST_OBJ_ID,
        FUNCTION_ID = l_def_cld_rec.FUNCTION_ID,
        FUNCTION_VALIDATE_RSTS = l_def_cld_rec.FUNCTION_VALIDATE_RSTS,
        FUNCTION_VALIDATE_MSG = l_def_cld_rec.FUNCTION_VALIDATE_MSG,
        INST_CHECKLIST_TYPE = l_def_cld_rec.INST_CHECKLIST_TYPE
-- end: Apr 25, 2005 cklee: Modification for okl.h
--Bug 4872271 PAGARG Appeal flag column is added to store the marking for Appeal
       ,APPEAL_FLAG = l_def_cld_rec.APPEAL_FLAG
    WHERE ID = l_def_cld_rec.id;

Line: 2227


  END update_row;

Line: 2231


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cldv_rec                     IN cldv_rec_type,
    x_cldv_rec                     OUT NOCOPY cldv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2241


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

Line: 2256


      l_cldv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2257


      l_cldv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2258


      l_cldv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2369


        IF (x_cldv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cldv_rec.program_update_date := l_db_cldv_rec.program_update_date;

Line: 2381


        IF (x_cldv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cldv_rec.last_updated_by := l_db_cldv_rec.last_updated_by;

Line: 2385


        IF (x_cldv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cldv_rec.last_update_date := l_db_cldv_rec.last_update_date;

Line: 2389


        IF (x_cldv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cldv_rec.last_update_login := l_db_cldv_rec.last_update_login;

Line: 2518


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cld_rec,
      lx_cld_rec
    );

Line: 2566


  END update_row;

Line: 2570


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cldv_tbl                     IN cldv_tbl_type,
    x_cldv_tbl                     OUT NOCOPY cldv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2581


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

Line: 2595


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_cldv_rec                     => p_cldv_tbl(i),
            x_cldv_rec                     => x_cldv_tbl(i));

Line: 2663


  END update_row;

Line: 2668


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cldv_tbl                     IN cldv_tbl_type,
    x_cldv_tbl                     OUT NOCOPY cldv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2678


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

Line: 2685


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_cldv_tbl                     => p_cldv_tbl,
        x_cldv_tbl                     => x_cldv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2727


  END update_row;

Line: 2735


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cld_rec                      IN cld_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2743


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

Line: 2758


    DELETE FROM OKL_CHECKLIST_DETAILS
     WHERE ID = p_cld_rec.id;

Line: 2794


  END delete_row;

Line: 2798


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cldv_rec                     IN cldv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2807


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

Line: 2831


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

Line: 2876


  END delete_row;

Line: 2880


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cldv_tbl                     IN cldv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2890


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

Line: 2904


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_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_cldv_rec                     => p_cldv_tbl(i));

Line: 2971


  END delete_row;

Line: 2976


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cldv_tbl                     IN cldv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2985


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

Line: 2992


      delete_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_cldv_tbl                     => p_cldv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3033


  END delete_row;