[Home] [Help]
1228: END IF;
1229:
1230: SELECT lse.lty_code
1231: INTO l_lty_code
1232: FROM okc_k_lines_b cle,
1233: okc_line_styles_b lse
1234: WHERE cle.id = p_cle_id
1235: AND cle.lse_id = lse.id;
1236:
1309: END IF;
1310: l_laslh_id := lx_rulv_rec.id;
1311: END IF;
1312: IF (p_payment_levels_tbl.COUNT > 0) THEN
1313: SELECT start_date INTO l_start_date FROM okc_k_lines_b where id = p_cle_id;
1314:
1315: IF(l_debug_enabled='Y') THEN
1316: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.validate_payment_details'
1317: ,'begin debug call validate_payment_details');
1619: l_create_line_item_tbl(k).serv_cov_prd_id := NULL;
1620:
1621: SELECT txl.asset_number
1622: INTO l_create_line_item_tbl(k).name
1623: FROM okc_k_lines_b cle,
1624: okc_line_styles_b lse,
1625: okl_txl_assets_b txl
1626: WHERE cle.id = txl.kle_id
1627: AND cle.lse_id = lse.id
2754: l_cre_counter NUMBER;
2755: l_line_number NUMBER;
2756: l_asset_number VARCHAR2(150);
2757: lx_return_status VARCHAR2(1);
2758: l_model_line_id okc_k_lines_b.id%TYPE;
2759: l_addon_item_id okc_k_items.object1_id1%TYPE;
2760: l_addon_unit_cost okc_k_lines_b.price_unit%TYPE;
2761: l_addon_modified BOOLEAN;
2762: TYPE qte_cntrct_addon_rec_type IS RECORD (qte_addon_id NUMBER,
2756: l_asset_number VARCHAR2(150);
2757: lx_return_status VARCHAR2(1);
2758: l_model_line_id okc_k_lines_b.id%TYPE;
2759: l_addon_item_id okc_k_items.object1_id1%TYPE;
2760: l_addon_unit_cost okc_k_lines_b.price_unit%TYPE;
2761: l_addon_modified BOOLEAN;
2762: TYPE qte_cntrct_addon_rec_type IS RECORD (qte_addon_id NUMBER,
2763: addon_supplier_id NUMBER,
2764: cntrct_addon_id NUMBER);
2766:
2767: CURSOR find_model_line_id_csr (p_fin_line_id NUMBER) IS
2768: -- to find id for model line style 34 which is parent of ADD ON Line
2769: SELECT cle.id MODEL_LINE_ID
2770: FROM okc_k_lines_b cle,
2771: okc_line_styles_b cls
2772: WHERE cle.cle_id = p_fin_line_id
2773: AND cle.lse_id = cls.id
2774: AND cls.lty_code = 'ITEM';