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

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

Line: 101


    SELECT
            CURE_AMOUNT_ID,
            CHR_ID,
            CURE_TYPE,
            CURE_AMOUNT,
            REPURCHASE_AMOUNT,
            EFFECTIVE_DATE,
            TIMES_CURED,
            PAYMENTS_REMAINING,
            ELIGIBLE_CURE_AMOUNT,
            OUTSTANDING_AMOUNT,
            PAST_DUE_AMOUNT,
            CURES_IN_POSSESSION,
            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,
            NEGOTIATED_AMOUNT,
            RECEIVED_AMOUNT,
            DELINQUENT_AMOUNT,
            SHORT_FUND_AMOUNT,
            CRT_ID,
            SHOW_ON_REQUEST,
            SELECTED_ON_REQUEST,
            QTE_ID,
            PROCESS
      FROM OKL_CURE_AMOUNTS
     WHERE OKL_CURE_AMOUNTS.cure_amount_id = p_cure_amount_id;

Line: 178


              l_camv_rec.program_update_date,
              l_camv_rec.attribute_category,
              l_camv_rec.attribute1,
              l_camv_rec.attribute2,
              l_camv_rec.attribute3,
              l_camv_rec.attribute4,
              l_camv_rec.attribute5,
              l_camv_rec.attribute6,
              l_camv_rec.attribute7,
              l_camv_rec.attribute8,
              l_camv_rec.attribute9,
              l_camv_rec.attribute10,
              l_camv_rec.attribute11,
              l_camv_rec.attribute12,
              l_camv_rec.attribute13,
              l_camv_rec.attribute14,
              l_camv_rec.attribute15,
              l_camv_rec.created_by,
              l_camv_rec.creation_date,
              l_camv_rec.last_updated_by,
              l_camv_rec.last_update_date,
              l_camv_rec.last_update_login,
              l_camv_rec.NEGOTIATED_AMOUNT,
              l_camv_rec.RECEIVED_AMOUNT,
              l_camv_rec.DELINQUENT_AMOUNT,
              l_camv_rec.SHORT_FUND_AMOUNT,
              l_camv_rec.CRT_ID,
              l_camv_rec.SHOW_ON_REQUEST,
              l_camv_rec.SELECTED_ON_REQUEST,
              l_camv_rec.QTE_ID,
              l_camv_rec.PROCESS;

Line: 251


    SELECT
            CURE_AMOUNT_ID,
            CHR_ID,
            CURE_TYPE,
            CURE_AMOUNT,
            REPURCHASE_AMOUNT,
            EFFECTIVE_DATE,
            TIMES_CURED,
            PAYMENTS_REMAINING,
            ELIGIBLE_CURE_AMOUNT,
            OUTSTANDING_AMOUNT,
            PAST_DUE_AMOUNT,
            CURES_IN_POSSESSION,
            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,
            NEGOTIATED_AMOUNT,
            RECEIVED_AMOUNT,
            DELINQUENT_AMOUNT,
            SHORT_FUND_AMOUNT,
            CRT_ID,
            SHOW_ON_REQUEST,
            SELECTED_ON_REQUEST,
            QTE_ID,
            PROCESS
      FROM OKL_Cure_Amounts
     WHERE OKL_cure_amounts.cure_amount_id = p_cure_amount_id;

Line: 328


              l_cam_rec.program_update_date,
              l_cam_rec.attribute_category,
              l_cam_rec.attribute1,
              l_cam_rec.attribute2,
              l_cam_rec.attribute3,
              l_cam_rec.attribute4,
              l_cam_rec.attribute5,
              l_cam_rec.attribute6,
              l_cam_rec.attribute7,
              l_cam_rec.attribute8,
              l_cam_rec.attribute9,
              l_cam_rec.attribute10,
              l_cam_rec.attribute11,
              l_cam_rec.attribute12,
              l_cam_rec.attribute13,
              l_cam_rec.attribute14,
              l_cam_rec.attribute15,
              l_cam_rec.created_by,
              l_cam_rec.creation_date,
              l_cam_rec.last_updated_by,
              l_cam_rec.last_update_date,
              l_cam_rec.last_update_login,
              l_cam_rec.NEGOTIATED_AMOUNT,
              l_cam_rec.RECEIVED_AMOUNT,
              l_cam_rec.DELINQUENT_AMOUNT,
              l_cam_rec.SHORT_FUND_AMOUNT,
              l_cam_rec.CRT_ID,
              l_cam_rec.SHOW_ON_REQUEST,
              l_cam_rec.SELECTED_ON_REQUEST,
              l_cam_rec.QTE_ID,
              l_cam_rec.PROCESS;

