[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;
1268: , cim.object1_id1
1269: , cim.object1_id2
1270: FROM OKC_K_ITEMS cim,
1271: OKC_LINE_STYLES_B lse,
1272: OKC_K_LINES_V cle
1273: WHERE cim.cle_id = cle.id
1274: and lse.id = cle.lse_id
1275: and cle.chr_id = p_chr_id
1276: and cle.date_cancelled is null --Changes [llc]
1291: , cim.object1_id2
1292: , cle.date_terminated
1293: FROM OKC_K_ITEMS cim,
1294: OKC_LINE_STYLES_B lse,
1295: OKC_K_LINES_V cle
1296: WHERE cim.cle_id = cle.id
1297: AND lse.LTY_CODE IN
1298: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',
1299: 'COVER_PTY', 'COVER_SITE', 'COVER_SYS','INST_CTR')
1316: nvl(rtrim(trgtl.line_number) || '.' || RTRIM(trgsl.line_number) ||', '|| RTRIM(trgst.name) ||' '|| RTRIM(trgsl.name), OKC_API.G_MISS_CHAR) trg_name,
1317: nvl(rtrim(srctl.line_number) || '.' || RTRIM(srcsl.line_number) ||', '|| RTRIM(srcst.name) ||' '|| RTRIM(srcsl.name), OKC_API.G_MISS_CHAR) src_name,
1318: srcsl.id srcsl_id
1319: FROM okc_k_headers_all_b trgh,
1320: okc_k_lines_v trgsl,
1321: okc_k_items trgi,
1322: okc_k_lines_b trgtl,
1323: okc_line_styles_v trgst,
1324: okc_k_lines_v srcsl,
1320: okc_k_lines_v trgsl,
1321: okc_k_items trgi,
1322: okc_k_lines_b trgtl,
1323: okc_line_styles_v trgst,
1324: okc_k_lines_v srcsl,
1325: okc_k_items srci,
1326: okc_k_lines_b srctl,
1327: okc_line_styles_v srcst,
1328: okc_statuses_b sts
1621: cle.start_date, cle.end_date,
1622: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1623: FROM OKC_K_ITEMS cim,
1624: OKC_LINE_STYLES_B lse,
1625: OKC_K_LINES_V cle
1626: WHERE cim.cle_id = cle.id
1627: AND lse.id = cle.lse_id
1628: AND cle.chr_id = p_chr_id
1629: AND cle.date_cancelled IS NULL --Changes [llc]
1636: cle.start_date, cle.end_date, lse.lty_code,
1637: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
1638: FROM OKC_K_ITEMS cim,
1639: OKC_LINE_STYLES_B lse,
1640: OKC_K_LINES_V cle
1641: WHERE cim.cle_id = cle.id
1642: AND lse.LTY_CODE IN
1643: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',
1644: 'COVER_PTY', 'COVER_SITE', 'COVER_SYS', 'INST_CTR')
1717: in authoring form is no longer mandatory - Bug #2364436 - Anupama */
1718:
1719: CURSOR l_cvd_lvl_csr (p_cle_id NUMBER) IS
1720: SELECT cle.id id
1721: FROM okc_k_lines_v cle, okc_line_styles_v lse
1722: WHERE lse.id = cle.lse_id
1723: AND lse.LTY_CODE IN
1724: ('COVER_CUST', 'COVER_ITEM', 'COVER_PROD',
1725: 'COVER_PTY', 'COVER_SITE', 'COVER_SYS', 'INST_CTR')
2128: l_date_cancelled DATE;
2129:
2130: CURSOR l_cle1_csr IS
2131: SELECT cle.id
2132: FROM OKC_K_LINES_V cle
2133: WHERE cle.dnz_chr_id = p_chr_id
2134: AND cle.name IS NULL
2135: AND cle.date_cancelled IS NULL ; --Changes [llc]
2136:
2258:
2259: /*** Get all service lines for given Contract header id ***/
2260: CURSOR l_csr_get_service_line_id(p_chr_id NUMBER) IS
2261: SELECT cle.id, sts.ste_code sts_code
2262: FROM okc_k_lines_v cle,
2263: okc_statuses_b sts
2264: WHERE cle.dnz_chr_id = p_chr_id
2265: AND sts.code = cle.sts_code
2266: AND cle.lse_id IN (1, 19);
2282:
2283: /*** Get all product lines and item lines for each service line ***/
2284: CURSOR l_csr_get_product_line_id IS
2285: SELECT id, start_date
2286: FROM okc_k_lines_v
2287: WHERE cle_id = l_service_id
2288: AND lse_id IN (9, 25, 7); -- 7 added for bug#2430496
2289:
2290: