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_FINANCIALS dependencies on DUAL

Line 286: from dual;

282: ,index_rate = null
283: where rate_id = p_rate_id;
284:
285: select LNS_RATE_SCHEDULES_S.NEXTVAL into l_new_rate_id
286: from dual;
287:
288: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - adding new row into rate schedule');
289: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_new_rate_id ' || l_new_rate_id );
290: insert into lns_rate_schedules(RATE_ID

Line 8597: || p_ending_balance => future or residual value of the loan (most loans will pass 0)

8593: || PARAMETERS
8594: ||
8595: || Parameter: p_loan_amount => amount of loan
8596: || p_num_intervals => number of installments for loan
8597: || p_ending_balance => future or residual value of the loan (most loans will pass 0)
8598: || p_pay_in_arrears => true if payments are at end of period
8599: || false otherwise
8600: ||
8601: || payment = (p_loan_amount - p_ending_balance) / p_num_intervals;

Line 8664: || p_ending_balance => future or residual value of the loan (most loans will pass 0)

8660: ||
8661: || Parameter: p_annualized_rate => annual rate of the loan
8662: || p_loan_amount => amount of loan
8663: || p_num_intervals => number of installments for loan
8664: || p_ending_balance => future or residual value of the loan (most loans will pass 0)
8665: || p_pay_in_arrears => true if payments are at end of period
8666: || false otherwise
8667: ||
8668: || payment =

Line 9638: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;

9634: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': p_period_start_date: ' || p_period_start_date);
9635: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': p_period_end_date: ' || p_period_end_date);
9636: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': p_target: ' || p_target);
9637:
9638: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;
9639: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;
9640:
9641: l_periodic_rate := 0;
9642: l_total_periodic_rate := 0;

Line 9639: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;

9635: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': p_period_end_date: ' || p_period_end_date);
9636: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ': p_target: ' || p_target);
9637:
9638: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;
9639: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;
9640:
9641: l_periodic_rate := 0;
9642: l_total_periodic_rate := 0;
9643:

Line 9820: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;

9816:
9817: l_annual_rate := p_annualized_rate / 100;
9818: l_periodic_rate := 0;
9819:
9820: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;
9821: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;
9822:
9823: if p_target = 'INTEREST' then
9824:

Line 9821: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;

9817: l_annual_rate := p_annualized_rate / 100;
9818: l_periodic_rate := 0;
9819:
9820: select to_number(to_char(p_period_start_date, 'YYYY')) into l_year1 from dual;
9821: select to_number(to_char(p_period_end_date, 'YYYY')) into l_year2 from dual;
9822:
9823: if p_target = 'INTEREST' then
9824:
9825: for k in l_year1..l_year2 loop

Line 11779: select to_char(l_num) into l_str from dual;

11775: BEGIN
11776:
11777: l_num := 123.12;
11778:
11779: select to_char(l_num) into l_str from dual;
11780: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'number 123.12 => string ' || l_str);
11781:
11782: l_char := substr(l_str, 4, 1);
11783: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'number . => char ' || l_char);