Line: 454


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

Line: 511


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

Line: 514


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

Line: 517


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

Line: 538


    IF (l_camv_rec.SELECTED_ON_REQUEST = OKL_API.G_MISS_CHAR ) THEN
      l_camv_rec.SELECTED_ON_REQUEST := NULL;

Line: 786


    p_to.program_update_date := p_from.program_update_date;

Line: 805


    p_to.last_updated_by := p_from.last_updated_by;

Line: 806


    p_to.last_update_date := p_from.last_update_date;

Line: 807


    p_to.last_update_login := p_from.last_update_login;

Line: 814


    p_to.SELECTED_ON_REQUEST := p_from.SELECTED_ON_REQUEST;

Line: 841


    p_to.program_update_date := p_from.program_update_date;

Line: 860


    p_to.last_updated_by := p_from.last_updated_by;

Line: 861


    p_to.last_update_date := p_from.last_update_date;

Line: 862


    p_to.last_update_login := p_from.last_update_login;

Line: 869


    p_to.SELECTED_ON_REQUEST := p_from.SELECTED_ON_REQUEST;

Line: 1117


  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_cam_rec                      IN cam_rec_type,
    x_cam_rec                      OUT NOCOPY cam_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1126


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

Line: 1162


    INSERT INTO OKL_CURE_AMOUNTS(
      cure_amount_id,
      chr_id,
      cure_type,
      cure_amount,
      repurchase_amount,
      effective_date,
      times_cured,
      payments_remaining,
      eligible_cure_amount,
      outstanding_amount,
      past_due_amount,
      cures_in_possession,
      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,
      NEGOTIATED_AMOUNT,
      RECEIVED_AMOUNT,
      DELINQUENT_AMOUNT,
      SHORT_FUND_AMOUNT,
      CRT_ID,
      SHOW_ON_REQUEST,
      SELECTED_ON_REQUEST,
      QTE_ID,
      PROCESS)
    VALUES (
      l_cam_rec.cure_amount_id,
      l_cam_rec.chr_id,
      l_cam_rec.cure_type,
      l_cam_rec.cure_amount,
      l_cam_rec.repurchase_amount,
      l_cam_rec.effective_date,
      l_cam_rec.times_cured,
      l_cam_rec.payments_remaining,
      l_cam_rec.eligible_cure_amount,
      l_cam_rec.outstanding_amount,
      l_cam_rec.past_due_amount,
      l_cam_rec.cures_in_possession,
      l_cam_rec.status,
      l_cam_rec.object_version_number,
      l_cam_rec.org_id,
      l_cam_rec.request_id,
      l_cam_rec.program_application_id,
      l_cam_rec.program_id,
      l_cam_rec.program_update_date,
      l_cam_rec.attribute_category,
      l_cam_rec.attribute1,
      l_cam_rec.attribute2,
      l_cam_rec.attribute3,
      l_cam_rec.attribute4,
      l_cam_rec.attribute5,
      l_cam_rec.attribute6,
      l_cam_rec.attribute7,
      l_cam_rec.attribute8,
      l_cam_rec.attribute9,
      l_cam_rec.attribute10,
      l_cam_rec.attribute11,
      l_cam_rec.attribute12,
      l_cam_rec.attribute13,
      l_cam_rec.attribute14,
      l_cam_rec.attribute15,
      l_cam_rec.created_by,
      l_cam_rec.creation_date,
      l_cam_rec.last_updated_by,
      l_cam_rec.last_update_date,
      l_cam_rec.last_update_login,
      l_cam_rec.NEGOTIATED_AMOUNT,
      l_cam_rec.RECEIVED_AMOUNT,
      l_cam_rec.DELINQUENT_AMOUNT,
      l_cam_rec.SHORT_FUND_AMOUNT,
      l_cam_rec.CRT_ID,
      l_cam_rec.SHOW_ON_REQUEST,
      l_cam_rec.SELECTED_ON_REQUEST,
      l_cam_rec.qte_id,
      l_cam_rec.process);

Line: 1297


  END insert_row;

Line: 1301


  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_camv_rec                     IN camv_rec_type,
    x_camv_rec                     OUT NOCOPY camv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1311


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

Line: 1327


      l_camv_rec.LAST_UPDATE_DATE := l_camv_rec.CREATION_DATE;

Line: 1328


      l_camv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1329


      l_camv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1393


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cam_rec,
      lx_cam_rec
    );

Line: 1442


  END insert_row;

Line: 1446


  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_camv_tbl                     IN camv_tbl_type,
    x_camv_tbl                     OUT NOCOPY camv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1457


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

Line: 1471


          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_camv_rec                     => p_camv_tbl(i),
            x_camv_rec                     => x_camv_tbl(i));

Line: 1539


  END insert_row;

Line: 1544


  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_camv_tbl                     IN camv_tbl_type,
    x_camv_tbl                     OUT NOCOPY camv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1554


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

Line: 1561


      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_camv_tbl                     => p_camv_tbl,
        x_camv_tbl                     => x_camv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1603


  END insert_row;

Line: 1621


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_AMOUNTS
     WHERE CURE_AMOUNT_ID = p_cam_rec.cure_amount_id
       AND OBJECT_VERSION_NUMBER = p_cam_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1628


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CURE_AMOUNTS
     WHERE CURE_AMOUNT_ID = p_cam_rec.cure_amount_id;

Line: 1669


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1678


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1958


  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_cam_rec                      IN cam_rec_type,
    x_cam_rec                      OUT NOCOPY cam_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1967


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

