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 576: --Replaced table okc_k_headers_b with headers_All_b table

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

Line 577: /* FROM okc_k_headers_b */

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

Line 590: --Replaced table okc_k_headers_b with headers_All_b table

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

Line 591: /* FROM okc_k_headers_b */

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

Line 797: --Replaced table okc_k_headers_b with headers_All_b table

793:
794: Cursor l_chrv_csr Is
795: SELECT currency_code
796: --npalepu 26-10-2005 modified for bug # 4691662.
797: --Replaced table okc_k_headers_b with headers_All_b table
798: /* FROM okc_k_headers_b */
799: FROM okc_k_headers_all_b
800: --end npalepu
801: WHERE ID = p_chrv_rec.id;

Line 798: /* FROM okc_k_headers_b */

794: Cursor l_chrv_csr Is
795: SELECT currency_code
796: --npalepu 26-10-2005 modified for bug # 4691662.
797: --Replaced table okc_k_headers_b with headers_All_b table
798: /* FROM okc_k_headers_b */
799: FROM okc_k_headers_all_b
800: --end npalepu
801: WHERE ID = p_chrv_rec.id;
802:

Line 811: --Replaced table okc_k_headers_b with headers_All_b table

807:
808: Cursor l_status_csr Is
809: SELECT sts_code
810: --npalepu 26-10-2005 modified for bug # 4691662.
811: --Replaced table okc_k_headers_b with headers_All_b table
812: /* FROM okc_k_headers_b */
813: FROM okc_k_headers_all_b
814: --end npalepu
815: WHERE ID = p_chrv_rec.id;

Line 812: /* FROM okc_k_headers_b */

808: Cursor l_status_csr Is
809: SELECT sts_code
810: --npalepu 26-10-2005 modified for bug # 4691662.
811: --Replaced table okc_k_headers_b with headers_All_b table
812: /* FROM okc_k_headers_b */
813: FROM okc_k_headers_all_b
814: --end npalepu
815: WHERE ID = p_chrv_rec.id;
816:

Line 1008: SELECT ste_code from okc_statuses_b status, okc_k_headers_b header

1004: SELECT id, object_version_number, dnz_chr_id
1005: FROM okc_k_sales_credits
1006: WHERE chr_id = p_chrv_rec.id;
1007: Cursor cur_status Is
1008: SELECT ste_code from okc_statuses_b status, okc_k_headers_b header
1009: where status.code = header.sts_code
1010: AND header.id = p_chrv_rec.id;
1011:
1012:

Line 1019: l_chr_status OKC_K_HEADERS_B.STS_CODE%TYPE;

1015: l_oiev_tbl OKC_OPER_INST_PUB.oiev_tbl_type;
1016: i NUMBER := 0;
1017:
1018: l_scrv_rec OKC_SALES_credit_PUB.scrv_rec_type;
1019: l_chr_status OKC_K_HEADERS_B.STS_CODE%TYPE;
1020:
1021:
1022: BEGIN
1023: -- check whether delete is allowed or not

Line 1133: l_entity_name => 'OKC_K_HEADERS_B',

1129:
1130: -- Delete any attachments assiciated
1131: If (x_return_status = OKC_API.G_RET_STS_SUCCESS) Then
1132: If (fnd_attachment_util_pkg.get_atchmt_exists (
1133: l_entity_name => 'OKC_K_HEADERS_B',
1134: l_pkey1 => p_chrv_rec.id,
1135: l_pkey2 => l_major_version) = 'Y')
1136:
1137: -- The following line to be added to the code once

Line 1144: x_entity_name => 'OKC_K_HEADERS_B',

1140: -- also below remove the comments
1141: -- in fnd_attached_documents2_pkg.delete_attachments call
1142: Then
1143: fnd_attached_documents2_pkg.delete_attachments(
1144: x_entity_name => 'OKC_K_HEADERS_B',
1145: x_pk1_value => p_chrv_rec.id,
1146: x_pk2_value => l_major_version
1147: );
1148: End If;

Line 1546: --Replaced table okc_k_headers_b with headers_All_b table

1542: l_modifier VARCHAR2(120);
1543: Cursor l_chr_csr(p_id NUMBER) Is
1544: SELECT contract_number,contract_number_modifier
1545: --npalepu 26-10-2005 modified for bug # 4691662.
1546: --Replaced table okc_k_headers_b with headers_All_b table
1547: /* FROM okc_k_headers_b */
1548: FROM okc_k_headers_all_b
1549: --end npalepu
1550: where id = p_id;

Line 1547: /* FROM okc_k_headers_b */

1543: Cursor l_chr_csr(p_id NUMBER) Is
1544: SELECT contract_number,contract_number_modifier
1545: --npalepu 26-10-2005 modified for bug # 4691662.
1546: --Replaced table okc_k_headers_b with headers_All_b table
1547: /* FROM okc_k_headers_b */
1548: FROM okc_k_headers_all_b
1549: --end npalepu
1550: where id = p_id;
1551: BEGIN

Line 4135: FROM OKC_K_HEADERS_B

4131: l_chr_id NUMBER;
4132: l_process_active_yn VARCHAR2(1);
4133: Cursor l_chrv_csr Is
4134: SELECT id
4135: FROM OKC_K_HEADERS_B
4136: WHERE contract_number = p_contract_number
4137: AND contract_number_modifier = p_contract_number_modifier;
4138:
4139: Cursor l_chrv_csr2 Is

Line 4141: FROM OKC_K_HEADERS_B

4137: AND contract_number_modifier = p_contract_number_modifier;
4138:
4139: Cursor l_chrv_csr2 Is
4140: SELECT id
4141: FROM OKC_K_HEADERS_B
4142: WHERE contract_number = p_contract_number
4143: AND contract_number_modifier is null;
4144:
4145: Cursor l_pdfv_csr Is

Line 4242: --Replaced table okc_k_headers_b with headers_All_b table

4238:
4239: Cursor l_chrv_csr Is
4240: SELECT sts_code, scs_code
4241: --npalepu 26-10-2005 modified for bug # 4691662.
4242: --Replaced table okc_k_headers_b with headers_All_b table
4243: /* FROM OKC_K_HEADERS_B */
4244: FROM OKC_K_HEADERS_ALL_B
4245: --end npalepu
4246: WHERE id = p_chr_id;

Line 4243: /* FROM OKC_K_HEADERS_B */

4239: Cursor l_chrv_csr Is
4240: SELECT sts_code, scs_code
4241: --npalepu 26-10-2005 modified for bug # 4691662.
4242: --Replaced table okc_k_headers_b with headers_All_b table
4243: /* FROM OKC_K_HEADERS_B */
4244: FROM OKC_K_HEADERS_ALL_B
4245: --end npalepu
4246: WHERE id = p_chr_id;
4247:

Line 4373: UPDATE OKC_K_HEADERS_B

4369: -- Clean date_renewed in header (for CLEAN)
4370: --
4371: If (l_active_yn = 'N') Then
4372: -- Clear all source contract's date_renewed column
4373: UPDATE OKC_K_HEADERS_B
4374: SET date_renewed = null,
4375: object_version_number = object_version_number + 1,
4376: last_updated_by = FND_GLOBAL.USER_ID,
4377: last_update_date = sysdate,

Line 4399: UPDATE OKC_K_HEADERS_B

4395: fetch cle_csr into l_no_of_lines;
4396: close cle_csr;
4397:
4398: If ( l_no_of_op_lines = l_no_of_lines ) Then
4399: UPDATE OKC_K_HEADERS_B
4400: SET date_renewed = sysdate,
4401: object_version_number = object_version_number + 1,
4402: last_updated_by = FND_GLOBAL.USER_ID,
4403: last_update_date = sysdate,

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

4569: start with id = p_cle_id;
4570:
4571: CURSOR l_k_code_csr IS
4572: SELECT cls_code from
4573: OKC_SUBCLASSES_B WHERE code=(SELECT scs_code from OKC_K_HEADERS_B where id in
4574: (select dnz_chr_id from okc_k_lines_b where id =p_cle_id));
4575:
4576: CURSOR l_chk_cle_csr IS
4577: SELECT clev.cle_id,RTRIM(clev.line_number) line_number,clev.lse_id

Line 5088: Update okc_k_headers_b

5084: Open get_hdr_amts_csr;
5085: Fetch get_hdr_amts_csr Into l_hdr_estimated_amt, l_hdr_cancelled_amt;
5086: Close get_hdr_amts_csr;
5087:
5088: Update okc_k_headers_b
5089: set estimated_amount = l_hdr_estimated_amt,
5090: cancelled_amount = l_hdr_cancelled_amt
5091: where id = p_id;
5092:

Line 5151: FROM okc_k_headers_b

5147: l_hdr_cancelled_amt number := 0;
5148:
5149: Cursor get_hdr_cancelled_amt IS
5150: SELECT cancelled_amount
5151: FROM okc_k_headers_b
5152: WHERE id = p_id;
5153:
5154:
5155: BEGIN