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

Line 721: SELECT object1_id1 frequency, object2_id1 laslh_id, fnd_date.canonical_to_date(rule_information2) start_date,

717: p_payment_frequency IN VARCHAR2,
718: p_payment_arrears IN VARCHAR2) RETURN BOOLEAN IS
719: -- cursor to retrieve the details of the LASLL rule
720: CURSOR find_lasll_dtls_csr(p_rul_id NUMBER) IS
721: SELECT object1_id1 frequency, object2_id1 laslh_id, fnd_date.canonical_to_date(rule_information2) start_date,
722: rule_information3 periods, rule_information6 amount,
723: rule_information5 payment_structure, rule_information13 rate,
724: rule_information7 stub_days, rule_information8 stub_amount, rule_information10 arrears
725: FROM okc_rules_b

Line 1374: l_lasll_rec.rule_information2 := fnd_date.date_to_canonical(l_payment_levels_tbl(line_number).start_date);

1370: l_lasll_rec.rule_information6 := l_payment_levels_tbl(line_number).amount;
1371: l_lasll_rec.rule_information10 := p_payment_arrears;
1372: l_lasll_rec.rule_information5 := NVL(p_payment_structure, '0');
1373: l_lasll_rec.rule_information13 := l_payment_levels_tbl(line_number).rate;
1374: l_lasll_rec.rule_information2 := fnd_date.date_to_canonical(l_payment_levels_tbl(line_number).start_date);
1375: -- stub information will be null except for the first line ( validation done before)
1376: l_lasll_rec.rule_information7 := l_payment_levels_tbl(line_number).stub_days;
1377: l_lasll_rec.rule_information8 := l_payment_levels_tbl(line_number).stub_amount;
1378: