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

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

Line: 118


    SELECT
            ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            DNZ_KHR_ID,
            REQUEST_TYPE_CODE,
            APPLY_TO_CODE,
            START_DATE,
            END_DATE,
            TERM_DURATION,
            AMOUNT,
            CURRENCY_CODE,
            SUBSIDY_YN,
            CASH_APPLIED_YN,
            OBJECT_VERSION_NUMBER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            MINIMUM_RATE,
            MAXIMUM_RATE,
            TOLERANCE,
            ADJUSTMENT_FREQUENCY_CODE,
            BASE_RATE,
            INDEX_NAME,
            VARIABLE_METHOD_CODE,
            ADDER,
            DAYS_IN_YEAR,
            DAYS_IN_MONTH,
            INTEREST_METHOD_CODE,
            INTEREST_START_DATE,
            METHOD_OF_CALCULATION_CODE,
            REQUEST_NUMBER,
            DATE_OF_CONVERSION,
            VARIABLE_RATE_YN,
            REQUEST_STATUS_CODE,
            YIELD,
            RESIDUAL,
            COMMENTS,
            PAYMENT_FREQUENCY_CODE,
            RESTRUCTURE_DATE,
            PAST_DUE_YN,
            REQUEST_REASON_CODE,
            PARENT_KHR_ID,
            YIELD_TYPE,
            PAYMENT_AMOUNT,
            PAYMENT_DATE,
	    PAYDOWN_TYPE,
	    CURRENCY_CONVERSION_TYPE,
	    CURRENCY_CONVERSION_RATE,
	    CURRENCY_CONVERSION_DATE,
	    LSM_ID,
	    RECEIPT_ID,
	    TCN_ID,
            TRY_ID,
	    CUR_PRINCIPAL_BALANCE, --BUG#5083582
	    CUR_ACCUM_INTEREST, --BUG#5083582
	    LEGAL_ENTITY_ID
      FROM OKL_TRX_REQUESTS
     WHERE OKL_TRX_REQUESTS.id = p_id;

Line: 243


              l_trqv_rec.program_update_date,
              l_trqv_rec.created_by,
              l_trqv_rec.creation_date,
              l_trqv_rec.last_updated_by,
              l_trqv_rec.last_update_date,
              l_trqv_rec.last_update_login,
              l_trqv_rec.minimum_rate,
              l_trqv_rec.maximum_rate,
              l_trqv_rec.tolerance,
              l_trqv_rec.adjustment_frequency_code,
              l_trqv_rec.base_rate,
              l_trqv_rec.index_name,
              l_trqv_rec.variable_method_code,
              l_trqv_rec.adder,
              l_trqv_rec.days_in_year,
              l_trqv_rec.days_in_month,
              l_trqv_rec.interest_method_code,
              l_trqv_rec.interest_start_date,
              l_trqv_rec.method_of_calculation_code,
              l_trqv_rec.request_number,
              l_trqv_rec.date_of_conversion,
              l_trqv_rec.variable_rate_yn,
              l_trqv_rec.request_status_code,
              l_trqv_rec.yield,
              l_trqv_rec.residual,
              l_trqv_rec.comments,
              l_trqv_rec.payment_frequency_code,
              l_trqv_rec.restructure_date,
              l_trqv_rec.past_due_yn,
              l_trqv_rec.request_reason_code,
              l_trqv_rec.parent_khr_id,
              l_trqv_rec.yield_type,
              l_trqv_rec.payment_amount,
              l_trqv_rec.payment_date,
              l_trqv_rec.paydown_type,
              l_trqv_rec.currency_conversion_type,
              l_trqv_rec.currency_conversion_rate,
              l_trqv_rec.currency_conversion_date,
              l_trqv_rec.lsm_id,
              l_trqv_rec.receipt_id,
              l_trqv_rec.tcn_id,
              l_trqv_rec.try_id,
	      l_trqv_rec.CUR_PRINCIPAL_BALANCE, ----BUG#5083582
	      l_trqv_rec.CUR_ACCUM_INTEREST, --BUG#5083582
              l_trqv_rec.legal_entity_id;

