DBA Data[Home] [Help]

APPS.WF_PLUG dependencies on HTP

Line 26: htp.htmlOpen;

22: error_name varchar2(30);
23: error_message varchar2(2000);
24: error_stack varchar2(32000);
25: begin
26: htp.htmlOpen;
27: htp.headOpen;
28: htp.title(wf_core.translate('ERROR'));
29: htp.headClose;
30:

Line 27: htp.headOpen;

23: error_message varchar2(2000);
24: error_stack varchar2(32000);
25: begin
26: htp.htmlOpen;
27: htp.headOpen;
28: htp.title(wf_core.translate('ERROR'));
29: htp.headClose;
30:
31: begin

Line 28: htp.title(wf_core.translate('ERROR'));

24: error_stack varchar2(32000);
25: begin
26: htp.htmlOpen;
27: htp.headOpen;
28: htp.title(wf_core.translate('ERROR'));
29: htp.headClose;
30:
31: begin
32: wfa_sec.Header(TRUE);

Line 29: htp.headClose;

25: begin
26: htp.htmlOpen;
27: htp.headOpen;
28: htp.title(wf_core.translate('ERROR'));
29: htp.headClose;
30:
31: begin
32: wfa_sec.Header(TRUE);
33: exception

Line 35: htp.bodyOpen;

31: begin
32: wfa_sec.Header(TRUE);
33: exception
34: when others then
35: htp.bodyOpen;
36: end;
37:
38: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
39:

Line 38: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));

34: when others then
35: htp.bodyOpen;
36: end;
37:
38: htp.header(nsize=>1, cheader=>wf_core.translate('ERROR'));
39:
40: wf_core.get_error(error_name, error_message, error_stack);
41:
42: if (error_name is not null) then

Line 43: htp.p(error_message);

39:
40: wf_core.get_error(error_name, error_message, error_stack);
41:
42: if (error_name is not null) then
43: htp.p(error_message);
44: else
45: htp.p(sqlerrm);
46: end if;
47:

Line 45: htp.p(sqlerrm);

41:
42: if (error_name is not null) then
43: htp.p(error_message);
44: else
45: htp.p(sqlerrm);
46: end if;
47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);

Line 48: htp.hr;

44: else
45: htp.p(sqlerrm);
46: end if;
47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
50: htp.br;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));

Line 49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);

45: htp.p(sqlerrm);
46: end if;
47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
50: htp.br;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
53:

Line 50: htp.br;

46: end if;
47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
50: htp.br;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
53:
54: wfa_sec.Footer;

Line 51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||

47:
48: htp.hr;
49: htp.p(wf_core.translate('WFENG_ERRNAME')||': '||error_name);
50: htp.br;
51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
53:
54: wfa_sec.Footer;
55: htp.htmlClose;

Line 55: htp.htmlClose;

51: htp.p(wf_core.translate('WFENG_ERRSTACK')||': '||
52: replace(error_stack,wf_plug.chr_newline,'
'));
53:
54: wfa_sec.Footer;
55: htp.htmlClose;
56: end Error;
57:
58: --
59: -- GetPlugSession

Line 285: htp.tableRowOpen;

281: length(userenv('LANGUAGE')));
282:
283:
284: -- From User Field
285: htp.tableRowOpen;
286: htp.tableData(cvalue=>wf_core.translate('NOTIF_FROM'), calign=>'right');
287:
288: IF (fromuser = '*') THEN
289:

Line 286: htp.tableData(cvalue=>wf_core.translate('NOTIF_FROM'), calign=>'right');

282:
283:
284: -- From User Field
285: htp.tableRowOpen;
286: htp.tableData(cvalue=>wf_core.translate('NOTIF_FROM'), calign=>'right');
287:
288: IF (fromuser = '*') THEN
289:
290: htp.tableData(htf.formText(cname=>'fromuser', csize=>'30',

Line 290: htp.tableData(htf.formText(cname=>'fromuser', csize=>'30',

286: htp.tableData(cvalue=>wf_core.translate('NOTIF_FROM'), calign=>'right');
287:
288: IF (fromuser = '*') THEN
289:
290: htp.tableData(htf.formText(cname=>'fromuser', csize=>'30',
291: cvalue=>'', cmaxlength=>'30'));
292:
293: ELSE
294:

Line 295: htp.tableData(htf.formText(cname=>'fromuser', csize=>'30',

291: cvalue=>'', cmaxlength=>'30'));
292:
293: ELSE
294:
295: htp.tableData(htf.formText(cname=>'fromuser', csize=>'30',
296: cvalue=>fromuser, cmaxlength=>'30'));
297:
298: END IF;
299:

Line 300: htp.tableRowClose;

296: cvalue=>fromuser, cmaxlength=>'30'));
297:
298: END IF;
299:
300: htp.tableRowClose;
301:
302:
303: -- Type field
304: htp.tableRowOpen;

Line 304: htp.tableRowOpen;

300: htp.tableRowClose;
301:
302:
303: -- Type field
304: htp.tableRowOpen;
305: htp.tableData(cvalue=>wf_core.translate('NOTIF_TYPE'), calign=>'right');
306: htp.p('');
307: htp.formSelectOpen('ittype');
308:

Line 305: htp.tableData(cvalue=>wf_core.translate('NOTIF_TYPE'), calign=>'right');

301:
302:
303: -- Type field
304: htp.tableRowOpen;
305: htp.tableData(cvalue=>wf_core.translate('NOTIF_TYPE'), calign=>'right');
306: htp.p('');
307: htp.formSelectOpen('ittype');
308:
309: for ittype_list in itcurs(username) loop

Line 306: htp.p('');

302:
303: -- Type field
304: htp.tableRowOpen;
305: htp.tableData(cvalue=>wf_core.translate('NOTIF_TYPE'), calign=>'right');
306: htp.p('');
307: htp.formSelectOpen('ittype');
308:
309: for ittype_list in itcurs(username) loop
310:

Line 307: htp.formSelectOpen('ittype');

303: -- Type field
304: htp.tableRowOpen;
305: htp.tableData(cvalue=>wf_core.translate('NOTIF_TYPE'), calign=>'right');
306: htp.p('');
307: htp.formSelectOpen('ittype');
308:
309: for ittype_list in itcurs(username) loop
310:
311: IF (ittype_list.message_type = ittype) THEN

Line 313: htp.formSelectOption(cvalue=>ittype_list.display_name,

309: for ittype_list in itcurs(username) loop
310:
311: IF (ittype_list.message_type = ittype) THEN
312:
313: htp.formSelectOption(cvalue=>ittype_list.display_name,
314: cselected => 'SELECTED',
315: cattributes=>'value='||ittype_list.message_type);
316:
317: ELSE

Line 319: htp.formSelectOption(cvalue=>ittype_list.display_name,

315: cattributes=>'value='||ittype_list.message_type);
316:
317: ELSE
318:
319: htp.formSelectOption(cvalue=>ittype_list.display_name,
320: cattributes=>'value='||ittype_list.message_type);
321:
322: END IF;
323:

Line 328: htp.formSelectOption(cvalue=>wf_core.translate('ALL'),

324: end loop;
325:
326: IF (ittype = '*') THEN
327:
328: htp.formSelectOption(cvalue=>wf_core.translate('ALL'),
329: cselected => 'SELECTED',
330: cattributes=>'value=*');
331:
332: ELSE

Line 334: htp.formSelectOption(cvalue=>wf_core.translate('ALL'),

330: cattributes=>'value=*');
331:
332: ELSE
333:
334: htp.formSelectOption(cvalue=>wf_core.translate('ALL'),
335: cattributes=>'value=*');
336:
337: END IF;
338:

Line 339: htp.formSelectClose;

335: cattributes=>'value=*');
336:
337: END IF;
338:
339: htp.formSelectClose;
340: htp.p('');
341: htp.tableRowClose;
342:
343: -- Sent in the last N days field

Line 340: htp.p('');

336:
337: END IF;
338:
339: htp.formSelectClose;
340: htp.p('');
341: htp.tableRowClose;
342:
343: -- Sent in the last N days field
344: htp.tableRowOpen;

Line 341: htp.tableRowClose;

337: END IF;
338:
339: htp.formSelectClose;
340: htp.p('');
341: htp.tableRowClose;
342:
343: -- Sent in the last N days field
344: htp.tableRowOpen;
345: htp.tableData(cvalue=>wf_core.translate('NOTIF_SENT'), calign=>'right');

Line 344: htp.tableRowOpen;

340: htp.p('');
341: htp.tableRowClose;
342:
343: -- Sent in the last N days field
344: htp.tableRowOpen;
345: htp.tableData(cvalue=>wf_core.translate('NOTIF_SENT'), calign=>'right');
346:
347: IF (beg_sent IS NOT NULL) THEN
348:

Line 345: htp.tableData(cvalue=>wf_core.translate('NOTIF_SENT'), calign=>'right');

341: htp.tableRowClose;
342:
343: -- Sent in the last N days field
344: htp.tableRowOpen;
345: htp.tableData(cvalue=>wf_core.translate('NOTIF_SENT'), calign=>'right');
346:
347: IF (beg_sent IS NOT NULL) THEN
348:
349: lbeg_sent := TO_DATE(beg_sent, 'MM/DD/YYYY') - TO_DATE('01/01/2000', 'MM/DD/YYYY');

Line 358: htp.tableData(htf.formText(cname=>'beg_sent', csize=>'5',

354:
355: END IF;
356:
357:
358: htp.tableData(htf.formText(cname=>'beg_sent', csize=>'5',
359: cvalue=>lbeg_sent, cmaxlength=>'5'));
360:
361:
362: htp.tableRowClose;

Line 362: htp.tableRowClose;

358: htp.tableData(htf.formText(cname=>'beg_sent', csize=>'5',
359: cvalue=>lbeg_sent, cmaxlength=>'5'));
360:
361:
362: htp.tableRowClose;
363:
364: -- Skip a line
365: htp.tableRowOpen;
366:

Line 365: htp.tableRowOpen;

361:
362: htp.tableRowClose;
363:
364: -- Skip a line
365: htp.tableRowOpen;
366:
367: htp.tableData(cvalue=>' ');
368:
369: htp.tableRowClose;

Line 367: htp.tableData(cvalue=>' ');

363:
364: -- Skip a line
365: htp.tableRowOpen;
366:
367: htp.tableData(cvalue=>' ');
368:
369: htp.tableRowClose;
370:
371: -- High Priority Items

Line 369: htp.tableRowClose;

365: htp.tableRowOpen;
366:
367: htp.tableData(cvalue=>' ');
368:
369: htp.tableRowClose;
370:
371: -- High Priority Items
372: htp.tableRowOpen;
373:

Line 372: htp.tableRowOpen;

368:
369: htp.tableRowClose;
370:
371: -- High Priority Items
372: htp.tableRowOpen;
373:
374: htp.tableData(cvalue=>' ');
375:
376: IF (INSTR(priority, 'H') > 0) THEN

Line 374: htp.tableData(cvalue=>' ');

370:
371: -- High Priority Items
372: htp.tableRowOpen;
373:
374: htp.tableData(cvalue=>' ');
375:
376: IF (INSTR(priority, 'H') > 0) THEN
377:
378: lchecked := 'Y';

Line 386: htp.tableData(

382: lchecked := null;
383:
384: END IF;
385:
386: htp.tableData(
387: cvalue=>htf.formcheckbox(
388: cname=>'HPRIORITY',
389: cvalue=>'H',
390: cchecked=>lchecked)||

Line 394: htp.tableRowClose;

390: cchecked=>lchecked)||
391: ' '||wf_core.translate('HIGH_MESSAGES')||'   ',
392: calign=>'left');
393:
394: htp.tableRowClose;
395:
396: -- Medium Priority Items
397: htp.tableRowOpen;
398:

Line 397: htp.tableRowOpen;

393:
394: htp.tableRowClose;
395:
396: -- Medium Priority Items
397: htp.tableRowOpen;
398:
399: htp.tableData(cvalue=>' ');
400:
401: IF (INSTR(priority, 'M') > 0) THEN

Line 399: htp.tableData(cvalue=>' ');

395:
396: -- Medium Priority Items
397: htp.tableRowOpen;
398:
399: htp.tableData(cvalue=>' ');
400:
401: IF (INSTR(priority, 'M') > 0) THEN
402:
403: lchecked := 'Y';

Line 411: htp.tableData(

407: lchecked := null;
408:
409: END IF;
410:
411: htp.tableData(
412: cvalue=>htf.formcheckbox(
413: cname=>'MPRIORITY',
414: cvalue=>'M',
415: cchecked=>lchecked)||

Line 419: htp.tableRowClose;

415: cchecked=>lchecked)||
416: ' '||wf_core.translate('MEDIUM_MESSAGES')||'   ',
417: calign=>'left');
418:
419: htp.tableRowClose;
420:
421: -- Low Priority Items
422: htp.tableRowOpen;
423:

Line 422: htp.tableRowOpen;

418:
419: htp.tableRowClose;
420:
421: -- Low Priority Items
422: htp.tableRowOpen;
423:
424: htp.tableData(cvalue=>' ');
425:
426: IF (INSTR(priority, 'L') > 0) THEN

Line 424: htp.tableData(cvalue=>' ');

420:
421: -- Low Priority Items
422: htp.tableRowOpen;
423:
424: htp.tableData(cvalue=>' ');
425:
426: IF (INSTR(priority, 'L') > 0) THEN
427:
428: lchecked := 'Y';

Line 436: htp.tableData(

432: lchecked := null;
433:
434: END IF;
435:
436: htp.tableData(
437: cvalue=>htf.formcheckbox(
438: cname=>'LPRIORITY',
439: cvalue=>'L',
440: cchecked=>lchecked)||

Line 444: htp.tableRowClose;

440: cchecked=>lchecked)||
441: ' '||wf_core.translate('LOW_MESSAGES')||'   ',
442: calign=>'left');
443:
444: htp.tableRowClose;
445:
446: htp.tableClose;
447:
448:

Line 446: htp.tableClose;

442: calign=>'left');
443:
444: htp.tableRowClose;
445:
446: htp.tableClose;
447:
448:
449: exception
450: when others then

Line 766: htp.p(lorderkey||':'||lstatus||':'||luser

762:
763: fetch wl_cursor into notrec;
764: if wl_cursor%NOTFOUND then
765: /*
766: htp.p(lorderkey||':'||lstatus||':'||luser
767: ||':'||lfromuser||':'||littype||':'||lsubject||':'||lbeg_sent
768: ||':'||lend_sent||':'||lbeg_due||':'||lend_due||':'||lpriority
769: ||':'||ldbm);
770: */

Line 772: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');

768: ||':'||lend_sent||':'||lbeg_due||':'||lend_due||':'||lpriority
769: ||':'||ldbm);
770: */
771: close wl_cursor;
772: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
773: htp.tableRowOpen;
774: htp.p('');
775: IF (display_name IS NULL) THEN
776:

Line 773: htp.tableRowOpen;

769: ||':'||ldbm);
770: */
771: close wl_cursor;
772: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
773: htp.tableRowOpen;
774: htp.p('');
775: IF (display_name IS NULL) THEN
776:
777: icx_plug_utilities.plugbanner(wf_core.translate('WFA_WTITLE'),

Line 774: htp.p('');

770: */
771: close wl_cursor;
772: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
773: htp.tableRowOpen;
774: htp.p('');
775: IF (display_name IS NULL) THEN
776:
777: icx_plug_utilities.plugbanner(wf_core.translate('WFA_WTITLE'),
778: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||

Line 788: htp.p('');

784: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||
785: 'p_plug_id='||plug_id, 'FNDALERT.gif');
786:
787: END IF;
788: htp.p('');
789: htp.tableRowClose;
790: htp.tableClose;
791:
792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));

Line 789: htp.tableRowClose;

785: 'p_plug_id='||plug_id, 'FNDALERT.gif');
786:
787: END IF;
788: htp.p('');
789: htp.tableRowClose;
790: htp.tableClose;
791:
792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));
793: htp.br;

Line 790: htp.tableClose;

786:
787: END IF;
788: htp.p('');
789: htp.tableRowClose;
790: htp.tableClose;
791:
792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));
793: htp.br;
794:

Line 792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));

788: htp.p('');
789: htp.tableRowClose;
790: htp.tableClose;
791:
792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));
793: htp.br;
794:
795: return;
796:

Line 793: htp.br;

789: htp.tableRowClose;
790: htp.tableClose;
791:
792: htp.p(wf_core.translate('WFA_NO_HOME_NOTIFY'));
793: htp.br;
794:
795: return;
796:
797: end if;

Line 799: htp.p(lorderkey||':'||lstatus||':'||luser

795: return;
796:
797: end if;
798: /*
799: htp.p(lorderkey||':'||lstatus||':'||luser
800: ||':'||lfromuser||':'||littype||':'||lsubject||':'||lbeg_sent
801: ||':'||lend_sent||':'||lbeg_due||':'||lend_due||':'||lpriority
802: ||':'||ldbm);
803: */

Line 808: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');

804:
805: -- If this is a plug then show title bar a customize reference
806: IF (plug_id IS NOT NULL) THEN
807:
808: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
809: htp.tableRowOpen;
810: htp.p('');
811: IF (display_name IS NULL) THEN
812:

Line 809: htp.tableRowOpen;

805: -- If this is a plug then show title bar a customize reference
806: IF (plug_id IS NOT NULL) THEN
807:
808: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
809: htp.tableRowOpen;
810: htp.p('');
811: IF (display_name IS NULL) THEN
812:
813: icx_plug_utilities.plugbanner(wf_core.translate('WFA_WTITLE'),

Line 810: htp.p('');

806: IF (plug_id IS NOT NULL) THEN
807:
808: htp.tableOpen('border=0 cellspacing=0 cellpadding=0 width=100%');
809: htp.tableRowOpen;
810: htp.p('');
811: IF (display_name IS NULL) THEN
812:
813: icx_plug_utilities.plugbanner(wf_core.translate('WFA_WTITLE'),
814: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||

Line 824: htp.p('');

820: owa_util.get_owa_service_path||'wf_plug.edit_worklist_definition?'||
821: 'p_plug_id='||plug_id, 'FNDALERT.gif');
822: end if;
823:
824: htp.p('');
825: htp.p('
');
826: htp.tableRowClose;
827: htp.tableClose;
828:

Line 825: htp.p('
');

821: 'p_plug_id='||plug_id, 'FNDALERT.gif');
822: end if;
823:
824: htp.p('');
825: htp.p('
');
826: htp.tableRowClose;
827: htp.tableClose;
828:
829: END IF;

Line 826: htp.tableRowClose;

822: end if;
823:
824: htp.p('');
825: htp.p('
');
826: htp.tableRowClose;
827: htp.tableClose;
828:
829: END IF;
830:

Line 827: htp.tableClose;

823:
824: htp.p('');
825: htp.p('
');
826: htp.tableRowClose;
827: htp.tableClose;
828:
829: END IF;
830:
831: -- There are some notifications for the user. Construct the page.

Line 832: htp.tableOpen('border=0 cellpadding=1 cellspacing=0 width=100%');

828:
829: END IF;
830:
831: -- There are some notifications for the user. Construct the page.
832: htp.tableOpen('border=0 cellpadding=1 cellspacing=0 width=100%');
833:
834: IF (l_worklist_col_definition.count > 1) THEN
835:
836: -- Column headers

Line 837: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbgcolor);

833:
834: IF (l_worklist_col_definition.count > 1) THEN
835:
836: -- Column headers
837: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbgcolor);
838:
839: htp.tabledata(cvalue=>' ');
840:
841: FOR l_record_num IN 1..l_worklist_col_definition.count LOOP

Line 839: htp.tabledata(cvalue=>' ');

835:
836: -- Column headers
837: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbgcolor);
838:
839: htp.tabledata(cvalue=>' ');
840:
841: FOR l_record_num IN 1..l_worklist_col_definition.count LOOP
842:
843: IF (l_worklist_col_definition(l_record_num).column_name =

Line 846: htp.tableData(''||wf_core.translate('TYPE')||'', 'Left');

842:
843: IF (l_worklist_col_definition(l_record_num).column_name =
844: 'MESSAGE_TYPE') THEN
845:
846: htp.tableData(''||wf_core.translate('TYPE')||'', 'Left');
847:
848: END IF;
849:
850: IF (l_worklist_col_definition(l_record_num).column_name =

Line 853: htp.tableData(''||wf_core.translate('SUBJECT')||'', 'Left');

849:
850: IF (l_worklist_col_definition(l_record_num).column_name =
851: 'SUBJECT') THEN
852:
853: htp.tableData(''||wf_core.translate('SUBJECT')||'', 'Left');
854:
855: END IF;
856:
857: IF (l_worklist_col_definition(l_record_num).column_name =

Line 860: htp.tableData(''||wf_core.translate('BEGIN_DATE')||'', 'Left');

856:
857: IF (l_worklist_col_definition(l_record_num).column_name =
858: 'BEGIN_DATE') THEN
859:
860: htp.tableData(''||wf_core.translate('BEGIN_DATE')||'', 'Left');
861:
862: END IF;
863:
864: IF (l_worklist_col_definition(l_record_num).column_name =

Line 867: htp.tableData(''||wf_core.translate('DUE_DATE')||'', 'Left');

863:
864: IF (l_worklist_col_definition(l_record_num).column_name =
865: 'DUE_DATE') THEN
866:
867: htp.tableData(''||wf_core.translate('DUE_DATE')||'', 'Left');
868:
869: END IF;
870:
871: END LOOP;

Line 873: htp.tableRowClose;

869: END IF;
870:
871: END LOOP;
872:
873: htp.tableRowClose;
874:
875: -- Print line
876: /*
877: htp.p('');
879: htp.p('

Line 879: htp.p('');
879: htp.p(' 882: || 'UDT.gif width=1 height=1>');
883: htp.tableRowClose;

Line 883: htp.tableRowClose;

879: htp.p(' 882: || 'UDT.gif width=1 height=1>');
883: htp.tableRowClose;
884: */
885:
886: END IF;
887:

Line 903: htp.tableRowOpen(cvalign=>'TOP', cattributes=>'bgcolor=white');

899: end if;
900: end if;
901:
902: -- Displaying a row
903: htp.tableRowOpen(cvalign=>'TOP', cattributes=>'bgcolor=white');
904:
905: IF (n_priority IS NULL) THEN
906:
907: htp.tableData(cvalue=>' ');

Line 907: htp.tableData(cvalue=>' ');

903: htp.tableRowOpen(cvalign=>'TOP', cattributes=>'bgcolor=white');
904:
905: IF (n_priority IS NULL) THEN
906:
907: htp.tableData(cvalue=>' ');
908:
909: ELSE
910:
911: htp.tableData(cvalue=>htf.img(curl=>n_priority));

Line 911: htp.tableData(cvalue=>htf.img(curl=>n_priority));

907: htp.tableData(cvalue=>' ');
908:
909: ELSE
910:
911: htp.tableData(cvalue=>htf.img(curl=>n_priority));
912:
913: END IF;
914:
915: FOR l_record_num IN 1..l_worklist_col_definition.count LOOP

Line 920: htp.tableData(cvalue=>''||

916:
917: IF (l_worklist_col_definition(l_record_num).column_name =
918: 'MESSAGE_TYPE') THEN
919:
920: htp.tableData(cvalue=>''||
921: notrec.message_type, calign=>'left');
922:
923: END IF;
924:

Line 933: htp.tableData(cvalue=>''||

929:
930: Wfa_Html_Util.GetDenormalizedValues(notrec.nid, userenv('LANG'),
931: nf_from_user, nf_to_user, nf_subject);
932:
933: htp.tableData(cvalue=>''||
934: htf.anchor(owa_util.get_owa_service_path||
935: Wfa_Sec.DetailURL(notrec.nid),
936: ctext=>nf_subject, cattributes=>'TARGET="_top"'),
937: calign=>'left');

Line 941: htp.tableData( cvalue=>''||

937: calign=>'left');
938:
939: else
940:
941: htp.tableData( cvalue=>''||
942: htf.anchor(owa_util.get_owa_service_path||
943: Wfa_Sec.DetailURL(notrec.nid),
944: ctext=>notrec.subject, cattributes=>'TARGET="_top"'),
945: calign=>'left');

Line 954: htp.tableData(cvalue=>''||

950:
951: IF (l_worklist_col_definition(l_record_num).column_name =
952: 'BEGIN_DATE') THEN
953:
954: htp.tableData(cvalue=>''||
955: to_char(notrec.begin_date ), calign=>'left',
956: cnowrap=>1);
957:
958: END IF;

Line 963: htp.tableData(cvalue=>''||

959:
960: IF (l_worklist_col_definition(l_record_num).column_name =
961: 'DUE_DATE') THEN
962:
963: htp.tableData(cvalue=>''||
964: nvl(to_char(notrec.due_date), '
'),
965: calign=>'left', cnowrap=>1);
966:
967: END IF;

Line 971: htp.tableRowClose;

967: END IF;
968:
969: END LOOP;
970:
971: htp.tableRowClose;
972:
973: <>
974: fetch wl_cursor into notrec;
975: exit when wl_cursor%NOTFOUND;

Line 979: htp.tableClose;

975: exit when wl_cursor%NOTFOUND;
976: end loop;
977: close wl_cursor;
978:
979: htp.tableClose;
980:
981: exception
982: when others then
983: rollback;

Line 1150: htp.htmlOpen;

1146:
1147: END IF;
1148:
1149: -- Page title
1150: htp.htmlOpen;
1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;

Line 1151: htp.headOpen;

1147: END IF;
1148:
1149: -- Page title
1150: htp.htmlOpen;
1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;
1155: htp.p('');

Line 1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));

1148:
1149: -- Page title
1150: htp.htmlOpen;
1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;
1155: htp.p('');
1156:

Line 1154: htp.headClose;

1150: htp.htmlOpen;
1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;
1155: htp.p('');
1156:
1157: -- Open body and draw standard header
1158: if (p_plug_id =0) then

Line 1155: htp.p('');

1151: htp.headOpen;
1152: htp.title(ctitle=>wf_core.translate('WF_EDIT_WORKLIST_TITLE'));
1153:
1154: htp.headClose;
1155: htp.p('');
1156:
1157: -- Open body and draw standard header
1158: if (p_plug_id =0) then
1159: icx_plug_utilities.toolbar(p_text => wf_core.translate('WF_EDIT_WORKLIST_TITLE'),

Line 1168: htp.tableopen;

1164: p_disp_mainmenu => 'N',
1165: p_disp_menu => 'N');
1166: end if;
1167:
1168: htp.tableopen;
1169:
1170: htp.tablerowopen;
1171:
1172: htp.p('      ');

Line 1170: htp.tablerowopen;

1166: end if;
1167:
1168: htp.tableopen;
1169:
1170: htp.tablerowopen;
1171:
1172: htp.p('      ');
1173:
1174: htp.p(''||wf_core.translate('WF_EDIT_WORKLIST_HELP')||'');

Line 1172: htp.p('      ');

1168: htp.tableopen;
1169:
1170: htp.tablerowopen;
1171:
1172: htp.p('      ');
1173:
1174: htp.p(''||wf_core.translate('WF_EDIT_WORKLIST_HELP')||'');
1175:
1176: htp.p('      ');

Line 1174: htp.p(''||wf_core.translate('WF_EDIT_WORKLIST_HELP')||'');

1170: htp.tablerowopen;
1171:
1172: htp.p('      ');
1173:
1174: htp.p(''||wf_core.translate('WF_EDIT_WORKLIST_HELP')||'');
1175:
1176: htp.p('      ');
1177:
1178: htp.tablerowclose;

Line 1176: htp.p('      ');

1172: htp.p('      ');
1173:
1174: htp.p(''||wf_core.translate('WF_EDIT_WORKLIST_HELP')||'');
1175:
1176: htp.p('      ');
1177:
1178: htp.tablerowclose;
1179:
1180: htp.tableclose;

Line 1178: htp.tablerowclose;

1174: htp.p(''||wf_core.translate('WF_EDIT_WORKLIST_HELP')||'');
1175:
1176: htp.p('      ');
1177:
1178: htp.tablerowclose;
1179:
1180: htp.tableclose;
1181:
1182: htp.tableopen(calign=>'CENTER');

Line 1180: htp.tableclose;

1176: htp.p('      ');
1177:
1178: htp.tablerowclose;
1179:
1180: htp.tableclose;
1181:
1182: htp.tableopen(calign=>'CENTER');
1183:
1184: htp.tablerowopen;

Line 1182: htp.tableopen(calign=>'CENTER');

1178: htp.tablerowclose;
1179:
1180: htp.tableclose;
1181:
1182: htp.tableopen(calign=>'CENTER');
1183:
1184: htp.tablerowopen;
1185:
1186: htp.p('');

Line 1184: htp.tablerowopen;

1180: htp.tableclose;
1181:
1182: htp.tableopen(calign=>'CENTER');
1183:
1184: htp.tablerowopen;
1185:
1186: htp.p('');
1187:
1188: -- wf_dsk.submit_dsk is the url(procedure) to which the contents

Line 1186: htp.p('');

1182: htp.tableopen(calign=>'CENTER');
1183:
1184: htp.tablerowopen;
1185:
1186: htp.p('');
1187:
1188: -- wf_dsk.submit_dsk is the url(procedure) to which the contents
1189: -- of this form is sent
1190: htp.p('

');

Line 1190: htp.p('');

1186: htp.p('');
1187:
1188: -- wf_dsk.submit_dsk is the url(procedure) to which the contents
1189: -- of this form is sent
1190: htp.p('');
1191:
1192: htp.formHidden(cname=>'plug_id', cvalue=>p_plug_id);
1193: htp.formHidden(cname=>'username', cvalue=>p_username);
1194: htp.formHidden(cname=>'definition_name', cvalue=>null);

Line 1192: htp.formHidden(cname=>'plug_id', cvalue=>p_plug_id);

1188: -- wf_dsk.submit_dsk is the url(procedure) to which the contents
1189: -- of this form is sent
1190: htp.p('');
1191:
1192: htp.formHidden(cname=>'plug_id', cvalue=>p_plug_id);
1193: htp.formHidden(cname=>'username', cvalue=>p_username);
1194: htp.formHidden(cname=>'definition_name', cvalue=>null);
1195:
1196: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_COLUMNS'));

Line 1193: htp.formHidden(cname=>'username', cvalue=>p_username);

1189: -- of this form is sent
1190: htp.p('');
1191:
1192: htp.formHidden(cname=>'plug_id', cvalue=>p_plug_id);
1193: htp.formHidden(cname=>'username', cvalue=>p_username);
1194: htp.formHidden(cname=>'definition_name', cvalue=>null);
1195:
1196: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_COLUMNS'));
1197: htp.br;

Line 1194: htp.formHidden(cname=>'definition_name', cvalue=>null);

1190: htp.p('');
1191:
1192: htp.formHidden(cname=>'plug_id', cvalue=>p_plug_id);
1193: htp.formHidden(cname=>'username', cvalue=>p_username);
1194: htp.formHidden(cname=>'definition_name', cvalue=>null);
1195:
1196: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_COLUMNS'));
1197: htp.br;
1198: htp.br;

Line 1196: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_COLUMNS'));

1192: htp.formHidden(cname=>'plug_id', cvalue=>p_plug_id);
1193: htp.formHidden(cname=>'username', cvalue=>p_username);
1194: htp.formHidden(cname=>'definition_name', cvalue=>null);
1195:
1196: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_COLUMNS'));
1197: htp.br;
1198: htp.br;
1199:
1200:

Line 1197: htp.br;

1193: htp.formHidden(cname=>'username', cvalue=>p_username);
1194: htp.formHidden(cname=>'definition_name', cvalue=>null);
1195:
1196: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_COLUMNS'));
1197: htp.br;
1198: htp.br;
1199:
1200:
1201: -- There are some notifications for the user. Construct the page.

Line 1198: htp.br;

1194: htp.formHidden(cname=>'definition_name', cvalue=>null);
1195:
1196: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_COLUMNS'));
1197: htp.br;
1198: htp.br;
1199:
1200:
1201: -- There are some notifications for the user. Construct the page.
1202: htp.tableOpen;

Line 1202: htp.tableOpen;

1198: htp.br;
1199:
1200:
1201: -- There are some notifications for the user. Construct the page.
1202: htp.tableOpen;
1203:
1204: -- Column Titles
1205: htp.tableRowOpen;
1206:

Line 1205: htp.tableRowOpen;

1201: -- There are some notifications for the user. Construct the page.
1202: htp.tableOpen;
1203:
1204: -- Column Titles
1205: htp.tableRowOpen;
1206:
1207: htp.p('');
1208:
1209: -- Create the column titles table inside the outer tablex

Line 1207: htp.p('');

1203:
1204: -- Column Titles
1205: htp.tableRowOpen;
1206:
1207: htp.p('');
1208:
1209: -- Create the column titles table inside the outer tablex
1210: htp.p('');
1211:

Line 1210: htp.p('
');

1206:
1207: htp.p('

');
1208:
1209: -- Create the column titles table inside the outer tablex
1210: htp.p('');
1211:
1212: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);
1213:
1214: -- If the p_add_columns to show has been passed in that means the user

Line 1212: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);

1208:
1209: -- Create the column titles table inside the outer tablex
1210: htp.p('

');
1211:
1212: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);
1213:
1214: -- If the p_add_columns to show has been passed in that means the user
1215: -- has asked to add a column to the list.
1216: l_columns_to_show := 4;

Line 1220: htp.p('
');
1272:
1273: END LOOP;

Line 1271: htp.p('');

1267: END IF;
1268:
1269: htp.formSelectClose;
1270:
1271: htp.p('');
1272:
1273: END LOOP;
1274:
1275: htp.tableRowClose;

Line 1275: htp.tableRowClose;

1271: htp.p('');
1272:
1273: END LOOP;
1274:
1275: htp.tableRowClose;
1276:
1277: htp.tableClose;
1278:
1279: htp.p('

');

Line 1277: htp.tableClose;

1273: END LOOP;
1274:
1275: htp.tableRowClose;
1276:
1277: htp.tableClose;
1278:
1279: htp.p('

');
1280:
1281: htp.p('');

1275: htp.tableRowClose;
1276:
1277: htp.tableClose;
1278:
1279: htp.p('

');
1280:
1281: htp.p('');
1280:
1281: htp.p('
'||

1216: l_columns_to_show := 4;
1217:
1218: FOR l_record_num IN 1..l_columns_to_show LOOP
1219:
1220: htp.p('

'||
1221: wf_core.translate('COLUMN')||' '||
1222: TO_CHAR(l_record_num)||'
');
1223:
1224: END LOOP;

Line 1226: htp.tableRowClose;

1222: TO_CHAR(l_record_num)||'');
1223:
1224: END LOOP;
1225:
1226: htp.tableRowClose;
1227:
1228: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);
1229:
1230: -- Display the LOV's for the column names that are in each column

Line 1228: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);

1224: END LOOP;
1225:
1226: htp.tableRowClose;
1227:
1228: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);
1229:
1230: -- Display the LOV's for the column names that are in each column
1231: htp.tableRowOpen;
1232:

Line 1231: htp.tableRowOpen;

1227:
1228: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);
1229:
1230: -- Display the LOV's for the column names that are in each column
1231: htp.tableRowOpen;
1232:
1233: FOR l_record_num IN 1..l_columns_to_show LOOP
1234:
1235: htp.p('

');

Line 1235: htp.p('
');

1231: htp.tableRowOpen;
1232:
1233: FOR l_record_num IN 1..l_columns_to_show LOOP
1234:
1235: htp.p('

');
1236:
1237: htp.formSelectOpen(cname=>'COLUMN_NAME');
1238:
1239: -- Loop on each of the possible column names that can be selected

Line 1237: htp.formSelectOpen(cname=>'COLUMN_NAME');

1233: FOR l_record_num IN 1..l_columns_to_show LOOP
1234:
1235: htp.p('

');
1236:
1237: htp.formSelectOpen(cname=>'COLUMN_NAME');
1238:
1239: -- Loop on each of the possible column names that can be selected
1240: -- for a given column.
1241: -- Need to make this a table so you only select it once.

Line 1246: htp.formSelectOption(cvalue=>orderby.meaning,

1242: FOR orderby IN lkcurs('WFSTD_WLORDERBY') LOOP
1243: IF (l_record_num <= l_worklist_col_definition.count AND
1244: l_worklist_col_definition(l_record_num).column_name =
1245: orderby.lookup_code) THEN
1246: htp.formSelectOption(cvalue=>orderby.meaning,
1247: cselected => 'SELECTED',
1248: cattributes=>'value='||orderby.lookup_code);
1249: ELSE
1250: htp.formSelectOption(cvalue=>orderby.meaning,

Line 1250: htp.formSelectOption(cvalue=>orderby.meaning,

1246: htp.formSelectOption(cvalue=>orderby.meaning,
1247: cselected => 'SELECTED',
1248: cattributes=>'value='||orderby.lookup_code);
1249: ELSE
1250: htp.formSelectOption(cvalue=>orderby.meaning,
1251: cattributes=>'value='||orderby.lookup_code);
1252: END IF;
1253:
1254: END LOOP;

Line 1258: htp.formSelectOption(cvalue=>wf_core.translate('BLANK'),

1254: END LOOP;
1255:
1256: IF (l_record_num > l_worklist_col_definition.count) THEN
1257:
1258: htp.formSelectOption(cvalue=>wf_core.translate('BLANK'),
1259: cselected => 'SELECTED',
1260: cattributes=>'value=NULL');
1261:
1262: ELSE

Line 1264: htp.formSelectOption(cvalue=>wf_core.translate('BLANK'),

1260: cattributes=>'value=NULL');
1261:
1262: ELSE
1263:
1264: htp.formSelectOption(cvalue=>wf_core.translate('BLANK'),
1265: cattributes=>'value=NULL');
1266:
1267: END IF;
1268:

Line 1269: htp.formSelectClose;

1265: cattributes=>'value=NULL');
1266:
1267: END IF;
1268:
1269: htp.formSelectClose;
1270:
1271: htp.p('

');

Line 1279: htp.p('
');
1282:
1283: -- Create the order column title table inside the outer tablex

Line 1281: htp.p('
');

1277: htp.tableClose;
1278:
1279: htp.p('

');
1282:
1283: -- Create the order column title table inside the outer tablex
1284: htp.p('');
1285:

Line 1284: htp.p('
');

1280:
1281: htp.p('

');
1282:
1283: -- Create the order column title table inside the outer tablex
1284: htp.p('');
1285:
1286: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);
1287:
1288: htp.p('
'||wf_core.translate('ORDERBY')||'');

Line 1286: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);

1282:
1283: -- Create the order column title table inside the outer tablex
1284: htp.p('');
1285:
1286: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);
1287:
1288: htp.p('
'||wf_core.translate('ORDERBY')||'');
1289:
1290: htp.tableRowClose;

Line 1288: htp.p('
'||wf_core.translate('ORDERBY')||'');

1284: htp.p('');
1285:
1286: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);
1287:
1288: htp.p('');
1311:
1312: htp.tableRowClose;

Line 1310: htp.p('');

1306: end loop;
1307:
1308: htp.formSelectClose;
1309:
1310: htp.p('');
1311:
1312: htp.tableRowClose;
1313:
1314: htp.tableClose; -- Worklist display

Line 1312: htp.tableRowClose;

1308: htp.formSelectClose;
1309:
1310: htp.p('');
1311:
1312: htp.tableRowClose;
1313:
1314: htp.tableClose; -- Worklist display
1315:
1316: htp.tableClose; -- outer table

Line 1314: htp.tableClose; -- Worklist display

1310: htp.p('');
1311:
1312: htp.tableRowClose;
1313:
1314: htp.tableClose; -- Worklist display
1315:
1316: htp.tableClose; -- outer table
1317:
1318: -- Place an extra space between the other search criteria and order by

Line 1316: htp.tableClose; -- outer table

1312: htp.tableRowClose;
1313:
1314: htp.tableClose; -- Worklist display
1315:
1316: htp.tableClose; -- outer table
1317:
1318: -- Place an extra space between the other search criteria and order by
1319: htp.br;
1320:

Line 1319: htp.br;

1315:
1316: htp.tableClose; -- outer table
1317:
1318: -- Place an extra space between the other search criteria and order by
1319: htp.br;
1320:
1321: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_CRITERIA'));
1322:
1323: htp.tableOpen; -- Show me only

Line 1321: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_CRITERIA'));

1317:
1318: -- Place an extra space between the other search criteria and order by
1319: htp.br;
1320:
1321: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_CRITERIA'));
1322:
1323: htp.tableOpen; -- Show me only
1324:
1325: -- Add blank row

Line 1323: htp.tableOpen; -- Show me only

1319: htp.br;
1320:
1321: htp.bold(wf_core.translate('WF_EDIT_WORKLIST_CRITERIA'));
1322:
1323: htp.tableOpen; -- Show me only
1324:
1325: -- Add blank row
1326: htp.tableRowOpen;
1327: htp.tableData(htf.br);

Line 1326: htp.tableRowOpen;

1322:
1323: htp.tableOpen; -- Show me only
1324:
1325: -- Add blank row
1326: htp.tableRowOpen;
1327: htp.tableData(htf.br);
1328: htp.tableRowClose;
1329:
1330: find_criteria (username=>l_username,

Line 1327: htp.tableData(htf.br);

1323: htp.tableOpen; -- Show me only
1324:
1325: -- Add blank row
1326: htp.tableRowOpen;
1327: htp.tableData(htf.br);
1328: htp.tableRowClose;
1329:
1330: find_criteria (username=>l_username,
1331: status=>l_worklist_definition.where_status,

Line 1328: htp.tableRowClose;

1324:
1325: -- Add blank row
1326: htp.tableRowOpen;
1327: htp.tableData(htf.br);
1328: htp.tableRowClose;
1329:
1330: find_criteria (username=>l_username,
1331: status=>l_worklist_definition.where_status,
1332: fromuser=>l_worklist_definition.where_from,

Line 1345: htp.tableRowOpen;

1341: orderkey=>l_worklist_definition.order_primary,
1342: customize=>'Y');
1343:
1344: -- Add blank row
1345: htp.tableRowOpen;
1346: htp.tableData(htf.br);
1347: htp.tableRowClose;
1348:
1349: htp.formHidden(cname=>'definition_exists', cvalue=>l_definition_exists);

Line 1346: htp.tableData(htf.br);

1342: customize=>'Y');
1343:
1344: -- Add blank row
1345: htp.tableRowOpen;
1346: htp.tableData(htf.br);
1347: htp.tableRowClose;
1348:
1349: htp.formHidden(cname=>'definition_exists', cvalue=>l_definition_exists);
1350: htp.tableClose; -- Show me only

Line 1347: htp.tableRowClose;

1343:
1344: -- Add blank row
1345: htp.tableRowOpen;
1346: htp.tableData(htf.br);
1347: htp.tableRowClose;
1348:
1349: htp.formHidden(cname=>'definition_exists', cvalue=>l_definition_exists);
1350: htp.tableClose; -- Show me only
1351:

Line 1349: htp.formHidden(cname=>'definition_exists', cvalue=>l_definition_exists);

1345: htp.tableRowOpen;
1346: htp.tableData(htf.br);
1347: htp.tableRowClose;
1348:
1349: htp.formHidden(cname=>'definition_exists', cvalue=>l_definition_exists);
1350: htp.tableClose; -- Show me only
1351:
1352: htp.p('

');
1353: htp.tableOpen; -- OK

Line 1350: htp.tableClose; -- Show me only

1346: htp.tableData(htf.br);
1347: htp.tableRowClose;
1348:
1349: htp.formHidden(cname=>'definition_exists', cvalue=>l_definition_exists);
1350: htp.tableClose; -- Show me only
1351:
1352: htp.p('

');
1353: htp.tableOpen; -- OK
1354: -- Add submit button

Line 1352: htp.p('
');

1348:
1349: htp.formHidden(cname=>'definition_exists', cvalue=>l_definition_exists);
1350: htp.tableClose; -- Show me only
1351:
1352: htp.p('

');
1353: htp.tableOpen; -- OK
1354: -- Add submit button
1355: htp.tableRowOpen;
1356:

Line 1353: htp.tableOpen; -- OK

1349: htp.formHidden(cname=>'definition_exists', cvalue=>l_definition_exists);
1350: htp.tableClose; -- Show me only
1351:
1352: htp.p('

');
1353: htp.tableOpen; -- OK
1354: -- Add submit button
1355: htp.tableRowOpen;
1356:
1357: htp.p('
');

1365: -- fixed bug for cancel button
1366: icx_plug_utilities.buttonright(wf_core.translate('CANCEL'),'javascript:history.back()', 'FNDJLFCN.gif');
1367: -- icx_plug_utilities.buttonright(wf_core.translate('CANCEL'),icx_plug_utilities.MainMenulink, 'FNDJLFCN.gif');
1368:
1369: htp.p('');
1370:
1371: htp.tableRowClose;
1372:
1373: htp.tableClose; -- OK

Line 1371: htp.tableRowClose;

1367: -- icx_plug_utilities.buttonright(wf_core.translate('CANCEL'),icx_plug_utilities.MainMenulink, 'FNDJLFCN.gif');
1368:
1369: htp.p('');
1370:
1371: htp.tableRowClose;
1372:
1373: htp.tableClose; -- OK
1374: htp.p('');
1375:

Line 1373: htp.tableClose; -- OK

1369: htp.p('');
1370:
1371: htp.tableRowClose;
1372:
1373: htp.tableClose; -- OK
1374: htp.p('');
1375:
1376: htp.formClose;
1377:

Line 1374: htp.p('');

1370:
1371: htp.tableRowClose;
1372:
1373: htp.tableClose; -- OK
1374: htp.p('');
1375:
1376: htp.formClose;
1377:
1378: htp.p('');

Line 1376: htp.formClose;

1372:
1373: htp.tableClose; -- OK
1374: htp.p('');
1375:
1376: htp.formClose;
1377:
1378: htp.p('');
1379:
1380: htp.tablerowclose;

Line 1378: htp.p('');

1374: htp.p('');
1375:
1376: htp.formClose;
1377:
1378: htp.p('');
1379:
1380: htp.tablerowclose;
1381:
1382: htp.tableclose;

Line 1380: htp.tablerowclose;

1376: htp.formClose;
1377:
1378: htp.p('');
1379:
1380: htp.tablerowclose;
1381:
1382: htp.tableclose;
1383:
1384: wfa_sec.footer;

Line 1382: htp.tableclose;

1378: htp.p('');
1379:
1380: htp.tablerowclose;
1381:
1382: htp.tableclose;
1383:
1384: wfa_sec.footer;
1385: htp.htmlClose;
1386:

Line 1385: htp.htmlClose;

1381:
1382: htp.tableclose;
1383:
1384: wfa_sec.footer;
1385: htp.htmlClose;
1386:
1387: exception
1388: when others then
1389: Wf_Core.Context('wf_plug', 'edit_worklist_definition',

'||wf_core.translate('ORDERBY')||'');
1289:
1290: htp.tableRowClose;
1291:
1292: htp.tableRowOpen;

Line 1290: htp.tableRowClose;

1286: htp.tableRowOpen(cattributes=>'bgcolor='||icx_plug_utilities.plugbannercolor);
1287:
1288: htp.p('

'||wf_core.translate('ORDERBY')||'');
1289:
1290: htp.tableRowClose;
1291:
1292: htp.tableRowOpen;
1293:
1294: htp.p('
');

Line 1292: htp.tableRowOpen;

1288: htp.p('

'||wf_core.translate('ORDERBY')||'');
1289:
1290: htp.tableRowClose;
1291:
1292: htp.tableRowOpen;
1293:
1294: htp.p('
');
1295:
1296: htp.formSelectOpen('orderkey');

Line 1294: htp.p('
');

1290: htp.tableRowClose;
1291:
1292: htp.tableRowOpen;
1293:
1294: htp.p('

');
1295:
1296: htp.formSelectOpen('orderkey');
1297: for orderby in lkcurs_order('WFSTD_WLORDERBY') loop
1298: if (orderby.lookup_code = l_worklist_definition.order_primary) then

Line 1296: htp.formSelectOpen('orderkey');

1292: htp.tableRowOpen;
1293:
1294: htp.p('

');
1295:
1296: htp.formSelectOpen('orderkey');
1297: for orderby in lkcurs_order('WFSTD_WLORDERBY') loop
1298: if (orderby.lookup_code = l_worklist_definition.order_primary) then
1299: htp.formSelectOption(cvalue=>orderby.meaning,
1300: cselected => 'SELECTED',

Line 1299: htp.formSelectOption(cvalue=>orderby.meaning,

1295:
1296: htp.formSelectOpen('orderkey');
1297: for orderby in lkcurs_order('WFSTD_WLORDERBY') loop
1298: if (orderby.lookup_code = l_worklist_definition.order_primary) then
1299: htp.formSelectOption(cvalue=>orderby.meaning,
1300: cselected => 'SELECTED',
1301: cattributes=>'value='||orderby.lookup_code);
1302: else
1303: htp.formSelectOption(cvalue=>orderby.meaning,

Line 1303: htp.formSelectOption(cvalue=>orderby.meaning,

1299: htp.formSelectOption(cvalue=>orderby.meaning,
1300: cselected => 'SELECTED',
1301: cattributes=>'value='||orderby.lookup_code);
1302: else
1303: htp.formSelectOption(cvalue=>orderby.meaning,
1304: cattributes=>'value='||orderby.lookup_code);
1305: end if;
1306: end loop;
1307:

Line 1308: htp.formSelectClose;

1304: cattributes=>'value='||orderby.lookup_code);
1305: end if;
1306: end loop;
1307:
1308: htp.formSelectClose;
1309:
1310: htp.p('

');

Line 1355: htp.tableRowOpen;

1351:
1352: htp.p('

');
1353: htp.tableOpen; -- OK
1354: -- Add submit button
1355: htp.tableRowOpen;
1356:
1357: htp.p('
');
1358:
1359: icx_plug_utilities.buttonleft(wf_core.translate('WF_EDIT_LONG_OK'),'javascript:document.WFPLUG.submit()', 'FNDJLFOK.gif');

Line 1357: htp.p('
');

1353: htp.tableOpen; -- OK
1354: -- Add submit button
1355: htp.tableRowOpen;
1356:
1357: htp.p('

');
1358:
1359: icx_plug_utilities.buttonleft(wf_core.translate('WF_EDIT_LONG_OK'),'javascript:document.WFPLUG.submit()', 'FNDJLFOK.gif');
1360: -- htp.p(' OK ');
1361:

Line 1360: -- htp.p(' OK ');

1356:
1357: htp.p('

');
1358:
1359: icx_plug_utilities.buttonleft(wf_core.translate('WF_EDIT_LONG_OK'),'javascript:document.WFPLUG.submit()', 'FNDJLFOK.gif');
1360: -- htp.p(' OK ');
1361:
1362: htp.p('
');
1363:
1364:

Line 1362: htp.p('
');

1358:
1359: icx_plug_utilities.buttonleft(wf_core.translate('WF_EDIT_LONG_OK'),'javascript:document.WFPLUG.submit()', 'FNDJLFOK.gif');
1360: -- htp.p(' OK ');
1361:
1362: htp.p('

');
1363:
1364:
1365: -- fixed bug for cancel button
1366: icx_plug_utilities.buttonright(wf_core.translate('CANCEL'),'javascript:history.back()', 'FNDJLFCN.gif');

Line 1369: htp.p('