[Home] [Help]
1223: END IF;
1224:
1225: SELECT lse.lty_code
1226: INTO l_lty_code
1227: FROM okc_k_lines_b cle,
1228: okc_line_styles_b lse
1229: WHERE cle.id = p_cle_id
1230: AND cle.lse_id = lse.id;
1231:
1304: END IF;
1305: l_laslh_id := lx_rulv_rec.id;
1306: END IF;
1307: IF (p_payment_levels_tbl.COUNT > 0) THEN
1308: SELECT start_date INTO l_start_date FROM okc_k_lines_b where id = p_cle_id;
1309:
1310: IF(l_debug_enabled='Y') THEN
1311: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.validate_payment_details'
1312: ,'begin debug call validate_payment_details');
1615: l_create_line_item_tbl(k).serv_cov_prd_id := NULL;
1616:
1617: SELECT txl.asset_number
1618: INTO l_create_line_item_tbl(k).name
1619: FROM okc_k_lines_b cle,
1620: okc_line_styles_b lse,
1621: okl_txl_assets_b txl
1622: WHERE cle.id = txl.kle_id
1623: AND cle.lse_id = lse.id
2716: l_cre_counter NUMBER;
2717: l_line_number NUMBER;
2718: l_asset_number VARCHAR2(150);
2719: lx_return_status VARCHAR2(1);
2720: l_model_line_id okc_k_lines_b.id%TYPE;
2721: l_addon_item_id okc_k_items.object1_id1%TYPE;
2722: l_addon_unit_cost okc_k_lines_b.price_unit%TYPE;
2723: l_addon_modified BOOLEAN;
2724: TYPE qte_cntrct_addon_rec_type IS RECORD (qte_addon_id NUMBER,
2718: l_asset_number VARCHAR2(150);
2719: lx_return_status VARCHAR2(1);
2720: l_model_line_id okc_k_lines_b.id%TYPE;
2721: l_addon_item_id okc_k_items.object1_id1%TYPE;
2722: l_addon_unit_cost okc_k_lines_b.price_unit%TYPE;
2723: l_addon_modified BOOLEAN;
2724: TYPE qte_cntrct_addon_rec_type IS RECORD (qte_addon_id NUMBER,
2725: addon_supplier_id NUMBER,
2726: cntrct_addon_id NUMBER);
2728:
2729: CURSOR find_model_line_id_csr (p_fin_line_id NUMBER) IS
2730: -- to find id for model line style 34 which is parent of ADD ON Line
2731: SELECT cle.id MODEL_LINE_ID
2732: FROM okc_k_lines_b cle,
2733: okc_line_styles_b cls
2734: WHERE cle.cle_id = p_fin_line_id
2735: AND cle.lse_id = cls.id
2736: AND cls.lty_code = 'ITEM';