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 340: p_cls_code IN okc_subclasses_b.cls_code%TYPE DEFAULT NULL,

336: -- BUG 4285665 --
337: -- GCHADHA --
338: -- Added the fix done for the bug 3967643 --
339: Procedure line_status_change (p_kid IN NUMBER DEFAULT NULL,
340: p_cls_code IN okc_subclasses_b.cls_code%TYPE DEFAULT NULL,
341: p_scs_code IN okc_k_headers_b.scs_code%TYPE DEFAULT NULL,
342: p_from_k IN VARCHAR2 DEFAULT NULL,
343: p_to_k IN VARCHAR2 DEFAULT NULL,
344: p_from_m IN VARCHAR2 DEFAULT NULL,

Line 446: okc_subclasses_b scs

442: FROM OKC_K_LINES_B line,
443: OKC_STATUSES_V status,
444: fnd_lookups fnd,
445: okc_k_headers_b chr,
446: okc_subclasses_b scs
447: WHERE line.STS_CODE = status.CODE
448: AND line.dnz_chr_id = chr.id
449: AND chr.scs_code = scs.code
450: AND scs.cls_code <> 'OKL'

Line 479: OKC_SUBCLASSES_B SCS

475: OKC_STATUSES_TL stst,
476: OKC_STATUSES_B stsb,
477: FND_LOOKUPS FND,
478: OKC_K_HEADERS_B CHR,
479: OKC_SUBCLASSES_B SCS
480: WHERE LINE.STS_CODE = STST.CODE
481: AND LINE.DNZ_CHR_ID = CHR.ID
482: AND stst.code = stsb.code
483: AND STST.LANGUAGE = USERENV('LANG')

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

494: AND LINE.DATE_TERMINATED <= TRUNC(SYSDATE) + 0.99999
495: AND LINE.DATE_TERMINATED >= TRUNC(l_last_rundate)
496: AND LINE.TRN_CODE = FND.LOOKUP_CODE
497: AND FND.LOOKUP_TYPE= 'OKC_TERMINATION_REASON'
498: --AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code); -- new
499: AND chr.scs_code = scs.code
500: And scs.cls_code <> 'OKL';
501:
502: -- When only Category is provided

Line 514: OKC_SUBCLASSES_B SCS

510: OKC_STATUSES_TL stst,
511: OKC_STATUSES_B stsb,
512: FND_LOOKUPS FND,
513: OKC_K_HEADERS_B CHR,
514: OKC_SUBCLASSES_B SCS
515: WHERE LINE.STS_CODE = STST.CODE
516: AND LINE.DNZ_CHR_ID = CHR.ID
517: AND stst.code = stsb.code
518: AND STST.LANGUAGE = USERENV('LANG')

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

525: AND LINE.DATE_TERMINATED <= TRUNC(SYSDATE) + 0.99999
526: AND LINE.DATE_TERMINATED >= TRUNC(l_last_rundate)
527: AND LINE.TRN_CODE = FND.LOOKUP_CODE
528: AND FND.LOOKUP_TYPE= 'OKC_TERMINATION_REASON'
529: --AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code); -- new
530: And chr.scs_code = scs.code
531: And scs.cls_code <> 'OKL';
532:
533: -- When no parameters are provided

Line 545: OKC_SUBCLASSES_B SCS

541: OKC_STATUSES_TL stst,
542: OKC_STATUSES_B stsb,
543: FND_LOOKUPS FND,
544: OKC_K_HEADERS_B CHR,
545: OKC_SUBCLASSES_B SCS
546: WHERE LINE.STS_CODE = STST.CODE
547: AND LINE.DNZ_CHR_ID = CHR.ID
548: AND stst.code = stsb.code
549: AND STST.LANGUAGE = USERENV('LANG')

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

555: AND LINE.DATE_TERMINATED <= TRUNC(SYSDATE) + 0.99999
556: AND LINE.DATE_TERMINATED >= TRUNC(l_last_rundate)
557: AND LINE.TRN_CODE = FND.LOOKUP_CODE
558: AND FND.LOOKUP_TYPE= 'OKC_TERMINATION_REASON'
559: --AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code); -- new
560: And chr.scs_code = scs.code
561: And scs.cls_code <> 'OKL';
562:
563: -- From ACTIVE/SIGNED/HOLD to EXPIRED

Line 586: okc_subclasses_b scs

582: status.meaning
583: FROM OKC_K_LINES_B line,
584: OKC_STATUSES_V status,
585: OKC_K_HEADERS_B chr,
586: okc_subclasses_b scs
587: WHERE line.STS_CODE = status.CODE
588: AND line.dnz_chr_id = chr.id
589: AND chr.scs_code = scs.code
590: AND scs.cls_code <> 'OKL'

Line 632: -- okc_subclasses_b scs

628: FROM OKC_K_LINES_B line,
629: OKC_STATUSES_TL stst,
630: OKC_STATUSES_B stsb,
631: OKC_K_HEADERS_B chr
632: -- okc_subclasses_b scs
633: WHERE line.STS_CODE = stst.CODE
634: AND line.dnz_chr_id = chr.id
635: AND stst.code = stsb.code
636: AND STST.LANGUAGE = USERENV('LANG')

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

651: AND line.end_date < trunc(sysdate)
652: AND line.end_date >= trunc(l_last_rundate)
653: AND (line.date_terminated IS NULL
654: OR line.date_terminated >= trunc(sysdate))
655: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code);
656:
657:
658: -- When only Category is provided
659: CURSOR c_expr_line_all_category IS

Line 680: -- okc_subclasses_b scs

676: -- OKC_STATUSES_V status,
677: OKC_STATUSES_TL stst,
678: OKC_STATUSES_B stsb,
679: OKC_K_HEADERS_B chr
680: -- okc_subclasses_b scs
681: WHERE line.STS_CODE = stst.CODE
682: AND line.dnz_chr_id = chr.id
683: AND stst.code = stsb.code
684: AND STST.LANGUAGE = USERENV('LANG')

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

695: AND line.end_date < trunc(sysdate)
696: AND line.end_date >= trunc(l_last_rundate)
697: AND (line.date_terminated IS NULL
698: OR line.date_terminated >= trunc(sysdate))
699: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code);
700:
701: -- When no parameters are is provided
702: CURSOR c_expired_line_all IS
703: SELECT

Line 722: -- okc_subclasses_b scs

718: FROM OKC_K_LINES_B line,
719: OKC_STATUSES_TL stst,
720: OKC_STATUSES_B stsb,
721: OKC_K_HEADERS_B chr
722: -- okc_subclasses_b scs
723: WHERE line.STS_CODE = stst.CODE
724: AND line.dnz_chr_id = chr.id
725: AND stst.code = stsb.code
726: AND STST.LANGUAGE = USERENV('LANG')

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

736: AND line.end_date < trunc(sysdate)
737: AND line.end_date >= trunc(l_last_rundate)
738: AND (line.date_terminated IS NULL
739: OR line.date_terminated >= trunc(sysdate))
740: AND exists (select 1 from okc_subclasses_b scs where scs.cls_code <> 'OKL' AND chr.scs_code = scs.code);
741:
742: -- LINE from SIGNED to ACTIVE
743: /* Commented for Bug #3967643. Split cursor into 3 parts based on
744: parameters as suggested by Appsperf Team

Line 764: okc_subclasses_b scs

760: FROM OKC_K_LINES_B line,
761: OKC_STATUSES_V status,
762: OKC_STATUSES_B status1,
763: okc_k_headers_b chr,
764: okc_subclasses_b scs
765: WHERE line.STS_CODE = status.CODE
766: AND line.dnz_chr_id = chr.id
767: AND chr.scs_code = scs.code
768: AND scs.cls_code <> 'OKL'

Line 808: okc_subclasses_b scs

804: FROM OKC_K_LINES_B line,
805: OKC_STATUSES_V status,
806: OKC_STATUSES_B status1,
807: okc_k_headers_b chr,
808: okc_subclasses_b scs
809: WHERE line.STS_CODE = status.CODE
810: AND line.dnz_chr_id = chr.id
811: AND chr.scs_code = scs.code
812: AND scs.cls_code <> 'OKL'

Line 847: okc_subclasses_b scs

843: FROM OKC_K_LINES_B line,
844: OKC_STATUSES_V status,
845: OKC_STATUSES_B status1,
846: okc_k_headers_b chr,
847: okc_subclasses_b scs
848: WHERE line.STS_CODE = status.CODE
849: AND line.dnz_chr_id = chr.id
850: AND chr.scs_code = scs.code
851: AND scs.cls_code <> 'OKL'

Line 882: okc_subclasses_b scs

878: FROM OKC_K_LINES_B line,
879: OKC_STATUSES_V status,
880: OKC_STATUSES_B status1,
881: okc_k_headers_b chr,
882: okc_subclasses_b scs
883: WHERE line.STS_CODE = status.CODE
884: AND line.dnz_chr_id = chr.id
885: AND chr.scs_code = scs.code
886: AND scs.cls_code <> 'OKL'

Line 920: okc_subclasses_b scs

916: FROM OKC_K_LINES_B line,
917: OKC_STATUSES_V status,
918: OKC_STATUSES_B status1,
919: okc_k_headers_b chr,
920: okc_subclasses_b scs
921: WHERE line.STS_CODE = status.CODE
922: AND line.dnz_chr_id = chr.id
923: AND chr.scs_code = scs.code
924: AND scs.cls_code <> 'OKL'

Line 959: okc_subclasses_b scs

955: FROM OKC_K_LINES_B line,
956: OKC_STATUSES_V status,
957: OKC_STATUSES_B status1,
958: okc_k_headers_b chr,
959: okc_subclasses_b scs
960: WHERE line.STS_CODE = status.CODE
961: AND line.dnz_chr_id = chr.id
962: AND chr.scs_code = scs.code
963: AND scs.cls_code <> 'OKL'

Line 994: okc_subclasses_b scs

990: FROM OKC_K_LINES_B line,
991: OKC_STATUSES_V status,
992: OKC_STATUSES_B status1,
993: okc_k_headers_b chr,
994: okc_subclasses_b scs
995: WHERE line.STS_CODE = status.CODE
996: AND line.dnz_chr_id = chr.id
997: AND chr.scs_code = scs.code
998: AND scs.cls_code <> 'OKL'

Line 3109: OKC_SUBCLASSES_B scs

3105: status.STE_CODE,
3106: status.meaning
3107: FROM OKC_K_HEADERS_B hdr,
3108: OKC_STATUSES_V status,
3109: OKC_SUBCLASSES_B scs
3110: WHERE hdr.STS_CODE = status.CODE
3111: AND scs.code = hdr.scs_code
3112: and scs.cls_code <> 'OKL'
3113: and ((p_category is NULL) or (scs.CODE = p_category))

Line 3148: OKC_SUBCLASSES_B scs

3144: status.STE_CODE,
3145: status.meaning
3146: FROM OKC_K_HEADERS_B hdr,
3147: OKC_STATUSES_V status,
3148: OKC_SUBCLASSES_B scs
3149: WHERE hdr.STS_CODE = status.CODE
3150: AND scs.code = hdr.scs_code
3151: and scs.cls_code <> 'OKL'
3152: and ((p_category is NULL) or (scs.CODE = p_category))

Line 3186: OKC_SUBCLASSES_B scs

3182: status.STE_CODE,
3183: status.meaning
3184: FROM OKC_K_HEADERS_B hdr,
3185: OKC_STATUSES_V status,
3186: OKC_SUBCLASSES_B scs
3187: WHERE hdr.STS_CODE = status.CODE
3188: AND scs.code = hdr.scs_code
3189: and scs.cls_code <> 'OKL'
3190: and hdr.CONTRACT_NUMBER >= p_from_k

Line 3222: OKC_SUBCLASSES_B scs

3218: status.STE_CODE,
3219: status.meaning
3220: FROM OKC_K_HEADERS_B hdr,
3221: OKC_STATUSES_V status,
3222: OKC_SUBCLASSES_B scs
3223: WHERE hdr.STS_CODE = status.CODE
3224: AND scs.code = hdr.scs_code
3225: and scs.cls_code <> 'OKL'
3226: and scs.CODE = p_category

Line 3256: OKC_SUBCLASSES_B scs

3252: status.STE_CODE,
3253: status.meaning
3254: FROM OKC_K_HEADERS_B hdr,
3255: OKC_STATUSES_V status,
3256: OKC_SUBCLASSES_B scs
3257: WHERE hdr.STS_CODE = status.CODE
3258: AND scs.code = hdr.scs_code
3259: and scs.cls_code <> 'OKL'
3260: and hdr.STS_CODE <> 'QA_HOLD'

Line 3290: OKC_SUBCLASSES_B scs

3286: status.STE_CODE,
3287: status.meaning
3288: FROM OKC_K_HEADERS_B hdr,
3289: OKC_STATUSES_V status,
3290: OKC_SUBCLASSES_B scs
3291: WHERE hdr.STS_CODE = status.CODE
3292: AND scs.code = hdr.scs_code
3293: and scs.cls_code <> 'OKL'
3294: and ((p_category is NULL) or (scs.CODE = p_category))

Line 3331: OKC_SUBCLASSES_B scs

3327: status.STE_CODE,
3328: status.meaning
3329: FROM OKC_K_HEADERS_B hdr,
3330: OKC_STATUSES_V status,
3331: OKC_SUBCLASSES_B scs
3332: WHERE hdr.STS_CODE = status.CODE
3333: AND scs.code = hdr.scs_code
3334: and scs.cls_code <> 'OKL'
3335: and ((p_category is NULL) or (scs.CODE = p_category))

Line 3370: OKC_SUBCLASSES_B scs

3366: status.STE_CODE,
3367: status.meaning
3368: FROM OKC_K_HEADERS_B hdr,
3369: OKC_STATUSES_V status,
3370: OKC_SUBCLASSES_B scs
3371: WHERE hdr.STS_CODE = status.CODE
3372: AND scs.code = hdr.scs_code
3373: and scs.cls_code <> 'OKL'
3374: and hdr.CONTRACT_NUMBER >= p_from_k

Line 3406: OKC_SUBCLASSES_B scs

3402: status.STE_CODE,
3403: status.meaning
3404: FROM OKC_K_HEADERS_B hdr,
3405: OKC_STATUSES_V status,
3406: OKC_SUBCLASSES_B scs
3407: WHERE hdr.STS_CODE = status.CODE
3408: AND scs.code = hdr.scs_code
3409: and scs.cls_code <> 'OKL'
3410: and scs.CODE = p_category

Line 3441: OKC_SUBCLASSES_B scs

3437: status.STE_CODE,
3438: status.meaning
3439: FROM OKC_K_HEADERS_B hdr,
3440: OKC_STATUSES_V status,
3441: OKC_SUBCLASSES_B scs
3442: WHERE hdr.STS_CODE = status.CODE
3443: AND scs.code = hdr.scs_code
3444: and scs.cls_code <> 'OKL'
3445: and hdr.STS_CODE <> 'QA_HOLD'

Line 3476: OKC_SUBCLASSES_B scs

3472: status.STE_CODE,
3473: status.meaning
3474: FROM OKC_K_HEADERS_B hdr,
3475: OKC_STATUSES_V status,
3476: OKC_SUBCLASSES_B scs
3477: WHERE hdr.STS_CODE = status.CODE
3478: AND scs.code = hdr.scs_code
3479: and scs.cls_code <> 'OKL'
3480: and ((p_category is NULL) or (scs.CODE = p_category))

Line 3522: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs

3518: scs.CLS_CODE,
3519: status.CODE,
3520: status.STE_CODE,
3521: status.meaning
3522: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs
3523: WHERE hdr.STS_CODE = status.CODE
3524: AND scs.code = hdr.scs_code
3525: AND scs.cls_code <> 'OKL'
3526: AND ((p_category IS NULL) OR (scs.CODE = p_category))

Line 3564: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs

3560: scs.CLS_CODE,
3561: status.CODE,
3562: status.STE_CODE,
3563: status.meaning
3564: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs
3565: WHERE hdr.STS_CODE = status.CODE
3566: AND scs.code = hdr.scs_code
3567: AND scs.cls_code <> 'OKL'
3568: AND hdr.CONTRACT_NUMBER >= p_from_k

Line 3602: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs

3598: scs.CLS_CODE,
3599: status.CODE,
3600: status.STE_CODE,
3601: status.meaning
3602: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs
3603: WHERE hdr.STS_CODE = status.CODE
3604: AND scs.code = hdr.scs_code
3605: AND scs.cls_code <> 'OKL'
3606: AND scs.CODE = p_category

Line 3639: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs

3635: scs.CLS_CODE,
3636: status.CODE,
3637: status.STE_CODE,
3638: status.meaning
3639: FROM OKC_K_HEADERS_B hdr, OKC_STATUSES_V status, OKC_SUBCLASSES_B scs
3640: WHERE hdr.STS_CODE = status.CODE
3641: AND scs.code = hdr.scs_code
3642: AND scs.cls_code <> 'OKL'
3643: AND hdr.STS_CODE <> 'QA_HOLD'

Line 3677: OKC_SUBCLASSES_B scs

3673: status.meaning
3674: FROM OKC_K_HEADERS_B hdr,
3675: OKC_STATUSES_V status,
3676: FND_LOOKUPS fnd,
3677: OKC_SUBCLASSES_B scs
3678: WHERE hdr.STS_CODE = status.CODE
3679: AND scs.code = hdr.scs_code
3680: and scs.cls_code <> 'OKL'
3681: and ((p_category is NULL) or (scs.CODE = p_category))

Line 3722: OKC_SUBCLASSES_B scs

3718: status.meaning
3719: FROM OKC_K_HEADERS_B hdr,
3720: OKC_STATUSES_V status,
3721: FND_LOOKUPS fnd,
3722: OKC_SUBCLASSES_B scs
3723: WHERE hdr.STS_CODE = status.CODE
3724: AND scs.code = hdr.scs_code
3725: AND scs.cls_code <> 'OKL'
3726: AND ((p_category IS NULL) OR (scs.CODE = p_category))

Line 3765: OKC_SUBCLASSES_B scs

3761: status.meaning
3762: FROM OKC_K_HEADERS_B hdr,
3763: OKC_STATUSES_V status,
3764: FND_LOOKUPS fnd,
3765: OKC_SUBCLASSES_B scs
3766: WHERE hdr.STS_CODE = status.CODE
3767: AND scs.code = hdr.scs_code
3768: AND scs.cls_code <> 'OKL'
3769: AND hdr.CONTRACT_NUMBER >= p_from_k

Line 3806: OKC_SUBCLASSES_B scs

3802: status.meaning
3803: FROM OKC_K_HEADERS_B hdr,
3804: OKC_STATUSES_V status,
3805: FND_LOOKUPS fnd,
3806: OKC_SUBCLASSES_B scs
3807: WHERE hdr.STS_CODE = status.CODE
3808: AND scs.code = hdr.scs_code
3809: AND scs.cls_code <> 'OKL'
3810: AND scs.CODE = p_category

Line 3845: OKC_SUBCLASSES_B scs

3841: status.meaning
3842: FROM OKC_K_HEADERS_B hdr,
3843: OKC_STATUSES_V status,
3844: FND_LOOKUPS fnd,
3845: OKC_SUBCLASSES_B scs
3846: WHERE hdr.STS_CODE = status.CODE
3847: AND scs.code = hdr.scs_code
3848: AND scs.cls_code <> 'OKL'
3849: AND hdr.STS_CODE <> 'QA_HOLD'