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

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

47: (Select sll.id,
48: styp.code payment_type,
49: sll.object1_id1 Pay_freq,
50: sll.rule_information1 seq,
51: fnd_date.canonical_to_date(sll.rule_information2) start_date,
52: sll.rule_information3 number_periods,
53: sll.rule_information4 tuoms_per_period,
54: sll.rule_information6 amount,
55: sll.rule_information7 stub_days,

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

71: and slh.object1_id1 = styp.id
72: and rgp.rgd_code = 'LALEVL'
73: and rgp.cle_id = cp_kle_id
74: order by rgp.cle_id
75: , fnd_date.canonical_to_date(sll.rule_information2)) A
76: )
77: where sequence = cp_sequence;
78:
79: BEGIN

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

295: l_stub_days NUMBER;
296: l_stub_amount NUMBER;
297:
298: CURSOR l_stub_csr(cp_kle_id IN NUMBER, cp_start_date IN DATE) IS
299: Select fnd_date.canonical_to_date(sll.rule_information2) start_date,
300: sll.rule_information7 stub_days,
301: sll.rule_information8 stub_amount
302: from okc_rules_b sll,
303: okc_rules_b slh,

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

314: and rgp.rgd_code = 'LALEVL'
315: and rgp.cle_id = cp_kle_id
316: and sll.rule_information7 IS NOT NULL
317: and sll.rule_information8 IS NOT NULL
318: --and fnd_date.canonical_to_date(sll.rule_information2) <= cp_start_date
319: order by abs(fnd_date.canonical_to_date(sll.rule_information2) - cp_start_date) asc;
320: BEGIN
321: OPEN l_stub_csr(p_kle_id, p_start_date);
322: FETCH l_stub_csr INTO l_stub_start_date, l_stub_days, l_stub_amount;

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

315: and rgp.cle_id = cp_kle_id
316: and sll.rule_information7 IS NOT NULL
317: and sll.rule_information8 IS NOT NULL
318: --and fnd_date.canonical_to_date(sll.rule_information2) <= cp_start_date
319: order by abs(fnd_date.canonical_to_date(sll.rule_information2) - cp_start_date) asc;
320: BEGIN
321: OPEN l_stub_csr(p_kle_id, p_start_date);
322: FETCH l_stub_csr INTO l_stub_start_date, l_stub_days, l_stub_amount;
323: CLOSE l_stub_csr;

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

1146: l_structure := l_pmt_cur.structure;
1147: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || 'done populating l_strm_lalevl_tbl with LASLH information');
1148: END IF;
1149:
1150: l_prior_level_date_start := FND_DATE.canonical_to_date(l_pmt_cur.start_date);
1151: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || 'l_prior_level_date_start : ' || l_prior_level_date_start);
1152: l_level_date_start := NULL;
1153: l_prior_periods := 0;
1154:

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

1168: l_stream_level_header := l_pmt_cur.stream_level_header;
1169: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Object1_id1 := l_pmt_cur.Pay_freq;
1170: l_sequence := l_sequence + 1;
1171: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information1 := l_sequence;
1172: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information2 := fnd_date.date_to_canonical(l_level_date_start);
1173: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information4 := l_pmt_cur.tuoms_per_period;
1174: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information5 := l_structure;
1175: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information6 := NULL;
1176: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information7 := l_pmt_cur.stub_days;

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

1214: l_stream_level_header := l_pmt_cur.stream_level_header;
1215: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Object1_id1 := l_pmt_cur.Pay_freq;
1216: l_sequence := l_sequence + 1;
1217: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information1 := l_sequence;
1218: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information2 := fnd_date.date_to_canonical(l_level_date_start);
1219: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information4 := l_pmt_cur.tuoms_per_period;
1220: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information5 := l_structure;
1221: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information6 := l_pmt_cur.amount;
1222: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information7 := l_pmt_cur.stub_days;

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

1260: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || ' l_stub_start_date => ' || l_stub_start_date);
1261: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || ' l_stub_days => ' || l_stub_days);
1262: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || ' l_stub_amount => ' || l_stub_amount);
1263:
1264: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information2 := fnd_date.date_to_canonical(l_stub_start_date);
1265: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information3 := NULL;
1266: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information6 := NULL;
1267: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information7 := l_stub_days;
1268: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information8 := l_rent_tbl(l_rent_tbl_cntr).amount;

Line 1270: 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);

1266: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information6 := NULL;
1267: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information7 := l_stub_days;
1268: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information8 := l_rent_tbl(l_rent_tbl_cntr).amount;
1269: ELSE
1270: 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);
1271: END IF;
1272:
1273: IF (p_trx_id IS NOT NULL) THEN
1274: l_strm_lalevl_tbl(l_strm_lalevl_tbl_cntr).Rule_Information10 := l_rent_tbl(l_rent_tbl_cntr).advance_or_arrears;