[Home] [Help]
1207: WHERE ast.id = p_ast_id;
1208: CURSOR get_fee_lq_id_csr( p_fee_id NUMBER )
1209: IS
1210: SELECT fee.parent_object_id lq_id
1211: FROM okl_fees_b fee
1212: WHERE fee.id = p_fee_id;
1213:
1214: -- Local Variables
1215: l_api_version CONSTANT NUMBER DEFAULT 1.0;
6744: SELECT target_arrears,
6745: target_amount,
6746: parent_object_id,
6747: payment_type_id
6748: FROM OKL_FEES_B
6749: WHERE id = p_feeId;
6750: -- Cursor to fetch the Cash flow header information
6751: CURSOR lq_cash_flows_csr( p_id NUMBER, p_cf_source_type VARCHAR2 )
6752: IS
6946: RAISE OKL_API.G_EXCEPTION_ERROR;
6947: END IF;
6948: l_cash_flow_det_tbl(1).number_of_periods := quote_rec.term / l_months_factor;
6949: --l_cash_flow_det_tbl(1).amount has been already fetched from the
6950: -- target_amount column either from OKL_LEASE_QUOTES_B/OKL_ASSETS_B/OKL_FEES_B
6951: ELSE
6952: -- When the LQ is being priced for SM pricng method, on selecting the SRT
6953: -- as the pricing option, the user will be shown to enter the Cash flow levels too.
6954: -- Hence, retrieve the cash flow levels even when the pricing option is SRT.
7041: IF p_cf_source = G_CF_SOURCE_LQ_FEE
7042: THEN
7043: -- For Rollover/Financed fee, though the PM is TR, where LLO is not applicable
7044: -- there also, pricing will fetch Adv/Arrears, Rate, Frequency will be fetched
7045: -- from the quote, but the Payment Stream ID will be store in the okl_fees_b.payment_sty_id
7046: FOR t_rec IN fee_details_csr( p_id )
7047: LOOP
7048: l_cash_flow_rec.sty_id := t_rec.payment_type_id;
7049: END LOOP;
8901: CURSOR fees_csr(qteid NUMBER,
8902: fee_id NUMBER)
8903: IS
8904: SELECT stytl.name
8905: FROM okl_fees_b fee,
8906: okl_strm_type_tl stytl
8907: WHERE fee.parent_object_code = 'LEASEQUOTE'
8908: AND fee.parent_object_id = qteid
8909: AND fee.id = fee_id
8947: fee.lease_rate_factor lease_rate_factor,
8948: fee.fee_type || ' FEE' name,
8949: fee.target_frequency target_frequency,
8950: fee.target_arrears target_arrears
8951: FROM okl_fees_b fee,
8952: okl_lease_quotes_b qte
8953: WHERE fee.parent_object_code = 'LEASEQUOTE'
8954: AND fee.parent_object_id = qte.id
8955: AND qte.id = qteid
9928: THEN
9929: l_cashflow_header_rec.parent_object_code := 'QUOTED_FEE';
9930: FOR t_rec IN check_cfo_exists_csr(
9931: p_oty_code => 'QUOTED_FEE',
9932: p_source_table => 'OKL_FEES_B',
9933: p_source_id => p_ast_id)
9934: LOOP
9935: l_cfo_exists := t_rec.cfo_exists;
9936: l_sty_id := t_rec.sty_id;
10655: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
10656: '!!!!! Fetching the Expense Cash flows for fee type ' || p_fee_type );
10657: FOR t_rec IN lq_cash_flows_csr(
10658: p_id => p_fee_id,
10659: p_cf_source => 'OKL_FEES_B',
10660: p_cft_code => 'OUTFLOW_SCHEDULE')
10661: LOOP
10662: x_outflow_caf_rec.caf_id := t_rec.caf_id;
10663: x_outflow_caf_rec.khr_id := t_rec.khr_id;
10722: '!!!!! Fetching the Income Cash flows for fee type ' || p_fee_type );
10723: l_return_status := OKL_API.G_RET_STS_ERROR;
10724: FOR t_rec IN lq_cash_flows_csr(
10725: p_id => p_fee_id,
10726: p_cf_source => 'OKL_FEES_B',
10727: p_cft_code => 'PAYMENT_SCHEDULE')
10728: LOOP
10729: x_inflow_caf_rec.caf_id := t_rec.caf_id;
10730: x_inflow_caf_rec.khr_id := t_rec.khr_id;
11563: fee.effective_to line_end_date,
11564: fee.lease_rate_factor lease_rate_factor,
11565: fee.target_arrears target_arrears,
11566: NULL oec_percentage
11567: FROM okl_fees_b fee,
11568: okl_lease_quotes_b qte
11569: WHERE fee.parent_object_code = 'LEASEQUOTE'
11570: AND fee.parent_object_id = qte.id
11571: AND qte.id = qteid;
11801: l_amount NUMBER;
11802: l_sum_assoc_assets_amt NUMBER;
11803: l_assoc_assets_count NUMBER;
11804: l_assets_indx NUMBER;
11805: l_fee_id OKL_FEES_B.ID%TYPE;
11806:
11807: TYPE amount_tabtype IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
11808: l_amount_tbl amount_tabtype;
11809: