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_CONTRACT_PVT dependencies on OKC_K_HEADERS_B

Line 49: from okc_k_headers_b

45: x_rule_meaning out NOCOPY varchar2) IS
46:
47: cursor cur_k_appl_id is
48: Select application_id
49: from okc_k_headers_b
50: where id = p_id;
51:
52: k_appl_id number;
53:

Line 574: --Replaced table okc_k_headers_b with headers_All_b table

570:
571: Cursor l_chrv_csr Is
572: SELECT currency_code
573: --npalepu 26-10-2005 modified for bug # 4691662.
574: --Replaced table okc_k_headers_b with headers_All_b table
575: /* FROM okc_k_headers_b */
576: FROM okc_k_headers_all_b
577: --end npalepu
578: WHERE ID = p_chrv_rec.id;

Line 575: /* FROM okc_k_headers_b */

571: Cursor l_chrv_csr Is
572: SELECT currency_code
573: --npalepu 26-10-2005 modified for bug # 4691662.
574: --Replaced table okc_k_headers_b with headers_All_b table
575: /* FROM okc_k_headers_b */
576: FROM okc_k_headers_all_b
577: --end npalepu
578: WHERE ID = p_chrv_rec.id;
579:

Line 588: --Replaced table okc_k_headers_b with headers_All_b table

584:
585: Cursor l_status_csr Is
586: SELECT sts_code
587: --npalepu 26-10-2005 modified for bug # 4691662.
588: --Replaced table okc_k_headers_b with headers_All_b table
589: /* FROM okc_k_headers_b */
590: FROM okc_k_headers_all_b
591: --end npalepu
592: WHERE ID = p_chrv_rec.id;

Line 589: /* FROM okc_k_headers_b */

585: Cursor l_status_csr Is
586: SELECT sts_code
587: --npalepu 26-10-2005 modified for bug # 4691662.
588: --Replaced table okc_k_headers_b with headers_All_b table
589: /* FROM okc_k_headers_b */
590: FROM okc_k_headers_all_b
591: --end npalepu
592: WHERE ID = p_chrv_rec.id;
593:

Line 766: --Replaced table okc_k_headers_b with headers_All_b table

762:
763: Cursor l_chrv_csr Is
764: SELECT currency_code
765: --npalepu 26-10-2005 modified for bug # 4691662.
766: --Replaced table okc_k_headers_b with headers_All_b table
767: /* FROM okc_k_headers_b */
768: FROM okc_k_headers_all_b
769: --end npalepu
770: WHERE ID = p_chrv_rec.id;

Line 767: /* FROM okc_k_headers_b */

763: Cursor l_chrv_csr Is
764: SELECT currency_code
765: --npalepu 26-10-2005 modified for bug # 4691662.
766: --Replaced table okc_k_headers_b with headers_All_b table
767: /* FROM okc_k_headers_b */
768: FROM okc_k_headers_all_b
769: --end npalepu
770: WHERE ID = p_chrv_rec.id;
771:

Line 780: --Replaced table okc_k_headers_b with headers_All_b table

776:
777: Cursor l_status_csr Is
778: SELECT sts_code
779: --npalepu 26-10-2005 modified for bug # 4691662.
780: --Replaced table okc_k_headers_b with headers_All_b table
781: /* FROM okc_k_headers_b */
782: FROM okc_k_headers_all_b
783: --end npalepu
784: WHERE ID = p_chrv_rec.id;

Line 781: /* FROM okc_k_headers_b */

777: Cursor l_status_csr Is
778: SELECT sts_code
779: --npalepu 26-10-2005 modified for bug # 4691662.
780: --Replaced table okc_k_headers_b with headers_All_b table
781: /* FROM okc_k_headers_b */
782: FROM okc_k_headers_all_b
783: --end npalepu
784: WHERE ID = p_chrv_rec.id;
785:

Line 950: SELECT ste_code from okc_statuses_b status, okc_k_headers_b header

946: SELECT id, object_version_number, dnz_chr_id
947: FROM okc_k_sales_credits
948: WHERE chr_id = p_chrv_rec.id;
949: Cursor cur_status Is
950: SELECT ste_code from okc_statuses_b status, okc_k_headers_b header
951: where status.code = header.sts_code
952: AND header.id = p_chrv_rec.id;
953:
954:

Line 961: l_chr_status OKC_K_HEADERS_B.STS_CODE%TYPE;

957: l_oiev_tbl OKC_OPER_INST_PUB.oiev_tbl_type;
958: i NUMBER := 0;
959:
960: l_scrv_rec OKC_SALES_credit_PUB.scrv_rec_type;
961: l_chr_status OKC_K_HEADERS_B.STS_CODE%TYPE;
962:
963:
964: BEGIN
965: -- check whether delete is allowed or not

Line 1075: l_entity_name => 'OKC_K_HEADERS_B',

1071:
1072: -- Delete any attachments assiciated
1073: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1074: If (fnd_attachment_util_pkg.get_atchmt_exists (
1075: l_entity_name => 'OKC_K_HEADERS_B',
1076: l_pkey1 => p_chrv_rec.id,
1077: l_pkey2 => l_major_version) = 'Y')
1078:
1079: -- The following line to be added to the code once

Line 1086: x_entity_name => 'OKC_K_HEADERS_B',

