1 PACKAGE ENG_CHANGE_LIFECYCLE_UTIL AS
2 /* $Header: ENGULCMS.pls 120.6 2007/07/04 10:58:09 sdarbha ship $ */
3
4 -- Global constants --
5 -- change objects, subjects
6 G_ENG_CHANGE CONSTANT VARCHAR2(30) := 'ENG_CHANGE';
7 G_ENG_CHG_LINE CONSTANT VARCHAR2(30) := 'ENG_CHANGE_LINE';
8 G_ENG_REVISED_ITEM CONSTANT VARCHAR2(30) := 'ENG_REVISED_ITEM';
9
10 -- change types
11 G_ENG_ECO CONSTANT VARCHAR2(30) := 'CHANGE_ORDER';
12 G_ENG_ATTACHMENT_APPR CONSTANT VARCHAR2(30) := 'ATTACHMENT_APPROVAL';
13 G_ENG_ATTACHMENT_REVW CONSTANT VARCHAR2(30) := 'ATTACHMENT_REVIEW';
14 G_ENG_NEW_ITEM_REQ CONSTANT VARCHAR2(30) := 'NEW_ITEM_REQUEST';
15 G_ENG_ISSUE CONSTANT VARCHAR2(30) := 'ISSUE';
16
17 G_ENG_PROMOTE CONSTANT VARCHAR2(30) := 'PROMOTE';
18 G_ENG_DEMOTE CONSTANT VARCHAR2(30) := 'DEMOTE';
19
20 --- Seeded status_type
21 G_ENG_DRAFT CONSTANT NUMBER := 0;
22 G_ENG_OPEN CONSTANT NUMBER := 1;
23 G_ENG_HOLD CONSTANT NUMBER := 2;
24 G_ENG_CANCELLED CONSTANT NUMBER := 5;
25 G_ENG_IMPLEMENTED CONSTANT NUMBER := 6;
26 G_ENG_APPROVED CONSTANT NUMBER := 8;
27 G_ENG_IMP_IN_PROGRESS CONSTANT NUMBER := 9;
28 G_ENG_IMP_FAILED CONSTANT NUMBER := 10;
29 G_ENG_COMPLETED CONSTANT NUMBER := 11;
30 G_ENG_REVIEWED CONSTANT NUMBER := 12;
31
32 -- line status types
33 G_LINE_OPEN CONSTANT VARCHAR2(30) := '1';
34 G_LINE_CANCELLED CONSTANT VARCHAR2(30) := '5';
35 G_LINE_COMPLETED CONSTANT VARCHAR2(30) := '11';
36
37 -- Seeded approval_status_type for change header
38 G_ENG_NOT_SUBMITTED CONSTANT NUMBER := 1; -- Not submitted for approval
39 G_ENG_READY_TO_APPR CONSTANT NUMBER := 2; -- Ready for approval
40 G_ENG_APPR_REQUESTED CONSTANT NUMBER := 3; -- Approval requested
41 G_ENG_APPR_REJECTED CONSTANT NUMBER := 4; -- Approval rejected
42 G_ENG_APPR_APPROVED CONSTANT NUMBER := 5; -- Approval approved
43 G_ENG_APPR_NO_NEED CONSTANT NUMBER := 6; -- Approval not needed
44 G_ENG_APPR_PROC_ERR CONSTANT NUMBER := 7; -- Approval process error
45 G_ENG_APPR_TIME_OUT CONSTANT NUMBER := 8; -- Approval time out
46
47
48 -- Workflow related
49 G_ENG_WF_USER_ID CONSTANT NUMBER := -10000;
50 G_ENG_WF_LOGIN_ID CONSTANT NUMBER := '';
51 -- Concurrent Program, right now set it to be the same as workflow
52 G_ENG_CP_USER_ID CONSTANT NUMBER := -10000;
53 G_ENG_CP_LOGIN_ID CONSTANT NUMBER := '';
54
55 --- Seeded phase level workflow status codes
56 -- in Package: ENG_WORKFLOW_UTIL
57 -- G_RT_NOT_STARTED CONSTANT VARCHAR2(30) := 'NOT_STARTED' ; -- Not Started
58 -- G_RT_IN_PROGRESS CONSTANT VARCHAR2(30) := 'IN_PROGRESS' ; -- In Progress
59 -- G_RT_APPROVED CONSTANT VARCHAR2(30) := 'APPROVED' ; -- Approved
60 -- G_RT_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED' ; -- Rejected
61 -- G_RT_TIME_OUT CONSTANT VARCHAR2(30) := 'TIME_OUT' ; -- Time Out
62 -- G_RT_ABORTED CONSTANT VARCHAR2(30) := 'ABORTED' ; -- Aborted
63 -- G_RT_COMPLETED CONSTANT VARCHAR2(30) := 'COMPLETED' ; -- Completed
64 -- G_RT_REPLIED CONSTANT VARCHAR2(30) := 'REPLIED' ; -- Replied
65
66
67 /********************************************************************
68 * Debug APIs : Open_Debug_Session, Close_Debug_Session,
69 * Write_Debug
70 * Parameters IN :
71 * Parameters OUT:
72 * Purpose : These procedures are for test and debug
73 *********************************************************************/
74 -- Open_Debug_Session
75 PROCEDURE Open_Debug_Session
76 ( p_output_dir IN VARCHAR2 := NULL
77 , p_file_name IN VARCHAR2 := NULL
78 );
79
80 -- Close Debug_Session
81 PROCEDURE Close_Debug_Session ;
82
83 -- Write Debug Message
84 PROCEDURE Write_Debug
85 ( p_debug_message IN VARCHAR2 ) ;
86
87 -- Write Debug Mode from Workflow Function Activities
88 PROCEDURE Get_Debug_Mode
89 ( p_item_type IN VARCHAR2
90 , p_item_key IN VARCHAR2
91 , x_debug_flag OUT NOCOPY BOOLEAN
92 , x_output_dir OUT NOCOPY VARCHAR2
93 , x_debug_filename OUT NOCOPY VARCHAR2
94 );
95
96
97
98 -- Internal procedure to raise cm status change events
99 /*
100 PROCEDURE Raise_Status_Change_Event
101 (
102 p_change_id IN NUMBER
103 ,p_base_cm_type_code IN VARCHAR2
104 ,p_status_code IN NUMBER
105 ,p_action_type IN VARCHAR2
106 ,p_action_id IN NUMBER
107 );
108 */
109
110
111
112 -- Special internal utility procedure to updateBug
113 -- Note that the bugDB API may or may not exist so the call must be dynamic
114 /*
115 PROCEDURE Update_Bug
116 (
117 p_change_id IN NUMBER -- header's change_id
118 ,p_action_type IN VARCHAR2
119 ,p_description IN VARCHAR2
120 );
121 */
122
123
124 -- Internal utility procedure to check if the header is CO and on its last
125 -- implement phase
126 /*
127 PROCEDURE Is_CO_On_Last_Imp_Phase
128 (
129 p_change_id IN NUMBER
130 ,p_api_caller IN VARCHAR2
131 ,x_is_co_last_phase OUT NOCOPY VARCHAR2
132 --,x_curr_status_code OUT NOCOPY NUMBER
133 --,x_last_status_code OUT NOCOPY NUMBER
134 ,x_auto_demote_status OUT NOCOPY NUMBER
135 );
136 */
137
138
139 -- Internal utility procedure to check if the header is CO and its last
140 -- implement phase has been used
141 /*
142 PROCEDURE Is_CO_Last_Imp_Phase_Used
143 (
144 p_change_id IN NUMBER
145 ,x_is_used OUT NOCOPY VARCHAR2
146 ,x_last_status_type OUT NOCOPY NUMBER
147 ,x_last_status_code OUT NOCOPY NUMBER
148 );
149 */
150
151
152 -- Internal procedure to return if a co has active revised items
153 -- active revised items are defined as those with status other than
154 -- 5(cancelled) or 6(implemented)
155 /*
156 PROCEDURE Has_Active_RevItem
157 (
158 p_change_id IN NUMBER
159 ,x_found OUT NOCOPY VARCHAR2
160 );
161 */
162
163
164
165 -- Internal utility procedure to update header approval status
166 -- together with launching associated workflow
167 /*
168 PROCEDURE Update_Header_Appr_Status
169 (
170 p_api_version IN NUMBER --
171 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
172 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
173 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
174 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
175 ,p_output_dir IN VARCHAR2 := NULL
176 ,p_debug_filename IN VARCHAR2 := NULL
177 ,x_return_status OUT NOCOPY VARCHAR2 --
178 ,x_msg_count OUT NOCOPY NUMBER --
179 ,x_msg_data OUT NOCOPY VARCHAR2 --
180 ,p_change_id IN NUMBER -- header's change_id
181 ,p_status_code IN NUMBER
182 ,p_appr_status IN NUMBER -- header approval status
183 ,p_route_status IN VARCHAR2 -- workflow routing status (for document types)
184 ,p_api_caller IN VARCHAR2 := 'UI' -- must
185 ,p_bypass IN VARCHAR2 := 'N' -- flag to bypass phase type check
186 );
187 */
188
189
190
191
192
193
194 -- Internal procedure to automatically launch workflow if necessary
195 -- (i.e., when start_workflow_flag is set to 'Y') for the specified phase
196 -- Note that this procedure may also submit the concurrent program for
197 -- implementing ECO as well!!!
198 /*
199 PROCEDURE Start_WF_OnlyIf_Necessary
200 (
201 p_api_version IN NUMBER --
202 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
203 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
204 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
205 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
206 ,p_output_dir IN VARCHAR2 := NULL
207 ,p_debug_filename IN VARCHAR2 := NULL
208 ,x_return_status OUT NOCOPY VARCHAR2 --
209 ,x_msg_count OUT NOCOPY NUMBER --
210 ,x_msg_data OUT NOCOPY VARCHAR2 --
211 ,p_change_id IN NUMBER -- header's change_id
212 ,p_status_code IN NUMBER -- new phase
213 ,p_status_type IN NUMBER -- new phase type
214 ,p_sequence_number IN NUMBER -- new phase sequence number
215 ,p_imp_eco_flag IN VARCHAR2 := 'N' -- flag for implementECO
216 ,p_api_caller IN VARCHAR2 := NULL -- can also be 'WF'
217 ,p_action_type IN VARCHAR2 := NULL -- or PROMOTE, DEMOTE
218 ,p_comment IN VARCHAR2 := NULL -- only used for co promote-to-implement action
219 ,p_skip_wf IN VARCHAR2 := 'N' -- used for eco's last implement phase
220 );
221 */
222
223 -- Internal procedure for promotion of change header (inc. revItems)
224 /*
225 PROCEDURE Promote_Header
226 (
227 p_api_version IN NUMBER --
228 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
229 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
230 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
231 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
232 ,p_output_dir IN VARCHAR2 := NULL
233 ,p_debug_filename IN VARCHAR2 := NULL
234 ,x_return_status OUT NOCOPY VARCHAR2 --
235 ,x_msg_count OUT NOCOPY NUMBER --
236 ,x_msg_data OUT NOCOPY VARCHAR2 --
237 ,p_change_id IN NUMBER -- header's change_id
238 ,p_status_code IN NUMBER -- new phase
239 ,p_update_ri_flag IN VARCHAR2 := 'Y' -- can also be 'N'
240 ,p_api_caller IN VARCHAR2 := NULL -- can also be 'WF'
241 ,p_comment IN VARCHAR2 := NULL -- only used for co promote-to-implement action
242 );
243 */
244
245 -- Internal procedure for demotion of change header (inc. revItems)
246 -- Note that even though this procedure shares the same argument list
247 -- as Promote_Header procedure, the internal logic is quite different,
248 -- so it is written as a seperate procedure for easier understanding.
249 /*
250 PROCEDURE Demote_Header
251 (
252 p_api_version IN NUMBER --
253 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
254 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
255 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
256 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
257 ,p_output_dir IN VARCHAR2 := NULL
258 ,p_debug_filename IN VARCHAR2 := NULL
259 ,x_return_status OUT NOCOPY VARCHAR2 --
260 ,x_msg_count OUT NOCOPY NUMBER --
261 ,x_msg_data OUT NOCOPY VARCHAR2 --
262 ,p_change_id IN NUMBER -- header's change_id
263 ,p_status_code IN NUMBER -- new phase
264 ,p_update_ri_flag IN VARCHAR2 := 'Y' -- can also be 'N'
265 ,p_api_caller IN VARCHAR2 := NULL -- can also be 'WF'
266 );
267 */
268
269 -- Internal procedure for promotion of a revised item
270 /*
271 PROCEDURE Promote_Revised_Item
272 (
273 p_api_version IN NUMBER --
274 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
275 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
276 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
277 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
278 ,p_output_dir IN VARCHAR2 := NULL
279 ,p_debug_filename IN VARCHAR2 := NULL
280 ,x_return_status OUT NOCOPY VARCHAR2 --
281 ,x_msg_count OUT NOCOPY NUMBER --
282 ,x_msg_data OUT NOCOPY VARCHAR2 --
283 ,p_change_id IN NUMBER -- header's change_id
284 ,p_object_id2 IN NUMBER -- revised item sequence id
285 ,p_status_code IN NUMBER -- new phase
286 ,p_api_caller IN VARCHAR2 := NULL -- can also be 'WF'
287 );
288 */
289
290 -- Internal procedure for demotion of change header (inc. revItems)
291 /*
292 PROCEDURE Demote_Revised_Item
293 (
294 p_api_version IN NUMBER --
295 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
296 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
297 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
301 ,x_return_status OUT NOCOPY VARCHAR2 --
298 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
299 ,p_output_dir IN VARCHAR2 := NULL
300 ,p_debug_filename IN VARCHAR2 := NULL
302 ,x_msg_count OUT NOCOPY NUMBER --
303 ,x_msg_data OUT NOCOPY VARCHAR2 --
304 ,p_change_id IN NUMBER -- header's change_id
305 ,p_object_id2 IN NUMBER -- revised item sequence id
306 ,p_status_code IN NUMBER -- new phase
307 ,p_api_caller IN VARCHAR2 := NULL -- can also be 'WF'
308 );
309 */
310
311 -- Interface procedure for combining promotion/demotion procedures
312 -- Note that this procedure can ONLY be called directly from UI
313 PROCEDURE Change_Phase
314 (
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 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
319 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
320 ,p_output_dir IN VARCHAR2 := NULL
321 ,p_debug_filename IN VARCHAR2 := NULL
322 ,x_return_status OUT NOCOPY VARCHAR2 --
323 ,x_msg_count OUT NOCOPY NUMBER --
324 ,x_msg_data OUT NOCOPY VARCHAR2 --
325 ,p_object_name IN VARCHAR2 := 'ENG_CHANGE'
326 ,p_change_id IN NUMBER -- header's change_id
327 ,p_object_id2 IN NUMBER := NULL -- revised item seq id
328 ,p_status_code IN NUMBER -- new phase
329 ,p_update_ri_flag IN VARCHAR2 := 'Y' -- can also be 'N'
330 ,p_api_caller IN VARCHAR2 := 'UI' -- must
331 ,p_action_type IN VARCHAR2 := G_ENG_PROMOTE -- promote/demote
332 ,p_comment IN VARCHAR2 := NULL -- only used for co promote-to-implement action
333 ,x_sfa_line_items_exists OUT NOCOPY VARCHAR2
334 );
335
336 PROCEDURE Change_Phase
337 (
338 p_api_version IN NUMBER --
339 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
340 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
341 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
342 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
343 ,p_output_dir IN VARCHAR2 := NULL
344 ,p_debug_filename IN VARCHAR2 := NULL
345 ,x_return_status OUT NOCOPY VARCHAR2 --
346 ,x_msg_count OUT NOCOPY NUMBER --
347 ,x_msg_data OUT NOCOPY VARCHAR2 --
348 ,p_object_name IN VARCHAR2 := 'ENG_CHANGE'
349 ,p_change_id IN NUMBER -- header's change_id
350 ,p_object_id2 IN NUMBER := NULL -- revised item seq id
351 ,p_status_code IN NUMBER -- new phase
352 ,p_update_ri_flag IN VARCHAR2 := 'Y' -- can also be 'N'
353 ,p_api_caller IN VARCHAR2 := 'UI' -- must
354 ,p_action_type IN VARCHAR2 := G_ENG_PROMOTE -- promote/demote
355 ,p_comment IN VARCHAR2 := NULL -- only used for co promote-to-implement action
356 );
357
358 -- Procedure to be called by WF to update lifecycle states of the change header,
359 -- revised items, tasks and lines lifecycle states
360 PROCEDURE Update_Lifecycle_States
361 (
362 p_api_version IN NUMBER --
363 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
364 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
365 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
366 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
367 ,p_output_dir IN VARCHAR2 := NULL
368 ,p_debug_filename IN VARCHAR2 := NULL
369 ,x_return_status OUT NOCOPY VARCHAR2 --
370 ,x_msg_count OUT NOCOPY NUMBER --
371 ,x_msg_data OUT NOCOPY VARCHAR2 --
372 ,p_change_id IN NUMBER
373 ,p_status_code IN NUMBER := NULL -- passed only by workflow call for p_route_status = IN_PROGRESS
374 ,p_api_caller IN VARCHAR2 := NULL -- or 'WF'
375 ,p_wf_route_id IN NUMBER
376 ,p_route_status IN VARCHAR2
377 ,p_comment IN VARCHAR2 := NULL -- only used for co promote-to-implement action
378 );
379
380
381 -- Procedure to refresh the route_id of the currently active phase of a particular
382 -- change header, called by WF only
383 PROCEDURE Refresh_WF_Route
384 (
385 p_api_version IN NUMBER --
389 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
386 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
387 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
388 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
390 ,p_output_dir IN VARCHAR2 := NULL
391 ,p_debug_filename IN VARCHAR2 := NULL
392 ,x_return_status OUT NOCOPY VARCHAR2 --
393 ,x_msg_count OUT NOCOPY NUMBER --
394 ,x_msg_data OUT NOCOPY VARCHAR2 --
395 ,p_change_id IN NUMBER
396 ,p_status_code IN NUMBER
397 ,p_wf_route_id IN NUMBER
398 ,p_api_caller IN VARCHAR2 := NULL -- or 'WF'
399 );
400
401
402 -- Procedure to automatically initialize lifecycles for a new change header
403 -- It also takes care of automatically launching the workflow if nedded
404 -- Note that this procedure can ONLY be called directly from UI
405 PROCEDURE Init_Lifecycle
406 (
407 p_api_version IN NUMBER --
408 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
409 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
410 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
411 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
412 ,p_output_dir IN VARCHAR2 := NULL
413 ,p_debug_filename IN VARCHAR2 := NULL
414 ,x_return_status OUT NOCOPY VARCHAR2 --
415 ,x_msg_count OUT NOCOPY NUMBER --
416 ,x_msg_data OUT NOCOPY VARCHAR2 --
417 ,p_change_id IN NUMBER -- header's change_id
418 ,p_api_caller IN VARCHAR2 := 'UI' -- must
419 ,p_init_status_code IN NUMBER := NULL -- R12
420 ,p_init_option IN VARCHAR2 := NULL -- R12
421 );
422
423
424 -- Procedure to be called by revised item implementation concurrent
425 -- program to set its status_type
426 PROCEDURE Update_RevItem_Lifecycle
427 (
428 p_api_version IN NUMBER --
429 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
430 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
431 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
432 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
433 ,p_output_dir IN VARCHAR2 := NULL
434 ,p_debug_filename IN VARCHAR2 := NULL
435 ,x_return_status OUT NOCOPY VARCHAR2 --
436 ,x_msg_count OUT NOCOPY NUMBER --
437 ,x_msg_data OUT NOCOPY VARCHAR2 --
438 ,p_rev_item_seq_id IN NUMBER
439 ,p_status_type IN NUMBER -- say 10 for imp_failed
440 ,p_api_caller IN VARCHAR2 := NULL -- 'CP'
441 );
442
443 -- Reset Phase
444 -- R12B
445 -- Called when Reset Workflow button pressed in Workflow UI
446 -- to reset Dcoument Status
447 PROCEDURE Reset_Phase
448 (
449 p_api_version IN NUMBER --
450 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
451 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
452 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
453 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
454 ,p_output_dir IN VARCHAR2 := NULL
455 ,p_debug_filename IN VARCHAR2 := NULL
456 ,x_return_status OUT NOCOPY VARCHAR2 --
457 ,x_msg_count OUT NOCOPY NUMBER --
458 ,x_msg_data OUT NOCOPY VARCHAR2 --
459 ,p_change_id IN NUMBER -- header's change_id
460 ,p_status_code IN NUMBER := NULL -- reset phase/status code
461 ,p_api_caller IN VARCHAR2 := NULL -- can also be 'WF'
462 ) ;
463
464 -- Sync_LC_Phase_Setup
465 -- R12B Sync Workflow Statuses/Lifecycle Phases
466 -- If a phase is added or removed in an existing lifecycle setup which is already being used by
467 -- some change objects including document lc change objects then the lifecycles of the change object
468 -- would be reflected
469 PROCEDURE Sync_LC_Phase_Setup
470 (
471 p_api_version IN NUMBER --
472 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE --
473 ,p_commit IN VARCHAR2 := FND_API.G_FALSE --
474 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
478 ,x_return_status OUT NOCOPY VARCHAR2 --
475 ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
476 ,p_output_dir IN VARCHAR2 := NULL
477 ,p_debug_filename IN VARCHAR2 := NULL
479 ,x_msg_count OUT NOCOPY NUMBER --
480 ,x_msg_data OUT NOCOPY VARCHAR2 --
481 ,p_change_type_id IN NUMBER -- header's change_type_id
482 ,p_api_caller IN VARCHAR2 := NULL -- Future Use
483 ) ;
484
485
486 END ENG_CHANGE_LIFECYCLE_UTIL;
487