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

Line 2639: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7));

2635: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
2636: l_recurrence_day := NULL;
2637: IF(l_arrears = 'Y') THEN
2638: IF l_arrears_pay_dates_option = 'FIRST_DAY_OF_NEXT_PERIOD' THEN
2639: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7));
2640: ELSE
2641: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7))-1;
2642: END IF;
2643: ELSE

Line 2641: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7))-1;

2637: IF(l_arrears = 'Y') THEN
2638: IF l_arrears_pay_dates_option = 'FIRST_DAY_OF_NEXT_PERIOD' THEN
2639: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7));
2640: ELSE
2641: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7))-1;
2642: END IF;
2643: ELSE
2644: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2));
2645: END IF;

Line 2644: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2));

2640: ELSE
2641: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7))-1;
2642: END IF;
2643: ELSE
2644: l_payment_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2));
2645: END IF;
2646:
2647: IF (l_payment_date >= NVL(p_prev_payout_date,l_payment_date)) AND
2648: (l_payment_date < p_payout_date) THEN

Line 2655: l_recurrence_day := TO_CHAR(TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)), 'DD');

2651: EXIT;
2652: END IF;
2653: ELSE
2654: IF(l_recurrence_day IS NULL) THEN
2655: l_recurrence_day := TO_CHAR(TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)), 'DD');
2656: END IF;
2657:
2658: l_num_of_periods := TO_NUMBER(l_rl_rec.RULE_INFORMATION3);
2659: l_period_start_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2));

Line 2659: l_period_start_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2));

2655: l_recurrence_day := TO_CHAR(TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2)), 'DD');
2656: END IF;
2657:
2658: l_num_of_periods := TO_NUMBER(l_rl_rec.RULE_INFORMATION3);
2659: l_period_start_date := TRUNC(FND_DATE.canonical_to_date(l_rl_rec.rule_information2));
2660: FOR k in 1 .. l_num_of_periods
2661: LOOP
2662: IF(l_arrears = 'Y') THEN
2663: l_payment_date := Okl_Lla_Util_Pvt.calculate_end_date(

Line 3071: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,

3067: CURSOR c_inflows
3068: IS
3069: SELECT rgp.cle_id cle_id,
3070: TO_NUMBER(rul1.object1_id1) sty_id,
3071: FND_DATE.canonical_to_date(rul2.rule_information2) start_date,
3072: TO_NUMBER(rul2.rule_information3) periods,
3073: -- srsreeni Bug 5917582 start
3074: TO_NUMBER(rul2.rule_information7) stub_days,
3075: TO_NUMBER(rul2.rule_information8) stub_amount,

Line 3102: ORDER BY cle_id,sty_id, FND_DATE.canonical_to_date(rul2.rule_information2);

3098: AND kle.fee_type = 'PASSTHROUGH'
3099: AND cle.id = kle.id
3100: AND cle.lse_id = lse.id
3101: --srsreeni bug 5869271 start add
3102: ORDER BY cle_id,sty_id, FND_DATE.canonical_to_date(rul2.rule_information2);
3103: --srsreeni bug 5869271 end add
3104: -- To get the streams information
3105: CURSOR l_stmp_yn_csr(khrid NUMBER, p VARCHAR2) IS
3106: SELECT 'Y' What

Line 6182: fnd_date.canonical_to_date(crl.RULE_INFORMATION2) START_DATE,

6178: --This cursor fetches the details of the payment plan the would be used in the Advance Rent Calculation
6179: CURSOR l_payment_csr(chrId NUMBER , styId NUMBER,kleId NUMBER)
6180: IS
6181: SELECT (NVL(crl.rule_information5,-1)) structure,
6182: fnd_date.canonical_to_date(crl.RULE_INFORMATION2) START_DATE,
6183: crl.RULE_INFORMATION3 PERIOD_IN_MONTHS,
6184: crl.RULE_INFORMATION6 AMOUNT,
6185: nvl(crl.RULE_INFORMATION10,'N') ARREARS,
6186: crl.RULE_INFORMATION7 STUB_DAYS,

Line 10158: SELECT FND_DATE.canonical_to_date(rule_information5) date_returned

10154: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
10155: x NUMBER := 0;
10156:
10157: CURSOR c_deposit_date( chrId NUMBER) IS
10158: SELECT FND_DATE.canonical_to_date(rule_information5) date_returned
10159: FROM okc_rules_b
10160: WHERE dnz_chr_id = chrId
10161: AND rule_information_category = 'LASDEP';
10162:

Line 10325: px_csm_one_off_fee_tbl(l).date_start := FND_DATE.canonical_to_date(l_rl_rec1.RULE_INFORMATION2);

10321: px_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec1.RULE_INFORMATION6,'0'));
10322: IF(l_rl_rec1.RULE_INFORMATION2 IS NULL or l_rl_rec1.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) Then
10323: px_csm_one_off_fee_tbl(l).date_start := l_lne_rec1.start_date ;
10324: ELSE
10325: px_csm_one_off_fee_tbl(l).date_start := FND_DATE.canonical_to_date(l_rl_rec1.RULE_INFORMATION2);
10326: END IF;
10327:
10328: OPEN c_deposit_date ( TO_NUMBER(p_chr_id) );
10329: FETCH c_deposit_date INTO l_c_deposit_date;

Line 11148: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);

11144: AND crg.rgd_code = rgcode
11145: AND crl.rule_information_category = rlcat
11146: AND crg.dnz_chr_id = chrId
11147: AND crg.cle_id = cleId
11148: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
11149:
11150: -- nikshah -- Bug # 5484903 Fixed
11151: -- Removed CURSOR c_finance_strm_csr (payment_type_id NUMBER, p_chr_id NUMBER)
11152:

Line 11512: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

11508: k := k + 1;
11509: idx := idx + 1;
11510: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
11511: px_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
11512: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
11513: px_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
11514: px_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
11515: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
11516: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_linked_asset_line_rec.id;

Line 11581: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

11577: --11-Sep-09 sechawla 8798556
11578: --px_csm_periodic_expenses_tbl(k).date_start:=l_hdr_rec.start_date;
11579: px_csm_periodic_expenses_tbl(k).date_start:= l_linked_asset_line_rec.start_date;
11580: ELSE
11581: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
11582: END IF;
11583: END IF;
11584:
11585: END LOOP;-- end-loop: l_rl_rec

Line 11633: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

11629: k := k + 1;
11630: idx := idx + 1;
11631: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
11632: px_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
11633: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
11634: px_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
11635: px_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
11636: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
11637: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;

Line 11702: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

11698: --11-Sep-09 sechawla 8798556
11699: --px_csm_periodic_expenses_tbl(k).date_start:=l_hdr_rec.start_date;
11700: px_csm_periodic_expenses_tbl(k).date_start:= l_lne_rec.start_date;
11701: ELSE
11702: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
11703: END IF;
11704: END IF;
11705:
11706: END LOOP;

Line 12041: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

12037: k := k + 1;
12038: idx := idx + 1;
12039: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
12040: px_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
12041: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
12042: px_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
12043: px_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
12044: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
12045: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 12109: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

12105: --11-Sep-09 sechawla 8798556
12106: --px_csm_periodic_expenses_tbl(k).date_start:=l_hdr_rec.start_date;
12107: px_csm_periodic_expenses_tbl(k).date_start:=l_linked_asset_line_rec.start_date;
12108: ELSE
12109: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
12110: END IF;
12111: END IF;
12112: END LOOP; -- END-FOR-LOOP: l_rl_csr
12113: Else -- l_rl_csr2%NOTFOUND

Line 12419: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

12415: k := k + 1;
12416: idx := idx + 1;
12417: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
12418: px_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
12419: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
12420: px_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
12421: px_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
12422: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
12423: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 12487: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

12483: --11-Sep-09 sechawla 8798556
12484: --px_csm_periodic_expenses_tbl(k).date_start:=l_hdr_rec.start_date;
12485: px_csm_periodic_expenses_tbl(k).date_start:= l_lne_rec.start_date;
12486: ELSE
12487: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
12488: END IF;
12489: END IF;
12490: END LOOP; -- END-FOR-LOOP: l_rl_csr
12491: Else -- l_rl_csr2%NOTFOUND

Line 12653: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

12649: k := k + 1;
12650: idx := idx + 1;
12651: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
12652: px_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
12653: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
12654: px_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
12655: px_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
12656: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
12657: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 12722: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

12718: --11-Sep-09 sechawla 8798556
12719: --px_csm_periodic_expenses_tbl(k).date_start:=l_hdr_rec.start_date;
12720: px_csm_periodic_expenses_tbl(k).date_start:= l_linked_asset_line_rec.start_date;
12721: ELSE
12722: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
12723: END IF;
12724: END IF;
12725: END LOOP;
12726:

Line 12807: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

12803: k := k + 1;
12804: idx := idx + 1;
12805: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
12806: px_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
12807: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
12808: px_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
12809: px_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
12810: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
12811: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 12876: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

12872: --11-Sep-09 sechawla 8798556
12873: --px_csm_periodic_expenses_tbl(k).date_start:=l_hdr_rec.start_date;
12874: px_csm_periodic_expenses_tbl(k).date_start:=l_lne_rec.start_date;
12875: ELSE
12876: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
12877: END IF;
12878: END IF;
12879: END LOOP;
12880:

Line 12997: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

12993: k := k + 1;
12994: idx := idx + 1;
12995: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
12996: px_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
12997: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
12998: px_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
12999: px_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
13000: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
13001: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 13067: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

13063: --11-Sep-09 sechawla 8798556
13064: --px_csm_periodic_expenses_tbl(k).date_start:=l_hdr_rec.start_date;
13065: px_csm_periodic_expenses_tbl(k).date_start:= link_rollover_rec.start_date;
13066: ELSE
13067: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
13068: END IF;
13069: END IF;
13070: END LOOP;
13071: END IF;

Line 13152: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

13148: k := k + 1;
13149: idx := idx + 1;
13150: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
13151: px_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
13152: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
13153: px_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
13154: px_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
13155: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
13156: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 13222: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

13218: --11-Sep-09 sechawla 8798556
13219: --px_csm_periodic_expenses_tbl(k).date_start:=l_hdr_rec.start_date;
13220: px_csm_periodic_expenses_tbl(k).date_start:= l_lne_rec.start_date;
13221: ELSE
13222: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
13223: END IF;
13224: END IF;
13225: END LOOP;
13226: END IF;

Line 13588: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

13584: k := k + 1;
13585: idx := idx + 1;
13586: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
13587: px_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
13588: px_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
13589: px_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
13590: px_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
13591: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
13592: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 13658: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

13654: --11-Sep-09 sechawla 8798556
13655: --px_csm_periodic_expenses_tbl(k).date_start:=l_hdr_rec.start_date;
13656: px_csm_periodic_expenses_tbl(k).date_start:=l_lne_rec.start_date;
13657: ELSE
13658: px_csm_periodic_expenses_tbl(k).date_start:=FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
13659: END IF;
13660: END IF;
13661:
13662: -- RGOOTY: Bug 7552496: Start

Line 13672: px_csm_periodic_expenses_tbl(k).date_paid := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

13668: IF(l_rl_rec.rule_information2 IS NULL OR
13669: l_rl_rec.rule_information2 = OKL_API.G_MISS_CHAR) THEN
13670: px_csm_periodic_expenses_tbl(k).date_paid := l_hdr_rec.start_date;
13671: ELSE
13672: px_csm_periodic_expenses_tbl(k).date_paid := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
13673: END IF;
13674: END IF;
13675: -- RGOOTY: Bug 7552496: End
13676:

Line 14329: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

14325: j := j + 1;
14326: idx := idx + 1;
14327: l_csm_line_details_tbl(j).level_index_number := idx;
14328: l_csm_line_details_tbl(j).amount := TO_NUMBER(l_rl_rec.rule_information8);
14329: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
14330: l_csm_line_details_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
14331: l_csm_line_details_tbl(j).period := g_stub_rec.period;
14332: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
14333: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;

Line 14387: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

14383: l_csm_line_details_tbl(j).description := l_strm_name;
14384: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14385: --Modified by kthiruva on 09-Dec-2005 for the VR build
14386: --Bug 4766555 - Start of Changes
14387: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
14388: --Bug 4766555 - End of Changes
14389: l_csm_line_details_tbl(j).level_index_number := idx;
14390: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
14391: l_csm_line_details_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));

Line 14613: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

14609: j := j + 1;
14610: idx := idx + 1;
14611: l_csm_line_details_tbl(j).level_index_number := idx;
14612: l_csm_line_details_tbl(j).amount := TO_NUMBER(l_rl_rec.rule_information8);
14613: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
14614: l_csm_line_details_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
14615: l_csm_line_details_tbl(j).period := g_stub_rec.period;
14616: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;
14617: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;

Line 14675: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

14671: l_csm_line_details_tbl(j).description := l_strm_name;
14672: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14673: --Modified by kthiruva on 09-Dec-2005 for the VR build
14674: --Bug 4766555 - Start of Changes
14675: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
14676: --Bug 4766555 - End of Changes
14677: l_csm_line_details_tbl(j).level_index_number := idx;
14678: --Modified by kthiruva on 09-Nov-2005.The level type should be
14679: --set as PRINCIPAL as the payment type is PRINCIPAL_PAYMENT

Line 14777: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

14773: -- idx := idx + 1; bug6245602
14774: idx_exp := idx_exp + 1; -- bug6245602
14775: l_csm_periodic_expenses_tbl(k).level_index_number := idx_exp; -- bug6245602
14776: l_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
14777: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
14778: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
14779: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
14780: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
14781: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 14849: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

14845: --l_csm_periodic_expenses_tbl(k).date_start := l_hdr_rec.start_date;
14846: l_csm_periodic_expenses_tbl(k).date_start := l_line_rec.start_date;
14847:
14848: ELSE
14849: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
14850: END IF;
14851: END IF;
14852: END LOOP;
14853: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 14880: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+l_rl_rec.rule_information7;

14876: -- idx := idx + 1; bug6245602
14877: idx_exp := idx_exp + 1; -- bug6245602
14878: l_csm_periodic_expenses_tbl(k).level_index_number := idx_exp;
14879: l_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
14880: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+l_rl_rec.rule_information7;
14881: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
14882: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
14883: l_csm_periodic_expenses_tbl(k).advance_or_arrears := g_stub_rec.advance_or_arrears;
14884: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;

Line 14961: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

14957: --sechawla 11-sep-09 8798556
14958: --l_csm_periodic_expenses_tbl(k).date_start := l_hdr_rec.start_date;
14959: l_csm_periodic_expenses_tbl(k).date_start := l_line_rec.start_date;
14960: ELSE
14961: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
14962: END IF;
14963: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
14964: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
14965: ELSE

Line 14988: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

14984: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14985: If(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) Then
14986: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
14987: Else
14988: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
14989: End If;
14990: l_csm_one_off_fee_tbl(l).kle_asset_id := l_line_rec.id;
14991:
14992: --sechawla 16-Jul-09 PRB ESG Enhancements : assign orig_contract_line_id

Line 15719: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

15715: IF (l_rl_rec.rule_information7 IS NOT NULL OR
15716: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
15717: (l_rl_rec.rule_information8 IS NOT NULL OR
15718: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
15719: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
15720: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));
15721: l_ppd_tbl(l_ppd_count).curr_paydown := 'N';
15722: l_ppd_count := l_ppd_count + 1;
15723: END IF;

Line 15824: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

15820: --Bug 4964710 - Start of Changes
15821: --============================================================================================
15822: --Step 1 : If payment is in Arrears created the PPD stub First
15823: --============================================================================================
15824: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
15825: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
15826: AND (l_rl_rec.RULE_INFORMATION10 IS NOT NULL) THEN
15827: j := j + 1;
15828: idx := idx + 1;

Line 15825: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)

15821: --============================================================================================
15822: --Step 1 : If payment is in Arrears created the PPD stub First
15823: --============================================================================================
15824: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
15825: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
15826: AND (l_rl_rec.RULE_INFORMATION10 IS NOT NULL) THEN
15827: j := j + 1;
15828: idx := idx + 1;
15829: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 15887: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