Line: 2059


        IF (x_cam_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cam_rec.program_update_date := l_cam_rec.program_update_date;

Line: 2135


        IF (x_cam_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cam_rec.last_updated_by := l_cam_rec.last_updated_by;

Line: 2139


        IF (x_cam_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cam_rec.last_update_date := l_cam_rec.last_update_date;

Line: 2143


        IF (x_cam_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cam_rec.last_update_login := l_cam_rec.last_update_login;

Line: 2171


        IF (x_cam_rec.SELECTED_ON_REQUEST = OKL_API.G_MISS_CHAR)
        THEN
          x_cam_rec.SELECTED_ON_REQUEST := l_cam_rec.SELECTED_ON_REQUEST;

Line: 2227


    UPDATE OKL_CURE_AMOUNTS
    SET CHR_ID = l_def_cam_rec.chr_id,
        CURE_TYPE = l_def_cam_rec.cure_type,
        CURE_AMOUNT = l_def_cam_rec.cure_amount,
        REPURCHASE_AMOUNT = l_def_cam_rec.repurchase_amount,
        EFFECTIVE_DATE = l_def_cam_rec.effective_date,
        TIMES_CURED = l_def_cam_rec.times_cured,
        PAYMENTS_REMAINING = l_def_cam_rec.payments_remaining,
        ELIGIBLE_CURE_AMOUNT = l_def_cam_rec.eligible_cure_amount,
        OUTSTANDING_AMOUNT = l_def_cam_rec.outstanding_amount,
        PAST_DUE_AMOUNT = l_def_cam_rec.past_due_amount,
        CURES_IN_POSSESSION = l_def_cam_rec.cures_in_possession,
        STATUS = l_def_cam_rec.status,
        OBJECT_VERSION_NUMBER = l_def_cam_rec.object_version_number,
        ORG_ID = l_def_cam_rec.org_id,
        REQUEST_ID = l_def_cam_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_cam_rec.program_application_id,
        PROGRAM_ID = l_def_cam_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_cam_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_cam_rec.attribute_category,
        ATTRIBUTE1 = l_def_cam_rec.attribute1,
        ATTRIBUTE2 = l_def_cam_rec.attribute2,
        ATTRIBUTE3 = l_def_cam_rec.attribute3,
        ATTRIBUTE4 = l_def_cam_rec.attribute4,
        ATTRIBUTE5 = l_def_cam_rec.attribute5,
        ATTRIBUTE6 = l_def_cam_rec.attribute6,
        ATTRIBUTE7 = l_def_cam_rec.attribute7,
        ATTRIBUTE8 = l_def_cam_rec.attribute8,
        ATTRIBUTE9 = l_def_cam_rec.attribute9,
        ATTRIBUTE10 = l_def_cam_rec.attribute10,
        ATTRIBUTE11 = l_def_cam_rec.attribute11,
        ATTRIBUTE12 = l_def_cam_rec.attribute12,
        ATTRIBUTE13 = l_def_cam_rec.attribute13,
        ATTRIBUTE14 = l_def_cam_rec.attribute14,
        ATTRIBUTE15 = l_def_cam_rec.attribute15,
        CREATED_BY = l_def_cam_rec.created_by,
        CREATION_DATE = l_def_cam_rec.creation_date,
        LAST_UPDATED_BY = l_def_cam_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cam_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cam_rec.last_update_login,
        NEGOTIATED_AMOUNT = l_def_cam_rec.NEGOTIATED_AMOUNT,
        RECEIVED_AMOUNT = l_def_cam_rec.RECEIVED_AMOUNT,
        DELINQUENT_AMOUNT = l_def_cam_rec.DELINQUENT_AMOUNT,
        SHORT_FUND_AMOUNT = l_def_cam_rec.SHORT_FUND_AMOUNT,
        CRT_ID = l_def_cam_rec.CRT_ID,
        SHOW_ON_REQUEST = l_def_cam_rec.SHOW_ON_REQUEST,
        SELECTED_ON_REQUEST = l_def_cam_rec.SELECTED_ON_REQUEST,
        QTE_ID = l_def_cam_rec.QTE_ID,
        PROCESS = l_def_cam_rec.PROCESS
    WHERE CURE_AMOUNT_ID = l_def_cam_rec.cure_amount_id;

Line: 2312


  END update_row;

Line: 2316


  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_camv_rec                     IN camv_rec_type,
    x_camv_rec                     OUT NOCOPY camv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2326


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

Line: 2341


      l_camv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2342


      l_camv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2343


      l_camv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2430


        IF (x_camv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_camv_rec.program_update_date := l_db_camv_rec.program_update_date;

Line: 2506


        IF (x_camv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_camv_rec.last_updated_by := l_db_camv_rec.last_updated_by;

Line: 2510


        IF (x_camv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_camv_rec.last_update_date := l_db_camv_rec.last_update_date;

Line: 2514


        IF (x_camv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_camv_rec.last_update_login := l_db_camv_rec.last_update_login;

Line: 2543


        IF (x_camv_rec.SELECTED_ON_REQUEST = OKL_API.G_MISS_CHAR)
        THEN
          x_camv_rec.SELECTED_ON_REQUEST := l_db_camv_rec.SELECTED_ON_REQUEST;

Line: 2638


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cam_rec,
      lx_cam_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_camv_tbl                     IN camv_tbl_type,
    x_camv_tbl                     OUT NOCOPY camv_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_camv_rec                     => p_camv_tbl(i),
            x_camv_rec                     => x_camv_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_camv_tbl                     IN camv_tbl_type,
    x_camv_tbl                     OUT NOCOPY camv_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_camv_tbl                     => p_camv_tbl,
        x_camv_tbl                     => x_camv_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_cam_rec                      IN cam_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_AMOUNTS
     WHERE CURE_AMOUNT_ID = p_cam_rec.cure_amount_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_camv_rec                     IN camv_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_cam_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_camv_tbl                     IN camv_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_camv_rec                     => p_camv_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_camv_tbl                     IN camv_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_camv_tbl                     => p_camv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3153


  END delete_row;