43: TYPE PA_NUM_1000_NUM IS VARRAY(1000) OF NUMBER;
44:
45: PROCEDURE UPDATE_TASK_PROGRESS(
46: p_api_version IN NUMBER :=1.0 ,
47: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
48: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
49: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
50: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
51: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
44:
45: PROCEDURE UPDATE_TASK_PROGRESS(
46: p_api_version IN NUMBER :=1.0 ,
47: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
48: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
49: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
50: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
51: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
52: p_calling_mode IN VARCHAR2 := null ,
45: PROCEDURE UPDATE_TASK_PROGRESS(
46: p_api_version IN NUMBER :=1.0 ,
47: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
48: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
49: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
50: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
51: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
52: p_calling_mode IN VARCHAR2 := null ,
53: p_debug_mode IN VARCHAR2 :='N' ,
46: p_api_version IN NUMBER :=1.0 ,
47: p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE ,
48: p_commit IN VARCHAR2 :=FND_API.G_FALSE ,
49: p_validate_only IN VARCHAR2 :=FND_API.G_TRUE ,
50: p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL ,
51: p_calling_module IN VARCHAR2 :='SELF_SERVICE' ,
52: p_calling_mode IN VARCHAR2 := null ,
53: p_debug_mode IN VARCHAR2 :='N' ,
54: p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ,
117: -- End of comments
118:
119: PROCEDURE ROLLUP_PROGRESS_PVT(
120: p_api_version IN NUMBER :=1.0
121: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
122: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
123: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
124: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
118:
119: PROCEDURE ROLLUP_PROGRESS_PVT(
120: p_api_version IN NUMBER :=1.0
121: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
122: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
123: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
124: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
126: ,p_debug_mode IN VARCHAR2 :='N'
119: PROCEDURE ROLLUP_PROGRESS_PVT(
120: p_api_version IN NUMBER :=1.0
121: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
122: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
123: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
124: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
126: ,p_debug_mode IN VARCHAR2 :='N'
127: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
120: p_api_version IN NUMBER :=1.0
121: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
122: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
123: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
124: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
125: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
126: ,p_debug_mode IN VARCHAR2 :='N'
127: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
128: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
169: -- End of comments
170:
171: PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
172: p_api_version IN NUMBER :=1.0
173: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
174: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
175: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
176: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
177: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
170:
171: PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
172: p_api_version IN NUMBER :=1.0
173: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
174: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
175: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
176: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
177: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
178: ,p_debug_mode IN VARCHAR2 :='N'
171: PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
172: p_api_version IN NUMBER :=1.0
173: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
174: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
175: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
176: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
177: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
178: ,p_debug_mode IN VARCHAR2 :='N'
179: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
172: p_api_version IN NUMBER :=1.0
173: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
174: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
175: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
176: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
177: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
178: ,p_debug_mode IN VARCHAR2 :='N'
179: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
180: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
198: );
199:
200: PROCEDURE CREATE_PROJ_PROG_ATTR(
201: p_api_version IN NUMBER :=1.0
202: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
203: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
204: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
205: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
199:
200: PROCEDURE CREATE_PROJ_PROG_ATTR(
201: p_api_version IN NUMBER :=1.0
202: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
203: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
204: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
205: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
207: ,p_debug_mode IN VARCHAR2 :='N'
200: PROCEDURE CREATE_PROJ_PROG_ATTR(
201: p_api_version IN NUMBER :=1.0
202: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
203: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
204: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
205: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
207: ,p_debug_mode IN VARCHAR2 :='N'
208: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
201: p_api_version IN NUMBER :=1.0
202: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
203: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
204: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
205: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
206: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
207: ,p_debug_mode IN VARCHAR2 :='N'
208: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
209: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
227: );
228:
229: PROCEDURE UPDATE_PROJ_PROG_ATTR(
230: p_api_version IN NUMBER :=1.0
231: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
232: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
233: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
234: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
235: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
228:
229: PROCEDURE UPDATE_PROJ_PROG_ATTR(
230: p_api_version IN NUMBER :=1.0
231: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
232: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
233: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
234: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
235: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
236: ,p_debug_mode IN VARCHAR2 :='N'
229: PROCEDURE UPDATE_PROJ_PROG_ATTR(
230: p_api_version IN NUMBER :=1.0
231: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
232: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
233: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
234: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
235: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
236: ,p_debug_mode IN VARCHAR2 :='N'
237: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
230: p_api_version IN NUMBER :=1.0
231: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
232: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
233: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
234: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
235: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
236: ,p_debug_mode IN VARCHAR2 :='N'
237: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
238: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
256: );
257:
258: PROCEDURE DELETE_PROJ_PROG_ATTR(
259: p_api_version IN NUMBER :=1.0
260: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
261: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
262: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
263: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
264: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
257:
258: PROCEDURE DELETE_PROJ_PROG_ATTR(
259: p_api_version IN NUMBER :=1.0
260: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
261: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
262: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
263: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
264: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
265: ,p_debug_mode IN VARCHAR2 :='N'
258: PROCEDURE DELETE_PROJ_PROG_ATTR(
259: p_api_version IN NUMBER :=1.0
260: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
261: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
262: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
263: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
264: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
265: ,p_debug_mode IN VARCHAR2 :='N'
266: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
259: p_api_version IN NUMBER :=1.0
260: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
261: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
262: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
263: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
264: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
265: ,p_debug_mode IN VARCHAR2 :='N'
266: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
267: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
274: );
275:
276: PROCEDURE delete_progress_record(
277: p_api_version IN NUMBER :=1.0
278: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
279: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
280: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
281: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
282: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
275:
276: PROCEDURE delete_progress_record(
277: p_api_version IN NUMBER :=1.0
278: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
279: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
280: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
281: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
282: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
283: ,p_debug_mode IN VARCHAR2 :='N'
276: PROCEDURE delete_progress_record(
277: p_api_version IN NUMBER :=1.0
278: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
279: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
280: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
281: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
282: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
283: ,p_debug_mode IN VARCHAR2 :='N'
284: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
277: p_api_version IN NUMBER :=1.0
278: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
279: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
280: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
281: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
282: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
283: ,p_debug_mode IN VARCHAR2 :='N'
284: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
285: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
290: );
291:
292: PROCEDURE push_down_task_status(
293: p_api_version IN NUMBER :=1.0
294: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
295: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
296: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
297: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
298: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
291:
292: PROCEDURE push_down_task_status(
293: p_api_version IN NUMBER :=1.0
294: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
295: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
296: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
297: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
298: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
299: ,p_debug_mode IN VARCHAR2 :='N'
292: PROCEDURE push_down_task_status(
293: p_api_version IN NUMBER :=1.0
294: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
295: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
296: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
297: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
298: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
299: ,p_debug_mode IN VARCHAR2 :='N'
300: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
293: p_api_version IN NUMBER :=1.0
294: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
295: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
296: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
297: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
298: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
299: ,p_debug_mode IN VARCHAR2 :='N'
300: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
301: ,p_task_status IN VARCHAR2
351: -- Progress Management Changes. Bug # 3420093.
352:
353: PROCEDURE apply_lp_prog_on_cwv(
354: p_api_version IN NUMBER :=1.0
355: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
356: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
357: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
358: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
359: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
352:
353: PROCEDURE apply_lp_prog_on_cwv(
354: p_api_version IN NUMBER :=1.0
355: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
356: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
357: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
358: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
359: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
360: ,p_debug_mode IN VARCHAR2 :='N'
353: PROCEDURE apply_lp_prog_on_cwv(
354: p_api_version IN NUMBER :=1.0
355: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
356: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
357: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
358: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
359: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
360: ,p_debug_mode IN VARCHAR2 :='N'
361: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
354: p_api_version IN NUMBER :=1.0
355: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
356: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
357: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
358: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
359: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
360: ,p_debug_mode IN VARCHAR2 :='N'
361: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
362: ,p_project_id IN NUMBER
369: -- Progress Management Changes. Bug # 3420093.
370:
371: PROCEDURE delete_working_wp_progress(
372: p_api_version IN NUMBER :=1.0
373: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
374: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
375: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
376: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
377: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
370:
371: PROCEDURE delete_working_wp_progress(
372: p_api_version IN NUMBER :=1.0
373: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
374: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
375: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
376: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
377: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
378: ,p_debug_mode IN VARCHAR2 :='N'
371: PROCEDURE delete_working_wp_progress(
372: p_api_version IN NUMBER :=1.0
373: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
374: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
375: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
376: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
377: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
378: ,p_debug_mode IN VARCHAR2 :='N'
379: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
372: p_api_version IN NUMBER :=1.0
373: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
374: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
375: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
376: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
377: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
378: ,p_debug_mode IN VARCHAR2 :='N'
379: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
380: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
389: -- Progress Management Changes. Bug # 3420093.
390:
391: Procedure PULL_SUMMARIZED_ACTUALS (
392: p_api_version IN NUMBER :=1.0
393: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
394: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
395: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
396: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
397: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
390:
391: Procedure PULL_SUMMARIZED_ACTUALS (
392: p_api_version IN NUMBER :=1.0
393: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
394: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
395: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
396: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
397: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
398: ,p_debug_mode IN VARCHAR2 :='N'
391: Procedure PULL_SUMMARIZED_ACTUALS (
392: p_api_version IN NUMBER :=1.0
393: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
394: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
395: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
396: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
397: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
398: ,p_debug_mode IN VARCHAR2 :='N'
399: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
392: p_api_version IN NUMBER :=1.0
393: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
394: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
395: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
396: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
397: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
398: ,p_debug_mode IN VARCHAR2 :='N'
399: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
400: ,P_Project_ID IN NUMBER
407: -- Progress Management Changes. Bug # 3420093.
408:
409: PROCEDURE update_progress(
410: p_api_version IN NUMBER :=1.0
411: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
412: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
413: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
414: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
415: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
408:
409: PROCEDURE update_progress(
410: p_api_version IN NUMBER :=1.0
411: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
412: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
413: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
414: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
415: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
416: ,p_debug_mode IN VARCHAR2 :='N'
409: PROCEDURE update_progress(
410: p_api_version IN NUMBER :=1.0
411: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
412: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
413: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
414: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
415: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
416: ,p_debug_mode IN VARCHAR2 :='N'
417: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
410: p_api_version IN NUMBER :=1.0
411: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
412: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
413: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
414: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
415: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
416: ,p_debug_mode IN VARCHAR2 :='N'
417: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
418: ,p_action IN VARCHAR2 :='SAVE'
468: -- Progress Management Changes. Bug # 3420093.
469:
470: PROCEDURE populate_pji_tab_for_plan(
471: p_api_version IN NUMBER :=1.0
472: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
473: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
474: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
475: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
476: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
469:
470: PROCEDURE populate_pji_tab_for_plan(
471: p_api_version IN NUMBER :=1.0
472: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
473: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
474: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
475: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
476: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
477: ,p_debug_mode IN VARCHAR2 :='N'
470: PROCEDURE populate_pji_tab_for_plan(
471: p_api_version IN NUMBER :=1.0
472: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
473: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
474: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
475: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
476: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
477: ,p_debug_mode IN VARCHAR2 :='N'
478: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
471: p_api_version IN NUMBER :=1.0
472: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
473: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
474: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
475: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
476: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
477: ,p_debug_mode IN VARCHAR2 :='N'
478: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
479: ,p_project_id IN NUMBER
491: );
492:
493: PROCEDURE push_workplan_actuals(
494: p_api_version IN NUMBER :=1.0
495: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
496: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
497: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
498: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
499: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
492:
493: PROCEDURE push_workplan_actuals(
494: p_api_version IN NUMBER :=1.0
495: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
496: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
497: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
498: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
499: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
500: ,p_debug_mode IN VARCHAR2 :='N'
493: PROCEDURE push_workplan_actuals(
494: p_api_version IN NUMBER :=1.0
495: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
496: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
497: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
498: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
499: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
500: ,p_debug_mode IN VARCHAR2 :='N'
501: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
494: p_api_version IN NUMBER :=1.0
495: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
496: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
497: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
498: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
499: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
500: ,p_debug_mode IN VARCHAR2 :='N'
501: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
502: ,p_project_Id NUMBER
543: -- Progress Management Change for bug # 3420093.
544:
545: PROCEDURE program_rollup_pvt(
546: p_api_version IN NUMBER :=1.0
547: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
548: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
549: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
550: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
551: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
544:
545: PROCEDURE program_rollup_pvt(
546: p_api_version IN NUMBER :=1.0
547: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
548: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
549: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
550: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
551: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
552: ,p_debug_mode IN VARCHAR2 :='N'
545: PROCEDURE program_rollup_pvt(
546: p_api_version IN NUMBER :=1.0
547: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
548: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
549: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
550: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
551: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
552: ,p_debug_mode IN VARCHAR2 :='N'
553: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
546: p_api_version IN NUMBER :=1.0
547: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
548: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
549: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
550: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
551: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
552: ,p_debug_mode IN VARCHAR2 :='N'
553: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
554: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
561: );
562:
563: PROCEDURE transfer_wp_percent_to_fin(
564: p_api_version IN NUMBER :=1.0
565: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
566: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
567: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
568: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
569: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
562:
563: PROCEDURE transfer_wp_percent_to_fin(
564: p_api_version IN NUMBER :=1.0
565: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
566: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
567: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
568: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
569: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
570: ,p_debug_mode IN VARCHAR2 :='N'
563: PROCEDURE transfer_wp_percent_to_fin(
564: p_api_version IN NUMBER :=1.0
565: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
566: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
567: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
568: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
569: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
570: ,p_debug_mode IN VARCHAR2 :='N'
571: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
564: p_api_version IN NUMBER :=1.0
565: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
566: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
567: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
568: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
569: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
570: ,p_debug_mode IN VARCHAR2 :='N'
571: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
572: ,p_project_id IN NUMBER
576: );
577:
578: PROCEDURE publish_progress(
579: p_api_version IN NUMBER :=1.0
580: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
581: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
582: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
583: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
584: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
577:
578: PROCEDURE publish_progress(
579: p_api_version IN NUMBER :=1.0
580: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
581: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
582: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
583: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
584: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
585: ,p_debug_mode IN VARCHAR2 :='N'
578: PROCEDURE publish_progress(
579: p_api_version IN NUMBER :=1.0
580: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
581: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
582: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
583: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
584: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
585: ,p_debug_mode IN VARCHAR2 :='N'
586: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
579: p_api_version IN NUMBER :=1.0
580: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
581: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
582: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
583: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
584: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
585: ,p_debug_mode IN VARCHAR2 :='N'
586: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
587: ,p_project_id IN NUMBER
622:
623: -- FPM Dev CR 1 : Added Following Procedure
624: PROCEDURE UPDATE_FINANCIAL_TASK_PROGRESS(
625: p_api_version IN NUMBER :=1.0
626: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
627: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
628: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
629: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
630: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
623: -- FPM Dev CR 1 : Added Following Procedure
624: PROCEDURE UPDATE_FINANCIAL_TASK_PROGRESS(
625: p_api_version IN NUMBER :=1.0
626: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
627: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
628: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
629: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
630: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
631: ,p_debug_mode IN VARCHAR2 :='N'
624: PROCEDURE UPDATE_FINANCIAL_TASK_PROGRESS(
625: p_api_version IN NUMBER :=1.0
626: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
627: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
628: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
629: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
630: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
631: ,p_debug_mode IN VARCHAR2 :='N'
632: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
625: p_api_version IN NUMBER :=1.0
626: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
627: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
628: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
629: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
630: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
631: ,p_debug_mode IN VARCHAR2 :='N'
632: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
633: ,p_action IN VARCHAR2 :='SAVE'
655: -- Progress Management Changes. Bug # 3420093.
656:
657: PROCEDURE re_rollup_progress(
658: p_api_version IN NUMBER :=1.0
659: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
660: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
661: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
662: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
663: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
656:
657: PROCEDURE re_rollup_progress(
658: p_api_version IN NUMBER :=1.0
659: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
660: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
661: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
662: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
663: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
664: ,p_debug_mode IN VARCHAR2 :='N'
657: PROCEDURE re_rollup_progress(
658: p_api_version IN NUMBER :=1.0
659: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
660: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
661: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
662: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
663: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
664: ,p_debug_mode IN VARCHAR2 :='N'
665: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
658: p_api_version IN NUMBER :=1.0
659: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
660: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
661: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
662: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
663: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
664: ,p_debug_mode IN VARCHAR2 :='N'
665: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
666: ,p_project_id IN NUMBER
672:
673: -- Bug 3633293 : Added populate_bulk_pji_tab_for_plan
674: PROCEDURE populate_bulk_pji_tab_for_plan(
675: p_api_version IN NUMBER :=1.0
676: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
677: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
678: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
679: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
680: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
673: -- Bug 3633293 : Added populate_bulk_pji_tab_for_plan
674: PROCEDURE populate_bulk_pji_tab_for_plan(
675: p_api_version IN NUMBER :=1.0
676: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
677: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
678: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
679: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
680: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
681: ,p_debug_mode IN VARCHAR2 :='N'
674: PROCEDURE populate_bulk_pji_tab_for_plan(
675: p_api_version IN NUMBER :=1.0
676: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
677: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
678: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
679: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
680: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
681: ,p_debug_mode IN VARCHAR2 :='N'
682: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
675: p_api_version IN NUMBER :=1.0
676: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
677: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
678: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
679: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
680: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
681: ,p_debug_mode IN VARCHAR2 :='N'
682: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
683: ,p_person_id NUMBER
696: -- End of comments
697:
698: PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
699: p_api_version IN NUMBER :=1.0
700: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
701: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
702: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
703: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
704: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
697:
698: PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
699: p_api_version IN NUMBER :=1.0
700: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
701: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
702: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
703: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
704: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
705: ,p_debug_mode IN VARCHAR2 :='N'
698: PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
699: p_api_version IN NUMBER :=1.0
700: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
701: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
702: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
703: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
704: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
705: ,p_debug_mode IN VARCHAR2 :='N'
706: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
699: p_api_version IN NUMBER :=1.0
700: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
701: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
702: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
703: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
704: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
705: ,p_debug_mode IN VARCHAR2 :='N'
706: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
707: ,p_project_id IN NUMBER
727: -- End of comments
728:
729: PROCEDURE COPY_PROGRESS_ACT_ETC(
730: p_api_version IN NUMBER :=1.0
731: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- FALSE for private API.
732: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
733: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
734: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
735: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
728:
729: PROCEDURE COPY_PROGRESS_ACT_ETC(
730: p_api_version IN NUMBER :=1.0
731: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- FALSE for private API.
732: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
733: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
734: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
735: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
736: ,p_debug_mode IN VARCHAR2 :='N'
729: PROCEDURE COPY_PROGRESS_ACT_ETC(
730: p_api_version IN NUMBER :=1.0
731: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- FALSE for private API.
732: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
733: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
734: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
735: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
736: ,p_debug_mode IN VARCHAR2 :='N'
737: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
730: p_api_version IN NUMBER :=1.0
731: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- FALSE for private API.
732: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
733: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
734: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
735: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
736: ,p_debug_mode IN VARCHAR2 :='N'
737: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
738: ,p_project_id IN NUMBER
751:
752: -- Bug 3807299 : new API which will be called from update_progress and AMG pa_status_pub.update_progress
753: PROCEDURE update_link_proj_rollup_dates(
754: p_api_version IN NUMBER :=1.0
755: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
756: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
757: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
758: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
759: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
752: -- Bug 3807299 : new API which will be called from update_progress and AMG pa_status_pub.update_progress
753: PROCEDURE update_link_proj_rollup_dates(
754: p_api_version IN NUMBER :=1.0
755: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
756: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
757: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
758: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
759: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
760: ,p_project_id IN NUMBER
753: PROCEDURE update_link_proj_rollup_dates(
754: p_api_version IN NUMBER :=1.0
755: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
756: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
757: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
758: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
759: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
760: ,p_project_id IN NUMBER
761: ,p_task_id IN NUMBER
754: p_api_version IN NUMBER :=1.0
755: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
756: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
757: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
758: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
759: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
760: ,p_project_id IN NUMBER
761: ,p_task_id IN NUMBER
762: ,p_task_version_id IN NUMBER
768: );
769:
770: PROCEDURE UPDATE_PROGRESS_BULK(
771: p_api_version IN NUMBER :=1.0
772: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
773: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
774: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
775: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
776: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
769:
770: PROCEDURE UPDATE_PROGRESS_BULK(
771: p_api_version IN NUMBER :=1.0
772: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
773: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
774: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
775: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
776: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
777: ,p_calling_mode IN VARCHAR2 := null
770: PROCEDURE UPDATE_PROGRESS_BULK(
771: p_api_version IN NUMBER :=1.0
772: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
773: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
774: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
775: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
776: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
777: ,p_calling_mode IN VARCHAR2 := null
778: ,p_debug_mode IN VARCHAR2 :='N'
771: p_api_version IN NUMBER :=1.0
772: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
773: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
774: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
775: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
776: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
777: ,p_calling_mode IN VARCHAR2 := null
778: ,p_debug_mode IN VARCHAR2 :='N'
779: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
825: -- Begin fix for Bug # 4262985.
826:
827: PROCEDURE apply_lp_prog_on_cwv_wrp(
828: p_api_version IN NUMBER :=1.0
829: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
830: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
831: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
832: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
833: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
826:
827: PROCEDURE apply_lp_prog_on_cwv_wrp(
828: p_api_version IN NUMBER :=1.0
829: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
830: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
831: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
832: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
833: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
834: ,p_debug_mode IN VARCHAR2 :='N'
827: PROCEDURE apply_lp_prog_on_cwv_wrp(
828: p_api_version IN NUMBER :=1.0
829: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
830: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
831: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
832: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
833: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
834: ,p_debug_mode IN VARCHAR2 :='N'
835: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
828: p_api_version IN NUMBER :=1.0
829: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
830: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
831: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
832: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
833: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
834: ,p_debug_mode IN VARCHAR2 :='N'
835: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
836: ,p_project_id IN NUMBER