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.WF_ACTIVITIES_VL_PUB dependencies on WF_ACTIVITIES_VL

Line 1: PACKAGE BODY wf_activities_vl_pub AS

1: PACKAGE BODY wf_activities_vl_pub AS
2: /* $Header: wfdefb.pls 120.1 2005/07/02 03:43:48 appldev ship $ */
3:
4: /*===========================================================================
5: PACKAGE NAME: wf_activities_vl_pub

Line 5: PACKAGE NAME: wf_activities_vl_pub

1: PACKAGE BODY wf_activities_vl_pub AS
2: /* $Header: wfdefb.pls 120.1 2005/07/02 03:43:48 appldev ship $ */
3:
4: /*===========================================================================
5: PACKAGE NAME: wf_activities_vl_pub
6:
7: DESCRIPTION:
8:
9: OWNER: GKELLNER

Line 22: into a p_wf_activities_vl_tbl table and a

18: PROCEDURE NAME: fetch_activities
19:
20: DESCRIPTION: Fetches all the activities and each activities
21: associate attributes for a given item type
22: into a p_wf_activities_vl_tbl table and a
23: p_wf_activity_attr_vl_tbl table based on the
24: item type internal eight character name and the
25: effective_date for the activities. This function
26: can retrieve just one type of activity list like only

Line 36: The p_wf_activities_vl_tbl table and the

32: useful if you wish to display the details for a
33: single activity when it is referenced from some
34: drilldown mechanism.
35:
36: The p_wf_activities_vl_tbl table and the
37: p_wf_activity_attr_vl_tbl table are synchronized by
38: the select order of both queries. The
39: draw_activity_list and draw_activity_details functions
40: take advantage of this ordering for performance reasons

Line 54: p_wf_activities_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activities_vl_tbl_type,

50: (p_item_type IN VARCHAR2,
51: p_activity_type IN VARCHAR2,
52: p_effective_date IN DATE,
53: p_name IN VARCHAR2,
54: p_wf_activities_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activities_vl_tbl_type,
55: p_wf_activity_attr_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activity_attr_vl_tbl_type) IS
56:
57: /*===========================================================================
58:

Line 55: p_wf_activity_attr_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activity_attr_vl_tbl_type) IS

51: p_activity_type IN VARCHAR2,
52: p_effective_date IN DATE,
53: p_name IN VARCHAR2,
54: p_wf_activities_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activities_vl_tbl_type,
55: p_wf_activity_attr_vl_tbl OUT NOCOPY wf_activities_vl_pub.wf_activity_attr_vl_tbl_type) IS
56:
57: /*===========================================================================
58:
59: CURSOR NAME: fetch_typed_activities

Line 118: FROM wf_activities_vl

114: display_name,
115: display_name result_type_display_name,
116: display_name message_display_name,
117: description
118: FROM wf_activities_vl
119: WHERE item_type = c_item_type
120: AND type = c_type
121: AND begin_date <= c_effective_date
122: AND (end_date is null or

Line 183: FROM wf_activities_vl

179: display_name,
180: display_name result_type_display_name,
181: display_name message_display_name,
182: description
183: FROM wf_activities_vl
184: WHERE item_type = c_item_type
185: AND begin_date <= c_effective_date
186: AND (end_date is null or
187: end_date > c_effective_date)

Line 262: wf_activities_vl wact

258: waa.date_default,
259: waa.display_name,
260: waa.description
261: FROM wf_activity_attributes_vl waa,
262: wf_activities_vl wact
263: WHERE waa.activity_item_type = c_item_type
264: AND wact.item_type = c_item_type
265: AND wact.name = waa.activity_name
266: AND wact.version = waa.activity_version

Line 326: INTO p_wf_activities_vl_tbl(1)

322: display_name,
323: display_name result_type_display_name,
324: display_name message_display_name,
325: description
326: INTO p_wf_activities_vl_tbl(1)
327: FROM wf_activities_vl
328: WHERE item_type = p_item_type
329: AND type = p_activity_type
330: AND name = p_name

Line 327: FROM wf_activities_vl

323: display_name result_type_display_name,
324: display_name message_display_name,
325: description
326: INTO p_wf_activities_vl_tbl(1)
327: FROM wf_activities_vl
328: WHERE item_type = p_item_type
329: AND type = p_activity_type
330: AND name = p_name
331: AND begin_date <= p_effective_date

Line 340: IF (NVL(p_wf_activities_vl_tbl(1).result_type,

336: /*
337: ** Get the display name for the result type for this activity and
338: ** put it in the result_type_display_name field
339: */
340: IF (NVL(p_wf_activities_vl_tbl(1).result_type,
341: '*') <> '*') THEN
342:
343: wf_lookup_types_pub.fetch_lookup_display(
344: p_wf_activities_vl_tbl(1).result_type,

Line 344: p_wf_activities_vl_tbl(1).result_type,

340: IF (NVL(p_wf_activities_vl_tbl(1).result_type,
341: '*') <> '*') THEN
342:
343: wf_lookup_types_pub.fetch_lookup_display(
344: p_wf_activities_vl_tbl(1).result_type,
345: null,
346: p_wf_activities_vl_tbl(1).result_type_display_name,
347: l_throwaway);
348:

Line 346: p_wf_activities_vl_tbl(1).result_type_display_name,

342:
343: wf_lookup_types_pub.fetch_lookup_display(
344: p_wf_activities_vl_tbl(1).result_type,
345: null,
346: p_wf_activities_vl_tbl(1).result_type_display_name,
347: l_throwaway);
348:
349: END IF;
350:

Line 356: IF (p_wf_activities_vl_tbl(1).message IS NOT NULL) THEN

352: ** If this is a notification activity and the message is populated
353: ** then go get the display name for the message and put it in
354: ** message_display_name
355: */
356: IF (p_wf_activities_vl_tbl(1).message IS NOT NULL) THEN
357:
358: wf_messages_vl_pub.fetch_message_display (
359: p_wf_activities_vl_tbl(1).item_type,
360: p_wf_activities_vl_tbl(1).message,

Line 359: p_wf_activities_vl_tbl(1).item_type,

355: */
356: IF (p_wf_activities_vl_tbl(1).message IS NOT NULL) THEN
357:
358: wf_messages_vl_pub.fetch_message_display (
359: p_wf_activities_vl_tbl(1).item_type,
360: p_wf_activities_vl_tbl(1).message,
361: p_wf_activities_vl_tbl(1).message_display_name);
362:
363: END IF;

Line 360: p_wf_activities_vl_tbl(1).message,

356: IF (p_wf_activities_vl_tbl(1).message IS NOT NULL) THEN
357:
358: wf_messages_vl_pub.fetch_message_display (
359: p_wf_activities_vl_tbl(1).item_type,
360: p_wf_activities_vl_tbl(1).message,
361: p_wf_activities_vl_tbl(1).message_display_name);
362:
363: END IF;
364:

Line 361: p_wf_activities_vl_tbl(1).message_display_name);

357:
358: wf_messages_vl_pub.fetch_message_display (
359: p_wf_activities_vl_tbl(1).item_type,
360: p_wf_activities_vl_tbl(1).message,
361: p_wf_activities_vl_tbl(1).message_display_name);
362:
363: END IF;
364:
365: /*

Line 377: ** for the given item_type filling in the p_wf_activities_vl_tbl

373: p_effective_date);
374:
375: /*
376: ** Loop through the specific type of activity row
377: ** for the given item_type filling in the p_wf_activities_vl_tbl
378: */
379: LOOP
380:
381: l_record_num := l_record_num + 1;

Line 383: FETCH fetch_typed_activities INTO p_wf_activities_vl_tbl(l_record_num);

379: LOOP
380:
381: l_record_num := l_record_num + 1;
382:
383: FETCH fetch_typed_activities INTO p_wf_activities_vl_tbl(l_record_num);
384:
385: EXIT WHEN fetch_typed_activities%NOTFOUND;
386:
387: /*

Line 391: IF (NVL(p_wf_activities_vl_tbl(l_record_num).result_type,

387: /*
388: ** Get the display name for the result type for this activity and
389: ** put it in the result_type_display_name field
390: */
391: IF (NVL(p_wf_activities_vl_tbl(l_record_num).result_type,
392: '*') <> '*') THEN
393:
394: wf_lookup_types_pub.fetch_lookup_display(
395: p_wf_activities_vl_tbl(l_record_num).result_type,

Line 395: p_wf_activities_vl_tbl(l_record_num).result_type,

391: IF (NVL(p_wf_activities_vl_tbl(l_record_num).result_type,
392: '*') <> '*') THEN
393:
394: wf_lookup_types_pub.fetch_lookup_display(
395: p_wf_activities_vl_tbl(l_record_num).result_type,
396: null,
397: p_wf_activities_vl_tbl(l_record_num).result_type_display_name,
398: l_throwaway);
399:

Line 397: p_wf_activities_vl_tbl(l_record_num).result_type_display_name,

393:
394: wf_lookup_types_pub.fetch_lookup_display(
395: p_wf_activities_vl_tbl(l_record_num).result_type,
396: null,
397: p_wf_activities_vl_tbl(l_record_num).result_type_display_name,
398: l_throwaway);
399:
400: END IF;
401:

Line 407: IF (p_wf_activities_vl_tbl(l_record_num).message IS NOT NULL) THEN

403: ** If this is a notification activity and the message is populated
404: ** then go get the display name for the message and put it in
405: ** message_display_name
406: */
407: IF (p_wf_activities_vl_tbl(l_record_num).message IS NOT NULL) THEN
408:
409: wf_messages_vl_pub.fetch_message_display (
410: p_wf_activities_vl_tbl(l_record_num).item_type,
411: p_wf_activities_vl_tbl(l_record_num).message,

Line 410: p_wf_activities_vl_tbl(l_record_num).item_type,

406: */
407: IF (p_wf_activities_vl_tbl(l_record_num).message IS NOT NULL) THEN
408:
409: wf_messages_vl_pub.fetch_message_display (
410: p_wf_activities_vl_tbl(l_record_num).item_type,
411: p_wf_activities_vl_tbl(l_record_num).message,
412: p_wf_activities_vl_tbl(l_record_num).message_display_name);
413:
414: END IF;

Line 411: p_wf_activities_vl_tbl(l_record_num).message,

407: IF (p_wf_activities_vl_tbl(l_record_num).message IS NOT NULL) THEN
408:
409: wf_messages_vl_pub.fetch_message_display (
410: p_wf_activities_vl_tbl(l_record_num).item_type,
411: p_wf_activities_vl_tbl(l_record_num).message,
412: p_wf_activities_vl_tbl(l_record_num).message_display_name);
413:
414: END IF;
415:

Line 412: p_wf_activities_vl_tbl(l_record_num).message_display_name);

408:
409: wf_messages_vl_pub.fetch_message_display (
410: p_wf_activities_vl_tbl(l_record_num).item_type,
411: p_wf_activities_vl_tbl(l_record_num).message,
412: p_wf_activities_vl_tbl(l_record_num).message_display_name);
413:
414: END IF;
415:
416: END LOOP;

Line 427: ** filling in the p_wf_activities_vl_tbl

423: p_effective_date);
424:
425: /*
426: ** Loop through all the activitiy rows for the given item_type
427: ** filling in the p_wf_activities_vl_tbl
428: */
429: LOOP
430:
431: l_record_num := l_record_num + 1;

Line 433: FETCH fetch_all_activities INTO p_wf_activities_vl_tbl(l_record_num);

429: LOOP
430:
431: l_record_num := l_record_num + 1;
432:
433: FETCH fetch_all_activities INTO p_wf_activities_vl_tbl(l_record_num);
434: EXIT WHEN fetch_all_activities%NOTFOUND;
435:
436: /*
437: ** Get the display name for the result type for this activity and

Line 440: IF (NVL(p_wf_activities_vl_tbl(l_record_num).result_type,

436: /*
437: ** Get the display name for the result type for this activity and
438: ** put it in the result_type_display_name field
439: */
440: IF (NVL(p_wf_activities_vl_tbl(l_record_num).result_type,
441: '*') <> '*') THEN
442:
443: wf_lookup_types_pub.fetch_lookup_display(
444: p_wf_activities_vl_tbl(l_record_num).result_type,

Line 444: p_wf_activities_vl_tbl(l_record_num).result_type,

440: IF (NVL(p_wf_activities_vl_tbl(l_record_num).result_type,
441: '*') <> '*') THEN
442:
443: wf_lookup_types_pub.fetch_lookup_display(
444: p_wf_activities_vl_tbl(l_record_num).result_type,
445: null,
446: p_wf_activities_vl_tbl(l_record_num).result_type_display_name,
447: l_throwaway);
448:

Line 446: p_wf_activities_vl_tbl(l_record_num).result_type_display_name,

442:
443: wf_lookup_types_pub.fetch_lookup_display(
444: p_wf_activities_vl_tbl(l_record_num).result_type,
445: null,
446: p_wf_activities_vl_tbl(l_record_num).result_type_display_name,
447: l_throwaway);
448:
449: END IF;
450:

Line 456: IF (p_wf_activities_vl_tbl(l_record_num).message IS NOT NULL) THEN

452: ** If this is a notification activity and the message is populated
453: ** then go get the display name for the message and put it in
454: ** message_display_name
455: */
456: IF (p_wf_activities_vl_tbl(l_record_num).message IS NOT NULL) THEN
457:
458: wf_messages_vl_pub.fetch_message_display (
459: p_wf_activities_vl_tbl(l_record_num).item_type,
460: p_wf_activities_vl_tbl(l_record_num).message,

Line 459: p_wf_activities_vl_tbl(l_record_num).item_type,

455: */
456: IF (p_wf_activities_vl_tbl(l_record_num).message IS NOT NULL) THEN
457:
458: wf_messages_vl_pub.fetch_message_display (
459: p_wf_activities_vl_tbl(l_record_num).item_type,
460: p_wf_activities_vl_tbl(l_record_num).message,
461: p_wf_activities_vl_tbl(l_record_num).message_display_name);
462:
463: END IF;

Line 460: p_wf_activities_vl_tbl(l_record_num).message,

456: IF (p_wf_activities_vl_tbl(l_record_num).message IS NOT NULL) THEN
457:
458: wf_messages_vl_pub.fetch_message_display (
459: p_wf_activities_vl_tbl(l_record_num).item_type,
460: p_wf_activities_vl_tbl(l_record_num).message,
461: p_wf_activities_vl_tbl(l_record_num).message_display_name);
462:
463: END IF;
464:

Line 461: p_wf_activities_vl_tbl(l_record_num).message_display_name);

457:
458: wf_messages_vl_pub.fetch_message_display (
459: p_wf_activities_vl_tbl(l_record_num).item_type,
460: p_wf_activities_vl_tbl(l_record_num).message,
461: p_wf_activities_vl_tbl(l_record_num).message_display_name);
462:
463: END IF;
464:
465: END LOOP;

Line 476: ** filling in the p_wf_activities_vl_tbl

472: l_record_num := 0;
473:
474: /*
475: ** Loop through all the activitiy rows for the given item_type
476: ** filling in the p_wf_activities_vl_tbl
477: */
478: LOOP
479:
480: l_record_num := l_record_num + 1;

Line 524: Wf_Core.Context('wf_activities_vl_pub',

520: END IF;
521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: Wf_Core.Context('wf_activities_vl_pub',
525: 'fetch_activities',
526: p_item_type,
527: p_activity_type,
528: TO_CHAR(p_effective_date),

Line 552: l_wf_activities_vl_tbl wf_activities_vl_pub.wf_activities_vl_tbl_type;

548: p_effective_date IN VARCHAR2,
549: p_name IN VARCHAR2) IS
550:
551: l_username varchar2(320); -- Username to query
552: l_wf_activities_vl_tbl wf_activities_vl_pub.wf_activities_vl_tbl_type;
553: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
554: l_effective_date DATE;
555: l_date_date DATE;
556: l_valid_date BOOLEAN;

Line 553: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;

549: p_name IN VARCHAR2) IS
550:
551: l_username varchar2(320); -- Username to query
552: l_wf_activities_vl_tbl wf_activities_vl_pub.wf_activities_vl_tbl_type;
553: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
554: l_effective_date DATE;
555: l_date_date DATE;
556: l_valid_date BOOLEAN;
557: l_print_date VARCHAR2(80);

Line 601: wf_activities_vl_pub.fetch_activities

597:
598: /*
599: ** Get the activity definition
600: */
601: wf_activities_vl_pub.fetch_activities
602: (p_item_type,
603: p_activity_type,
604: l_effective_date,
605: p_name,

Line 606: l_wf_activities_vl_tbl,

602: (p_item_type,
603: p_activity_type,
604: l_effective_date,
605: p_name,
606: l_wf_activities_vl_tbl,
607: l_wf_activity_attr_vl_tbl);
608:
609: /*
610: ** Draw the activity definition details

Line 612: wf_activities_vl_pub.draw_activity_details

608:
609: /*
610: ** Draw the activity definition details
611: */
612: wf_activities_vl_pub.draw_activity_details
613: (l_wf_activities_vl_tbl,
614: l_wf_activity_attr_vl_tbl,
615: l_effective_date,
616: 0,

Line 613: (l_wf_activities_vl_tbl,

609: /*
610: ** Draw the activity definition details
611: */
612: wf_activities_vl_pub.draw_activity_details
613: (l_wf_activities_vl_tbl,
614: l_wf_activity_attr_vl_tbl,
615: l_effective_date,
616: 0,
617: FALSE,

Line 622: Wf_Core.Context('wf_activities_vl_pub',

618: FALSE);
619:
620: EXCEPTION
621: WHEN OTHERS THEN
622: Wf_Core.Context('wf_activities_vl_pub',
623: 'fetch_draw_activity_details',
624: p_item_type,
625: p_activity_type,
626: p_effective_date,

Line 652: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,

648: using the draw_activity_attr_list.
649:
650: ============================================================================*/
651: PROCEDURE draw_activity_list
652: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,
653: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
654: p_effective_date IN DATE,
655: p_indent_level IN NUMBER) IS
656:

Line 653: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,

649:
650: ============================================================================*/
651: PROCEDURE draw_activity_list
652: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,
653: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
654: p_effective_date IN DATE,
655: p_indent_level IN NUMBER) IS
656:
657: l_activity_record_num NUMBER := 1;

Line 664: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;

660: l_highest_activity NUMBER := 1;
661: ii NUMBER := 0;
662: l_activity_type VARCHAR2(8);
663: l_summary_section_title VARCHAR2(240);
664: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
665:
666: BEGIN
667:
668: l_activity_type := 'UNSET';

Line 673: FOR l_activity_record_num IN 1..p_wf_activities_vl_tbl.count LOOP

669:
670: /*
671: ** Print out all item attribute display names in the pl*sql table
672: */
673: FOR l_activity_record_num IN 1..p_wf_activities_vl_tbl.count LOOP
674:
675: /*
676: ** Check to see if the activity type has changed since the last
677: ** that you printed. If so then create the title. If this is a \

Line 681: IF (l_activity_type <> p_wf_activities_vl_tbl(l_activity_record_num).type AND

677: ** that you printed. If so then create the title. If this is a \
678: ** special type of activity like a folder then
679: ** don't reset your context
680: */
681: IF (l_activity_type <> p_wf_activities_vl_tbl(l_activity_record_num).type AND
682: p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN
683:
684: /*
685: ** Reset the activity type to the local name

Line 682: p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN

678: ** special type of activity like a folder then
679: ** don't reset your context
680: */
681: IF (l_activity_type <> p_wf_activities_vl_tbl(l_activity_record_num).type AND
682: p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN
683:
684: /*
685: ** Reset the activity type to the local name
686: */

Line 687: l_activity_type := p_wf_activities_vl_tbl(l_activity_record_num).type;

683:
684: /*
685: ** Reset the activity type to the local name
686: */
687: l_activity_type := p_wf_activities_vl_tbl(l_activity_record_num).type;
688:
689: /*
690: ** The type has changed so print the proper title
691: */

Line 791: IF (p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN

787: /*
788: ** If this is a special type of activity like a folder then
789: ** don't show it in the list
790: */
791: IF (p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN
792:
793: /*
794: ** The creation of the anchor from the summary frame to the detail
795: ** frame was very complex so I've extracted the function into its

Line 799: p_wf_activities_vl_tbl(l_activity_record_num).item_type,

795: ** frame was very complex so I've extracted the function into its
796: ** own routine.
797: */
798: wf_item_definition_util_pub.create_hotlink_to_details (
799: p_wf_activities_vl_tbl(l_activity_record_num).item_type,
800: p_effective_date,
801: l_activity_type,
802: p_wf_activities_vl_tbl(l_activity_record_num).name,
803: p_wf_activities_vl_tbl(l_activity_record_num).display_name,

Line 802: p_wf_activities_vl_tbl(l_activity_record_num).name,

798: wf_item_definition_util_pub.create_hotlink_to_details (
799: p_wf_activities_vl_tbl(l_activity_record_num).item_type,
800: p_effective_date,
801: l_activity_type,
802: p_wf_activities_vl_tbl(l_activity_record_num).name,
803: p_wf_activities_vl_tbl(l_activity_record_num).display_name,
804: NULL,
805: p_indent_level+1);
806:

Line 803: p_wf_activities_vl_tbl(l_activity_record_num).display_name,

799: p_wf_activities_vl_tbl(l_activity_record_num).item_type,
800: p_effective_date,
801: l_activity_type,
802: p_wf_activities_vl_tbl(l_activity_record_num).name,
803: p_wf_activities_vl_tbl(l_activity_record_num).display_name,
804: NULL,
805: p_indent_level+1);
806:
807: /*

Line 829: p_wf_activities_vl_tbl(l_activity_record_num).type =

825: ** will cause a 6502-PL*SQL numeric or value error exception.
826: */
827: WHILE (
828: l_attr_record_num <= p_wf_activity_attr_vl_tbl.count AND
829: p_wf_activities_vl_tbl(l_activity_record_num).type =
830: p_wf_activity_attr_vl_tbl(l_attr_record_num).activity_type
831: AND p_wf_activities_vl_tbl(l_activity_record_num).display_name =
832: p_wf_activity_attr_vl_tbl(l_attr_record_num).activity_display_name
833: ) LOOP

Line 831: AND p_wf_activities_vl_tbl(l_activity_record_num).display_name =

827: WHILE (
828: l_attr_record_num <= p_wf_activity_attr_vl_tbl.count AND
829: p_wf_activities_vl_tbl(l_activity_record_num).type =
830: p_wf_activity_attr_vl_tbl(l_attr_record_num).activity_type
831: AND p_wf_activities_vl_tbl(l_activity_record_num).display_name =
832: p_wf_activity_attr_vl_tbl(l_attr_record_num).activity_display_name
833: ) LOOP
834:
835: /*

Line 863: wf_activities_vl_pub.draw_activity_attr_list (

859: ** List all the activity attribute details for this message that
860: ** we found above. Add two to the current indent level so it
861: ** is pushed in past the start of the message list.
862: */
863: wf_activities_vl_pub.draw_activity_attr_list (
864: l_wf_activity_attr_vl_tbl,
865: p_effective_date,
866: p_indent_level + 2);
867:

Line 886: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_list');

882: p_indent_level);
883:
884: EXCEPTION
885: WHEN OTHERS THEN
886: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_list');
887: wf_item_definition.Error;
888:
889: END draw_activity_list;
890:

Line 903: (p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,

899: output.
900:
901: ============================================================================*/
902: PROCEDURE draw_activity_attr_list
903: (p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
904: p_effective_date IN DATE,
905: p_indent_level IN NUMBER) IS
906:
907: l_record_num NUMBER;

Line 966: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_list');

962: END LOOP;
963:
964: EXCEPTION
965: WHEN OTHERS THEN
966: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_list');
967: wf_item_definition.Error;
968:
969: END draw_activity_attr_list;
970:

Line 991: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,

987: MODIFICATION LOG:
988: 06-JUN-2001 JWSMITH BUG 1819232 - added summary attr for table tag for ADA
989: ============================================================================*/
990: PROCEDURE draw_activity_details
991: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,
992: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
993: p_effective_date IN DATE,
994: p_indent_level IN NUMBER,
995: p_create_child_links IN BOOLEAN,

Line 992: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,

988: 06-JUN-2001 JWSMITH BUG 1819232 - added summary attr for table tag for ADA
989: ============================================================================*/
990: PROCEDURE draw_activity_details
991: (p_wf_activities_vl_tbl IN wf_activities_vl_pub.wf_activities_vl_tbl_type,
992: p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
993: p_effective_date IN DATE,
994: p_indent_level IN NUMBER,
995: p_create_child_links IN BOOLEAN,
996: p_print_skipped_titles IN BOOLEAN) IS

Line 1015: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;

1011: l_activity_type VARCHAR2(8);
1012: l_end_date VARCHAR2(80);
1013: l_activity_name_prompt VARCHAR2(80);
1014: l_activity_section_title VARCHAR2(240);
1015: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
1016:
1017: BEGIN
1018:
1019: -- Check session and current user

Line 1027: FOR l_activity_record_num IN 1..p_wf_activities_vl_tbl.count LOOP

1023:
1024: /*
1025: ** Print out all item attribute display names in the pl*sql table
1026: */
1027: FOR l_activity_record_num IN 1..p_wf_activities_vl_tbl.count LOOP
1028:
1029: /*
1030: ** Check to see if the activity type has changed since the last
1031: ** that you printed. If so then create the title. If this is a

Line 1035: IF (l_activity_type <> p_wf_activities_vl_tbl(l_activity_record_num).type AND

1031: ** that you printed. If so then create the title. If this is a
1032: ** special type of activity like a folder then
1033: ** don't reset your context
1034: */
1035: IF (l_activity_type <> p_wf_activities_vl_tbl(l_activity_record_num).type AND
1036: p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN
1037:
1038: /*
1039: ** Reset the activity type to the local name

Line 1036: p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN

1032: ** special type of activity like a folder then
1033: ** don't reset your context
1034: */
1035: IF (l_activity_type <> p_wf_activities_vl_tbl(l_activity_record_num).type AND
1036: p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN
1037:
1038: /*
1039: ** Reset the activity type to the local name
1040: */

Line 1041: l_activity_type := p_wf_activities_vl_tbl(l_activity_record_num).type;

1037:
1038: /*
1039: ** Reset the activity type to the local name
1040: */
1041: l_activity_type := p_wf_activities_vl_tbl(l_activity_record_num).type;
1042:
1043: /*
1044: ** The type has changed so print the proper title for the region
1045: **

Line 1171: IF (p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN

1167: /*
1168: ** If this is a special type of activity like a folder then
1169: ** don't print it
1170: */
1171: IF (p_wf_activities_vl_tbl(l_activity_record_num).type <> 'FOLDER') THEN
1172:
1173: /*
1174: ** Open a new table for each attribute so you can control the spacing
1175: ** between each attribute

Line 1186: p_wf_activities_vl_tbl(l_activity_record_num).type,

1182: ** create the first row in the table which is always the display
1183: ** name for the object.
1184: */
1185: wf_item_definition_util_pub.create_details_hotlink_target (
1186: p_wf_activities_vl_tbl(l_activity_record_num).type,
1187: p_wf_activities_vl_tbl(l_activity_record_num).name,
1188: p_wf_activities_vl_tbl(l_activity_record_num).display_name,
1189: l_activity_name_prompt,
1190: 0);

Line 1187: p_wf_activities_vl_tbl(l_activity_record_num).name,

1183: ** name for the object.
1184: */
1185: wf_item_definition_util_pub.create_details_hotlink_target (
1186: p_wf_activities_vl_tbl(l_activity_record_num).type,
1187: p_wf_activities_vl_tbl(l_activity_record_num).name,
1188: p_wf_activities_vl_tbl(l_activity_record_num).display_name,
1189: l_activity_name_prompt,
1190: 0);
1191:

Line 1188: p_wf_activities_vl_tbl(l_activity_record_num).display_name,

1184: */
1185: wf_item_definition_util_pub.create_details_hotlink_target (
1186: p_wf_activities_vl_tbl(l_activity_record_num).type,
1187: p_wf_activities_vl_tbl(l_activity_record_num).name,
1188: p_wf_activities_vl_tbl(l_activity_record_num).display_name,
1189: l_activity_name_prompt,
1190: 0);
1191:
1192: /*

Line 1197: p_wf_activities_vl_tbl(l_activity_record_num).name);

1193: ** Create the internal name row in the table.
1194: */
1195: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1196: wf_core.translate('WFITD_INTERNAL_NAME'),
1197: p_wf_activities_vl_tbl(l_activity_record_num).name);
1198:
1199: /*
1200: ** Create the description row in the table
1201: */

Line 1204: p_wf_activities_vl_tbl(l_activity_record_num).description);

1200: ** Create the description row in the table
1201: */
1202: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1203: wf_core.translate('DESCRIPTION'),
1204: p_wf_activities_vl_tbl(l_activity_record_num).description);
1205:
1206: /*
1207: ** If this is a process or notification activity, only show the function row
1208: ** if the function field is populate. If this is a function activity then

Line 1211: IF ((p_wf_activities_vl_tbl(l_activity_record_num).type = 'PROCESS' AND

1207: ** If this is a process or notification activity, only show the function row
1208: ** if the function field is populate. If this is a function activity then
1209: ** always create the function row
1210: */
1211: IF ((p_wf_activities_vl_tbl(l_activity_record_num).type = 'PROCESS' AND
1212: p_wf_activities_vl_tbl(l_activity_record_num).function IS NOT NULL) OR
1213: p_wf_activities_vl_tbl(l_activity_record_num).type IN ('NOTICE', 'FUNCTION')) THEN
1214:
1215:

Line 1212: p_wf_activities_vl_tbl(l_activity_record_num).function IS NOT NULL) OR

1208: ** if the function field is populate. If this is a function activity then
1209: ** always create the function row
1210: */
1211: IF ((p_wf_activities_vl_tbl(l_activity_record_num).type = 'PROCESS' AND
1212: p_wf_activities_vl_tbl(l_activity_record_num).function IS NOT NULL) OR
1213: p_wf_activities_vl_tbl(l_activity_record_num).type IN ('NOTICE', 'FUNCTION')) THEN
1214:
1215:
1216: wf_item_definition_util_pub.draw_detail_prompt_value_pair (

Line 1213: p_wf_activities_vl_tbl(l_activity_record_num).type IN ('NOTICE', 'FUNCTION')) THEN

1209: ** always create the function row
1210: */
1211: IF ((p_wf_activities_vl_tbl(l_activity_record_num).type = 'PROCESS' AND
1212: p_wf_activities_vl_tbl(l_activity_record_num).function IS NOT NULL) OR
1213: p_wf_activities_vl_tbl(l_activity_record_num).type IN ('NOTICE', 'FUNCTION')) THEN
1214:
1215:
1216: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1217: wf_core.translate('WFITD_FUNCTION'),

Line 1218: p_wf_activities_vl_tbl(l_activity_record_num).function);

1214:
1215:
1216: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1217: wf_core.translate('WFITD_FUNCTION'),
1218: p_wf_activities_vl_tbl(l_activity_record_num).function);
1219:
1220: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1221: wf_core.translate('WFITD_FUNCTION_TYPE'),
1222: NVL(p_wf_activities_vl_tbl(l_activity_record_num).function_type, 'PL/SQL'));

Line 1222: NVL(p_wf_activities_vl_tbl(l_activity_record_num).function_type, 'PL/SQL'));

1218: p_wf_activities_vl_tbl(l_activity_record_num).function);
1219:
1220: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1221: wf_core.translate('WFITD_FUNCTION_TYPE'),
1222: NVL(p_wf_activities_vl_tbl(l_activity_record_num).function_type, 'PL/SQL'));
1223:
1224: END IF;
1225:
1226: /*

Line 1231: IF (NVL(p_wf_activities_vl_tbl(l_activity_record_num).result_type,

1227: ** Create the result type row in the table
1228: ** Do not show the result type field if it is equal to * which
1229: ** occurs when a notification is FYI and doesn't expect a response
1230: */
1231: IF (NVL(p_wf_activities_vl_tbl(l_activity_record_num).result_type,
1232: '*') <> '*') THEN
1233:
1234: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1235: wf_core.translate('WFITD_RESULT_TYPE'),

Line 1236: p_wf_activities_vl_tbl(l_activity_record_num).result_type_display_name);

1232: '*') <> '*') THEN
1233:
1234: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1235: wf_core.translate('WFITD_RESULT_TYPE'),
1236: p_wf_activities_vl_tbl(l_activity_record_num).result_type_display_name);
1237:
1238: END IF;
1239:
1240: /*

Line 1258: WHERE item_type = p_wf_activities_vl_tbl(l_activity_record_num).item_type

1254: */
1255: SELECT count(*)
1256: INTO l_runnable_process
1257: FROM WF_RUNNABLE_PROCESSES_V
1258: WHERE item_type = p_wf_activities_vl_tbl(l_activity_record_num).item_type
1259: AND process_name = p_wf_activities_vl_tbl(l_activity_record_num).name;
1260:
1261: IF (l_runnable_process > 0) THEN
1262:

Line 1259: AND process_name = p_wf_activities_vl_tbl(l_activity_record_num).name;

1255: SELECT count(*)
1256: INTO l_runnable_process
1257: FROM WF_RUNNABLE_PROCESSES_V
1258: WHERE item_type = p_wf_activities_vl_tbl(l_activity_record_num).item_type
1259: AND process_name = p_wf_activities_vl_tbl(l_activity_record_num).name;
1260:
1261: IF (l_runnable_process > 0) THEN
1262:
1263: /*

Line 1292: p_wf_activities_vl_tbl(l_activity_record_num).item_type,

1288: */
1289: IF (p_create_child_links = TRUE) THEN
1290:
1291: wf_item_definition_util_pub.create_hotlink_to_details(
1292: p_wf_activities_vl_tbl(l_activity_record_num).item_type,
1293: p_effective_date,
1294: 'MESSAGE',
1295: p_wf_activities_vl_tbl(l_activity_record_num).message,
1296: p_wf_activities_vl_tbl(l_activity_record_num).message_display_name,

Line 1295: p_wf_activities_vl_tbl(l_activity_record_num).message,

1291: wf_item_definition_util_pub.create_hotlink_to_details(
1292: p_wf_activities_vl_tbl(l_activity_record_num).item_type,
1293: p_effective_date,
1294: 'MESSAGE',
1295: p_wf_activities_vl_tbl(l_activity_record_num).message,
1296: p_wf_activities_vl_tbl(l_activity_record_num).message_display_name,
1297: wf_core.translate('MESSAGE_NAME'),
1298: 0);
1299:

Line 1296: p_wf_activities_vl_tbl(l_activity_record_num).message_display_name,

1292: p_wf_activities_vl_tbl(l_activity_record_num).item_type,
1293: p_effective_date,
1294: 'MESSAGE',
1295: p_wf_activities_vl_tbl(l_activity_record_num).message,
1296: p_wf_activities_vl_tbl(l_activity_record_num).message_display_name,
1297: wf_core.translate('MESSAGE_NAME'),
1298: 0);
1299:
1300: ELSE

Line 1304: p_wf_activities_vl_tbl(l_activity_record_num).message_display_name);

1300: ELSE
1301:
1302: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1303: wf_core.translate('MESSAGE_NAME'),
1304: p_wf_activities_vl_tbl(l_activity_record_num).message_display_name);
1305:
1306: END IF;
1307:
1308: /*

Line 1311: IF (p_wf_activities_vl_tbl(l_activity_record_num).expand_role = 'Y') THEN

1307:
1308: /*
1309: ** Create the expand roles in the table
1310: */
1311: IF (p_wf_activities_vl_tbl(l_activity_record_num).expand_role = 'Y') THEN
1312:
1313: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1314: wf_core.translate('WFITD_EXPAND_ROLES'),
1315: wf_core.translate('WFITD_YES'));

Line 1332: TO_CHAR((p_wf_activities_vl_tbl(l_activity_record_num).cost/100)));

1328: ** Create the cost row in the table
1329: */
1330: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1331: wf_core.translate('WFMON_COST'),
1332: TO_CHAR((p_wf_activities_vl_tbl(l_activity_record_num).cost/100)));
1333:
1334: ELSIF (l_activity_type = 'EVENT') THEN
1335:
1336: /*

Line 1341: p_wf_activities_vl_tbl(l_activity_record_num).event_name);

1337: ** Create the event name and direction rows in the table
1338: */
1339: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1340: wf_core.translate('WFITD_EVENT'),
1341: p_wf_activities_vl_tbl(l_activity_record_num).event_name);
1342: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1343: wf_core.translate('WFITD_DIRECTION'),
1344: p_wf_activities_vl_tbl(l_activity_record_num).direction);
1345:

Line 1344: p_wf_activities_vl_tbl(l_activity_record_num).direction);

1340: wf_core.translate('WFITD_EVENT'),
1341: p_wf_activities_vl_tbl(l_activity_record_num).event_name);
1342: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1343: wf_core.translate('WFITD_DIRECTION'),
1344: p_wf_activities_vl_tbl(l_activity_record_num).direction);
1345:
1346: END IF;
1347:
1348: /*

Line 1353: p_wf_activities_vl_tbl(l_activity_record_num).icon_name);

1349: ** Create the icon name in the table
1350: */
1351: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1352: wf_core.translate('WFITD_ICON'),
1353: p_wf_activities_vl_tbl(l_activity_record_num).icon_name);
1354:
1355: /*
1356: ** Create the error item type name in the table
1357: */

Line 1360: p_wf_activities_vl_tbl(l_activity_record_num).error_item_type);

1356: ** Create the error item type name in the table
1357: */
1358: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1359: wf_core.translate('WFMON_ERROR_TYPE'),
1360: p_wf_activities_vl_tbl(l_activity_record_num).error_item_type);
1361:
1362: /*
1363: ** Create the error process name in the table
1364: */

Line 1367: p_wf_activities_vl_tbl(l_activity_record_num).error_process);

1363: ** Create the error process name in the table
1364: */
1365: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1366: wf_core.translate('WFMON_ERROR_PROCESS'),
1367: p_wf_activities_vl_tbl(l_activity_record_num).error_process);
1368:
1369:
1370: /*
1371: ** Get the expected format for the date. You'll notice that I've

Line 1386: IF (p_wf_activities_vl_tbl(l_activity_record_num).end_date IS NOT NULL) THEN

1382: /*
1383: ** Only populate the l_end_date for the continuation of the effective
1384: ** date if there is an end date otherwise leave it null.
1385: */
1386: IF (p_wf_activities_vl_tbl(l_activity_record_num).end_date IS NOT NULL) THEN
1387:
1388: l_end_date := ' - ' ||
1389: TO_CHAR(p_wf_activities_vl_tbl(l_activity_record_num).end_date,
1390: l_expected_format);

Line 1389: TO_CHAR(p_wf_activities_vl_tbl(l_activity_record_num).end_date,

1385: */
1386: IF (p_wf_activities_vl_tbl(l_activity_record_num).end_date IS NOT NULL) THEN
1387:
1388: l_end_date := ' - ' ||
1389: TO_CHAR(p_wf_activities_vl_tbl(l_activity_record_num).end_date,
1390: l_expected_format);
1391:
1392: ELSE
1393:

Line 1403: TO_CHAR(p_wf_activities_vl_tbl(l_activity_record_num).begin_date,

1399: ** Create the effective date range in the table
1400: */
1401: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1402: wf_core.translate('WFITD_EFFECTIVE'),
1403: TO_CHAR(p_wf_activities_vl_tbl(l_activity_record_num).begin_date,
1404: l_expected_format)|| l_end_date);
1405:
1406: /*
1407: ** Create the loop reset description

Line 1409: IF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'RESET') THEN

1405:
1406: /*
1407: ** Create the loop reset description
1408: */
1409: IF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'RESET') THEN
1410:
1411: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1412: wf_core.translate('WFITD_LOOP_RESET'),
1413: wf_core.translate('WFITD_LOOP_RESET_VALUE'));

Line 1415: ELSIF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'LOOP') THEN

1411: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1412: wf_core.translate('WFITD_LOOP_RESET'),
1413: wf_core.translate('WFITD_LOOP_RESET_VALUE'));
1414:
1415: ELSIF (p_wf_activities_vl_tbl(l_activity_record_num).rerun = 'LOOP') THEN
1416:
1417: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1418: wf_core.translate('WFITD_LOOP_RESET'),
1419: wf_core.translate('WFITD_LOOP_RESET_LOOP'));

Line 1434: p_wf_activities_vl_tbl(l_activity_record_num).version);

1430: ** Create the version row in the table
1431: */
1432: wf_item_definition_util_pub.draw_detail_prompt_value_pair (
1433: wf_core.translate('WFITD_VERSION'),
1434: p_wf_activities_vl_tbl(l_activity_record_num).version);
1435:
1436: /*
1437: ** Call function to print the read/write/execute roles
1438: */

Line 1440: p_wf_activities_vl_tbl(l_activity_record_num).read_role,

1436: /*
1437: ** Call function to print the read/write/execute roles
1438: */
1439: wf_item_definition_util_pub.draw_read_write_exe_details(
1440: p_wf_activities_vl_tbl(l_activity_record_num).read_role,
1441: p_wf_activities_vl_tbl(l_activity_record_num).write_role,
1442: p_wf_activities_vl_tbl(l_activity_record_num).execute_role,
1443: TRUE);
1444:

Line 1441: p_wf_activities_vl_tbl(l_activity_record_num).write_role,

1437: ** Call function to print the read/write/execute roles
1438: */
1439: wf_item_definition_util_pub.draw_read_write_exe_details(
1440: p_wf_activities_vl_tbl(l_activity_record_num).read_role,
1441: p_wf_activities_vl_tbl(l_activity_record_num).write_role,
1442: p_wf_activities_vl_tbl(l_activity_record_num).execute_role,
1443: TRUE);
1444:
1445: /*

Line 1442: p_wf_activities_vl_tbl(l_activity_record_num).execute_role,

1438: */
1439: wf_item_definition_util_pub.draw_read_write_exe_details(
1440: p_wf_activities_vl_tbl(l_activity_record_num).read_role,
1441: p_wf_activities_vl_tbl(l_activity_record_num).write_role,
1442: p_wf_activities_vl_tbl(l_activity_record_num).execute_role,
1443: TRUE);
1444:
1445: /*
1446: ** Call function to print the customization/protection levels

Line 1449: p_wf_activities_vl_tbl(l_activity_record_num).custom_level,

1445: /*
1446: ** Call function to print the customization/protection levels
1447: */
1448: wf_item_definition_util_pub.draw_custom_protect_details(
1449: p_wf_activities_vl_tbl(l_activity_record_num).custom_level,
1450: p_wf_activities_vl_tbl(l_activity_record_num).protect_level);
1451:
1452: /*
1453: ** Table is created so close it out

Line 1450: p_wf_activities_vl_tbl(l_activity_record_num).protect_level);

1446: ** Call function to print the customization/protection levels
1447: */
1448: wf_item_definition_util_pub.draw_custom_protect_details(
1449: p_wf_activities_vl_tbl(l_activity_record_num).custom_level,
1450: p_wf_activities_vl_tbl(l_activity_record_num).protect_level);
1451:
1452: /*
1453: ** Table is created so close it out
1454: */

Line 1478: p_wf_activities_vl_tbl(l_activity_record_num).type =

1474: ** will cause a 6502-PL*SQL numeric or value error exception.
1475: */
1476: WHILE (
1477: l_attr_record_num <= p_wf_activity_attr_vl_tbl.count AND
1478: p_wf_activities_vl_tbl(l_activity_record_num).type =
1479: p_wf_activity_attr_vl_tbl(l_attr_record_num).activity_type
1480: AND p_wf_activities_vl_tbl(l_activity_record_num).display_name =
1481: p_wf_activity_attr_vl_tbl(l_attr_record_num).activity_display_name
1482: ) LOOP

Line 1480: AND p_wf_activities_vl_tbl(l_activity_record_num).display_name =

1476: WHILE (
1477: l_attr_record_num <= p_wf_activity_attr_vl_tbl.count AND
1478: p_wf_activities_vl_tbl(l_activity_record_num).type =
1479: p_wf_activity_attr_vl_tbl(l_attr_record_num).activity_type
1480: AND p_wf_activities_vl_tbl(l_activity_record_num).display_name =
1481: p_wf_activity_attr_vl_tbl(l_attr_record_num).activity_display_name
1482: ) LOOP
1483:
1484: /*

Line 1516: wf_activities_vl_pub.draw_activity_attr_details (

1512: /*
1513: ** List all the activity attribute details for this activity that
1514: ** we found above.
1515: */
1516: wf_activities_vl_pub.draw_activity_attr_details (
1517: l_wf_activity_attr_vl_tbl,
1518: 1);
1519:
1520: /*

Line 1525: IF (l_activity_record_num < p_wf_activities_vl_tbl.count AND

1521: ** If you still have more activities to process and the next activity is
1522: ** the same type as the current one then put in a
1523: ** few blank lines and put in another Activity Details Header
1524: */
1525: IF (l_activity_record_num < p_wf_activities_vl_tbl.count AND
1526: l_activity_type = p_wf_activities_vl_tbl(l_activity_record_num + 1).type) THEN
1527:
1528: /*
1529: ** Put in a couple of blank lines between the current activity

Line 1526: l_activity_type = p_wf_activities_vl_tbl(l_activity_record_num + 1).type) THEN

1522: ** the same type as the current one then put in a
1523: ** few blank lines and put in another Activity Details Header
1524: */
1525: IF (l_activity_record_num < p_wf_activities_vl_tbl.count AND
1526: l_activity_type = p_wf_activities_vl_tbl(l_activity_record_num + 1).type) THEN
1527:
1528: /*
1529: ** Put in a couple of blank lines between the current activity
1530: ** attributes and the next activity

Line 1552: IF (l_activity_record_num < p_wf_activities_vl_tbl.count AND

1548: ** if this is not the last item in the list and if there
1549: ** are no attributes in the attribute list for this activity and
1550: ** there are more activities of the same type
1551: */
1552: IF (l_activity_record_num < p_wf_activities_vl_tbl.count AND
1553: l_cur_attr_record_num = 1 AND
1554: l_activity_type = p_wf_activities_vl_tbl(l_activity_record_num + 1).type) THEN
1555:
1556: htp.p ('

');

Line 1554: l_activity_type = p_wf_activities_vl_tbl(l_activity_record_num + 1).type) THEN

1550: ** there are more activities of the same type
1551: */
1552: IF (l_activity_record_num < p_wf_activities_vl_tbl.count AND
1553: l_cur_attr_record_num = 1 AND
1554: l_activity_type = p_wf_activities_vl_tbl(l_activity_record_num + 1).type) THEN
1555:
1556: htp.p ('

');
1557:
1558: END IF;

Line 1579: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_details');

1575: END IF;
1576:
1577: EXCEPTION
1578: WHEN OTHERS THEN
1579: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_details');
1580: wf_item_definition.Error;
1581:
1582: END draw_activity_details;
1583:

Line 1595: (p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,

1591: MODIFICATION LOG:
1592: 06-JUN-2001 JWSMITH BUG 1819232 - added summary attr for table tag for ADA
1593: ============================================================================*/
1594: PROCEDURE draw_activity_attr_details
1595: (p_wf_activity_attr_vl_tbl IN wf_activities_vl_pub.wf_activity_attr_vl_tbl_type,
1596: p_indent_level IN NUMBER) IS
1597:
1598: l_record_num NUMBER;
1599: ii NUMBER := 0;

Line 1819: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_details');

1815: END LOOP;
1816:
1817: EXCEPTION
1818: WHEN OTHERS THEN
1819: Wf_Core.Context('wf_activities_vl_pub', 'draw_activity_attr_details');
1820: wf_item_definition.Error;
1821:
1822: END draw_activity_attr_details;
1823:

Line 1824: END wf_activities_vl_pub;

1820: wf_item_definition.Error;
1821:
1822: END draw_activity_attr_details;
1823:
1824: END wf_activities_vl_pub;