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 140: UPDATE OKC_K_HEADERS_B

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

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

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

Line 332: p_k_num IN okc_k_headers_b.contract_number%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,
331: p_to_m IN VARCHAR2 DEFAULT NULL,
332: p_k_num IN okc_k_headers_b.contract_number%TYPE DEFAULT NULL,
333: p_k_num_mod IN okc_k_headers_b.contract_number_modifier%TYPE DEFAULT NULL,
334: p_update_minor_version IN VARCHAR2 DEFAULT 'Y',
335: x_return_status OUT NOCOPY VARCHAR2) IS
336: C number := 0;

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

329: p_to_k IN VARCHAR2 DEFAULT NULL,
330: p_from_m IN VARCHAR2 DEFAULT NULL,
331: p_to_m IN VARCHAR2 DEFAULT NULL,
332: p_k_num IN okc_k_headers_b.contract_number%TYPE DEFAULT NULL,
333: p_k_num_mod IN okc_k_headers_b.contract_number_modifier%TYPE DEFAULT NULL,
334: p_update_minor_version IN VARCHAR2 DEFAULT 'Y',
335: x_return_status OUT NOCOPY VARCHAR2) IS
336: C number := 0;
337:

Line 349: contract_number okc_k_headers_b.contract_number%TYPE,

345: l_cle_rec okc_contract_pub.clev_rec_type;
346: x_cle_rec okc_contract_pub.clev_rec_type;
347:
348: TYPE line_rec_type IS RECORD (
349: contract_number okc_k_headers_b.contract_number%TYPE,
350: contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE,
351: ID okc_k_lines_b.id%TYPE,
352: OBJECT_VERSION_NUMBER okc_k_lines_b.object_version_number%TYPE,
353: STS_CODE okc_k_lines_b.sts_code%TYPE,

Line 350: contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE,

346: x_cle_rec okc_contract_pub.clev_rec_type;
347:
348: TYPE line_rec_type IS RECORD (
349: contract_number okc_k_headers_b.contract_number%TYPE,
350: contract_number_modifier okc_k_headers_b.contract_number_modifier%TYPE,
351: ID okc_k_lines_b.id%TYPE,
352: OBJECT_VERSION_NUMBER okc_k_lines_b.object_version_number%TYPE,
353: STS_CODE okc_k_lines_b.sts_code%TYPE,
354: DATE_TERMINATED okc_k_lines_b.date_terminated%TYPE,

Line 431: okc_k_headers_b chr,

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

Line 464: OKC_K_HEADERS_B CHR,

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

Line 497: OKC_K_HEADERS_B CHR,

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

Line 526: OKC_K_HEADERS_B CHR,

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

Line 565: OKC_K_HEADERS_B chr,

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

Line 611: OKC_K_HEADERS_B chr

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

Line 659: OKC_K_HEADERS_B chr

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

Line 701: OKC_K_HEADERS_B chr

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

Line 743: okc_k_headers_b chr,

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

Line 787: okc_k_headers_b chr,

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

Line 826: okc_k_headers_b chr,

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

Line 861: okc_k_headers_b chr,

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

Line 899: okc_k_headers_b chr,

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

Line 938: okc_k_headers_b chr,

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

Line 973: okc_k_headers_b chr,

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

Line 3086: FROM OKC_K_HEADERS_B hdr,

3082: scs.CLS_CODE,
3083: status.CODE,
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

Line 3125: FROM OKC_K_HEADERS_B hdr,

3121: scs.CLS_CODE,
3122: status.CODE,
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

Line 3164: FROM OKC_K_HEADERS_B hdr,

3160: scs.CLS_CODE,
3161: status.CODE,
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

Line 3208: FROM OKC_K_HEADERS_B hdr,

3204: scs.CLS_CODE,
3205: status.CODE,
3206: status.STE_CODE,
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