[Home] [Help]
25:
26:
27:
28: CURSOR c_qq_header_rec(p_quote_id NUMBER) IS
29: SELECT t1.* FROM OKL_QUICK_QUOTES_B t1
30: WHERE t1.id = p_quote_id;
31:
32: CURSOR c_lq_header_rec(p_quote_id NUMBER) IS
33: SELECT t1.* FROM OKL_LEASE_QUOTES_B t1
1469: AND oac.primary_component='YES'
1470: AND oab.parent_object_id=p_lease_quote_id;
1471: --Fix Bug # 4898499 End
1472: cursor c_qq_asset_lines_rec(p_quick_quote_id NUMBER,p_pricing_method VARCHAR2,p_type VARCHAR2) IS
1473: select t2.* from OKL_QUICK_QUOTES_B t1,OKL_QUICK_QUOTE_LINES_B t2
1474: WHERE t1.PRICING_METHOD=p_pricing_method
1475: AND t2.type=p_type
1476: AND t1.id=p_quick_quote_id
1477: AND t2.quick_quote_id=t1.id;
1780: x_eligible boolean;
1781: l_obj_name okl_fe_std_rt_tmp_v.template_name%TYPE;
1782: l_message_name VARCHAR2(30);
1783: cursor c_qq_header_rec(p_quote_id NUMBER) IS
1784: SELECT t1.* FROM OKL_QUICK_QUOTES_B t1
1785: WHERE t1.id = p_quote_id;
1786: lp_qq_header_rec c_qq_header_rec%ROWTYPE;
1787:
1788: cursor c_qq_assets_cost(p_quick_quote_id NUMBER) IS
2191: lp_rec_flag VARCHAR2(1);
2192: i INTEGER;
2193:
2194: cursor c_qq_header_rec(p_quick_quote_id NUMBER) IS
2195: SELECT t1.* FROM OKL_QUICK_QUOTES_B t1
2196: WHERE t1.id = p_quick_quote_id;
2197: lp_qq_header_rec c_qq_header_rec%ROWTYPE;
2198:
2199: cursor c_qq_assets_cost(p_quick_quote_id NUMBER) IS
2649: l_program_name CONSTANT VARCHAR2(30) := 'chk_ss';
2650: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
2651:
2652: cursor c_qq_asset_lines_rec(p_quick_quote_id NUMBER) IS
2653: select t2.* from OKL_QUICK_QUOTES_B t1,OKL_QUICK_QUOTE_LINES_B t2
2654: WHERE t1.PRICING_METHOD='SF'
2655: AND t2.type='SUBSIDY'
2656: AND t1.id=p_quick_quote_id
2657: AND t2.quick_quote_id=t1.id;
4608:
4609: IF(p_object_type='QUICKQUOTE') THEN
4610: --Check Payment For SFFA,SFY and SFS Methods
4611: SELECT count(1) INTO l_cnt
4612: from OKL_QUICK_QUOTES_B
4613: WHERE ID=lp_quote_id
4614: AND PRICING_METHOD IN('SF','SS','SY');
4615: IF(l_cnt >= 1) THEN
4616: OPEN c_lq_cfl_line(lp_quote_id ,'QUICK_QUOTE');
4638:
4639: END IF;
4640:
4641: SELECT TRUNC(EXPECTED_START_DATE) INTO lp_cont_start_date
4642: FROM OKL_QUICK_QUOTES_B
4643: WHERE ID=lp_quote_id;
4644:
4645: ---Check for the VPA Effective Dates Fall within the Expected Start Date
4646: select TRUNC(EXPECTED_START_DATE),PROGRAM_AGREEMENT_ID INTO lp_cont_start_date,lp_vp_id
4643: WHERE ID=lp_quote_id;
4644:
4645: ---Check for the VPA Effective Dates Fall within the Expected Start Date
4646: select TRUNC(EXPECTED_START_DATE),PROGRAM_AGREEMENT_ID INTO lp_cont_start_date,lp_vp_id
4647: from OKL_QUICK_QUOTES_B
4648: WHERE ID=lp_quote_id;
4649:
4650: IF(lp_vp_id IS NOT NULL) THEN
4651: OPEN c_vp_rec(lp_vp_id ,lp_cont_start_date);