APPS.WF_ITEM_DEFINITION dependencies on WF_ITEM_TYPES_VL

Line 53: FROM wf_item_types_vl

49: ** List of all item types based no security or admin access
50: */
51: CURSOR admin_itemtypes IS
52: SELECT display_name, name
53: FROM wf_item_types_vl
54: ORDER BY 1;
55:
56: /*
57: ** List of item types based on owner access for a given user.

Line 61: FROM wf_item_types_vl wit, wf_items wik

57: ** List of item types based on owner access for a given user.
58: */
59: CURSOR user_itemtypes IS
60: SELECT distinct wit.display_name, wit.name
61: FROM wf_item_types_vl wit, wf_items wik
62: WHERE wik.owner_role = l_username
63: AND wik.item_type = wit.name
64: ORDER BY 1;
65:

Line 483: l_wf_item_types_vl_tbl wf_item_types_vl_pub.wf_item_types_vl_tbl_type;

479:
480: l_username VARCHAR2(320);
481: l_item_type_display_name VARCHAR2(240) := NULL;
482: l_title VARCHAR2(240) := NULL;
483: l_wf_item_types_vl_tbl wf_item_types_vl_pub.wf_item_types_vl_tbl_type;
484:
485: BEGIN
486:
487: -- Make sure user has signed on

Line 496: wf_item_types_vl_pub.fetch_item_type

492: ** Get the display name for the item type if it was passed in
493: */
494: IF (p_item_type IS NOT NULL) THEN
495:
496: wf_item_types_vl_pub.fetch_item_type
497: (p_item_type,
498: l_wf_item_types_vl_tbl);
499:
500: l_item_type_display_name := '('||l_wf_item_types_vl_tbl(1).display_name||')';

Line 498: l_wf_item_types_vl_tbl);

494: IF (p_item_type IS NOT NULL) THEN
495:
496: wf_item_types_vl_pub.fetch_item_type
497: (p_item_type,
498: l_wf_item_types_vl_tbl);
499:
500: l_item_type_display_name := '('||l_wf_item_types_vl_tbl(1).display_name||')';
501:
502: /*

Line 500: l_item_type_display_name := '('||l_wf_item_types_vl_tbl(1).display_name||')';

496: wf_item_types_vl_pub.fetch_item_type
497: (p_item_type,
498: l_wf_item_types_vl_tbl);
499:
500: l_item_type_display_name := '('||l_wf_item_types_vl_tbl(1).display_name||')';
501:
502: /*
503: ** Add the effective date to the item type display name
504: ** if it was passed in

Line 594: l_wf_item_types_vl_tbl wf_item_types_vl_pub.wf_item_types_vl_tbl_type;

590: l_item_type VARCHAR2(30);
591: l_username VARCHAR2(320);
592: l_expected_format VARCHAR2(80);
593:
594: l_wf_item_types_vl_tbl wf_item_types_vl_pub.wf_item_types_vl_tbl_type;
595: l_wf_item_attributes_vl_tbl wf_item_attributes_vl_pub.wf_item_attributes_vl_tbl_type;
596: l_wf_activities_vl_tbl wf_activities_vl_pub.wf_activities_vl_tbl_type;
597: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
598: l_wf_messages_vl_tbl wf_messages_vl_pub.wf_messages_vl_tbl_type;

Line 626: wf_item_types_vl_pub.fetch_item_type

622:
623: /*
624: ** Get all the information about this item type
625: */
626: wf_item_types_vl_pub.fetch_item_type
627: (l_item_type,
628: l_wf_item_types_vl_tbl);
629:
630:

Line 628: l_wf_item_types_vl_tbl);

624: ** Get all the information about this item type
625: */
626: wf_item_types_vl_pub.fetch_item_type
627: (l_item_type,
628: l_wf_item_types_vl_tbl);
629:
630:
631: /*
632: ** Fetch all the item attributes associtated with this item type

Line 686: wf_item_types_vl_pub.draw_item_type_list

682:
683: /*
684: ** List all the item type names
685: */
686: wf_item_types_vl_pub.draw_item_type_list
687: (l_wf_item_types_vl_tbl,
688: l_effective_date,
689: 0);
690:

Line 687: (l_wf_item_types_vl_tbl,

683: /*
684: ** List all the item type names
685: */
686: wf_item_types_vl_pub.draw_item_type_list
687: (l_wf_item_types_vl_tbl,
688: l_effective_date,
689: 0);
690:
691: /*

Line 765: l_wf_item_types_vl_tbl wf_item_types_vl_pub.wf_item_types_vl_tbl_type;

761: l_username VARCHAR2(320);
762: l_item_type VARCHAR2(30);
763: l_expected_format VARCHAR2(80);
764:
765: l_wf_item_types_vl_tbl wf_item_types_vl_pub.wf_item_types_vl_tbl_type;
766: l_wf_item_attributes_vl_tbl wf_item_attributes_vl_pub.wf_item_attributes_vl_tbl_type;
767: l_wf_activities_vl_tbl wf_activities_vl_pub.wf_activities_vl_tbl_type;
768: l_wf_activity_attr_vl_tbl wf_activities_vl_pub.wf_activity_attr_vl_tbl_type;
769: l_wf_messages_vl_tbl wf_messages_vl_pub.wf_messages_vl_tbl_type;

Line 797: wf_item_types_vl_pub.fetch_item_type

793:
794: /*
795: ** Get all the information about this item type
796: */
797: wf_item_types_vl_pub.fetch_item_type
798: (l_item_type,
799: l_wf_item_types_vl_tbl);
800:
801: /*

Line 799: l_wf_item_types_vl_tbl);

795: ** Get all the information about this item type
796: */
797: wf_item_types_vl_pub.fetch_item_type
798: (l_item_type,
799: l_wf_item_types_vl_tbl);
800:
801: /*
802: ** Fetch all the item attributes associtated with this item type
803: */

Line 849: wf_item_types_vl_pub.draw_item_type_details

845:
846: /*
847: ** List all the item type details
848: */
849: wf_item_types_vl_pub.draw_item_type_details
850: (l_wf_item_types_vl_tbl,
851: 1);
852:
853: /*

Line 850: (l_wf_item_types_vl_tbl,

846: /*
847: ** List all the item type details
848: */
849: wf_item_types_vl_pub.draw_item_type_details
850: (l_wf_item_types_vl_tbl,
851: 1);
852:
853: /*
854: ** Finish off the list with a couple of blank rows