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

Line 475: FROM okc_k_headers_b

471: l_template_yn VARCHAR2(3);
472:
473: CURSOR c_template IS
474: SELECT template_yn
475: FROM okc_k_headers_b
476: WHERE id = p_chr_id;
477:
478: CURSOR invalid_template IS
479: SELECT '1'

Line 480: FROM okc_k_headers_b

476: WHERE id = p_chr_id;
477:
478: CURSOR invalid_template IS
479: SELECT '1'
480: FROM okc_k_headers_b
481: WHERE template_yn = 'Y'
482: AND nvl(end_date, sysdate+1) >= trunc(sysdate)
483: AND id = p_chr_id;
484:

Line 489: FROM okc_k_headers_b

485: /*hkamdar 12-12-2005 Commented as this check is not required for source contract.
486: -- Bug #4693415 28-Nov-2005 hkamdar
487: CURSOR term_cntr IS
488: SELECT '1'
489: FROM okc_k_headers_b
490: WHERE id = p_chr_id
491: AND date_terminated IS NOT NULL
492: AND date_terminated <= SYSDATE;
493:

Line 496: FROM okc_k_headers_b hdr, okc_statuses_b status

492: AND date_terminated <= SYSDATE;
493:
494: CURSOR cancel_cntr IS
495: SELECT '1'
496: FROM okc_k_headers_b hdr, okc_statuses_b status
497: WHERE hdr.id = p_chr_id
498: AND hdr.sts_code = status.code
499: AND status.ste_code = 'CANCELLED';
500: */

Line 555: FROM okc_k_headers_b

551: l_code VARCHAR2(100);
552:
553: CURSOR c_chr IS
554: SELECT sts_code,template_yn,scs_code
555: FROM okc_k_headers_b
556: WHERE id = p_chr_id;
557:
558: CURSOR c_sts(p_code IN VARCHAR2) IS
559: SELECT ste_code

Line 2853: OKC_K_HEADERS_B chrv

2849: SELECT 'x'
2850: FROM FND_LOOKUP_VALUES rgdv,
2851: okc_rule_groups_b rgp,
2852: OKC_SUBCLASS_RG_DEFS srdv,
2853: OKC_K_HEADERS_B chrv
2854: WHERE rgp.id = p_rgp_id
2855: AND rgdv.LOOKUP_CODE = rgp.rgd_code
2856: AND rgdv.lookup_type = 'OKC_RULE_GROUP_DEF'
2857: AND srdv.RGD_CODE = rgp.rgd_code

Line 3504: FROM okc_k_headers_b

3500: PROCEDURE Set_Attach_Session_Vars(p_chr_id NUMBER) IS
3501: l_app_id NUMBER;
3502: Cursor l_chr_csr Is
3503: SELECT application_id
3504: FROM okc_k_headers_b
3505: WHERE id = p_chr_id;
3506: BEGIN
3507: If (p_chr_id IS NOT NULL AND
3508: FND_ATTACHMENT_UTIL_PKG.function_name IS NULL

Line 3652: FROM okc_subclasses_b osb,okc_k_headers_b okb

3648: -- cursor to get the contract category
3649:
3650: CURSOR l_Service_Contract_csr IS
3651: SELECT osb.cls_code
3652: FROM okc_subclasses_b osb,okc_k_headers_b okb
3653: WHERE okb.id = p_from_chr_id
3654: AND okb.scs_code = osb.code ;
3655:
3656: -- Added for Bug 3764231

Line 3975: FROM okc_k_headers_b

3971: WHERE id = p_to_cle_id;
3972:
3973: CURSOR c_chr IS
3974: SELECT start_date,end_date
3975: FROM okc_k_headers_b
3976: WHERE id = p_to_chr_id;
3977:
3978: BEGIN
3979: IF (p_to_chr_id IS NULL OR p_to_chr_id = OKC_API.G_MISS_NUM) THEN

Line 4950: FROM okc_k_headers_b chr,

4946: START WITH id = p_from_cle_id;
4947:
4948: CURSOR c_application_id IS
4949: SELECT chr.application_id
4950: FROM okc_k_headers_b chr,
4951: okc_k_lines_b cle
4952: WHERE chr.id = cle.dnz_chr_id
4953: AND cle.id = p_from_cle_id;
4954: ----------------------------------------------------------------------------

Line 5409: from okc_k_headers_b

5405: -- /Rules migration/
5406: --FOr other contracts classes, conversion data is now stored at the header level
5407: select CONVERSION_TYPE, CONVERSION_RATE, CONVERSION_rate_DATE
5408: into g_conversion_type, g_conversion_rate, g_conversion_date
5409: from okc_k_headers_b
5410: where id = l_chrv_rec.id;
5411: End If;
5412:
5413:

Line 5645: l_entity_name := 'OKC_K_HEADERS_B';

5641: l_entity_name := 'OKC_K_HEADERS_V';
5642: l_from_entity_name := 'OKC_K_HEADERS_V';
5643: l_to_entity_name := 'OKC_K_HEADERS_V';
5644: ELSE */
5645: l_entity_name := 'OKC_K_HEADERS_B';
5646: l_from_entity_name := 'OKC_K_HEADERS_B';
5647: l_to_entity_name := 'OKC_K_HEADERS_B';
5648: --End If;
5649:

Line 5646: l_from_entity_name := 'OKC_K_HEADERS_B';

5642: l_from_entity_name := 'OKC_K_HEADERS_V';
5643: l_to_entity_name := 'OKC_K_HEADERS_V';
5644: ELSE */
5645: l_entity_name := 'OKC_K_HEADERS_B';
5646: l_from_entity_name := 'OKC_K_HEADERS_B';
5647: l_to_entity_name := 'OKC_K_HEADERS_B';
5648: --End If;
5649:
5650: If (fnd_attachment_util_pkg.get_atchmt_exists (

Line 5647: l_to_entity_name := 'OKC_K_HEADERS_B';

5643: l_to_entity_name := 'OKC_K_HEADERS_V';
5644: ELSE */
5645: l_entity_name := 'OKC_K_HEADERS_B';
5646: l_from_entity_name := 'OKC_K_HEADERS_B';
5647: l_to_entity_name := 'OKC_K_HEADERS_B';
5648: --End If;
5649:
5650: If (fnd_attachment_util_pkg.get_atchmt_exists (
5651: l_entity_name => l_entity_name,

Line 6055: FROM okc_subclasses_b osb,okc_k_headers_b okb

6051: -- cursor to get the contract category
6052:
6053: CURSOR l_Service_Contract_csr IS
6054: SELECT osb.cls_code
6055: FROM okc_subclasses_b osb,okc_k_headers_b okb
6056: WHERE okb.id = p_chr_id
6057: AND okb.scs_code = osb.code ;
6058:
6059: CURSOR c_lines IS

Line 8225: -- okc_k_headers_bh/hv and as NUMBER in okc_k_headers_b/v. This gives

8221: l_no_data_found BOOLEAN := TRUE;
8222:
8223: -- Bug 1922121: Compilation errors on ktst115. Problem occurred
8224: -- because application_id is defined as varchar2(240) in
8225: -- okc_k_headers_bh/hv and as NUMBER in okc_k_headers_b/v. This gives
8226: -- problems in the UNION ALL because it tries to combine datatypes
8227: -- Fix: Put a to_char() around application_id in the first cursor
8228:
8229: CURSOR c_chrv_rec IS

Line 10469: FROM okc_subclasses_b osb,okc_k_headers_b okb

10465: -- cursor to get the contract category
10466:
10467: CURSOR l_Service_Contract_csr IS
10468: SELECT osb.cls_code
10469: FROM okc_subclasses_b osb,okc_k_headers_b okb
10470: WHERE okb.id = p_from_chr_id
10471: AND okb.scs_code = osb.code ;
10472:
10473: -- Added for Bug 3764231

Line 11495: FROM okc_k_headers_b

11491: CURSOR get_k_num_csr(p_chr_id IN NUMBER)
11492: IS
11493: SELECT
11494: contract_number ||' '|| contract_number_modifier
11495: FROM okc_k_headers_b
11496: WHERE id = p_chr_id;
11497:
11498: l_token VARCHAR2(250);
11499: l_msg_stack VARCHAR2(250);

Line 11792: okc_k_headers_b

11788: -- Get Source Contract ID
11789: CURSOR GetSourceContractID(P_To_Chr_ID IN NUMBER) IS
11790: select orig_system_id1
11791: from
11792: okc_k_headers_b
11793: where id = P_To_Chr_ID;
11794:
11795: P_From_Chr_ID NUMBER;
11796:

Line 11815: FROM OKC_K_HEADERS_B

11811:
11812: -- Get Header start date and rules
11813: CURSOR get_hdr_date_csr(p_chr_id IN NUMBER) IS
11814: SELECT start_date,end_date
11815: FROM OKC_K_HEADERS_B
11816: WHERE id = p_chr_id;
11817:
11818: -- Get all top lines
11819: CURSOR topline_csr(p_chr_id IN NUMBER) IS

Line 11979: FROM okc_k_headers_b

11975: --end npalepu
11976:
11977: CURSOR get_hdr_enddate (p_chr_id IN NUMBER) IS
11978: SELECT end_date,inv_rule_id
11979: FROM okc_k_headers_b
11980: WHERE id= p_chr_id;
11981:
11982: CURSOR get_parent_line_enddate (p_cle_id IN NUMBER) IS
11983: SELECT end_date,inv_rule_id