15883: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
15884: THEN
15885: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
15886: ELSE
15887: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
15888: END IF;
15889: l_csm_line_details_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
15890: l_csm_line_details_tbl(j).period := g_stub_rec.period;
15891: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;

Line 15936: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

15932: --Step 3 : IF the Payment is Advance then the PPD stub is created after the existing stub
15933: --=======================================================================================
15934: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
15935: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
15936: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
15937: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
15938: AND (l_rl_rec.RULE_INFORMATION10 IS NULL) THEN
15939: j := j + 1;
15940: idx := idx + 1;

Line 15937: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)

15933: --=======================================================================================
15934: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
15935: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
15936: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
15937: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
15938: AND (l_rl_rec.RULE_INFORMATION10 IS NULL) THEN
15939: j := j + 1;
15940: idx := idx + 1;
15941: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 15962: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

15958: l_ppd_assigned := 'Y';
15959: ELSE
15960: l_csm_line_details_tbl(j).amount := l_ppd_tbl(k).paydown_amount;
15961: END IF;
15962: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
15963: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
15964: l_csm_line_details_tbl(j).level_index_number := idx;
15965: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
15966: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;

Line 15998: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

15994: (l_rl_rec.rule_information8 IS NULL OR
15995: l_rl_rec.rule_information8 = OKL_API.G_MISS_CHAR) THEN
15996:
15997: --When there is no PPD in the range of the periodic payment, the payment is retained as is
15998: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
15999: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
16000: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16001: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
16002:

Line 15999: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))

15995: l_rl_rec.rule_information8 = OKL_API.G_MISS_CHAR) THEN
15996:
15997: --When there is no PPD in the range of the periodic payment, the payment is retained as is
15998: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
15999: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
16000: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16001: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
16002:
16003: j := j + 1;

Line 16000: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

15996:
15997: --When there is no PPD in the range of the periodic payment, the payment is retained as is
15998: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
15999: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
16000: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16001: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
16002:
16003: j := j + 1;
16004: idx := idx + 1;

Line 16001: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /chk date cols/

15997: --When there is no PPD in the range of the periodic payment, the payment is retained as is
15998: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
15999: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
16000: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16001: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
16002:
16003: j := j + 1;
16004: idx := idx + 1;
16005: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;

Line 16014: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;

16010: end if;
16011:
16012: l_csm_line_details_tbl(j).description := l_strm_name;
16013: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16014: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
16015: l_csm_line_details_tbl(j).level_index_number := idx;
16016: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
16017: l_csm_line_details_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
16018:

Line 16054: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

16050:
16051: ELSE
16052:
16053: FOR k in l_ppd_tbl.FIRST .. l_ppd_tbl.LAST LOOP
16054: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16055: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN /*chk date cols*/
16056: --=============================================================
16057: --Step 1 : Obtaining the number of periods prior to the paydown
16058: --=============================================================

Line 16055: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN /chk date cols/

16051: ELSE
16052:
16053: FOR k in l_ppd_tbl.FIRST .. l_ppd_tbl.LAST LOOP
16054: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16055: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN /*chk date cols*/
16056: --=============================================================
16057: --Step 1 : Obtaining the number of periods prior to the paydown
16058: --=============================================================
16059: l_number_periods_remaining := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term)) ;

Line 16064: l_number_periods_completed := trunc (months_between(l_ppd_tbl(k).paydown_date, FND_DATE.canonical_to_date(l_rl_rec.rule_information2)) / l_rl_rec.decoded_object1_id1,0);

16060: --Modified by kthiruva on 12-Dec-2005
16061: --Instead of round, the function trunc needs to be used as we want the number
16062: --of periods elapsed completely
16063: --Bug 4878162 - Start of Changes
16064: l_number_periods_completed := trunc (months_between(l_ppd_tbl(k).paydown_date, FND_DATE.canonical_to_date(l_rl_rec.rule_information2)) / l_rl_rec.decoded_object1_id1,0);
16065: --Bug 4878162 - End of Changes
16066:
16067: IF l_number_periods_completed = 0 THEN
16068: l_number_periods_completed_cpy := 0;

Line 16091: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;

16087: end if;
16088:
16089: l_csm_line_details_tbl(j).description := l_strm_name;
16090: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16091: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
16092: l_csm_line_details_tbl(j).level_index_number := idx;
16093: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
16094:
16095: IF l_number_periods_completed_cpy = 0 THEN

Line 16146: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

16142: --Bug 4964710 - Start of Changes
16143: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
16144: THEN
16145: --Calculating the days between the Paydown date and the due date of the next periodic payment
16146: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
16147: l_days_between := l_adjusting_stub_date - l_ppd_tbl(k).paydown_date;
16148:
16149: --Checking to see if 2 PPD's lie inside a single period.If so, no adjusting stub and
16150: --line for remaining payments are created.

Line 16238: l_csm_line_details_tbl(j).date_start := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

16234: l_csm_line_details_tbl(j).amount := l_ppd_tbl(k).paydown_amount;
16235: END IF;
16236: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
16237: THEN
16238: l_csm_line_details_tbl(j).date_start := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
16239: ELSE
16240: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
16241: END IF;
16242: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;

Line 16272: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

16268: --Bug 4964710 - Start of Changes
16269: IF (l_rl_rec.RULE_INFORMATION10 IS NOT NULL)
16270: THEN
16271: --Calculating the days between the Paydown date and the due date of the next periodic payment
16272: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
16273: l_days_between := l_adjusting_stub_date - l_ppd_tbl(k).paydown_date;
16274:
16275: --Checking to see if 2 PPD's lie inside a single period.If so, no adjusting stub and
16276: --line for remaining payments are created.

Line 16337: l_period_end_date := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3);

16333:
16334: --The periods between the end date of the adjusting stub and the next PPD is calculated
16335: --If number of periods > 0, then a payment line for that many periods needs to be created.
16336: IF k = l_ppd_tbl.LAST THEN
16337: l_period_end_date := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3);
16338: ELSE
16339: l_period_end_date := l_ppd_tbl(k+1).paydown_date;
16340: END IF;
16341: --Modified by kthiruva on 12-Dec-2005

Line 16369: l_csm_line_details_tbl(j).date_start := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) ;

16365: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
16366: l_csm_line_details_tbl(j).level_index_number := idx;
16367: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
16368: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
16369: l_csm_line_details_tbl(j).date_start := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) ;
16370: l_csm_line_details_tbl(j).rate := l_variable_rate;
16371: --When l_ppd_assigned is 'Y', the PPD stub has already been created. And therefore
16372: --for the subsequent stubs we lock only the Rate.The amount is unlocked as we are
16373: --solving for the new payment plan.

Line 16517: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

16513: IF (l_rl_rec.rule_information7 IS NOT NULL OR
16514: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
16515: (l_rl_rec.rule_information8 IS NOT NULL OR
16516: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
16517: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
16518: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));
16519: l_ppd_tbl(l_ppd_count).curr_paydown := 'N';
16520: l_ppd_count := l_ppd_count + 1;
16521: END IF;

Line 16621: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

16617: --Bug 4964710 - Start of Changes
16618: --============================================================================================
16619: --Step 1 : If payment is in Arrears created the PPD stub First
16620: --============================================================================================
16621: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16622: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
16623: AND (l_rl_rec.RULE_INFORMATION10 IS NOT NULL) THEN
16624: j := j + 1;
16625: idx := idx + 1;

Line 16622: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)

16618: --============================================================================================
16619: --Step 1 : If payment is in Arrears created the PPD stub First
16620: --============================================================================================
16621: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16622: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
16623: AND (l_rl_rec.RULE_INFORMATION10 IS NOT NULL) THEN
16624: j := j + 1;
16625: idx := idx + 1;
16626: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 16684: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

16680: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
16681: THEN
16682: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
16683: ELSE
16684: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
16685: END IF;
16686: l_csm_line_details_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
16687: l_csm_line_details_tbl(j).period := g_stub_rec.period;
16688: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;

Line 16733: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

16729: --Step 3 : IF the Payment is Advance then the PPD stub is created after the existing stub
16730: --=======================================================================================
16731: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
16732: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
16733: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16734: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
16735: AND (l_rl_rec.RULE_INFORMATION10 IS NULL) THEN
16736: j := j + 1;
16737: idx := idx + 1;

Line 16734: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)

16730: --=======================================================================================
16731: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
16732: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
16733: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16734: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
16735: AND (l_rl_rec.RULE_INFORMATION10 IS NULL) THEN
16736: j := j + 1;
16737: idx := idx + 1;
16738: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 16759: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

16755: l_ppd_assigned := 'Y';
16756: ELSE
16757: l_csm_line_details_tbl(j).amount := l_ppd_tbl(k).paydown_amount;
16758: END IF;
16759: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
16760: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
16761: l_csm_line_details_tbl(j).level_index_number := idx;
16762: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
16763: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;

Line 16794: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

16790: (l_rl_rec.rule_information8 IS NULL OR
16791: l_rl_rec.rule_information8 = OKL_API.G_MISS_CHAR) THEN
16792:
16793: --When there is no PPD in the range of the periodic payment, the payment is retained as is
16794: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16795: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
16796: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16797: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
16798:

Line 16795: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))

16791: l_rl_rec.rule_information8 = OKL_API.G_MISS_CHAR) THEN
16792:
16793: --When there is no PPD in the range of the periodic payment, the payment is retained as is
16794: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16795: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
16796: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16797: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
16798:
16799: j := j + 1;

Line 16796: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

16792:
16793: --When there is no PPD in the range of the periodic payment, the payment is retained as is
16794: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16795: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
16796: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16797: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
16798:
16799: j := j + 1;
16800: idx := idx + 1;

Line 16797: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /chk date cols/

16793: --When there is no PPD in the range of the periodic payment, the payment is retained as is
16794: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16795: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
16796: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16797: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
16798:
16799: j := j + 1;
16800: idx := idx + 1;
16801: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;

Line 16810: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;

16806: end if;
16807:
16808: l_csm_line_details_tbl(j).description := l_strm_name;
16809: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16810: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
16811: l_csm_line_details_tbl(j).level_index_number := idx;
16812: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;
16813: l_csm_line_details_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
16814:

Line 16850: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

16846:
16847: ELSE
16848:
16849: FOR k in l_ppd_tbl.FIRST .. l_ppd_tbl.LAST LOOP
16850: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16851: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN
16852: --=============================================================
16853: --Step 1 : Obtaining the number of periods prior to the paydown
16854: --=============================================================

Line 16851: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN

16847: ELSE
16848:
16849: FOR k in l_ppd_tbl.FIRST .. l_ppd_tbl.LAST LOOP
16850: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
16851: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN
16852: --=============================================================
16853: --Step 1 : Obtaining the number of periods prior to the paydown
16854: --=============================================================
16855: l_number_periods_remaining := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term)) ;

Line 16859: l_number_periods_completed := trunc (months_between(l_ppd_tbl(k).paydown_date, FND_DATE.canonical_to_date(l_rl_rec.rule_information2)) / l_rl_rec.decoded_object1_id1,0);

16855: l_number_periods_remaining := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term)) ;
16856: --Modified by kthiruva on 12-Dec-2005
16857: --Use trunc instead of round as we need the number of periods elapsed completely
16858: --Bug 4878162 - Start of Changes
16859: l_number_periods_completed := trunc (months_between(l_ppd_tbl(k).paydown_date, FND_DATE.canonical_to_date(l_rl_rec.rule_information2)) / l_rl_rec.decoded_object1_id1,0);
16860: --Bug 4878162 - End of Changes
16861:
16862:
16863: IF l_number_periods_completed = 0 THEN

Line 16887: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;

16883: end if;
16884:
16885: l_csm_line_details_tbl(j).description := l_strm_name;
16886: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16887: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
16888: l_csm_line_details_tbl(j).level_index_number := idx;
16889: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;
16890:
16891: IF l_number_periods_completed_cpy = 0 THEN

Line 16942: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

16938: --Bug 4964710 - Start of Changes
16939: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
16940: THEN
16941: --Calculating the days between the Paydown date and the due date of the next periodic payment
16942: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
16943: l_days_between := l_adjusting_stub_date - l_ppd_tbl(k).paydown_date;
16944:
16945: --Checking to see if 2 PPD's lie inside a single period.If so, no adjusting stub and
16946: --line for remaining payments are created.

Line 17034: l_csm_line_details_tbl(j).date_start := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

17030: l_csm_line_details_tbl(j).amount := l_ppd_tbl(k).paydown_amount;
17031: END IF;
17032: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
17033: THEN
17034: l_csm_line_details_tbl(j).date_start := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
17035: ELSE
17036: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
17037: END IF;
17038: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;

Line 17070: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

17066: --Bug 4964710 - Start of Changes
17067: IF (l_rl_rec.RULE_INFORMATION10 IS NOT NULL)
17068: THEN
17069: --Calculating the days between the Paydown date and the due date of the next periodic payment
17070: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
17071: l_days_between := l_adjusting_stub_date - l_ppd_tbl(k).paydown_date;
17072:
17073: --Checking to see if 2 PPD's lie inside a single period.If so, no adjusting stub and
17074: --line for remaining payments are created.

Line 17135: l_period_end_date := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3);

17131:
17132: --The periods between the end date of the adjusting stub and the next PPD is calculated
17133: --If number of periods > 0, then a payment line for that many periods needs to be created.
17134: IF k = l_ppd_tbl.LAST THEN
17135: l_period_end_date := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3);
17136: ELSE
17137: l_period_end_date := l_ppd_tbl(k+1).paydown_date;
17138: END IF;
17139: --Modified by kthiruva on 12-Dec-2005

Line 17166: l_csm_line_details_tbl(j).date_start := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) ;

17162: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
17163: l_csm_line_details_tbl(j).level_index_number := idx;
17164: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
17165: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
17166: l_csm_line_details_tbl(j).date_start := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) ;
17167: l_csm_line_details_tbl(j).rate := l_variable_rate;
17168: --When l_ppd_assigned is 'Y', the PPD stub has already been created. And therefore
17169: --for the subsequent stubs we lock only the Rate.The amount is unlocked as we are
17170: --solving for the new payment plan.

Line 17221: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+l_rl_rec.rule_information7;

17217: k := k + 1;
17218: idx := idx + 1;
17219: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
17220: l_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
17221: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+l_rl_rec.rule_information7;
17222: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
17223: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
17224: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
17225:

Line 17300: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

17296: --sechawla 11-sep-09 8798556
17297: --l_csm_periodic_expenses_tbl(k).date_start := l_hdr_rec.start_date;
17298: l_csm_periodic_expenses_tbl(k).date_start := l_line_rec.start_date;
17299: ELSE
17300: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
17301: END IF;
17302: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
17303: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
17304: ELSE

Line 17327: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

17323: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
17324: If(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) Then
17325: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
17326: Else
17327: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
17328: End If;
17329: l_csm_one_off_fee_tbl(l).kle_asset_id := l_line_rec.id;
17330:
17331: --sechawla 16-Jul-09 PRb ESg Enhancements : assign orig_contract_line_id

Line 18001: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

17997: IF (l_rl_rec.rule_information7 IS NOT NULL OR
17998: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
17999: (l_rl_rec.rule_information8 IS NOT NULL OR
18000: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
18001: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
18002: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));
18003: l_ppd_tbl(l_ppd_count).curr_paydown := 'N';
18004: l_ppd_count := l_ppd_count + 1;
18005: END IF;

Line 18098: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

18094: --Bug 4964710 - Start of Changes
18095: --============================================================================================
18096: --Step 1 : If payment is in Arrears created the PPD stub First
18097: --============================================================================================
18098: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18099: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
18100: AND (l_rl_rec.RULE_INFORMATION10 IS NOT NULL) THEN
18101: j := j + 1;
18102: idx := idx + 1;

Line 18099: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)

18095: --============================================================================================
18096: --Step 1 : If payment is in Arrears created the PPD stub First
18097: --============================================================================================
18098: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18099: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
18100: AND (l_rl_rec.RULE_INFORMATION10 IS NOT NULL) THEN
18101: j := j + 1;
18102: idx := idx + 1;
18103: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 18158: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

18154: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
18155: THEN
18156: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
18157: ELSE
18158: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
18159: END IF;
18160: l_csm_line_details_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
18161: l_csm_line_details_tbl(j).period := g_stub_rec.period;
18162: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;

