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 230: UPDATE OKC_K_LINES_B

226: BEGIN
227:
228: x_return_status := OKC_API.G_RET_STS_SUCCESS;
229: x_clev_rec := p_clev_rec;
230: UPDATE OKC_K_LINES_B
231: SET STS_CODE = p_clev_rec.sts_code,
232: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
233: PROGRAM_ID = NVL(decode(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),PROGRAM_ID),
234: REQUEST_ID = NVL(decode(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),REQUEST_ID),

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

Line 366: OBJECT_VERSION_NUMBER okc_k_lines_b.object_version_number%TYPE,

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

Line 367: STS_CODE okc_k_lines_b.sts_code%TYPE,

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,
369: START_DATE okc_k_lines_b.start_date%TYPE,
370: END_DATE okc_k_lines_b.end_date%TYPE,
371: LINE_NUMBER okc_k_lines_b.line_number%TYPE,

Line 368: DATE_TERMINATED okc_k_lines_b.date_terminated%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,
369: START_DATE okc_k_lines_b.start_date%TYPE,
370: END_DATE okc_k_lines_b.end_date%TYPE,
371: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
372: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,

Line 369: START_DATE okc_k_lines_b.start_date%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,
369: START_DATE okc_k_lines_b.start_date%TYPE,
370: END_DATE okc_k_lines_b.end_date%TYPE,
371: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
372: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
373: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,

Line 370: END_DATE okc_k_lines_b.end_date%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,
369: START_DATE okc_k_lines_b.start_date%TYPE,
370: END_DATE okc_k_lines_b.end_date%TYPE,
371: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
372: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
373: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
374: TERMINATION_REASON fnd_lookups.meaning%TYPE,

Line 371: LINE_NUMBER okc_k_lines_b.line_number%TYPE,

367: STS_CODE okc_k_lines_b.sts_code%TYPE,
368: DATE_TERMINATED okc_k_lines_b.date_terminated%TYPE,
369: START_DATE okc_k_lines_b.start_date%TYPE,
370: END_DATE okc_k_lines_b.end_date%TYPE,
371: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
372: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
373: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
374: TERMINATION_REASON fnd_lookups.meaning%TYPE,
375: CODE okc_statuses_b.code%TYPE,

Line 372: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,

368: DATE_TERMINATED okc_k_lines_b.date_terminated%TYPE,
369: START_DATE okc_k_lines_b.start_date%TYPE,
370: END_DATE okc_k_lines_b.end_date%TYPE,
371: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
372: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
373: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
374: TERMINATION_REASON fnd_lookups.meaning%TYPE,
375: CODE okc_statuses_b.code%TYPE,
376: STE_CODE okc_statuses_b.ste_code%TYPE,

Line 373: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,

369: START_DATE okc_k_lines_b.start_date%TYPE,
370: END_DATE okc_k_lines_b.end_date%TYPE,
371: LINE_NUMBER okc_k_lines_b.line_number%TYPE,
372: PRICE_NEGOTIATED okc_k_lines_b.price_negotiated%TYPE,
373: dnz_chr_id okc_k_lines_b.dnz_chr_id%TYPE,
374: TERMINATION_REASON fnd_lookups.meaning%TYPE,
375: CODE okc_statuses_b.code%TYPE,
376: STE_CODE okc_statuses_b.ste_code%TYPE,
377: meaning okc_statuses_v.meaning%TYPE);

Line 442: FROM OKC_K_LINES_B line,

438: fnd.meaning TERMINATION_REASON,
439: status.CODE,
440: status.STE_CODE,
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

Line 474: FROM OKC_K_LINES_B LINE,

470: CHR.CONTRACT_NUMBER, CHR.CONTRACT_NUMBER_MODIFIER, LINE.ID,
471: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
472: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
473: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
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,

Line 509: FROM OKC_K_LINES_B LINE,

505: CHR.CONTRACT_NUMBER, CHR.CONTRACT_NUMBER_MODIFIER, LINE.ID,
506: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
507: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
508: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
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,

Line 540: FROM OKC_K_LINES_B LINE,

536: CHR.CONTRACT_NUMBER, CHR.CONTRACT_NUMBER_MODIFIER, LINE.ID,
537: LINE.OBJECT_VERSION_NUMBER, LINE.STS_CODE, LINE.DATE_TERMINATED, LINE.START_DATE,
538: LINE.END_DATE, LINE.LINE_NUMBER, LINE.PRICE_NEGOTIATED, LINE.DNZ_CHR_ID,
539: FND.MEANING TERMINATION_REASON, STSB.CODE, STSB.STE_CODE, STST.MEANING
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,

