[Home] [Help]
135:
136: CURSOR l_chk_cle_csr IS
137: SELECT clev.cle_id, RTRIM(clev.line_number) line_number
138: FROM
139: OKC_K_LINES_V clev
140: WHERE
141: clev.id = p_cle_id;
142:
143: CURSOR l_get_top_line_number_csr (p_line_id NUMBER) IS
148: CURSOR l_line_name_csr IS
149: SELECT RTRIM(RTRIM(line_number) || ', ' || RTRIM(lsev.name) || ' ' ||
150: RTRIM(clev.name)) "LINE_NAME"
151: FROM OKC_LINE_STYLES_V lsev,
152: OKC_K_LINES_V clev
153: WHERE lsev.id = clev.lse_id
154: AND clev.id = p_cle_id;
155:
156: l_line_name_rec l_line_name_csr%ROWTYPE;
1205: , cim.object1_id1
1206: , cim.object1_id2
1207: FROM OKC_K_ITEMS cim,
1208: OKC_LINE_STYLES_B lse,
1209: OKC_K_LINES_V cle
1210: WHERE cim.cle_id = cle.id
1211: and lse.id = cle.lse_id
1212: and cle.chr_id = p_chr_id
1213: and cle.date_cancelled is null --Changes [llc]
1228: , cim.object1_id2
1229: , cle.date_terminated
1230: FROM OKC_K_ITEMS cim,
1231: OKC_LINE_STYLES_B lse,
1232: OKC_K_LINES_V cle
1233: WHERE cim.cle_id = cle.id
1234: AND lse.LTY_CODE IN
1235: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',
1236: 'COVER_PTY', 'COVER_SITE', 'COVER_SYS','INST_CTR')
1253: nvl(rtrim(trgtl.line_number) || '.' || RTRIM(trgsl.line_number) ||', '|| RTRIM(trgst.name) ||' '|| RTRIM(trgsl.name), OKC_API.G_MISS_CHAR) trg_name,
1254: nvl(rtrim(srctl.line_number) || '.' || RTRIM(srcsl.line_number) ||', '|| RTRIM(srcst.name) ||' '|| RTRIM(srcsl.name), OKC_API.G_MISS_CHAR) src_name,
1255: srcsl.id srcsl_id
1256: FROM okc_k_headers_all_b trgh,
1257: okc_k_lines_v trgsl,
1258: okc_k_items trgi,
1259: okc_k_lines_b trgtl,
1260: okc_line_styles_v trgst,
1261: okc_k_lines_v srcsl,
1257: okc_k_lines_v trgsl,
1258: okc_k_items trgi,
1259: okc_k_lines_b trgtl,
1260: okc_line_styles_v trgst,
1261: okc_k_lines_v srcsl,
1262: okc_k_items srci,
1263: okc_k_lines_b srctl,
1264: okc_line_styles_v srcst,
1265: okc_statuses_b sts
1552: cle.start_date, cle.end_date,
1553: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1554: FROM OKC_K_ITEMS cim,
1555: OKC_LINE_STYLES_B lse,
1556: OKC_K_LINES_V cle
1557: WHERE cim.cle_id = cle.id
1558: AND lse.id = cle.lse_id
1559: AND cle.chr_id = p_chr_id
1560: AND cle.date_cancelled IS NULL --Changes [llc]
1567: cle.start_date, cle.end_date, lse.lty_code,
1568: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1569: FROM OKC_K_ITEMS cim,
1570: OKC_LINE_STYLES_B lse,
1571: OKC_K_LINES_V cle
1572: WHERE cim.cle_id = cle.id
1573: AND lse.LTY_CODE IN
1574: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',
1575: 'COVER_PTY', 'COVER_SITE', 'COVER_SYS', 'INST_CTR')
1648: in authoring form is no longer mandatory - Bug #2364436 - Anupama */
1649:
1650: CURSOR l_cvd_lvl_csr (p_cle_id NUMBER) IS
1651: SELECT cle.id id
1652: FROM okc_k_lines_v cle, okc_line_styles_v lse
1653: WHERE lse.id = cle.lse_id
1654: AND lse.LTY_CODE IN
1655: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',
1656: 'COVER_PTY', 'COVER_SITE', 'COVER_SYS', 'INST_CTR')
2059: l_date_cancelled DATE;
2060:
2061: CURSOR l_cle1_csr IS
2062: SELECT cle.id
2063: FROM OKC_K_LINES_V cle
2064: WHERE cle.dnz_chr_id = p_chr_id
2065: AND cle.name IS NULL
2066: AND cle.date_cancelled IS NULL ; --Changes [llc]
2067:
2189:
2190: /*** Get all service lines for given Contract header id ***/
2191: CURSOR l_csr_get_service_line_id(p_chr_id NUMBER) IS
2192: SELECT cle.id, sts.ste_code sts_code
2193: FROM okc_k_lines_v cle,
2194: okc_statuses_b sts
2195: WHERE cle.dnz_chr_id = p_chr_id
2196: AND sts.code = cle.sts_code
2197: AND cle.lse_id IN (1, 19);
2213:
2214: /*** Get all product lines and item lines for each service line ***/
2215: CURSOR l_csr_get_product_line_id IS
2216: SELECT id, start_date
2217: FROM okc_k_lines_v
2218: WHERE cle_id = l_service_id
2219: AND lse_id IN (9, 25, 7); -- 7 added for bug#2430496
2220:
2221: