eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMINATE_PVT dependencies on OKC_K_HEADERS_B

Line 19: l_app_id okc_k_headers_b.application_id%TYPE;

15: l_sts_code VARCHAR2(100);
16: l_cls_code VARCHAR2(100);
17: l_template_yn VARCHAR2(10);
18: l_code VARCHAR2(100);
19: l_app_id okc_k_headers_b.application_id%TYPE;
20: l_scs_code okc_k_headers_b.scs_code%TYPE;
21: l_k VARCHAR2(255);
22: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
23: l_date_term DATE;

Line 20: l_scs_code okc_k_headers_b.scs_code%TYPE;

16: l_cls_code VARCHAR2(100);
17: l_template_yn VARCHAR2(10);
18: l_code VARCHAR2(100);
19: l_app_id okc_k_headers_b.application_id%TYPE;
20: l_scs_code okc_k_headers_b.scs_code%TYPE;
21: l_k VARCHAR2(255);
22: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
23: l_date_term DATE;
24: l_allow Varchar2(1) := 'N';

Line 22: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;

18: l_code VARCHAR2(100);
19: l_app_id okc_k_headers_b.application_id%TYPE;
20: l_scs_code okc_k_headers_b.scs_code%TYPE;
21: l_k VARCHAR2(255);
22: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;
23: l_date_term DATE;
24: l_allow Varchar2(1) := 'N';
25:
26:

Line 30: FROM okc_k_headers_b

26:
27: CURSOR c_chr IS
28: SELECT sts_code, template_yn, application_id, scs_code ,contract_number,
29: contract_number_modifier, date_terminated
30: FROM okc_k_headers_b
31: WHERE id = p_chr_id;
32:
33: CURSOR c_sts(p_code IN VARCHAR2) IS
34: SELECT ste_code

Line 145: l_app_id okc_k_headers_b.application_id%TYPE;

141: l_template_yn VARCHAR2(10);
142: l_code VARCHAR2(100);
143: l_hdr_code VARCHAR2(100);
144: l_chr_id number:=OKC_API.G_MISS_NUM;
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;

Line 146: l_scs_code okc_k_headers_b.scs_code%TYPE;

142: l_code VARCHAR2(100);
143: l_hdr_code VARCHAR2(100);
144: l_chr_id number:=OKC_API.G_MISS_NUM;
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;

Line 148: l_mod okc_k_headers_b.contract_number_modifier%TYPE ;

144: l_chr_id number:=OKC_API.G_MISS_NUM;
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';

Line 156: FROM okc_k_headers_b

152: l_allow Varchar2(1) := 'N';
153:
154: CURSOR c_chr(p_chr_id number) IS
155: SELECT template_yn ,sts_code, application_id, scs_code ,contract_number, contract_number_modifier, date_terminated
156: FROM okc_k_headers_b
157: WHERE id = p_chr_id;
158:
159: CURSOR c_cle IS
160: SELECT sts_code,dnz_chr_id,line_number , date_terminated

Line 294: FROM okc_k_headers_b

290: DATE_TERMINATED,
291: DATE_RENEWED,
292: APPLICATION_ID,
293: SCS_CODE
294: FROM okc_k_headers_b
295: WHERE id = p_terminate_in_parameters_rec.p_contract_id;
296:
297:
298: -- Will not need object_version_number this termination is an adverse step. Even if there

Line 329: -- from okc_k_headers_b

325:
326: -- CURSOR cur_old_contract is
327: -- select contract_number,
328: -- contract_number_modifier
329: -- from okc_k_headers_b
330: -- where chr_id_renewed = p_terminate_in_parameters_rec.p_contract_id;
331:
332: Cursor cur_old_contract(p_chr_id number) is
333: select k.contract_number,k.contract_number_modifier

Line 334: from okc_k_headers_b k,okc_operation_lines a,

330: -- where chr_id_renewed = p_terminate_in_parameters_rec.p_contract_id;
331:
332: Cursor cur_old_contract(p_chr_id number) is
333: select k.contract_number,k.contract_number_modifier
334: from okc_k_headers_b k,okc_operation_lines a,
335: okc_operation_instances b,okc_class_operations c
336: where k.id=a.subject_chr_id
337: and a.object_chr_id=p_chr_id and
338: c.id=b.cop_id and c.opn_code='RENEWAL'

Line 584: okc_k_headers_b k,

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,
586: okc_operations_b opn,
587: okc_val_line_operations lopn
588: WHERE cle.chr_id = p_terminate_in_parameters_rec.p_contract_id

Line 621: FROM OKC_K_HEADERS_B K,

617: FOR update of datetime_ineffective nowait;
618:
619: CURSOR cur_header_aa IS
620: SELECT k.estimated_amount,k.scs_code,scs.cls_code,k.sts_code
621: FROM OKC_K_HEADERS_B K,
622: OKC_SUBCLASSES_B SCS
623: WHERE k.id = p_terminate_in_parameters_rec.p_contract_id
624: AND k.scs_code = scs.code;
625:

Line 1139: FROM okc_k_headers_b k

1135: CURSOR k_csr is
1136: SELECT k.template_Yn, k.date_renewed, k.contract_number,
1137: k.contract_number_modifier, k.sts_code, k.application_id,
1138: k.scs_code
1139: FROM okc_k_headers_b k
1140: WHERE k.id = p_terminate_in_parameters_rec.p_dnz_chr_id;
1141:
1142: l_chrv_rec k_csr%rowtype;
1143:

Line 1176: --FROM okc_k_headers_b

1172: l_dummy varchar2(1);
1173:
1174: --CURSOR cur_old_contract is
1175: --SELECT contract_number,contract_number_modifier
1176: --FROM okc_k_headers_b
1177: --WHERE chr_id_renewed = p_terminate_in_parameters_rec.p_dnz_chr_id;
1178:
1179: Cursor cur_old_contract(p_chr_id number) is
1180: select k.contract_number,k.contract_number_modifier

Line 1181: from okc_k_headers_b k,okc_operation_lines a,

1177: --WHERE chr_id_renewed = p_terminate_in_parameters_rec.p_dnz_chr_id;
1178:
1179: Cursor cur_old_contract(p_chr_id number) is
1180: select k.contract_number,k.contract_number_modifier
1181: from okc_k_headers_b k,okc_operation_lines a,
1182: okc_operation_instances b,okc_class_operations c
1183: where k.id=a.subject_chr_id
1184: and a.object_chr_id=p_chr_id and
1185: c.id=b.cop_id and c.opn_code='RENEWAL'

Line 1392: FROM okc_k_headers_b k,

1388:
1389: CURSOR cur_header is
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