APPS.OKC_EXTEND_PVT dependencies on OKC_K_LINES_B

Line 114: l_no okc_k_lines_b.line_number%TYPE;

110: l_app_id okc_k_headers_b.application_id%TYPE;
111: l_scs_code okc_k_headers_b.scs_code%TYPE;
112: l_k VARCHAR2(255);
113: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
114: l_no okc_k_lines_b.line_number%TYPE;
115: l_end_date okc_k_lines_b.end_date%TYPE;
116:
117: CURSOR c_chr(p_chr_id number) IS
118: SELECT template_yn, application_id, scs_code ,contract_number,

Line 115: l_end_date okc_k_lines_b.end_date%TYPE;

111: l_scs_code okc_k_headers_b.scs_code%TYPE;
112: l_k VARCHAR2(255);
113: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
114: l_no okc_k_lines_b.line_number%TYPE;
115: l_end_date okc_k_lines_b.end_date%TYPE;
116:
117: CURSOR c_chr(p_chr_id number) IS
118: SELECT template_yn, application_id, scs_code ,contract_number,
119: contract_number_modifier

Line 125: FROM okc_k_lines_b

121: WHERE id = p_chr_id;
122:
123: CURSOR c_cle IS
124: SELECT sts_code,dnz_chr_id ,line_number,end_date
125: FROM okc_k_lines_b
126: WHERE id = p_cle_id;
127:
128: CURSOR c_sts(p_code IN VARCHAR2) IS
129: SELECT ste_code

Line 606: FROM okc_k_lines_b cle,

602:
603: -- bug#5757116 added trunc in the where clause of the cursor.
604: CURSOR cur_k_lines is
605: SELECT cle.id
606: FROM okc_k_lines_b cle,
607: okc_statuses_b sts
608: WHERE trunc(cle.end_date) = trunc(p_chr_rec.end_date)
609: AND cle.dnz_chr_id = p_chr_rec.id
610: AND Cle.chr_id is not null

Line 616: FROM okc_k_lines_b cle

612: AND sts.ste_code in ('ACTIVE','EXPIRED','ENTERED','SIGNED');
613:
614: CURSOR cur_k_sublines(p_id number) is
615: SELECT cle.id,cle.object_version_number,cle.sts_code,cle.end_date
616: FROM okc_k_lines_b cle
617: CONNECT BY PRIOR id=cle_id
618: start with id=p_id;
619:
620: CURSOR cur_status(p_sts_code varchar2) is

Line 1207: FROM okc_k_lines_b cle,

1203:
1204: -- bug # 5757116 Added trunc to the end date in the where clause of the cursor.
1205: CURSOR cur_k_lines(p_chr_id number,p_end_date date) is
1206: SELECT cle.id,cle.end_date,cle.start_date,cle.object_version_number
1207: FROM okc_k_lines_b cle,
1208: okc_statuses_b sts
1209: WHERE cle.dnz_chr_id = p_chr_id
1210: and trunc(cle.end_date) = trunc(p_end_date)
1211: and cle.sts_code = sts.code

Line 1516: FROM okc_k_lines_b

1512:
1513:
1514: CURSOR cur_lines is
1515: SELECT id,object_version_number,chr_id,date_terminated,end_date,sts_code, start_date
1516: FROM okc_k_lines_b
1517: WHERE date_terminated is null
1518: START WITH id = p_extend_in_parameters_rec.p_cle_id
1519: CONNECT BY PRIOR id = cle_id
1520: ORDER BY LEVEL asc

Line 1533: okc_k_lines_b cle

1529: SELECT k.contract_number,k.contract_number_modifier,k.scs_code,scs.cls_code,
1530: cle.price_negotiated,cle.sts_code
1531: FROM okc_k_headers_b k,
1532: okc_subclasses_b scs,
1533: okc_k_lines_b cle
1534: WHERE k.id = p_extend_in_parameters_rec.p_dnz_chr_id
1535: AND cle.chr_id = k.id
1536: AND cle.id = p_extend_in_parameters_rec.p_cle_id
1537: AND k.scs_code = scs.code;