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

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

Line: 101


    SELECT
            CURE_REFUND_ID,
            REFUND_NUMBER,
            STATUS,
            AMOUNT,
            BALANCE,
            TAP_ID,
            tai_id,
            CURE_REFUND_STAGE_ID,
            VENDOR_SITE_ID,
            CHR_ID,
            DISBURSEMENT_AMOUNT,
            OFFSET_AMOUNT,
            OFFSET_CONTRACT,
            TOTAL_REFUND_DUE,
            REFUND_DATE,
            OBJECT_VERSION_NUMBER,
            PROGRAM_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_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,
            CURE_REFUND_HEADER_ID,
            RECEIVED_AMOUNT
      FROM OKL_CURE_REFUNDS
     WHERE OKL_CURE_REFUNDS.cure_refund_id = p_cure_refund_id;

Line: 173


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

Line: 238


    SELECT
            CURE_REFUND_ID,
            REFUND_NUMBER,
            STATUS,
            AMOUNT,
            BALANCE,
            TAP_ID,
            tai_id,
            CURE_REFUND_STAGE_ID,
            VENDOR_SITE_ID,
            CHR_ID,
            DISBURSEMENT_AMOUNT,
            offset_AMOUNT,
            offset_contract,
            TOTAL_REFUND_DUE,
            REFUND_DATE,
            OBJECT_VERSION_NUMBER,
            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,
            CURE_REFUND_HEADER_ID,
            received_amount
      FROM Okl_Cure_Refunds
     WHERE okl_cure_refunds.cure_refund_id = p_cure_refund_id;

Line: 310


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

Line: 432


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

Line: 489


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

Line: 492


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

Line: 495


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

Line: 859


    p_to.program_update_date := p_from.program_update_date;

Line: 878


    p_to.last_updated_by := p_from.last_updated_by;

Line: 879


    p_to.last_update_date := p_from.last_update_date;

Line: 880


    p_to.last_update_login := p_from.last_update_login;

Line: 908


    p_to.program_update_date := p_from.program_update_date;

Line: 927


    p_to.last_updated_by := p_from.last_updated_by;

Line: 928


    p_to.last_update_date := p_from.last_update_date;

Line: 929


    p_to.last_update_login := p_from.last_update_login;

Line: 1177


  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_crf_rec                      IN crf_rec_type,
    x_crf_rec                      OUT NOCOPY crf_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1186


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

Line: 1222


    INSERT INTO OKL_CURE_REFUNDS(
      cure_refund_id,
      refund_number,
      status,
      amount,
      balance,
      tap_id,
      tai_id,
      cure_refund_stage_id,
      vendor_site_id,
      chr_id,
      disbursement_amount,
      offset_amount,
      offset_contract,
      total_refund_due,
      refund_date,
      object_version_number,
      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,
      cure_refund_header_id,
      received_amount,
      org_id)
    VALUES (
      l_crf_rec.cure_refund_id,
      l_crf_rec.refund_number,
      l_crf_rec.status,
      l_crf_rec.amount,
      l_crf_rec.balance,
      l_crf_rec.tap_id,
      l_crf_rec.tai_id,
      l_crf_rec.cure_refund_stage_id,
      l_crf_rec.vendor_site_id,
      l_crf_rec.chr_id,
      l_crf_rec.disbursement_amount,
      l_crf_rec.offset_amount,
      l_crf_rec.offset_contract,
      l_crf_rec.total_refund_due,
      l_crf_rec.refund_date,
      l_crf_rec.object_version_number,
      l_crf_rec.request_id,
      l_crf_rec.program_application_id,
      l_crf_rec.program_id,
      l_crf_rec.program_update_date,
      l_crf_rec.attribute_category,
      l_crf_rec.attribute1,
      l_crf_rec.attribute2,
      l_crf_rec.attribute3,
      l_crf_rec.attribute4,
      l_crf_rec.attribute5,
      l_crf_rec.attribute6,
      l_crf_rec.attribute7,
      l_crf_rec.attribute8,
      l_crf_rec.attribute9,
      l_crf_rec.attribute10,
      l_crf_rec.attribute11,
      l_crf_rec.attribute12,
      l_crf_rec.attribute13,
      l_crf_rec.attribute14,
      l_crf_rec.attribute15,
      l_crf_rec.created_by,
      l_crf_rec.creation_date,
      l_crf_rec.last_updated_by,
      l_crf_rec.last_update_date,
      l_crf_rec.last_update_login,
      l_crf_rec.cure_refund_header_id,
      l_crf_rec.received_amount,
      mo_global.get_current_org_id());   --dkagrawa aded to fix moac issue