Line: 329


    SELECT
            ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            DNZ_KHR_ID,
            REQUEST_TYPE_CODE,
            APPLY_TO_CODE,
            START_DATE,
            END_DATE,
            TERM_DURATION,
            AMOUNT,
            CURRENCY_CODE,
            SUBSIDY_YN,
            CASH_APPLIED_YN,
            OBJECT_VERSION_NUMBER,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            MINIMUM_RATE,
            MAXIMUM_RATE,
            TOLERANCE,
            ADJUSTMENT_FREQUENCY_CODE,
            BASE_RATE,
            INDEX_NAME,
            VARIABLE_METHOD_CODE,
            ADDER,
            DAYS_IN_YEAR,
            DAYS_IN_MONTH,
            INTEREST_METHOD_CODE,
            INTEREST_START_DATE,
            METHOD_OF_CALCULATION_CODE,
            REQUEST_NUMBER,
            DATE_OF_CONVERSION,
            VARIABLE_RATE_YN,
            REQUEST_STATUS_CODE,
            YIELD,
            RESIDUAL,
            COMMENTS,
            PAYMENT_FREQUENCY_CODE,
            RESTRUCTURE_DATE,
            PAST_DUE_YN,
            REQUEST_REASON_CODE,
            PARENT_KHR_ID,
            YIELD_TYPE,
            PAYMENT_AMOUNT,
            PAYMENT_DATE,
	    PAYDOWN_TYPE,
            CURRENCY_CONVERSION_TYPE,
            CURRENCY_CONVERSION_RATE,
            CURRENCY_CONVERSION_DATE,
	    LSM_ID,
            RECEIPT_ID,
            TCN_ID,
            TRY_ID,
	    LEGAL_ENTITY_ID
      FROM Okl_Trx_Requests
     WHERE okl_trx_requests.id  = p_id;

Line: 452


              l_trq_rec.program_update_date,
              l_trq_rec.created_by,
              l_trq_rec.creation_date,
              l_trq_rec.last_updated_by,
              l_trq_rec.last_update_date,
              l_trq_rec.last_update_login,
              l_trq_rec.minimum_rate,
              l_trq_rec.maximum_rate,
              l_trq_rec.tolerance,
              l_trq_rec.adjustment_frequency_code,
              l_trq_rec.base_rate,
              l_trq_rec.index_name,
              l_trq_rec.variable_method_code,
              l_trq_rec.adder,
              l_trq_rec.days_in_year,
              l_trq_rec.days_in_month,
              l_trq_rec.interest_method_code,
              l_trq_rec.interest_start_date,
              l_trq_rec.method_of_calculation_code,
              l_trq_rec.request_number,
              l_trq_rec.date_of_conversion,
              l_trq_rec.variable_rate_yn,
              l_trq_rec.request_status_code,
              l_trq_rec.yield,
              l_trq_rec.residual,
              l_trq_rec.comments,
              l_trq_rec.payment_frequency_code,
              l_trq_rec.restructure_date,
              l_trq_rec.past_due_yn,
              l_trq_rec.request_reason_code,
              l_trq_rec.parent_khr_id,
              l_trq_rec.yield_type,
              l_trq_rec.payment_amount,
              l_trq_rec.payment_date,
              l_trq_rec.paydown_type,
              l_trq_rec.currency_conversion_type,
              l_trq_rec.currency_conversion_rate,
              l_trq_rec.currency_conversion_date,
              l_trq_rec.lsm_id,
              l_trq_rec.receipt_id,
              l_trq_rec.tcn_id,
              l_trq_rec.try_id,
	      l_trq_rec.legal_entity_id;

Line: 641


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

Line: 650


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

Line: 653


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

Line: 656


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

Line: 1284


    SELECT count(*)
    FROM OKL_TRX_REQUESTS
    WHERE id = p_id;

Line: 1588


    p_to.program_update_date := p_from.program_update_date;

Line: 1591


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1592


    p_to.last_update_date := p_from.last_update_date;

Line: 1593


    p_to.last_update_login := p_from.last_update_login;

Line: 1674


    p_to.program_update_date := p_from.program_update_date;

Line: 1677


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1678


    p_to.last_update_date := p_from.last_update_date;

Line: 1679


    p_to.last_update_login := p_from.last_update_login;

Line: 1964


  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_trq_rec                      IN trq_rec_type,
    x_trq_rec                      OUT NOCOPY trq_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1973


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

