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.LNS_TERMS_PUB SQL Statements

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

Line: 18


PROCEDURE do_update_term (p_loan_term_rec          IN OUT NOCOPY LOAN_TERM_REC_TYPE
                         ,p_object_version_number  IN OUT NOCOPY NUMBER
                         ,x_return_status          IN OUT NOCOPY VARCHAR2);

Line: 79


    select loan_start_date from lns_loan_headers_all
    where loan_id=p_loan_id;

Line: 91


            SELECT 'Y'
            INTO   l_dummy
            FROM   LNS_TERMS
            WHERE  term_id = l_term_id;

Line: 146


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: Before call to LNS_TERMS_PKG.Insert_Row');

Line: 149


    LNS_TERMS_PKG.Insert_Row (X_TERM_ID                        => p_loan_term_rec.term_id
                             ,X_LOAN_ID                        => p_loan_term_rec.loan_id
                             ,X_OBJECT_VERSION_NUMBER          => 1
                             ,X_DAY_COUNT_METHOD               => p_loan_term_rec.day_count_method
                             ,X_BASED_ON_BALANCE               => p_loan_term_rec.based_on_balance
                             ,X_FIRST_RATE_CHANGE_DATE         => p_loan_term_rec.first_rate_change_date
                             ,X_NEXT_RATE_CHANGE_DATE          => p_loan_term_rec.next_rate_change_date
                             ,X_PERCENT_INCREASE               => p_loan_term_rec.percent_increase
                             ,X_PERCENT_INCREASE_TERM          => p_loan_term_rec.percent_increase_term
                             ,X_PAYMENT_APPLICATION_ORDER      => p_loan_term_rec.payment_application_order
                             ,X_PREPAY_PENALTY_FLAG            => p_loan_term_rec.prepay_penalty_flag
                             ,X_PREPAY_PENALTY_DATE            => p_loan_term_rec.prepay_penalty_date
                             ,X_CEILING_RATE                   => p_loan_term_rec.ceiling_rate
                             ,X_FLOOR_RATE                     => p_loan_term_rec.floor_rate
                             ,X_DELINQUENCY_THRESHOLD_NUMBER   => p_loan_term_rec.delinquency_threshold_number
                             ,X_DELINQUENCY_THRESHOLD_AMOUNT   => p_loan_term_rec.delinquency_threshold_amount
                             ,X_CALCULATION_METHOD             => p_loan_term_rec.calculation_method
                             ,X_REAMORTIZE_UNDER_PAYMENT       => p_loan_term_rec.reamortize_under_payment
                             ,X_REAMORTIZE_OVER_PAYMENT        => p_loan_term_rec.reamortize_over_payment
                             ,X_REAMORTIZE_WITH_INTEREST       => p_loan_term_rec.reamortize_with_interest
                             ,X_LOAN_PAYMENT_FREQUENCY         => p_loan_term_rec.loan_payment_frequency
                             ,X_INTEREST_COMPOUNDING_FREQ      => p_loan_term_rec.interest_compounding_freq
                             ,X_AMORTIZATION_FREQUENCY         => p_loan_term_rec.amortization_frequency
                             ,X_NUMBER_GRACE_DAYS              => p_loan_term_rec.number_grace_days
                             ,X_RATE_TYPE                      => p_loan_term_rec.rate_type
                             ,X_INDEX_NAME                     => p_loan_term_rec.index_name
                             ,X_ADJUSTMENT_FREQUENCY           => p_loan_term_rec.adjustment_frequency
                             ,X_ADJUSTMENT_FREQUENCY_TYPE      => p_loan_term_rec.adjustment_frequency_type
                             ,X_FIXED_RATE_PERIOD              => p_loan_term_rec.fixed_rate_period
                             ,X_FIXED_RATE_PERIOD_TYPE         => p_loan_term_rec.fixed_rate_period_type
                             ,X_FIRST_PAYMENT_DATE             => p_loan_term_rec.first_payment_date
                             ,X_NEXT_PAYMENT_DUE_DATE          => p_loan_term_rec.next_payment_due_date
                             ,X_OPEN_FIRST_PAYMENT_DATE        => p_loan_term_rec.open_first_payment_date
                             ,X_OPEN_PAYMENT_FREQUENCY         => p_loan_term_rec.open_payment_frequency
                             ,X_OPEN_NEXT_PAYMENT_DATE         => p_loan_term_rec.open_next_payment_date
                             ,X_LOCK_IN_DATE                   => p_loan_term_rec.lock_in_date
                             ,X_LOCK_TO_DATE                   => p_loan_term_rec.lock_to_date
                             ,X_RATE_CHANGE_FREQUENCY          => p_loan_term_rec.rate_change_frequency
                             ,X_INDEX_RATE_ID                  => p_loan_term_rec.index_rate_id
                             ,X_PERCENT_INCREASE_LIFE          => p_loan_term_rec.PERCENT_INCREASE_LIFE
                             ,X_FIRST_PERCENT_INCREASE         => p_loan_term_rec.FIRST_PERCENT_INCREASE
                             ,X_OPEN_PERCENT_INCREASE          => p_loan_term_rec.OPEN_PERCENT_INCREASE
                             ,X_OPEN_PERCENT_INCREASE_LIFE     => p_loan_term_rec.OPEN_PERCENT_INCREASE_LIFE
                             ,X_OPEN_FIRST_PERCENT_INCREASE    => p_loan_term_rec.OPEN_FIRST_PERCENT_INCREASE
                             ,X_PMT_APPL_ORDER_SCOPE           => p_loan_term_rec.PMT_APPL_ORDER_SCOPE
                             ,X_OPEN_CEILING_RATE              => p_loan_term_rec.OPEN_CEILING_RATE
                             ,X_OPEN_FLOOR_RATE                => p_loan_term_rec.OPEN_FLOOR_RATE
                             ,X_OPEN_INDEX_DATE                => p_loan_term_rec.OPEN_INDEX_DATE
                             ,X_TERM_INDEX_DATE                => p_loan_term_rec.TERM_INDEX_DATE
                             ,X_OPEN_PROJECTED_RATE            => p_loan_term_rec.OPEN_PROJECTED_RATE
                             ,X_TERM_PROJECTED_RATE            => p_loan_term_rec.TERM_PROJECTED_RATE
                             ,X_PAYMENT_CALC_METHOD            => p_loan_term_rec.PAYMENT_CALC_METHOD
                             ,X_CUSTOM_CALC_METHOD	         => p_loan_term_rec.CUSTOM_CALC_METHOD
                             ,X_ORIG_PAY_CALC_METHOD	         => p_loan_term_rec.ORIG_PAY_CALC_METHOD
                             ,X_PRIN_FIRST_PAY_DATE            => p_loan_term_rec.PRIN_FIRST_PAY_DATE
                             ,X_PRIN_PAYMENT_FREQUENCY         => p_loan_term_rec.PRIN_PAYMENT_FREQUENCY
                             ,X_PENAL_INT_RATE		         => p_loan_term_rec.PENAL_INT_RATE
                             ,X_PENAL_INT_GRACE_DAYS           => p_loan_term_rec.PENAL_INT_GRACE_DAYS
                             ,X_CALC_ADD_INT_UNPAID_PRIN       => p_loan_term_rec.CALC_ADD_INT_UNPAID_PRIN
                             ,X_CALC_ADD_INT_UNPAID_INT	   => p_loan_term_rec.CALC_ADD_INT_UNPAID_INT
                             ,X_REAMORTIZE_ON_FUNDING	         => p_loan_term_rec.REAMORTIZE_ON_FUNDING
                             ,X_DEFAULT_THRESHOLD_AMOUNT       => p_loan_term_rec.DEFAULT_THRESHOLD_AMOUNT
                             ,X_CUSTOM_SCHED_DESC              => p_loan_term_rec.CUSTOM_SCHED_DESC
                             ,X_CAPITALIZE_INT		         => p_loan_term_rec.CAPITALIZE_INT
                             ,X_CALC_EARLY_PAY_CR		   => p_loan_term_rec.CALC_EARLY_PAY_CR
                             ,X_FLUCTUATE_EQ_PAY_AMOUNT	   => p_loan_term_rec.FLUCTUATE_EQ_PAY_AMOUNT
			     );

