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_REPORT_PVT dependencies on OKC_REPORT_HTM

Line 622: okc_report_htm_v H

618: pp_scn_id number,
619: pp_xst_date date) is
620: select '!'
621: from
622: okc_report_htm_v H
623: where H.CHR_ID = pp_chr_id
624: and H.MAJOR_VERSION = pp_major_version
625: and H.MINOR_VERSION = pp_minor_version
626: and H.XST_ID = pp_xst_id

Line 639: okc_report_htm_v H

635: pp_scn_id number,
636: pp_xst_date date) is
637: select H.HTM_TEXT
638: from
639: okc_report_htm_v H
640: where H.CHR_ID = pp_chr_id
641: and H.MAJOR_VERSION = pp_major_version
642: and H.MINOR_VERSION = pp_minor_version
643: and H.XST_ID = pp_xst_id

Line 694: delete from okc_report_htm H

690: --
691: -- obsolete? - lock cache, update everything but clob
692: --
693: begin
694: delete from okc_report_htm H
695: where H.CHR_ID = G_kid
696: and H.MAJOR_VERSION = G_vid
697: and H.LANGUAGE = userenv('LANG')
698: and H.XST_ID = G_xid

Line 706: insert into okc_report_htm

702: end;
703: --
704: -- not found! - insert in cache and lock
705: --
706: insert into okc_report_htm
707: ( CHR_ID
708: ,MAJOR_VERSION
709: ,LANGUAGE
710: ,XST_ID

Line 734: from okc_report_htm

730: sysdate,
731: fnd_global.login_id
732: );
733: select HTM_TEXT into x_htm_text
734: from okc_report_htm
735: where CHR_ID = G_kid
736: and MAJOR_VERSION = G_vid
737: and LANGUAGE = userenv('LANG')
738: and XST_ID = G_xid

Line 2119: from okc_report_htm_v

2115: p_document in out NOCOPY CLOB) as
2116:
2117: cursor get_htm_text(pp_kid number, pp_vid number, pp_xid number) is
2118: select HTM_TEXT
2119: from okc_report_htm_v
2120: where CHR_ID = pp_kid
2121: and MAJOR_VERSION = pp_vid
2122: and XST_ID = pp_xid;
2123: c1 clob;