APPS.OKC_TERMINATE_PVT dependencies on OKC_K_LINES_B

Line 149: l_no okc_k_lines_b.line_number%TYPE;

145: l_app_id okc_k_headers_b.application_id%TYPE;
146: l_scs_code okc_k_headers_b.scs_code%TYPE;
147: l_k VARCHAR2(255);
148: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
149: l_no okc_k_lines_b.line_number%TYPE;
150: l_date_term_chr DATE;
151: l_date_term_cle DATE;
152: l_allow Varchar2(1) := 'N';
153:

Line 161: FROM okc_k_lines_b

157: WHERE id = p_chr_id;
158:
159: CURSOR c_cle IS
160: SELECT sts_code,dnz_chr_id,line_number , date_terminated
161: FROM okc_k_lines_b
162: WHERE id = p_cle_id;
163:
164: CURSOR c_sts(p_code IN VARCHAR2) IS
165: SELECT ste_code

Line 320: okc_k_lines_b cle

316: /*
317: CURSOR cur_service_requests is
318: SELECT 'x'
319: FROM okx_incident_statuses_v xis,
320: okc_k_lines_b cle
321: WHERE cle.id = xis.contract_service_id
322: and cle.dnz_chr_id = p_terminate_in_parameters_rec.p_contract_id
323: and xis.status_code in ('OPEN'); -- Impact -- DepENDency on status of service requests
324: */

Line 581: FROM okc_k_lines_b cle,

577: SELECT cle.id,
578: cle.object_version_number,
579: cle.start_date,
580: cle.end_date
581: FROM okc_k_lines_b cle,
582: okc_line_styles_b lse,
583: okc_statuses_b sts,
584: okc_k_headers_b k,
585: okc_assents a,

Line 1120: FROM okc_k_lines_b

1116: ) is
1117:
1118: CURSOR is_line_a_top_line is
1119: SELECT 'x'
1120: FROM okc_k_lines_b
1121: WHERE id = p_terminate_in_parameters_rec.p_cle_id
1122: and chr_id is not null;
1123:
1124: -- Bug 1925467 Commented

Line 1129: FROM okc_k_lines_b cle,

1125: -- Bug 1932363: Added another linestyle in the where for 'Usage'
1126: /*
1127: CURSOR is_line_a_service_line is
1128: SELECT 'x'
1129: FROM okc_k_lines_b cle,
1130: okc_line_styles_b lse
1131: WHERE cle.id = p_terminate_in_parameters_rec.p_cle_id
1132: and cle.lse_id = lse.id
1133: and lse.lty_code in ('SERVICE','EXT_WARRANTY','USAGE');

Line 1158: okc_k_lines_b cle

1154: WHERE sts.code = p_code;
1155: CURSOR cur_service_requests is
1156: SELECT 'x'
1157: FROM okx_incident_statuses_v xis,
1158: okc_k_lines_b cle
1159: WHERE cle.id = xis.contract_service_id
1160: --san below cle.id condition added as we just want to check SRs againt this line only.
1161: and cle.id=p_terminate_in_parameters_rec.p_cle_id --bug 1325866
1162: and xis.status_code in ('OPEN'); -- Impact -- DepENDency on status of service requests

Line 1394: okc_k_lines_b cle

1390: SELECT k.contract_number,k.contract_number_modifier,k.scs_code,scs.cls_code,
1391: cle.price_negotiated,cle.sts_code
1392: FROM okc_k_headers_b k,
1393: okc_subclasses_b scs,
1394: okc_k_lines_b cle
1395: WHERE k.id = p_terminate_in_parameters_rec.p_dnz_chr_id
1396: AND cle.chr_id = k.id
1397: AND cle.id = p_terminate_in_parameters_rec.p_cle_id
1398: AND k.scs_code = scs.code;

Line 1410: FROM okc_k_lines_b

1406: l_price_negotiated number;
1407:
1408: CURSOR cur_lines is
1409: SELECT id,object_version_number,sts_code,lse_id,start_date,end_date
1410: FROM okc_k_lines_b
1411: WHERE date_terminated is null
1412: START WITH id = p_terminate_in_parameters_rec.p_cle_id
1413: CONNECT BY PRIOR id = cle_id
1414: ORDER BY LEVEL DESC

Line 1422: FROM okc_k_lines_b cle,

1418: -- Bug 1932363: Added another linestyle in the where for 'Usage'
1419: /*
1420: CURSOR is_line_a_service_line is
1421: SELECT 'x'
1422: FROM okc_k_lines_b cle,
1423: okc_line_styles_b lse
1424: WHERE cle.id = p_terminate_in_parameters_rec.p_cle_id
1425: and cle.lse_id = lse.id
1426: and lse.lty_code in ('SERVICE','EXT_WARRANTY','USAGE');