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 2664: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,

2660: -- srsreeni Bug 5917582 end
2661: rul2.object1_id1 frequency,
2662: rul2.rule_information5 structure,
2663: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,
2664: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
2665: lse.lty_code lty_code,
2666: kle.capital_amount capital_amount,
2667: kle.residual_value residual_value
2668: FROM okc_rule_groups_b rgp,

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

8776:
8777: OPEN l_rl_csr1 ( 'LALEVL', 'LASLL', TO_NUMBER(p_chr_id), l_lne_rec1.id );
8778: FETCH l_rl_csr1 INTO l_rl_rec1;
8779: CLOSE l_rl_csr1;
8780: px_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec1.RULE_INFORMATION6,'0'));
8781: IF(l_rl_rec1.RULE_INFORMATION2 IS NULL or l_rl_rec1.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) Then
8782: px_csm_one_off_fee_tbl(l).date_start := l_lne_rec1.start_date ;
8783: ELSE
8784: px_csm_one_off_fee_tbl(l).date_start := FND_DATE.canonical_to_date(l_rl_rec1.RULE_INFORMATION2);

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

9826: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
9827: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
9828: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
9829: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
9830: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
9831: -- gboomina Bug 4746368 - Modified amount calculation - Start
9832: px_csm_periodic_expenses_tbl(k).amount := px_csm_periodic_expenses_tbl(k).amount - l_pass_thru_amount;
9833: -- gboomina Bug 4746368 - Modified amount calculation - End
9834: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));

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

9951: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
9952: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
9953: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
9954: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
9955: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
9956: -- gboomina Bug 4746368 - Modified amount calculation - Start
9957: px_csm_periodic_expenses_tbl(k).amount := px_csm_periodic_expenses_tbl(k).amount - l_pass_thru_amount;
9958: -- gboomina Bug 4746368 - Modified amount calculation - End
9959: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));

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

10323: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
10324: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
10325: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
10326: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
10327: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
10328: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
10329: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
10330: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
10331: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_linked_asset_line_rec.id;

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

10663: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
10664: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
10665: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
10666: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
10667: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
10668: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
10669: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
10670: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
10671: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;

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

10873: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
10874: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
10875: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
10876: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
10877: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
10878: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
10879: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
10880: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_linked_asset_line_rec.id;
10881: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

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

11009: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
11010: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
11011: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
11012: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
11013: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
11014: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
11015: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
11016: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;
11017: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

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

11181: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
11182: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
11183: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
11184: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
11185: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
11186: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
11187: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
11188: px_csm_periodic_expenses_tbl(k).kle_fee_id := link_rollover_rec.id;
11189: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

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

11316: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
11317: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
11318: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
11319: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
11320: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
11321: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
11322: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
11323: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;
11324: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

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

11618: CLOSE l_rl_csr;
11619: px_csm_one_off_fee_tbl(l).description := l_strm_name;
11620: px_csm_one_off_fee_tbl(l).fee_type := l_fee_type;
11621: px_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
11622: px_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(r_rl_rec.rule_information6);
11623: px_csm_one_off_fee_tbl(l).date_paid := l_lne_rec.start_date;
11624: px_csm_one_off_fee_tbl(l).kle_fee_id := l_lne_rec.id;
11625:
11626: ELSIF ln_level_cnt > 1 THEN

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

11723: px_csm_periodic_expenses_tbl(k).level_index_number := idx;
11724: px_csm_periodic_expenses_tbl(k).description := l_strm_name;
11725: px_csm_periodic_expenses_tbl(k).fee_type := l_fee_type;
11726: px_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
11727: px_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.rule_information6,'0'));
11728: px_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.rule_information3, l_hdr_rec.term));
11729: px_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
11730: px_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
11731: px_csm_periodic_expenses_tbl(k).kle_fee_id := l_lne_rec.id;

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

12370: j := j + 1;
12371: idx := idx + 1;
12372: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
12373: l_csm_line_details_tbl(j).description := l_strm_name;
12374: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
12375: --Modified by kthiruva on 09-Dec-2005 for the VR build
12376: --Bug 4766555 - Start of Changes
12377: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
12378: --Bug 4766555 - End of Changes

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

