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_LINES_B

Line 216: UPDATE OKC_K_LINES_B

212: BEGIN
213:
214: x_return_status := OKC_API.G_RET_STS_SUCCESS;
215: x_clev_rec := p_clev_rec;
216: UPDATE OKC_K_LINES_B
217: SET STS_CODE = p_clev_rec.sts_code,
218: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
219: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
220: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),

Line 351: ID okc_k_lines_b.id%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,
355: START_DATE okc_k_lines_b.start_date%TYPE,

Line 352: OBJECT_VERSION_NUMBER okc_k_lines_b.object_version_number%TYPE,

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,
355: START_DATE okc_k_lines_b.start_date%TYPE,
356: END_DATE okc_k_lines_b.end_date%TYPE,

Line 353: STS_CODE okc_k_lines_b.sts_code%TYPE,

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,
355: START_DATE okc_k_lines_b.start_date%TYPE,
356: END_DATE okc_k_lines_b.end_date%TYPE,
357: LINE_NUMBER okc_k_lines_b.line_number%TYPE,

Line 354: DATE_TERMINATED okc_k_lines_b.date_terminated%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,
355: START_DATE okc_k_lines_b.start_date%TYPE,
356: END_DATE okc_k_lines_b.end_date%TYPE,
357: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
358: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,

Line 355: START_DATE okc_k_lines_b.start_date%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,
355: START_DATE okc_k_lines_b.start_date%TYPE,
356: END_DATE okc_k_lines_b.end_date%TYPE,
357: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
358: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
359: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,

Line 356: END_DATE okc_k_lines_b.end_date%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,
355: START_DATE okc_k_lines_b.start_date%TYPE,
356: END_DATE okc_k_lines_b.end_date%TYPE,
357: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
358: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
359: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
360: TERMINATION_REASON fnd_lookups.meaning%TYPE,

Line 357: LINE_NUMBER okc_k_lines_b.line_number%TYPE,

353: STS_CODE okc_k_lines_b.sts_code%TYPE,
354: DATE_TERMINATED okc_k_lines_b.date_terminated%TYPE,
355: START_DATE okc_k_lines_b.start_date%TYPE,
356: END_DATE okc_k_lines_b.end_date%TYPE,
357: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
358: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
359: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
360: TERMINATION_REASON fnd_lookups.meaning%TYPE,
361: CODE okc_statuses_b.code%TYPE,

Line 358: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,

354: DATE_TERMINATED okc_k_lines_b.date_terminated%TYPE,
355: START_DATE okc_k_lines_b.start_date%TYPE,
356: END_DATE okc_k_lines_b.end_date%TYPE,
357: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
358: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
359: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
360: TERMINATION_REASON fnd_lookups.meaning%TYPE,
361: CODE okc_statuses_b.code%TYPE,
362: STE_CODE okc_statuses_b.ste_code%TYPE,

Line 359: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,

355: START_DATE okc_k_lines_b.start_date%TYPE,
356: END_DATE okc_k_lines_b.end_date%TYPE,
357: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
358: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
359: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
360: TERMINATION_REASON fnd_lookups.meaning%TYPE,
361: CODE okc_statuses_b.code%TYPE,
362: STE_CODE okc_statuses_b.ste_code%TYPE,
363: meaning okc_statuses_v.meaning%TYPE);

Line 428: FROM OKC_K_LINES_B line,

424: fnd.meaning TERMINATION_REASON,
425: status.CODE,
426: status.STE_CODE,
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

Line 460: FROM OKC_K_LINES_B LINE,

456: CHR.CONTRACT_NUMBER, CHR.CONTRACT_NUMBER_MODIFIER, LINE.ID,
457: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
458: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
459: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
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,

Line 493: FROM OKC_K_LINES_B LINE,

489: CHR.CONTRACT_NUMBER, CHR.CONTRACT_NUMBER_MODIFIER, LINE.ID,
490: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
491: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
492: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
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,

Line 522: FROM OKC_K_LINES_B LINE,

518: CHR.CONTRACT_NUMBER, CHR.CONTRACT_NUMBER_MODIFIER, LINE.ID,
519: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
520: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
521: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
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,

Line 563: FROM OKC_K_LINES_B line,

559: line.dnz_chr_id,
560: status.CODE,
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

Line 608: FROM OKC_K_LINES_B line,

604: line.dnz_chr_id,
605: stsb.CODE,
606: stsb.STE_CODE,
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

Line 655: FROM OKC_K_LINES_B line,

651: line.dnz_chr_id,
652: stsb.CODE,
653: stsb.STE_CODE,
654: stst.meaning
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

Line 698: FROM OKC_K_LINES_B line,

694: line.dnz_chr_id,
695: stsb.CODE,
696: stsb.STE_CODE,
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

Line 740: FROM OKC_K_LINES_B line,

736: line.dnz_chr_id,
737: status.CODE,
738: status.STE_CODE,
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

Line 784: FROM OKC_K_LINES_B line,

780: line.dnz_chr_id,
781: status.CODE,
782: status.STE_CODE,
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

Line 823: FROM OKC_K_LINES_B line,

819: line.dnz_chr_id,
820: status.CODE,
821: status.STE_CODE,
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

Line 858: FROM OKC_K_LINES_B line,

854: line.dnz_chr_id,
855: status.CODE,
856: status.STE_CODE,
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

Line 896: FROM OKC_K_LINES_B line,

892: line.dnz_chr_id,
893: status.CODE,
894: status.STE_CODE,
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

Line 935: FROM OKC_K_LINES_B line,

931: line.dnz_chr_id,
932: status.CODE,
933: status.STE_CODE,
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

Line 970: FROM OKC_K_LINES_B line,

966: line.dnz_chr_id,
967: status.CODE,
968: status.STE_CODE,
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

Line 1003: FROM OKC_K_LINES_B line,

999: fnd.meaning TERMINATION_REASON,
1000: status.CODE,
1001: status.STE_CODE,
1002: status.meaning
1003: FROM OKC_K_LINES_B line,
1004: OKC_STATUSES_V status,
1005: fnd_lookups fnd
1006: WHERE line.STS_CODE = status.CODE
1007: AND line.dnz_chr_id = p_kid

Line 1031: FROM OKC_K_LINES_B line,

1027: line.dnz_chr_id,
1028: status.CODE,
1029: status.STE_CODE,
1030: status.meaning
1031: FROM OKC_K_LINES_B line,
1032: OKC_STATUSES_V status
1033: WHERE line.STS_CODE = status.CODE
1034: AND line.dnz_chr_id = p_kid
1035: --BUG 4915692 --

Line 1063: FROM OKC_K_LINES_B line,

1059: line.dnz_chr_id,
1060: status.CODE,
1061: status.STE_CODE,
1062: status.meaning
1063: FROM OKC_K_LINES_B line,
1064: OKC_STATUSES_V status
1065: WHERE line.STS_CODE = status.CODE
1066: AND line.dnz_chr_id = p_kid
1067: AND status.ste_code = 'SIGNED'

Line 1088: FROM OKC_K_LINES_B line,

1084: line.dnz_chr_id,
1085: status.CODE,
1086: status.STE_CODE,
1087: status.meaning
1088: FROM OKC_K_LINES_B line,
1089: OKC_STATUSES_V status
1090: WHERE line.STS_CODE = status.CODE
1091: AND line.dnz_chr_id = p_kid
1092: AND status.ste_code = 'ACTIVE'