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.OKL_CONTRACT_STATUS_PVT dependencies on OKC_STATUSES_B

Line 520: FROM OKC_STATUSES_B

516:
517: --cusrsor to get OKC_STATUS check if status not in OKC frozen statuses
518: CURSOR okc_sts_csr (p_okl_sts IN VARCHAR2) IS
519: SELECT ste_code
520: FROM OKC_STATUSES_B
521: WHERE CODE = p_okl_sts
522: AND nvl(START_DATE,sysdate) <= sysdate
523: AND nvl(END_DATE, sysdate+1) > sysdate;
524:

Line 525: l_okc_sts OKC_STATUSES_B.STE_CODE%TYPE;

521: WHERE CODE = p_okl_sts
522: AND nvl(START_DATE,sysdate) <= sysdate
523: AND nvl(END_DATE, sysdate+1) > sysdate;
524:
525: l_okc_sts OKC_STATUSES_B.STE_CODE%TYPE;
526:
527:
528: --------------------------------------------------------------------------------
529: --Local Procedure to Copy Khr status to kle

Line 534: p_sts_code IN OKC_STATUSES_B.CODE%TYPE,

530: --------------------------------------------------------------------------------
531: PROCEDURE cpy_khr_sts_to_kle(p_api_version IN NUMBER,
532: p_init_msg_list IN VARCHAR2,
533: p_kle_id IN NUMBER,
534: p_sts_code IN OKC_STATUSES_B.CODE%TYPE,
535: p_kle_start_date IN DATE,
536: p_khr_start_date IN DATE,
537: p_kle_end_date IN DATE,
538: p_khr_end_date IN DATE,

Line 851: OKC_STATUSES_B B

847: A.ID,
848: A.START_DATE,
849: A.END_DATE
850: FROM OKC_K_LINES_B A,
851: OKC_STATUSES_B B
852: WHERE A.DNZ_CHR_ID = p_chr_id
853: AND A.STS_CODE = B.CODE
854: AND B.STE_CODE not in ('HOLD','EXPIRED','TERMINATED','CANCELLED');
855: /* -- Bug 5046462: Performance fix by removing UNION part

Line 863: AND NOT EXISTS (select 'x' from OKC_STATUSES_B B where B.CODE = A.STS_CODE);

859: A.START_DATE,
860: A.END_DATE
861: FROM OKC_K_LINES_B A
862: WHERE A.DNZ_CHR_ID = p_chr_id
863: AND NOT EXISTS (select 'x' from OKC_STATUSES_B B where B.CODE = A.STS_CODE);
864: */
865:
866: l_kle_sts clev_tbl_sts_type;
867: l_kle_id clev_tbl_id_type;

Line 882: FROM OKC_STATUSES_B

878:
879: --cusrsor to get OKC_STATUS check if status not in OKC frozen statuses
880: CURSOR okc_sts_csr (p_okl_sts IN VARCHAR2) IS
881: SELECT ste_code
882: FROM OKC_STATUSES_B
883: WHERE CODE = p_okl_sts
884: AND nvl(START_DATE,sysdate) <= sysdate
885: AND nvl(END_DATE, sysdate+1) > sysdate;
886:

Line 887: l_okc_sts OKC_STATUSES_B.STE_CODE%TYPE;

883: WHERE CODE = p_okl_sts
884: AND nvl(START_DATE,sysdate) <= sysdate
885: AND nvl(END_DATE, sysdate+1) > sysdate;
886:
887: l_okc_sts OKC_STATUSES_B.STE_CODE%TYPE;
888:
889:
890: Begin
891: --Call OKL_API.START_ACTIVITY

Line 1070: FROM OKC_STATUSES_B

1066:
1067: --cusrsor to get OKC_STATUS check if status not in OKC frozen statuses
1068: CURSOR okc_sts_csr (p_okl_sts IN VARCHAR2) IS
1069: SELECT ste_code
1070: FROM OKC_STATUSES_B
1071: WHERE CODE = p_okl_sts
1072: AND nvl(START_DATE,sysdate) <= sysdate
1073: AND nvl(END_DATE, sysdate+1) > sysdate;
1074:

Line 1075: l_okc_sts OKC_STATUSES_B.STE_CODE%TYPE;

1071: WHERE CODE = p_okl_sts
1072: AND nvl(START_DATE,sysdate) <= sysdate
1073: AND nvl(END_DATE, sysdate+1) > sysdate;
1074:
1075: l_okc_sts OKC_STATUSES_B.STE_CODE%TYPE;
1076:
1077: l_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1078: x_chrv_rec okl_okc_migration_pvt.chrv_rec_type;
1079: