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

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

Line: 102


    SELECT
            TRQ_ID,
            KHR_ID,
            PARAMETER_TYPE_CODE,
            EFFECTIVE_FROM_DATE,
            EFFECTIVE_TO_DATE,
            MINIMUM_RATE,
            MAXIMUM_RATE,
            BASE_RATE,
            INTEREST_INDEX_ID,
            ADDER_RATE,
            DAYS_IN_A_YEAR_CODE,
            DAYS_IN_A_MONTH_CODE,
            PROPOSED_EFFECTIVE_DATE,
            CONVERSION_DATE,
            VARIABLE_RATE_YN,
            PRINCIPAL_BASIS_CODE,
            INTEREST_BASIS_CODE,
            RATE_DELAY_CODE,
            RATE_DELAY_FREQUENCY,
            COMPOUND_FREQUENCY_CODE,
            CALCULATION_FORMULA_NAME,
            CATCHUP_START_DATE,
            CATCHUP_SETTLEMENT_CODE,
            CATCHUP_BASIS_CODE,
            RATE_CHANGE_START_DATE,
            RATE_CHANGE_FREQUENCY_CODE,
            RATE_CHANGE_VALUE,
            CONVERSION_OPTION_CODE,
            NEXT_CONVERSION_DATE,
            CONVERSION_TYPE_CODE,
            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_Convert_Int_Rate_Request_V
     WHERE okl_convert_int_rate_request_v.trq_id = p_trq_id;

Line: 209


              l_citv_rec.last_updated_by,
              l_citv_rec.last_update_date,
              l_citv_rec.last_update_login;

Line: 253


    SELECT
            TRQ_ID,
            KHR_ID,
            PARAMETER_TYPE_CODE,
            EFFECTIVE_FROM_DATE,
            EFFECTIVE_TO_DATE,
            MINIMUM_RATE,
            MAXIMUM_RATE,
            BASE_RATE,
            INTEREST_INDEX_ID,
            ADDER_RATE,
            DAYS_IN_A_YEAR_CODE,
            DAYS_IN_A_MONTH_CODE,
            PROPOSED_EFFECTIVE_DATE,
            CONVERSION_DATE,
            VARIABLE_RATE_YN,
            PRINCIPAL_BASIS_CODE,
            INTEREST_BASIS_CODE,
            RATE_DELAY_CODE,
            RATE_DELAY_FREQUENCY,
            COMPOUND_FREQUENCY_CODE,
            CALCULATION_FORMULA_NAME,
            CATCHUP_START_DATE,
            CATCHUP_SETTLEMENT_CODE,
            CATCHUP_BASIS_CODE,
            RATE_CHANGE_START_DATE,
            RATE_CHANGE_FREQUENCY_CODE,
            RATE_CHANGE_VALUE,
            CONVERSION_OPTION_CODE,
            NEXT_CONVERSION_DATE,
            CONVERSION_TYPE_CODE,
            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_Convert_Int_Rate_Request
     WHERE okl_convert_int_rate_request.trq_id = p_trq_id;

Line: 360


              l_cit_rec.last_updated_by,
              l_cit_rec.last_update_date,
              l_cit_rec.last_update_login;

Line: 545


    IF (l_citv_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
      l_citv_rec.last_updated_by := NULL;

Line: 548


    IF (l_citv_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
      l_citv_rec.last_update_date := NULL;

Line: 551


    IF (l_citv_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
      l_citv_rec.last_update_login := NULL;

Line: 701


    p_to.last_updated_by := p_from.last_updated_by;

Line: 702


    p_to.last_update_date := p_from.last_update_date;

Line: 703


    p_to.last_update_login := p_from.last_update_login;

Line: 757


    p_to.last_updated_by := p_from.last_updated_by;

Line: 758


    p_to.last_update_date := p_from.last_update_date;

Line: 759


    p_to.last_update_login := p_from.last_update_login;

Line: 1005


  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_cit_rec                      IN cit_rec_type,
    x_cit_rec                      OUT NOCOPY cit_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1014


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

Line: 1050


    INSERT INTO OKL_CONVERT_INT_RATE_REQUEST(
      trq_id,
      khr_id,
      parameter_type_code,
      effective_from_date,
      effective_to_date,
      minimum_rate,
      maximum_rate,
      base_rate,
      interest_index_id,
      adder_rate,
      days_in_a_year_code,
      days_in_a_month_code,
      proposed_effective_date,
      conversion_date,
      variable_rate_yn,
      principal_basis_code,
      interest_basis_code,
      rate_delay_code,
      rate_delay_frequency,
      compound_frequency_code,
      calculation_formula_name,
      catchup_start_date,
      catchup_settlement_code,
      catchup_basis_code,
      rate_change_start_date,
      rate_change_frequency_code,
      rate_change_value,
      conversion_option_code,
      next_conversion_date,
      conversion_type_code,
      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_cit_rec.trq_id,
      l_cit_rec.khr_id,
      l_cit_rec.parameter_type_code,
      l_cit_rec.effective_from_date,
      l_cit_rec.effective_to_date,
      l_cit_rec.minimum_rate,
      l_cit_rec.maximum_rate,
      l_cit_rec.base_rate,
      l_cit_rec.interest_index_id,
      l_cit_rec.adder_rate,
      l_cit_rec.days_in_a_year_code,
      l_cit_rec.days_in_a_month_code,
      l_cit_rec.proposed_effective_date,
      l_cit_rec.conversion_date,
      l_cit_rec.variable_rate_yn,
      l_cit_rec.principal_basis_code,
      l_cit_rec.interest_basis_code,
      l_cit_rec.rate_delay_code,
      l_cit_rec.rate_delay_frequency,
      l_cit_rec.compound_frequency_code,
      l_cit_rec.calculation_formula_name,
      l_cit_rec.catchup_start_date,
      l_cit_rec.catchup_settlement_code,
      l_cit_rec.catchup_basis_code,
      l_cit_rec.rate_change_start_date,
      l_cit_rec.rate_change_frequency_code,
      l_cit_rec.rate_change_value,
      l_cit_rec.conversion_option_code,
      l_cit_rec.next_conversion_date,
      l_cit_rec.conversion_type_code,
      l_cit_rec.attribute1,
      l_cit_rec.attribute2,
      l_cit_rec.attribute3,
      l_cit_rec.attribute4,
      l_cit_rec.attribute5,
      l_cit_rec.attribute6,
      l_cit_rec.attribute7,
      l_cit_rec.attribute8,
      l_cit_rec.attribute9,
      l_cit_rec.attribute10,
      l_cit_rec.attribute11,
      l_cit_rec.attribute12,
      l_cit_rec.attribute13,
      l_cit_rec.attribute14,
      l_cit_rec.attribute15,
      l_cit_rec.created_by,
      l_cit_rec.creation_date,
      l_cit_rec.last_updated_by,
      l_cit_rec.last_update_date,
      l_cit_rec.last_update_login);

Line: 1187


  END insert_row;

Line: 1191


  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_citv_rec                     IN citv_rec_type,
    x_citv_rec                     OUT NOCOPY citv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1201


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

Line: 1217


      l_citv_rec.LAST_UPDATE_DATE := l_citv_rec.CREATION_DATE;

Line: 1218


      l_citv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1219


      l_citv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1284


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cit_rec,
      lx_cit_rec
    );

Line: 1333


  END insert_row;

Line: 1337


  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_citv_tbl                     IN citv_tbl_type,
    x_citv_tbl                     OUT NOCOPY citv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1348


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

Line: 1362


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_citv_rec                     => p_citv_tbl(i),
            x_citv_rec                     => x_citv_tbl(i));

Line: 1430


  END insert_row;

Line: 1437


  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_citv_tbl                     IN citv_tbl_type,
    x_citv_tbl                     OUT NOCOPY citv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1447


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

Line: 1454


      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_citv_tbl                     => p_citv_tbl,
        x_citv_tbl                     => x_citv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1496


  END insert_row;

Line: 1514


    SELECT *
      FROM OKL_CONVERT_INT_RATE_REQUEST
     WHERE TRQ_ID = p_cit_rec.trq_id
    FOR UPDATE NOWAIT;

Line: 1550


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1741


      IF (l_lock_var.last_updated_by <> p_cit_rec.last_updated_by) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1745


      IF (l_lock_var.last_update_date <> p_cit_rec.last_update_date) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 1749


      IF (l_lock_var.last_update_login <> p_cit_rec.last_update_login) THEN
        OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

Line: 2031


  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_cit_rec                      IN cit_rec_type,
    x_cit_rec                      OUT NOCOPY cit_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2040


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

Line: 2248


        IF (x_cit_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_cit_rec.last_updated_by := l_cit_rec.last_updated_by;

Line: 2252


        IF (x_cit_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_cit_rec.last_update_date := l_cit_rec.last_update_date;

Line: 2256


        IF (x_cit_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_cit_rec.last_update_login := l_cit_rec.last_update_login;

Line: 2301


    UPDATE OKL_CONVERT_INT_RATE_REQUEST
    SET KHR_ID = l_def_cit_rec.khr_id,
        PARAMETER_TYPE_CODE = l_def_cit_rec.parameter_type_code,
        EFFECTIVE_FROM_DATE = l_def_cit_rec.effective_from_date,
        EFFECTIVE_TO_DATE = l_def_cit_rec.effective_to_date,
        MINIMUM_RATE = l_def_cit_rec.minimum_rate,
        MAXIMUM_RATE = l_def_cit_rec.maximum_rate,
        BASE_RATE = l_def_cit_rec.base_rate,
        INTEREST_INDEX_ID = l_def_cit_rec.interest_index_id,
        ADDER_RATE = l_def_cit_rec.adder_rate,
        DAYS_IN_A_YEAR_CODE = l_def_cit_rec.days_in_a_year_code,
        DAYS_IN_A_MONTH_CODE = l_def_cit_rec.days_in_a_month_code,
        PROPOSED_EFFECTIVE_DATE = l_def_cit_rec.proposed_effective_date,
        CONVERSION_DATE = l_def_cit_rec.conversion_date,
        VARIABLE_RATE_YN = l_def_cit_rec.variable_rate_yn,
        PRINCIPAL_BASIS_CODE = l_def_cit_rec.principal_basis_code,
        INTEREST_BASIS_CODE = l_def_cit_rec.interest_basis_code,
        RATE_DELAY_CODE = l_def_cit_rec.rate_delay_code,
        RATE_DELAY_FREQUENCY = l_def_cit_rec.rate_delay_frequency,
        COMPOUND_FREQUENCY_CODE = l_def_cit_rec.compound_frequency_code,
        CALCULATION_FORMULA_NAME = l_def_cit_rec.calculation_formula_name,
        CATCHUP_START_DATE = l_def_cit_rec.catchup_start_date,
        CATCHUP_SETTLEMENT_CODE = l_def_cit_rec.catchup_settlement_code,
        CATCHUP_BASIS_CODE  = l_def_cit_rec.catchup_basis_code,
        RATE_CHANGE_START_DATE = l_def_cit_rec.rate_change_start_date,
        RATE_CHANGE_FREQUENCY_CODE = l_def_cit_rec.rate_change_frequency_code,
        RATE_CHANGE_VALUE = l_def_cit_rec.rate_change_value,
        CONVERSION_OPTION_CODE = l_def_cit_rec.conversion_option_code,
        NEXT_CONVERSION_DATE  = l_def_cit_rec.next_conversion_date,
        CONVERSION_TYPE_CODE = l_def_cit_rec.conversion_type_code,
        ATTRIBUTE1 = l_def_cit_rec.attribute1,
        ATTRIBUTE2 = l_def_cit_rec.attribute2,
        ATTRIBUTE3 = l_def_cit_rec.attribute3,
        ATTRIBUTE4 = l_def_cit_rec.attribute4,
        ATTRIBUTE5 = l_def_cit_rec.attribute5,
        ATTRIBUTE6 = l_def_cit_rec.attribute6,
        ATTRIBUTE7 = l_def_cit_rec.attribute7,
        ATTRIBUTE8 = l_def_cit_rec.attribute8,
        ATTRIBUTE9 = l_def_cit_rec.attribute9,
        ATTRIBUTE10 = l_def_cit_rec.attribute10,
        ATTRIBUTE11 = l_def_cit_rec.attribute11,
        ATTRIBUTE12 = l_def_cit_rec.attribute12,
        ATTRIBUTE13 = l_def_cit_rec.attribute13,
        ATTRIBUTE14 = l_def_cit_rec.attribute14,
        ATTRIBUTE15 = l_def_cit_rec.attribute15,
        CREATED_BY = l_def_cit_rec.created_by,
        CREATION_DATE = l_def_cit_rec.creation_date,
        LAST_UPDATED_BY = l_def_cit_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_cit_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_cit_rec.last_update_login
    WHERE TRQ_ID = l_def_cit_rec.trq_id;

Line: 2387


  END update_row;

Line: 2391


  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_citv_rec                     IN citv_rec_type,
    x_citv_rec                     OUT NOCOPY citv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2401


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

Line: 2416


      l_citv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2417


      l_citv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2418


      l_citv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2625


        IF (x_citv_rec.last_updated_by = OKC_API.G_MISS_NUM)
        THEN
          x_citv_rec.last_updated_by := l_db_citv_rec.last_updated_by;

Line: 2629


        IF (x_citv_rec.last_update_date = OKC_API.G_MISS_DATE)
        THEN
          x_citv_rec.last_update_date := l_db_citv_rec.last_update_date;

Line: 2633


        IF (x_citv_rec.last_update_login = OKC_API.G_MISS_NUM)
        THEN
          x_citv_rec.last_update_login := l_db_citv_rec.last_update_login;

Line: 2718


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_cit_rec,
      lx_cit_rec
    );

Line: 2766


  END update_row;

Line: 2770


  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_citv_tbl                     IN citv_tbl_type,
    x_citv_tbl                     OUT NOCOPY citv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2781


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

Line: 2795


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_citv_rec                     => p_citv_tbl(i),
            x_citv_rec                     => x_citv_tbl(i));

Line: 2863


  END update_row;

Line: 2870


  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_citv_tbl                     IN citv_tbl_type,
    x_citv_tbl                     OUT NOCOPY citv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2880


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

Line: 2887


      update_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKC_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_citv_tbl                     => p_citv_tbl,
        x_citv_tbl                     => x_citv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2929


  END update_row;

Line: 2937


  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_cit_rec                      IN cit_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2945


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

Line: 2960


    DELETE FROM OKL_CONVERT_INT_RATE_REQUEST
     WHERE TRQ_ID = p_cit_rec.trq_id;

Line: 2996


  END delete_row;

Line: 3000


  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_citv_rec                     IN citv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3009


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

Line: 3033


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

Line: 3078


  END delete_row;

Line: 3082


  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_citv_tbl                     IN citv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3092


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

Line: 3106


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKC_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_citv_rec                     => p_citv_tbl(i));

Line: 3173


  END delete_row;

Line: 3178


  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_citv_tbl                     IN citv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3187


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

Line: 3194


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

Line: 3235


  END delete_row;