Line: 219


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_create_term procedure: After call to LNS_TERMS.Insert_Row');

Line: 226


 |              do_update_term
 |
 | DESCRIPTION
 |              Updates term.
 |
 | SCOPE - PRIVATE
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |              OUT:
 |              IN/OUT:
 |                    p_loan_term_rec
 |		      p_object_version_number
 |                    x_return_status
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |
 |   21-Dec-2003     Karthik Ramachandran       Created.
 +===========================================================================*/

PROCEDURE do_update_term(p_loan_term_rec           IN OUT NOCOPY LOAN_TERM_REC_TYPE
                        ,p_object_version_number   IN OUT NOCOPY NUMBER
                        ,x_return_status           IN OUT NOCOPY VARCHAR2) IS

    l_object_version_number NUMBER;

Line: 263


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin do_update_term procedure');

Line: 267


        SELECT OBJECT_VERSION_NUMBER,
               ROWID
        INTO   l_object_version_number,
               l_rowid
        FROM   LNS_TERMS
        WHERE  TERM_ID = p_loan_term_rec.term_id
        FOR UPDATE OF TERM_ID NOWAIT;

Line: 313


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: Before call to LNS_TERMS_PKG.Update_Row');

Line: 318


    LNS_TERMS_PKG.Update_Row (
        X_Rowid                   => l_rowid,
        X_TERM_ID                   => p_loan_term_rec.term_id,
        X_LOAN_ID                   => p_loan_term_rec.loan_id,
        X_OBJECT_VERSION_NUMBER     => p_object_version_number,
        X_DAY_COUNT_METHOD          => p_loan_term_rec.day_count_method,
        X_BASED_ON_BALANCE          => p_loan_term_rec.based_on_balance,
        X_FIRST_RATE_CHANGE_DATE    => p_loan_term_rec.first_rate_change_date,
        X_NEXT_RATE_CHANGE_DATE     => p_loan_term_rec.next_rate_change_date,
        X_PERCENT_INCREASE          => p_loan_term_rec.percent_increase,
        X_PERCENT_INCREASE_TERM     => p_loan_term_rec.percent_increase_term,
        X_PAYMENT_APPLICATION_ORDER => p_loan_term_rec.payment_application_order,
        X_PREPAY_PENALTY_FLAG       => p_loan_term_rec.prepay_penalty_flag,
        X_PREPAY_PENALTY_DATE       => p_loan_term_rec.prepay_penalty_date,
        X_CEILING_RATE              => p_loan_term_rec.ceiling_rate,
        X_FLOOR_RATE                => p_loan_term_rec.floor_rate,
        X_DELINQUENCY_THRESHOLD_NUMBER  => p_loan_term_rec.delinquency_threshold_number,
        X_DELINQUENCY_THRESHOLD_AMOUNT  => p_loan_term_rec.delinquency_threshold_amount,
        X_CALCULATION_METHOD        => p_loan_term_rec.calculation_method,
        X_REAMORTIZE_UNDER_PAYMENT  => p_loan_term_rec.reamortize_under_payment,
        X_REAMORTIZE_OVER_PAYMENT   => p_loan_term_rec.reamortize_over_payment,
        X_REAMORTIZE_WITH_INTEREST  => p_loan_term_rec.reamortize_with_interest,
        X_LOAN_PAYMENT_FREQUENCY    => p_loan_term_rec.loan_payment_frequency,
        X_INTEREST_COMPOUNDING_FREQ => p_loan_term_rec.interest_compounding_freq,
        X_AMORTIZATION_FREQUENCY    => p_loan_term_rec.amortization_frequency,
        X_NUMBER_GRACE_DAYS         => p_loan_term_rec.number_grace_days,
        X_RATE_TYPE                 => p_loan_term_rec.rate_type,
        X_INDEX_NAME                => p_loan_term_rec.index_name,
        X_ADJUSTMENT_FREQUENCY      => p_loan_term_rec.adjustment_frequency,
        X_ADJUSTMENT_FREQUENCY_TYPE => p_loan_term_rec.adjustment_frequency_type,
        X_FIXED_RATE_PERIOD         => p_loan_term_rec.fixed_rate_period,
        X_FIXED_RATE_PERIOD_TYPE    => p_loan_term_rec.fixed_rate_period_type,
        X_FIRST_PAYMENT_DATE        => p_loan_term_rec.first_payment_date,
        X_NEXT_PAYMENT_DUE_DATE     => p_loan_term_rec.next_payment_due_date,
        X_OPEN_FIRST_PAYMENT_DATE   => p_loan_term_rec.open_first_payment_date,
        X_OPEN_PAYMENT_FREQUENCY    => p_loan_term_rec.open_payment_frequency,
        X_OPEN_NEXT_PAYMENT_DATE    => p_loan_term_rec.open_next_payment_date,
        X_LOCK_IN_DATE              => p_loan_term_rec.lock_in_date,
        X_LOCK_TO_DATE              => p_loan_term_rec.lock_to_date,
        X_RATE_CHANGE_FREQUENCY     => p_loan_term_rec.rate_change_frequency,
        X_INDEX_RATE_ID             => p_loan_term_rec.index_rate_id,
        X_PERCENT_INCREASE_LIFE     => p_loan_term_rec.PERCENT_INCREASE_LIFE,
        X_FIRST_PERCENT_INCREASE    => p_loan_term_rec.FIRST_PERCENT_INCREASE,
        X_OPEN_PERCENT_INCREASE     => p_loan_term_rec.OPEN_PERCENT_INCREASE,
        X_OPEN_PERCENT_INCREASE_LIFE    => p_loan_term_rec.OPEN_PERCENT_INCREASE_LIFE,
        X_OPEN_FIRST_PERCENT_INCREASE   => p_loan_term_rec.OPEN_FIRST_PERCENT_INCREASE,
        X_PMT_APPL_ORDER_SCOPE      => p_loan_term_rec.PMT_APPL_ORDER_SCOPE,
        X_OPEN_CEILING_RATE         => p_loan_term_rec.OPEN_CEILING_RATE,
        X_OPEN_FLOOR_RATE           => p_loan_term_rec.OPEN_FLOOR_RATE,
        X_OPEN_INDEX_DATE           => p_loan_term_rec.OPEN_INDEX_DATE,
        X_TERM_INDEX_DATE           => p_loan_term_rec.TERM_INDEX_DATE,
        X_OPEN_PROJECTED_RATE       => p_loan_term_rec.OPEN_PROJECTED_RATE,
        X_TERM_PROJECTED_RATE       => p_loan_term_rec.TERM_PROJECTED_RATE,
        X_PAYMENT_CALC_METHOD       => p_loan_term_rec.PAYMENT_CALC_METHOD,
        X_CUSTOM_CALC_METHOD	    => p_loan_term_rec.CUSTOM_CALC_METHOD,
        X_ORIG_PAY_CALC_METHOD	    => p_loan_term_rec.ORIG_PAY_CALC_METHOD,
	  X_PRIN_FIRST_PAY_DATE	    => p_loan_term_rec.PRIN_FIRST_PAY_DATE,
        X_PRIN_PAYMENT_FREQUENCY    => p_loan_term_rec.PRIN_PAYMENT_FREQUENCY,
        X_PENAL_INT_RATE            => p_loan_term_rec.PENAL_INT_RATE,
        X_PENAL_INT_GRACE_DAYS      => p_loan_term_rec.PENAL_INT_GRACE_DAYS,
	  X_CALC_ADD_INT_UNPAID_PRIN  => p_loan_term_rec.CALC_ADD_INT_UNPAID_PRIN,
        X_CALC_ADD_INT_UNPAID_INT   => p_loan_term_rec.CALC_ADD_INT_UNPAID_INT,
	  X_REAMORTIZE_ON_FUNDING     => p_loan_term_rec.REAMORTIZE_ON_FUNDING,
	  X_DEFAULT_THRESHOLD_AMOUNT  => p_loan_term_rec.DEFAULT_THRESHOLD_AMOUNT,
	  X_CUSTOM_SCHED_DESC         => p_loan_term_rec.CUSTOM_SCHED_DESC,
	  X_CAPITALIZE_INT            => p_loan_term_rec.CAPITALIZE_INT,
	  X_CALC_EARLY_PAY_CR         => p_loan_term_rec.CALC_EARLY_PAY_CR,
	  X_FLUCTUATE_EQ_PAY_AMOUNT   => p_loan_term_rec.FLUCTUATE_EQ_PAY_AMOUNT
        );

Line: 388


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In do_update_term procedure: After call to LNS_TERMS_PKG.Update_Row');

Line: 390


END do_update_term;

Line: 454


    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from LNS_TERMS
    where term_id = p_term_id;

Line: 459


    LNS_TERMS_PUB.update_term(
            p_init_msg_list         => FND_API.G_FALSE,
            p_loan_term_rec         => l_loan_term_rec,
            p_object_version_number => l_object_version_number,
            X_RETURN_STATUS         => x_return_status,
            X_MSG_COUNT             => l_msg_count,
            X_MSG_DATA              => l_msg_data);

Line: 582


    select OBJECT_VERSION_NUMBER
    into l_object_version_number
    from LNS_TERMS
    where term_id = p_term_id;

Line: 587


    LNS_TERMS_PUB.update_term(
            p_init_msg_list         => FND_API.G_FALSE,
            p_loan_term_rec         => l_loan_term_rec,
            p_object_version_number => l_object_version_number,
            X_RETURN_STATUS         => x_return_status,
            X_MSG_COUNT             => l_msg_count,
            X_MSG_DATA              => l_msg_data);

Line: 735


 |              update_term
 |
 | DESCRIPTION
 |              Updates term.
 |
 | SCOPE - PUBLIC
 |
 | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED
 |
 | ARGUMENTS  : IN:
 |                    p_init_msg_list
 |                    p_loan_term_rec
 |              OUT:
 |                    x_return_status
 |                    x_msg_count
 |                    x_msg_data
 |              IN/OUT:
 |		      p_object_version_number
 |
 | RETURNS    : NONE
 |
 | NOTES
 |
 | MODIFICATION HISTORY
 |   21-Dec-2003     Karthik Ramachandran       Created.
 +===========================================================================*/