Line: 1347


  END insert_row;

Line: 1351


  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_crfv_rec                     IN crfv_rec_type,
    x_crfv_rec                     OUT NOCOPY crfv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1361


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

Line: 1377


      l_crfv_rec.LAST_UPDATE_DATE := l_crfv_rec.CREATION_DATE;

Line: 1378


      l_crfv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1379


      l_crfv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1443


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_crf_rec,
      lx_crf_rec
    );

Line: 1492


  END insert_row;

Line: 1496


  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_crfv_tbl                     IN crfv_tbl_type,
    x_crfv_tbl                     OUT NOCOPY crfv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1507


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

Line: 1521


          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_crfv_rec                     => p_crfv_tbl(i),
            x_crfv_rec                     => x_crfv_tbl(i));

Line: 1589


  END insert_row;

Line: 1594


  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_crfv_tbl                     IN crfv_tbl_type,
    x_crfv_tbl                     OUT NOCOPY crfv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1604


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

Line: 1611


      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_crfv_tbl                     => p_crfv_tbl,
        x_crfv_tbl                     => x_crfv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1653


  END insert_row;

Line: 1671


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_REFUNDS
     WHERE CURE_REFUND_ID = p_crf_rec.cure_refund_id
       AND OBJECT_VERSION_NUMBER = p_crf_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1678


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_REFUNDS
     WHERE CURE_REFUND_ID = p_crf_rec.cure_refund_id;

Line: 1719


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1728


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2008


  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_crf_rec                      IN crf_rec_type,
    x_crf_rec                      OUT NOCOPY crf_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2017


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

Line: 2115


        IF (x_crf_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crf_rec.program_update_date := l_crf_rec.program_update_date;

Line: 2191


        IF (x_crf_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_crf_rec.last_updated_by := l_crf_rec.last_updated_by;

Line: 2195


        IF (x_crf_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crf_rec.last_update_date := l_crf_rec.last_update_date;

Line: 2199


        IF (x_crf_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_crf_rec.last_update_login := l_crf_rec.last_update_login;

Line: 2255


    UPDATE OKL_CURE_REFUNDS
    SET REFUND_NUMBER = l_def_crf_rec.refund_number,
        STATUS = l_def_crf_rec.status,
        AMOUNT = l_def_crf_rec.amount,
        BALANCE = l_def_crf_rec.balance,
        TAP_ID = l_def_crf_rec.tap_id,
        TAi_ID = l_def_crf_rec.tai_id,
        cure_refund_stage_id = l_def_crf_rec.cure_refund_stage_id,
        VENDOR_SITE_ID = l_def_crf_rec.vendor_site_id,
        CHR_ID = l_def_crf_rec.chr_id,
        DISBURSEMENT_AMOUNT = l_def_crf_rec.disbursement_amount,
        offset_amount = l_def_crf_rec.offset_amount,
        offset_contract = l_def_crf_rec.offset_contract,
        TOTAL_REFUND_DUE = l_def_crf_rec.total_refund_due,
        REFUND_DATE = l_def_crf_rec.refund_date,
        OBJECT_VERSION_NUMBER = l_def_crf_rec.object_version_number,
        REQUEST_ID = l_def_crf_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_crf_rec.program_application_id,
        PROGRAM_ID = l_def_crf_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_crf_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_crf_rec.attribute_category,
        ATTRIBUTE1 = l_def_crf_rec.attribute1,
        ATTRIBUTE2 = l_def_crf_rec.attribute2,
        ATTRIBUTE3 = l_def_crf_rec.attribute3,
        ATTRIBUTE4 = l_def_crf_rec.attribute4,
        ATTRIBUTE5 = l_def_crf_rec.attribute5,
        ATTRIBUTE6 = l_def_crf_rec.attribute6,
        ATTRIBUTE7 = l_def_crf_rec.attribute7,
        ATTRIBUTE8 = l_def_crf_rec.attribute8,
        ATTRIBUTE9 = l_def_crf_rec.attribute9,
        ATTRIBUTE10 = l_def_crf_rec.attribute10,
        ATTRIBUTE11 = l_def_crf_rec.attribute11,
        ATTRIBUTE12 = l_def_crf_rec.attribute12,
        ATTRIBUTE13 = l_def_crf_rec.attribute13,
        ATTRIBUTE14 = l_def_crf_rec.attribute14,
        ATTRIBUTE15 = l_def_crf_rec.attribute15,
        CREATED_BY = l_def_crf_rec.created_by,
        CREATION_DATE = l_def_crf_rec.creation_date,
        LAST_UPDATED_BY = l_def_crf_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_crf_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_crf_rec.last_update_login,
        CURE_REFUND_HEADER_ID = l_def_crf_rec.cure_refund_header_id,
        received_amount = l_def_crf_rec.received_amount
    WHERE CURE_REFUND_ID = l_def_crf_rec.cure_refund_id;

Line: 2334


  END update_row;

Line: 2338


  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_crfv_rec                     IN crfv_rec_type,
    x_crfv_rec                     OUT NOCOPY crfv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2348


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

Line: 2363


      l_crfv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2364


      l_crfv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2365


      l_crfv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2459


        IF (x_crfv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crfv_rec.program_update_date := l_db_crfv_rec.program_update_date;

Line: 2535


        IF (x_crfv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_crfv_rec.last_updated_by := l_db_crfv_rec.last_updated_by;

Line: 2539


        IF (x_crfv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crfv_rec.last_update_date := l_db_crfv_rec.last_update_date;

Line: 2543


        IF (x_crfv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_crfv_rec.last_update_login := l_db_crfv_rec.last_update_login;

Line: 2638


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_crf_rec,
      lx_crf_rec
    );

Line: 2686


  END update_row;

Line: 2690


  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_crfv_tbl                     IN crfv_tbl_type,
    x_crfv_tbl                     OUT NOCOPY crfv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2701


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

Line: 2715


          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_crfv_rec                     => p_crfv_tbl(i),
            x_crfv_rec                     => x_crfv_tbl(i));

Line: 2783


  END update_row;

Line: 2788


  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_crfv_tbl                     IN crfv_tbl_type,
    x_crfv_tbl                     OUT NOCOPY crfv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2798


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

Line: 2805


      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_crfv_tbl                     => p_crfv_tbl,
        x_crfv_tbl                     => x_crfv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2847


  END update_row;

Line: 2855


  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_crf_rec                      IN crf_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2863


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

Line: 2878


    DELETE FROM OKL_CURE_REFUNDS
     WHERE CURE_REFUND_ID = p_crf_rec.cure_refund_id;

Line: 2914


  END delete_row;

Line: 2918


  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_crfv_rec                     IN crfv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2927


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

Line: 2951


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

Line: 2996


  END delete_row;

Line: 3000


  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_crfv_tbl                     IN crfv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3010


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

Line: 3024


          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_crfv_rec                     => p_crfv_tbl(i));

Line: 3091


  END delete_row;

Line: 3096


  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_crfv_tbl                     IN crfv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3105


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

Line: 3112


      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_crfv_tbl                     => p_crfv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3153


  END delete_row;