1 PACKAGE PQH_WF AUTHID CURRENT_USER AS
2 /* $Header: pqhwfpc.pkh 120.0.12010000.1 2008/07/28 13:01:24 appldev ship $ */
3 PROCEDURE FIND_NEXT_USER (
4 itemtype in varchar2
5 , itemkey in varchar2
6 , actid in number
7 , funcmode in varchar2
8 , result out nocopy varchar2
9 );
10 PROCEDURE notify_requestor (
11 itemtype in varchar2
12 , itemkey in varchar2
13 , actid in number
14 , funcmode in varchar2
15 , result out nocopy varchar2
16 );
17 PROCEDURE SET_NEXT_USER (
18 p_itemtype in varchar2
19 , p_itemkey in varchar2
20 , p_route_to_user in varchar2
21 , p_status in varchar2 DEFAULT NULL
22 );
23 PROCEDURE SET_NEXT_USER (
24 p_transaction_category_id in number
25 , p_transaction_id in number
26 , p_route_to_user in varchar2
27 , p_status in varchar2
28 );
29 FUNCTION post_any_txn (p_transaction_id IN NUMBER
30 )
31 RETURN VARCHAR2;
32 /*
33 PROCEDURE StartProcess(
34 p_itemkey in varchar2
35 , p_itemtype in varchar2
36 , p_process_name in varchar2
37 , p_route_to_user in varchar2
38 , p_user_status in varchar2
39 , p_timeout_days in number
40 , p_form_name in VARCHAR2
41 , p_transaction_id in NUMBER
42 , p_transaction_category_id in NUMBER
43 , p_post_txn_function IN VARCHAR2
44 , p_future_action_cd IN VARCHAR2
45 , p_post_style_cd IN VARCHAR2
46 , p_transaction_name IN VARCHAR2
47 , p_transaction_category_name IN VARCHAR2
48 );
49 */
50 PROCEDURE process_user_action(
51 p_transaction_category_id IN NUMBER
52 , p_transaction_id IN NUMBER
53 , p_workflow_seq_no IN NUMBER DEFAULT NULL
54 , p_routing_category_id in number DEFAULT NULL
55 , p_member_cd IN VARCHAR2 DEFAULT NULL
56 , p_user_action_cd in varchar2 DEFAULT 'FORWARD'
57 , p_route_to_user IN VARCHAR2
58 , p_user_status IN VARCHAR2 DEFAULT 'FOUND'
59 , p_approval_cd IN VARCHAR2 DEFAULT NULL
60 , p_pos_structure_version_id in number DEFAULT NULL
61 , p_comments in varchar2 DEFAULT NULL
62 , p_forwarded_to_user_id in number DEFAULT NULL
63 , p_forwarded_to_role_id in number DEFAULT NULL
64 , p_forwarded_to_position_id in number DEFAULT NULL
65 , p_forwarded_to_assignment_id in number DEFAULT NULL
66 , p_forwarded_to_member_id in number DEFAULT NULL
67 , p_forwarded_by_user_id in number DEFAULT NULL
68 , p_forwarded_by_role_id in number DEFAULT NULL
69 , p_forwarded_by_position_id in number DEFAULT NULL
70 , p_forwarded_by_assignment_id in number DEFAULT NULL
71 , p_forwarded_by_member_id in number DEFAULT NULL
72 , p_effective_date IN DATE DEFAULT NULL
73 , p_parameter1_name IN varchar2 DEFAULT NULL
74 , p_parameter1_value IN varchar2 DEFAULT NULL
75 , p_parameter2_name IN varchar2 DEFAULT NULL
76 , p_parameter2_value IN varchar2 DEFAULT NULL
77 , p_parameter3_name IN varchar2 DEFAULT NULL
78 , p_parameter3_value IN varchar2 DEFAULT NULL
79 , p_parameter4_name IN varchar2 DEFAULT NULL
80 , p_parameter4_value IN varchar2 DEFAULT NULL
81 , p_parameter5_name IN varchar2 DEFAULT NULL
82 , p_parameter5_value IN varchar2 DEFAULT NULL
83 , p_parameter6_name IN varchar2 DEFAULT NULL
84 , p_parameter6_value IN varchar2 DEFAULT NULL
85 , p_parameter7_name IN varchar2 DEFAULT NULL
86 , p_parameter7_value IN varchar2 DEFAULT NULL
87 , p_parameter8_name IN varchar2 DEFAULT NULL
88 , p_parameter8_value IN varchar2 DEFAULT NULL
89 , p_parameter9_name IN varchar2 DEFAULT NULL
90 , p_parameter9_value IN varchar2 DEFAULT NULL
91 , p_parameter10_name IN varchar2 DEFAULT NULL
92 , p_parameter10_value IN varchar2 DEFAULT NULL
93 , p_transaction_name IN varchar2 DEFAULT NULL
94 , p_apply_error_mesg out nocopy varchar2
95 , p_apply_error_num out nocopy varchar2
96 );
97 PROCEDURE APPROVE_TXN (
98 itemtype in varchar2
99 , itemkey in varchar2
100 , actid in number
101 , funcmode in varchar2
102 , result out nocopy varchar2
103 );
104 PROCEDURE REROUTE_FUTURE_ACTION (
105 p_transaction_category_id in NUMBER
106 , p_transaction_id in NUMBER
107 , p_route_to_user in VARCHAR2
108 , p_user_status in VARCHAR2
109 );
110 PROCEDURE POST_TXN (
111 itemtype in varchar2
112 , itemkey in varchar2
113 , actid in number
114 , funcmode in varchar2
115 , result out nocopy varchar2
116 );
117 PROCEDURE CHK_EFFECTIVE_DATE (
118 itemtype in varchar2
119 , itemkey in varchar2
120 , actid in number
121 , funcmode in varchar2
122 , result out nocopy varchar2
123 );
124 PROCEDURE create_routing_history(
125 p_transaction_category_id IN NUMBER
126 , p_transaction_id IN NUMBER
127 , p_routing_category_id IN NUMBER
128 , p_pos_structure_version_id IN NUMBER
129 , p_user_action_cd IN VARCHAR2
130 , p_approval_cd IN VARCHAR2
131 , p_notification_date IN DATE
132 , p_comments IN VARCHAR2
133 , p_forwarded_to_user_id IN NUMBER
134 , p_forwarded_to_role_id IN NUMBER
135 , p_forwarded_to_position_id IN NUMBER
136 , p_forwarded_to_assignment_id IN NUMBER
137 , p_forwarded_to_member_id IN NUMBER
138 , p_forwarded_by_user_id IN NUMBER
139 , p_forwarded_by_role_id IN NUMBER
140 , p_forwarded_by_position_id IN NUMBER
141 , p_forwarded_by_assignment_id IN NUMBER
142 , p_forwarded_by_member_id IN NUMBER
143 , p_routing_history_id OUT NOCOPY NUMBER
144 );
145 PROCEDURE PROCESS_NOTIFICATION (
146 itemtype in varchar2,
147 itemkey in varchar2,
148 actid in number,
149 funcmode in varchar2,
150 result out nocopy varchar2
151 );
152 PROCEDURE PROCESS_RESPONSE (
153 itemtype in varchar2,
154 itemkey in varchar2,
155 actid in number,
156 funcmode in varchar2,
157 result out nocopy varchar2 );
158 PROCEDURE CHECK_FYI (
159 itemtype in varchar2,
160 itemkey in varchar2,
161 actid in number,
162 funcmode in varchar2,
163 result out nocopy varchar2 );
164 PROCEDURE CHK_FYI_RESULTS (
165 itemtype in varchar2
166 , itemkey in varchar2
167 , actid in number
168 , funcmode in varchar2
169 , result out nocopy varchar2
170 );
171 FUNCTION get_default_role (
172 p_transaction_category_id NUMBER
173 , p_user_id in NUMBER default FND_PROFILE.VALUE('USER_ID')
174 )
175 RETURN NUMBER;
176 PROCEDURE chk_root_node (itemtype in varchar2,
177 itemkey in varchar2,
178 actid in number,
179 funcmode in varchar2,
180 result out nocopy varchar2) ;
181 procedure complete_delegate_workflow(
182 p_itemkey in varchar2,
183 p_workflow_name in varchar2 ) ;
184 function get_workflow_name(p_transaction_category_id in number )
185 return varchar2;
186 procedure fyi_notification( document_id in varchar2,
187 display_type in varchar2,
188 document in out nocopy varchar2,
189 document_type in out nocopy varchar2);
190 PROCEDURE reject_notification( document_id in varchar2,
191 display_type in varchar2,
192 document in out nocopy varchar2,
193 document_type in out nocopy varchar2) ;
194 PROCEDURE back_notification( document_id in varchar2,
195 display_type in varchar2,
196 document in out nocopy varchar2,
197 document_type in out nocopy varchar2) ;
198 PROCEDURE override_notification( document_id in varchar2,
199 display_type in varchar2,
200 document in out nocopy varchar2,
201 document_type in out nocopy varchar2) ;
202 PROCEDURE apply_notification( document_id in varchar2,
203 display_type in varchar2,
204 document in out nocopy varchar2,
205 document_type in out nocopy varchar2) ;
206 PROCEDURE warning_notification( document_id in varchar2,
207 display_type in varchar2,
208 document in out nocopy varchar2,
209 document_type in out nocopy varchar2) ;
210 PROCEDURE respond_notification( document_id in varchar2,
211 display_type in varchar2,
212 document in out nocopy varchar2,
213 document_type in out nocopy varchar2) ;
214 PROCEDURE set_status ( p_workflow_name in varchar2,
215 p_item_id in varchar2,
216 p_status in varchar2,
217 p_result out nocopy varchar2);
218 procedure get_apply_error(p_transaction_id in number,
219 p_transaction_category_id in number,
220 p_apply_error_mesg out nocopy varchar2,
221 p_apply_error_num out nocopy varchar2) ;
222 procedure set_apply_error(p_transaction_id in number,
223 p_transaction_category_id in number,
224 p_apply_error_mesg in varchar2,
225 p_apply_error_num in varchar2) ;
226 FUNCTION get_requestor (
227 p_transaction_category_id IN NUMBER
228 , p_transaction_id IN NUMBER
229 )
230 RETURN VARCHAR2 ;
231 FUNCTION get_last_user (
232 p_transaction_category_id IN NUMBER
233 , p_transaction_id IN NUMBER
234 )
235 RETURN VARCHAR2 ;
236 FUNCTION get_current_owner(p_transaction_id in number,
237 p_transaction_category_id in number,
238 p_status in varchar2) RETURN VARCHAR2 ;
239 PROCEDURE WHICH_TXN_CAT (
240 itemtype in varchar2,
241 itemkey in varchar2,
242 actid in number,
246 PROCEDURE FIND_NOTICE_TYPE (
243 funcmode in varchar2,
244 result out nocopy varchar2 );
245
247 itemtype in varchar2,
248 itemkey in varchar2,
249 actid in number,
250 funcmode in varchar2,
251 result out nocopy varchar2 );
252 function get_person_name(p_user_id in number default null,
253 p_assignment_id in number default null) return varchar2 ;
254 END;