[Home] [Help]
1238: IF px_qte_line_dtl_tbl(k).qte_line_index = px_qte_line_tbl(px_k2q_line_tbl(i).q_line_idx).line_number THEN
1239: --
1240: -- Need to ensure that qdl(k) has a covered line
1241: --
1242: IF px_qte_line_dtl_tbl(k).service_ref_type_code = okc_oc_int_ktq_pvt.g_qte_ref_quote THEN
1243: -- Now this is a covered line and hence the relationship needs to be created
1244: -- Need to use the index of the related quote line (service line).
1245:
1246: IF NVL(px_qte_line_dtl_tbl(k).service_ref_qte_line_index,OKC_API.G_MISS_NUM) <>
1281: okc_util.print_trace(2,'Rltd qte line idx = '||l_line_rltship_tab(p).related_qte_line_index);
1282: okc_util.print_trace(2,'rltshp type code = '||l_line_rltship_tab(p).relationship_type_code);
1283: END IF;
1284:
1285: END IF; -- IF px_qte_line_dtl_tbl(k).service_ref_type_code = okc_oc_int_ktq_pvt.g_qte_ref_quote
1286:
1287: EXIT;
1288:
1289: END IF; -- px_qte_line_dtl_tbl(k).qte_line_index = px_qte_line_tbl(px
1305: IF px_qte_line_dtl_tbl(k).qte_line_index = px_qte_line_tbl(px_k2q_line_tbl(i).q_line_idx).line_number THEN
1306: --
1307: -- Need to ensure that qdl(k) has a covered line
1308: --
1309: IF px_qte_line_dtl_tbl(k).service_ref_type_code = okc_oc_int_ktq_pvt.g_qte_ref_quote THEN
1310:
1311: -- Need to use the id of the related quote line (service line).
1312:
1313: IF NVL(px_qte_line_dtl_tbl(k).service_ref_qte_line_index,OKC_API.G_MISS_NUM) <>
1373:
1374: END IF;
1375: CLOSE c_qte_line_rlt;
1376:
1377: END IF; -- IF px_qte_line_dtl_tbl(k).service_ref_type_code = okc_oc_int_ktq_pvt.g_qte_ref_quote THEN
1378:
1379: END IF; -- px_qte_line_dtl_tbl(k).qte_line_index = px_qte_li
1380:
1381: END LOOP; -- FOR k IN px_qte_line_dtl_tbl.FIRST..px_q