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_K_HEADERS_B

Line 142: UPDATE OKC_K_HEADERS_B

138:
139: BEGIN
140: x_return_status := OKC_API.G_RET_STS_SUCCESS;
141: x_chrv_rec := p_chrv_rec;
142: UPDATE OKC_K_HEADERS_B
143: SET STS_CODE = p_chrv_rec.sts_code,
144: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
145: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
146: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),

Line 341: p_scs_code IN okc_k_headers_b.scs_code%TYPE DEFAULT NULL,

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,
345: p_to_m IN VARCHAR2 DEFAULT NULL,

Line 346: p_k_num IN okc_k_headers_b.contract_number%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,
345: p_to_m IN VARCHAR2 DEFAULT NULL,
346: p_k_num IN okc_k_headers_b.contract_number%TYPE DEFAULT NULL,
347: p_k_num_mod IN okc_k_headers_b.contract_number_modifier%TYPE DEFAULT NULL,
348: p_update_minor_version IN VARCHAR2 DEFAULT 'Y',
349: x_return_status OUT NOCOPY VARCHAR2) IS
350: C number := 0;

Line 347: p_k_num_mod IN okc_k_headers_b.contract_number_modifier%TYPE DEFAULT NULL,

343: p_to_k IN VARCHAR2 DEFAULT NULL,
344: p_from_m IN VARCHAR2 DEFAULT NULL,
345: p_to_m IN VARCHAR2 DEFAULT NULL,
346: p_k_num IN okc_k_headers_b.contract_number%TYPE DEFAULT NULL,
347: p_k_num_mod IN okc_k_headers_b.contract_number_modifier%TYPE DEFAULT NULL,
348: p_update_minor_version IN VARCHAR2 DEFAULT 'Y',
349: x_return_status OUT NOCOPY VARCHAR2) IS
350: C number := 0;
351:

Line 363: contract_number okc_k_headers_b.contract_number%TYPE,

359: l_cle_rec okc_contract_pub.clev_rec_type;
360: x_cle_rec okc_contract_pub.clev_rec_type;
361:
362: TYPE line_rec_type IS RECORD (
363: contract_number okc_k_headers_b.contract_number%TYPE,
364: contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE,
365: ID okc_k_lines_b.id%TYPE,
366: OBJECT_VERSION_NUMBER okc_k_lines_b.object_version_number%TYPE,
367: STS_CODE okc_k_lines_b.sts_code%TYPE,

Line 364: contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE,

360: x_cle_rec okc_contract_pub.clev_rec_type;
361:
362: TYPE line_rec_type IS RECORD (
363: contract_number okc_k_headers_b.contract_number%TYPE,
364: contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE,
365: ID okc_k_lines_b.id%TYPE,
366: OBJECT_VERSION_NUMBER okc_k_lines_b.object_version_number%TYPE,
367: STS_CODE okc_k_lines_b.sts_code%TYPE,
368: DATE_TERMINATED okc_k_lines_b.date_terminated%TYPE,

Line 445: okc_k_headers_b chr,

441: status.meaning
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

Line 478: OKC_K_HEADERS_B CHR,

474: FROM OKC_K_LINES_B LINE,
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

Line 513: OKC_K_HEADERS_B CHR,

509: FROM OKC_K_LINES_B LINE,
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

Line 544: OKC_K_HEADERS_B CHR,

540: FROM OKC_K_LINES_B LINE,
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

Line 585: OKC_K_HEADERS_B chr,

581: status.STE_CODE,
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

Line 631: OKC_K_HEADERS_B chr

627: stst.meaning
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

Line 679: OKC_K_HEADERS_B chr

675: FROM OKC_K_LINES_B line,
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

Line 721: OKC_K_HEADERS_B chr

717: stst.meaning
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

Line 763: okc_k_headers_b chr,

759: status.meaning
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

Line 807: okc_k_headers_b chr,

803: status.meaning
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

Line 846: okc_k_headers_b chr,

842: status.meaning
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

Line 881: okc_k_headers_b chr,

877: status.meaning
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

Line 919: okc_k_headers_b chr,

915: status.meaning
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

Line 958: okc_k_headers_b chr,

954: status.meaning
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

Line 993: okc_k_headers_b chr,

989: status.meaning
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

Line 3107: FROM OKC_K_HEADERS_B hdr,

3103: scs.CLS_CODE,
3104: status.CODE,
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

Line 3146: FROM OKC_K_HEADERS_B hdr,

3142: scs.CLS_CODE,
3143: status.CODE,
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

Line 3184: FROM OKC_K_HEADERS_B hdr,

3180: scs.CLS_CODE,
3181: status.CODE,
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

Line 3220: FROM OKC_K_HEADERS_B hdr,

3216: scs.CLS_CODE,
3217: status.CODE,
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

Line 3254: FROM OKC_K_HEADERS_B hdr,

3250: scs.CLS_CODE,
3251: status.CODE,
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

Line 3288: FROM OKC_K_HEADERS_B hdr,

3284: scs.CLS_CODE,
3285: status.CODE,
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

Line 3329: FROM OKC_K_HEADERS_B hdr,

3325: scs.CLS_CODE,
3326: status.CODE,
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

Line 3368: FROM OKC_K_HEADERS_B hdr,

3364: scs.CLS_CODE,
3365: status.CODE,
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

Line 3404: FROM OKC_K_HEADERS_B hdr,

3400: scs.CLS_CODE,
3401: status.CODE,
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

Line 3439: FROM OKC_K_HEADERS_B hdr,

3435: scs.CLS_CODE,
3436: status.CODE,
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

Line 3474: FROM OKC_K_HEADERS_B hdr,

3470: scs.CLS_CODE,
3471: status.CODE,
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

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 3674: FROM OKC_K_HEADERS_B hdr,

3670: scs.CLS_CODE,
3671: status.CODE,
3672: status.STE_CODE,
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

Line 3719: FROM OKC_K_HEADERS_B hdr,

3715: scs.CLS_CODE,
3716: status.CODE,
3717: status.STE_CODE,
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

Line 3762: FROM OKC_K_HEADERS_B hdr,

3758: scs.CLS_CODE,
3759: status.CODE,
3760: status.STE_CODE,
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

Line 3803: FROM OKC_K_HEADERS_B hdr,

3799: scs.CLS_CODE,
3800: status.CODE,
3801: status.STE_CODE,
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

Line 3842: FROM OKC_K_HEADERS_B hdr,

3838: scs.CLS_CODE,
3839: status.CODE,
3840: status.STE_CODE,
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