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

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

Line: 101


    SELECT
            ID,
            KHR_ID,
            KLE_ID,
            ACTUAL_PRINCIPAL_BALANCE_AMT,
            ACTUAL_PRINCIPAL_BALANCE_DATE,
            INTEREST_AMT,
            INTEREST_CALC_DATE,
            INTEREST_ACCRUED_AMT,
            INTEREST_ACCRUED_DATE,
            INTEREST_BILLED_AMT,
            INTEREST_BILLED_DATE,
            INTEREST_RECEIVED_AMT,
            INTEREST_RECEIVED_DATE,
            TERMINATION_VALUE_AMT,
            TERMINATION_DATE,
            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_CONTRACT_BALANCES
     WHERE OKL_CONTRACT_BALANCES.id = p_id;

Line: 173


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

Line: 236


    SELECT
            ID,
            KHR_ID,
            KLE_ID,
            ACTUAL_PRINCIPAL_BALANCE_AMT,
            ACTUAL_PRINCIPAL_BALANCE_DATE,
            INTEREST_AMT,
            INTEREST_CALC_DATE,
            INTEREST_ACCRUED_AMT,
            INTEREST_ACCRUED_DATE,
            INTEREST_BILLED_AMT,
            INTEREST_BILLED_DATE,
            INTEREST_RECEIVED_AMT,
            INTEREST_RECEIVED_DATE,
            TERMINATION_VALUE_AMT,
            TERMINATION_DATE,
            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_Contract_Balances
     WHERE okl_contract_balances.id = p_id;

Line: 308


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

Line: 431


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

Line: 488


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

Line: 491


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

Line: 494


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

Line: 537


      SELECT id
        FROM OKL_K_HEADERS
       WHERE id = p_khr_id;

Line: 684


    p_to.program_update_date := p_from.program_update_date;

Line: 703


    p_to.last_updated_by := p_from.last_updated_by;

Line: 704


    p_to.last_update_date := p_from.last_update_date;

Line: 705


    p_to.last_update_login := p_from.last_update_login;

Line: 732


    p_to.program_update_date := p_from.program_update_date;

Line: 751


    p_to.last_updated_by := p_from.last_updated_by;

Line: 752


    p_to.last_update_date := p_from.last_update_date;

Line: 753


    p_to.last_update_login := p_from.last_update_login;

Line: 999


  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_cbl_rec                      IN cbl_rec_type,
    x_cbl_rec                      OUT NOCOPY cbl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1008


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

Line: 1044


    INSERT INTO OKL_CONTRACT_BALANCES(
      id,
      khr_id,
      kle_id,
      actual_principal_balance_amt,
      actual_principal_balance_date,
      interest_amt,
      interest_calc_date,
      interest_accrued_amt,
      interest_accrued_date,
      interest_billed_amt,
      interest_billed_date,
      interest_received_amt,
      interest_received_date,
      termination_value_amt,
      termination_date,
      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_cbl_rec.id,
      l_cbl_rec.khr_id,
      l_cbl_rec.kle_id,
      l_cbl_rec.actual_principal_balance_amt,
      l_cbl_rec.actual_principal_balance_date,
      l_cbl_rec.interest_amt,
      l_cbl_rec.interest_calc_date,
      l_cbl_rec.interest_accrued_amt,
      l_cbl_rec.interest_accrued_date,
      l_cbl_rec.interest_billed_amt,
      l_cbl_rec.interest_billed_date,
      l_cbl_rec.interest_received_amt,
      l_cbl_rec.interest_received_date,
      l_cbl_rec.termination_value_amt,
      l_cbl_rec.termination_date,
      l_cbl_rec.object_version_number,
      l_cbl_rec.org_id,
      l_cbl_rec.request_id,
      l_cbl_rec.program_application_id,
      l_cbl_rec.program_id,
      l_cbl_rec.program_update_date,
      l_cbl_rec.attribute_category,
      l_cbl_rec.attribute1,
      l_cbl_rec.attribute2,
      l_cbl_rec.attribute3,
      l_cbl_rec.attribute4,
      l_cbl_rec.attribute5,
      l_cbl_rec.attribute6,
      l_cbl_rec.attribute7,
      l_cbl_rec.attribute8,
      l_cbl_rec.attribute9,
      l_cbl_rec.attribute10,
      l_cbl_rec.attribute11,
      l_cbl_rec.attribute12,
      l_cbl_rec.attribute13,
      l_cbl_rec.attribute14,
      l_cbl_rec.attribute15,
      l_cbl_rec.created_by,
      l_cbl_rec.creation_date,
      l_cbl_rec.last_updated_by,
      l_cbl_rec.last_update_date,
      l_cbl_rec.last_update_login);

Line: 1165


  END insert_row;

Line: 1169


  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_cblv_rec                     IN cblv_rec_type,
    x_cblv_rec                     OUT NOCOPY cblv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1179


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

Line: 1195


      l_cblv_rec.LAST_UPDATE_DATE := l_cblv_rec.CREATION_DATE;

Line: 1196


      l_cblv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1197


      l_cblv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1213


        SELECT
               DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
               DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_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_cblv_rec.request_id,
               x_cblv_rec.program_application_id,
               x_cblv_rec.program_id,
               x_cblv_rec.program_update_date
        FROM dual;

Line: 1279


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cbl_rec,
      lx_cbl_rec
    );

Line: 1328


  END insert_row;

Line: 1332


  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_cblv_tbl                     IN cblv_tbl_type,
    x_cblv_tbl                     OUT NOCOPY cblv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1343


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

Line: 1357


          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_cblv_rec                     => p_cblv_tbl(i),
            x_cblv_rec                     => x_cblv_tbl(i));

Line: 1425


  END insert_row;

Line: 1430


  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_cblv_tbl                     IN cblv_tbl_type,
    x_cblv_tbl                     OUT NOCOPY cblv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1440


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

Line: 1447


      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_cblv_tbl                     => p_cblv_tbl,
        x_cblv_tbl                     => x_cblv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1489


  END insert_row;

Line: 1507


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CONTRACT_BALANCES
     WHERE ID = p_cbl_rec.id
       AND OBJECT_VERSION_NUMBER = p_cbl_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1514


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_CONTRACT_BALANCES
     WHERE ID = p_cbl_rec.id;

Line: 1555


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1564


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1844


  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_cbl_rec                      IN cbl_rec_type,
    x_cbl_rec                      OUT NOCOPY cbl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1853


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

Line: 1953


        IF (x_cbl_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cbl_rec.program_update_date := l_cbl_rec.program_update_date;

Line: 2029


        IF (x_cbl_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cbl_rec.last_updated_by := l_cbl_rec.last_updated_by;

Line: 2033


        IF (x_cbl_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cbl_rec.last_update_date := l_cbl_rec.last_update_date;

Line: 2037


        IF (x_cbl_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cbl_rec.last_update_login := l_cbl_rec.last_update_login;

Line: 2083


    UPDATE OKL_CONTRACT_BALANCES
    SET KHR_ID = l_def_cbl_rec.khr_id,
        KLE_ID = l_def_cbl_rec.kle_id,
        ACTUAL_PRINCIPAL_BALANCE_AMT = l_def_cbl_rec.actual_principal_balance_amt,
        ACTUAL_PRINCIPAL_BALANCE_DATE = l_def_cbl_rec.actual_principal_balance_date,
        INTEREST_AMT = l_def_cbl_rec.interest_amt,
        INTEREST_CALC_DATE = l_def_cbl_rec.interest_calc_date,
        INTEREST_ACCRUED_AMT = l_def_cbl_rec.interest_accrued_amt,
        INTEREST_ACCRUED_DATE = l_def_cbl_rec.interest_accrued_date,
        INTEREST_BILLED_AMT = l_def_cbl_rec.interest_billed_amt,
        INTEREST_BILLED_DATE = l_def_cbl_rec.interest_billed_date,
        INTEREST_RECEIVED_AMT = l_def_cbl_rec.interest_received_amt,
        INTEREST_RECEIVED_DATE = l_def_cbl_rec.interest_received_date,
        TERMINATION_VALUE_AMT = l_def_cbl_rec.termination_value_amt,
        TERMINATION_DATE = l_def_cbl_rec.termination_date,
        OBJECT_VERSION_NUMBER = l_def_cbl_rec.object_version_number,
        ORG_ID = l_def_cbl_rec.org_id,
        REQUEST_ID = l_def_cbl_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_cbl_rec.program_application_id,
        PROGRAM_ID = l_def_cbl_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_cbl_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_cbl_rec.attribute_category,
        ATTRIBUTE1 = l_def_cbl_rec.attribute1,
        ATTRIBUTE2 = l_def_cbl_rec.attribute2,
        ATTRIBUTE3 = l_def_cbl_rec.attribute3,
        ATTRIBUTE4 = l_def_cbl_rec.attribute4,
        ATTRIBUTE5 = l_def_cbl_rec.attribute5,
        ATTRIBUTE6 = l_def_cbl_rec.attribute6,
        ATTRIBUTE7 = l_def_cbl_rec.attribute7,
        ATTRIBUTE8 = l_def_cbl_rec.attribute8,
        ATTRIBUTE9 = l_def_cbl_rec.attribute9,
        ATTRIBUTE10 = l_def_cbl_rec.attribute10,
        ATTRIBUTE11 = l_def_cbl_rec.attribute11,
        ATTRIBUTE12 = l_def_cbl_rec.attribute12,
        ATTRIBUTE13 = l_def_cbl_rec.attribute13,
        ATTRIBUTE14 = l_def_cbl_rec.attribute14,
        ATTRIBUTE15 = l_def_cbl_rec.attribute15,
        CREATED_BY = l_def_cbl_rec.created_by,
        CREATION_DATE = l_def_cbl_rec.creation_date,
        LAST_UPDATED_BY = l_def_cbl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cbl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cbl_rec.last_update_login
    WHERE ID = l_def_cbl_rec.id;

Line: 2161


  END update_row;

Line: 2165


  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_cblv_rec                     IN cblv_rec_type,
    x_cblv_rec                     OUT NOCOPY cblv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2175


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

Line: 2190


      l_cblv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2191


      l_cblv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2192


      l_cblv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2287


        IF (x_cblv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cblv_rec.program_update_date := l_db_cblv_rec.program_update_date;

Line: 2363


        IF (x_cblv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_cblv_rec.last_updated_by := l_db_cblv_rec.last_updated_by;

Line: 2367


        IF (x_cblv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_cblv_rec.last_update_date := l_db_cblv_rec.last_update_date;

Line: 2371


        IF (x_cblv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_cblv_rec.last_update_login := l_db_cblv_rec.last_update_login;

Line: 2397


       SELECT
               NVL(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
               x_cblv_rec.request_id),
               NVL(DECODE(Fnd_Global.PROG_APPL_ID,   -1,NULL,Fnd_Global.PROG_APPL_ID),
               x_cblv_rec.program_application_id),
               NVL(DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),
               x_cblv_rec.program_id),
               DECODE(DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,SYSDATE),
               NULL,x_cblv_rec.program_update_date,SYSDATE)
	INTO
               x_cblv_rec.request_id,
               x_cblv_rec.program_application_id,
               x_cblv_rec.program_id,
               x_cblv_rec.program_update_date
        FROM dual;

Line: 2487


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cbl_rec,
      lx_cbl_rec
    );

Line: 2535


  END update_row;

Line: 2539


  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_cblv_tbl                     IN cblv_tbl_type,
    x_cblv_tbl                     OUT NOCOPY cblv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2550


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

Line: 2564


          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_cblv_rec                     => p_cblv_tbl(i),
            x_cblv_rec                     => x_cblv_tbl(i));

Line: 2632


  END update_row;

Line: 2637


  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_cblv_tbl                     IN cblv_tbl_type,
    x_cblv_tbl                     OUT NOCOPY cblv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2647


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

Line: 2654


      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_cblv_tbl                     => p_cblv_tbl,
        x_cblv_tbl                     => x_cblv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2696


  END update_row;

Line: 2704


  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_cbl_rec                      IN cbl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2712


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

Line: 2727


    DELETE FROM OKL_CONTRACT_BALANCES
     WHERE ID = p_cbl_rec.id;

Line: 2763


  END delete_row;

Line: 2767


  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_cblv_rec                     IN cblv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2776


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

Line: 2800


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

Line: 2845


  END delete_row;

Line: 2849


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2859


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

Line: 2873


          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_cblv_rec                     => p_cblv_tbl(i));

Line: 2940


  END delete_row;

Line: 2945


  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_cblv_tbl                     IN cblv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2954


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

Line: 2961


      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_cblv_tbl                     => p_cblv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 3002


  END delete_row;