Line 18203: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

18199: --Step 3 : IF the Payment is Advance then the PPD stub is created after the existing stub
18200: --=======================================================================================
18201: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
18202: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
18203: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18204: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
18205: AND (l_rl_rec.RULE_INFORMATION10 IS NULL) THEN
18206: j := j + 1;
18207: idx := idx + 1;

Line 18204: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)

18200: --=======================================================================================
18201: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
18202: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
18203: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18204: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
18205: AND (l_rl_rec.RULE_INFORMATION10 IS NULL) THEN
18206: j := j + 1;
18207: idx := idx + 1;
18208: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 18221: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

18217: end if;
18218:
18219: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
18220: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount (p_amount => l_ppd_tbl(k).paydown_amount, p_currency_code => l_hdr_rec.currency_code);
18221: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
18222: l_csm_line_details_tbl(j).level_index_number := idx;
18223: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
18224: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
18225: --This rate column is relevant for rent payments only in the rebook scenarios

Line 18260: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

18256: (l_rl_rec.rule_information8 IS NULL OR
18257: l_rl_rec.rule_information8 = OKL_API.G_MISS_CHAR) THEN
18258:
18259: --When there is no PPD in the range of the periodic payment, the payment is retained as is
18260: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18261: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
18262: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18263: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
18264:

Line 18261: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))

18257: l_rl_rec.rule_information8 = OKL_API.G_MISS_CHAR) THEN
18258:
18259: --When there is no PPD in the range of the periodic payment, the payment is retained as is
18260: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18261: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
18262: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18263: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
18264:
18265: j := j + 1;

Line 18262: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

18258:
18259: --When there is no PPD in the range of the periodic payment, the payment is retained as is
18260: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18261: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
18262: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18263: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
18264:
18265: j := j + 1;
18266: idx := idx + 1;

Line 18263: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /chk date cols/

18259: --When there is no PPD in the range of the periodic payment, the payment is retained as is
18260: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18261: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
18262: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18263: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
18264:
18265: j := j + 1;
18266: idx := idx + 1;
18267: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;

Line 18276: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;

18272: end if;
18273:
18274: l_csm_line_details_tbl(j).description := l_strm_name;
18275: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount (p_amount => FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0')), p_currency_code => l_hdr_rec.currency_code);
18276: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
18277: l_csm_line_details_tbl(j).level_index_number := idx;
18278: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
18279: l_csm_line_details_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
18280:

Line 18312: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

18308:
18309: ELSE
18310:
18311: FOR k in l_ppd_tbl.FIRST .. l_ppd_tbl.LAST LOOP
18312: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18313: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN /*chk date cols*/
18314: --=============================================================
18315: --Step 1 : Obtaining the number of periods prior to the paydown
18316: --=============================================================

Line 18313: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN /chk date cols/

18309: ELSE
18310:
18311: FOR k in l_ppd_tbl.FIRST .. l_ppd_tbl.LAST LOOP
18312: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18313: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN /*chk date cols*/
18314: --=============================================================
18315: --Step 1 : Obtaining the number of periods prior to the paydown
18316: --=============================================================
18317: l_number_periods_remaining := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term)) ;

Line 18322: l_number_periods_completed := trunc (months_between(l_ppd_tbl(k).paydown_date, FND_DATE.canonical_to_date(l_rl_rec.rule_information2)) / l_rl_rec.decoded_object1_id1,0);

18318: --Modified by kthiruva on 12-Dec-2005
18319: --Instead of round, the function trunc needs to be used as we want the number
18320: --of periods elapsed completely
18321: --Bug 4878162 - Start of Changes
18322: l_number_periods_completed := trunc (months_between(l_ppd_tbl(k).paydown_date, FND_DATE.canonical_to_date(l_rl_rec.rule_information2)) / l_rl_rec.decoded_object1_id1,0);
18323: --Bug 4878162 - End of Changes
18324:
18325: IF l_number_periods_completed = 0 THEN
18326: l_number_periods_completed_cpy := 0;

Line 18349: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;

18345: end if;
18346:
18347: l_csm_line_details_tbl(j).description := l_strm_name;
18348: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount (p_amount => FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0')), p_currency_code => l_hdr_rec.currency_code);
18349: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
18350: l_csm_line_details_tbl(j).level_index_number := idx;
18351: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
18352:
18353: IF l_number_periods_completed_cpy = 0 THEN

Line 18400: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

18396: --Bug 4964710 - Start of Changes
18397: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
18398: THEN
18399: --Calculating the days between the Paydown date and the due date of the next periodic payment
18400: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
18401: l_days_between := l_adjusting_stub_date - l_ppd_tbl(k).paydown_date;
18402:
18403: --Checking to see if 2 PPD's lie inside a single period.If so, no adjusting stub and
18404: --line for remaining payments are created.

Line 18478: l_csm_line_details_tbl(j).date_start := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

18474: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
18475: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount (p_amount => l_ppd_tbl(k).paydown_amount, p_currency_code => l_hdr_rec.currency_code);
18476: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
18477: THEN
18478: l_csm_line_details_tbl(j).date_start := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
18479: ELSE
18480: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
18481: END IF;
18482: l_csm_line_details_tbl(j).level_index_number := idx;

Line 18517: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

18513: --Bug 4964710 - Start of Changes
18514: IF (l_rl_rec.RULE_INFORMATION10 IS NOT NULL)
18515: THEN
18516: --Calculating the days between the Paydown date and the due date of the next periodic payment
18517: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
18518: l_days_between := l_adjusting_stub_date - l_ppd_tbl(k).paydown_date;
18519:
18520: --Checking to see if 2 PPD's lie inside a single period.If so, no adjusting stub and
18521: --line for remaining payments are created.

Line 18579: l_period_end_date := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3);

18575:
18576: --The periods between the end date of the adjusting stub and the next PPD is calculated
18577: --If number of periods > 0, then a payment line for that many periods needs to be created.
18578: IF k = l_ppd_tbl.LAST THEN
18579: l_period_end_date := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3);
18580: ELSE
18581: l_period_end_date := l_ppd_tbl(k+1).paydown_date;
18582: END IF;
18583: --Modified by kthiruva on 12-Dec-2005

Line 18614: l_csm_line_details_tbl(j).date_start := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) ;

18610: --This rate column is relevant for rent payments only in the rebook scenarios
18611: --after a reamort
18612: l_csm_line_details_tbl(j).rate := l_rl_rec.rule_information13;
18613:
18614: l_csm_line_details_tbl(j).date_start := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) ;
18615: --When the cashflow step is a payment line, both amount and rate should not be locked
18616: -- For the PPD stub, the amount should be locked , but rate should be unlocked, as
18617: -- we are solving for rate.
18618: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := G_FALSE;

Line 18764: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

18760: IF (l_rl_rec.rule_information7 IS NOT NULL OR
18761: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
18762: (l_rl_rec.rule_information8 IS NOT NULL OR
18763: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
18764: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
18765: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));
18766: l_ppd_tbl(l_ppd_count).curr_paydown := 'N';
18767: l_ppd_count := l_ppd_count + 1;
18768: END IF;

Line 18860: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

18856: --Bug 4964710 - Start of Changes
18857: --============================================================================================
18858: --Step 1 : If payment is in Arrears created the PPD stub First
18859: --============================================================================================
18860: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18861: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
18862: AND (l_rl_rec.RULE_INFORMATION10 IS NOT NULL) THEN
18863: j := j + 1;
18864: idx := idx + 1;

Line 18861: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)

18857: --============================================================================================
18858: --Step 1 : If payment is in Arrears created the PPD stub First
18859: --============================================================================================
18860: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18861: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
18862: AND (l_rl_rec.RULE_INFORMATION10 IS NOT NULL) THEN
18863: j := j + 1;
18864: idx := idx + 1;
18865: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 18922: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

18918: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
18919: THEN
18920: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
18921: ELSE
18922: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
18923: END IF;
18924: l_csm_line_details_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
18925: l_csm_line_details_tbl(j).period := g_stub_rec.period;
18926: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;

Line 18970: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

18966: --Step 3 : IF the Payment is Advance then the PPD stub is created after the existing stub
18967: --=======================================================================================
18968: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
18969: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
18970: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18971: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
18972: AND (l_rl_rec.RULE_INFORMATION10 IS NULL) THEN
18973: j := j + 1;
18974: idx := idx + 1;

Line 18971: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)

18967: --=======================================================================================
18968: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
18969: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
18970: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
18971: AND l_ppd_tbl(k).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7)
18972: AND (l_rl_rec.RULE_INFORMATION10 IS NULL) THEN
18973: j := j + 1;
18974: idx := idx + 1;
18975: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 18988: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

18984: end if;
18985:
18986: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
18987: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount (p_amount => l_ppd_tbl(k).paydown_amount , p_currency_code => l_hdr_rec.currency_code);
18988: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
18989: l_csm_line_details_tbl(j).level_index_number := idx;
18990: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
18991: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
18992: --When the payment type is Principal, the Base Rate specified in the contract needs to be

Line 19029: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

19025: (l_rl_rec.rule_information8 IS NULL OR
19026: l_rl_rec.rule_information8 = OKL_API.G_MISS_CHAR) THEN
19027:
19028: --When there is no PPD in the range of the periodic payment, the payment is retained as is
19029: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19030: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
19031: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19032: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
19033:

Line 19030: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))

19026: l_rl_rec.rule_information8 = OKL_API.G_MISS_CHAR) THEN
19027:
19028: --When there is no PPD in the range of the periodic payment, the payment is retained as is
19029: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19030: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
19031: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19032: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
19033:
19034: j := j + 1;

Line 19031: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

19027:
19028: --When there is no PPD in the range of the periodic payment, the payment is retained as is
19029: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19030: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
19031: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19032: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
19033:
19034: j := j + 1;
19035: idx := idx + 1;

Line 19032: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /chk date cols/

19028: --When there is no PPD in the range of the periodic payment, the payment is retained as is
19029: IF (l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19030: OR l_ppd_tbl(l_ppd_tbl.FIRST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3))
19031: AND (l_ppd_tbl(l_ppd_tbl.LAST).paydown_date < FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19032: OR l_ppd_tbl(l_ppd_tbl.LAST).paydown_date > get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3)) THEN /*chk date cols*/
19033:
19034: j := j + 1;
19035: idx := idx + 1;
19036: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;

Line 19045: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;

19041: end if;
19042:
19043: l_csm_line_details_tbl(j).description := l_strm_name;
19044: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount (p_amount => FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0')) , p_currency_code => l_hdr_rec.currency_code);
19045: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
19046: l_csm_line_details_tbl(j).level_index_number := idx;
19047: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;
19048: l_csm_line_details_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
19049:

Line 19083: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)

19079:
19080: ELSE
19081:
19082: FOR k in l_ppd_tbl.FIRST .. l_ppd_tbl.LAST LOOP
19083: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19084: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN
19085: --=============================================================
19086: --Step 1 : Obtaining the number of periods prior to the paydown
19087: --=============================================================

Line 19084: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN

19080: ELSE
19081:
19082: FOR k in l_ppd_tbl.FIRST .. l_ppd_tbl.LAST LOOP
19083: IF l_ppd_tbl(k).paydown_date >= FND_DATE.canonical_to_date(l_rl_rec.rule_information2)
19084: AND l_ppd_tbl(k).paydown_date < get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) THEN
19085: --=============================================================
19086: --Step 1 : Obtaining the number of periods prior to the paydown
19087: --=============================================================
19088: l_number_periods_remaining := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term)) ;

Line 19092: l_number_periods_completed := trunc (months_between(l_ppd_tbl(k).paydown_date, FND_DATE.canonical_to_date(l_rl_rec.rule_information2)) / l_rl_rec.decoded_object1_id1,0);

19088: l_number_periods_remaining := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term)) ;
19089: --Modified by kthiruva on 12-Dec-2005
19090: --Use trunc instead of round as we need the number of periods elapsed completely
19091: --Bug 4878162 - Start of Changes
19092: l_number_periods_completed := trunc (months_between(l_ppd_tbl(k).paydown_date, FND_DATE.canonical_to_date(l_rl_rec.rule_information2)) / l_rl_rec.decoded_object1_id1,0);
19093: --Bug 4878162 - End of Changes
19094:
19095:
19096: IF l_number_periods_completed = 0 THEN

Line 19120: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;

19116: end if;
19117:
19118: l_csm_line_details_tbl(j).description := l_strm_name;
19119: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount (p_amount => FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0')) , p_currency_code => l_hdr_rec.currency_code);
19120: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
19121: l_csm_line_details_tbl(j).level_index_number := idx;
19122: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;
19123:
19124: IF l_number_periods_completed_cpy = 0 THEN

Line 19173: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

19169: --Bug 4964710 - Start of Changes
19170: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
19171: THEN
19172: --Calculating the days between the Paydown date and the due date of the next periodic payment
19173: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
19174: l_days_between := l_adjusting_stub_date - l_ppd_tbl(k).paydown_date;
19175:
19176: --Checking to see if 2 PPD's lie inside a single period.If so, no adjusting stub and
19177: --line for remaining payments are created.

Line 19254: l_csm_line_details_tbl(j).date_start := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

19250: l_csm_line_details_tbl(j).description := 'UNSCHEDULED_PRINCIPAL_PAYMENT';
19251: l_csm_line_details_tbl(j).amount := okl_accounting_util.round_amount (p_amount => l_ppd_tbl(k).paydown_amount , p_currency_code => l_hdr_rec.currency_code);
19252: IF (l_rl_rec.RULE_INFORMATION10 IS NULL)
19253: THEN
19254: l_csm_line_details_tbl(j).date_start := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
19255: ELSE
19256: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
19257: END IF;
19258: l_csm_line_details_tbl(j).level_index_number := idx;

Line 19298: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;

19294: --Bug 4964710 - Start of Changes
19295: IF (l_rl_rec.RULE_INFORMATION10 IS NOT NULL)
19296: THEN
19297: --Calculating the days between the Paydown date and the due date of the next periodic payment
19298: l_adjusting_stub_date := add_months(FND_DATE.canonical_to_date(l_rl_rec.rule_information2), (l_number_periods_completed_cpy+1)*l_rl_rec.decoded_object1_id1) ;
19299: l_days_between := l_adjusting_stub_date - l_ppd_tbl(k).paydown_date;
19300:
19301: --Checking to see if 2 PPD's lie inside a single period.If so, no adjusting stub and
19302: --line for remaining payments are created.

Line 19361: l_period_end_date := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3);

19357:
19358: --The periods between the end date of the adjusting stub and the next PPD is calculated
19359: --If number of periods > 0, then a payment line for that many periods needs to be created.
19360: IF k = l_ppd_tbl.LAST THEN
19361: l_period_end_date := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3);
19362: ELSE
19363: l_period_end_date := l_ppd_tbl(k+1).paydown_date;
19364: END IF;
19365: --Modified by kthiruva on 12-Dec-2005

Line 19397: l_csm_line_details_tbl(j).date_start := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) ;

19393: --During the booking scenario, the SLL lines do not contain the rate info.Therefore,
19394: --l_base_Rate needs to be used.
19395: l_csm_line_details_tbl(j).rate := nvl(l_rl_rec.rule_information13,l_base_rate);
19396:
19397: l_csm_line_details_tbl(j).date_start := get_end_date(FND_DATE.canonical_to_date(l_rl_rec.rule_information2),l_rl_rec.OBJECT1_ID1,l_rl_rec.rule_information3) ;
19398: --When the cashflow step is a payment line, both amount and rate should not be locked
19399: -- For the PPD stub, the amount should be locked , but rate should be unlocked, as
19400: -- we are solving for rate.
19401: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := G_FALSE;

Line 19444: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+l_rl_rec.rule_information7;

19440: k := k + 1;
19441: idx := idx + 1;
19442: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
19443: l_csm_periodic_expenses_tbl(k).amount := okl_accounting_util.round_amount (p_amount => TO_NUMBER(l_rl_rec.rule_information8) , p_currency_code => l_hdr_rec.currency_code);
19444: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+l_rl_rec.rule_information7;
19445: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
19446: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
19447: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
19448:

Line 19523: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

19519: --sechawla 11-sep-09 8798556
19520: --l_csm_periodic_expenses_tbl(k).date_start := l_hdr_rec.start_date;
19521: l_csm_periodic_expenses_tbl(k).date_start := l_line_rec.start_date;
19522: ELSE
19523: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
19524: END IF;
19525: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
19526: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
19527: ELSE

Line 19550: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

19546: l_csm_one_off_fee_tbl(l).amount := okl_accounting_util.round_amount (p_amount => FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0')) , p_currency_code => l_hdr_rec.currency_code);
19547: If(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) Then
19548: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
19549: Else
19550: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
19551: End If;
19552: l_csm_one_off_fee_tbl(l).kle_asset_id := l_line_rec.id;
19553:
19554: --sechawla 16-Jul-09 PRB ESG Enhancements : assign orig_contract_line_id

Line 20381: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);

20377: AND crg.rgd_code = rgcode
20378: AND crl.rule_information_category = rlcat
20379: AND crg.dnz_chr_id = chrId
20380: AND crg.cle_id = cleId
20381: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
20382:
20383: --mansrini : Code for VR build
20384: CURSOR get_day_conv_on_contrct
20385: IS

Line 21419: /*IF FND_DATE.canonical_to_date(l_rl_rec.rule_information2) <> l_hdr_rec.start_date AND

21415: idx := 0;
21416: IF( UPPER(TRIM(l_strm_name)) = 'RENT' ) THEN
21417: FOR l_rl_rec in l_sll_csr_lease ( l_rl_rec1.slh_id, 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_line_rec.id ) LOOP
21418: -- Start of Bug#3401024 modification BAKUCHIB
21419: /*IF FND_DATE.canonical_to_date(l_rl_rec.rule_information2) <> l_hdr_rec.start_date AND
21420: lv_diff_date = 'N' AND
21421: idx = 0 THEN
21422: j := j + 1;
21423: idx := idx + 1;

Line 21426: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

21422: j := j + 1;
21423: idx := idx + 1;
21424: l_rents_tbl(j).level_index_number := idx;
21425: l_rents_tbl(j).amount := 0;
21426: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
21427: l_rents_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
21428: l_rents_tbl(j).period := g_stub_rec.period;
21429: l_rents_tbl(j).description := l_strm_name;
21430: l_rents_tbl(j).kle_asset_id := l_line_rec.id;

Line 21473: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

21469: j := j + 1;
21470: idx := idx + 1;
21471: l_rents_tbl(j).level_index_number := idx;
21472: l_rents_tbl(j).amount := TO_NUMBER(l_rl_rec.rule_information8);
21473: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
21474: l_rents_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
21475: l_rents_tbl(j).period := g_stub_rec.period;
21476: l_rents_tbl(j).description := l_strm_name;
21477: l_rents_tbl(j).kle_asset_id := l_line_rec.id;

Line 21563: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

21559: --sechawla 11-sep-09 8798556
21560: --l_rents_tbl(j).date_start := l_hdr_rec.start_date;
21561: l_rents_tbl(j).date_start := l_line_rec.start_date;
21562: ELSE
21563: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
21564: END IF;
21565: l_rents_tbl(j).rate := l_rl_rec.rule_information13;
21566: END IF;
21567: END LOOP;

Line 21577: IF FND_DATE.canonical_to_date(l_rl_rec.rule_information2) <> l_hdr_rec.start_date AND

21573: -- Code for Estimated Property Tax Starts Here
21574: ELSIF( UPPER(TRIM(l_strm_name)) = 'ESTIMATED_PROPERTY_TAX' ) THEN
21575: FOR l_rl_rec in l_sll_csr_lease (l_rl_rec1.slh_id, 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_line_rec.id ) LOOP
21576: /*
21577: IF FND_DATE.canonical_to_date(l_rl_rec.rule_information2) <> l_hdr_rec.start_date AND
21578: lv_diff_date = 'N' AND
21579: idx = 0 THEN
21580: k := k + 1;
21581: idx := idx + 1;

Line 21584: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

21580: k := k + 1;
21581: idx := idx + 1;
21582: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
21583: l_csm_periodic_expenses_tbl(k).amount := 0;
21584: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
21585: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
21586: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
21587: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
21588: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;

Line 21627: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

21623: k := k + 1;
21624: idx := idx + 1;
21625: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
21626: l_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
21627: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
21628: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
21629: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
21630: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
21631: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 21698: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

21694: --l_csm_periodic_expenses_tbl(k).date_start := l_hdr_rec.start_date;
21695: l_csm_periodic_expenses_tbl(k).date_start := l_line_rec.start_date;
21696:
21697: ELSE
21698: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
21699: END IF;
21700: END IF;
21701: END LOOP;
21702: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 21716: IF FND_DATE.canonical_to_date(l_rl_rec.rule_information2) <> l_hdr_rec.start_date AND

21712: ((l_strm_name_rec.periodic_yn = 'Y' ) AND (UPPER(l_strm_name_rec.name) <> 'FEE'))) Then
21713: FOR l_rl_rec in l_sll_csr_lease (l_rl_rec1.slh_id, 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_line_rec.id ) LOOP
21714: -- Start of Bug#3401024 modification BAKUCHIB
21715: /*
21716: IF FND_DATE.canonical_to_date(l_rl_rec.rule_information2) <> l_hdr_rec.start_date AND
21717: lv_diff_date = 'N' AND
21718: idx = 0 THEN
21719: k := k + 1;
21720: idx := idx + 1;

Line 21723: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);

21719: k := k + 1;
21720: idx := idx + 1;
21721: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
21722: l_csm_periodic_expenses_tbl(k).amount := 0;
21723: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
21724: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
21725: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
21726: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
21727: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;

Line 21766: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

21762: k := k + 1;
21763: idx := idx + 1;
21764: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
21765: l_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
21766: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
21767: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
21768: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
21769: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
21770: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 21834: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

21830: --l_csm_periodic_expenses_tbl(k).date_start := l_hdr_rec.start_date;
21831: l_csm_periodic_expenses_tbl(k).date_start := l_line_rec.start_date;
21832:
21833: ELSE
21834: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
21835: END IF;
21836: END IF;
21837: END LOOP;
21838: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 21853: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

21849: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
21850: IF(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) THEN
21851: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
21852: ELSE
21853: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
21854: END IF;
21855: l_csm_one_off_fee_tbl(l).kle_asset_id := l_line_rec.id;
21856:
21857: --sechawla 15-Jul-09 : PRB ESg enhancements : assign orig_contract_line_id

Line 22984: start_date := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

22980: LOOP
22981:
22982: number_of_periods := TO_NUMBER(l_rl_rec.RULE_INFORMATION3);
22983: amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
22984: start_date := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
22985: k := 0;
22986: FOR i in 1..number_of_periods
22987: LOOP
22988: k := i;

Line 23698: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,

23694: CURSOR c_get_sll_lines_csr(p_khr_id okl_k_headers.id%TYPE,
23695: p_cle_id okl_k_lines.id%TYPE,
23696: p_slh_id okc_rules_b.id%TYPE)
23697: IS
23698: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
23699: /* DECODE(SLL.rule_information7,
23700: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
23701: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
23702: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1)) end_date,

Line 23700: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),

23696: p_slh_id okc_rules_b.id%TYPE)
23697: IS
23698: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
23699: /* DECODE(SLL.rule_information7,
23700: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
23701: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
23702: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1)) end_date,
23703: */
23704: -- Bug 5362566: Start

Line 23701: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,

23697: IS
23698: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
23699: /* DECODE(SLL.rule_information7,
23700: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
23701: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
23702: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1)) end_date,
23703: */
23704: -- Bug 5362566: Start
23705: OKL_LA_PAYMENTS_PVT.get_display_end_date(

Line 23702: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1)) end_date,

