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.
60: htp.headOpen; 61: htp.title(wf_core.translate('WFA_LOGIN_REQUEST')); 62: wfa_html.create_help_function('wf/links/log.htm?LOGIN'); 63: htp.headClose; 64: wfa_sec.Header(background_only=>FALSE, inc_lov_applet=>FALSE); 65: 66: htp.p('
118: 119: htp.tableRowClose; 120: htp.tableClose; 121: 122: wfa_sec.Footer; 123: htp.htmlClose; 124: exception 125: when others then 126: rollback;
158: end if; 159: username := upper(user_id); 160: 161: begin 162: wfa_sec.CreateSession(username, password); 163: exception 164: when others then 165: if (wf_core.error_name='WFSEC_USER_PASSWORD') then 166: -- Bad username or password
371: oosid number; 372: begin 373: if (nkey is null) then 374: -- No nkey passed, means must be connected. Get current user. 375: Wfa_Sec.GetSession(username); 376: 377: -- Get recipient and original recipient of this notification 378: begin 379: select RECIPIENT_ROLE, ORIGINAL_RECIPIENT
633: ** session. 634: ** But first check to see if there is a current session 635: */ 636: begin 637: wfa_sec.validate_only := TRUE; 638: wfa_sec.GetSession(sess_username); 639: if (sess_username <> 'ANONYMOUS' and sess_username <> '-1' 640: and sess_username is not null) then 641: -- there is a valid session already, just use it
634: ** But first check to see if there is a current session 635: */ 636: begin 637: wfa_sec.validate_only := TRUE; 638: wfa_sec.GetSession(sess_username); 639: if (sess_username <> 'ANONYMOUS' and sess_username <> '-1' 640: and sess_username is not null) then 641: -- there is a valid session already, just use it 642: username := sess_username;
648: 649: -- create a pseudo session for user 650: owa_util.mime_header('text/html', FALSE); 651: owa_cookie.send('WF_SESSION', wfsession, '', '/'); 652: wfa_sec.PseudoSession(FALSE, username); 653: owa_util.http_header_close; 654: end if; 655: exception 656: when OTHERS then
657: -- this is the first attempt to see a detached notfication 658: wf_core.clear; 659: owa_util.mime_header('text/html', FALSE); 660: owa_cookie.send('WF_SESSION', wfsession, '', '/'); 661: wfa_sec.PseudoSession(FALSE, username); 662: owa_util.http_header_close; 663: end; 664: wfa_sec.validate_only := FALSE; 665:
660: owa_cookie.send('WF_SESSION', wfsession, '', '/'); 661: wfa_sec.PseudoSession(FALSE, username); 662: owa_util.http_header_close; 663: end; 664: wfa_sec.validate_only := FALSE; 665: 666: pseudo_login := TRUE; 667: end if; 668:
710: htp.p(''); 711: htp.p(''); 712: 713: if (nkey is null) then 714: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wfa_html.Find', 715: wf_core.translate('WFA_DTITLE_TBAR'), FALSE, pseudo_login); 716: else 717: -- disabled Find for detached notification 718: wfa_sec.Header(FALSE, null,
714: wfa_sec.Header(FALSE, owa_util.get_owa_service_path ||'wfa_html.Find', 715: wf_core.translate('WFA_DTITLE_TBAR'), FALSE, pseudo_login); 716: else 717: -- disabled Find for detached notification 718: wfa_sec.Header(FALSE, null, 719: wf_core.translate('WFA_DTITLE_TBAR'), FALSE, pseudo_login); 720: end if; 721: 722: htp.tableOpen(cattributes=>'WIDTH=100% summary=""', calign=>'CENTER');
930: end if; 931: 932: --Check the SOCKET_LISTENER_PORT profile option. 933: l_forms_port := 934: Wfa_Sec.Get_Profile_Value('SOCKET_LISTENER_PORT',username); 935: 936: htp.p('
1051: 1052: -- 1053: -- Page footer 1054: -- 1055: Wfa_Sec.Footer; 1056: htp.htmlClose; 1057: 1058: exception 1059: when others then
1159: -- if nkey is not null, it is from email, and we need to create a pseudo 1160: -- session for it. 1161: if (nkey is not null) then 1162: begin 1163: wfa_sec.validate_only := TRUE; 1164: wfa_sec.GetSession(sess_username); 1165: if (sess_username <> 'ANONYMOUS' and sess_username <> '-1' 1166: and sess_username is not null) then 1167: -- there is a valid session already, just use it
1160: -- session for it. 1161: if (nkey is not null) then 1162: begin 1163: wfa_sec.validate_only := TRUE; 1164: wfa_sec.GetSession(sess_username); 1165: if (sess_username <> 'ANONYMOUS' and sess_username <> '-1' 1166: and sess_username is not null) then 1167: -- there is a valid session already, just use it 1168: username := sess_username;
1173: end if; 1174: 1175: -- create a pseudo session for user 1176: owa_util.mime_header('text/html', FALSE); 1177: wfa_sec.PseudoSession(FALSE, username); 1178: end if; 1179: exception 1180: when OTHERS then 1181: -- this is the first attempt to see a detached notfication
1180: when OTHERS then 1181: -- this is the first attempt to see a detached notfication 1182: wf_core.clear; 1183: owa_util.mime_header('text/html', FALSE); 1184: wfa_sec.PseudoSession(FALSE, username); 1185: end; 1186: wfa_sec.validate_only := FALSE; 1187: end if; 1188:
1182: wf_core.clear; 1183: owa_util.mime_header('text/html', FALSE); 1184: wfa_sec.PseudoSession(FALSE, username); 1185: end; 1186: wfa_sec.validate_only := FALSE; 1187: end if; 1188: 1189: wfa_html_util.GetUrlCount(to_number(nid),urlcount,urlstring); 1190:
1225: 1226: -- 1227: -- Response body content 1228: -- 1229: wfa_sec.header(background_only=>TRUE); 1230: 1231: -- Add the Return to Worklist link before other attributes. 1232: -- We shows it regardless if we have open response or not. 1233: -- Fix bug #785206. We don't show the WorkList link if is coming from
1262: htp.p('
1293: htp.br; 1294: end if; 1295: 1296: if (respcnt >= 1) then 1297: Wfa_Sec.Footer; 1298: htp.htmlClose; 1299: return; 1300: end if; 1301: end if;
1318: 1319: end loop; 1320: 1321: htp.tableClose; 1322: Wfa_Sec.Footer; 1323: htp.htmlClose; 1324: 1325: return; 1326:
1571: htp.formClose; 1572: end if; 1573: 1574: -- Page footer 1575: Wfa_Sec.Footer; 1576: htp.htmlClose; 1577: 1578: exception 1579: when others then
1650: 1651: htp.headClose; 1652: 1653: -- Body contents 1654: wfa_sec.header(background_only=>TRUE); 1655: 1656: -- Open form and add hidden fields 1657: htp.formOpen(curl=>owa_util.get_owa_service_path||'wfa_html.SubmitForward', 1658: cmethod=>'Post', cattributes=>'NAME="WF_HTML"');
1754: 1755: htp.tableRowClose; 1756: htp.tableClose; 1757: 1758: wfa_sec.Footer; 1759: htp.htmlClose; 1760: exception 1761: when others then 1762: rollback;
1813: htp.title(wf_core.translate('WFA_ATTRINFO')||': '||dispname); 1814: htp.headClose; 1815: 1816: -- Body contents 1817: wfa_sec.header(background_only=>TRUE); 1818: -- Title 1819: htp.center(htf.bold(wf_core.translate('WFA_ATTRINFO')||' '||dispname)); 1820: htp.tableOpen(cattributes=>'summary=""'); 1821:
1868: end if; 1869: htp.tableRowClose; 1870: 1871: htp.tableClose; 1872: wfa_sec.Footer; 1873: htp.htmlClose; 1874: exception 1875: when others then 1876: rollback;
2178: result := result||'
2731: l_help_target := p_help_file; 2732: 2733: END IF; 2734: 2735: wfa_sec.create_help_syntax (l_help_target, l_lang); 2736: 2737: end if; 2738: 2739: exception
3053: 3054: BEGIN 3055: 3056: -- Authenticate user 3057: wfa_sec.GetSession(l_username); 3058: 3059: IF (p_titles_only = 'N') THEN 3060: 3061: SELECT COUNT(*)
3109: 3110: procedure logout is 3111: username varchar2(320); 3112: begin 3113: wfa_sec.GetSession(username); 3114: owa_util.mime_header('text/html', FALSE); 3115: owa_cookie.send('WDB_GATEWAY_LOGOUT','YES', '', '/'); 3116: owa_util.http_header_close; 3117: htp.htmlOpen;
3120: wfa_html.create_help_function('wf/links/web.htm?WEBHOME'); 3121: htp.headClose; 3122: 3123: -- Page header 3124: wfa_sec.Header(FALSE, '', wf_core.translate('WF_WORKFLOW_TITLE')|| 3125: ' - '|| wf_core.translate('WF_VERSION'), FALSE); 3126: 3127: htp.center(wf_core.translate('LOGOUT_MESSAGE') 3128: ||' '||htf.anchor(curl=>wfa_html.base_url||'/wfa_html.home',
3127: htp.center(wf_core.translate('LOGOUT_MESSAGE') 3128: ||' '||htf.anchor(curl=>wfa_html.base_url||'/wfa_html.home', 3129: ctext=>wf_core.translate('CLICK_HOME'))); 3130: 3131: wfa_sec.Footer; 3132: htp.htmlClose; 3133: exception 3134: when others then 3135: wf_core.context('Wfa_Html','logout');
3148: begin 3149: 3150: BEGIN 3151: -- Check session and current user 3152: wfa_sec.GetSession(username); 3153: username := upper(username); 3154: 3155: -- Validate the user 3156: if (username is null) then
3199: username varchar2(320); -- Username to query 3200: 3201: begin 3202: -- Check session and current user 3203: wfa_sec.GetSession(username); 3204: 3205: -- Set page title 3206: htp.htmlOpen; 3207: htp.headOpen;
3208: htp.title(wf_core.translate('WFA_HOMETITLE')); 3209: wfa_html.create_help_function('wf/links/web.htm?WEBHOME'); 3210: htp.headClose; 3211: -- Page header 3212: wfa_sec.Header(FALSE, '', wf_core.translate('WF_WORKFLOW_TITLE')|| 3213: ' - '|| wf_core.translate('WF_VERSION'), TRUE); 3214: wfa_sec.Footer; 3215: htp.htmlClose; 3216: end;
3210: htp.headClose; 3211: -- Page header 3212: wfa_sec.Header(FALSE, '', wf_core.translate('WF_WORKFLOW_TITLE')|| 3213: ' - '|| wf_core.translate('WF_VERSION'), TRUE); 3214: wfa_sec.Footer; 3215: htp.htmlClose; 3216: end; 3217: 3218:
3225: s0 varchar2(2000); 3226: close_anchor varchar2(40); 3227: begin 3228: -- Check session and current user 3229: wfa_sec.GetSession(username); 3230: username := upper(username); 3231: wf_directory.GetRoleInfo(username, realname, s0, s0, s0, s0); 3232: 3233: admin_mode := 'N';
3265: htp.p(''); 3266: htp.p(WF_CORE.Translate('WFA_NOSCRIPT')); 3267: htp.p(''); 3268: 3269: wfa_sec.Footer; 3270: htp.htmlClose; 3271: 3272: if (admin_mode = 'Y') then 3273: wfa_html.WorkList(user=>username,resetcookie=>1);
3295: wrklstbuf varchar2(2000); -- buffer to store worklist string 3296: begin 3297: 3298: -- Check session and current user 3299: wfa_sec.GetSession(username); 3300: username := upper(username); 3301: wf_directory.GetRoleInfo(username, realname, s0, s0, s0, s0); 3302: 3303: admin_mode := 'N';
3316: htp.headClose; 3317: 3318: if origin = 'FLOATING' then 3319: anchor_tag := ' 3322: anchor_tag := ' 3322: anchor_tag := ' 3730: htp.p(''); 3731: htp.title(wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT')); 3732: wfa_html.create_help_function('wfnew/wfnew52.htm#nrr'); 3733: htp.headClose; 3734: wfa_sec.Header(FALSE, '',wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT'), 3735: TRUE); 3736: htp.br; 3737: 3738: lobsize := dbms_lob.getlength(clob_loc); Line 3745: wfa_sec.Footer; 3741: while not (end_of_text) loop 3742: wf_notification.readattrclob(nid, aname, doctext, end_of_text); 3743: htp.prn(doctext); 3744: end loop; 3745: wfa_sec.Footer; 3746: htp.htmlClose; 3747: elsif attr_name is not null then 3748: -- BINARY Document 3749: if (l_encoding is not null) then Line 3810: wfa_sec.Header(FALSE, '',wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT'), 3806: htp.headOpen; 3807: htp.title(wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT')); 3808: wfa_html.create_help_function('wfnew/wfnew52.htm#nrr'); 3809: htp.headClose; 3810: wfa_sec.Header(FALSE, '',wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT'), 3811: TRUE); 3812: htp.br; 3813: 3814: htp.p (doctext); Line 3816: wfa_sec.Footer; 3812: htp.br; 3813: 3814: htp.p (doctext); 3815: 3816: wfa_sec.Footer; 3817: htp.htmlClose; 3818: end if; 3819: 3820: exception Line 4230: wfa_sec.Header(background_only=>TRUE); 4226: htp.title(wf_core.translate('LONG_DESC')); 4227: htp.headClose; 4228: 4229: begin 4230: wfa_sec.Header(background_only=>TRUE); 4231: exception 4232: when others then 4233: htp.bodyOpen; 4234: end; Line 4238: wfa_sec.Footer; 4234: end; 4235: 4236: htp.p(WF_CORE.Translate(UPPER(p_token))); 4237: 4238: wfa_sec.Footer; 4239: htp.htmlClose; 4240: 4241: END LongDesc; 4242:
3730: htp.p(''); 3731: htp.title(wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT')); 3732: wfa_html.create_help_function('wfnew/wfnew52.htm#nrr'); 3733: htp.headClose; 3734: wfa_sec.Header(FALSE, '',wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT'), 3735: TRUE); 3736: htp.br; 3737: 3738: lobsize := dbms_lob.getlength(clob_loc);
3741: while not (end_of_text) loop 3742: wf_notification.readattrclob(nid, aname, doctext, end_of_text); 3743: htp.prn(doctext); 3744: end loop; 3745: wfa_sec.Footer; 3746: htp.htmlClose; 3747: elsif attr_name is not null then 3748: -- BINARY Document 3749: if (l_encoding is not null) then
3806: htp.headOpen; 3807: htp.title(wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT')); 3808: wfa_html.create_help_function('wfnew/wfnew52.htm#nrr'); 3809: htp.headClose; 3810: wfa_sec.Header(FALSE, '',wf_core.translate('WFITD_ATTR_TYPE_DOCUMENT'), 3811: TRUE); 3812: htp.br; 3813: 3814: htp.p (doctext);
3812: htp.br; 3813: 3814: htp.p (doctext); 3815: 3816: wfa_sec.Footer; 3817: htp.htmlClose; 3818: end if; 3819: 3820: exception
4226: htp.title(wf_core.translate('LONG_DESC')); 4227: htp.headClose; 4228: 4229: begin 4230: wfa_sec.Header(background_only=>TRUE); 4231: exception 4232: when others then 4233: htp.bodyOpen; 4234: end;
4234: end; 4235: 4236: htp.p(WF_CORE.Translate(UPPER(p_token))); 4237: 4238: wfa_sec.Footer; 4239: htp.htmlClose; 4240: 4241: END LongDesc; 4242: