19: l_sts_code VARCHAR2(100);
20: l_cls_code VARCHAR2(100);
21: l_template_yn VARCHAR2(10);
22: l_code VARCHAR2(100);
23: l_end_date okc_k_headers_b.end_date%TYPE;
24: l_app_id okc_k_headers_b.application_id%TYPE;
25: l_scs_code okc_k_headers_b.scs_code%TYPE;
26: l_k VARCHAR2(255);
27: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
20: l_cls_code VARCHAR2(100);
21: l_template_yn VARCHAR2(10);
22: l_code VARCHAR2(100);
23: l_end_date okc_k_headers_b.end_date%TYPE;
24: l_app_id okc_k_headers_b.application_id%TYPE;
25: l_scs_code okc_k_headers_b.scs_code%TYPE;
26: l_k VARCHAR2(255);
27: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
28:
21: l_template_yn VARCHAR2(10);
22: l_code VARCHAR2(100);
23: l_end_date okc_k_headers_b.end_date%TYPE;
24: l_app_id okc_k_headers_b.application_id%TYPE;
25: l_scs_code okc_k_headers_b.scs_code%TYPE;
26: l_k VARCHAR2(255);
27: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
28:
29:
23: l_end_date okc_k_headers_b.end_date%TYPE;
24: l_app_id okc_k_headers_b.application_id%TYPE;
25: l_scs_code okc_k_headers_b.scs_code%TYPE;
26: l_k VARCHAR2(255);
27: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
28:
29:
30: CURSOR c_chr IS
31: SELECT sts_code,template_yn,end_date,application_id,scs_code ,contract_number,
29:
30: CURSOR c_chr IS
31: SELECT sts_code,template_yn,end_date,application_id,scs_code ,contract_number,
32: contract_number_modifier
33: FROM okc_k_headers_b
34: WHERE id = p_chr_id;
35:
36: CURSOR c_sts(p_code IN VARCHAR2) IS
37: SELECT ste_code
106: l_cls_code VARCHAR2(100);
107: l_template_yn VARCHAR2(10);
108: l_code VARCHAR2(100);
109: l_chr_id number:=OKC_API.G_MISS_NUM;
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;
107: l_template_yn VARCHAR2(10);
108: l_code VARCHAR2(100);
109: l_chr_id number:=OKC_API.G_MISS_NUM;
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;
109: l_chr_id number:=OKC_API.G_MISS_NUM;
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
116:
117: CURSOR c_chr(p_chr_id number) IS
118: SELECT template_yn, application_id, scs_code ,contract_number,
119: contract_number_modifier
120: FROM okc_k_headers_b
121: WHERE id = p_chr_id;
122:
123: CURSOR c_cle IS
124: SELECT sts_code,dnz_chr_id ,line_number,end_date
237: TEMPLATE_YN,
238: DATE_TERMINATED,
239: DATE_RENEWED,
240: END_DATE
241: FROM okc_k_headers_b
242: WHERE id = p_extend_in_parameters_rec.p_contract_id;
243:
244: CURSOR is_k_locked is
245: SELECT 'Y'
424: FROM okc_statuses_v
425: WHERE code = p_sts_code;
426:
427: Cursor cur_k_end_date(p_id number) is
428: SELECT end_date+1 from okc_k_headers_b
429: WHERE id=p_id;
430:
431: k_lines_rec cur_k_lines%rowtype;
432:
1188: FOR update of object1_id1 nowait;
1189:
1190: CURSOR cur_header_aa IS
1191: SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code
1192: FROM OKC_K_HEADERS_B K,
1193: OKC_SUBCLASSES_B SCS
1194: WHERE k.id = p_extend_in_parameters_rec.p_contract_id
1195: AND k.scs_code = scs.code;
1196:
1527:
1528: CURSOR cur_header is
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