Line 583: FROM OKC_K_LINES_B line,

579: line.dnz_chr_id,
580: status.CODE,
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

Line 628: FROM OKC_K_LINES_B line,

624: line.dnz_chr_id,
625: stsb.CODE,
626: stsb.STE_CODE,
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

Line 660: SELECT /+ leading(stsb, stst, line) index(line okc_k_lines_b_n12) / ---Modified hint for bug 12976183

656:
657:
658: -- When only Category is provided
659: CURSOR c_expr_line_all_category IS
660: SELECT /*+ leading(stsb, stst, line) index(line okc_k_lines_b_n12) */ ---Modified hint for bug 12976183
661: chr.contract_number,
662: chr.contract_number_modifier,
663: line.ID ,
664: line.OBJECT_VERSION_NUMBER,

Line 675: FROM OKC_K_LINES_B line,

671: line.dnz_chr_id,
672: stsb.CODE,
673: stsb.STE_CODE,
674: stst.meaning
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

Line 718: FROM OKC_K_LINES_B line,

714: line.dnz_chr_id,
715: stsb.CODE,
716: stsb.STE_CODE,
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

Line 760: FROM OKC_K_LINES_B line,

756: line.dnz_chr_id,
757: status.CODE,
758: status.STE_CODE,
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

Line 804: FROM OKC_K_LINES_B line,

800: line.dnz_chr_id,
801: status.CODE,
802: status.STE_CODE,
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

Line 828: SELECT /+leading(status, line) index(line okc_k_lines_b_n11) / ---Modified hint for bug 12976183

824: or line.date_terminated >= trunc(sysdate));
825:
826: -- When only Category is provided
827: CURSOR c_actv_line_all_category IS
828: SELECT /*+leading(status, line) index(line okc_k_lines_b_n11) */ ---Modified hint for bug 12976183
829: chr.contract_number,
830: chr.contract_number_modifier,
831: line.ID ,
832: line.OBJECT_VERSION_NUMBER,

Line 843: FROM OKC_K_LINES_B line,

839: line.dnz_chr_id,
840: status.CODE,
841: status.STE_CODE,
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

Line 878: FROM OKC_K_LINES_B line,

874: line.dnz_chr_id,
875: status.CODE,
876: status.STE_CODE,
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

Line 916: FROM OKC_K_LINES_B line,

912: line.dnz_chr_id,
913: status.CODE,
914: status.STE_CODE,
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

Line 955: FROM OKC_K_LINES_B line,

951: line.dnz_chr_id,
952: status.CODE,
953: status.STE_CODE,
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

Line 990: FROM OKC_K_LINES_B line,

986: line.dnz_chr_id,
987: status.CODE,
988: status.STE_CODE,
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

Line 1023: FROM OKC_K_LINES_B line,

1019: fnd.meaning TERMINATION_REASON,
1020: status.CODE,
1021: status.STE_CODE,
1022: status.meaning
1023: FROM OKC_K_LINES_B line,
1024: OKC_STATUSES_V status,
1025: fnd_lookups fnd
1026: WHERE line.STS_CODE = status.CODE
1027: AND line.dnz_chr_id = p_kid

Line 1051: FROM OKC_K_LINES_B line,

1047: line.dnz_chr_id,
1048: status.CODE,
1049: status.STE_CODE,
1050: status.meaning
1051: FROM OKC_K_LINES_B line,
1052: OKC_STATUSES_V status
1053: WHERE line.STS_CODE = status.CODE
1054: AND line.dnz_chr_id = p_kid
1055: --BUG 4915692 --

Line 1083: FROM OKC_K_LINES_B line,

1079: line.dnz_chr_id,
1080: status.CODE,
1081: status.STE_CODE,
1082: status.meaning
1083: FROM OKC_K_LINES_B line,
1084: OKC_STATUSES_V status
1085: WHERE line.STS_CODE = status.CODE
1086: AND line.dnz_chr_id = p_kid
1087: AND status.ste_code = 'SIGNED'

Line 1108: FROM OKC_K_LINES_B line,

1104: line.dnz_chr_id,
1105: status.CODE,
1106: status.STE_CODE,
1107: status.meaning
1108: FROM OKC_K_LINES_B line,
1109: OKC_STATUSES_V status
1110: WHERE line.STS_CODE = status.CODE
1111: AND line.dnz_chr_id = p_kid
1112: AND status.ste_code = 'ACTIVE'