1082: -- also below remove the comments
1083: -- in fnd_attached_documents2_pkg.delete_attachments call
1084: Then
1085: fnd_attached_documents2_pkg.delete_attachments(
1086: x_entity_name => 'OKC_K_HEADERS_B',
1087: x_pk1_value => p_chrv_rec.id,
1088: x_pk2_value => l_major_version
1089: );
1090: End If;

Line 1488: --Replaced table okc_k_headers_b with headers_All_b table

1484: l_modifier VARCHAR2(120);
1485: Cursor l_chr_csr(p_id NUMBER) Is
1486: SELECT contract_number,contract_number_modifier
1487: --npalepu 26-10-2005 modified for bug # 4691662.
1488: --Replaced table okc_k_headers_b with headers_All_b table
1489: /* FROM okc_k_headers_b */
1490: FROM okc_k_headers_all_b
1491: --end npalepu
1492: where id = p_id;

Line 1489: /* FROM okc_k_headers_b */

1485: Cursor l_chr_csr(p_id NUMBER) Is
1486: SELECT contract_number,contract_number_modifier
1487: --npalepu 26-10-2005 modified for bug # 4691662.
1488: --Replaced table okc_k_headers_b with headers_All_b table
1489: /* FROM okc_k_headers_b */
1490: FROM okc_k_headers_all_b
1491: --end npalepu
1492: where id = p_id;
1493: BEGIN

Line 4077: FROM OKC_K_HEADERS_B

4073: l_chr_id NUMBER;
4074: l_process_active_yn VARCHAR2(1);
4075: Cursor l_chrv_csr Is
4076: SELECT id
4077: FROM OKC_K_HEADERS_B
4078: WHERE contract_number = p_contract_number
4079: AND contract_number_modifier = p_contract_number_modifier;
4080:
4081: Cursor l_chrv_csr2 Is

Line 4083: FROM OKC_K_HEADERS_B

4079: AND contract_number_modifier = p_contract_number_modifier;
4080:
4081: Cursor l_chrv_csr2 Is
4082: SELECT id
4083: FROM OKC_K_HEADERS_B
4084: WHERE contract_number = p_contract_number
4085: AND contract_number_modifier is null;
4086:
4087: Cursor l_pdfv_csr Is

Line 4184: --Replaced table okc_k_headers_b with headers_All_b table

4180:
4181: Cursor l_chrv_csr Is
4182: SELECT sts_code, scs_code
4183: --npalepu 26-10-2005 modified for bug # 4691662.
4184: --Replaced table okc_k_headers_b with headers_All_b table
4185: /* FROM OKC_K_HEADERS_B */
4186: FROM OKC_K_HEADERS_ALL_B
4187: --end npalepu
4188: WHERE id = p_chr_id;

Line 4185: /* FROM OKC_K_HEADERS_B */

4181: Cursor l_chrv_csr Is
4182: SELECT sts_code, scs_code
4183: --npalepu 26-10-2005 modified for bug # 4691662.
4184: --Replaced table okc_k_headers_b with headers_All_b table
4185: /* FROM OKC_K_HEADERS_B */
4186: FROM OKC_K_HEADERS_ALL_B
4187: --end npalepu
4188: WHERE id = p_chr_id;
4189:

Line 4315: UPDATE OKC_K_HEADERS_B

4311: -- Clean date_renewed in header (for CLEAN)
4312: --
4313: If (l_active_yn = 'N') Then
4314: -- Clear all source contract's date_renewed column
4315: UPDATE OKC_K_HEADERS_B
4316: SET date_renewed = null,
4317: object_version_number = object_version_number + 1,
4318: last_updated_by = FND_GLOBAL.USER_ID,
4319: last_update_date = sysdate,

Line 4341: UPDATE OKC_K_HEADERS_B

4337: fetch cle_csr into l_no_of_lines;
4338: close cle_csr;
4339:
4340: If ( l_no_of_op_lines = l_no_of_lines ) Then
4341: UPDATE OKC_K_HEADERS_B
4342: SET date_renewed = sysdate,
4343: object_version_number = object_version_number + 1,
4344: last_updated_by = FND_GLOBAL.USER_ID,
4345: last_update_date = sysdate,

Line 4515: OKC_SUBCLASSES_B WHERE code=(SELECT scs_code from OKC_K_HEADERS_B where id in

4511: start with id = p_cle_id;
4512:
4513: CURSOR l_k_code_csr IS
4514: SELECT cls_code from
4515: OKC_SUBCLASSES_B WHERE code=(SELECT scs_code from OKC_K_HEADERS_B where id in
4516: (select dnz_chr_id from okc_k_lines_b where id =p_cle_id));
4517:
4518: CURSOR l_chk_cle_csr IS
4519: SELECT clev.cle_id,RTRIM(clev.line_number) line_number,clev.lse_id

Line 4926: Update okc_k_headers_b

4922: Open get_hdr_amts_csr;
4923: Fetch get_hdr_amts_csr Into l_hdr_estimated_amt, l_hdr_cancelled_amt;
4924: Close get_hdr_amts_csr;
4925:
4926: Update okc_k_headers_b
4927: set estimated_amount = l_hdr_estimated_amt,
4928: cancelled_amount = l_hdr_cancelled_amt
4929: where id = p_id;
4930:

Line 4989: FROM okc_k_headers_b

4985: l_hdr_cancelled_amt number := 0;
4986:
4987: Cursor get_hdr_cancelled_amt IS
4988: SELECT cancelled_amount
4989: FROM okc_k_headers_b
4990: WHERE id = p_id;
4991:
4992:
4993: BEGIN