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 OKL_CREATE_STREAMS_PVT

Line 10: G_SFE_TYPE_SUBSIDY CONSTANT VARCHAR2(200) := okl_create_streams_pvt.G_SFE_TYPE_SUBSIDY;

6: -------------------------------------------------------------------------------------------------
7: G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKL_NO_PARENT_RECORD';
8: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
9: g_rep_req_yn VARCHAR2(3) := 'N';
10: G_SFE_TYPE_SUBSIDY CONSTANT VARCHAR2(200) := okl_create_streams_pvt.G_SFE_TYPE_SUBSIDY;
11: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
12: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
13: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
14: G_DB_ERROR CONSTANT VARCHAR2(12) := 'OKL_DB_ERROR';

Line 52: advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKL_CREATE_STREAMS_PVT.G_ARREARS,

48: -----------------------------------------------------------------------------------
49: -- Start of Bug#2757289 modification bakuchib
50: TYPE stub_rec_type IS RECORD (
51: number_of_periods NUMBER := 1,
52: advance_or_arrears OKL_SIF_FEES_V.advance_or_arrears%TYPE := OKL_CREATE_STREAMS_PVT.G_ARREARS,
53: period OKL_SIF_FEES_V.period%TYPE := 'T');
54: g_stub_rec stub_rec_type;
55: SUBTYPE pdtv_rec_type IS okl_setupproducts_pvt.pdtv_rec_type;
56: SUBTYPE ast_dtl_tbl_type IS okl_activate_asset_pvt.ast_dtl_tbl_type;

Line 1865: l_csm_yields_tbl(1).siy_type := okl_create_streams_pvt.g_siy_type_yield;

1861: l_csm_yields_tbl(1).array_type := 'PTCF';
1862: l_csm_yields_tbl(1).compounded_method := 'Periodic';
1863: l_csm_yields_tbl(1).nominal_yn := 'Y';
1864: l_csm_yields_tbl(1).pre_tax_yn := 'Y';
1865: l_csm_yields_tbl(1).siy_type := okl_create_streams_pvt.g_siy_type_yield;
1866: -- After tax IRR with subsidy
1867: l_csm_yields_tbl(2).yield_name := 'NAT';
1868: l_csm_yields_tbl(2).method := 'Internal rate-of-return';
1869: l_csm_yields_tbl(2).array_type := 'ATCF';

Line 1873: l_csm_yields_tbl(2).siy_type := okl_create_streams_pvt.g_siy_type_yield;

1869: l_csm_yields_tbl(2).array_type := 'ATCF';
1870: l_csm_yields_tbl(2).compounded_method := 'Periodic';
1871: l_csm_yields_tbl(2).nominal_yn := 'Y';
1872: l_csm_yields_tbl(2).pre_tax_yn := 'Y';
1873: l_csm_yields_tbl(2).siy_type := okl_create_streams_pvt.g_siy_type_yield;
1874: -- Booking yield with subsidy
1875: l_csm_yields_tbl(3).yield_name := 'Booking';
1876: l_csm_yields_tbl(3).method := 'FAS 13 accounting';
1877: l_csm_yields_tbl(3).array_type := 'Full-term rate and subsidies';

Line 1881: l_csm_yields_tbl(3).siy_type := okl_create_streams_pvt.g_siy_type_yield;

1877: l_csm_yields_tbl(3).array_type := 'Full-term rate and subsidies';
1878: l_csm_yields_tbl(3).compounded_method := 'Periodic';
1879: l_csm_yields_tbl(3).nominal_yn := 'Y';
1880: l_csm_yields_tbl(3).pre_tax_yn := 'Y';
1881: l_csm_yields_tbl(3).siy_type := okl_create_streams_pvt.g_siy_type_yield;
1882: -- Pre tax IRR without subsidy
1883: l_csm_yields_tbl(4).yield_name := 'PTIRRWS';
1884: l_csm_yields_tbl(4).method := 'Internal rate-of-return';
1885: l_csm_yields_tbl(4).array_type := 'PTCF w/o subsidies';

Line 1889: l_csm_yields_tbl(4).siy_type := okl_create_streams_pvt.g_siy_type_yield;

1885: l_csm_yields_tbl(4).array_type := 'PTCF w/o subsidies';
1886: l_csm_yields_tbl(4).compounded_method := 'Periodic';
1887: l_csm_yields_tbl(4).nominal_yn := 'Y';
1888: l_csm_yields_tbl(4).pre_tax_yn := 'Y';
1889: l_csm_yields_tbl(4).siy_type := okl_create_streams_pvt.g_siy_type_yield;
1890: -- After tax IRR without subsidy
1891: l_csm_yields_tbl(5).yield_name := 'NATWS';
1892: l_csm_yields_tbl(5).method := 'Internal rate-of-return';
1893: l_csm_yields_tbl(5).array_type := 'ATCF w/o subsidies';

Line 1897: l_csm_yields_tbl(5).siy_type := okl_create_streams_pvt.g_siy_type_yield;

1893: l_csm_yields_tbl(5).array_type := 'ATCF w/o subsidies';
1894: l_csm_yields_tbl(5).compounded_method := 'Periodic';
1895: l_csm_yields_tbl(5).nominal_yn := 'Y';
1896: l_csm_yields_tbl(5).pre_tax_yn := 'N';
1897: l_csm_yields_tbl(5).siy_type := okl_create_streams_pvt.g_siy_type_yield;
1898: -- Booking yield without subsidy
1899: l_csm_yields_tbl(6).yield_name := 'BookingWS';
1900: l_csm_yields_tbl(6).method := 'FAS 13 accounting';
1901: l_csm_yields_tbl(6).array_type := 'Full-term rate';

Line 1905: l_csm_yields_tbl(6).siy_type := okl_create_streams_pvt.g_siy_type_yield;

1901: l_csm_yields_tbl(6).array_type := 'Full-term rate';
1902: l_csm_yields_tbl(6).compounded_method := 'Periodic';
1903: l_csm_yields_tbl(6).nominal_yn := 'Y';
1904: l_csm_yields_tbl(6).pre_tax_yn := 'N';
1905: l_csm_yields_tbl(6).siy_type := okl_create_streams_pvt.g_siy_type_yield;
1906: -- Assign output rec
1907: x_csm_yields_tbl := l_csm_yields_tbl;
1908: RETURN x_return_status;
1909: EXCEPTION

Line 11859: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,

11855: p_deal_type IN VARCHAR2,
11856: x_return_status OUT NOCOPY VARCHAR2,
11857: x_msg_count OUT NOCOPY NUMBER,
11858: x_msg_data OUT NOCOPY VARCHAR2,
11859: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
11860: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
11861: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
11862: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
11863: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,

Line 11860: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,

11856: x_return_status OUT NOCOPY VARCHAR2,
11857: x_msg_count OUT NOCOPY NUMBER,
11858: x_msg_data OUT NOCOPY VARCHAR2,
11859: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
11860: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
11861: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
11862: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
11863: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
11864: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,

Line 11861: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,

11857: x_msg_count OUT NOCOPY NUMBER,
11858: x_msg_data OUT NOCOPY VARCHAR2,
11859: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
11860: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
11861: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
11862: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
11863: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
11864: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
11865: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type) AS

Line 11930: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

11926: l_strm_name_rec strm_name_csr%ROWTYPE;
11927: l_ib_rec ib_csr%ROWTYPE;
11928: l_struct_rec l_struct_csr%ROWTYPE;
11929: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
11930: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
11931: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
11932: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
11933: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
11934: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;

Line 11931: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

11927: l_ib_rec ib_csr%ROWTYPE;
11928: l_struct_rec l_struct_csr%ROWTYPE;
11929: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
11930: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
11931: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
11932: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
11933: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
11934: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
11935: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;

Line 11937: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

11933: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
11934: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
11935: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
11936: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
11937: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
11938: l_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
11939: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
11940:
11941: --mansrini : Code for VR build

Line 13089: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,

13085: p_balance_type_code IN VARCHAR2,
13086: x_return_status OUT NOCOPY VARCHAR2,
13087: x_msg_count OUT NOCOPY NUMBER,
13088: x_msg_data OUT NOCOPY VARCHAR2,
13089: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
13090: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
13091: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
13092: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
13093: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,

Line 13090: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,

13086: x_return_status OUT NOCOPY VARCHAR2,
13087: x_msg_count OUT NOCOPY NUMBER,
13088: x_msg_data OUT NOCOPY VARCHAR2,
13089: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
13090: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
13091: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
13092: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
13093: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
13094: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,

Line 13091: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,

13087: x_msg_count OUT NOCOPY NUMBER,
13088: x_msg_data OUT NOCOPY VARCHAR2,
13089: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
13090: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
13091: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
13092: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
13093: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
13094: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
13095: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type) AS

Line 13184: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

13180: l_strm_name_rec strm_name_csr%ROWTYPE;
13181: l_ib_rec ib_csr%ROWTYPE;
13182: l_struct_rec l_struct_csr%ROWTYPE;
13183: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
13184: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
13185: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
13186: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
13187: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
13188: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;

Line 13185: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

13181: l_ib_rec ib_csr%ROWTYPE;
13182: l_struct_rec l_struct_csr%ROWTYPE;
13183: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
13184: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
13185: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
13186: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
13187: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
13188: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
13189: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;

Line 13191: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

13187: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
13188: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
13189: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
13190: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
13191: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
13192: l_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
13193: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
13194: --p_deal_type okl_st_gen_tmpt_sets.deal_type%TYPE;
13195:

Line 13662: IF p_paydown_type = OKL_CREATE_STREAMS_PVT.G_PAYDOWN_TYPE_PPD THEN

13658: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
13659: (l_rl_rec.rule_information8 IS NOT NULL OR
13660: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
13661:
13662: IF p_paydown_type = OKL_CREATE_STREAMS_PVT.G_PAYDOWN_TYPE_PPD THEN
13663: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
13664: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
13665: --Modified by kthiruva on 13-Feb-2006
13666: --Bug 4964710 - Start of Changes

Line 13695: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

13691: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
13692: l_csm_line_details_tbl(j).level_index_number := idx;
13693: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
13694: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
13695: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13696: l_csm_line_details_tbl(j).rate := l_variable_rate;
13697: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
13698: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
13699: ELSE

Line 13745: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

13741: --solving for the new payment plan.
13742: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
13743: --both rate and amount
13744: IF l_ppd_assigned = 'Y' THEN
13745: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
13746: ELSIF l_ppd_assigned = 'N' THEN
13747: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13748: END IF;
13749:

Line 13747: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

13743: --both rate and amount
13744: IF l_ppd_assigned = 'Y' THEN
13745: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
13746: ELSIF l_ppd_assigned = 'N' THEN
13747: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13748: END IF;
13749:
13750: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
13751: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;

Line 13795: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

13791: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
13792: l_csm_line_details_tbl(j).level_index_number := idx;
13793: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
13794: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
13795: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13796: l_csm_line_details_tbl(j).rate := l_variable_rate;
13797: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
13798: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
13799: ELSE

Line 13852: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

13848: --solving for the new payment plan.
13849: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
13850: --both rate and amount
13851: IF l_ppd_assigned = 'Y' THEN
13852: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
13853: ELSIF l_ppd_assigned = 'N' THEN
13854: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13855: END IF;
13856:

Line 13854: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

13850: --both rate and amount
13851: IF l_ppd_assigned = 'Y' THEN
13852: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
13853: ELSIF l_ppd_assigned = 'N' THEN
13854: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13855: END IF;
13856:
13857: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
13858: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 13928: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

13924: --solving for the new payment plan.
13925: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
13926: --both rate and amount
13927: IF l_ppd_assigned = 'Y' THEN
13928: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
13929: ELSIF l_ppd_assigned = 'N' THEN
13930: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13931: END IF;
13932:

Line 13930: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

13926: --both rate and amount
13927: IF l_ppd_assigned = 'Y' THEN
13928: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
13929: ELSIF l_ppd_assigned = 'N' THEN
13930: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13931: END IF;
13932:
13933: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
13934: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 13992: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

13988: --solving for the new payment plan.
13989: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
13990: --both rate and amount
13991: IF l_ppd_assigned = 'Y' THEN
13992: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
13993: ELSIF l_ppd_assigned = 'N' THEN
13994: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13995: END IF;
13996:

Line 13994: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

13990: --both rate and amount
13991: IF l_ppd_assigned = 'Y' THEN
13992: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
13993: ELSIF l_ppd_assigned = 'N' THEN
13994: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
13995: END IF;
13996:
13997: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
13998: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 14020: IF p_paydown_type = OKL_CREATE_STREAMS_PVT.G_PAYDOWN_TYPE_PPD THEN

14016: --=================================
14017: --Step 4 : Create the paydown stub
14018: --=================================
14019:
14020: IF p_paydown_type = OKL_CREATE_STREAMS_PVT.G_PAYDOWN_TYPE_PPD THEN
14021: /*PPD stub*/
14022: j := j + 1;
14023: idx := idx + 1;
14024: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 14050: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14046: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
14047: l_csm_line_details_tbl(j).level_index_number := idx;
14048: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
14049: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
14050: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14051: l_csm_line_details_tbl(j).rate := l_variable_rate;
14052:
14053: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
14054: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 14106: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

14102: --solving for the new payment plan.
14103: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
14104: --both rate and amount
14105: IF l_ppd_assigned = 'Y' THEN
14106: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14107: ELSIF l_ppd_assigned = 'N' THEN
14108: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14109: END IF;
14110:

Line 14108: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14104: --both rate and amount
14105: IF l_ppd_assigned = 'Y' THEN
14106: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14107: ELSIF l_ppd_assigned = 'N' THEN
14108: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14109: END IF;
14110:
14111: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
14112: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 14170: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

14166: --solving for the new payment plan.
14167: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
14168: --both rate and amount
14169: IF l_ppd_assigned = 'Y' THEN
14170: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14171: ELSIF l_ppd_assigned = 'N' THEN
14172: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14173: END IF;
14174:

Line 14172: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14168: --both rate and amount
14169: IF l_ppd_assigned = 'Y' THEN
14170: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14171: ELSIF l_ppd_assigned = 'N' THEN
14172: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14173: END IF;
14174:
14175: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
14176: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 14376: IF p_paydown_type = OKL_CREATE_STREAMS_PVT.G_PAYDOWN_TYPE_PPD THEN

14372: IF (l_rl_rec.rule_information7 IS NOT NULL OR
14373: l_rl_rec.rule_information7 <> OKL_API.G_MISS_CHAR) AND
14374: (l_rl_rec.rule_information8 IS NOT NULL OR
14375: l_rl_rec.rule_information8 <> OKL_API.G_MISS_CHAR) THEN
14376: IF p_paydown_type = OKL_CREATE_STREAMS_PVT.G_PAYDOWN_TYPE_PPD THEN
14377: FOR k in l_ppd_tbl.FIRST..l_ppd_tbl.LAST LOOP
14378: --If the paydown date lies inside the stub's start and end date, create a stub for the paydown
14379: --Modified by kthiruva on 13-Feb-2006
14380: --Bug 4964710 - Start of Changes

Line 14409: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14405: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
14406: l_csm_line_details_tbl(j).level_index_number := idx;
14407: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
14408: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
14409: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14410: l_csm_line_details_tbl(j).rate := l_variable_rate;
14411: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
14412: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
14413: ELSE

Line 14459: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

14455: --solving for the new payment plan.
14456: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
14457: --both rate and amount
14458: IF l_ppd_assigned = 'Y' THEN
14459: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14460: ELSIF l_ppd_assigned = 'N' THEN
14461: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14462: END IF;
14463:

Line 14461: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14457: --both rate and amount
14458: IF l_ppd_assigned = 'Y' THEN
14459: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14460: ELSIF l_ppd_assigned = 'N' THEN
14461: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14462: END IF;
14463:
14464: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
14465: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;

Line 14509: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14505: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
14506: l_csm_line_details_tbl(j).level_index_number := idx;
14507: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
14508: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
14509: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14510: l_csm_line_details_tbl(j).rate := l_variable_rate;
14511: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
14512: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
14513: ELSE

Line 14565: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

14561: --solving for the new payment plan.
14562: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
14563: --both rate and amount
14564: IF l_ppd_assigned = 'Y' THEN
14565: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14566: ELSIF l_ppd_assigned = 'N' THEN
14567: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14568: END IF;
14569:

Line 14567: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14563: --both rate and amount
14564: IF l_ppd_assigned = 'Y' THEN
14565: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14566: ELSIF l_ppd_assigned = 'N' THEN
14567: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14568: END IF;
14569:
14570: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
14571: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 14641: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

14637: --solving for the new payment plan.
14638: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
14639: --both rate and amount
14640: IF l_ppd_assigned = 'Y' THEN
14641: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14642: ELSIF l_ppd_assigned = 'N' THEN
14643: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14644: END IF;
14645:

Line 14643: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14639: --both rate and amount
14640: IF l_ppd_assigned = 'Y' THEN
14641: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14642: ELSIF l_ppd_assigned = 'N' THEN
14643: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14644: END IF;
14645:
14646: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
14647: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 14705: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

14701: --solving for the new payment plan.
14702: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
14703: --both rate and amount
14704: IF l_ppd_assigned = 'Y' THEN
14705: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14706: ELSIF l_ppd_assigned = 'N' THEN
14707: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14708: END IF;
14709:

Line 14707: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14703: --both rate and amount
14704: IF l_ppd_assigned = 'Y' THEN
14705: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14706: ELSIF l_ppd_assigned = 'N' THEN
14707: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14708: END IF;
14709:
14710: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
14711: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 14733: IF p_paydown_type = OKL_CREATE_STREAMS_PVT.G_PAYDOWN_TYPE_PPD THEN

14729: --=================================
14730: --Step 4 : Create the paydown stub
14731: --=================================
14732:
14733: IF p_paydown_type = OKL_CREATE_STREAMS_PVT.G_PAYDOWN_TYPE_PPD THEN
14734: /*PPD stub*/
14735: j := j + 1;
14736: idx := idx + 1;
14737: l_csm_line_details_tbl(j).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PRINCIPAL;

Line 14763: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14759: l_csm_line_details_tbl(j).balance_type_code := p_balance_type_code;
14760: l_csm_line_details_tbl(j).level_index_number := idx;
14761: l_csm_line_details_tbl(j).days_in_month := l_days_in_month_code;
14762: l_csm_line_details_tbl(j).days_in_year := l_days_in_yr_code;
14763: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14764: l_csm_line_details_tbl(j).rate := l_variable_rate;
14765:
14766: /*Populate the accrual end date as well*/
14767: /*Create a stub for principal paydown*/

Line 14821: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

14817: --solving for the new payment plan.
14818: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
14819: --both rate and amount
14820: IF l_ppd_assigned = 'Y' THEN
14821: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14822: ELSIF l_ppd_assigned = 'N' THEN
14823: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14824: END IF;
14825:

Line 14823: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14819: --both rate and amount
14820: IF l_ppd_assigned = 'Y' THEN
14821: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14822: ELSIF l_ppd_assigned = 'N' THEN
14823: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14824: END IF;
14825:
14826: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
14827: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 14883: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;

14879: --solving for the new payment plan.
14880: --When l_ppd_assigned is 'N', the payment is prior to paydown and we therefore lock
14881: --both rate and amount
14882: IF l_ppd_assigned = 'Y' THEN
14883: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14884: ELSIF l_ppd_assigned = 'N' THEN
14885: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14886: END IF;
14887:

Line 14885: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;

14881: --both rate and amount
14882: IF l_ppd_assigned = 'Y' THEN
14883: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_RATE;
14884: ELSIF l_ppd_assigned = 'N' THEN
14885: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_BOTH;
14886: END IF;
14887:
14888: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
14889: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);

