1 Package pqh_tct_wizard_pkg AUTHID CURRENT_USER as
2 /* $Header: pqtctwiz.pkh 120.1 2005/10/12 20:20:17 srajakum noship $ */
3 --
4 type warnings_rec is record(message_text fnd_new_messages.message_text%type);
5
6 type warnings_tab is table of warnings_rec index by binary_integer;
7 --
8 -----------------------------------------------------------------------------
9 --
10 -- This function checks if standard setup is already complete for the
11 -- transaction category and returns TRUE if standard setup is complete .
12 -- It returns FALSE if standard setup has not yet been done.
13 --
14 Function chk_if_setup_finish(p_transaction_category_id in number,
15 p_setup_type out nocopy varchar2)
16 Return Boolean;
17
18 --
19 -----------------------------------------------------------------------------
20 --
21 Function generate_rule_name
22 Return Varchar2;
23 --
24 -----------------------------------------------------------------------------
25 --
26 PROCEDURE create_default_hierarchy
27 ( p_validate in boolean default false
28 ,p_routing_category_id out nocopy number
29 ,p_transaction_category_id in number default null
30 ,p_enable_flag in varchar2 default 'Y'
31 ,p_default_flag in varchar2 default null
32 ,p_routing_list_id in number default null
33 ,p_position_structure_id in number default null
34 ,p_override_position_id in number default null
35 ,p_override_assignment_id in number default null
36 ,p_override_role_id in number default null
37 ,p_override_user_id in number default null
38 ,p_object_version_number out nocopy number
39 ,p_effective_date in date
40 );
41
42 --
43 -----------------------------------------------------------------------------
44 --
45 PROCEDURE update_default_hierarchy
46 (
47 p_validate in boolean default false
48 ,p_old_routing_category_id in number
49 ,p_routing_category_id in out nocopy number
50 ,p_transaction_category_id in number default null
51 ,p_enable_flag in varchar2 default 'Y'
52 ,p_default_flag in varchar2 default null
53 ,p_routing_list_id in number default null
54 ,p_position_structure_id in number default null
55 ,p_override_position_id in number default null
56 ,p_override_assignment_id in number default null
57 ,p_override_role_id in number default null
58 ,p_override_user_id in number default null
59 ,p_object_version_number in out nocopy number
60 ,p_effective_date in date
61 );
62
63 --
64 -----------------------------------------------------------------------------
65 --
66 PROCEDURE create_default_approver
67 (
68 p_validate in boolean default false
69 ,p_attribute_range_id out nocopy number
70 ,p_approver_flag in varchar2 default null
71 ,p_enable_flag in varchar2 default 'Y'
72 ,p_assignment_id in number default null
73 ,p_attribute_id in number default null
74 ,p_position_id in number default null
75 ,p_range_name in out nocopy varchar2
76 ,p_routing_category_id in number
77 ,p_routing_list_member_id in number default null
78 ,p_object_version_number out nocopy number
79 ,p_effective_date in date
80 );
81
82 --
83 -----------------------------------------------------------------------------
84 --
85 PROCEDURE update_default_approver
86 (
87 p_validate in boolean default false
88 ,p_attribute_range_id in number
89 ,p_approver_flag in varchar2 default null
90 ,p_enable_flag in varchar2 default 'Y'
91 ,p_assignment_id in number default null
92 ,p_attribute_id in number default null
93 ,p_position_id in number default null
94 ,p_range_name in varchar2
95 ,p_routing_category_id in number
96 ,p_routing_list_member_id in number default null
97 ,p_object_version_number in out nocopy number
98 ,p_effective_date in date
99 );
100 --
101 --------------------------------------------------------------------------
102 --
103 PROCEDURE delete_default_approver
104 (
105 p_validate in boolean default false
106 ,p_attribute_range_id in number
107 ,p_object_version_number in number
108 ,p_effective_date in date
109 );
110 --
111 --
112 -----------------------------------------------------------------------------
113 --
114 PROCEDURE select_routing_attribute
115 (p_txn_category_attribute_id in number,
116 p_attribute_id in number,
117 p_transaction_category_id in number) ;
118 --
119 --
120 PROCEDURE unselect_routing_attribute
121 (p_txn_category_attribute_id in number,
122 p_attribute_id in number,
123 p_transaction_category_id in number);
124 --
125 --
126 PROCEDURE select_authorization_attribute
127 (p_txn_category_attribute_id in number,
128 p_attribute_id in number,
129 p_transaction_category_id in number);
130 --
131 --
132 PROCEDURE unselect_auth_attribute
133 (p_txn_category_attribute_id in number,
134 p_attribute_id in number,
135 p_transaction_category_id in number) ;
136 --
137 --
138 PROCEDURE Refresh_routing_rules(p_transaction_category_id in number);
139 --
140 --
141 PROCEDURE Refresh_authorization_rules(p_transaction_category_id in number);
142 --
143 --
144 PROCEDURE disable_rout_hier_if_no_attr(p_transaction_category_id in number);
145 --
146 --
147 FUNCTION chk_rules_exist (p_routing_category_id in number)
148 RETURN BOOLEAN;
149 --
150 --
151 FUNCTION chk_routing_history_exists (p_routing_category_id in number)
152 RETURN BOOLEAN;
153 --
154 PROCEDURE get_all_attribute_range_id(p_routing_category_id in number,
155 p_range_name in varchar2,
156 p_rule_type in varchar2,
157 p_all_attribute_range_id out nocopy varchar2);
158 --
159 PROCEDURE create_routing_rule(p_transaction_category_id in number,
160 p_routing_category_id in number,
161 p_range_name in varchar2,
162 p_delete_flag in varchar2,
163 p_enable_flag in varchar2,
164 p_all_attribute_range_id out nocopy varchar2);
165 --
166 --
167 PROCEDURE update_routing_rule(p_routing_category_id in number,
168 p_range_name in varchar2,
169 p_enable_flag in varchar2,
170 p_approver_flag in varchar2 default NULL,
171 p_delete_flag in varchar2 default NULL,
172 p_all_attribute_range_id in varchar2);
173 --
174 --
175 PROCEDURE delete_routing_rule(p_routing_category_id in number,
176 p_all_attribute_range_id in varchar2);
177 --
178 --
179 PROCEDURE create_approver ( p_transaction_category_id in number,
180 p_routing_category_id in number,
181 p_routing_list_member_id in number,
182 p_position_id in number,
183 p_assignment_id in number,
184 p_approver_flag in varchar2,
185 p_gen_sys_rule_name out nocopy varchar2);
186 --
187 --
188 PROCEDURE update_approver (p_routing_category_id in number,
189 p_routing_style in varchar2,
190 p_routing_list_member_id in number,
191 p_position_id in number,
192 p_assignment_id in number,
193 p_approver_flag in varchar2 );
194 --
195 --
196 PROCEDURE delete_approver (p_routing_category_id in number,
197 p_routing_style in varchar2,
198 p_routing_list_member_id in number,
199 p_position_id in number,
200 p_assignment_id in number );
201 --
202 --
203 PROCEDURE create_authorization_rule (
204 p_transaction_category_id in number,
205 p_routing_category_id in number,
206 p_routing_list_member_id in number,
207 p_position_id in number,
208 p_assignment_id in number,
209 p_approver_flag in varchar2,
210 p_delete_flag in varchar2,
211 p_enable_flag in varchar2,
212 p_range_name in varchar2,
213 p_all_attribute_range_id out nocopy varchar2);
214 --
215 --
216 PROCEDURE update_authorization_rule
217 (p_routing_category_id in number,
218 p_range_name in varchar2,
219 p_enable_flag in varchar2,
220 p_approver_flag in varchar2 default NULL,
221 p_delete_flag in varchar2 default NULL,
222 p_all_attribute_range_id in varchar2) ;
223 --
224 --
225 PROCEDURE delete_authorization_rule (p_routing_category_id in number,
226 p_all_attribute_range_id in varchar2);
227 -----------------------------------------------------------------------------
228 PROCEDURE create_local_setup(p_transaction_category_id in out nocopy NUMBER,
229 p_language in varchar2,
230 p_business_group_id in number);
231 -----------------------------------------------------------------------------
232 PROCEDURE freeze_category (p_transaction_category_id in number,
233 p_setup_type_cd in varchar2,
234 p_freeze_status_cd in varchar2);
235 ----------------------------------------------------------------------------
236 FUNCTION chk_range_name_unique (p_routing_category_id in number,
237 p_range_name in varchar2,
238 p_attribute_id_list in varchar2,
239 p_primary_flag in varchar2)
240 RETURN BOOLEAN ;
241 --
242 -- --------------------------------------------------------------------------
243 --
244
245 PROCEDURE load_row (
246 p_canvas_name in varchar2,
247 p_form_name in varchar2,
248 p_current_item in varchar2,
249 p_previous_item in varchar2,
250 p_next_item in varchar2,
251 p_enable_finish_flag in varchar2,
252 p_post_flag in varchar2,
253 p_seq_no in number,
254 p_finish_item in varchar2,
255 p_refresh_msg_flag in varchar2,
256 p_image_name in varchar2,
257 p_warning_item in varchar2,
258 p_image_item in varchar2,
259 p_line_size in number,
260 p_owner in varchar2,
261 p_last_update_date in varchar2 ) ;
262
263 --
264 Function check_errors_in_std_setup(p_transaction_category_id in number,
265 p_error_messages out nocopy warnings_tab)
266 RETURN boolean;
267 --
268 FUNCTION check_errors_in_adv_setup(p_transaction_category_id in number,
269 p_error_messages out nocopy warnings_tab)
270 RETURN boolean;
271 --
272 FUNCTION check_if_adv_setup_started(p_transaction_category_id in number)
273 RETURN BOOLEAN;
274 --
275 Function chk_valid_rout_hier_exists(p_transaction_category_id in number,
279 RETURN BOOLEAN ;
276 p_routing_type in varchar2,
277 p_error_messages out nocopy warnings_tab,
278 p_no_errors out nocopy varchar2)
280 --
281 ------------------------------------------------------------------------
282 FUNCTION chk_mem_overlap_on_freeze(
283 p_transaction_category_id in number,
284 p_routing_type in varchar2,
285 p_routing_category_id in number default NULL,
286 p_error_routing_cat out nocopy varchar2,
287 p_member_name out nocopy varchar2,
288 p_overlap_range_1 out nocopy varchar2,
289 p_overlap_range_2 out nocopy varchar2)
290 --
291 RETURN BOOLEAN;
292 --
293 ------------------------------------------------------------------------
294 Procedure delete_hierarchy_and_rules(p_transaction_category_id in number,
295 p_routing_style in varchar2);
296 --
297 ------------------------------------------------------------------------
298 FUNCTION return_approver_status(p_routing_category_id in number,
299 p_approver_id in number,
300 p_routing_style in varchar2)
301 RETURN varchar2;
302 --
303 ------------------------------------------------------------------------
304 PROCEDURE update_approver_flag(p_routing_category_id in number,
305 p_routing_style in varchar2,
306 p_routing_list_member_id in number,
307 p_position_id in number,
308 p_assignment_id in number,
309 p_approver_flag in varchar2 );
310 ------------------------------------------------------------------------
311 FUNCTION return_person_name(p_assignment_id in number)
312 RETURN varchar2;
313 --
314 END;