1 PACKAGE wf_item_types_vl_pub AUTHID CURRENT_USER AS
2 /* $Header: wfdefs.pls 115.18 2002/12/03 01:12:21 dlam ship $ */
3
4
5 /*===========================================================================
6 PACKAGE NAME: wf_item_types_vl_pub
7
8 DESCRIPTION:
9
10 OWNER: GKELLNER
11
12 TABLES/RECORDS:
13
14 PROCEDURES/FUNCTIONS:
15
16 MODIFICATION LOG: 01/2002 JWSMITH BUG 2001012 - Increase read_role,
17 write_role, execute_role to varchar2(320)
18
19 ============================================================================*/
20
21 /*===========================================================================
22
23 PL*SQL TABLE NAME: wf_item_types_vl_tbl_type
24
25 DESCRIPTION: Stores a list of item types or workflow definitions.
26 Typically you will only ever have one row in
27 this table as it is the master for all the objects
28 within this workflow definition.
29
30 ============================================================================*/
31
32 TYPE wf_item_types_vl_rec_type IS RECORD
33 (
34 ROW_ID ROWID,
35 NAME VARCHAR2(8),
36 PROTECT_LEVEL NUMBER,
37 CUSTOM_LEVEL NUMBER,
38 WF_SELECTOR VARCHAR2(240),
39 READ_ROLE VARCHAR2(320),
40 WRITE_ROLE VARCHAR2(320),
41 EXECUTE_ROLE VARCHAR2(320),
42 DISPLAY_NAME VARCHAR2(80),
43 DESCRIPTION VARCHAR2(240)
44 );
45
46 TYPE wf_item_types_vl_tbl_type IS TABLE OF
47 wf_item_types_vl_pub.wf_item_types_vl_rec_type
48 INDEX BY BINARY_INTEGER;
49
50
51 /*===========================================================================
52 PROCEDURE NAME: fetch_item_type
53
54 DESCRIPTION: Fetches all the properties of a given item type
55 into a wf_item_types_vl_tbl_type table based on the
56 item type internal eight character name.
57
58 PARAMETERS:
59
60 p_name IN Internal name of the item type
61
62 p_wf_item_types_vl_tbl OUT
63 The pl*sql table with the detailed definition of
64 the item type
65
66 ============================================================================*/
67 PROCEDURE fetch_item_type
68 (p_name IN VARCHAR2,
69 p_wf_item_types_vl_tbl OUT NOCOPY wf_item_types_vl_pub.wf_item_types_vl_tbl_type);
70
71 /*===========================================================================
72 PROCEDURE NAME: draw_item_type_list
73
74 DESCRIPTION: Shows the display name of an item type as a
75 html view as a part of a hierical summary list of
76 an item type. This function uses the htp to
77 generate its html output.
78
79 PARAMETERS:
80
81 p_wf_item_types_vl_tbl IN
82 The pl*sql table with the detailed definition of
83 the item type
84
85 p_effective_date IN
86 The effective date that was requested.
87 This is required if you would like to create
88 hotlinks between a summary frame view and your
89 detail frame view. Since the listing are usually
90 implemented as frames the links need to include
91 all the attributes that were used to generate those
92 frames.
93
94 p_indent_level IN
95 How many spaces would you like to indent this
96 listing from the left border of the screen.
97
98 ============================================================================*/
99 PROCEDURE draw_item_type_list
100 (p_wf_item_types_vl_tbl
101 IN wf_item_types_vl_pub.wf_item_types_vl_tbl_type,
102 p_effective_date IN DATE,
103 p_indent_level IN NUMBER);
104
105 /*===========================================================================
106 PROCEDURE NAME: draw_item_type_details
107
108 DESCRIPTION: Shows all the details of an item type as a
109 html view. This function uses the htp to
110 generate its html output.
111
112 PARAMETERS:
113
114 p_wf_item_types_vl_tbl IN
115 The pl*sql table with the detailed definition of
116 the item type
117
118 p_indent_level IN
119 How many space would you like to indent this
120 listing from the left border of the screen.
121
122 ============================================================================*/
123 PROCEDURE draw_item_type_details
124 (p_wf_item_types_vl_tbl IN wf_item_types_vl_pub.wf_item_types_vl_tbl_type,
125 p_indent_level IN NUMBER);
126
127
128 END wf_item_types_vl_pub;