Line 15189: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,

15185: p_chr_id IN VARCHAR2,
15186: x_return_status OUT NOCOPY VARCHAR2,
15187: x_msg_count OUT NOCOPY NUMBER,
15188: x_msg_data OUT NOCOPY VARCHAR2,
15189: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
15190: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
15191: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
15192: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
15193: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,

Line 15190: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,

15186: x_return_status OUT NOCOPY VARCHAR2,
15187: x_msg_count OUT NOCOPY NUMBER,
15188: x_msg_data OUT NOCOPY VARCHAR2,
15189: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
15190: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
15191: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
15192: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
15193: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
15194: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,

Line 15191: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,

15187: x_msg_count OUT NOCOPY NUMBER,
15188: x_msg_data OUT NOCOPY VARCHAR2,
15189: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
15190: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
15191: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
15192: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
15193: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
15194: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
15195: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type) AS

Line 15259: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

15255: l_strm_name_rec strm_name_csr%ROWTYPE;
15256: l_ib_rec ib_csr%ROWTYPE;
15257: l_struct_rec l_struct_csr%ROWTYPE;
15258: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
15259: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
15260: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
15261: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
15262: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
15263: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;

Line 15260: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

15256: l_ib_rec ib_csr%ROWTYPE;
15257: l_struct_rec l_struct_csr%ROWTYPE;
15258: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
15259: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
15260: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
15261: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
15262: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
15263: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
15264: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;

Line 15266: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

15262: l_csm_periodic_expenses_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
15263: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
15264: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
15265: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
15266: l_csm_line_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
15267: l_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
15268: l_strm_type_id_tbl okl_strm_type_id_tbl_type;
15269: --p_deal_type okl_st_gen_tmpt_sets.deal_type%TYPE;
15270:

Line 15742: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;

15738:
15739: --When the cashflow step is a payment line, both amount and rate should not be locked
15740: -- For the PPD stub, the amount should be locked , but rate should be unlocked, as
15741: -- we are solving for rate.
15742: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;
15743: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
15744: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
15745: ELSE
15746: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

Line 15835: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;

15831:
15832: --When the cashflow step is a payment line, both amount and rate should not be locked
15833: -- For the PPD stub, the amount should be locked , but rate should be unlocked, as
15834: -- we are solving for rate.
15835: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;
15836: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
15837: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
15838: ELSE
15839: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

Line 16071: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;

16067:
16068: --When the cashflow step is a payment line, both amount and rate should not be locked
16069: -- For the PPD stub, the amount should be locked , but rate should be unlocked, as
16070: -- we are solving for rate.
16071: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;
16072:
16073: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN
16074: l_csm_line_details_tbl(j).structure := TO_NUMBER(l_rl_rec.RULE_INFORMATION5);
16075: END IF;

Line 16422: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;

16418:
16419: --When the cashflow step is a payment line, both amount and rate should not be locked
16420: -- For the PPD stub, the amount should be locked , but rate should be unlocked, as
16421: -- we are solving for rate.
16422: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;
16423: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
16424: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
16425: ELSE
16426: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

Line 16519: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;

16515:
16516: --When the cashflow step is a payment line, both amount and rate should not be locked
16517: -- For the PPD stub, the amount should be locked , but rate should be unlocked, as
16518: -- we are solving for rate.
16519: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;
16520: IF( l_strm_name_rec.stream_type_class = 'EXPENSE') THEN
16521: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_EXPENSE;
16522: ELSE
16523: l_csm_line_details_tbl(j).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

Line 16764: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;

16760:
16761: --When the cashflow step is a payment line, both amount and rate should not be locked
16762: -- For the PPD stub, the amount should be locked , but rate should be unlocked, as
16763: -- we are solving for rate.
16764: l_csm_line_details_tbl(j).LOCK_LEVEL_STEP := OKL_CREATE_STREAMS_PVT.G_LOCK_AMOUNT;
16765:
16766: /*Populate the accrual end date as well*/
16767: /*Create a stub for principal paydown*/
16768: IF( l_rl_rec.RULE_INFORMATION5 IS NOT NULL) THEN

Line 17185: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,

17181: p_chr_id IN VARCHAR2,
17182: x_return_status OUT NOCOPY VARCHAR2,
17183: x_msg_count OUT NOCOPY NUMBER,
17184: x_msg_data OUT NOCOPY VARCHAR2,
17185: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
17186: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
17187: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
17188: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
17189: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,

Line 17186: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,

17182: x_return_status OUT NOCOPY VARCHAR2,
17183: x_msg_count OUT NOCOPY NUMBER,
17184: x_msg_data OUT NOCOPY VARCHAR2,
17185: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
17186: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
17187: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
17188: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
17189: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
17190: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,

Line 17187: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,

17183: x_msg_count OUT NOCOPY NUMBER,
17184: x_msg_data OUT NOCOPY VARCHAR2,
17185: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
17186: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
17187: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
17188: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
17189: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
17190: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
17191: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type) AS

Line 17290: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,

17286: p_chr_id IN VARCHAR2,
17287: x_return_status OUT NOCOPY VARCHAR2,
17288: x_msg_count OUT NOCOPY NUMBER,
17289: x_msg_data OUT NOCOPY VARCHAR2,
17290: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
17291: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
17292: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
17293: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
17294: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,

Line 17291: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,

17287: x_return_status OUT NOCOPY VARCHAR2,
17288: x_msg_count OUT NOCOPY NUMBER,
17289: x_msg_data OUT NOCOPY VARCHAR2,
17290: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
17291: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
17292: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
17293: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
17294: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
17295: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,

Line 17292: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,

17288: x_msg_count OUT NOCOPY NUMBER,
17289: x_msg_data OUT NOCOPY VARCHAR2,
17290: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
17291: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
17292: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type,
17293: x_csm_one_off_fee_tbl OUT NOCOPY okl_create_streams_pub.csm_one_off_fee_tbl_type,
17294: x_csm_periodic_expenses_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
17295: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
17296: x_csm_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type) AS