23698: SELECT FND_DATE.canonical_to_date(sll.rule_information2) start_date,
23699: /* DECODE(SLL.rule_information7,
23700: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
23701: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
23702: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1)) end_date,
23703: */
23704: -- Bug 5362566: Start
23705: OKL_LA_PAYMENTS_PVT.get_display_end_date(
23706: sll.RULE_INFORMATION2, sll.RULE_INFORMATION7, sll.OBJECT1_ID1, sll.RULE_INFORMATION3,

Line 23731: ORDER BY FND_DATE.canonical_to_date(sll.rule_information2);

23727: AND TO_CHAR(slh.id) = sll.object2_id1
23728: AND sll.rule_information_category = G_RUL_SLL_CODE
23729: --Added by kthiruva for Bug 5130703
23730: AND slh.JTOT_OBJECT1_CODE = 'OKL_STRMTYP'
23731: ORDER BY FND_DATE.canonical_to_date(sll.rule_information2);
23732:
23733: CURSOR c_valid_khr_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)
23734: IS
23735: SELECT 1

Line 24964: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);

24960: AND crg.rgd_code = rgcode
24961: AND crl.rule_information_category = rlcat
24962: AND crg.dnz_chr_id = chrId
24963: AND crg.cle_id = cleId
24964: ORDER BY FND_DATE.canonical_to_date(crl.rule_information2);
24965: -- Get Structure
24966: CURSOR l_struct_csr(chrId NUMBER)
24967: IS
24968: SELECT DISTINCT(nvl(crl.rule_information5,-1)) structure

Line 25023: MAX(FND_DATE.canonical_to_date(sll.rule_information2)) pay_start_date,

25019: p_cle_id okc_k_lines_b.id%TYPE,
25020: p_slh_id okc_rule_groups_b.id%TYPE)
25021: IS
25022: SELECT chrv.end_date chr_end_date,
25023: MAX(FND_DATE.canonical_to_date(sll.rule_information2)) pay_start_date,
25024: MAX(DECODE(SLL.rule_information7,
25025: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
25026: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
25027: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1))) pay_end_date

Line 25025: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),

25021: IS
25022: SELECT chrv.end_date chr_end_date,
25023: MAX(FND_DATE.canonical_to_date(sll.rule_information2)) pay_start_date,
25024: MAX(DECODE(SLL.rule_information7,
25025: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
25026: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
25027: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1))) pay_end_date
25028: FROM okc_rules_b sll,
25029: okc_rules_b slh,

Line 25026: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,

25022: SELECT chrv.end_date chr_end_date,
25023: MAX(FND_DATE.canonical_to_date(sll.rule_information2)) pay_start_date,
25024: MAX(DECODE(SLL.rule_information7,
25025: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
25026: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
25027: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1))) pay_end_date
25028: FROM okc_rules_b sll,
25029: okc_rules_b slh,
25030: okc_rule_groups_b rgp,

Line 25027: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1))) pay_end_date

25023: MAX(FND_DATE.canonical_to_date(sll.rule_information2)) pay_start_date,
25024: MAX(DECODE(SLL.rule_information7,
25025: NULL,(ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1),
25026: TO_NUMBER(SLL.rule_information7),FND_DATE.canonical_to_date(sll.rule_information2)+SLL.rule_information7-1,
25027: (ADD_MONTHS(FND_DATE.canonical_to_date(sll.rule_information2),to_number(SLL.rule_information3)*DECODE(sll.object1_id1, 'M', 1, 'Q', 3, 'S', 6, 'A', 12))-1))) pay_end_date
25028: FROM okc_rules_b sll,
25029: okc_rules_b slh,
25030: okc_rule_groups_b rgp,
25031: okc_k_headers_b chrv

Line 25707: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

25703: j := j + 1;
25704: idx := idx + 1;
25705: l_rents_tbl(j).level_index_number := idx;
25706: l_rents_tbl(j).amount := TO_NUMBER(l_rl_rec.rule_information8);
25707: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
25708: l_rents_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
25709: l_rents_tbl(j).period := g_stub_rec.period;
25710: l_rents_tbl(j).description := l_strm_name;
25711: -- l_rents_tbl(j).kle_asset_id := l_so_line_rec.id;

Line 25758: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

25754: END IF;
25755: IF(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) Then
25756: l_rents_tbl(j).date_start := l_hdr_rec.start_date;
25757: ELSE
25758: l_rents_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
25759: END IF;
25760: l_rents_tbl(j).rate := l_rl_rec.rule_information13;
25761: END IF;
25762: -- Now we get difference in days between contract end_date and last payment end_date

Line 25784: ld_last_start_date = FND_DATE.canonical_to_date(l_rl_rec.rule_information2) THEN

25780: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
25781: END IF;
25782: -- If there is diff in days then an empty stub will be appended
25783: IF ln_diff_days > 0 AND
25784: ld_last_start_date = FND_DATE.canonical_to_date(l_rl_rec.rule_information2) THEN
25785: j := j + 1;
25786: idx := idx + 1;
25787: l_rents_tbl(j).level_index_number := idx;
25788: l_rents_tbl(j).amount := 0;

Line 25828: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

25824: k := k + 1;
25825: idx := idx + 1;
25826: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
25827: l_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
25828: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
25829: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
25830: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
25831: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
25832: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

Line 25880: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

25876: END IF;
25877: IF(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) THEN
25878: l_csm_periodic_expenses_tbl(k).date_start := l_hdr_rec.start_date;
25879: ELSE
25880: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
25881: END IF;
25882: END IF;
25883: END LOOP;
25884: ELSIF ((UPPER(TRIM(l_strm_name_rec.periodic_yn)) = 'N' )) THEN

Line 25893: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

25889: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
25890: IF (l_rl_rec.RULE_INFORMATION2 IS NULL OR l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) THEN
25891: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
25892: ELSE
25893: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
25894: END IF;
25895: -- l_csm_one_off_fee_tbl(l).kle_asset_id := l_so_line_rec.id;
25896: END LOOP;
25897: END IF;

Line 26048: l_csm_loan_levels_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);

26044: j := j + 1;
26045: idx := idx + 1;
26046: l_csm_loan_levels_tbl(j).level_index_number := idx;
26047: l_csm_loan_levels_tbl(j).amount := TO_NUMBER(l_rl_rec.rule_information8);
26048: l_csm_loan_levels_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+TO_NUMBER(l_rl_rec.rule_information7);
26049: l_csm_loan_levels_tbl(j).number_of_periods := g_stub_rec.number_of_periods;
26050: l_csm_loan_levels_tbl(j).period := g_stub_rec.period;
26051: l_csm_loan_levels_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
26052: l_csm_loan_levels_tbl(j).days_in_month := l_days_in_month_code;

Line 26129: ld_last_start_date = FND_DATE.canonical_to_date(l_rl_rec.rule_information2) THEN

26125: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
26126: END IF;
26127: -- If there is diff in days then an empty stub will be appended
26128: IF ln_diff_days > 0 AND
26129: ld_last_start_date = FND_DATE.canonical_to_date(l_rl_rec.rule_information2) THEN
26130: j := j + 1;
26131: idx := idx + 1;
26132: l_csm_loan_levels_tbl(j).level_index_number := idx;
26133: l_csm_loan_levels_tbl(j).amount := 0;

Line 26178: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+l_rl_rec.rule_information7;

26174: k := k + 1;
26175: idx := idx + 1;
26176: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
26177: l_csm_periodic_expenses_tbl(k).amount := TO_NUMBER(l_rl_rec.rule_information8);
26178: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2)+l_rl_rec.rule_information7;
26179: l_csm_periodic_expenses_tbl(k).number_of_periods := g_stub_rec.number_of_periods;
26180: l_csm_periodic_expenses_tbl(k).period := g_stub_rec.period;
26181: -- l_csm_periodic_expenses_tbl(k).kle_asset_id := l_so_line_rec.id;
26182: l_csm_periodic_expenses_tbl(k).description := l_strm_name;

Line 26238: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

26234: END IF;
26235: IF (l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) THEN
26236: l_csm_periodic_expenses_tbl(k).date_start := l_hdr_rec.start_date;
26237: ELSE
26238: l_csm_periodic_expenses_tbl(k).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
26239: END IF;
26240: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
26241: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
26242: ELSE

Line 26264: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

26260: IF (l_rl_rec.RULE_INFORMATION2 IS NULL OR
26261: l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) THEN
26262: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
26263: ELSE
26264: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
26265: END IF;
26266: -- l_csm_one_off_fee_tbl(l).kle_asset_id := l_so_line_rec.id;
26267: END LOOP;
26268: END IF;