DBA Data[Home] [Help]

APPS.WF_ITEM_DEFINITION dependencies on WF_ITEM_TYPES_VL_PUB

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 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 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 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 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: /*