[Home] [Help]
PACKAGE: APPS.PA_ASGMT_WFSTD
Source
1 PACKAGE PA_ASGMT_WFSTD AUTHID CURRENT_USER AS
2 -- $Header: PAWFAAPS.pls 120.1.12010000.2 2008/10/06 21:02:33 asahoo ship $
3 g_rejector_uname VARCHAR2(30);
4 g_approver_response VARCHAR2(2000);
5 g_mass_approval VARCHAR2(10) := 'Mass';
6 g_single_approval VARCHAR2(10) := 'Single';
7 PROCEDURE Start_Workflow ( p_project_id IN NUMBER DEFAULT NULL
8 , p_assignment_id IN NUMBER
9 , p_status_code IN VARCHAR2 DEFAULT NULL
10 , p_person_id IN NUMBER DEFAULT NULL
11 , p_wf_item_type IN VARCHAR2
12 , p_wf_process IN VARCHAR2
13 , p_approver1_person_id IN NUMBER DEFAULT NULL
14 , p_approver1_type IN VARCHAR2 DEFAULT NULL
15 , p_approver2_person_id IN NUMBER DEFAULT NULL
16 , p_approver2_type IN VARCHAR2 DEFAULT NULL
17 , p_apprvl_item_type IN VARCHAR2 DEFAULT NULL
18 , p_apprvl_item_key IN VARCHAR2 DEFAULT NULL
19 , p_conflict_group_id IN NUMBER DEFAULT NULL
20 , x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
21 , x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
22 , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
23 , x_error_message_code OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
24
25 PROCEDURE get_workflow_process_info
26 (p_status_code IN VARCHAR2
27 ,x_wf_item_type OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
28 ,x_wf_process OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
29 ,x_wf_type OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
30 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
31 ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
32 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
33 ,x_error_message_code OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
34
35 FUNCTION Is_approval_pending (p_assignment_id IN NUMBER) RETURN VARCHAR2;
36 PRAGMA RESTRICT_REFERENCES (Is_approval_pending, WNPS,WNDS) ;
37
38
39 PROCEDURE Generate_URL ( itemtype IN VARCHAR2
40 , itemkey IN VARCHAR2
41 , actid IN NUMBER
42 , funcmode IN VARCHAR2
43 , resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
44 );
45
46 PROCEDURE Generate_URL_failure
47 ( itemtype IN VARCHAR2
48 , itemkey IN VARCHAR2
49 , actid IN NUMBER
50 , funcmode IN VARCHAR2
51 , resultout OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
52 );
53
54 PROCEDURE Start_New_WF (itemtype IN VARCHAR2
55 , itemkey IN VARCHAR2
56 , actid IN NUMBER
57 , funcmode IN VARCHAR2
58 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
59
60 PROCEDURE Set_Success_Status (itemtype IN VARCHAR2
61 , itemkey IN VARCHAR2
62 , actid IN NUMBER
63 , funcmode IN VARCHAR2
64 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
65
66 PROCEDURE Set_Failure_Status (itemtype IN VARCHAR2
67 , itemkey IN VARCHAR2
68 , actid IN NUMBER
69 , funcmode IN VARCHAR2
70 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
71
72 PROCEDURE Generate_Approvers (itemtype IN VARCHAR2
73 , itemkey IN VARCHAR2
74 , actid IN NUMBER
75 , funcmode IN VARCHAR2
76 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
77
78 PROCEDURE Get_Approver (itemtype IN VARCHAR2
79 , itemkey IN VARCHAR2
80 , actid IN NUMBER
81 , funcmode IN VARCHAR2
82 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
83
84 PROCEDURE Generate_apprvl_nf_recipients
85 (itemtype IN VARCHAR2
86 , itemkey IN VARCHAR2
87 , actid IN NUMBER
88 , funcmode IN VARCHAR2
89 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
90
91 PROCEDURE Get_Approval_NF_Recipient
92 (itemtype IN VARCHAR2
93 , itemkey IN VARCHAR2
94 , actid IN NUMBER
95 , funcmode IN VARCHAR2
96 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
97
98 PROCEDURE Generate_reject_nf_recipients
99 (itemtype IN VARCHAR2
100 , itemkey IN VARCHAR2
101 , actid IN NUMBER
102 , funcmode IN VARCHAR2
103 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
104
105 PROCEDURE Get_Reject_NF_Recipient
106 (itemtype IN VARCHAR2
107 , itemkey IN VARCHAR2
108 , actid IN NUMBER
109 , funcmode IN VARCHAR2
110 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
111
112 PROCEDURE Generate_cancel_nf_recipients
113 (itemtype IN VARCHAR2
114 , itemkey IN VARCHAR2
115 , actid IN NUMBER
116 , funcmode IN VARCHAR2
117 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
118 PROCEDURE Get_Cancel_NF_Recipient
119 (itemtype IN VARCHAR2
120 , itemkey IN VARCHAR2
121 , actid IN NUMBER
122 , funcmode IN VARCHAR2
123 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
124
125
126 PROCEDURE Check_Wf_Enabled (itemtype IN VARCHAR2
127 , itemkey IN VARCHAR2
128 , actid IN NUMBER
129 , funcmode IN VARCHAR2
130 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
131
132 PROCEDURE Set_Forwarded_From (itemtype IN VARCHAR2
133 , itemkey IN VARCHAR2
134 , actid IN NUMBER
135 , funcmode IN VARCHAR2
136 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
137
138 PROCEDURE Set_Approval_Reqd_Msg (itemtype IN VARCHAR2
139 , itemkey IN VARCHAR2
140 , actid IN NUMBER
141 , funcmode IN VARCHAR2
142 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
143
144 PROCEDURE Set_Approved_Msg (itemtype IN VARCHAR2
145 , itemkey IN VARCHAR2
146 , actid IN NUMBER
147 , funcmode IN VARCHAR2
148 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
149
150 PROCEDURE Set_Rejected_Msg (itemtype IN VARCHAR2
151 , itemkey IN VARCHAR2
152 , actid IN NUMBER
153 , funcmode IN VARCHAR2
154 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
155
156 PROCEDURE Set_Canceled_Msg (itemtype IN VARCHAR2
157 , itemkey IN VARCHAR2
158 , actid IN NUMBER
159 , funcmode IN VARCHAR2
160 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
161
162 PROCEDURE Validate_Forwarded_User (itemtype IN VARCHAR2
163 , itemkey IN VARCHAR2
164 , actid IN NUMBER
165 , funcmode IN VARCHAR2
166 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
167
168 PROCEDURE Set_Approval_Pending (itemtype IN VARCHAR2
169 , itemkey IN VARCHAR2
170 , actid IN NUMBER
171 , funcmode IN VARCHAR2
172 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
173
174 PROCEDURE Maintain_wf_pending_flag (p_assignment_id IN NUMBER,
175 p_mode IN VARCHAR2 );
176 PROCEDURE Set_Asgmt_wf_result_Status
177 (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
178 p_status_code IN pa_project_statuses.project_status_code%TYPE,
179 p_result_type IN VARCHAR2,
180 p_item_type IN VARCHAR2,
181 p_item_key IN VARCHAR2 ,
182 x_return_status OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
183
184 PROCEDURE generate_sch_err_msg
185 (document_id IN VARCHAR2,
186 display_type IN VARCHAR2,
187 document IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
188 document_type IN OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
189
190 PROCEDURE Capture_approver_comment (itemtype IN VARCHAR2
191 , itemkey IN VARCHAR2
192 , actid IN NUMBER
193 , funcmode IN VARCHAR2
194 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
195
196 PROCEDURE Populate_approval_NF_comments (itemtype IN VARCHAR2
197 , itemkey IN VARCHAR2
198 , actid IN NUMBER
199 , funcmode IN VARCHAR2
200 , resultout OUT NOCOPY VARCHAR2 ) ; --File.Sql.39 bug 4440895
201
202 PROCEDURE Delete_Assignment_WF_Records (p_assignment_id IN pa_project_assignments.assignment_id%TYPE,
203 p_project_id IN pa_project_assignments.project_id%TYPE);
204
205 PROCEDURE Check_And_Get_Proj_Customer ( p_project_id IN NUMBER
206 ,x_customer_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
207 ,x_customer_name OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
208
209 PROCEDURE start_mass_approval_flow
210 ( p_project_id IN NUMBER := FND_API.G_MISS_NUM
211 ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
212 ,p_note_to_approvers IN VARCHAR2 := FND_API.G_MISS_CHAR
213 ,p_forwarded_from IN VARCHAR2
214 ,p_performer_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR
215 ,p_routing_order IN NUMBER := FND_API.G_MISS_NUM
216 ,p_group_id IN NUMBER := FND_API.G_MISS_NUM
217 ,p_approver_group_id IN NUMBER := FND_API.G_MISS_NUM
218 ,p_submitter_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR
219 ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
220 ,p_project_name IN VARCHAR2
221 ,p_project_number IN VARCHAR2
222 ,p_project_manager IN VARCHAR2
223 ,p_project_org IN VARCHAR2
224 ,p_project_cus IN VARCHAR2
225 ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
226 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
227 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
228 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
229
230 PROCEDURE process_approval_result_wf
231 ( itemtype IN VARCHAR2
232 ,itemkey IN VARCHAR2
233 ,actid IN NUMBER
234 ,funcmode IN VARCHAR2
235 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
236
237 PROCEDURE Check_Approval_Type
238 ( itemtype IN VARCHAR2
239 ,itemkey IN VARCHAR2
240 ,actid IN NUMBER
241 ,funcmode IN VARCHAR2
242 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
243
244 PROCEDURE Check_Notification_Completed
245 ( itemtype IN VARCHAR2
246 ,itemkey IN VARCHAR2
247 ,actid IN NUMBER
248 ,funcmode IN VARCHAR2
249 ,resultout OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
250
251 PROCEDURE process_res_fyi_notification
252 ( p_project_id IN NUMBER := FND_API.G_MISS_NUM
253 ,p_assignment_id IN NUMBER := FND_API.G_MISS_NUM
254 ,p_mode IN VARCHAR2
255 ,p_project_name IN VARCHAR2
256 ,p_project_number IN VARCHAR2
257 ,p_project_manager IN VARCHAR2
258 ,p_project_org IN VARCHAR2
259 ,p_project_cus IN VARCHAR2
260 ,p_conflict_group_id IN NUMBER := NULL
261 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
262 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
263 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
264
265 PROCEDURE process_submitter_notification
266 ( p_project_id IN NUMBER := FND_API.G_MISS_NUM
267 ,p_mode IN VARCHAR2
268 ,p_group_id IN NUMBER := FND_API.G_MISS_NUM
269 ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
270 ,p_num_apr_asgns IN NUMBER
271 ,p_num_rej_asgns IN NUMBER
272 ,p_project_name IN VARCHAR2
273 ,p_project_number IN VARCHAR2
274 ,p_project_manager IN VARCHAR2
275 ,p_project_org IN VARCHAR2
276 ,p_project_cus IN VARCHAR2
277 ,p_submitter_user_name IN VARCHAR2
278 ,p_assignment_id IN NUMBER := FND_API.G_MISS_NUM
279 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
280 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
281 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
282
283 PROCEDURE Set_Submitter_User_Name
284 (p_item_type IN VARCHAR2,
285 p_item_key IN VARCHAR2,
286 p_actid IN NUMBER,
287 p_funcmode IN VARCHAR2,
288 p_result OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
289
290 PROCEDURE Abort_Remaining_Trx
291 (p_item_type IN VARCHAR2,
292 p_item_key IN VARCHAR2,
293 p_actid IN NUMBER,
294 p_funcmode IN VARCHAR2,
295 p_result OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
296
297 PROCEDURE process_mgr_fyi_notification
298 ( p_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
299 ,p_project_id IN NUMBER := FND_API.G_MISS_NUM
300 ,p_group_id IN NUMBER := FND_API.G_MISS_NUM
301 ,p_mode IN VARCHAR2
302 ,p_update_info_doc IN VARCHAR2 := FND_API.G_MISS_CHAR
303 ,p_num_apr_asgns IN NUMBER
304 ,p_num_rej_asgns IN NUMBER
305 ,p_project_name IN VARCHAR2
306 ,p_project_number IN VARCHAR2
307 ,p_project_manager IN VARCHAR2
308 ,p_project_org IN VARCHAR2
309 ,p_project_cus IN VARCHAR2
310 ,p_submitter_user_name IN VARCHAR2
311 ,p_conflict_group_id IN NUMBER := FND_API.G_MISS_NUM
312 ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
313 ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
314 ,x_msg_data OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
315
316 END PA_ASGMT_WFSTD;