[Home] [Help]
PACKAGE: APPS.CSM_WF_PKG
Source
1 PACKAGE CSM_WF_PKG AUTHID CURRENT_USER AS
2 /* $Header: csmewfs.pls 120.4.12020000.3 2012/11/08 06:33:14 pramosin ship $ */
3
4 /*=========================================================
5 4 WF processes for TASK MODULE
6 TASK_ASSIGNMENT_POST_INS
7 TASK_ASSIGNMENT_PRE_UPD
8 TASK_ASSIGNMENT_PURGE
9 TASK_PRE_UPD
13 Starts the TASK_ASSIGNMENT_INS workflow. Should be called when new
10 =========================================================*/
11 /*--------------------------------------------------
12 Description:
14 task assignment is made.
15 Invoked by JTF_TASK_ASSIGNMENTS_IUHK.update_task_assignment_pre
16 global var jtf_task_assignments_pub.p_task_assignments_user_hooks(.task_assignment_id)
17
18 Parameter(s):
19 x_return_status
20 ----------------------------------------------------*/
21
22 PROCEDURE Task_Assignment_Post_Ins(
23 x_return_status OUT NOCOPY VARCHAR2
24 -- p_task_assignment_id in number
25 );
26
27 /*-----------------------------------------------------------------
28 Description:
29 Start the TASK_ASSIGNMENT_UPD process. Called by
30 JTF_TASK_ASSIGNMENTS_IUHK.update_task_assignment_pre
31 We retrieve the old record by selecting from db with task_assignment_id
32 Then, we compare the old resource id and new resource id for whether the resource has changed.
33 Parameter(s):
34 x_return_status
35 ------------------------------------------------------------------*/
36 PROCEDURE Task_Assignment_Pre_Upd(
37 x_return_status OUT NOCOPY VARCHAR2
38 -- p_task_assignment_id in jtf_task_assignments.task_assignment_id%type,
39 -- p_old_resource_id in jtf_task_assignments.resource_id%type,
40 -- p_is_resource_updated in char
41 );
42
43 PROCEDURE Task_Assignment_Post_Upd(
44 x_return_status OUT NOCOPY VARCHAR2
45 );
46
47 /*--------------------------------------------------------
48 Description:
49 Start the workflow process TASK_ASSIGNMENT_PURGE.
50 Invoked by JTF_TASK_ASSIGNMENTS_IUHK.delete_task_assignment_post
51 and by concurrent program to purge closed task assignments
52 older than specified in profile: CSF_M_HISTORY.
53 Parameter(s):
54 x_return_status
55 --------------------------------------------------------*/
56 PROCEDURE Task_Assignment_Post_Del(
57 x_return_status OUT NOCOPY VARCHAR2
58 );
59
60 /*-----------------------------------------------------------------
61 Description:
62 Start the workflow process TASK_UPD_USERLOOP.
63 Invoked by jtf_tasks_iuhk.update_task_pre
64 The global variable for IUHK is: jtf_tasks_pub.p_task_user_hooks(.task_id)
65 Parameter(s):
66 x_return_status
67 ------------------------------------------------------------------*/
68 -- PROCEDURE Task_Pre_Upd(p_jtf_task_id jtf_tasks_b.task_id%type);
69 Procedure Task_Pre_Upd (
70 x_return_status OUT NOCOPY VARCHAR2
71 );
72
73 Procedure Task_Post_Upd (
74 x_return_status OUT NOCOPY VARCHAR2
75 );
76
77 Procedure TASK_Post_Ins(
78 x_return_status OUT NOCOPY VARCHAR2
79 );
80
81 Procedure TASK_Post_DEL(
82 x_return_status OUT NOCOPY VARCHAR2
83 );
84
85
86 /*=========================================================
87 3 WF processes SERVICE REQUEST MODULE for IUHK
88 SR_Post_Ins
89 SR_PRE_UPD
90 SR_CONTACT_POST_INS
91 SR_CONTACT_PRE_UPD
92 Global variable to be used:
93 user_hooks_rec CS_ServiceRequest_PVT.internal_user_hooks_rec
94 Two fields are initialized.
95 user_hooks_rec.customer_id := l_old_ServiceRequest_rec.customer_id ;
96 user_hooks_rec.request_id := p_request_id ;
97 The most useful info is the request_id. We need to use this to check
98 -- whether the other FK columns are changed or not.
99 =========================================================*/
100 PROCEDURE SR_Post_Ins( x_return_status OUT NOCOPY VARCHAR2 );
101
102 PROCEDURE SR_Pre_Upd( x_return_status OUT NOCOPY VARCHAR2 );
103
104 PROCEDURE SR_Post_Upd( x_return_status OUT NOCOPY VARCHAR2 );
105
106 /* =========================================================*/
107
108 PROCEDURE CSF_Debrief_Header_Post_Ins(x_return_status OUT NOCOPY VARCHAR2);
109
110 PROCEDURE CSF_Debrief_Header_Pre_Upd(x_return_status OUT NOCOPY VARCHAR2);
111
112 PROCEDURE CSF_Debrief_Header_Post_Upd(x_return_status OUT NOCOPY VARCHAR2);
113
114 PROCEDURE CSF_Debrief_Header_Post_Del(x_return_status OUT NOCOPY VARCHAR2);
115
116 /*=========================================================
117 2 events related to Debriefing. IUHK
118 CSF_DEBRIEF_LINE_POST_INS
119 CSF_DEBRIEF_LINE_PRE_UPD
120 Global: user_hooks_rec CSF_DEBRIEF_LINES_PKG.internal_user_hooks_rec..DEBRIEF_LINE_ID
121 =========================================================*/
122
123 PROCEDURE CSF_Debrief_Line_Post_Ins(x_return_status OUT NOCOPY VARCHAR2);
124
125 PROCEDURE CSF_Debrief_Line_Pre_Upd(x_return_status OUT NOCOPY VARCHAR2);
126
127 PROCEDURE CSF_Debrief_Line_Post_Upd(x_return_status OUT NOCOPY VARCHAR2);
128
129 PROCEDURE CSF_Debrief_Line_Post_Del(x_return_status OUT NOCOPY VARCHAR2);
130
131 /*=========================================================
132 2 events related to INV_LOC_ASSIGNMENT. IUHK
133 CSP_INV_LOC_ASSIGNMNT_POST_INS
134 CSP_INV_LOC_ASSIGNMNT_PRE_UPD
135 Global variable:
136 CSP_INV_LOC_ASSIGNMENTS_PKG.user_hooks_rec.CSP_INV_LOC_ASSIGNMENT_ID
137 =========================================================*/
138
139 PROCEDURE CSP_Inv_Loc_Assignmnt_Post_Ins(x_return_status OUT NOCOPY varchar2);
140
141 PROCEDURE CSP_Inv_Loc_Assignmnt_Pre_Upd(x_return_status OUT NOCOPY varchar2);
142
143 PROCEDURE CSP_Inv_Loc_Assignmnt_Post_Upd(x_return_status OUT NOCOPY varchar2);
144
145 PROCEDURE CSP_Inv_Loc_Assg_Post_Del(x_return_status OUT NOCOPY varchar2);
149 CSP_SHIP_TO_ADDRESS_POST_INS
146
147 /*=========================================================
148 2 events related to CSP_REQUIREMENT_LINES_PVT IUHK
150 CSP_SHIP_TO_ADDRESS_POST_UPD
151 Global variable:
152 CSP_SHIP_TO_ADDRESS_PVT.G_INV_LOC_ID
153 =========================================================*/
154
155 PROCEDURE CSP_SHIP_TO_ADDRESS_POST_INS(x_return_status OUT NOCOPY varchar2);
156
157 PROCEDURE CSP_SHIP_TO_ADDRESS_POST_UPD(x_return_status OUT NOCOPY varchar2);
158
159 /*=========================================================
160 3 events related to CSP_REQUIREMENT_HEADERS_PKG IUHK
161 CSP_REQ_HEADERS_POST_INS
162 CSP_REQ_HEADERS_POST_UPD
163 CSP_REQ_HEADERS_PRE_DEL
164 Global variable:
165 CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID
166 =========================================================*/
167
168 PROCEDURE CSP_REQ_HEADERS_POST_INS(x_return_status OUT NOCOPY varchar2);
169
170 PROCEDURE CSP_REQ_HEADERS_POST_UPD(x_return_status OUT NOCOPY varchar2);
171
172 PROCEDURE CSP_REQ_HEADERS_POST_DEL(x_return_status OUT NOCOPY varchar2);
173
174 /*=========================================================
175 3 events related to CSP_REQUIREMENT_LINES_PKG IUHK
176 CSP_REQ_LINES_POST_INS
177 CSP_REQ_LINES_POST_UPD
178 CSP_REQ_LINES_PRE_DEL
179 Global variable:
180 CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID
181 =========================================================*/
182
183 PROCEDURE CSP_REQ_LINES_POST_INS(x_return_status OUT NOCOPY varchar2);
184
185 PROCEDURE CSP_REQ_LINES_POST_UPD(x_return_status OUT NOCOPY varchar2);
186
187 PROCEDURE CSP_REQ_LINES_POST_DEL(x_return_status OUT NOCOPY varchar2);
188
189 /*=========================================================
190 3 events related to CSP_REQ_LINE_DETAILS_PKG IUHK
191 CSP_REQ_LINE_DETAILS_POST_INS
192 CSP_REQ_LINE_DETAILS_POST_UPD
193 CSP_REQ_LINE_DETAILS_PRE_DEL
194 Global variable:
195 CSP_REQ_LINE_DETAILS_PKG.user_hook_rec.REQUIREMENT_LINE_ID
196 =========================================================*/
197
198 PROCEDURE CSP_REQ_LINE_DETAILS_POST_INS(x_return_status OUT NOCOPY varchar2);
199
200 PROCEDURE CSP_REQ_LINE_DETAILS_POST_UPD(x_return_status OUT NOCOPY varchar2);
201
202 PROCEDURE CSP_REQ_LINE_DETAILS_PRE_DEL(x_return_status OUT NOCOPY varchar2);
203
204 /*=============================================
205 4 events for install base VUHK
206 CSI_Item_Instance_Post_Ins
207 CSI_ITEM_INSTANCE_PRE_UPD
208 CSI_II_Relationship_Post_Ins
209 CSI_II_Relationship_Pre_Upd
210 =============================================*/
211 /* PROCEDURE CSI_Item_Instance_Post_Ins(p_user_id in number,
212 p_csi_item_instances csi_item_instances%rowtype);
213 */
214 Procedure CSI_Item_Instance_Post_Ins(p_api_version IN NUMBER
215 , p_init_msg_list IN VARCHAR2
216 , p_commit IN VARCHAR2
217 , p_validation_level IN NUMBER
218 , p_instance_id IN NUMBER
219 , x_return_status OUT NOCOPY VARCHAR2
220 , x_msg_count OUT NOCOPY NUMBER
221 , x_msg_data OUT NOCOPY VARCHAR2) ;
222
223 Procedure CSI_Item_Instance_Pre_Upd(p_api_version IN NUMBER
224 , p_init_msg_list IN VARCHAR2
225 , p_commit IN VARCHAR2
226 , p_validation_level IN NUMBER
227 , p_instance_id IN NUMBER
228 , x_return_status OUT NOCOPY VARCHAR2
229 , x_msg_count OUT NOCOPY NUMBER
230 , x_msg_data OUT NOCOPY VARCHAR2) ;
231
232 /*=========================================================
233 3 WF processes for JTF_RS_Group_Member. Used by VUHK
234 JTF_RS_GROUP_MEMBER_POST_INS
235 JTF_RS_GROUP_MEMBER_PRE_UPD
236 JTF_RS_GROUP_MEMBER_POST_DEL
237 =========================================================*/
238
239 PROCEDURE JTF_RS_Group_Member_Post_Ins(p_group_member_id in jtf_rs_group_members.group_member_id%TYPE,
240 p_group_id in jtf_rs_group_members.group_id%TYPE,
241 p_resource_id in jtf_rs_group_members.resource_id%TYPE,
242 x_return_status OUT NOCOPY varchar2);
243
244 PROCEDURE JTF_RS_Group_Member_Pre_Upd(p_user_id in number,
245 p_jtf_rs_group_memb jtf_rs_group_members%rowtype);
246
247 /* SAGRAWAL We have pre processing vertical hook for Group Member Del
248 PROCEDURE JTF_RS_Group_Member_Post_Del(p_user_id in number,
249 p_jtf_rs_group_memb jtf_rs_group_members%rowtype);
250 */
251 Procedure JTF_RS_Group_Member_Pre_Del(p_group_id in jtf_rs_group_members.group_id%TYPE,
252 p_resource_id in jtf_rs_group_members.resource_id%TYPE,
253 x_return_status OUT NOCOPY varchar2) ;
254
255 /*=============================================
256 2 events for NOTES module. VUHK
257 =============================================*/
258
259 PROCEDURE JTF_Note_Post_Ins(p_api_version IN NUMBER
260 , p_init_msg_list IN VARCHAR2
261 , p_commit IN VARCHAR2
262 , p_validation_level IN NUMBER
263 , x_msg_count OUT NOCOPY NUMBER
267
264 , x_msg_data OUT NOCOPY VARCHAR2
265 , x_return_status OUT NOCOPY VARCHAR2
266 ,p_jtf_note_id in jtf_notes_b.jtf_note_id%type);
268 /* SAGRAWAL We have post processing vertical hook for update notes
269 PROCEDURE JTF_Note_Pre_Upd(p_jtf_note_id in jtf_notes_b.jtf_note_id%type); */
270
271 PROCEDURE JTF_Note_Pre_Upd(p_api_version IN NUMBER
272 , p_init_msg_list IN VARCHAR2
273 , p_commit IN VARCHAR2
274 , p_validation_level IN NUMBER
275 , x_msg_count OUT NOCOPY NUMBER
276 , x_msg_data OUT NOCOPY VARCHAR2
277 , x_return_status OUT NOCOPY VARCHAR2
278 ,p_jtf_note_id in jtf_notes_b.jtf_note_id%type);
279
280 PROCEDURE JTF_Note_Post_Upd(p_api_version IN NUMBER
281 , p_init_msg_list IN VARCHAR2
282 , p_commit IN VARCHAR2
283 , p_validation_level IN NUMBER
284 , x_msg_count OUT NOCOPY NUMBER
285 , x_msg_data OUT NOCOPY VARCHAR2
286 , x_return_status OUT NOCOPY VARCHAR2
287 ,p_jtf_note_id in jtf_notes_b.jtf_note_id%type);
288
289 /*=============================================
290 7 events for counters VUHK
291 CS_Counter_Post_Ins (rarely needed)
292 CS_Counter_Pre_Upd (rarely needed)
293 CS_Counter_Property_Post_Ins (rarely needed)
294 CS_Counter_Property_Pre_Upd (rarely needed)
295 CS_Counter_Value_Post_Ins
296 CS_Counter_Value_Pre_Upd
297 CS_Counter_Prop_Val_Post_Ins
298 CS_Counter_Prop_Val_Pre_Upd (probably not needed)
299 *=============================================*/
300
301 PROCEDURE CS_Counter_Post_Ins(
302 P_Api_Version IN NUMBER,
303 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
304 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
305 X_Return_Status OUT NOCOPY VARCHAR2,
306 X_Msg_Count OUT NOCOPY NUMBER,
307 X_Msg_Data OUT NOCOPY VARCHAR2,
308 p_counter_id IN NUMBER,
309 x_object_version_number OUT NOCOPY NUMBER
310 -- p_user_id in number,
311 -- p_counter_id cs_counters.counter_id%type
312 );
313
314 Procedure CS_Counter_Pre_Del(
315 P_Api_Version IN NUMBER,
316 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
317 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
318 X_Return_Status OUT NOCOPY VARCHAR2,
319 X_Msg_Count OUT NOCOPY NUMBER,
320 X_Msg_Data OUT NOCOPY VARCHAR2,
321 p_counter_id IN NUMBER
322 );
323
324
325 PROCEDURE CS_CTR_GRP_INSTANCE_CRE_POST(
326 P_Api_Version IN NUMBER,
327 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
328 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
329 X_Return_Status OUT NOCOPY VARCHAR2,
330 X_Msg_Count OUT NOCOPY NUMBER,
331 X_Msg_Data OUT NOCOPY VARCHAR2,
332 p_source_object_cd IN VARCHAR2,
333 p_source_object_id IN NUMBER,
334 p_ctr_grp_id IN NUMBER,
335 x_object_version_number OUT NOCOPY NUMBER
336 );
337
338 PROCEDURE CS_CTR_GRP_INSTANCE_PRE_DEL(
339 P_Api_Version IN NUMBER,
340 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
341 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
342 X_Return_Status OUT NOCOPY VARCHAR2,
343 X_Msg_Count OUT NOCOPY NUMBER,
344 X_Msg_Data OUT NOCOPY VARCHAR2,
345 p_source_object_cd IN VARCHAR2,
346 p_source_object_id IN NUMBER
347 );
348
349 PROCEDURE CS_COUNTER_GRP_Post_Upd( P_Api_Version IN NUMBER
350 , P_Init_Msg_List IN VARCHAR2
351 , P_Commit IN VARCHAR2
352 , X_Return_Status OUT NOCOPY VARCHAR2
353 , X_Msg_Count OUT NOCOPY NUMBER
354 , X_Msg_Data OUT NOCOPY VARCHAR2
355 , p_ctr_grp_id IN NUMBER
356 , p_object_version_number IN NUMBER
357 , p_cascade_upd_to_instances IN VARCHAR2
358 , x_object_version_number OUT NOCOPY NUMBER );
359
360 PROCEDURE CS_COUNTERS_INSTANTIATE_POST(
361 P_Api_Version IN NUMBER,
362 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
363 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
364 X_Return_Status OUT NOCOPY VARCHAR2,
365 X_Msg_Count OUT NOCOPY NUMBER,
366 X_Msg_Data OUT NOCOPY VARCHAR2,
367 p_counter_group_id_template IN NUMBER,
368 p_source_object_cd IN VARCHAR2,
369 p_source_object_id IN NUMBER,
370 x_ctr_grp_id_template IN NUMBER,
371 p_ctr_grp_id IN NUMBER
372 );
373
374 PROCEDURE CS_Counter_Pre_Upd(
375 P_Api_Version IN NUMBER,
376 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
377 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
378 X_Return_Status OUT NOCOPY VARCHAR2,
379 X_Msg_Count OUT NOCOPY NUMBER,
380 X_Msg_Data OUT NOCOPY VARCHAR2,
381 p_counter_id IN NUMBER,
382 p_object_version_number IN NUMBER,
383 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
384 x_object_version_number OUT NOCOPY NUMBER
385 -- p_user_id in number,
386 -- p_cs_counters cs_counters%rowtype
387 );
388 /*
389 SAGRAWAL Added other parameters
390 PROCEDURE CS_Counter_Value_Post_Ins(p_counter_value_id in number);
391 */
392
393 PROCEDURE CS_Counter_Post_Upd(
394 P_Api_Version IN NUMBER,
395 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
396 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
397 X_Return_Status OUT NOCOPY VARCHAR2,
398 X_Msg_Count OUT NOCOPY NUMBER,
399 X_Msg_Data OUT NOCOPY VARCHAR2,
400 p_counter_id IN NUMBER,
401 p_object_version_number IN NUMBER,
402 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
403 x_object_version_number OUT NOCOPY NUMBER
404 -- p_user_id in number,
405 -- p_cs_counters cs_counters%rowtype
406 );
407
408 PROCEDURE CS_Counter_Value_Post_Ins(p_api_version IN NUMBER
409 , p_init_msg_list IN VARCHAR2
410 , p_commit IN VARCHAR2
411 , p_validation_level IN NUMBER
412 , p_counter_grp_log_id IN NUMBER
413 , x_return_status OUT NOCOPY VARCHAR2
414 , x_msg_count OUT NOCOPY NUMBER
415 , x_msg_data OUT NOCOPY VARCHAR2) ;
416
417 PROCEDURE CS_Counter_Value_Pre_Upd(p_api_version IN NUMBER
418 , p_init_msg_list IN VARCHAR2
419 , p_commit IN VARCHAR2
420 , p_validation_level IN NUMBER
421 , p_counter_grp_log_id IN NUMBER
422 , p_object_version_number IN NUMBER
423 , x_return_status OUT NOCOPY VARCHAR2
424 , x_msg_count OUT NOCOPY NUMBER
425 , x_msg_data OUT NOCOPY VARCHAR2
426 );
427
428 PROCEDURE CS_Counter_Property_Post_Ins(p_user_id in number,
429 p_cs_counter_prop cs_counter_properties%rowtype);
430
431 PROCEDURE CS_Counter_Property_Pre_Upd(p_user_id in number,
432 p_cs_counter_prop cs_counter_properties%rowtype);
433
434 PROCEDURE CS_Counter_Prop_Val_Post_Ins(p_user_id in number,
435 p_cs_counter_prop_val cs_counter_prop_values%rowtype);
436
437 PROCEDURE CS_Counter_Prop_Val_Pre_Upd(p_user_id in number,
438 p_cs_counter_prop_val cs_counter_prop_values%rowtype);
439 /*=============================================
440 User events
441 USER_RESP_POST_INS
442 USER_DEL
443 =============================================*/
444
445 Procedure User_Resp_Post_Ins(p_user_id in number,
446 p_responsibility_id in number);
447
448 /*--------------------------------------------------------
449 Description:
450 It starts the USER_DEL workflow process.
451 Called when a Field Service Palm user is deleted
452 Parameter(s):
453 User_ID
454 --------------------------------------------------------*/
455 Procedure User_Del(p_user_id in number);
456
457 /*--------------------------------------------------------
458 Description:
459 Raises event oracle.apps.csm.download.startsync
460 Parameter(s):
461 ENTITY, PK_VALUE & MODE
462 --------------------------------------------------------*/
463 PROCEDURE RAISE_START_AUTO_SYNC_EVENT(l_entity VARCHAR2 , l_pk_value VARCHAR2, l_mode VARCHAR2);
464
465 END CSM_WF_PKG;