12616: j := j + 1;
12617: idx := idx + 1;
12618: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
12619: l_csm_line_details_tbl(j).description := l_strm_name;
12620: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
12621: --Modified by kthiruva on 09-Dec-2005 for the VR build
12622: --Bug 4766555 - Start of Changes
12623: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
12624: --Bug 4766555 - End of Changes

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

12758: l_csm_periodic_expenses_tbl(k).level_index_number := idx_exp; -- bug6245602
12759: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
12760: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
12761: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
12762: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
12763: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
12764: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
12765: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
12766: l_csm_periodic_expenses_tbl(k).cash_effect_yn := 'N';

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

12859: idx_exp := idx_exp + 1; -- bug6245602
12860: l_csm_periodic_expenses_tbl(k).level_index_number := idx_exp;
12861: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
12862: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
12863: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
12864: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
12865: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
12866: l_csm_periodic_expenses_tbl(k).days_in_month := l_days_in_month_code;
12867: l_csm_periodic_expenses_tbl(k).days_in_year := l_days_in_yr_code;

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

12899: 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
12900: l := l + 1;
12901: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
12902: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
12903: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
12904: If(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) Then
12905: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
12906: Else
12907: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

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

13586: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
13587: (l_rl_rec.rule_information8 IS NOT NULL OR
13588: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
13589: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
13590: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));
13591: l_ppd_tbl(l_ppd_count).curr_paydown := 'N';
13592: l_ppd_count := l_ppd_count + 1;
13593: END IF;
13594: END LOOP;

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

13831: j := j + 1;
13832: idx := idx + 1;
13833: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
13834: l_csm_line_details_tbl(j).description := l_strm_name;
13835: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
13836: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
13837: l_csm_line_details_tbl(j).level_index_number := idx;
13838: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
13839: l_csm_line_details_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));

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

13902: j := j + 1;
13903: idx := idx + 1;
13904: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
13905: l_csm_line_details_tbl(j).description := l_strm_name;
13906: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
13907: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
13908: l_csm_line_details_tbl(j).level_index_number := idx;
13909: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
13910:

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

13974: l_csm_line_details_tbl(j).period := g_stub_rec.period;
13975: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
13976: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
13977: l_csm_line_details_tbl(j).description := l_strm_name;
13978: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
13979: --The adjusting stub would end one day before the PPD date
13980: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
13981: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
13982: l_csm_line_details_tbl(j).level_index_number := idx;

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

14089: l_csm_line_details_tbl(j).period := g_stub_rec.period;
14090: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
14091: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14092: l_csm_line_details_tbl(j).description := l_strm_name;
14093: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14094: l_csm_line_details_tbl(j).date_start := l_adjusting_stub_date;
14095: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
14096: l_csm_line_details_tbl(j).level_index_number := idx;
14097: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;

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

14153: l_csm_line_details_tbl(j).period := l_rl_rec.object1_id1;
14154: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
14155: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14156: l_csm_line_details_tbl(j).description := l_strm_name;
14157: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14158: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
14159: l_csm_line_details_tbl(j).level_index_number := idx;
14160: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
14161: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;

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

14301: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
14302: (l_rl_rec.rule_information8 IS NOT NULL OR
14303: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
14304: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
14305: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));
14306: l_ppd_tbl(l_ppd_count).curr_paydown := 'N';
14307: l_ppd_count := l_ppd_count + 1;
14308: END IF;
14309: END LOOP;

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

14544: j := j + 1;
14545: idx := idx + 1;
14546: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14547: l_csm_line_details_tbl(j).description := l_strm_name;
14548: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14549: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
14550: l_csm_line_details_tbl(j).level_index_number := idx;
14551: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;
14552: l_csm_line_details_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));

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

14615: j := j + 1;
14616: idx := idx + 1;
14617: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14618: l_csm_line_details_tbl(j).description := l_strm_name;
14619: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14620: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
14621: l_csm_line_details_tbl(j).level_index_number := idx;
14622: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;
14623:

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

14687: l_csm_line_details_tbl(j).period := g_stub_rec.period;
14688: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
14689: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14690: l_csm_line_details_tbl(j).description := l_strm_name;
14691: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14692: --The adjusting stub would end one day before the PPD date
14693: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
14694: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
14695: l_csm_line_details_tbl(j).level_index_number := idx;

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

14804: l_csm_line_details_tbl(j).period := g_stub_rec.period;
14805: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
14806: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14807: l_csm_line_details_tbl(j).description := l_strm_name;
14808: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14809: l_csm_line_details_tbl(j).date_start := l_adjusting_stub_date;
14810: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
14811: l_csm_line_details_tbl(j).level_index_number := idx;
14812: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;

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

14866: l_csm_line_details_tbl(j).period := l_rl_rec.object1_id1;
14867: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
14868: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
14869: l_csm_line_details_tbl(j).description := l_strm_name;
14870: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14871: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
14872: l_csm_line_details_tbl(j).level_index_number := idx;
14873: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
14874: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;

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

14974: idx := idx + 1;
14975: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
14976: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
14977: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
14978: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
14979: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
14980: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
14981: l_csm_periodic_expenses_tbl(k).days_in_month := l_days_in_month_code;
14982: l_csm_periodic_expenses_tbl(k).days_in_year := l_days_in_yr_code;

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

15014: 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
15015: l := l + 1;
15016: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
15017: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
15018: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
15019: If(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) Then
15020: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
15021: Else
15022: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

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

15643: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
15644: (l_rl_rec.rule_information8 IS NOT NULL OR
15645: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
15646: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
15647: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));
15648: l_ppd_tbl(l_ppd_count).curr_paydown := 'N';
15649: l_ppd_count := l_ppd_count + 1;
15650: END IF;
15651: END LOOP;

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

15868: j := j + 1;
15869: idx := idx + 1;
15870: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
15871: l_csm_line_details_tbl(j).description := l_strm_name;
15872: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
15873: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
15874: l_csm_line_details_tbl(j).level_index_number := idx;
15875: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
15876: l_csm_line_details_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));

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

15935: j := j + 1;
15936: idx := idx + 1;
15937: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
15938: l_csm_line_details_tbl(j).description := l_strm_name;
15939: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
15940: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
15941: l_csm_line_details_tbl(j).level_index_number := idx;
15942: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
15943:

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

16003: l_csm_line_details_tbl(j).period := g_stub_rec.period;
16004: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
16005: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
16006: l_csm_line_details_tbl(j).description := l_strm_name;
16007: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16008: --The adjusting stub would end one day before the PPD date
16009: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
16010: l_csm_line_details_tbl(j).level_index_number := idx;
16011: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;

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

16109: l_csm_line_details_tbl(j).period := g_stub_rec.period;
16110: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
16111: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
16112: l_csm_line_details_tbl(j).description := l_strm_name;
16113: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16114: l_csm_line_details_tbl(j).date_start := l_adjusting_stub_date;
16115: l_csm_line_details_tbl(j).level_index_number := idx;
16116: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
16117: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;

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

16169: l_csm_line_details_tbl(j).period := l_rl_rec.object1_id1;
16170: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
16171: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
16172: l_csm_line_details_tbl(j).description := l_strm_name;
16173: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16174: l_csm_line_details_tbl(j).level_index_number := idx;
16175: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
16176: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
16177: --This rate column is relevant for rent payments only in the rebook scenarios

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

16322: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
16323: (l_rl_rec.rule_information8 IS NOT NULL OR
16324: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
16325: l_ppd_tbl(l_ppd_count).paydown_date := FND_DATE.canonical_to_date(l_rl_rec.rule_information2);
16326: l_ppd_tbl(l_ppd_count).paydown_amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION8,'0'));
16327: l_ppd_tbl(l_ppd_count).curr_paydown := 'N';
16328: l_ppd_count := l_ppd_count + 1;
16329: END IF;
16330: END LOOP;

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

16552: j := j + 1;
16553: idx := idx + 1;
16554: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
16555: l_csm_line_details_tbl(j).description := l_strm_name;
16556: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16557: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
16558: l_csm_line_details_tbl(j).level_index_number := idx;
16559: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;
16560: l_csm_line_details_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));

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

16621: j := j + 1;
16622: idx := idx + 1;
16623: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
16624: l_csm_line_details_tbl(j).description := l_strm_name;
16625: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16626: l_csm_line_details_tbl(j).date_start := FND_DATE.canonical_to_date(l_rl_rec.rule_information2) ;
16627: l_csm_line_details_tbl(j).level_index_number := idx;
16628: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;
16629:

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

16691: l_csm_line_details_tbl(j).period := g_stub_rec.period;
16692: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
16693: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
16694: l_csm_line_details_tbl(j).description := l_strm_name;
16695: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16696: --The adjusting stub would end one day before the PPD date
16697: l_csm_line_details_tbl(j).date_start := l_ppd_tbl(k).paydown_date;
16698: l_csm_line_details_tbl(j).level_index_number := idx;
16699: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;

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

16804: l_csm_line_details_tbl(j).period := g_stub_rec.period;
16805: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
16806: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
16807: l_csm_line_details_tbl(j).description := l_strm_name;
16808: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16809: l_csm_line_details_tbl(j).date_start := l_adjusting_stub_date;
16810: l_csm_line_details_tbl(j).level_index_number := idx;
16811: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
16812: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;

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

16864: l_csm_line_details_tbl(j).period := l_rl_rec.object1_id1;
16865: l_csm_line_details_tbl(j).advance_or_arrears := g_stub_rec.advance_or_arrears;
16866: l_csm_line_details_tbl(j).kle_loan_id := l_line_rec.id;
16867: l_csm_line_details_tbl(j).description := l_strm_name;
16868: l_csm_line_details_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16869: l_csm_line_details_tbl(j).level_index_number := idx;
16870: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
16871: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
16872: --When the payment type is Principal, the Base Rate specified in the contract needs to be

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

16969: idx := idx + 1;
16970: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
16971: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
16972: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
16973: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
16974: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
16975: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
16976: l_csm_periodic_expenses_tbl(k).days_in_month := l_days_in_month_code;
16977: l_csm_periodic_expenses_tbl(k).days_in_year := l_days_in_yr_code;

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

17009: 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
17010: l := l + 1;
17011: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
17012: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
17013: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
17014: If(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) Then
17015: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
17016: Else
17017: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

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

18803: l_rents_tbl(j).level_index_number := idx;
18804: l_rents_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
18805: l_rents_tbl(j).description := l_strm_name;
18806: l_rents_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
18807: l_rents_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
18808: l_rents_tbl(j).period := l_rl_rec.object1_id1;
18809: l_rents_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
18810: l_rents_tbl(j).kle_asset_id := l_line_rec.id;
18811: l_rents_tbl(j).days_in_month := l_days_in_month_code;

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

18921: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
18922: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
18923: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
18924: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
18925: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
18926: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
18927: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
18928: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
18929: l_csm_periodic_expenses_tbl(k).cash_effect_yn := 'N';

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

19036: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
19037: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
19038: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
19039: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
19040: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
19041: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
19042: l_csm_periodic_expenses_tbl(k).kle_asset_id := l_line_rec.id;
19043: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
19044: l_csm_periodic_expenses_tbl(k).days_in_month := l_days_in_month_code;

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

19069: 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
19070: l := l + 1;
19071: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
19072: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
19073: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
19074: IF(l_rl_rec.RULE_INFORMATION2 IS NULL or l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) THEN
19075: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
19076: ELSE
19077: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

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

20171: FOR l_rl_rec in l_rl_csr ( 'LALEVL', 'LASLL', p_chr_id, p_line_id )
20172: LOOP
20173:
20174: number_of_periods := TO_NUMBER(l_rl_rec.RULE_INFORMATION3);
20175: amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
20176: start_date := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);
20177: k := 0;
20178: FOR i in 1..number_of_periods
20179: LOOP

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

