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_NUMBER

Line 3080: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

3076: -- srsreeni Bug 5917582 end
3077: rul2.object1_id1 frequency,
3078: rul2.rule_information5 structure,
3079: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,
3080: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
3081: lse.lty_code lty_code,
3082: kle.capital_amount capital_amount,
3083: kle.residual_value residual_value
3084: FROM okc_rule_groups_b rgp,

Line 10321: px_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec1.RULE_INFORMATION6,'0'));

10317:
10318: OPEN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_rec1.id );
10319: FETCH l_rl_csr1 INTO l_rl_rec1;
10320: CLOSE l_rl_csr1;
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);

Line 11554: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

11550: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
11551: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
11552: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
11553: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
11554: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
11555: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
11556: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
11557: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_linked_asset_line_rec.id;
11558:

Line 11675: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

11671: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
11672: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
11673: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
11674: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
11675: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
11676: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
11677: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
11678: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;
11679:

Line 12082: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

12078: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
12079: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
12080: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
12081: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
12082: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
12083: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
12084: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
12085: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
12086: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_linked_asset_line_rec.id;

Line 12460: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

12456: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
12457: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
12458: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
12459: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
12460: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
12461: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
12462: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
12463: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
12464: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;

Line 12694: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));

12690: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
12691: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
12692: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
12693: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
12694: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
12695: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
12696: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
12697: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_linked_asset_line_rec.id;
12698:

Line 12848: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));

12844: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
12845: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
12846: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
12847: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
12848: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
12849: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
12850: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
12851: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;
12852:

Line 13039: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));

13035: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
13036: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
13037: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
13038: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
13039: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
13040: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
13041: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
13042: px_csm_periodic_expenses_tbl(k).kle_fee_id := link_rollover_rec.id;
13043:

Line 13194: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));

13190: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
13191: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
13192: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
13193: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
13194: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
13195: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
13196: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
13197: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;
13198:

Line 13514: px_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(r_rl_rec.rule_information6);

13510: CLOSE l_rl_csr;
13511: px_csm_one_off_fee_tbl(l).description := l_strm_name;
13512: px_csm_one_off_fee_tbl(l).fee_type := l_fee_type;
13513: px_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
13514: px_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(r_rl_rec.rule_information6);
13515: px_csm_one_off_fee_tbl(l).date_paid := l_lne_rec.start_date;
13516: px_csm_one_off_fee_tbl(l).kle_fee_id := l_lne_rec.id;
13517:
13518: --sechawla 15-jul-09 PRB ESG enhancements : assign orig_contract_line_id

Line 13630: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));

13626: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
13627: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
13628: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
13629: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
13630: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
13631: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
13632: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
13633: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
13634: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;

Line 14384: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

14380: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
14381: end if;
14382:
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

Line 14672: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

14668: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
14669: end if;
14670:
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

Line 14820: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

14816: l_csm_periodic_expenses_tbl(k).level_index_number := idx_exp; -- bug6245602
14817: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
14818: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
14819: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
14820: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14821: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
14822: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
14823:
14824: --sechawla 16-Jul-09 PRb ESg enhancements : assign orig_contract_line_id

Line 14936: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

14932: idx_exp := idx_exp + 1; -- bug6245602
14933: l_csm_periodic_expenses_tbl(k).level_index_number := idx_exp;
14934: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
14935: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
14936: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14937: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
14938: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
14939:
14940: --sechawla 16-Jul-09 PRb ESg enhancements : assign orig_contract_line_id

Line 14984: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

14980: FOR l_rl_rec in l_rl_csr (l_rl_rec1.slh_id, 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_line_rec.id ) LOOP
14981: l := l + 1;
14982: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
14983: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
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);

Line 15720: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));

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;
15724: END LOOP;

Line 16013: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

16009: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
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));

Line 16090: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

16086: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
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:

Line 16168: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

16164: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
16165: end if;
16166:
16167: l_csm_line_details_tbl(j).description := l_strm_name;
16168: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16169: --The adjusting stub would end one day before the PPD date
16170: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
16171: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
16172: l_csm_line_details_tbl(j).level_index_number := idx;

Line 16294: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

16290: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
16291: end if;
16292:
16293: l_csm_line_details_tbl(j).description := l_strm_name;
16294: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16295: l_csm_line_details_tbl(j).date_start := l_adjusting_stub_date;
16296: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
16297: l_csm_line_details_tbl(j).level_index_number := idx;
16298: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;

Line 16364: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

16360: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
16361: end if;
16362:
16363: l_csm_line_details_tbl(j).description := l_strm_name;
16364: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
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;

Line 16518: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));

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;
16522: END LOOP;

Line 16809: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

16805: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
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));

Line 16886: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

16882: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
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:

Line 16964: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

16960: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
16961: end if;
16962:
16963: l_csm_line_details_tbl(j).description := l_strm_name;
16964: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16965: --The adjusting stub would end one day before the PPD date
16966: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
16967: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
16968: l_csm_line_details_tbl(j).level_index_number := idx;

Line 17093: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

17089: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
17090: end if;
17091:
17092: l_csm_line_details_tbl(j).description := l_strm_name;
17093: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
17094: l_csm_line_details_tbl(j).date_start := l_adjusting_stub_date;
17095: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
17096: l_csm_line_details_tbl(j).level_index_number := idx;
17097: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;

Line 17161: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

17157: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
17158: end if;
17159:
17160: l_csm_line_details_tbl(j).description := l_strm_name;
17161: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
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;

Line 17275: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

17271: idx := idx + 1;
17272: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
17273: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
17274: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
17275: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
17276: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
17277: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
17278:
17279: --sechawla 16-JUl-09 PRB ESg Enhancements : assign orig_contract_line_id

Line 17323: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

17319: FOR l_rl_rec in l_rl_csr (l_rl_rec1.slh_id, 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_line_rec.id ) LOOP
17320: l := l + 1;
17321: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
17322: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
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);

Line 18002: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));

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;
18006: END LOOP;

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

18271: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
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));

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

18344: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
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:

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

18418: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
18419: end if;
18420:
18421: l_csm_line_details_tbl(j).description := l_strm_name;
18422: 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);
18423: --The adjusting stub would end one day before the PPD date
18424: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
18425: l_csm_line_details_tbl(j).level_index_number := idx;
18426: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;

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

18536: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
18537: end if;
18538:
18539: l_csm_line_details_tbl(j).description := l_strm_name;
18540: 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);
18541: l_csm_line_details_tbl(j).date_start := l_adjusting_stub_date;
18542: l_csm_line_details_tbl(j).level_index_number := idx;
18543: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
18544: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;

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

18602: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
18603: end if;
18604:
18605: l_csm_line_details_tbl(j).description := l_strm_name;
18606: 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);
18607: l_csm_line_details_tbl(j).level_index_number := idx;
18608: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
18609: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
18610: --This rate column is relevant for rent payments only in the rebook scenarios

Line 18765: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));

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;
18769: END LOOP;

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

19040: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
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));

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

19115: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
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:

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

19191: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
19192: end if;
19193:
19194: l_csm_line_details_tbl(j).description := l_strm_name;
19195: 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);
19196: --The adjusting stub would end one day before the PPD date
19197: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
19198: l_csm_line_details_tbl(j).level_index_number := idx;
19199: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;

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

19317: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
19318: end if;
19319:
19320: l_csm_line_details_tbl(j).description := l_strm_name;
19321: 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);
19322: l_csm_line_details_tbl(j).date_start := l_adjusting_stub_date;
19323: l_csm_line_details_tbl(j).level_index_number := idx;
19324: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
19325: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;

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

19383: l_csm_line_details_tbl(j).orig_contract_line_id := l_line_rec.orig_contract_line_id;
19384: end if;
19385:
19386: l_csm_line_details_tbl(j).description := l_strm_name;
19387: 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);
19388: l_csm_line_details_tbl(j).level_index_number := idx;
19389: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
19390: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
19391: --When the payment type is Principal, the Base Rate specified in the contract needs to be

Line 19498: l_csm_periodic_expenses_tbl(k).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);

19494: idx := idx + 1;
19495: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
19496: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
19497: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
19498: l_csm_periodic_expenses_tbl(k).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);
19499: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
19500: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
19501:
19502: --sechawla 16-Jul-09 PRB ESg enhancements : assign orig_contract_line_id

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

