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_STATUS_CHANGE_PVT dependencies on OKC_SUBCLASSES_B

Line 326: p_cls_code IN okc_subclasses_b.cls_code%TYPE DEFAULT NULL,

322: -- BUG 4285665 --
323: -- GCHADHA --
324: -- Added the fix done for the bug 3967643 --
325: Procedure line_status_change (p_kid IN NUMBER DEFAULT NULL,
326: p_cls_code IN okc_subclasses_b.cls_code%TYPE DEFAULT NULL,
327: p_scs_code IN okc_k_headers_b.scs_code%TYPE DEFAULT NULL,
328: p_from_k IN VARCHAR2 DEFAULT NULL,
329: p_to_k IN VARCHAR2 DEFAULT NULL,
330: p_from_m IN VARCHAR2 DEFAULT NULL,

Line 432: okc_subclasses_b scs

428: FROM OKC_K_LINES_B line,
429: OKC_STATUSES_V status,
430: fnd_lookups fnd,
431: okc_k_headers_b chr,
432: okc_subclasses_b scs
433: WHERE line.STS_CODE = status.CODE
434: AND line.dnz_chr_id = chr.id
435: AND chr.scs_code = scs.code
436: AND scs.cls_code <> 'OKL'

Line 465: OKC_SUBCLASSES_B SCS

461: OKC_STATUSES_TL stst,
462: OKC_STATUSES_B stsb,
463: FND_LOOKUPS FND,
464: OKC_K_HEADERS_B CHR,
465: OKC_SUBCLASSES_B SCS
466: WHERE LINE.STS_CODE = STST.CODE
467: AND LINE.DNZ_CHR_ID = CHR.ID
468: AND stst.code = stsb.code
469: AND STST.LANGUAGE = USERENV('LANG')

Line 484: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code); -- new

480: AND LINE.DATE_TERMINATED <= TRUNC(SYSDATE) + 0.99999
481: AND LINE.DATE_TERMINATED >= TRUNC(l_last_rundate)
482: AND LINE.TRN_CODE = FND.LOOKUP_CODE
483: AND FND.LOOKUP_TYPE= 'OKC_TERMINATION_REASON'
484: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code); -- new
485:
486: -- When only Category is provided
487: CURSOR c_termnt_line_all_category IS
488: SELECT

Line 498: OKC_SUBCLASSES_B SCS

494: OKC_STATUSES_TL stst,
495: OKC_STATUSES_B stsb,
496: FND_LOOKUPS FND,
497: OKC_K_HEADERS_B CHR,
498: OKC_SUBCLASSES_B SCS
499: WHERE LINE.STS_CODE = STST.CODE
500: AND LINE.DNZ_CHR_ID = CHR.ID
501: AND stst.code = stsb.code
502: AND STST.LANGUAGE = USERENV('LANG')

Line 513: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code); -- new

509: AND LINE.DATE_TERMINATED <= TRUNC(SYSDATE) + 0.99999
510: AND LINE.DATE_TERMINATED >= TRUNC(l_last_rundate)
511: AND LINE.TRN_CODE = FND.LOOKUP_CODE
512: AND FND.LOOKUP_TYPE= 'OKC_TERMINATION_REASON'
513: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code); -- new
514:
515: -- When no parameters are provided
516: CURSOR c_terminate_line_all IS
517: SELECT

Line 527: OKC_SUBCLASSES_B SCS

523: OKC_STATUSES_TL stst,
524: OKC_STATUSES_B stsb,
525: FND_LOOKUPS FND,
526: OKC_K_HEADERS_B CHR,
527: OKC_SUBCLASSES_B SCS
528: WHERE LINE.STS_CODE = STST.CODE
529: AND LINE.DNZ_CHR_ID = CHR.ID
530: AND stst.code = stsb.code
531: AND STST.LANGUAGE = USERENV('LANG')

Line 541: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code); -- new

537: AND LINE.DATE_TERMINATED <= TRUNC(SYSDATE) + 0.99999
538: AND LINE.DATE_TERMINATED >= TRUNC(l_last_rundate)
539: AND LINE.TRN_CODE = FND.LOOKUP_CODE
540: AND FND.LOOKUP_TYPE= 'OKC_TERMINATION_REASON'
541: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code); -- new
542:
543: -- From ACTIVE/SIGNED/HOLD to EXPIRED
544: -- Hint added as per Bug 2563108 (Suggested by Appsperf Team)
545: -- Commented for Bug #3967643. Split cursor into 3 parts based on parameters

Line 566: okc_subclasses_b scs

562: status.meaning
563: FROM OKC_K_LINES_B line,
564: OKC_STATUSES_V status,
565: OKC_K_HEADERS_B chr,
566: okc_subclasses_b scs
567: WHERE line.STS_CODE = status.CODE
568: AND line.dnz_chr_id = chr.id
569: AND chr.scs_code = scs.code
570: AND scs.cls_code <> 'OKL'

Line 612: -- okc_subclasses_b scs

608: FROM OKC_K_LINES_B line,
609: OKC_STATUSES_TL stst,
610: OKC_STATUSES_B stsb,
611: OKC_K_HEADERS_B chr
612: -- okc_subclasses_b scs
613: WHERE line.STS_CODE = stst.CODE
614: AND line.dnz_chr_id = chr.id
615: AND stst.code = stsb.code
616: AND STST.LANGUAGE = USERENV('LANG')

Line 635: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code);

631: AND line.end_date < trunc(sysdate)
632: AND line.end_date >= trunc(l_last_rundate)
633: AND (line.date_terminated IS NULL
634: OR line.date_terminated >= trunc(sysdate))
635: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code);
636:
637:
638: -- When only Category is provided
639: CURSOR c_expr_line_all_category IS

Line 660: -- okc_subclasses_b scs

656: -- OKC_STATUSES_V status,
657: OKC_STATUSES_TL stst,
658: OKC_STATUSES_B stsb,
659: OKC_K_HEADERS_B chr
660: -- okc_subclasses_b scs
661: WHERE line.STS_CODE = stst.CODE
662: AND line.dnz_chr_id = chr.id
663: AND stst.code = stsb.code
664: AND STST.LANGUAGE = USERENV('LANG')

Line 679: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code);

675: AND line.end_date < trunc(sysdate)
676: AND line.end_date >= trunc(l_last_rundate)
677: AND (line.date_terminated IS NULL
678: OR line.date_terminated >= trunc(sysdate))
679: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code);
680:
681: -- When no parameters are is provided
682: CURSOR c_expired_line_all IS
683: SELECT

Line 702: -- okc_subclasses_b scs

698: FROM OKC_K_LINES_B line,
699: OKC_STATUSES_TL stst,
700: OKC_STATUSES_B stsb,
701: OKC_K_HEADERS_B chr
702: -- okc_subclasses_b scs
703: WHERE line.STS_CODE = stst.CODE
704: AND line.dnz_chr_id = chr.id
705: AND stst.code = stsb.code
706: AND STST.LANGUAGE = USERENV('LANG')

Line 720: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code);

716: AND line.end_date < trunc(sysdate)
717: AND line.end_date >= trunc(l_last_rundate)
718: AND (line.date_terminated IS NULL
719: OR line.date_terminated >= trunc(sysdate))
720: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code);
721:
722: -- LINE from SIGNED to ACTIVE
723: /* Commented for Bug #3967643. Split cursor into 3 parts based on
724: parameters as suggested by Appsperf Team

Line 744: okc_subclasses_b scs

740: FROM OKC_K_LINES_B line,
741: OKC_STATUSES_V status,
742: OKC_STATUSES_B status1,
743: okc_k_headers_b chr,
744: okc_subclasses_b scs
745: WHERE line.STS_CODE = status.CODE
746: AND line.dnz_chr_id = chr.id
747: AND chr.scs_code = scs.code
748: AND scs.cls_code <> 'OKL'

Line 788: okc_subclasses_b scs

784: FROM OKC_K_LINES_B line,
785: OKC_STATUSES_V status,
786: OKC_STATUSES_B status1,
787: okc_k_headers_b chr,
788: okc_subclasses_b scs
789: WHERE line.STS_CODE = status.CODE
790: AND line.dnz_chr_id = chr.id
791: AND chr.scs_code = scs.code
792: AND scs.cls_code <> 'OKL'

Line 827: okc_subclasses_b scs

823: FROM OKC_K_LINES_B line,
824: OKC_STATUSES_V status,
825: OKC_STATUSES_B status1,
826: okc_k_headers_b chr,
827: okc_subclasses_b scs
828: WHERE line.STS_CODE = status.CODE
829: AND line.dnz_chr_id = chr.id
830: AND chr.scs_code = scs.code
831: AND scs.cls_code <> 'OKL'

Line 862: okc_subclasses_b scs

858: FROM OKC_K_LINES_B line,
859: OKC_STATUSES_V status,
860: OKC_STATUSES_B status1,
861: okc_k_headers_b chr,
862: okc_subclasses_b scs
863: WHERE line.STS_CODE = status.CODE
864: AND line.dnz_chr_id = chr.id
865: AND chr.scs_code = scs.code
866: AND scs.cls_code <> 'OKL'

Line 900: okc_subclasses_b scs

896: FROM OKC_K_LINES_B line,
897: OKC_STATUSES_V status,
898: OKC_STATUSES_B status1,
899: okc_k_headers_b chr,
900: okc_subclasses_b scs
901: WHERE line.STS_CODE = status.CODE
902: AND line.dnz_chr_id = chr.id
903: AND chr.scs_code = scs.code
904: AND scs.cls_code <> 'OKL'

Line 939: okc_subclasses_b scs

935: FROM OKC_K_LINES_B line,
936: OKC_STATUSES_V status,
937: OKC_STATUSES_B status1,
938: okc_k_headers_b chr,
939: okc_subclasses_b scs
940: WHERE line.STS_CODE = status.CODE
941: AND line.dnz_chr_id = chr.id
942: AND chr.scs_code = scs.code
943: AND scs.cls_code <> 'OKL'

Line 974: okc_subclasses_b scs

970: FROM OKC_K_LINES_B line,
971: OKC_STATUSES_V status,
972: OKC_STATUSES_B status1,
973: okc_k_headers_b chr,
974: okc_subclasses_b scs
975: WHERE line.STS_CODE = status.CODE
976: AND line.dnz_chr_id = chr.id
977: AND chr.scs_code = scs.code
978: AND scs.cls_code <> 'OKL'

Line 3088: OKC_SUBCLASSES_B scs

3084: status.STE_CODE,
3085: status.meaning
3086: FROM OKC_K_HEADERS_B hdr,
3087: OKC_STATUSES_V status,
3088: OKC_SUBCLASSES_B scs
3089: WHERE hdr.STS_CODE = status.CODE
3090: AND scs.code = hdr.scs_code
3091: and scs.cls_code <> 'OKL'
3092: and ((p_category is NULL) or (scs.CODE = p_category))

Line 3127: OKC_SUBCLASSES_B scs

3123: status.STE_CODE,
3124: status.meaning
3125: FROM OKC_K_HEADERS_B hdr,
3126: OKC_STATUSES_V status,
3127: OKC_SUBCLASSES_B scs
3128: WHERE hdr.STS_CODE = status.CODE
3129: AND scs.code = hdr.scs_code
3130: and scs.cls_code <> 'OKL'
3131: and ((p_category is NULL) or (scs.CODE = p_category))

Line 3166: OKC_SUBCLASSES_B scs

3162: status.STE_CODE,
3163: status.meaning
3164: FROM OKC_K_HEADERS_B hdr,
3165: OKC_STATUSES_V status,
3166: OKC_SUBCLASSES_B scs
3167: WHERE hdr.STS_CODE = status.CODE
3168: AND scs.code = hdr.scs_code
3169: and scs.cls_code <> 'OKL'
3170: and ((p_category is NULL) or (scs.CODE = p_category))

Line 3211: OKC_SUBCLASSES_B scs

3207: status.meaning
3208: FROM OKC_K_HEADERS_B hdr,
3209: OKC_STATUSES_V status,
3210: FND_LOOKUPS fnd,
3211: OKC_SUBCLASSES_B scs
3212: WHERE hdr.STS_CODE = status.CODE
3213: AND scs.code = hdr.scs_code
3214: and scs.cls_code <> 'OKL'
3215: and ((p_category is NULL) or (scs.CODE = p_category))