Line 19409: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

19405: x_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
19406: x_csm_line_details_tbl okl_create_streams_pub.csm_line_details_tbl_type;
19407: x_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
19408:
19409: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
19410: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19411: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
19412: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19413:

Line 19410: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

19406: x_csm_line_details_tbl okl_create_streams_pub.csm_line_details_tbl_type;
19407: x_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
19408:
19409: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
19410: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19411: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
19412: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19413:
19414: BEGIN

Line 19411: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

19407: x_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
19408:
19409: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
19410: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19411: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
19412: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19413:
19414: BEGIN
19415:

Line 19412: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

19408:
19409: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
19410: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19411: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
19412: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19413:
19414: BEGIN
19415:
19416:

Line 19661: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

19657: x_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
19658: x_csm_line_details_tbl okl_create_streams_pub.csm_line_details_tbl_type;
19659: x_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
19660:
19661: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
19662: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19663: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
19664: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19665:

Line 19662: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

19658: x_csm_line_details_tbl okl_create_streams_pub.csm_line_details_tbl_type;
19659: x_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
19660:
19661: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
19662: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19663: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
19664: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19665:
19666: p_pdtv_rec pdtv_rec_type;

Line 19663: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

19659: x_rents_tbl okl_create_streams_pub.csm_periodic_expenses_tbl_type;
19660:
19661: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
19662: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19663: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
19664: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19665:
19666: p_pdtv_rec pdtv_rec_type;
19667: x_pdt_parameter_rec pdt_param_rec_type;

Line 19664: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

19660:
19661: x_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
19662: x_csm_lines_details_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19663: x_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
19664: x_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
19665:
19666: p_pdtv_rec pdtv_rec_type;
19667: x_pdt_parameter_rec pdt_param_rec_type;
19668: x_no_data_found BOOLEAN;

Line 21821: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,

21817: x_csm_yields_tbl OUT NOCOPY okl_create_streams_pub.csm_yields_tbl_type,
21818: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
21819: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
21820: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
21821: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
21822: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
21823: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type)
21824: IS
21825: l_api_name CONSTANT VARCHAR2(30) := 'EXTRACT_PARAMS_SO';

Line 21822: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,

21818: x_req_stream_types_tbl OUT NOCOPY okl_create_streams_pub.csm_stream_types_tbl_type,
21819: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
21820: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
21821: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
21822: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
21823: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type)
21824: IS
21825: l_api_name CONSTANT VARCHAR2(30) := 'EXTRACT_PARAMS_SO';
21826: lv_fed_only VARCHAR2(3) := 'N';

Line 21823: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type)

21819: x_csm_line_details_tbl OUT NOCOPY okl_create_streams_pub.csm_line_details_tbl_type,
21820: x_rents_tbl OUT NOCOPY okl_create_streams_pub.csm_periodic_expenses_tbl_type,
21821: x_csm_loan_header OUT NOCOPY okl_create_streams_pvt.csm_loan_rec_type,
21822: x_csm_loan_lines_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_line_tbl_type,
21823: x_csm_loan_levels_tbl OUT NOCOPY okl_create_streams_pvt.csm_loan_level_tbl_type)
21824: IS
21825: l_api_name CONSTANT VARCHAR2(30) := 'EXTRACT_PARAMS_SO';
21826: lv_fed_only VARCHAR2(3) := 'N';
21827: ln_value NUMBER := 0;

Line 22219: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

22215: l_csm_one_off_fee_tbl okl_create_streams_pub.csm_one_off_fee_tbl_type;
22216: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
22217: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
22218: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
22219: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
22220: l_csm_loan_details_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
22221: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
22222:
22223: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;

Line 22220: l_csm_loan_details_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

22216: l_csm_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
22217: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
22218: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
22219: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
22220: l_csm_loan_details_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
22221: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
22222:
22223: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
22224:

Line 22221: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;

22217: l_req_stream_types_tbl okl_create_streams_pub.csm_stream_types_tbl_type;
22218: l_csm_yields_tbl okl_create_streams_pub.csm_yields_tbl_type;
22219: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
22220: l_csm_loan_details_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
22221: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
22222:
22223: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;
22224:
22225: --mansrini : Code for VR build