1 PACKAGE wf_route AS
2 /* $Header: wfrtgs.pls 120.2 2006/04/06 09:29:13 rwunderl ship $ */
3
4 --
5 -- Types
6 --
7 -- Complex name#type identifiers from the web page
8 type name_array is table of varchar2(240) index by binary_integer;
9
10 -- Values from the web page.
11 type value_array is table of varchar2(4000) index by binary_integer;
12
13
14 --
15 -- DeleteRule
16 -- Delete rule with ruleid
17 -- IN
18 -- ruleid - Rule id
19 --
20 procedure DeleteRule(
21 user in varchar2 default null,
22 ruleid in varchar2);
23
24 -- SubmitUpdate
25 -- Process rule update page
26 -- IN
27 -- ruleid - Rule id
28 -- action - Rule action
29 -- action_argument - Forward to if forward
30 -- begin_date - Begin date
31 -- end_date - End date
32 -- rule_comment - Rule comment
33 -- h_fnames - array of attr field names
34 -- h_fvalues - array of attr field values
35 -- h_fdocnames - array of document name values
36 -- h_counter - number of fields passed in fnames and fvalues
37 -- update_button - Update button flag
38 -- delete_button - Delete button flag
39 --
40 procedure SubmitUpdate(
41 rule_id in varchar2,
42 action in varchar2,
43 fmode in varchar2 default null,
44 action_argument in varchar2 default null,
45 display_action_argument in varchar2 default null,
46 begin_date in varchar2 default null,
47 end_date in varchar2 default null,
48 rule_comment in varchar2 default null,
49 h_fnames in Name_Array,
50 h_fvalues in Value_Array,
51 h_fdocnames in Value_Array,
52 h_counter in varchar2,
53 delete_button in varchar2 default null,
54 update_button in varchar2 default null);
55
56 --
57 -- UpdateRule
58 -- Update values for existing rule
59 -- IN
60 -- rule_id - Rule id number
61 --
62 procedure UpdateRule(
63 ruleid in varchar2);
64
65 --
66 -- SubmitCreate
67 -- Process CreateRule request
68 -- IN
69 -- user - role owning rule
70 -- msg_type - message type
71 -- msg_name - message name
72 -- begin_date - Start date
73 -- end_date - End date
74 -- action - action
75 -- fmode - forward mode: 'FORWARD', 'TRANSFER'
76 -- action_argument - reassign to if forward
77 -- h_fnames - Name array
78 -- h_fvalues - Value array
79 -- h_fdocnames - array of document name values
80 -- h_counter - count of array element
81 -- rule_comment - comments included in notification
82 -- delete_button - cancel operation flag
83 -- done_button - done button flag
84 --
85 procedure SubmitCreate(
86 user in varchar2,
87 msg_type in varchar2,
88 msg_name in varchar2 default null,
89 begin_date in varchar2 default null,
90 end_date in varchar2 default null,
91 action in varchar2,
92 fmode in varchar2 default null,
93 action_argument in varchar2 default null,
94 display_action_argument in varchar2 default null,
95 h_fnames in Name_Array,
96 h_fvalues in Value_Array,
97 h_fdocnames in Value_Array,
98 h_counter in varchar2,
99 rule_comment in varchar2 default null,
100 delete_button in varchar2 default null,
101 done_button in varchar2 default null);
102
103 /*
104 --
105 -- CreateRule1
106 -- Create a new routing rule
107 -- IN
108 -- user - User to query rules for. If null use current user.
109 -- Nore: only WF_ADMIN_ROLE can create rules for other users
110 -- create_button - create button flag
111 --
112 procedure CreateRule1(
113 user in varchar2 default null,
114 create_button in varchar2 default null);
115 */
116
117 --
118 -- CreateRule2
119 -- Create a new routing rule
120 -- IN
121 -- user - User to query rules for. If null use current user.
122 -- Nore: only WF_ADMIN_ROLE can create rules for other users
123 -- create_button - create button flag
124 --
125 procedure CreateRule2(
126 user in varchar2 default null,
127 msg_type in varchar2 default null,
128 insert_button in varchar2 default null,
129 cancel_button in varchar2 default null);
130
131 --
132 -- CreateRule3
133 -- Create a new routing rule
134 -- IN
135 -- user - User to query rules for. If null use current user.
136 -- Nore: only WF_ADMIN_ROLE can create rules for other users
137 -- create_button - create button flag
138 --
139 procedure CreateRule3(
140 user in varchar2 default null,
141 msg_type in varchar2 default null,
142 msg_name in varchar2 default null,
143 insert_button in varchar2 default null,
144 cancel_button in varchar2 default null);
145
146 --
147 -- CreateRule
148 -- Create a new routing rule
149 -- IN
150 -- user - User to query rules for. If null use current user.
151 -- Nore: only WF_ADMIN_ROLE can create rules for other users
152 -- create_button - create button flag
153 --
154 procedure CreateRule(
155 user in varchar2 default null,
156 create_button in varchar2 default null);
157
158 /*
159 --
160 -- ListFrame
161 -- Produce Frame to display List
162 -- IN
163 -- user - User to query rules for. If null use current user.
164 -- Note: only WF_ADMIN_ROLE can query other than the current user.
165 --
166 procedure ListFrame (
167 user in varchar2 default null);
168 */
169
170 --
171 -- List
172 -- Produce list of routing rules for user
173 -- IN
174 -- user - User to query rules for. If null use current user.
175 -- Nore: only WF_ADMIN_ROLE can query other than the current user.
176 --
177 procedure List (
178 user in varchar2 default null,
179 display_user in varchar2 default null
180 );
181
182 /*
183 --
184 -- ListButton
185 --
186 procedure ListButton (
187 user in varchar2 default null,
188 username varchar2 default null);
189 */
190
191 --
192 -- Find
193 -- Find routing rules for given user
194 -- Note: only WF_ADMIN_ROLE can query other than the current user.
195 --
196 procedure Find;
197
198 --
199 -- ChangeMessageName
200 -- Changes the message name on any defined rule(s).
201 --
202 procedure ChangeMessageName (p_itemType in varchar2,
203 p_oldMessageName in varchar2,
204 p_newMessageName in varchar2);
205
206
207 END WF_ROUTE;