19542: FOR l_rl_rec in l_rl_csr (l_rl_rec1.slh_id, 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_line_rec.id ) LOOP
19543: l := l + 1;
19544: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
19545: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
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);

Line 21525: l_rents_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

21521: l_rents_tbl(j).level_index_number := idx;
21522: l_rents_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
21523: l_rents_tbl(j).description := l_strm_name;
21524: l_rents_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
21525: l_rents_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
21526: l_rents_tbl(j).period := l_rl_rec.object1_id1;
21527: l_rents_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
21528: l_rents_tbl(j).kle_asset_id := l_line_rec.id;
21529: l_rents_tbl(j).days_in_month := l_days_in_month_code;

Line 21669: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

21665: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
21666: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
21667: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
21668: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
21669: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
21670: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
21671: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
21672:
21673: --sechawla 15-JUL-09 : PRB ESG Enhancements : assigne orig_contract_line_id

Line 21807: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

21803: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
21804: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
21805: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
21806: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
21807: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
21808: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
21809: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
21810:
21811: --sechawla 15-jul-09 PRB ESg enhancements : assign orig_contract_line_id

Line 21849: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

21845: 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
21846: l := l + 1;
21847: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
21848: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
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);

Line 22983: amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

22979: FOR l_rl_rec in l_rl_csr ( 'LALEVL', 'LASLL', p_chr_id, p_line_id )
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

Line 23713: FND_NUMBER.canonical_to_number(NVL(sll.rule_information6,sll.rule_information8)) amount,

23709: )
23710: END_DATE,
23711: -- Bug 5362566: End
23712: -- Start of BAKUCHIB modification bug#3121708
23713: FND_NUMBER.canonical_to_number(NVL(sll.rule_information6,sll.rule_information8)) amount,
23714: -- End of BAKUCHIB modification bug#3121708
23715: sll.rule_information13 rate,
23716: nvl(sll.rule_information10,'Y') arrears_yn,
23717: sll.rule_information5 structure

Line 25741: l_rents_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

25737: l_rents_tbl(j).level_index_number := idx;
25738: l_rents_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
25739: l_rents_tbl(j).description := l_strm_name;
25740: l_rents_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
25741: l_rents_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
25742: l_rents_tbl(j).period := l_rl_rec.object1_id1;
25743: l_rents_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
25744: -- l_rents_tbl(j).kle_asset_id := l_so_line_rec.id;
25745: l_rents_tbl(j).days_in_month := l_days_in_month_code;

Line 25862: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

25858: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
25859: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
25860: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
25861: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
25862: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
25863: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
25864: -- l_csm_periodic_expenses_tbl(k).kle_asset_id := l_so_line_rec.id;
25865: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
25866: l_csm_periodic_expenses_tbl(k).days_in_month := l_days_in_month_code;

Line 25889: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

25885: FOR l_rl_rec in l_rl_csr (l_rl_rec1.slh_id, 'LALEVL', 'LASLL',p_chr_id, l_so_line_rec.id ) LOOP
25886: l := l + 1;
25887: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
25888: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
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);

Line 26084: l_csm_loan_levels_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

26080: j := j + 1;
26081: idx := idx + 1;
26082: --smahapat l_csm_loan_levels_tbl(j).kle_loan_id := l_so_line_rec.id;
26083: l_csm_loan_levels_tbl(j).description := l_strm_name;
26084: l_csm_loan_levels_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
26085: l_csm_loan_levels_tbl(j).date_start := l_hdr_rec.start_date;
26086: l_csm_loan_levels_tbl(j).level_index_number := idx;
26087: l_csm_loan_levels_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
26088: l_csm_loan_levels_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));

Line 26221: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

26217: idx := idx + 1;
26218: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
26219: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
26220: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
26221: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
26222: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
26223: -- l_csm_periodic_expenses_tbl(k).kle_asset_id := l_so_line_rec.id;
26224: l_csm_periodic_expenses_tbl(k).days_in_month := l_days_in_month_code;
26225: l_csm_periodic_expenses_tbl(k).days_in_year := l_days_in_yr_code;

Line 26259: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));

26255: FOR l_rl_rec in l_rl_csr (l_rl_rec1.slh_id, 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_so_line_rec.id ) LOOP
26256: l := l + 1;
26257: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
26258: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
26259: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
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