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
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
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 --
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 --
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
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
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 --
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 --
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
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
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 --
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 --
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
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
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 --
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 --
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
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
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 --
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 --
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
298: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
299: ,p_output_dir IN VARCHAR2 := NULL
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
298: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
299: ,p_output_dir IN VARCHAR2 := NULL
300: ,p_debug_filename IN VARCHAR2 := NULL
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
298: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
299: ,p_output_dir IN VARCHAR2 := NULL
300: ,p_debug_filename IN VARCHAR2 := NULL
301: ,x_return_status OUT NOCOPY VARCHAR2 --
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
298: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
299: ,p_output_dir IN VARCHAR2 := NULL
300: ,p_debug_filename IN VARCHAR2 := NULL
301: ,x_return_status OUT NOCOPY VARCHAR2 --
302: ,x_msg_count OUT NOCOPY NUMBER --
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
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
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 --
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 --
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
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
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 --
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 --
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
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
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 --
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 --
382: -- change header, called by WF only
383: PROCEDURE Refresh_WF_Route
384: (
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: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
389: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
390: ,p_output_dir IN VARCHAR2 := NULL
383: PROCEDURE Refresh_WF_Route
384: (
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: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
389: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
390: ,p_output_dir IN VARCHAR2 := NULL
391: ,p_debug_filename IN VARCHAR2 := NULL
384: (
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: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
389: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
390: ,p_output_dir IN VARCHAR2 := NULL
391: ,p_debug_filename IN VARCHAR2 := NULL
392: ,x_return_status OUT NOCOPY VARCHAR2 --
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: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
389: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
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 --
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
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
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 --
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 --
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
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
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 --
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 --
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
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
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 --
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 --
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
475: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
476: ,p_output_dir IN VARCHAR2 := NULL
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
475: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
476: ,p_output_dir IN VARCHAR2 := NULL
477: ,p_debug_filename IN VARCHAR2 := NULL
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
475: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
476: ,p_output_dir IN VARCHAR2 := NULL
477: ,p_debug_filename IN VARCHAR2 := NULL
478: ,x_return_status OUT NOCOPY VARCHAR2 --
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
475: ,p_debug IN VARCHAR2 := FND_API.G_FALSE --
476: ,p_output_dir IN VARCHAR2 := NULL
477: ,p_debug_filename IN VARCHAR2 := NULL
478: ,x_return_status OUT NOCOPY VARCHAR2 --
479: ,x_msg_count OUT NOCOPY NUMBER --