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

Line 1071: l_end_date := FND_DATE.canonical_to_date(p_start_date) + to_number(p_stub_days);

1067: RETURN DATE IS
1068: l_end_date date;
1069: BEGIN
1070: if(p_stub_days is not null and p_stub_days <> OKL_API.G_MISS_CHAR) then -- end date for stub entry.
1071: l_end_date := FND_DATE.canonical_to_date(p_start_date) + to_number(p_stub_days);
1072: l_end_date := l_end_date - 1;
1073: else -- end date for level entry.
1074: l_end_date := get_end_date(FND_DATE.canonical_to_date(p_start_date), p_frequency, to_number(nvl(p_period,0)));
1075: end if;

Line 1074: l_end_date := get_end_date(FND_DATE.canonical_to_date(p_start_date), p_frequency, to_number(nvl(p_period,0)));

1070: if(p_stub_days is not null and p_stub_days <> OKL_API.G_MISS_CHAR) then -- end date for stub entry.
1071: l_end_date := FND_DATE.canonical_to_date(p_start_date) + to_number(p_stub_days);
1072: l_end_date := l_end_date - 1;
1073: else -- end date for level entry.
1074: l_end_date := get_end_date(FND_DATE.canonical_to_date(p_start_date), p_frequency, to_number(nvl(p_period,0)));
1075: end if;
1076: return l_end_date;
1077: EXCEPTION
1078: WHEN OTHERS THEN

Line 1648: l_modified_payments(k).RULE_INFORMATION2 := FND_DATE.date_to_canonical(l_end_date +1);

1644: k := K+1;
1645: --For the second part of the split payment
1646: l_modified_payments(k) := l_payment_struc(j);
1647: --l_modified_payments(k).RULE_INFORMATION2 := to_date(l_end_date +1);
1648: l_modified_payments(k).RULE_INFORMATION2 := FND_DATE.date_to_canonical(l_end_date +1);
1649: -- l_modified_payments(k).RULE_INFORMATION2 := FND_DATE.date_to_canonical(l_end_date);
1650: IF l_stub_pymnt = 'N' THEN --[9]
1651: l_modified_payments(k).rule_information3 := l_lower_period;
1652: IF p_blank_amount = 'Y' THEN

Line 1649: -- l_modified_payments(k).RULE_INFORMATION2 := FND_DATE.date_to_canonical(l_end_date);

1645: --For the second part of the split payment
1646: l_modified_payments(k) := l_payment_struc(j);
1647: --l_modified_payments(k).RULE_INFORMATION2 := to_date(l_end_date +1);
1648: l_modified_payments(k).RULE_INFORMATION2 := FND_DATE.date_to_canonical(l_end_date +1);
1649: -- l_modified_payments(k).RULE_INFORMATION2 := FND_DATE.date_to_canonical(l_end_date);
1650: IF l_stub_pymnt = 'N' THEN --[9]
1651: l_modified_payments(k).rule_information3 := l_lower_period;
1652: IF p_blank_amount = 'Y' THEN
1653: l_modified_payments(k).rule_information6 := 0; --Set amount to Zero

Line 2145: l_modified_payments(k).RULE_INFORMATION2 := FND_DATE.date_to_canonical(l_end_date +1);

2141: k := K+1;
2142: --For the second part of the split payment
2143: l_modified_payments(k) := l_payment_struc(j);
2144: --l_modified_payments(k).RULE_INFORMATION2 := to_date(l_end_date +1);
2145: l_modified_payments(k).RULE_INFORMATION2 := FND_DATE.date_to_canonical(l_end_date +1);
2146: IF l_stub_pymnt = 'N' THEN --[9]
2147: l_modified_payments(k).rule_information3 := l_lower_period;
2148:
2149: --dkagrawa modified the logic to calculate the amount for bug#5203265

Line 5873: lp_cafv_rec.start_date := FND_DATE.canonical_to_date(

5869: lp_cafv_rec.sts_code := G_PROPOSED_STATUS;
5870: lp_cafv_rec.sty_id := l_sty_id;
5871: lp_cafv_rec.cft_code := G_CASH_FLOW_TYPE;
5872: lp_cafv_rec.due_arrears_yn := nvl(p_payment_structure(i).rule_information10,'N');
5873: lp_cafv_rec.start_date := FND_DATE.canonical_to_date(
5874: p_payment_structure(i).rule_information2);
5875: lp_cafv_rec.number_of_advance_periods := p_payment_structure(i).rule_information5;
5876: lp_cafv_rec.dnz_khr_id := p_ppd_khr_id;
5877: lp_cafv_rec.dnz_qte_id := p_ppd_request_id;

Line 5910: lp_cafv_rec.start_date := FND_DATE.canonical_to_date(

5906: lp_cafv_rec.sts_code := G_PROPOSED_STATUS;
5907: lp_cafv_rec.sty_id := l_sty_id;
5908: lp_cafv_rec.cft_code := G_CASH_FLOW_TYPE;
5909: lp_cafv_rec.due_arrears_yn := nvl(p_payment_structure(i).rule_information10,'N');
5910: lp_cafv_rec.start_date := FND_DATE.canonical_to_date(
5911: p_payment_structure(i).rule_information2);
5912: lp_cafv_rec.number_of_advance_periods := p_payment_structure(i).rule_information5;
5913: lp_cafv_rec.dnz_khr_id := p_ppd_khr_id;
5914: lp_cafv_rec.dnz_qte_id := p_ppd_request_id;

Line 5940: OPEN l_cfl_id_csr(l_caf_id, FND_DATE.canonical_to_date(

5936:
5937: --Now create the Cash flow lines
5938: --check if a cash flow line exists of this type.
5939: l_cfl_id := NULL;
5940: OPEN l_cfl_id_csr(l_caf_id, FND_DATE.canonical_to_date(
5941: p_payment_structure(i).rule_information2));
5942: FETCH l_cfl_id_csr INTO l_cfl_id;
5943: CLOSE l_cfl_id_csr;
5944:

Line 5966: lp_cflv_rec.start_date := FND_DATE.canonical_to_date(

5962: lp_cflv_rec.fqy_code := p_payment_structure(i).object1_id1;
5963: END IF;
5964:
5965: lp_cflv_rec.level_sequence := p_payment_structure(i).rule_information1;
5966: lp_cflv_rec.start_date := FND_DATE.canonical_to_date(
5967: p_payment_structure(i).rule_information2);
5968:
5969:
5970: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 6011: lp_cflv_rec.start_date := FND_DATE.canonical_to_date(

6007: lp_cflv_rec.fqy_code := p_payment_structure(i).object1_id1;
6008: END IF;
6009:
6010: lp_cflv_rec.level_sequence := p_payment_structure(i).rule_information1;
6011: lp_cflv_rec.start_date := FND_DATE.canonical_to_date(
6012: p_payment_structure(i).rule_information2);
6013:
6014:
6015: lp_cflv_rec.id := l_cfl_id;

Line 6330: l_payment_tbl(knt).start_date := FND_DATE.canonical_to_date(p_payment_structure(i).rule_information2);

6326: IF p_payment_structure(i).rule_information_category = 'LASLL' THEN
6327: l_payment_tbl(knt).khr_id := p_payment_Structure(i).chr_id;
6328: l_payment_tbl(knt).kle_id := p_payment_structure(i).cle_id;
6329: l_payment_tbl(knt).sty_id := l_pp_sty_id;
6330: l_payment_tbl(knt).start_date := FND_DATE.canonical_to_date(p_payment_structure(i).rule_information2);
6331: l_payment_tbl(knt).periods := p_payment_structure(i).rule_information3;
6332: l_payment_tbl(knt).frequency := p_payment_structure(i).object1_id1;
6333: l_payment_tbl(knt).arrears_yn := p_payment_structure(i).rule_information10;
6334: l_payment_tbl(knt).amount := p_payment_structure(i).rule_information6;

Line 6609: p_payment_struc(i).RULE_INFORMATION2 := fnd_date.date_to_canonical(cur_rec.start_date);

6605:
6606: --Now populate LASLLs
6607: p_payment_struc(i).chr_id := cur_rec.dnz_khr_id;
6608: p_payment_struc(i).cle_id := cur_rec.kle_id;
6609: p_payment_struc(i).RULE_INFORMATION2 := fnd_date.date_to_canonical(cur_rec.start_date);
6610: p_payment_struc(i).RULE_INFORMATION3 := cur_rec.number_of_periods;
6611: --This will Null for Stubs,but we need to pass a value,
6612: --so passing zero
6613: p_payment_struc(i).RULE_INFORMATION5 := NVL(cur_rec.advance_payments,0); --Adv Period