50: TYPE PA_NUM_1000_NUM IS VARRAY(1000) OF NUMBER;
51:
52: PROCEDURE UPDATE_TASK_PROGRESS(
53: p_api_version IN NUMBER :=1.0 ,
54: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
55: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
56: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
57: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
58: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
51:
52: PROCEDURE UPDATE_TASK_PROGRESS(
53: p_api_version IN NUMBER :=1.0 ,
54: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
55: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
56: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
57: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
58: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
59: p_calling_mode IN VARCHAR2 := null ,
52: PROCEDURE UPDATE_TASK_PROGRESS(
53: p_api_version IN NUMBER :=1.0 ,
54: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
55: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
56: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
57: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
58: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
59: p_calling_mode IN VARCHAR2 := null ,
60: p_debug_mode IN VARCHAR2 :='N' ,
53: p_api_version IN NUMBER :=1.0 ,
54: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
55: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
56: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
57: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
58: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
59: p_calling_mode IN VARCHAR2 := null ,
60: p_debug_mode IN VARCHAR2 :='N' ,
61: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
124: -- End of comments
125:
126: PROCEDURE ROLLUP_PROGRESS_PVT(
127: p_api_version IN NUMBER :=1.0
128: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
129: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
130: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
131: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
132: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
125:
126: PROCEDURE ROLLUP_PROGRESS_PVT(
127: p_api_version IN NUMBER :=1.0
128: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
129: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
130: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
131: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
132: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
133: ,p_debug_mode IN VARCHAR2 :='N'
126: PROCEDURE ROLLUP_PROGRESS_PVT(
127: p_api_version IN NUMBER :=1.0
128: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
129: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
130: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
131: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
132: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
133: ,p_debug_mode IN VARCHAR2 :='N'
134: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
127: p_api_version IN NUMBER :=1.0
128: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
129: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
130: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
131: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
132: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
133: ,p_debug_mode IN VARCHAR2 :='N'
134: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
135: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
176: -- End of comments
177:
178: PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
179: p_api_version IN NUMBER :=1.0
180: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
181: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
183: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
184: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
177:
178: PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
179: p_api_version IN NUMBER :=1.0
180: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
181: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
183: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
184: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
185: ,p_debug_mode IN VARCHAR2 :='N'
178: PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
179: p_api_version IN NUMBER :=1.0
180: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
181: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
183: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
184: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
185: ,p_debug_mode IN VARCHAR2 :='N'
186: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
179: p_api_version IN NUMBER :=1.0
180: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
181: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
182: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
183: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
184: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
185: ,p_debug_mode IN VARCHAR2 :='N'
186: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
187: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
205: );
206:
207: PROCEDURE CREATE_PROJ_PROG_ATTR(
208: p_api_version IN NUMBER :=1.0
209: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
210: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
211: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
212: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
213: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
206:
207: PROCEDURE CREATE_PROJ_PROG_ATTR(
208: p_api_version IN NUMBER :=1.0
209: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
210: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
211: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
212: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
213: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
214: ,p_debug_mode IN VARCHAR2 :='N'
207: PROCEDURE CREATE_PROJ_PROG_ATTR(
208: p_api_version IN NUMBER :=1.0
209: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
210: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
211: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
212: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
213: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
214: ,p_debug_mode IN VARCHAR2 :='N'
215: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
208: p_api_version IN NUMBER :=1.0
209: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
210: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
211: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
212: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
213: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
214: ,p_debug_mode IN VARCHAR2 :='N'
215: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
216: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
234: );
235:
236: PROCEDURE UPDATE_PROJ_PROG_ATTR(
237: p_api_version IN NUMBER :=1.0
238: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
239: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
240: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
241: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
242: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
235:
236: PROCEDURE UPDATE_PROJ_PROG_ATTR(
237: p_api_version IN NUMBER :=1.0
238: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
239: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
240: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
241: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
242: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
243: ,p_debug_mode IN VARCHAR2 :='N'
236: PROCEDURE UPDATE_PROJ_PROG_ATTR(
237: p_api_version IN NUMBER :=1.0
238: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
239: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
240: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
241: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
242: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
243: ,p_debug_mode IN VARCHAR2 :='N'
244: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
237: p_api_version IN NUMBER :=1.0
238: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
239: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
240: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
241: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
242: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
243: ,p_debug_mode IN VARCHAR2 :='N'
244: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
245: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
263: );
264:
265: PROCEDURE DELETE_PROJ_PROG_ATTR(
266: p_api_version IN NUMBER :=1.0
267: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
268: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
269: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
270: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
271: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
264:
265: PROCEDURE DELETE_PROJ_PROG_ATTR(
266: p_api_version IN NUMBER :=1.0
267: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
268: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
269: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
270: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
271: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
272: ,p_debug_mode IN VARCHAR2 :='N'
265: PROCEDURE DELETE_PROJ_PROG_ATTR(
266: p_api_version IN NUMBER :=1.0
267: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
268: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
269: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
270: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
271: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
272: ,p_debug_mode IN VARCHAR2 :='N'
273: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
266: p_api_version IN NUMBER :=1.0
267: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
268: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
269: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
270: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
271: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
272: ,p_debug_mode IN VARCHAR2 :='N'
273: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
274: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
281: );
282:
283: PROCEDURE delete_progress_record(
284: p_api_version IN NUMBER :=1.0
285: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
286: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
287: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
282:
283: PROCEDURE delete_progress_record(
284: p_api_version IN NUMBER :=1.0
285: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
286: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
287: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
290: ,p_debug_mode IN VARCHAR2 :='N'
283: PROCEDURE delete_progress_record(
284: p_api_version IN NUMBER :=1.0
285: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
286: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
287: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
290: ,p_debug_mode IN VARCHAR2 :='N'
291: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
284: p_api_version IN NUMBER :=1.0
285: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
286: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
287: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
288: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
289: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
290: ,p_debug_mode IN VARCHAR2 :='N'
291: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
292: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
297: );
298:
299: PROCEDURE push_down_task_status(
300: p_api_version IN NUMBER :=1.0
301: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
302: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
298:
299: PROCEDURE push_down_task_status(
300: p_api_version IN NUMBER :=1.0
301: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
302: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
306: ,p_debug_mode IN VARCHAR2 :='N'
299: PROCEDURE push_down_task_status(
300: p_api_version IN NUMBER :=1.0
301: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
302: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
306: ,p_debug_mode IN VARCHAR2 :='N'
307: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
300: p_api_version IN NUMBER :=1.0
301: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
302: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
303: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
304: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
305: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
306: ,p_debug_mode IN VARCHAR2 :='N'
307: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
308: ,p_task_status IN VARCHAR2
358: -- Progress Management Changes. Bug # 3420093.
359:
360: PROCEDURE apply_lp_prog_on_cwv(
361: p_api_version IN NUMBER :=1.0
362: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
363: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
364: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
365: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
366: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
359:
360: PROCEDURE apply_lp_prog_on_cwv(
361: p_api_version IN NUMBER :=1.0
362: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
363: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
364: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
365: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
366: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
367: ,p_debug_mode IN VARCHAR2 :='N'
360: PROCEDURE apply_lp_prog_on_cwv(
361: p_api_version IN NUMBER :=1.0
362: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
363: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
364: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
365: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
366: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
367: ,p_debug_mode IN VARCHAR2 :='N'
368: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
361: p_api_version IN NUMBER :=1.0
362: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
363: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
364: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
365: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
366: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
367: ,p_debug_mode IN VARCHAR2 :='N'
368: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
369: ,p_project_id IN NUMBER
376: -- Progress Management Changes. Bug # 3420093.
377:
378: PROCEDURE delete_working_wp_progress(
379: p_api_version IN NUMBER :=1.0
380: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
381: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
382: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
383: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
384: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
377:
378: PROCEDURE delete_working_wp_progress(
379: p_api_version IN NUMBER :=1.0
380: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
381: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
382: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
383: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
384: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
385: ,p_debug_mode IN VARCHAR2 :='N'
378: PROCEDURE delete_working_wp_progress(
379: p_api_version IN NUMBER :=1.0
380: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
381: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
382: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
383: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
384: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
385: ,p_debug_mode IN VARCHAR2 :='N'
386: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
379: p_api_version IN NUMBER :=1.0
380: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
381: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
382: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
383: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
384: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
385: ,p_debug_mode IN VARCHAR2 :='N'
386: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
387: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
396: -- Progress Management Changes. Bug # 3420093.
397:
398: Procedure PULL_SUMMARIZED_ACTUALS (
399: p_api_version IN NUMBER :=1.0
400: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
401: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
402: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
403: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
404: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
397:
398: Procedure PULL_SUMMARIZED_ACTUALS (
399: p_api_version IN NUMBER :=1.0
400: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
401: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
402: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
403: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
404: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
405: ,p_debug_mode IN VARCHAR2 :='N'
398: Procedure PULL_SUMMARIZED_ACTUALS (
399: p_api_version IN NUMBER :=1.0
400: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
401: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
402: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
403: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
404: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
405: ,p_debug_mode IN VARCHAR2 :='N'
406: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
399: p_api_version IN NUMBER :=1.0
400: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
401: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
402: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
403: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
404: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
405: ,p_debug_mode IN VARCHAR2 :='N'
406: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
407: ,P_Project_ID IN NUMBER
414: -- Progress Management Changes. Bug # 3420093.
415:
416: PROCEDURE update_progress(
417: p_api_version IN NUMBER :=1.0
418: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
419: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
420: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
421: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
422: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
415:
416: PROCEDURE update_progress(
417: p_api_version IN NUMBER :=1.0
418: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
419: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
420: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
421: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
422: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
423: ,p_debug_mode IN VARCHAR2 :='N'
416: PROCEDURE update_progress(
417: p_api_version IN NUMBER :=1.0
418: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
419: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
420: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
421: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
422: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
423: ,p_debug_mode IN VARCHAR2 :='N'
424: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
417: p_api_version IN NUMBER :=1.0
418: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
419: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
420: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
421: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
422: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
423: ,p_debug_mode IN VARCHAR2 :='N'
424: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
425: ,p_action IN VARCHAR2 :='SAVE'
475: -- Progress Management Changes. Bug # 3420093.
476:
477: PROCEDURE populate_pji_tab_for_plan(
478: p_api_version IN NUMBER :=1.0
479: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
480: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
481: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
482: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
483: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
476:
477: PROCEDURE populate_pji_tab_for_plan(
478: p_api_version IN NUMBER :=1.0
479: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
480: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
481: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
482: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
483: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
484: ,p_debug_mode IN VARCHAR2 :='N'
477: PROCEDURE populate_pji_tab_for_plan(
478: p_api_version IN NUMBER :=1.0
479: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
480: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
481: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
482: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
483: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
484: ,p_debug_mode IN VARCHAR2 :='N'
485: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
478: p_api_version IN NUMBER :=1.0
479: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
480: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
481: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
482: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
483: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
484: ,p_debug_mode IN VARCHAR2 :='N'
485: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
486: ,p_project_id IN NUMBER
498: );
499:
500: PROCEDURE push_workplan_actuals(
501: p_api_version IN NUMBER :=1.0
502: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
503: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
504: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
505: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
506: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
499:
500: PROCEDURE push_workplan_actuals(
501: p_api_version IN NUMBER :=1.0
502: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
503: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
504: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
505: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
506: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
507: ,p_debug_mode IN VARCHAR2 :='N'
500: PROCEDURE push_workplan_actuals(
501: p_api_version IN NUMBER :=1.0
502: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
503: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
504: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
505: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
506: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
507: ,p_debug_mode IN VARCHAR2 :='N'
508: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
501: p_api_version IN NUMBER :=1.0
502: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
503: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
504: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
505: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
506: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
507: ,p_debug_mode IN VARCHAR2 :='N'
508: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
509: ,p_project_Id NUMBER
551: -- Progress Management Change for bug # 3420093.
552:
553: PROCEDURE program_rollup_pvt(
554: p_api_version IN NUMBER :=1.0
555: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
556: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
557: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
558: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
559: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
552:
553: PROCEDURE program_rollup_pvt(
554: p_api_version IN NUMBER :=1.0
555: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
556: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
557: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
558: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
559: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
560: ,p_debug_mode IN VARCHAR2 :='N'
553: PROCEDURE program_rollup_pvt(
554: p_api_version IN NUMBER :=1.0
555: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
556: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
557: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
558: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
559: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
560: ,p_debug_mode IN VARCHAR2 :='N'
561: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
554: p_api_version IN NUMBER :=1.0
555: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
556: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
557: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
558: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
559: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
560: ,p_debug_mode IN VARCHAR2 :='N'
561: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
562: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
569: );
570:
571: PROCEDURE transfer_wp_percent_to_fin(
572: p_api_version IN NUMBER :=1.0
573: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
576: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
577: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
570:
571: PROCEDURE transfer_wp_percent_to_fin(
572: p_api_version IN NUMBER :=1.0
573: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
576: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
577: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
578: ,p_debug_mode IN VARCHAR2 :='N'
571: PROCEDURE transfer_wp_percent_to_fin(
572: p_api_version IN NUMBER :=1.0
573: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
576: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
577: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
578: ,p_debug_mode IN VARCHAR2 :='N'
579: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
572: p_api_version IN NUMBER :=1.0
573: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
574: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
575: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
576: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
577: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
578: ,p_debug_mode IN VARCHAR2 :='N'
579: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
580: ,p_project_id IN NUMBER
584: );
585:
586: PROCEDURE publish_progress(
587: p_api_version IN NUMBER :=1.0
588: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
589: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
590: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
591: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
592: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
585:
586: PROCEDURE publish_progress(
587: p_api_version IN NUMBER :=1.0
588: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
589: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
590: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
591: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
592: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
593: ,p_debug_mode IN VARCHAR2 :='N'
586: PROCEDURE publish_progress(
587: p_api_version IN NUMBER :=1.0
588: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
589: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
590: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
591: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
592: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
593: ,p_debug_mode IN VARCHAR2 :='N'
594: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
587: p_api_version IN NUMBER :=1.0
588: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
589: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
590: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
591: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
592: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
593: ,p_debug_mode IN VARCHAR2 :='N'
594: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
595: ,p_project_id IN NUMBER
630:
631: -- FPM Dev CR 1 : Added Following Procedure
632: PROCEDURE UPDATE_FINANCIAL_TASK_PROGRESS(
633: p_api_version IN NUMBER :=1.0
634: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
635: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
636: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
637: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
638: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
631: -- FPM Dev CR 1 : Added Following Procedure
632: PROCEDURE UPDATE_FINANCIAL_TASK_PROGRESS(
633: p_api_version IN NUMBER :=1.0
634: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
635: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
636: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
637: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
638: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
639: ,p_debug_mode IN VARCHAR2 :='N'
632: PROCEDURE UPDATE_FINANCIAL_TASK_PROGRESS(
633: p_api_version IN NUMBER :=1.0
634: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
635: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
636: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
637: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
638: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
639: ,p_debug_mode IN VARCHAR2 :='N'
640: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
633: p_api_version IN NUMBER :=1.0
634: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
635: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
636: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
637: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
638: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
639: ,p_debug_mode IN VARCHAR2 :='N'
640: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
641: ,p_action IN VARCHAR2 :='SAVE'
663: -- Progress Management Changes. Bug # 3420093.
664:
665: PROCEDURE re_rollup_progress(
666: p_api_version IN NUMBER :=1.0
667: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
668: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
669: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
670: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
671: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
664:
665: PROCEDURE re_rollup_progress(
666: p_api_version IN NUMBER :=1.0
667: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
668: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
669: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
670: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
671: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
672: ,p_debug_mode IN VARCHAR2 :='N'
665: PROCEDURE re_rollup_progress(
666: p_api_version IN NUMBER :=1.0
667: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
668: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
669: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
670: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
671: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
672: ,p_debug_mode IN VARCHAR2 :='N'
673: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
666: p_api_version IN NUMBER :=1.0
667: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
668: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
669: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
670: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
671: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
672: ,p_debug_mode IN VARCHAR2 :='N'
673: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
674: ,p_project_id IN NUMBER
680:
681: -- Bug 3633293 : Added populate_bulk_pji_tab_for_plan
682: PROCEDURE populate_bulk_pji_tab_for_plan(
683: p_api_version IN NUMBER :=1.0
684: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
685: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
686: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
687: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
688: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
681: -- Bug 3633293 : Added populate_bulk_pji_tab_for_plan
682: PROCEDURE populate_bulk_pji_tab_for_plan(
683: p_api_version IN NUMBER :=1.0
684: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
685: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
686: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
687: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
688: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
689: ,p_debug_mode IN VARCHAR2 :='N'
682: PROCEDURE populate_bulk_pji_tab_for_plan(
683: p_api_version IN NUMBER :=1.0
684: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
685: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
686: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
687: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
688: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
689: ,p_debug_mode IN VARCHAR2 :='N'
690: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
683: p_api_version IN NUMBER :=1.0
684: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
685: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
686: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
687: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
688: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
689: ,p_debug_mode IN VARCHAR2 :='N'
690: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
691: ,p_person_id NUMBER
704: -- End of comments
705:
706: PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
707: p_api_version IN NUMBER :=1.0
708: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
709: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
710: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
711: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
712: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
705:
706: PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
707: p_api_version IN NUMBER :=1.0
708: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
709: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
710: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
711: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
712: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
713: ,p_debug_mode IN VARCHAR2 :='N'
706: PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
707: p_api_version IN NUMBER :=1.0
708: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
709: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
710: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
711: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
712: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
713: ,p_debug_mode IN VARCHAR2 :='N'
714: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
707: p_api_version IN NUMBER :=1.0
708: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
709: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
710: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
711: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
712: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
713: ,p_debug_mode IN VARCHAR2 :='N'
714: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
715: ,p_project_id IN NUMBER
735: -- End of comments
736:
737: PROCEDURE COPY_PROGRESS_ACT_ETC(
738: p_api_version IN NUMBER :=1.0
739: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- FALSE for private API.
740: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
741: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
742: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
743: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
736:
737: PROCEDURE COPY_PROGRESS_ACT_ETC(
738: p_api_version IN NUMBER :=1.0
739: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- FALSE for private API.
740: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
741: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
742: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
743: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
744: ,p_debug_mode IN VARCHAR2 :='N'
737: PROCEDURE COPY_PROGRESS_ACT_ETC(
738: p_api_version IN NUMBER :=1.0
739: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- FALSE for private API.
740: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
741: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
742: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
743: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
744: ,p_debug_mode IN VARCHAR2 :='N'
745: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
738: p_api_version IN NUMBER :=1.0
739: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- FALSE for private API.
740: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
741: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
742: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
743: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
744: ,p_debug_mode IN VARCHAR2 :='N'
745: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
746: ,p_project_id IN NUMBER
759:
760: -- Bug 3807299 : new API which will be called from update_progress and AMG pa_status_pub.update_progress
761: PROCEDURE update_link_proj_rollup_dates(
762: p_api_version IN NUMBER :=1.0
763: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
764: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
765: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
766: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
767: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
760: -- Bug 3807299 : new API which will be called from update_progress and AMG pa_status_pub.update_progress
761: PROCEDURE update_link_proj_rollup_dates(
762: p_api_version IN NUMBER :=1.0
763: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
764: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
765: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
766: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
767: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
768: ,p_project_id IN NUMBER
761: PROCEDURE update_link_proj_rollup_dates(
762: p_api_version IN NUMBER :=1.0
763: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
764: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
765: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
766: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
767: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
768: ,p_project_id IN NUMBER
769: ,p_task_id IN NUMBER
762: p_api_version IN NUMBER :=1.0
763: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
764: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
765: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
766: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
767: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
768: ,p_project_id IN NUMBER
769: ,p_task_id IN NUMBER
770: ,p_task_version_id IN NUMBER
776: );
777:
778: PROCEDURE UPDATE_PROGRESS_BULK(
779: p_api_version IN NUMBER :=1.0
780: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
781: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
782: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
783: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
784: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
777:
778: PROCEDURE UPDATE_PROGRESS_BULK(
779: p_api_version IN NUMBER :=1.0
780: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
781: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
782: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
783: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
784: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
785: ,p_calling_mode IN VARCHAR2 := null
778: PROCEDURE UPDATE_PROGRESS_BULK(
779: p_api_version IN NUMBER :=1.0
780: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
781: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
782: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
783: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
784: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
785: ,p_calling_mode IN VARCHAR2 := null
786: ,p_debug_mode IN VARCHAR2 :='N'
779: p_api_version IN NUMBER :=1.0
780: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
781: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
782: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
783: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
784: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
785: ,p_calling_mode IN VARCHAR2 := null
786: ,p_debug_mode IN VARCHAR2 :='N'
787: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
833: -- Begin fix for Bug # 4262985.
834:
835: PROCEDURE apply_lp_prog_on_cwv_wrp(
836: p_api_version IN NUMBER :=1.0
837: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
838: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
839: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
840: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
841: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
834:
835: PROCEDURE apply_lp_prog_on_cwv_wrp(
836: p_api_version IN NUMBER :=1.0
837: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
838: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
839: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
840: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
841: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
842: ,p_debug_mode IN VARCHAR2 :='N'
835: PROCEDURE apply_lp_prog_on_cwv_wrp(
836: p_api_version IN NUMBER :=1.0
837: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
838: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
839: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
840: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
841: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
842: ,p_debug_mode IN VARCHAR2 :='N'
843: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
836: p_api_version IN NUMBER :=1.0
837: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
838: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
839: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
840: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
841: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
842: ,p_debug_mode IN VARCHAR2 :='N'
843: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
844: ,p_project_id IN NUMBER