PROCEDURE update_term (
    p_init_msg_list         IN      VARCHAR2,
    p_loan_term_rec       IN      LOAN_TERM_REC_TYPE,
    p_object_version_number IN OUT NOCOPY  NUMBER,
    x_return_status         OUT NOCOPY     VARCHAR2,
    x_msg_count             OUT NOCOPY     NUMBER,
    x_msg_data              OUT NOCOPY     VARCHAR2
) IS

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

Line: 779


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - Begin Update_Term procedure');

Line: 782


    SAVEPOINT update_term;

Line: 807


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Update_Term procedure: Before call to do_update_term proc');

Line: 810


    do_update_term(
                   l_loan_term_rec,
                   p_object_version_number,
                   x_return_status
                  );

Line: 816


    logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' - In Update_Term procedure: After call to do_update_term proc');

Line: 820


        ROLLBACK TO update_term;

Line: 827


        ROLLBACK TO update_term;

Line: 834


        ROLLBACK TO update_term;

Line: 844


    	FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End Update_Term procedure');

Line: 847


END update_term;

Line: 891


    select day_count_method
          ,amortization_frequency
      from lns_terms
     where loan_id = p_loan_id;

Line: 1025


    LNS_TERMS_PKG.Select_Row (
                    X_TERM_ID           => x_loan_term_rec.term_id,
                    X_LOAN_ID           => x_loan_term_rec.loan_id,
                    X_DAY_COUNT_METHOD      => x_loan_term_rec.day_count_method,
                    X_BASED_ON_BALANCE      => x_loan_term_rec.based_on_balance,
                    X_FIRST_RATE_CHANGE_DATE    => x_loan_term_rec.first_rate_change_date,
                    X_NEXT_RATE_CHANGE_DATE     => x_loan_term_rec.next_rate_change_date,
                    X_PERCENT_INCREASE      => x_loan_term_rec.percent_increase,
                    X_PERCENT_INCREASE_TERM     => x_loan_term_rec.percent_increase_term,
                    X_PAYMENT_APPLICATION_ORDER => x_loan_term_rec.payment_application_order,
                    X_PREPAY_PENALTY_FLAG       => x_loan_term_rec.prepay_penalty_flag,
                    X_PREPAY_PENALTY_DATE       => x_loan_term_rec.prepay_penalty_date,
                    X_CEILING_RATE          => x_loan_term_rec.ceiling_rate,
                    X_FLOOR_RATE            => x_loan_term_rec.floor_rate,
                    X_DELINQUENCY_THRESHOLD_NUMBER  => x_loan_term_rec.delinquency_threshold_number,
                    X_DELINQUENCY_THRESHOLD_AMOUNT  => x_loan_term_rec.delinquency_threshold_amount,
                    X_CALCULATION_METHOD        => x_loan_term_rec.calculation_method,
                    X_REAMORTIZE_UNDER_PAYMENT  => x_loan_term_rec.reamortize_under_payment,
                    X_REAMORTIZE_OVER_PAYMENT   => x_loan_term_rec.reamortize_over_payment,
                    X_REAMORTIZE_WITH_INTEREST  => x_loan_term_rec.reamortize_with_interest,
                    X_LOAN_PAYMENT_FREQUENCY    => x_loan_term_rec.loan_payment_frequency,
                    X_INTEREST_COMPOUNDING_FREQ => x_loan_term_rec.interest_compounding_freq,
                    X_AMORTIZATION_FREQUENCY    => x_loan_term_rec.amortization_frequency,
                    X_NUMBER_GRACE_DAYS     => x_loan_term_rec.number_grace_days,
                    X_RATE_TYPE         => x_loan_term_rec.rate_type,
                    X_INDEX_NAME            => x_loan_term_rec.index_name,
                    X_ADJUSTMENT_FREQUENCY      => x_loan_term_rec.adjustment_frequency,
                    X_ADJUSTMENT_FREQUENCY_TYPE => x_loan_term_rec.adjustment_frequency_type,
                    X_FIXED_RATE_PERIOD     => x_loan_term_rec.fixed_rate_period,
                    X_FIXED_RATE_PERIOD_TYPE    => x_loan_term_rec.fixed_rate_period_type,
                    X_FIRST_PAYMENT_DATE        => x_loan_term_rec.first_payment_date,
                    X_NEXT_PAYMENT_DUE_DATE     => x_loan_term_rec.next_payment_due_date,
                    X_OPEN_FIRST_PAYMENT_DATE   => x_loan_term_rec.open_first_payment_date,
                    X_OPEN_PAYMENT_FREQUENCY    => x_loan_term_rec.open_payment_frequency,
                    X_OPEN_NEXT_PAYMENT_DATE    => x_loan_term_rec.open_next_payment_date,
                    X_LOCK_IN_DATE          => x_loan_term_rec.lock_in_date,
                    X_LOCK_TO_DATE          => x_loan_term_rec.lock_to_date,
                    X_RATE_CHANGE_FREQUENCY     => x_loan_term_rec.rate_change_frequency,
                    X_INDEX_RATE_ID         => x_loan_term_rec.index_rate_id,
                    X_PERCENT_INCREASE_LIFE     => x_loan_term_rec.PERCENT_INCREASE_LIFE,
                    X_FIRST_PERCENT_INCREASE    => x_loan_term_rec.FIRST_PERCENT_INCREASE,
                    X_OPEN_PERCENT_INCREASE     => x_loan_term_rec.OPEN_PERCENT_INCREASE,
                    X_OPEN_PERCENT_INCREASE_LIFE    => x_loan_term_rec.OPEN_PERCENT_INCREASE_LIFE,
                    X_OPEN_FIRST_PERCENT_INCREASE   => x_loan_term_rec.OPEN_FIRST_PERCENT_INCREASE,
                    X_PMT_APPL_ORDER_SCOPE      => x_loan_term_rec.PMT_APPL_ORDER_SCOPE,
                    X_OPEN_CEILING_RATE       => x_loan_term_rec.OPEN_CEILING_RATE,
                    X_OPEN_FLOOR_RATE         => x_loan_term_rec.OPEN_FLOOR_RATE,
                    X_OPEN_INDEX_DATE         => x_loan_term_rec.OPEN_INDEX_DATE,
                    X_TERM_INDEX_DATE         => x_loan_term_rec.TERM_INDEX_DATE,
                    X_OPEN_PROJECTED_RATE       => x_loan_term_rec.OPEN_PROJECTED_RATE,
                    X_TERM_PROJECTED_RATE       => x_loan_term_rec.TERM_PROJECTED_RATE,
                    X_PAYMENT_CALC_METHOD       => x_loan_term_rec.PAYMENT_CALC_METHOD,
                    X_CUSTOM_CALC_METHOD	=> x_loan_term_rec.CUSTOM_CALC_METHOD,
                    X_ORIG_PAY_CALC_METHOD	=> x_loan_term_rec.ORIG_PAY_CALC_METHOD,
		        X_PRIN_FIRST_PAY_DATE	=> x_loan_term_rec.prin_first_pay_date,
                    X_PRIN_PAYMENT_FREQUENCY	=> x_loan_term_rec.prin_payment_frequency,
		        X_PENAL_INT_RATE            => x_loan_term_rec.PENAL_INT_RATE,
		        X_PENAL_INT_GRACE_DAYS      => x_loan_term_rec.PENAL_INT_GRACE_DAYS,
		        X_CALC_ADD_INT_UNPAID_PRIN  => x_loan_term_rec.CALC_ADD_INT_UNPAID_PRIN,
		        X_CALC_ADD_INT_UNPAID_INT   => x_loan_term_rec.CALC_ADD_INT_UNPAID_INT,
		        X_REAMORTIZE_ON_FUNDING     => x_loan_term_rec.REAMORTIZE_ON_FUNDING,
		        X_DEFAULT_THRESHOLD_AMOUNT  => x_loan_term_rec.DEFAULT_THRESHOLD_AMOUNT,
		        X_CUSTOM_SCHED_DESC         => x_loan_term_rec.CUSTOM_SCHED_DESC,
		        X_CAPITALIZE_INT            => x_loan_term_rec.CAPITALIZE_INT,
		        X_CALC_EARLY_PAY_CR         => x_loan_term_rec.CALC_EARLY_PAY_CR,
		        X_FLUCTUATE_EQ_PAY_AMOUNT   => x_loan_term_rec.FLUCTUATE_EQ_PAY_AMOUNT

                    );

Line: 1181


    select count(1)
      from lns_rate_schedules rs,
           lns_terms term
     where term.loan_id = p_loan_id
       and term.term_id = rs.term_id
       and rs.interest_only_flag = 'Y'
       and rs.phase <> 'OPEN';

Line: 1190


    select max(end_installment_number)
      from lns_rate_schedules rs,
           lns_terms term
     where term.loan_id = p_loan_id
       and term.term_id = rs.term_id
       and rs.interest_only_flag = 'Y'
       and rs.phase <> 'OPEN';

Line: 1199


    select nvl(reamortize_over_payment, 'N')
      from lns_terms
     where loan_id = p_loan_id;

Line: 1204


    select first_payment_date
      from lns_terms
     where loan_id = p_loan_id;