[Home] [Help]
99: x_source_table := 'OKL_SERVICES_B';
100: ELSIF (p_source_object_code = 'QUOTED_INSURANCE') THEN
101: x_source_table := 'OKL_INSURANCE_ESTIMATES_B';
102: ELSIF (p_source_object_code = 'LEASE_QUOTE') THEN
103: x_source_table := 'OKL_LEASE_QUOTES_B';
104: ELSIF (p_source_object_code = 'QUICK_QUOTE') THEN
105: x_source_table := 'OKL_QUICK_QUOTES_B';
106: ELSIF (p_source_object_code = 'QUICK_QUOTE_ASSET') THEN
107: x_source_table := 'OKL_QUICK_QUOTE_LINES_B';
113: x_source_table := 'OKL_QUICK_QUOTE_LINES_B';
114: ELSIF (p_source_object_code = 'QUICK_QUOTE_INSURANCE') THEN
115: x_source_table := 'OKL_QUICK_QUOTE_LINES_B';
116: ELSIF (p_source_object_code = 'LEASE_QUOTE_CONSOLIDATED') THEN
117: x_source_table := 'OKL_LEASE_QUOTES_B';
118: ELSE
119: OKL_API.SET_MESSAGE (
120: p_app_name => G_APP_NAME
121: ,p_msg_name => 'OKL_INVALID_VALUE2'
605: ,lsq.expected_start_date
606: ,lsq.term
607: ,lsq.pricing_method
608: FROM
609: okl_lease_quotes_b lsq
610: ,okl_lease_opportunities_b lop
611: WHERE lsq.id = p_quote_id
612: AND lsq.parent_object_code = 'LEASEOPP'
613: AND lsq.parent_object_id = lop.id;
618: ,lsq.expected_start_date
619: ,lsq.term
620: ,lsq.pricing_method
621: FROM
622: okl_lease_quotes_b lsq
623: ,okl_lease_applications_b lap
624: WHERE lsq.id = p_quote_id
625: AND lsq.parent_object_code = 'LEASEAPP'
626: AND lsq.parent_object_id = lap.id;
837: l_cfov_rec.source_table := 'OKL_SERVICES_B';
838: ELSIF (p_cashflow_header_rec.parent_object_code = 'QUOTED_INSURANCE') THEN
839: l_cfov_rec.source_table := 'OKL_INSURANCE_ESTIMATES_B';
840: ELSIF (p_cashflow_header_rec.parent_object_code = 'LEASE_QUOTE') THEN
841: l_cfov_rec.source_table := 'OKL_LEASE_QUOTES_B';
842: ELSIF (p_cashflow_header_rec.parent_object_code = 'QUICK_QUOTE') THEN
843: l_cfov_rec.source_table := 'OKL_QUICK_QUOTES_B';
844: ELSIF (p_cashflow_header_rec.parent_object_code = 'QUICK_QUOTE_ASSET') THEN
845: l_cfov_rec.source_table := 'OKL_QUICK_QUOTE_LINES_B';
851: l_cfov_rec.source_table := 'OKL_QUICK_QUOTE_LINES_B';
852: ELSIF (p_cashflow_header_rec.parent_object_code = 'QUICK_QUOTE_INSURANCE') THEN
853: l_cfov_rec.source_table := 'OKL_QUICK_QUOTE_LINES_B';
854: ELSIF (p_cashflow_header_rec.parent_object_code = 'LEASE_QUOTE_CONSOLIDATED') THEN
855: l_cfov_rec.source_table := 'OKL_LEASE_QUOTES_B';
856: END IF;
857:
858: okl_cfo_pvt.insert_row (
859: p_api_version => G_API_VERSION
1557:
1558: CURSOR c_lq_hdr_rec_cur(p_lease_quote_id NUMBER)
1559: IS
1560: SELECT pricing_method,status,parent_object_code
1561: FROM OKL_LEASE_QUOTES_B
1562: where id = p_lease_quote_id;
1563: --Bug # 5021937 ssdeshpa end;
1564: CURSOR c_cf_objects (p_oty_code VARCHAR2, p_source_table VARCHAR2, p_source_id NUMBER)
1565: IS
1643: /*
1644: -- Fetch the Quote type
1645: SELECT parent_object_code
1646: INTO lv_parent_object_code
1647: FROM okl_lease_quotes_b
1648: WHERE id = p_quote_id;*/
1649:
1650: IF (lv_parent_object_code = 'LEASEOPP') THEN
1651: l_cashflow_header_rec.quote_type_code := 'LQ';
2069: CURSOR csr_sm_cashflow_levels IS
2070: SELECT distinct a.id, a.object_version_number
2071: FROM okl_cash_flow_levels a,
2072: okl_cash_flows b,
2073: okl_lease_quotes_b qte
2074: WHERE a.caf_id = b.id
2075: AND a.missing_pmt_flag = 'Y'
2076: AND B.DNZ_QTE_ID = p_quote_id
2077: AND B.DNZ_QTE_ID = qte.id
2190: --if additional lines are available for pricinig method
2191: --ss or si or sd then delete respective adjustments.
2192: SELECT pricing_method
2193: INTO l_pricing_method
2194: FROM okl_lease_quotes_b
2195: WHERE ID = p_quote_id;
2196:
2197: i := 0;
2198: IF l_pricing_method = 'SS' THEN