[Home] [Help]
PACKAGE: APPS.IEU_WR_PUB
Source
1 PACKAGE IEU_WR_PUB AS
2 /* $Header: IEUPUWRS.pls 120.9 2006/08/18 05:09:13 msathyan noship $ */
3
4 -- *******
5 --
6 -- Status_id : 0 - open , 3 - Closed, 4 - Delete, 5- Sleep
7 -- Distribution Status: 0 - Onhold/UnAvailable, 1 - Distributable, 2 - Distributing, 3 - Distributed
8 --
9 -- *******
10
11 g_pkg_name CONSTANT VARCHAR2(30) := 'IEU_WR_PUB';
12
13 TYPE IEU_WR_ITEM_REC is RECORD
14 (
15 WORK_ITEM_ID NUMBER(15),
16 WORKITEM_OBJ_CODE VARCHAR2(30),
17 WORKITEM_PK_ID NUMBER(15),
18 PREV_PARENT_DIST_STATUS_ID NUMBER,
19 PREV_PARENT_WORKITEM_STATUS_ID NUMBER
20 );
21
22 TYPE IEU_WR_ITEM_LIST IS
23 TABLE OF IEU_WR_ITEM_REC INDEX BY BINARY_INTEGER;
24
25 /******* Orig proc without audit log *********/
26
27 PROCEDURE CREATE_WR_ITEM
28 ( p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
30 p_commit IN VARCHAR2 DEFAULT NULL,
31 p_workitem_obj_code IN VARCHAR2 DEFAULT NULL,
32 p_workitem_pk_id IN NUMBER DEFAULT NULL,
33 p_work_item_number IN VARCHAR2 DEFAULT NULL,
34 p_title IN VARCHAR2 DEFAULT NULL,
35 p_party_id IN NUMBER,
36 p_priority_code IN VARCHAR2 DEFAULT NULL,
37 p_due_date IN DATE,
38 p_owner_id IN NUMBER,
39 p_owner_type IN VARCHAR2,
40 p_assignee_id IN NUMBER,
41 p_assignee_type IN VARCHAR2,
42 p_source_object_id IN NUMBER,
43 p_source_object_type_code IN VARCHAR2,
44 p_application_id IN NUMBER DEFAULT NULL,
45 p_ieu_enum_type_uuid IN VARCHAR2 DEFAULT NULL,
46 p_work_item_status IN VARCHAR2 DEFAULT NULL,
47 p_user_id IN NUMBER DEFAULT NULL,
48 p_login_id IN NUMBER DEFAULT NULL,
49 x_work_item_id OUT NOCOPY NUMBER,
50 x_msg_count OUT NOCOPY NUMBER,
51 x_msg_data OUT NOCOPY VARCHAR2,
52 x_return_status OUT NOCOPY VARCHAR2);
53
54 PROCEDURE UPDATE_WR_ITEM
55 ( p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
57 p_commit IN VARCHAR2 DEFAULT NULL,
58 p_workitem_obj_code IN VARCHAR2 DEFAULT NULL,
59 p_workitem_pk_id IN NUMBER DEFAULT NULL,
60 p_title IN VARCHAR2 DEFAULT NULL,
61 p_party_id IN NUMBER,
62 p_priority_code IN VARCHAR2 DEFAULT NULL,
63 p_due_date IN DATE,
64 p_owner_id IN NUMBER DEFAULT NULL,
65 p_owner_type IN VARCHAR2 DEFAULT NULL,
66 p_assignee_id IN NUMBER,
67 p_assignee_type IN VARCHAR2,
68 p_source_object_id IN NUMBER,
69 p_source_object_type_code IN VARCHAR2,
70 p_application_id IN NUMBER DEFAULT NULL,
71 p_work_item_status IN VARCHAR2 DEFAULT NULL,
72 p_user_id IN NUMBER DEFAULT NULL,
73 p_login_id IN NUMBER DEFAULT NULL,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 x_return_status OUT NOCOPY VARCHAR2);
77
78 /***
79 PROCEDURE RESCHEDULE_UWQM_ITEM
80 ( p_api_version IN NUMBER,
81 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
82 p_commit IN VARCHAR2 DEFAULT NULL,
83 p_workitem_obj_code IN VARCHAR2 DEFAULT NULL,
84 p_workitem_pk_id IN NUMBER DEFAULT NULL,
85 p_work_item_id IN NUMBER DEFAULT NULL,
86 p_reschedule_time IN DATE DEFAULT NULL,
87 p_user_id IN NUMBER DEFAULT NULL,
88 p_login_id IN NUMBER DEFAULT NULL,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2,
91 x_return_status OUT NOCOPY VARCHAR2);
92 **/
93
94 PROCEDURE SYNC_WS_DETAILS
95 ( p_api_version IN NUMBER,
96 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
97 p_commit IN VARCHAR2 DEFAULT NULL,
98 p_ws_code IN VARCHAR2 DEFAULT NULL,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 x_return_status OUT NOCOPY VARCHAR2);
102
103 PROCEDURE GET_NEXT_WORK_FOR_APPS
104 ( p_api_version IN NUMBER,
105 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
106 p_commit IN VARCHAR2 DEFAULT NULL,
107 p_resource_id IN NUMBER,
108 p_language IN VARCHAR2,
109 p_source_lang IN VARCHAR2,
110 p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
111 x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 x_return_status OUT NOCOPY VARCHAR2);
115
116 PROCEDURE SYNC_DEPENDENT_WR_ITEMS
117 ( p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
119 p_commit IN VARCHAR2 DEFAULT NULL,
120 p_wr_item_list IN IEU_WR_PUB.IEU_WR_ITEM_LIST ,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 x_return_status OUT NOCOPY VARCHAR2);
124
125 /******** overloaded proc for Audit logging **********/
126
127 PROCEDURE CREATE_WR_ITEM
128 ( p_api_version IN NUMBER,
129 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
130 p_commit IN VARCHAR2 DEFAULT NULL,
131 p_workitem_obj_code IN VARCHAR2 DEFAULT NULL,
132 p_workitem_pk_id IN NUMBER DEFAULT NULL,
133 p_work_item_number IN VARCHAR2 DEFAULT NULL,
134 p_title IN VARCHAR2 DEFAULT NULL,
135 p_party_id IN NUMBER,
136 p_priority_code IN VARCHAR2 DEFAULT NULL,
137 p_due_date IN DATE,
138 p_owner_id IN NUMBER,
139 p_owner_type IN VARCHAR2,
140 p_assignee_id IN NUMBER,
141 p_assignee_type IN VARCHAR2,
142 p_source_object_id IN NUMBER,
143 p_source_object_type_code IN VARCHAR2,
144 p_application_id IN NUMBER DEFAULT NULL,
145 p_ieu_enum_type_uuid IN VARCHAR2 DEFAULT NULL,
146 p_work_item_status IN VARCHAR2 DEFAULT NULL,
147 p_user_id IN NUMBER DEFAULT NULL,
148 p_login_id IN NUMBER DEFAULT NULL,
149 p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
150 x_work_item_id OUT NOCOPY NUMBER,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 x_return_status OUT NOCOPY VARCHAR2);
154
155 PROCEDURE UPDATE_WR_ITEM
156 ( p_api_version IN NUMBER,
157 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
158 p_commit IN VARCHAR2 DEFAULT NULL,
159 p_workitem_obj_code IN VARCHAR2 DEFAULT NULL,
160 p_workitem_pk_id IN NUMBER DEFAULT NULL,
161 p_title IN VARCHAR2 DEFAULT NULL,
162 p_party_id IN NUMBER,
163 p_priority_code IN VARCHAR2 DEFAULT NULL,
164 p_due_date IN DATE,
165 p_owner_id IN NUMBER DEFAULT NULL,
166 p_owner_type IN VARCHAR2 DEFAULT NULL,
167 p_assignee_id IN NUMBER,
168 p_assignee_type IN VARCHAR2,
169 p_source_object_id IN NUMBER,
170 p_source_object_type_code IN VARCHAR2,
171 p_application_id IN NUMBER DEFAULT NULL,
172 p_work_item_status IN VARCHAR2 DEFAULT NULL,
173 p_user_id IN NUMBER DEFAULT NULL,
174 p_login_id IN NUMBER DEFAULT NULL,
175 p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 x_return_status OUT NOCOPY VARCHAR2);
179
180 PROCEDURE RESCHEDULE_UWQM_ITEM
181 ( p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
183 p_commit IN VARCHAR2 DEFAULT NULL,
184 p_workitem_obj_code IN VARCHAR2 DEFAULT NULL,
185 p_workitem_pk_id IN NUMBER DEFAULT NULL,
186 p_work_item_id IN NUMBER DEFAULT NULL,
187 p_reschedule_time IN DATE DEFAULT NULL,
188 p_user_id IN NUMBER DEFAULT NULL,
189 p_login_id IN NUMBER DEFAULT NULL,
190 --- p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 x_return_status OUT NOCOPY VARCHAR2);
194
195 PROCEDURE SYNC_WS_DETAILS
196 ( p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
198 p_commit IN VARCHAR2 DEFAULT NULL,
199 p_ws_code IN VARCHAR2 DEFAULT NULL,
200 p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 x_return_status OUT NOCOPY VARCHAR2);
204
205 PROCEDURE GET_NEXT_WORK_FOR_APPS
206 ( p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
208 p_commit IN VARCHAR2 DEFAULT NULL,
209 p_resource_id IN NUMBER,
210 p_language IN VARCHAR2,
211 p_source_lang IN VARCHAR2,
212 p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
213 p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
214 x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 x_return_status OUT NOCOPY VARCHAR2);
218
219 PROCEDURE SYNC_DEPENDENT_WR_ITEMS
220 ( p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
222 p_commit IN VARCHAR2 DEFAULT NULL,
223 p_wr_item_list IN IEU_WR_PUB.IEU_WR_ITEM_LIST ,
224 p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 x_return_status OUT NOCOPY VARCHAR2);
228
229 PROCEDURE ACTIVATE_WS
230 ( p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
232 p_commit IN VARCHAR2 DEFAULT NULL,
233 p_ws_code IN VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 x_return_status OUT NOCOPY VARCHAR2);
237
238 PROCEDURE CHECK_WS_ACTIVATION_STATUS
239 ( p_api_version IN NUMBER,
240 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
241 p_commit IN VARCHAR2 DEFAULT NULL,
242 p_ws_code IN VARCHAR2,
243 x_ws_activation_status OUT NOCOPY VARCHAR2,
244 x_msg_count OUT NOCOPY NUMBER,
245 x_msg_data OUT NOCOPY VARCHAR2,
246 x_return_status OUT NOCOPY VARCHAR2);
247
248 PROCEDURE PURGE_WR_ITEM
249 (
250 P_API_VERSION_NUMBER IN NUMBER,
251 P_INIT_MSG_LIST IN VARCHAR2,
252 P_COMMIT IN VARCHAR2,
253 P_PROCESSING_SET_ID IN NUMBER,
254 P_OBJECT_TYPE IN VARCHAR2,
255 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
256 X_MSG_COUNT OUT NOCOPY NUMBER,
257 X_MSG_DATA OUT NOCOPY VARCHAR2
258 );
259
260 PROCEDURE PURGE_WR_ITEM
261 ( p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
263 p_commit IN VARCHAR2 DEFAULT NULL,
264 p_workitem_obj_code IN VARCHAR2,
265 p_workitem_pk_id IN NUMBER,
266 p_application_id IN NUMBER DEFAULT NULL,
267 p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST DEFAULT NULL,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2,
270 x_return_status OUT NOCOPY VARCHAR2);
271
272 /**** Wrapper for RESCHEDULE_WORK_ITEM - ER# 4134808****/
273
274 PROCEDURE SNOOZE_UWQM_ITEM
275 ( p_api_version IN NUMBER,
276 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
277 p_commit IN VARCHAR2 DEFAULT NULL,
278 p_workitem_obj_code IN VARCHAR2 DEFAULT NULL,
279 p_workitem_pk_id IN NUMBER DEFAULT NULL,
280 p_work_item_id IN NUMBER DEFAULT NULL,
281 p_reschedule_time IN DATE DEFAULT NULL,
282 p_user_id IN NUMBER DEFAULT NULL,
283 p_login_id IN NUMBER DEFAULT NULL,
284 x_msg_count OUT NOCOPY NUMBER,
285 x_msg_data OUT NOCOPY VARCHAR2,
286 x_return_status OUT NOCOPY VARCHAR2);
287
288 PROCEDURE DEACTIVATE_WS
289 ( p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
291 p_commit IN VARCHAR2 DEFAULT NULL,
292 p_ws_code IN VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 x_return_status OUT NOCOPY VARCHAR2);
296
297 PROCEDURE SYNC_WR_ITEMS
298 ( p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
300 p_commit IN VARCHAR2 DEFAULT NULL,
301 p_processing_set_id IN NUMBER DEFAULT NULL,
302 p_user_id IN NUMBER DEFAULT NULL,
303 p_login_id IN NUMBER DEFAULT NULL,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 x_return_status OUT NOCOPY VARCHAR2);
307
308 PROCEDURE SYNC_ASSCT_TASK_WR_ITEMS
309 ( p_api_version IN NUMBER,
310 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
311 p_commit IN VARCHAR2 DEFAULT NULL,
312 p_ws_code IN VARCHAR2 DEFAULT NULL,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2,
315 x_return_status OUT NOCOPY VARCHAR2);
316
317 PROCEDURE IEU_DEF_TASKS_RULES_FUNC
318 ( P_PROCESSING_SET_ID IN NUMBER DEFAULT NULL,
319 X_MSG_COUNT OUT NOCOPY NUMBER,
320 X_MSG_DATA OUT NOCOPY VARCHAR2,
321 X_RETURN_STATUS OUT NOCOPY VARCHAR2);
322
323 PROCEDURE GET_NEXT_WORK_ITEM
324 ( p_ws_code IN VARCHAR2,
325 p_resource_id IN NUMBER,
326 x_workitem_pk_id OUT nocopy NUMBER,
327 x_workitem_obj_code OUT NOCOPY VARCHAR2,
328 x_source_obj_id OUT NOCOPY NUMBER,
329 x_source_obj_type_code OUT NOCOPY VARCHAR2,
330 x_msg_count OUT nocopy NUMBER,
331 x_return_status OUT nocopy VARCHAR2,
332 x_msg_data OUT nocopy VARCHAR2);
333
334 PROCEDURE SYNC_WR_ITEM_STATUS
335 ( p_api_version IN NUMBER,
336 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
337 p_commit IN VARCHAR2 DEFAULT NULL,
338 p_processing_set_id IN NUMBER DEFAULT NULL,
339 p_ws_code IN VARCHAR2 DEFAULT NULL,
340 x_msg_count OUT NOCOPY NUMBER,
341 x_msg_data OUT NOCOPY VARCHAR2,
342 x_return_status OUT NOCOPY VARCHAR2);
343
344 PROCEDURE UPDATE_WR_ITEM_STATUS
345 ( p_api_version IN NUMBER,
346 p_init_msg_list IN VARCHAR2 DEFAULT NULL,
347 p_commit IN VARCHAR2 DEFAULT NULL,
348 p_ws_code IN VARCHAR2 DEFAULT NULL,
349 x_msg_count OUT NOCOPY NUMBER,
350 x_msg_data OUT NOCOPY VARCHAR2,
351 x_return_status OUT NOCOPY VARCHAR2);
352
353 END IEU_WR_PUB;