20873: )
20874: END_DATE,
20875: -- Bug 5362566: End
20876: -- Start of BAKUCHIB modification bug#3121708
20877: FND_NUMBER.canonical_to_number(NVL(sll.rule_information6,sll.rule_information8)) amount,
20878: -- End of BAKUCHIB modification bug#3121708
20879: sll.rule_information13 rate,
20880: nvl(sll.rule_information10,'Y') arrears_yn,
20881: sll.rule_information5 structure

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

22894: l_rents_tbl(j).level_index_number := idx;
22895: l_rents_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
22896: l_rents_tbl(j).description := l_strm_name;
22897: l_rents_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
22898: l_rents_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
22899: l_rents_tbl(j).period := l_rl_rec.object1_id1;
22900: l_rents_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
22901: -- l_rents_tbl(j).kle_asset_id := l_so_line_rec.id;
22902: l_rents_tbl(j).days_in_month := l_days_in_month_code;

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

23015: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
23016: l_csm_periodic_expenses_tbl(k).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
23017: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
23018: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
23019: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
23020: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
23021: -- l_csm_periodic_expenses_tbl(k).kle_asset_id := l_so_line_rec.id;
23022: l_csm_periodic_expenses_tbl(k).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
23023: l_csm_periodic_expenses_tbl(k).days_in_month := l_days_in_month_code;

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

23042: FOR l_rl_rec in l_rl_csr (l_rl_rec1.slh_id, 'LALEVL', 'LASLL',p_chr_id, l_so_line_rec.id ) LOOP
23043: l := l + 1;
23044: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
23045: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
23046: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
23047: IF (l_rl_rec.RULE_INFORMATION2 IS NULL OR l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) THEN
23048: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
23049: ELSE
23050: l_csm_one_off_fee_tbl(l).date_paid := FND_DATE.canonical_to_date(l_rl_rec.RULE_INFORMATION2);

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

23237: j := j + 1;
23238: idx := idx + 1;
23239: --smahapat l_csm_loan_levels_tbl(j).kle_loan_id := l_so_line_rec.id;
23240: l_csm_loan_levels_tbl(j).description := l_strm_name;
23241: l_csm_loan_levels_tbl(j).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
23242: l_csm_loan_levels_tbl(j).date_start := l_hdr_rec.start_date;
23243: l_csm_loan_levels_tbl(j).level_index_number := idx;
23244: l_csm_loan_levels_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
23245: l_csm_loan_levels_tbl(j).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));

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

23374: idx := idx + 1;
23375: l_csm_periodic_expenses_tbl(k).level_index_number := idx;
23376: l_csm_periodic_expenses_tbl(k).description := l_strm_name;
23377: l_csm_periodic_expenses_tbl(k).period := l_rl_rec.object1_id1;
23378: l_csm_periodic_expenses_tbl(k).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
23379: l_csm_periodic_expenses_tbl(k).number_of_periods := TO_NUMBER(nvl(l_rl_rec.RULE_INFORMATION3, l_hdr_rec.term));
23380: -- l_csm_periodic_expenses_tbl(k).kle_asset_id := l_so_line_rec.id;
23381: l_csm_periodic_expenses_tbl(k).days_in_month := l_days_in_month_code;
23382: l_csm_periodic_expenses_tbl(k).days_in_year := l_days_in_yr_code;

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

23412: 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
23413: l := l + 1;
23414: l_csm_one_off_fee_tbl(l).description := l_strm_name_rec.name;
23415: l_csm_one_off_fee_tbl(l).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
23416: l_csm_one_off_fee_tbl(l).amount := FND_NUMBER.canonical_to_number(nvl(l_rl_rec.RULE_INFORMATION6,'0'));
23417: IF (l_rl_rec.RULE_INFORMATION2 IS NULL OR
23418: l_rl_rec.RULE_INFORMATION2 = OKL_API.G_MISS_CHAR) THEN
23419: l_csm_one_off_fee_tbl(l).date_paid := l_hdr_rec.start_date;
23420: ELSE