[Home] [Help]
501: FROM okc_k_headers_all_b WHERE id = p_chr_id;
502:
503: CURSOR get_status(l_sts_code VARCHAR) IS
504: SELECT ste_code
505: FROM okc_statuses_b
506: WHERE ste_code = 'ENTERED' AND code = l_sts_code;
507:
508: /*cursor get_price_list(l_price_list_id number) is
509: SELECT CURRENCY_CODE
520: **/
521: --bug 5442886
522: SELECT line_number, price_list_id
523: FROM okc_k_lines_b,
524: okc_statuses_b
525: WHERE chr_id = p_chr_id
526: AND lse_id IN (1,12,46,19)
527: AND ste_code = 'ENTERED'
528: AND code = sts_code
1060: FROM okc_k_headers_all_b chdr,
1061: OKC_K_ITEMS cim,
1062: OKC_LINE_STYLES_V lse,
1063: OKC_K_LINES_B cle,
1064: OKC_STATUSES_B sts
1065: WHERE chdr.id = cle.dnz_chr_id
1066: AND object1_id1 = p_object1_id1
1067: AND object1_id2 = p_object1_id2
1068: AND jtot_object1_code = p_jtot_object1_code
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
1266: WHERE srcsl.dnz_chr_id = cp_chr_id
1267: AND srcsl.lse_id IN (7, 8, 9, 10, 11, 35, 13, 18, 25)
1268: AND nvl(srcsl.date_terminated, cp_date + 1) > cp_date
1269: AND srci.cle_id = srcsl.id
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);
2198:
4204: cle.start_date, cle.end_date, cle.date_terminated,
4205: cim.jtot_object1_code, cim.object1_id1, cim.object1_id2
4206: FROM okc_k_items cim,
4207: okc_k_lines_b cle,
4208: okc_statuses_b sts
4209: WHERE cle.dnz_chr_id = p_chr_id
4210: AND cle.cle_id IS NULL
4211: AND sts.code = cle.sts_code
4212: AND cim.cle_id = cle.id
4249: cim.jtot_object1_code, cim.object1_id1,
4250: cim.object1_id2
4251: FROM OKC_K_ITEMS cim,
4252: OKC_K_LINES_B cle,
4253: OKC_STATUSES_B sts
4254: WHERE cim.cle_id = cle.id
4255: AND cle.cle_id = p_cle_id
4256: AND sts.code = cle.sts_code
4257: AND cle.lse_id IN (35, 7, 8, 9, 10, 11, 13, 18, 25);
4311: --Changed cursor because ste_code does not have QA_HOLD
4312: CURSOR l_hdr_csr(l_chr_id NUMBER) IS
4313: SELECT sts_code --sts.ste_code sts_code
4314: FROM okc_k_headers_all_b
4315: -- ,okc_statuses_b sts
4316: WHERE id = l_chr_id;
4317: --And sts.code = chr.sts_code;
4318:
4319:
6158: /*** Get all service lines for given Contract header id ***/
6159: CURSOR l_csr_get_service_line_id(p_chr_id NUMBER) IS
6160: SELECT cle.id, sts.ste_code sts_code
6161: FROM okc_k_lines_b cle,
6162: okc_statuses_b sts
6163: WHERE cle.dnz_chr_id = p_chr_id
6164: AND sts.code = cle.sts_code
6165: AND cle.lse_id IN (1, 19)
6166: AND cle.date_cancelled IS NULL --Changes [llc]
7697: l_dummy_msg VARCHAR2(200);
7698:
7699: CURSOR cur_renewal_source_lines (p_chr_id NUMBER) IS
7700: SELECT 1
7701: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7702: WHERE a.subject_chr_id = p_chr_id
7703: AND c.id = b.cop_id
7704: AND c.opn_code IN('RENEWAL', 'REN_CON')
7705: AND a.oie_id = b.id
7781:
7782:
7783: CURSOR cur_is_K_renewed IS
7784: SELECT d.id target_contract_id
7785: FROM okc_operation_lines a, okc_operation_instances b, okc_class_operations c, okc_k_headers_all_b d, okc_statuses_b e
7786: WHERE a.object_chr_id = p_chr_id
7787: AND c.id = b.cop_id
7788: AND c.opn_code IN('RENEWAL', 'REN_CON')
7789: AND a.oie_id = b.id
7793: AND e.ste_code NOT IN ('ACTIVE', 'SIGNED', 'HOLD', 'EXPIRED');
7794:
7795: CURSOR cur_lines_status IS
7796: SELECT b.id, b.line_number, s.ste_code
7797: FROM okc_k_lines_b b, okc_statuses_b s
7798: WHERE dnz_chr_id = p_chr_id
7799: AND cle_id IS NULL
7800: AND s.code = b.sts_code;
7801:
7801:
7802:
7803: CURSOR cur_sublines_status(p_cle_id NUMBER) IS
7804: SELECT b.id, b.line_number, s.ste_code
7805: FROM okc_k_lines_b b, okc_statuses_b s
7806: WHERE cle_id = p_cle_id
7807: AND s.code = b.sts_code
7808: AND s.ste_code = 'CANCELLED';
7809: