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

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

Line: 101


    SELECT
            CURE_REPORT_AMOUNT_ID,
            CURE_AMOUNT_ID,
            CURE_REPORT_ID,
            REQUEST_TYPE,
            CURES_IN_POSSESSION,
            CLAIMED_CURE_AMOUNT,
            PAST_DUE_AMOUNT,
            ELIGIBLE_CURE_AMOUNT,
            REPURCHASE_AMOUNT,
            OUTSTANDING_AMOUNT,
            TIMES_CURED,
            PAYMENTS_REMAINING,
            STATUS,
            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 OKL_Cure_Report_Amounts
     WHERE cure_report_amount_id = p_cure_report_amount_id;

Line: 169


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

Line: 232


    SELECT
            CURE_REPORT_AMOUNT_ID,
            CURE_AMOUNT_ID,
            CURE_REPORT_ID,
            REQUEST_TYPE,
            CURES_IN_POSSESSION,
            CLAIMED_CURE_AMOUNT,
            PAST_DUE_AMOUNT,
            ELIGIBLE_CURE_AMOUNT,
            REPURCHASE_AMOUNT,
            OUTSTANDING_AMOUNT,
            TIMES_CURED,
            PAYMENTS_REMAINING,
            STATUS,
            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 OKL_Cure_Report_Amounts
     WHERE OKL_cure_report_amounts.cure_report_amount_id = p_cure_report_amount_id;

Line: 300


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

Line: 417


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

Line: 474


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

Line: 477


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

Line: 480


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

Line: 553


      SELECT approval_status
      FROM   OKL_cure_reports
      WHERE  cure_report_id = p_cure_report_id;

Line: 574


      OKL_API.set_message(G_APP_NAME, G_CANNOT_UPDATE_REQUEST, G_COL_NAME_TOKEN, 'cure_report_id');

Line: 794


    p_to.program_update_date := p_from.program_update_date;

Line: 813


    p_to.last_updated_by := p_from.last_updated_by;

Line: 814


    p_to.last_update_date := p_from.last_update_date;

Line: 815


    p_to.last_update_login := p_from.last_update_login;

Line: 840


    p_to.program_update_date := p_from.program_update_date;

Line: 859


    p_to.last_updated_by := p_from.last_updated_by;

Line: 860


    p_to.last_update_date := p_from.last_update_date;

Line: 861


    p_to.last_update_login := p_from.last_update_login;

Line: 1107


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cra_rec                      IN cra_rec_type,
    x_cra_rec                      OUT NOCOPY cra_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1116


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

Line: 1152


    INSERT INTO OKL_CURE_REPORT_AMOUNTS(
      cure_report_amount_id,
      cure_amount_id,
      cure_report_id,
      request_type,
      cures_in_possession,
      claimed_cure_amount,
      past_due_amount,
      eligible_cure_amount,
      repurchase_amount,
      outstanding_amount,
      times_cured,
      payments_remaining,
      status,
      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_cra_rec.cure_report_amount_id,
      l_cra_rec.cure_amount_id,
      l_cra_rec.cure_report_id,
      l_cra_rec.request_type,
      l_cra_rec.cures_in_possession,
      l_cra_rec.claimed_cure_amount,
      l_cra_rec.past_due_amount,
      l_cra_rec.eligible_cure_amount,
      l_cra_rec.repurchase_amount,
      l_cra_rec.outstanding_amount,
      l_cra_rec.times_cured,
      l_cra_rec.payments_remaining,
      l_cra_rec.status,
      l_cra_rec.object_version_number,
      l_cra_rec.org_id,
      l_cra_rec.request_id,
      l_cra_rec.program_application_id,
      l_cra_rec.program_id,
      l_cra_rec.program_update_date,
      l_cra_rec.attribute_category,
      l_cra_rec.attribute1,
      l_cra_rec.attribute2,
      l_cra_rec.attribute3,
      l_cra_rec.attribute4,
      l_cra_rec.attribute5,
      l_cra_rec.attribute6,
      l_cra_rec.attribute7,
      l_cra_rec.attribute8,
      l_cra_rec.attribute9,
      l_cra_rec.attribute10,
      l_cra_rec.attribute11,
      l_cra_rec.attribute12,
      l_cra_rec.attribute13,
      l_cra_rec.attribute14,
      l_cra_rec.attribute15,
      l_cra_rec.created_by,
      l_cra_rec.creation_date,
      l_cra_rec.last_updated_by,
      l_cra_rec.last_update_date,
      l_cra_rec.last_update_login);

Line: 1269


  END insert_row;

Line: 1273


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 ,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crav_rec                     IN crav_rec_type,
    x_crav_rec                     OUT NOCOPY crav_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1283


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

Line: 1299


      l_crav_rec.LAST_UPDATE_DATE := l_crav_rec.CREATION_DATE;

Line: 1300


      l_crav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1301


      l_crav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1365


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cra_rec,
      lx_cra_rec
    );

Line: 1414


  END insert_row;

Line: 1418


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crav_tbl                     IN crav_tbl_type,
    x_crav_tbl                     OUT NOCOPY crav_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1429


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

Line: 1443


          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_crav_rec                     => p_crav_tbl(i),
            x_crav_rec                     => x_crav_tbl(i));

Line: 1511


  END insert_row;

Line: 1516


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crav_tbl                     IN crav_tbl_type,
    x_crav_tbl                     OUT NOCOPY crav_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1526


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

Line: 1533


      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_crav_tbl                     => p_crav_tbl,
        x_crav_tbl                     => x_crav_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1575


  END insert_row;

Line: 1593


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_REPORT_AMOUNTS
     WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id
       AND OBJECT_VERSION_NUMBER = p_cra_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1600


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_REPORT_AMOUNTS
     WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id;

Line: 1641


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1650


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1930


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cra_rec                      IN cra_rec_type,
    x_cra_rec                      OUT NOCOPY cra_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1939


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

Line: 2031


        IF (x_cra_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cra_rec.program_update_date := l_cra_rec.program_update_date;

Line: 2107


        IF (x_cra_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cra_rec.last_updated_by := l_cra_rec.last_updated_by;

Line: 2111


        IF (x_cra_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cra_rec.last_update_date := l_cra_rec.last_update_date;

Line: 2115


        IF (x_cra_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cra_rec.last_update_login := l_cra_rec.last_update_login;

Line: 2161


    UPDATE OKL_CURE_REPORT_AMOUNTS
    SET CURE_AMOUNT_ID = l_def_cra_rec.cure_amount_id,
        CURE_REPORT_ID = l_def_cra_rec.cure_report_id,
        REQUEST_TYPE = l_def_cra_rec.request_type,
        CURES_IN_POSSESSION = l_def_cra_rec.cures_in_possession,
        CLAIMED_CURE_AMOUNT = l_def_cra_rec.claimed_cure_amount,
        PAST_DUE_AMOUNT = l_def_cra_rec.past_due_amount,
        ELIGIBLE_CURE_AMOUNT = l_def_cra_rec.eligible_cure_amount,
        REPURCHASE_AMOUNT = l_def_cra_rec.repurchase_amount,
        OUTSTANDING_AMOUNT = l_def_cra_rec.outstanding_amount,
        TIMES_CURED = l_def_cra_rec.times_cured,
        PAYMENTS_REMAINING = l_def_cra_rec.payments_remaining,
        STATUS = l_def_cra_rec.status,
        OBJECT_VERSION_NUMBER = l_def_cra_rec.object_version_number,
        ORG_ID = l_def_cra_rec.org_id,
        REQUEST_ID = l_def_cra_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_cra_rec.program_application_id,
        PROGRAM_ID = l_def_cra_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_cra_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_cra_rec.attribute_category,
        ATTRIBUTE1 = l_def_cra_rec.attribute1,
        ATTRIBUTE2 = l_def_cra_rec.attribute2,
        ATTRIBUTE3 = l_def_cra_rec.attribute3,
        ATTRIBUTE4 = l_def_cra_rec.attribute4,
        ATTRIBUTE5 = l_def_cra_rec.attribute5,
        ATTRIBUTE6 = l_def_cra_rec.attribute6,
        ATTRIBUTE7 = l_def_cra_rec.attribute7,
        ATTRIBUTE8 = l_def_cra_rec.attribute8,
        ATTRIBUTE9 = l_def_cra_rec.attribute9,
        ATTRIBUTE10 = l_def_cra_rec.attribute10,
        ATTRIBUTE11 = l_def_cra_rec.attribute11,
        ATTRIBUTE12 = l_def_cra_rec.attribute12,
        ATTRIBUTE13 = l_def_cra_rec.attribute13,
        ATTRIBUTE14 = l_def_cra_rec.attribute14,
        ATTRIBUTE15 = l_def_cra_rec.attribute15,
        CREATED_BY = l_def_cra_rec.created_by,
        CREATION_DATE = l_def_cra_rec.creation_date,
        LAST_UPDATED_BY = l_def_cra_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cra_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cra_rec.last_update_login
    WHERE CURE_REPORT_AMOUNT_ID = l_def_cra_rec.cure_report_amount_id;

Line: 2237


  END update_row;

Line: 2241


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crav_rec                     IN crav_rec_type,
    x_crav_rec                     OUT NOCOPY crav_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2251


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

Line: 2266


      l_crav_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2267


      l_crav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2268


      l_crav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2355


        IF (x_crav_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crav_rec.program_update_date := l_db_crav_rec.program_update_date;

Line: 2431


        IF (x_crav_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_crav_rec.last_updated_by := l_db_crav_rec.last_updated_by;

Line: 2435


        IF (x_crav_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_crav_rec.last_update_date := l_db_crav_rec.last_update_date;

Line: 2439


        IF (x_crav_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_crav_rec.last_update_login := l_db_crav_rec.last_update_login;

Line: 2524


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cra_rec,
      lx_cra_rec
    );

Line: 2572


  END update_row;

Line: 2576


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crav_tbl                     IN crav_tbl_type,
    x_crav_tbl                     OUT NOCOPY crav_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2587


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

Line: 2601


          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_crav_rec                     => p_crav_tbl(i),
            x_crav_rec                     => x_crav_tbl(i));

Line: 2669


  END update_row;

Line: 2674


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crav_tbl                     IN crav_tbl_type,
    x_crav_tbl                     OUT NOCOPY crav_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2684


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

Line: 2691


      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_crav_tbl                     => p_crav_tbl,
        x_crav_tbl                     => x_crav_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2733


  END update_row;

Line: 2741


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_cra_rec                      IN cra_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2749


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

Line: 2764


    DELETE FROM OKL_CURE_REPORT_AMOUNTS
     WHERE CURE_REPORT_AMOUNT_ID = p_cra_rec.cure_report_amount_id;

Line: 2800


  END delete_row;

Line: 2804


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crav_rec                     IN crav_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2813


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

Line: 2837


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

Line: 2882


  END delete_row;

Line: 2886


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crav_tbl                     IN crav_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2896


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

Line: 2910


          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_crav_rec                     => p_crav_tbl(i));

Line: 2977


  END delete_row;

Line: 2982


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_crav_tbl                     IN crav_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2991


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

Line: 2998


      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_crav_tbl                     => p_crav_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3039


  END delete_row;