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_VARIABLE_INTEREST_PVT dependencies on FND_DATE

Line 111: fnd_date.canonical_to_date(sll.rule_information2) start_date,

107: (Select sll.id,
108: styp.code payment_type,
109: sll.object1_id1 Pay_freq,
110: sll.rule_information1 seq,
111: fnd_date.canonical_to_date(sll.rule_information2) start_date,
112: sll.rule_information3 number_periods,
113: sll.rule_information4 tuoms_per_period,
114: sll.rule_information6 amount,
115: sll.rule_information7 stub_days,

Line 135: , fnd_date.canonical_to_date(sll.rule_information2)) A

131: and slh.object1_id1 = styp.id
132: and rgp.rgd_code = 'LALEVL'
133: and rgp.cle_id = cp_kle_id
134: order by rgp.cle_id
135: , fnd_date.canonical_to_date(sll.rule_information2)) A
136: )
137: where sequence = cp_sequence;
138:
139: BEGIN

Line 158: Select fnd_date.canonical_to_date(sll.rule_information2) start_date,

154: l_stub_days NUMBER;
155: l_stub_amount NUMBER;
156:
157: CURSOR l_stub_csr(cp_kle_id IN NUMBER, cp_start_date IN DATE) IS
158: Select fnd_date.canonical_to_date(sll.rule_information2) start_date,
159: sll.rule_information7 stub_days,
160: sll.rule_information8 stub_amount
161: from okc_rules_b sll,
162: okc_rules_b slh,

Line 177: --and fnd_date.canonical_to_date(sll.rule_information2) <= cp_start_date

173: and rgp.rgd_code = 'LALEVL'
174: and rgp.cle_id = cp_kle_id
175: and sll.rule_information7 IS NOT NULL
176: and sll.rule_information8 IS NOT NULL
177: --and fnd_date.canonical_to_date(sll.rule_information2) <= cp_start_date
178: order by abs(fnd_date.canonical_to_date(sll.rule_information2) - cp_start_date) asc;
179: BEGIN
180: OPEN l_stub_csr(p_kle_id, p_start_date);
181: FETCH l_stub_csr INTO l_stub_start_date, l_stub_days, l_stub_amount;

Line 178: order by abs(fnd_date.canonical_to_date(sll.rule_information2) - cp_start_date) asc;

174: and rgp.cle_id = cp_kle_id
175: and sll.rule_information7 IS NOT NULL
176: and sll.rule_information8 IS NOT NULL
177: --and fnd_date.canonical_to_date(sll.rule_information2) <= cp_start_date
178: order by abs(fnd_date.canonical_to_date(sll.rule_information2) - cp_start_date) asc;
179: BEGIN
180: OPEN l_stub_csr(p_kle_id, p_start_date);
181: FETCH l_stub_csr INTO l_stub_start_date, l_stub_days, l_stub_amount;
182: CLOSE l_stub_csr;

Line 2507: and FND_DATE.canonical_to_date(lx_rulv_rec.rule_information4) > r_contracts_csr.start_date) THEN

2503: if (r_contracts_csr.date_last_interim_interest_cal is not null
2504: and r_contracts_csr.date_last_interim_interest_cal > r_contracts_csr.start_date) THEN
2505: l_stm_date := r_contracts_csr.date_last_interim_interest_cal;
2506: elsif(lx_rulv_rec.rule_information4 is not null
2507: and FND_DATE.canonical_to_date(lx_rulv_rec.rule_information4) > r_contracts_csr.start_date) THEN
2508: l_stm_date := FND_DATE.canonical_to_date(lx_rulv_rec.rule_information4);
2509: else
2510: l_stm_date := r_contracts_csr.start_date;
2511: end if;

Line 2508: l_stm_date := FND_DATE.canonical_to_date(lx_rulv_rec.rule_information4);

2504: and r_contracts_csr.date_last_interim_interest_cal > r_contracts_csr.start_date) THEN
2505: l_stm_date := r_contracts_csr.date_last_interim_interest_cal;
2506: elsif(lx_rulv_rec.rule_information4 is not null
2507: and FND_DATE.canonical_to_date(lx_rulv_rec.rule_information4) > r_contracts_csr.start_date) THEN
2508: l_stm_date := FND_DATE.canonical_to_date(lx_rulv_rec.rule_information4);
2509: else
2510: l_stm_date := r_contracts_csr.start_date;
2511: end if;
2512:

Line 9355: l_prior_level_date_start := FND_DATE.canonical_to_date(l_pmt_cur.start_date);

9351: l_structure := l_pmt_cur.structure;
9352: print_debug('done populating l_strm_lalevl_tbl with LASLH information');
9353: END IF;
9354:
9355: l_prior_level_date_start := FND_DATE.canonical_to_date(l_pmt_cur.start_date);
9356: print_debug('l_prior_level_date_start : ' || l_prior_level_date_start);
9357: l_level_date_start := NULL;
9358: l_prior_periods := 0;
9359: FOR l_period_cntr IN 1..NVL(l_pmt_cur.number_periods, 1) LOOP

Line 9385: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information2 := fnd_date.date_to_canonical(l_level_date_start);

9381: l_stream_level_header := l_pmt_cur.stream_level_header;
9382: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Object1_id1 := l_pmt_cur.Pay_freq;
9383: l_sequence := l_sequence + 1;
9384: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information1 := l_sequence;
9385: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information2 := fnd_date.date_to_canonical(l_level_date_start);
9386: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information4 := l_pmt_cur.tuoms_per_period;
9387: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information5 := l_structure;
9388: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information6 := l_pmt_cur.amount;
9389: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information7 := l_pmt_cur.stub_days;

Line 9430: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information2 := fnd_date.date_to_canonical(l_stub_start_date);

9426: print_debug(' l_stub_start_date => ' || l_stub_start_date);
9427: print_debug(' l_stub_days => ' || l_stub_days);
9428: print_debug(' l_stub_amount => ' || l_stub_amount);
9429:
9430: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information2 := fnd_date.date_to_canonical(l_stub_start_date);
9431: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information3 := NULL;
9432: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information6 := NULL;
9433: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information7 := l_stub_days;
9434: --l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information8 := l_stub_amount;

Line 9437: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information2 := fnd_date.date_to_canonical(l_rent_tbl(l_rent_tbl_cntr).first_payment_date);

9433: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information7 := l_stub_days;
9434: --l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information8 := l_stub_amount;
9435: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information8 := l_rent_tbl(l_rent_tbl_cntr).amount;
9436: ELSE
9437: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information2 := fnd_date.date_to_canonical(l_rent_tbl(l_rent_tbl_cntr).first_payment_date);
9438: END IF;
9439: --start change by pjgomes
9440: --uncomment out the below lines when necessary changes are made
9441: --so that the l_rent_tbl structure has stub_days and stub_amount fields

Line 9496: If (FND_DATE.canonical_to_date(r_pymt_csr.start_date) < l_reamort_date) Then

9492: ' No. of Old Periods: '||r_pymt_csr.number_periods||
9493: ' Payment Start Date: '||l_reamort_date);
9494: print_debug('Payment Start Date from Split: '||l_split_asset_tbl(l_split_count).Rule_Information2);
9495:
9496: If (FND_DATE.canonical_to_date(r_pymt_csr.start_date) < l_reamort_date) Then
9497: i := i + 1;
9498: l_diff_in_periods := round(months_between(l_reamort_date,
9499: FND_DATE.canonical_to_date(r_pymt_csr.start_date)));
9500: print_debug('Period Diff: '||l_diff_in_periods);

Line 9499: FND_DATE.canonical_to_date(r_pymt_csr.start_date)));

9495:
9496: If (FND_DATE.canonical_to_date(r_pymt_csr.start_date) < l_reamort_date) Then
9497: i := i + 1;
9498: l_diff_in_periods := round(months_between(l_reamort_date,
9499: FND_DATE.canonical_to_date(r_pymt_csr.start_date)));
9500: print_debug('Period Diff: '||l_diff_in_periods);
9501: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Period Diff: '||l_diff_in_periods);
9502: If (l_diff_in_periods >= 1 and r_pymt_csr.number_periods > l_diff_in_periods)Then
9503: l_strm_lalevl_tbl(i).Rule_Information3 := l_diff_in_periods;