[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'
603: ,lsq.expected_start_date
604: ,lsq.term
605: ,lsq.pricing_method
606: FROM
607: okl_lease_quotes_b lsq
608: ,okl_lease_opportunities_b lop
609: WHERE lsq.id = p_quote_id
610: AND lsq.parent_object_code = 'LEASEOPP'
611: AND lsq.parent_object_id = lop.id;
616: ,lsq.expected_start_date
617: ,lsq.term
618: ,lsq.pricing_method
619: FROM
620: okl_lease_quotes_b lsq
621: ,okl_lease_applications_b lap
622: WHERE lsq.id = p_quote_id
623: AND lsq.parent_object_code = 'LEASEAPP'
624: AND lsq.parent_object_id = lap.id;
835: l_cfov_rec.source_table := 'OKL_SERVICES_B';
836: ELSIF (p_cashflow_header_rec.parent_object_code = 'QUOTED_INSURANCE') THEN
837: l_cfov_rec.source_table := 'OKL_INSURANCE_ESTIMATES_B';
838: ELSIF (p_cashflow_header_rec.parent_object_code = 'LEASE_QUOTE') THEN
839: l_cfov_rec.source_table := 'OKL_LEASE_QUOTES_B';
840: ELSIF (p_cashflow_header_rec.parent_object_code = 'QUICK_QUOTE') THEN
841: l_cfov_rec.source_table := 'OKL_QUICK_QUOTES_B';
842: ELSIF (p_cashflow_header_rec.parent_object_code = 'QUICK_QUOTE_ASSET') THEN
843: l_cfov_rec.source_table := 'OKL_QUICK_QUOTE_LINES_B';
849: l_cfov_rec.source_table := 'OKL_QUICK_QUOTE_LINES_B';
850: ELSIF (p_cashflow_header_rec.parent_object_code = 'QUICK_QUOTE_INSURANCE') THEN
851: l_cfov_rec.source_table := 'OKL_QUICK_QUOTE_LINES_B';
852: ELSIF (p_cashflow_header_rec.parent_object_code = 'LEASE_QUOTE_CONSOLIDATED') THEN
853: l_cfov_rec.source_table := 'OKL_LEASE_QUOTES_B';
854: END IF;
855:
856: okl_cfo_pvt.insert_row (
857: p_api_version => G_API_VERSION
1555:
1556: CURSOR c_lq_hdr_rec_cur(p_lease_quote_id NUMBER)
1557: IS
1558: SELECT pricing_method,status,parent_object_code
1559: FROM OKL_LEASE_QUOTES_B
1560: where id = p_lease_quote_id;
1561: --Bug # 5021937 ssdeshpa end;
1562: CURSOR c_cf_objects (p_oty_code VARCHAR2, p_source_table VARCHAR2, p_source_id NUMBER)
1563: IS
1639: /*
1640: -- Fetch the Quote type
1641: SELECT parent_object_code
1642: INTO lv_parent_object_code
1643: FROM okl_lease_quotes_b
1644: WHERE id = p_quote_id;*/
1645:
1646: IF (lv_parent_object_code = 'LEASEOPP') THEN
1647: l_cashflow_header_rec.quote_type_code := 'LQ';
2058: CURSOR csr_sm_cashflow_levels IS
2059: SELECT distinct a.id, a.object_version_number
2060: FROM okl_cash_flow_levels a,
2061: okl_cash_flows b,
2062: okl_lease_quotes_b qte
2063: WHERE a.caf_id = b.id
2064: AND a.missing_pmt_flag = 'Y'
2065: AND B.DNZ_QTE_ID = p_quote_id
2066: AND B.DNZ_QTE_ID = qte.id
2179: --if additional lines are available for pricinig method
2180: --ss or si or sd then delete respective adjustments.
2181: SELECT pricing_method
2182: INTO l_pricing_method
2183: FROM okl_lease_quotes_b
2184: WHERE ID = p_quote_id;
2185:
2186: i := 0;
2187: IF l_pricing_method = 'SS' THEN