Line: 2009


    INSERT INTO OKL_TRX_REQUESTS(
      id,
      object1_id1,
      object1_id2,
      jtot_object1_code,
      dnz_khr_id,
      request_type_code,
      apply_to_code,
      start_date,
      end_date,
      term_duration,
      AMOUNT,
      currency_code,
      subsidy_yn,
      cash_applied_yn,
      object_version_number,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15,
      org_id,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      minimum_rate,
      maximum_rate,
      tolerance,
      adjustment_frequency_code,
      base_rate,
      index_name,
      variable_method_code,
      adder,
      days_in_year,
      days_in_month,
      interest_method_code,
      interest_start_date,
      method_of_calculation_code,
      request_number,
      date_of_conversion,
      variable_rate_yn,
      request_status_code,
      yield,
      residual,
      comments,
      payment_frequency_code,
      restructure_date,
      past_due_yn,
      request_reason_code,
      parent_khr_id,
      yield_type,
      payment_amount,
      payment_date,
      paydown_type,
      currency_conversion_type,
      currency_conversion_rate,
      currency_conversion_date,
      lsm_id,
      receipt_id,
      tcn_id,
      try_id,
      CUR_PRINCIPAL_BALANCE, --BUG#5083582
      CUR_ACCUM_INTEREST, --BUG#5083582
      legal_entity_id )
    VALUES (
      l_trq_rec.id,
      l_trq_rec.object1_id1,
      l_trq_rec.object1_id2,
      l_trq_rec.jtot_object1_code,
      l_trq_rec.dnz_khr_id,
      l_trq_rec.request_type_code,
      l_trq_rec.apply_to_code,
      l_trq_rec.start_date,
      l_trq_rec.end_date,
      l_trq_rec.term_duration,
      l_trq_rec.AMOUNT,
      l_trq_rec.currency_code,
      l_trq_rec.subsidy_yn,
      l_trq_rec.cash_applied_yn,
      l_trq_rec.object_version_number,
      l_trq_rec.attribute_category,
      l_trq_rec.attribute1,
      l_trq_rec.attribute2,
      l_trq_rec.attribute3,
      l_trq_rec.attribute4,
      l_trq_rec.attribute5,
      l_trq_rec.attribute6,
      l_trq_rec.attribute7,
      l_trq_rec.attribute8,
      l_trq_rec.attribute9,
      l_trq_rec.attribute10,
      l_trq_rec.attribute11,
      l_trq_rec.attribute12,
      l_trq_rec.attribute13,
      l_trq_rec.attribute14,
      l_trq_rec.attribute15,
      l_trq_rec.org_id,
      l_trq_rec.request_id,
      l_trq_rec.program_application_id,
      l_trq_rec.program_id,
      l_trq_rec.program_update_date,
      l_trq_rec.created_by,
      l_trq_rec.creation_date,
      l_trq_rec.last_updated_by,
      l_trq_rec.last_update_date,
      l_trq_rec.last_update_login,
      l_trq_rec.minimum_rate,
      l_trq_rec.maximum_rate,
      l_trq_rec.tolerance,
      l_trq_rec.adjustment_frequency_code,
      l_trq_rec.base_rate,
      l_trq_rec.index_name,
      l_trq_rec.variable_method_code,
      l_trq_rec.adder,
      l_trq_rec.days_in_year,
      l_trq_rec.days_in_month,
      l_trq_rec.interest_method_code,
      l_trq_rec.interest_start_date,
      l_trq_rec.method_of_calculation_code,
      l_trq_rec.request_number,
      l_trq_rec.date_of_conversion,
      l_trq_rec.variable_rate_yn,
      l_trq_rec.request_status_code,
      l_trq_rec.yield,
      l_trq_rec.residual,
      l_trq_rec.comments,
      l_trq_rec.payment_frequency_code,
      l_trq_rec.restructure_date,
      l_trq_rec.past_due_yn,
      l_trq_rec.request_reason_code,
      l_trq_rec.parent_khr_id,
      l_trq_rec.yield_type,
      l_trq_rec.payment_amount,
      l_trq_rec.payment_date,
      l_trq_rec.paydown_type,
      l_trq_rec.currency_conversion_type,
      l_trq_rec.currency_conversion_rate,
      l_trq_rec.currency_conversion_date,
      l_trq_rec.lsm_id,
      l_trq_rec.receipt_id,
      l_trq_rec.tcn_id,
      l_trq_rec.try_id,
      l_trq_rec.CUR_PRINCIPAL_BALANCE, --BUG#5083582
      l_trq_rec.CUR_ACCUM_INTEREST, --BUG#5083582
      l_trq_rec.legal_entity_id );

Line: 2206


  END insert_row;

Line: 2210


  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_trqv_rec                     IN trqv_rec_type,
    x_trqv_rec                     OUT NOCOPY trqv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2220


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

Line: 2236


      l_trqv_rec.LAST_UPDATE_DATE := l_trqv_rec.CREATION_DATE;

Line: 2237


      l_trqv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2238


      l_trqv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2252


      select OKL_TRQ_SEQ.nextval
      from dual;

Line: 2324


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_trq_rec,
      lx_trq_rec
    );

Line: 2373


  END insert_row;

Line: 2377


  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_trqv_tbl                     IN trqv_tbl_type,
    x_trqv_tbl                     OUT NOCOPY trqv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2388


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

Line: 2402


          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_trqv_rec                     => p_trqv_tbl(i),
            x_trqv_rec                     => x_trqv_tbl(i));

Line: 2470


  END insert_row;

Line: 2475


  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_trqv_tbl                     IN trqv_tbl_type,
    x_trqv_tbl                     OUT NOCOPY trqv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2485


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

Line: 2492


      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_trqv_tbl                     => p_trqv_tbl,
        x_trqv_tbl                     => x_trqv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2534


  END insert_row;

Line: 2552


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_REQUESTS
     WHERE ID = p_trq_rec.id
       AND OBJECT_VERSION_NUMBER = p_trq_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2559


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TRX_REQUESTS
     WHERE ID = p_trq_rec.id;

Line: 2600


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2609


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2889


  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_trq_rec                      IN trq_rec_type,
    x_trq_rec                      OUT NOCOPY trq_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2898


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

Line: 3058


        IF (x_trq_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_trq_rec.program_update_date := l_trq_rec.program_update_date;

Line: 3070


        IF (x_trq_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_trq_rec.last_updated_by := l_trq_rec.last_updated_by;

Line: 3074


        IF (x_trq_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_trq_rec.last_update_date := l_trq_rec.last_update_date;

Line: 3078


        IF (x_trq_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_trq_rec.last_update_login := l_trq_rec.last_update_login;

Line: 3282


    UPDATE OKL_TRX_REQUESTS
    SET OBJECT1_ID1 = l_def_trq_rec.object1_id1,
        OBJECT1_ID2 = l_def_trq_rec.object1_id2,
        JTOT_OBJECT1_CODE = l_def_trq_rec.jtot_object1_code,
        DNZ_KHR_ID = l_def_trq_rec.dnz_khr_id,
        REQUEST_TYPE_CODE = l_def_trq_rec.request_type_code,
        APPLY_TO_CODE = l_def_trq_rec.apply_to_code,
        START_DATE = l_def_trq_rec.start_date,
        END_DATE = l_def_trq_rec.end_date,
        TERM_DURATION = l_def_trq_rec.term_duration,
        AMOUNT = l_def_trq_rec.AMOUNT,
        CURRENCY_CODE = l_def_trq_rec.currency_code,
        SUBSIDY_YN = l_def_trq_rec.subsidy_yn,
        CASH_APPLIED_YN = l_def_trq_rec.cash_applied_yn,
        OBJECT_VERSION_NUMBER = l_def_trq_rec.object_version_number,
        ATTRIBUTE_CATEGORY = l_def_trq_rec.attribute_category,
        ATTRIBUTE1 = l_def_trq_rec.attribute1,
        ATTRIBUTE2 = l_def_trq_rec.attribute2,
        ATTRIBUTE3 = l_def_trq_rec.attribute3,
        ATTRIBUTE4 = l_def_trq_rec.attribute4,
        ATTRIBUTE5 = l_def_trq_rec.attribute5,
        ATTRIBUTE6 = l_def_trq_rec.attribute6,
        ATTRIBUTE7 = l_def_trq_rec.attribute7,
        ATTRIBUTE8 = l_def_trq_rec.attribute8,
        ATTRIBUTE9 = l_def_trq_rec.attribute9,
        ATTRIBUTE10 = l_def_trq_rec.attribute10,
        ATTRIBUTE11 = l_def_trq_rec.attribute11,
        ATTRIBUTE12 = l_def_trq_rec.attribute12,
        ATTRIBUTE13 = l_def_trq_rec.attribute13,
        ATTRIBUTE14 = l_def_trq_rec.attribute14,
        ATTRIBUTE15 = l_def_trq_rec.attribute15,
        ORG_ID = l_def_trq_rec.org_id,
        REQUEST_ID = l_def_trq_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_trq_rec.program_application_id,
        PROGRAM_ID = l_def_trq_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_trq_rec.program_update_date,
        CREATED_BY = l_def_trq_rec.created_by,
        CREATION_DATE = l_def_trq_rec.creation_date,
        LAST_UPDATED_BY = l_def_trq_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_trq_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_trq_rec.last_update_login,
        MINIMUM_RATE = l_def_trq_rec.minimum_rate,
        MAXIMUM_RATE = l_def_trq_rec.maximum_rate,
        TOLERANCE = l_def_trq_rec.tolerance,
        ADJUSTMENT_FREQUENCY_CODE = l_def_trq_rec.adjustment_frequency_code,
        BASE_RATE = l_def_trq_rec.base_rate,
        INDEX_NAME = l_def_trq_rec.index_name,
        VARIABLE_METHOD_CODE = l_def_trq_rec.variable_method_code,
        ADDER = l_def_trq_rec.adder,
        DAYS_IN_YEAR = l_def_trq_rec.days_in_year,
        DAYS_IN_MONTH = l_def_trq_rec.days_in_month,
        INTEREST_METHOD_CODE = l_def_trq_rec.interest_method_code,
        INTEREST_START_DATE = l_def_trq_rec.interest_start_date,
        METHOD_OF_CALCULATION_CODE = l_def_trq_rec.method_of_calculation_code,
        REQUEST_NUMBER = l_def_trq_rec.request_number,
        DATE_OF_CONVERSION = l_def_trq_rec.date_of_conversion,
        VARIABLE_RATE_YN = l_def_trq_rec.variable_rate_yn,
        REQUEST_STATUS_CODE = l_def_trq_rec.request_status_code,
        YIELD = l_def_trq_rec.yield,
        RESIDUAL = l_def_trq_rec.residual,
        COMMENTS = l_def_trq_rec.comments,
        PAYMENT_FREQUENCY_CODE = l_def_trq_rec.payment_frequency_code,
        RESTRUCTURE_DATE = l_def_trq_rec.restructure_date,
        PAST_DUE_YN = l_def_trq_rec.past_due_yn,
        REQUEST_REASON_CODE = l_def_trq_rec.request_reason_code,
        PARENT_KHR_ID = l_def_trq_rec.parent_khr_id,
        YIELD_TYPE = l_def_trq_rec.yield_type,
        PAYMENT_AMOUNT = l_def_trq_rec.payment_amount,
        PAYMENT_DATE = l_def_trq_rec.payment_date,
        PAYDOWN_TYPE = l_def_trq_rec.paydown_type,
        CURRENCY_CONVERSION_TYPE = l_def_trq_rec.currency_conversion_type,
        CURRENCY_CONVERSION_RATE = l_def_trq_rec.currency_conversion_rate,
        CURRENCY_CONVERSION_DATE = l_def_trq_rec.currency_conversion_date,
        LSM_ID = l_def_trq_rec.lsm_id,
        RECEIPT_ID = l_def_trq_rec.receipt_id,
        TCN_ID = l_def_trq_rec.tcn_id,
        TRY_ID = l_def_trq_rec.try_id,
	LEGAL_ENTITY_ID = l_def_trq_rec.legal_entity_id
    WHERE ID = l_def_trq_rec.id;

Line: 3396


  END update_row;

Line: 3400


  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_trqv_rec                     IN trqv_rec_type,
    x_trqv_rec                     OUT NOCOPY trqv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3410


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

Line: 3425


      l_trqv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3426


      l_trqv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3427


      l_trqv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3582


        IF (x_trqv_rec.program_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_trqv_rec.program_update_date := l_db_trqv_rec.program_update_date;

Line: 3594


        IF (x_trqv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_trqv_rec.last_updated_by := l_db_trqv_rec.last_updated_by;

Line: 3598


        IF (x_trqv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_trqv_rec.last_update_date := l_db_trqv_rec.last_update_date;

Line: 3602


        IF (x_trqv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_trqv_rec.last_update_login := l_db_trqv_rec.last_update_login;

Line: 3835


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_trq_rec,
      lx_trq_rec
    );

Line: 3883


  END update_row;

Line: 3887


  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_trqv_tbl                     IN trqv_tbl_type,
    x_trqv_tbl                     OUT NOCOPY trqv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3898


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

Line: 3912


          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_trqv_rec                     => p_trqv_tbl(i),
            x_trqv_rec                     => x_trqv_tbl(i));

Line: 3980


  END update_row;

Line: 3985


  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_trqv_tbl                     IN trqv_tbl_type,
    x_trqv_tbl                     OUT NOCOPY trqv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3995


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

Line: 4002


      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_trqv_tbl                     => p_trqv_tbl,
        x_trqv_tbl                     => x_trqv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 4044


  END update_row;

Line: 4052


  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_trq_rec                      IN trq_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4060


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

Line: 4075


    DELETE FROM OKL_TRX_REQUESTS
     WHERE ID = p_trq_rec.id;

Line: 4111


  END delete_row;

Line: 4115


  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_trqv_rec                     IN trqv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4124


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

Line: 4148


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

Line: 4193


  END delete_row;

Line: 4197


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4207


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

Line: 4221


          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_trqv_rec                     => p_trqv_tbl(i));

Line: 4288


  END delete_row;

Line: 4293


  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_trqv_tbl                     IN trqv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4302


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

Line: 4309


      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_trqv_tbl                     => p_trqv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 4350


  END delete_row;