[Home] [Help]
PACKAGE: APPS.CSM_WF_PKG
Source
1 PACKAGE CSM_WF_PKG AS
2 /* $Header: csmewfs.pls 120.1 2005/07/25 01:09:21 trajasek noship $ */
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
10 =========================================================*/
11 /*--------------------------------------------------
12 Description:
13 Starts the TASK_ASSIGNMENT_INS workflow. Should be called when new
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);
146
147 /*=========================================================
148 2 events related to CSP_REQUIREMENT_LINES_PVT IUHK
149 CSP_SHIP_TO_ADDRESS_POST_INS
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
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);
267
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 /*=============================================
281 7 events for counters VUHK
282 CS_Counter_Post_Ins (rarely needed)
283 CS_Counter_Pre_Upd (rarely needed)
284 CS_Counter_Property_Post_Ins (rarely needed)
285 CS_Counter_Property_Pre_Upd (rarely needed)
286 CS_Counter_Value_Post_Ins
287 CS_Counter_Value_Pre_Upd
288 CS_Counter_Prop_Val_Post_Ins
289 CS_Counter_Prop_Val_Pre_Upd (probably not needed)
290 *=============================================*/
291
292 PROCEDURE CS_Counter_Post_Ins(
293 P_Api_Version IN NUMBER,
294 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
295 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
296 X_Return_Status OUT NOCOPY VARCHAR2,
297 X_Msg_Count OUT NOCOPY NUMBER,
298 X_Msg_Data OUT NOCOPY VARCHAR2,
299 p_counter_id IN NUMBER,
300 x_object_version_number OUT NOCOPY NUMBER
301 -- p_user_id in number,
302 -- p_counter_id cs_counters.counter_id%type
303 );
304
305 Procedure CS_Counter_Pre_Del(
306 P_Api_Version IN NUMBER,
307 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
308 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
309 X_Return_Status OUT NOCOPY VARCHAR2,
310 X_Msg_Count OUT NOCOPY NUMBER,
311 X_Msg_Data OUT NOCOPY VARCHAR2,
312 p_counter_id IN NUMBER
313 );
314
315
316 PROCEDURE CS_CTR_GRP_INSTANCE_CRE_POST(
317 P_Api_Version IN NUMBER,
318 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
319 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
320 X_Return_Status OUT NOCOPY VARCHAR2,
321 X_Msg_Count OUT NOCOPY NUMBER,
322 X_Msg_Data OUT NOCOPY VARCHAR2,
323 p_source_object_cd IN VARCHAR2,
324 p_source_object_id IN NUMBER,
325 p_ctr_grp_id IN NUMBER,
326 x_object_version_number OUT NOCOPY NUMBER
327 );
328
329 PROCEDURE CS_CTR_GRP_INSTANCE_PRE_DEL(
330 P_Api_Version IN NUMBER,
331 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
332 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
333 X_Return_Status OUT NOCOPY VARCHAR2,
334 X_Msg_Count OUT NOCOPY NUMBER,
335 X_Msg_Data OUT NOCOPY VARCHAR2,
336 p_source_object_cd IN VARCHAR2,
337 p_source_object_id IN NUMBER
338 );
339
340 PROCEDURE CS_COUNTER_GRP_Post_Upd( P_Api_Version IN NUMBER
341 , P_Init_Msg_List IN VARCHAR2
342 , P_Commit IN VARCHAR2
343 , X_Return_Status OUT NOCOPY VARCHAR2
344 , X_Msg_Count OUT NOCOPY NUMBER
345 , X_Msg_Data OUT NOCOPY VARCHAR2
346 , p_ctr_grp_id IN NUMBER
347 , p_object_version_number IN NUMBER
348 , p_cascade_upd_to_instances IN VARCHAR2
349 , x_object_version_number OUT NOCOPY NUMBER );
350
351 PROCEDURE CS_COUNTERS_INSTANTIATE_POST(
352 P_Api_Version IN NUMBER,
353 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
354 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
355 X_Return_Status OUT NOCOPY VARCHAR2,
356 X_Msg_Count OUT NOCOPY NUMBER,
357 X_Msg_Data OUT NOCOPY VARCHAR2,
358 p_counter_group_id_template IN NUMBER,
359 p_source_object_cd IN VARCHAR2,
360 p_source_object_id IN NUMBER,
361 x_ctr_grp_id_template IN NUMBER,
362 p_ctr_grp_id IN NUMBER
363 );
364
365 PROCEDURE CS_Counter_Pre_Upd(
366 P_Api_Version IN NUMBER,
367 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
368 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
369 X_Return_Status OUT NOCOPY VARCHAR2,
370 X_Msg_Count OUT NOCOPY NUMBER,
371 X_Msg_Data OUT NOCOPY VARCHAR2,
372 p_counter_id IN NUMBER,
373 p_object_version_number IN NUMBER,
374 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
375 x_object_version_number OUT NOCOPY NUMBER
376 -- p_user_id in number,
377 -- p_cs_counters cs_counters%rowtype
378 );
379 /*
380 SAGRAWAL Added other parameters
381 PROCEDURE CS_Counter_Value_Post_Ins(p_counter_value_id in number);
382 */
383
384 PROCEDURE CS_Counter_Post_Upd(
385 P_Api_Version IN NUMBER,
386 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
387 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
388 X_Return_Status OUT NOCOPY VARCHAR2,
389 X_Msg_Count OUT NOCOPY NUMBER,
390 X_Msg_Data OUT NOCOPY VARCHAR2,
391 p_counter_id IN NUMBER,
392 p_object_version_number IN NUMBER,
393 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
394 x_object_version_number OUT NOCOPY NUMBER
395 -- p_user_id in number,
396 -- p_cs_counters cs_counters%rowtype
397 );
398
399 PROCEDURE CS_Counter_Value_Post_Ins(p_api_version IN NUMBER
400 , p_init_msg_list IN VARCHAR2
401 , p_commit IN VARCHAR2
402 , p_validation_level IN NUMBER
403 , p_counter_grp_log_id IN NUMBER
404 , x_return_status OUT NOCOPY VARCHAR2
405 , x_msg_count OUT NOCOPY NUMBER
406 , x_msg_data OUT NOCOPY VARCHAR2) ;
407
408 PROCEDURE CS_Counter_Value_Pre_Upd(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 , p_object_version_number IN NUMBER
414 , x_return_status OUT NOCOPY VARCHAR2
415 , x_msg_count OUT NOCOPY NUMBER
416 , x_msg_data OUT NOCOPY VARCHAR2
417 );
418
419 PROCEDURE CS_Counter_Property_Post_Ins(p_user_id in number,
420 p_cs_counter_prop cs_counter_properties%rowtype);
421
422 PROCEDURE CS_Counter_Property_Pre_Upd(p_user_id in number,
423 p_cs_counter_prop cs_counter_properties%rowtype);
424
425 PROCEDURE CS_Counter_Prop_Val_Post_Ins(p_user_id in number,
426 p_cs_counter_prop_val cs_counter_prop_values%rowtype);
427
428 PROCEDURE CS_Counter_Prop_Val_Pre_Upd(p_user_id in number,
429 p_cs_counter_prop_val cs_counter_prop_values%rowtype);
430 /*=============================================
431 User events
432 USER_RESP_POST_INS
433 USER_DEL
434 =============================================*/
435
436 Procedure User_Resp_Post_Ins(p_user_id in number,
437 p_responsibility_id in number);
438
439 /*--------------------------------------------------------
440 Description:
441 It starts the USER_DEL workflow process.
442 Called when a Field Service Palm user is deleted
443 Parameter(s):
444 User_ID
445 --------------------------------------------------------*/
446 Procedure User_Del(p_user_id in number);
447
448 END CSM_WF_PKG;