248: when others then
249: -- If AccessKeyCheck will return "ERROR" directly if failed
250: if (not(AccessKeyCheck(x_item_type, x_item_key, x_admin_mode,
251: x_access_key))) then
252: htp.p(wf_core.translate('WRONG_ACCESS_KEY'));
253: return;
254: else
255: dbms_session.set_nls('NLS_LANGUAGE', ''''||x_nls_lang||'''');
256: pseudo_login := TRUE;
280: wf_core.Token('TYPE', x_item_type);
281: wf_core.Token('KEY', x_item_key);
282: wf_core.Raise('WFENG_ITEM');
283: when OTHERS then
284: htp.p(sqlerrm);
285: return;
286: end;
287:
288: lang_codeset := substr(userenv('LANGUAGE'),instr(userenv('LANGUAGE'),'.')+1,
295: where name = x_item_type;
296:
297: exception
298: when OTHERS then
299: htp.p(sqlerrm);
300: return;
301: end;
302:
303: -- Otherwise, we can continue our work here
301: end;
302:
303: -- Otherwise, we can continue our work here
304: -- Generate the html page
305: htp.p('');
306: if (admin_privilege) then
307: htp.p('
303: -- Otherwise, we can continue our work here
304: -- Generate the html page
305: htp.p('');
306: if (admin_privilege) then
307: htp.p('
309: else
310: htp.p('
306: if (admin_privilege) then
307: htp.p('
310: htp.p('
329: l_wf_plugin_version := Wf_Core.translate('WF_PLUGIN_VERSION');
330: l_wf_classid := Wf_Core.translate('WF_CLASSID');
331: l_ie_plugin_ver := replace(Wf_Core.translate('WF_PLUGIN_VERSION'), '.', ',');
332:
333: htp.p('334: 'WIDTH=100% HEIGHT=90% '||
335: 'CODEBASE="'||l_wf_plugin_download||
336: '#Version='||l_ie_plugin_ver||'">'||
337: ''||
346: '' ||
349: '');
350: htp.p('
354: ' jinit_appletcache="off"'||
355: ' java_CODE="'||l_code||'"'||
356: ' java_CODEBASE="'||l_java_loc||'"'||
357: ' java_ARCHIVE="'||l_archive||'"');
358: htp.p(' itemtype="'||x_item_type||'"' ||
359: ' itemkey="'||x_item_key||'"' ||
360: ' langcodeset="'||lang_codeset||'"' ||
361: ' accesskey="'||x_access_key||'"' ||
362: ' admin="'||l_admin||'"' ||
364: ' installType="' || l_installType || '">'||
365: '
366: else
367: -- Client is not Windows, so we don't want to call Jinitiator.
368: htp.p('369:
370: l_archive := '/OA_JAVA/oracle/apps/fnd/jar/wfmon.jar, ' ||
371: '/OA_JAVA/oracle/apps/fnd/jar/fndewt.jar, ' ||
372: '/OA_JAVA/oracle/apps/fnd/jar/fndswing.jar, ' ||
372: '/OA_JAVA/oracle/apps/fnd/jar/fndswing.jar, ' ||
373: '/OA_JAVA/oracle/apps/fnd/jar/fndbalishare.jar, ' ||
374: '/OA_JAVA/oracle/apps/fnd/jar/fndctx.jar';
375:
376: htp.p(' archive="' || l_archive || '"');
377:
378: htp.p(' width=100% height=90%>');
379: htp.p('');
380: htp.p('');
374: '/OA_JAVA/oracle/apps/fnd/jar/fndctx.jar';
375:
376: htp.p(' archive="' || l_archive || '"');
377:
378: htp.p(' width=100% height=90%>');
379: htp.p('');
380: htp.p('');
381: htp.p('');
382: htp.p('');
375:
376: htp.p(' archive="' || l_archive || '"');
377:
378: htp.p(' width=100% height=90%>');
379: htp.p('');
380: htp.p('');
381: htp.p('');
382: htp.p('');
383: htp.p('');
376: htp.p(' archive="' || l_archive || '"');
377:
378: htp.p(' width=100% height=90%>');
379: htp.p('');
380: htp.p('');
381: htp.p('');
382: htp.p('');
383: htp.p('');
384: htp.p('');
377:
378: htp.p(' width=100% height=90%>');
379: htp.p('');
380: htp.p('');
381: htp.p('');
382: htp.p('');
383: htp.p('');
384: htp.p('');
385: htp.p('');
378: htp.p(' width=100% height=90%>');
379: htp.p('');
380: htp.p('');
381: htp.p('');
382: htp.p('');
383: htp.p('');
384: htp.p('');
385: htp.p('');
386:
379: htp.p('');
380: htp.p('');
381: htp.p('');
382: htp.p('');
383: htp.p('');
384: htp.p('');
385: htp.p('');
386:
387: end if;
380: htp.p('');
381: htp.p('');
382: htp.p('');
383: htp.p('');
384: htp.p('');
385: htp.p('');
386:
387: end if;
388:
381: htp.p('');
382: htp.p('');
383: htp.p('');
384: htp.p('');
385: htp.p('');
386:
387: end if;
388:
389: else
387: end if;
388:
389: else
390:
391: htp.p('392:
393: -- ### We should have this be under fnd/jar after 2.6
394: -- htp.p(' archive="/OA_JAVA/oracle/apps/fnd/wf/jar/wfmon.jar, /OA_JAVA/oracle/apps/fnd/wf/jar/fndewt.jar, /OA_JAVA/oracle/apps/fnd/wf/jar/fndswing.jar, /OA_JAVA/oracle/apps/fnd/wf/jar/fndbalishare.jar"');
395:
390:
391: htp.p('
393: -- ### We should have this be under fnd/jar after 2.6
394: -- htp.p(' archive="/OA_JAVA/oracle/apps/fnd/wf/jar/wfmon.jar, /OA_JAVA/oracle/apps/fnd/wf/jar/fndewt.jar, /OA_JAVA/oracle/apps/fnd/wf/jar/fndswing.jar, /OA_JAVA/oracle/apps/fnd/wf/jar/fndbalishare.jar"');
395:
396: -- Path for 9i, OA_JAVA sets to ORACLE_HOME/jlib, where all needed jar file locates
397: htp.p(' archive="/OA_JAVA/wfmon.jar, /OA_JAVA/ewt3.jar, /OA_JAVA/ewt3-nls.jar, /OA_JAVA/swingall-1_1_1.jar, /OA_JAVA/share.jar, /OA_JAVA/fndctx.jar"');
398:
399: htp.p(' width=100% height=90%>');
400: htp.p('');
401: htp.p('');
395:
396: -- Path for 9i, OA_JAVA sets to ORACLE_HOME/jlib, where all needed jar file locates
397: htp.p(' archive="/OA_JAVA/wfmon.jar, /OA_JAVA/ewt3.jar, /OA_JAVA/ewt3-nls.jar, /OA_JAVA/swingall-1_1_1.jar, /OA_JAVA/share.jar, /OA_JAVA/fndctx.jar"');
398:
399: htp.p(' width=100% height=90%>');
400: htp.p('');
401: htp.p('');
402: htp.p('');
403: htp.p('');
396: -- Path for 9i, OA_JAVA sets to ORACLE_HOME/jlib, where all needed jar file locates
397: htp.p(' archive="/OA_JAVA/wfmon.jar, /OA_JAVA/ewt3.jar, /OA_JAVA/ewt3-nls.jar, /OA_JAVA/swingall-1_1_1.jar, /OA_JAVA/share.jar, /OA_JAVA/fndctx.jar"');
398:
399: htp.p(' width=100% height=90%>');
400: htp.p('');
401: htp.p('');
402: htp.p('');
403: htp.p('');
404: htp.p('');
397: htp.p(' archive="/OA_JAVA/wfmon.jar, /OA_JAVA/ewt3.jar, /OA_JAVA/ewt3-nls.jar, /OA_JAVA/swingall-1_1_1.jar, /OA_JAVA/share.jar, /OA_JAVA/fndctx.jar"');
398:
399: htp.p(' width=100% height=90%>');
400: htp.p('');
401: htp.p('');
402: htp.p('');
403: htp.p('');
404: htp.p('');
405: htp.p('');
398:
399: htp.p(' width=100% height=90%>');
400: htp.p('');
401: htp.p('');
402: htp.p('');
403: htp.p('');
404: htp.p('');
405: htp.p('');
406: htp.p('');
399: htp.p(' width=100% height=90%>');
400: htp.p('');
401: htp.p('');
402: htp.p('');
403: htp.p('');
404: htp.p('');
405: htp.p('');
406: htp.p('');
407: end if;
400: htp.p('');
401: htp.p('');
402: htp.p('');
403: htp.p('');
404: htp.p('');
405: htp.p('');
406: htp.p('');
407: end if;
408:
401: htp.p('');
402: htp.p('');
403: htp.p('');
404: htp.p('');
405: htp.p('');
406: htp.p('');
407: end if;
408:
409: htp.p('');
402: htp.p('');
403: htp.p('');
404: htp.p('');
405: htp.p('');
406: htp.p('');
407: end if;
408:
409: htp.p('');
410:
405: htp.p('');
406: htp.p('');
407: end if;
408:
409: htp.p('');
410:
411: exception
412: when others then
413: Error;
552: appendData('ERROR:' || 'Internal Error in GetRootProcess');
553: return;
554: end if;
555:
556: -- The htp.p proc does not handle returns well, replace them
557: -- with the value
558: -- tokenized_mesg := substr((replace (rc.error_message, wf_core.newline, return_token)), 1, 220);
559: tokenized_mesg := replace (rc.error_message, wf_core.newline,
560: return_token);
868: loop
869: fetch proc_info into prc;
870: exit when proc_info%notfound;
871:
872: -- The htp.p proc does not handle returns well, replace them
873: -- with the value
874: -- tokenized_mesg := substr((replace (prc.error_message, wf_core.newline, return_token)), 1, 220);
875: tokenized_mesg := replace (prc.error_message, wf_core.newline,
876: return_token);
1784: begin
1785:
1786: -- Security check
1787: if (x_access_key <> GetAccessKey(x_item_type, x_item_key, 'Y')) then
1788: htp.p('ENG_API_ACCESS_DENIED:');
1789: end if;
1790:
1791: begin
1792: -- Validate the session that comes from monitor
1817: elsif (api_name = 'SetItemAttrText') then
1818: Wf_Engine.SetItemAttrText(x_item_type, x_item_key, third_arg, forth_arg);
1819: end if;
1820:
1821: htp.p('ENG_API_SUCC:');
1822: return;
1823:
1824: exception
1825: when others then
1912: IF (NVL(x_cur_sort_column, 'UNSET') = x_sort_column AND
1913: NVL(x_cur_sort_order, 'ASC') = 'ASC' AND
1914: x_advanced IN ('FIRST', 'TRUE')) THEN
1915:
1916: htp.tableHeader(
1917: cvalue=>'
2200: htp.tableData(itemkey, 'Left', cattributes=>'id=""');
2201: if (userkey is not null) then
2202: htp.tableData(userkey, 'Left',cattributes=>'id=""');
2195: is
2196: begin
2197:
2198: htp.tableRowOpen(calign=>'middle');
2199: htp.tableData(itemtype, 'Left', cattributes=>'id=""');
2200: htp.tableData(itemkey, 'Left', cattributes=>'id=""');
2201: if (userkey is not null) then
2202: htp.tableData(userkey, 'Left',cattributes=>'id=""');
2203: else
2196: begin
2197:
2198: htp.tableRowOpen(calign=>'middle');
2199: htp.tableData(itemtype, 'Left', cattributes=>'id=""');
2200: htp.tableData(itemkey, 'Left', cattributes=>'id=""');
2201: if (userkey is not null) then
2202: htp.tableData(userkey, 'Left',cattributes=>'id=""');
2203: else
2204: htp.tableData(htf.br,cattributes=>'id=""');
2198: htp.tableRowOpen(calign=>'middle');
2199: htp.tableData(itemtype, 'Left', cattributes=>'id=""');
2200: htp.tableData(itemkey, 'Left', cattributes=>'id=""');
2201: if (userkey is not null) then
2202: htp.tableData(userkey, 'Left',cattributes=>'id=""');
2203: else
2204: htp.tableData(htf.br,cattributes=>'id=""');
2205: end if;
2206:
2200: htp.tableData(itemkey, 'Left', cattributes=>'id=""');
2201: if (userkey is not null) then
2202: htp.tableData(userkey, 'Left',cattributes=>'id=""');
2203: else
2204: htp.tableData(htf.br,cattributes=>'id=""');
2205: end if;
2206:
2207: if (url is not null) then
2208: htp.tableData(htf.anchor2(curl=>url, ctext=>process, ctarget=>'_top'),
2204: htp.tableData(htf.br,cattributes=>'id=""');
2205: end if;
2206:
2207: if (url is not null) then
2208: htp.tableData(htf.anchor2(curl=>url, ctext=>process, ctarget=>'_top'),
2209: 'Left',
2210: cattributes=>'id=""');
2211: else
2212: htp.tableData(process, 'Left', cattributes=>'id=""');
2208: htp.tableData(htf.anchor2(curl=>url, ctext=>process, ctarget=>'_top'),
2209: 'Left',
2210: cattributes=>'id=""');
2211: else
2212: htp.tableData(process, 'Left', cattributes=>'id=""');
2213: end if;
2214:
2215: -- Active/Complete icon
2216: if (active) then
2213: end if;
2214:
2215: -- Active/Complete icon
2216: if (active) then
2217: htp.tableData(htf.br,cattributes=>'id=""');
2218: else
2219: htp.tableData(cvalue=>htf.img(curl=>wfa_html.image_loc||'FNDIDONE.gif',
2220: calt=>wf_core.translate('COMPLETE'),
2221: cattributes=>'border=no height=26'),
2215: -- Active/Complete icon
2216: if (active) then
2217: htp.tableData(htf.br,cattributes=>'id=""');
2218: else
2219: htp.tableData(cvalue=>htf.img(curl=>wfa_html.image_loc||'FNDIDONE.gif',
2220: calt=>wf_core.translate('COMPLETE'),
2221: cattributes=>'border=no height=26'),
2222: calign=>'center',
2223: cattributes=>'id=""');
2224: end if;
2225:
2226: -- Error icon if error
2227: if (error) then
2228: htp.tableData(cvalue=>htf.img(curl=>wfa_html.image_loc||'FNDIREDL.gif',
2229: calt=>wf_core.translate('IN_ERROR'),
2230: cattributes=>'border=no height=26'),
2231: calign=>'center',
2232: cattributes=>'id=""');
2230: cattributes=>'border=no height=26'),
2231: calign=>'center',
2232: cattributes=>'id=""');
2233: else
2234: htp.tableData(htf.br,cattributes=>'id=""');
2235: end if;
2236:
2237: -- Suspend icon if suspended
2238: if (suspend) then
2235: end if;
2236:
2237: -- Suspend icon if suspended
2238: if (suspend) then
2239: htp.tableData(cvalue=>htf.img(curl=>wfa_html.image_loc||'FNDIYLWL.gif',
2240: calt=>wf_core.translate('SUSPEND'),
2241: cattributes=>'border=no height=26'),
2242: calign=>'center', cattributes=>'id=""');
2243: else
2240: calt=>wf_core.translate('SUSPEND'),
2241: cattributes=>'border=no height=26'),
2242: calign=>'center', cattributes=>'id=""');
2243: else
2244: htp.tableData(htf.br,cattributes=>'id=""');
2245: end if;
2246:
2247: htp.tableData(startdate, 'Left', cattributes=>'id=""');
2248: htp.tableRowClose;
2243: else
2244: htp.tableData(htf.br,cattributes=>'id=""');
2245: end if;
2246:
2247: htp.tableData(startdate, 'Left', cattributes=>'id=""');
2248: htp.tableRowClose;
2249:
2250: exception
2251: when others then
2244: htp.tableData(htf.br,cattributes=>'id=""');
2245: end if;
2246:
2247: htp.tableData(startdate, 'Left', cattributes=>'id=""');
2248: htp.tableRowClose;
2249:
2250: exception
2251: when others then
2252: Wf_Core.Context('Wf_Monitor', 'TableRow', itemtype, itemkey, process,
2366: wfa_html.validate_display_name (x_display_process_owner, l_process_owner);
2367: wfa_html.validate_display_name (x_display_person, l_person);
2368:
2369: -- Window title
2370: htp.htmlOpen;
2371: htp.headOpen;
2372: htp.title(wf_core.translate('WFMON_LISTTITLE'));
2373: wfa_html.create_help_function('wf/links/pro.htm?PROLIST');
2374: htp.headClose;
2367: wfa_html.validate_display_name (x_display_person, l_person);
2368:
2369: -- Window title
2370: htp.htmlOpen;
2371: htp.headOpen;
2372: htp.title(wf_core.translate('WFMON_LISTTITLE'));
2373: wfa_html.create_help_function('wf/links/pro.htm?PROLIST');
2374: htp.headClose;
2375:
2368:
2369: -- Window title
2370: htp.htmlOpen;
2371: htp.headOpen;
2372: htp.title(wf_core.translate('WFMON_LISTTITLE'));
2373: wfa_html.create_help_function('wf/links/pro.htm?PROLIST');
2374: htp.headClose;
2375:
2376: -- Open body and draw standard header
2370: htp.htmlOpen;
2371: htp.headOpen;
2372: htp.title(wf_core.translate('WFMON_LISTTITLE'));
2373: wfa_html.create_help_function('wf/links/pro.htm?PROLIST');
2374: htp.headClose;
2375:
2376: -- Open body and draw standard header
2377: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top',
2378: wf_core.translate('WFMON_LISTTITLE'), TRUE);
2376: -- Open body and draw standard header
2377: wfa_sec.header(FALSE, 'wf_monitor.find_instance" TARGET="_top',
2378: wf_core.translate('WFMON_LISTTITLE'), TRUE);
2379:
2380: htp.tableOpen(cattributes=>'border=1 cellpadding=3 bgcolor=WHITE
2381: width=100% summary=""');
2382:
2383: showColumnHeaders;
2384:
2426: to_char(proc.begin_date) || ' '
2427: || to_char(proc.begin_date, 'HH24:MI:SS'));
2428: end loop;
2429:
2430: htp.tableClose;
2431:
2432:
2433: wfa_sec.footer;
2434: htp.htmlClose;
2430: htp.tableClose;
2431:
2432:
2433: wfa_sec.footer;
2434: htp.htmlClose;
2435: exception
2436: when others then
2437: Wf_Core.Context('Wf_Monitor', 'Instance_List', x_active, x_itemtype,
2438: x_ident, x_process, x_status);
3221: ** Create the envelope form. The envelope form is under the advanced_controls
3222: ** form and is implemented as a separate form so that you can have the
3223: ** diffent submit controls for View Monitor vs. Show Activities.
3224: */
3225: htp.p('
3227: /*
3228: ** Open the main table for the list of activities
3229: */
3226:
3227: /*
3228: ** Open the main table for the list of activities
3229: */
3230: htp.tableOpen(calign=>'CENTER', cattributes=>'border=1 cellpadding=3 bgcolor=WHITE width=100% summary=""');
3231:
3232: /*
3233: ** Show the Envelope column headers. All the parameters being passed
3234: ** around is required so that I can create soft links that cause the
3548: ** create the row on the html page.
3549: */
3550: IF (x_valid_status = TRUE AND x_show_activity = TRUE) THEN
3551:
3552: htp.tableRowOpen(calign=>'middle');
3553:
3554: /*
3555: ** If you are viewing the standard activity listing with the
3556: ** with the notifications with responses then use the DONE column
3579:
3580: END LOOP;
3581:
3582: if (x_icon_name = 'FNDIACTV.gif') then
3583: htp.tableData(
3584: htf.img(wfa_html.image_loc||x_icon_name, 'absmiddle',
3585: wf_core.translate('ACTIVE'),
3586: null, 'height=26')||
3587: ' '||
3587: ' '||
3588: x_activity_record.activity_status_display,
3589: cattributes=>'id=""');
3590: elsif (x_icon_name = 'FNDIDONE.gif') then
3591: htp.tableData(
3592: htf.img(wfa_html.image_loc||x_icon_name, 'absmiddle',
3593: wf_core.translate('COMPLETE'),
3594: null, 'height=26')||
3595: ' '||
3595: ' '||
3596: x_activity_record.activity_status_display,
3597: cattributes=>'id=""');
3598: elsif (x_icon_name = 'FNDIREDL.gif') then
3599: htp.tableData(
3600: htf.img(wfa_html.image_loc||x_icon_name, 'absmiddle',
3601: wf_core.translate('ERROR'),
3602: null, 'height=26')||
3603: ' '||
3603: ' '||
3604: x_activity_record.activity_status_display,
3605: cattributes=>'id=""');
3606: else
3607: htp.tableData(
3608: htf.img(wfa_html.image_loc||x_icon_name, 'absmiddle',
3609: wf_core.translate('SUSPEND'),
3610: null, 'height=26')||
3611: ' '||
3625: IF (x_activity_record.activity_status = 'COMPLETE' OR
3626: NVL(x_activity_record.notification_status, 'OPEN') =
3627: 'CLOSED') THEN
3628:
3629: htp.tableData(
3630: htf.img(wfa_html.image_loc||'chckmark.gif', 'absmiddle',
3631: wf_core.translate('COMPLETE'), null, 'height=26'),
3632: cattributes=>'id=""');
3633:
3632: cattributes=>'id=""');
3633:
3634: ELSE
3635:
3636: htp.tableData(htf.br,cattributes=>'id=""');
3637:
3638: END IF;
3639:
3640: END IF;
3699: ** to. If it is any other type of activity then the WHO column is
3700: ** set to Workflow engine.
3701: */
3702: if (mlrurl is not null) then
3703: htp.tableData(htf.anchor2(mlrurl, role_name, 'anchor_text', '_top'),
3704: 'Left',cattributes=>'id=""');
3705: else
3706: htp.tableData(x_font_color||role_name||x_font_color_end, 'Left',
3707: cattributes=>'id=""');
3702: if (mlrurl is not null) then
3703: htp.tableData(htf.anchor2(mlrurl, role_name, 'anchor_text', '_top'),
3704: 'Left',cattributes=>'id=""');
3705: else
3706: htp.tableData(x_font_color||role_name||x_font_color_end, 'Left',
3707: cattributes=>'id=""');
3708: end if;
3709:
3710: /*
3714: */
3735: calign=>'Left', cattributes=>'id=""');
3764: end if;
3794:
3860:
3891: */
3908: '
3915: ELSE
3919: htp.tableData(x_font_color||x_activity_record.result||x_font_color_end, 'Left',cattributes=>'id=""');
3927: END IF;
3931: htp.tableData(htf.br,cattributes=>'id=""');
3939: end loop;
3941: CLOSE x_activity_cursor;
3942:
3943: htp.tableClose;
3944:
3945: htp.p(htf.formHidden('x_item_type', x_item_type));
3947: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3949: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3952:
3715: IF (x_activity_record.parent_activity_name <> 'ROOT' AND
3716: x_advanced IN ('FIRST','TRUE')and not (pseudo_login)) THEN
3717:
3718: htp.tableData(
3719: cvalue=>'
3736:
3737: ELSIF (x_advanced in ('FIRST', 'TRUE')) THEN
3738:
3739: htp.tableData('
', 'Left',cattributes=>'id=""');
3740:
3741: END IF;
3742:
3743: /*
Line 3768: htp.tableData(
3765: close attrs;
3766: end if;
3767:
3768: htp.tableData(
3769: cvalue=>'
3786:
3787: ELSE
3788:
3789: htp.tableData(x_font_color||
3790: x_activity_record.activity_display_name||
3791: x_font_color_end, 'Left',cattributes=>'id=""');
3792:
3793: END IF;
Line 3798: htp.tableData(x_font_color||x_activity_record.begin_date_time||x_font_color_end, 'Left',cattributes=>'id=""');
3795: /*
3796: ** Show the begin date column
3797: */
3798: htp.tableData(x_font_color||x_activity_record.begin_date_time||x_font_color_end, 'Left',cattributes=>'id=""');
3799:
3800: /*
3801: ** The x_activity_record.duration is based on the difference between
3802: ** the activity end_date or sysdate if the end_date is null minus the
Line 3864: htp.tableData(x_font_color||x_duration_str||x_font_color_end,
3861: /*
3862: ** Show the duration string that we just constructed
3863: */
3864: htp.tableData(x_font_color||x_duration_str||x_font_color_end,
3865: 'Left',cattributes=>'id=""');
3866:
3867: /*
3868: ** Show the result column value if the activity is completed or has
Line 3895: htp.tableData(
3892: IF (x_activity_record.activity_status = 'ERROR') THEN
3893:
3894: IF NOT (pseudo_login) then
3895: htp.tableData(
3896: cvalue=>'
3909: calign=>'Left',
3910: cattributes=>'id=""');
3911: ELSE
3912: htp.tableData(x_font_color||x_activity_record.result||x_font_color_end, 'Left',cattributes=>'id=""');
3913: END IF;
3914:
3915: ELSE
3916:
Line 3919: htp.tableData(x_font_color||x_activity_record.result||x_font_color_end, 'Left',cattributes=>'id=""');
3916:
3917: IF (x_activity_record.result IS NOT NULL) THEN
3918:
3919: htp.tableData(x_font_color||x_activity_record.result||x_font_color_end, 'Left',cattributes=>'id=""');
3920:
3921: ELSE
3922:
3923: htp.tableData(htf.br,cattributes=>'id=""');
Line 3923: htp.tableData(htf.br,cattributes=>'id=""');
3920:
3921: ELSE
3922:
3923: htp.tableData(htf.br,cattributes=>'id=""');
3924:
3925: END IF;
3926:
3927: END IF;
Line 3931: htp.tableData(htf.br,cattributes=>'id=""');
3928:
3929: else
3930:
3931: htp.tableData(htf.br,cattributes=>'id=""');
3932:
3933: end if;
3934:
3935: htp.tableRowClose;
Line 3935: htp.tableRowClose;
3932:
3933: end if;
3934:
3935: htp.tableRowClose;
3936:
3937: end if;
3938:
3939: end loop;
Line 3943: htp.tableClose;
3940:
3941: CLOSE x_activity_cursor;
3942:
3943: htp.tableClose;
3944:
3945: htp.p(htf.formHidden('x_item_type', x_item_type));
3946: htp.p(htf.formHidden('x_item_key', x_item_key));
3947: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
Line 3945: htp.p(htf.formHidden('x_item_type', x_item_type));
3942:
3943: htp.tableClose;
3944:
3945: htp.p(htf.formHidden('x_item_type', x_item_type));
3946: htp.p(htf.formHidden('x_item_key', x_item_key));
3947: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3948: htp.p(htf.formHidden('x_access_key', x_access_key));
3949: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
Line 3946: htp.p(htf.formHidden('x_item_key', x_item_key));
3943: htp.tableClose;
3944:
3945: htp.p(htf.formHidden('x_item_type', x_item_type));
3946: htp.p(htf.formHidden('x_item_key', x_item_key));
3947: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3948: htp.p(htf.formHidden('x_access_key', x_access_key));
3949: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3950:
Line 3947: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3944:
3945: htp.p(htf.formHidden('x_item_type', x_item_type));
3946: htp.p(htf.formHidden('x_item_key', x_item_key));
3947: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3948: htp.p(htf.formHidden('x_access_key', x_access_key));
3949: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3950:
3951: htp.formClose;
Line 3948: htp.p(htf.formHidden('x_access_key', x_access_key));
3945: htp.p(htf.formHidden('x_item_type', x_item_type));
3946: htp.p(htf.formHidden('x_item_key', x_item_key));
3947: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3948: htp.p(htf.formHidden('x_access_key', x_access_key));
3949: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3950:
3951: htp.formClose;
3952:
Line 3949: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3946: htp.p(htf.formHidden('x_item_key', x_item_key));
3947: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3948: htp.p(htf.formHidden('x_access_key', x_access_key));
3949: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3950:
3951: htp.formClose;
3952:
3953: htp.tableOpen(cattributes=>'border=0 cellpadding=5 cellspacing=0
Line 3951: htp.formClose;
3948: htp.p(htf.formHidden('x_access_key', x_access_key));
3949: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3950:
3951: htp.formClose;
3952:
3953: htp.tableOpen(cattributes=>'border=0 cellpadding=5 cellspacing=0
3954: ALIGN=CENTER summary=""');
3955:
Line 3953: htp.tableOpen(cattributes=>'border=0 cellpadding=5 cellspacing=0
3950:
3951: htp.formClose;
3952:
3953: htp.tableOpen(cattributes=>'border=0 cellpadding=5 cellspacing=0
3954: ALIGN=CENTER summary=""');
3955:
3956: htp.tableRowOpen;
3957:
Line 3956: htp.tableRowOpen;
3953: htp.tableOpen(cattributes=>'border=0 cellpadding=5 cellspacing=0
3954: ALIGN=CENTER summary=""');
3955:
3956: htp.tableRowOpen;
3957:
3958: htp.p('
3954: ALIGN=CENTER summary=""');
3955:
3956: htp.tableRowOpen;
3957:
3958: htp.p('
3962: wfa_html.image_loc,
3963: null,
3964: wf_core.translate ('WFMON_VIEW_DIAGRAM'));
3965:
3966: htp.p('
3972: ** options parameter so you want to show the advanced options button.
3973: */
3974: IF (x_advanced = 'FALSE') THEN
3975:
3976: htp.p('
3978: htp.p(htf.formHidden('x_advanced', 'FIRST'));
3979: htp.p(htf.formHidden('x_item_type', x_item_type));
3980: htp.p(htf.formHidden('x_item_key', x_item_key));
3974: IF (x_advanced = 'FALSE') THEN
3975:
3976: htp.p('
3975:
3976: htp.p('
3976: htp.p('
3977:
3978: htp.p(htf.formHidden('x_advanced', 'FIRST'));
3979: htp.p(htf.formHidden('x_item_type', x_item_type));
3980: htp.p(htf.formHidden('x_item_key', x_item_key));
3981: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3982: htp.p(htf.formHidden('x_access_key', x_access_key));
3983: htp.p(htf.formHidden('x_active','ACTIVE'));
3984: htp.p(htf.formHidden('x_complete','COMPLETE'));
3985: htp.p(htf.formHidden('x_error','ERROR'));
3978: htp.p(htf.formHidden('x_advanced', 'FIRST'));
3979: htp.p(htf.formHidden('x_item_type', x_item_type));
3980: htp.p(htf.formHidden('x_item_key', x_item_key));
3981: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3982: htp.p(htf.formHidden('x_access_key', x_access_key));
3983: htp.p(htf.formHidden('x_active','ACTIVE'));
3984: htp.p(htf.formHidden('x_complete','COMPLETE'));
3985: htp.p(htf.formHidden('x_error','ERROR'));
3986: htp.p(htf.formHidden('x_suspend','SUSPEND'));
3979: htp.p(htf.formHidden('x_item_type', x_item_type));
3980: htp.p(htf.formHidden('x_item_key', x_item_key));
3981: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3982: htp.p(htf.formHidden('x_access_key', x_access_key));
3983: htp.p(htf.formHidden('x_active','ACTIVE'));
3984: htp.p(htf.formHidden('x_complete','COMPLETE'));
3985: htp.p(htf.formHidden('x_error','ERROR'));
3986: htp.p(htf.formHidden('x_suspend','SUSPEND'));
3987: htp.p(htf.formHidden('x_proc_func',null));
3980: htp.p(htf.formHidden('x_item_key', x_item_key));
3981: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3982: htp.p(htf.formHidden('x_access_key', x_access_key));
3983: htp.p(htf.formHidden('x_active','ACTIVE'));
3984: htp.p(htf.formHidden('x_complete','COMPLETE'));
3985: htp.p(htf.formHidden('x_error','ERROR'));
3986: htp.p(htf.formHidden('x_suspend','SUSPEND'));
3987: htp.p(htf.formHidden('x_proc_func',null));
3988: htp.p(htf.formHidden('x_note_resp','Y'));
3981: htp.p(htf.formHidden('x_admin_mode', x_admin_mode));
3982: htp.p(htf.formHidden('x_access_key', x_access_key));
3983: htp.p(htf.formHidden('x_active','ACTIVE'));
3984: htp.p(htf.formHidden('x_complete','COMPLETE'));
3985: htp.p(htf.formHidden('x_error','ERROR'));
3986: htp.p(htf.formHidden('x_suspend','SUSPEND'));
3987: htp.p(htf.formHidden('x_proc_func',null));
3988: htp.p(htf.formHidden('x_note_resp','Y'));
3989: htp.p(htf.formHidden('x_note_noresp',null));
3982: htp.p(htf.formHidden('x_access_key', x_access_key));
3983: htp.p(htf.formHidden('x_active','ACTIVE'));
3984: htp.p(htf.formHidden('x_complete','COMPLETE'));
3985: htp.p(htf.formHidden('x_error','ERROR'));
3986: htp.p(htf.formHidden('x_suspend','SUSPEND'));
3987: htp.p(htf.formHidden('x_proc_func',null));
3988: htp.p(htf.formHidden('x_note_resp','Y'));
3989: htp.p(htf.formHidden('x_note_noresp',null));
3990: htp.p(htf.formHidden('x_func_std',null));
3983: htp.p(htf.formHidden('x_active','ACTIVE'));
3984: htp.p(htf.formHidden('x_complete','COMPLETE'));
3985: htp.p(htf.formHidden('x_error','ERROR'));
3986: htp.p(htf.formHidden('x_suspend','SUSPEND'));
3987: htp.p(htf.formHidden('x_proc_func',null));
3988: htp.p(htf.formHidden('x_note_resp','Y'));
3989: htp.p(htf.formHidden('x_note_noresp',null));
3990: htp.p(htf.formHidden('x_func_std',null));
3991: htp.p(htf.formHidden('x_event',null));
3984: htp.p(htf.formHidden('x_complete','COMPLETE'));
3985: htp.p(htf.formHidden('x_error','ERROR'));
3986: htp.p(htf.formHidden('x_suspend','SUSPEND'));
3987: htp.p(htf.formHidden('x_proc_func',null));
3988: htp.p(htf.formHidden('x_note_resp','Y'));
3989: htp.p(htf.formHidden('x_note_noresp',null));
3990: htp.p(htf.formHidden('x_func_std',null));
3991: htp.p(htf.formHidden('x_event',null));
3992: htp.p(htf.formHidden('x_sort_column','STARTDATE'));
3985: htp.p(htf.formHidden('x_error','ERROR'));
3986: htp.p(htf.formHidden('x_suspend','SUSPEND'));
3987: htp.p(htf.formHidden('x_proc_func',null));
3988: htp.p(htf.formHidden('x_note_resp','Y'));
3989: htp.p(htf.formHidden('x_note_noresp',null));
3990: htp.p(htf.formHidden('x_func_std',null));
3991: htp.p(htf.formHidden('x_event',null));
3992: htp.p(htf.formHidden('x_sort_column','STARTDATE'));
3993: htp.p(htf.formHidden('x_sort_order', 'ASC'));
3986: htp.p(htf.formHidden('x_suspend','SUSPEND'));
3987: htp.p(htf.formHidden('x_proc_func',null));
3988: htp.p(htf.formHidden('x_note_resp','Y'));
3989: htp.p(htf.formHidden('x_note_noresp',null));
3990: htp.p(htf.formHidden('x_func_std',null));
3991: htp.p(htf.formHidden('x_event',null));
3992: htp.p(htf.formHidden('x_sort_column','STARTDATE'));
3993: htp.p(htf.formHidden('x_sort_order', 'ASC'));
3994: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3987: htp.p(htf.formHidden('x_proc_func',null));
3988: htp.p(htf.formHidden('x_note_resp','Y'));
3989: htp.p(htf.formHidden('x_note_noresp',null));
3990: htp.p(htf.formHidden('x_func_std',null));
3991: htp.p(htf.formHidden('x_event',null));
3992: htp.p(htf.formHidden('x_sort_column','STARTDATE'));
3993: htp.p(htf.formHidden('x_sort_order', 'ASC'));
3994: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3995:
3988: htp.p(htf.formHidden('x_note_resp','Y'));
3989: htp.p(htf.formHidden('x_note_noresp',null));
3990: htp.p(htf.formHidden('x_func_std',null));
3991: htp.p(htf.formHidden('x_event',null));
3992: htp.p(htf.formHidden('x_sort_column','STARTDATE'));
3993: htp.p(htf.formHidden('x_sort_order', 'ASC'));
3994: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3995:
3996:
3989: htp.p(htf.formHidden('x_note_noresp',null));
3990: htp.p(htf.formHidden('x_func_std',null));
3991: htp.p(htf.formHidden('x_event',null));
3992: htp.p(htf.formHidden('x_sort_column','STARTDATE'));
3993: htp.p(htf.formHidden('x_sort_order', 'ASC'));
3994: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3995:
3996:
3997: htp.p('
3990: htp.p(htf.formHidden('x_func_std',null));
3991: htp.p(htf.formHidden('x_event',null));
3992: htp.p(htf.formHidden('x_sort_column','STARTDATE'));
3993: htp.p(htf.formHidden('x_sort_order', 'ASC'));
3994: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3995:
3996:
3997: htp.p('
3993: htp.p(htf.formHidden('x_sort_order', 'ASC'));
3994: htp.p(htf.formHidden('x_nls_lang', x_nls_lang));
3995:
3996:
3997: htp.p('
4001: wfa_html.image_loc,
4002: null,
4003: wf_core.translate ('WFMON_REPORT_OPTIONS'));
4004:
4005: htp.p('
4003: wf_core.translate ('WFMON_REPORT_OPTIONS'));
4004:
4005: htp.p('');
4006:
4007: htp.formClose;
4008:
4009: END IF;
4010:
4011: htp.tableRowClose;
4007: htp.formClose;
4008:
4009: END IF;
4010:
4011: htp.tableRowClose;
4012:
4013: htp.tableClose;
4014:
4015: wfa_sec.footer;
4009: END IF;
4010:
4011: htp.tableRowClose;
4012:
4013: htp.tableClose;
4014:
4015: wfa_sec.footer;
4016:
4017: htp.htmlClose;
4013: htp.tableClose;
4014:
4015: wfa_sec.footer;
4016:
4017: htp.htmlClose;
4018:
4019: exception
4020: when others then
4021: Wf_Core.Context('Wf_Monitor', 'Envelope_Frame', x_item_type, x_item_key);
4064:
4065: /*
4066: ** Create the Window title
4067: */
4068: htp.htmlOpen;
4069: htp.headOpen;
4070: htp.title(l_title);
4071: wfa_html.create_help_function('wf/links/wfm.htm?WFMON');
4072:
4065: /*
4066: ** Create the Window title
4067: */
4068: htp.htmlOpen;
4069: htp.headOpen;
4070: htp.title(l_title);
4071: wfa_html.create_help_function('wf/links/wfm.htm?WFMON');
4072:
4073: -- call getsession to set context else header will print
4066: ** Create the Window title
4067: */
4068: htp.htmlOpen;
4069: htp.headOpen;
4070: htp.title(l_title);
4071: wfa_html.create_help_function('wf/links/wfm.htm?WFMON');
4072:
4073: -- call getsession to set context else header will print
4074: -- differently in apps.
4079: ** Open body and draw standard header
4080: */
4081: wfa_sec.header;
4082:
4083: htp.p('
');
4084:
4085: /*
4086: ** Draw the section title for the lookup detail section
4087: */
4095: /*
4096: ** Open a new table for each lookup so you can control the spacing
4097: ** between each attribute
4098: */
4099: htp.tableOpen(cattributes=>'border=0 cellpadding=0 cellspacing=0
4100: summary=""');
4101:
4102: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
4103: wf_core.translate('WFMON_ACTIVITY'),
4121:
4122: /*
4123: ** Table is created so close it out
4124: */
4125: htp.tableClose;
4126:
4127: END LOOP;
4128:
4129: exception
4239:
4240: /*
4241: ** Create the link for the current item
4242: */
4243: htp.tableRowOpen;
4244: htp.p ('
4240: /*
4241: ** Create the link for the current item
4242: */
4243: htp.tableRowOpen;
4244: htp.p ('
4244: htp.p ('
4258: l_item_type_disp_name||' - '||p_parent_item_key||'');
4259:
4260: htp.p ('
4259:
4260: htp.p ('');
4261:
4262: htp.tableRowClose;
4263: htp.p ('');
4264:
4265: /*
4266: ** Get the process children for this row
4267: */
4305: BEGIN
4306:
4307: wfa_sec.header(background_only=>TRUE);
4308:
4309: htp.tableopen(cattributes=>'summary=""');
4310:
4311: wf_monitor.draw_process_children (x_item_type,
4312: x_item_key,
4313: x_admin_mode,
4313: x_admin_mode,
4314: 0,x_nls_lang);
4315:
4316:
4317: htp.tableclose;
4318:
4319: wfa_sec.footer;
4320:
4321: exception