28: -- End of comments
29:
30: PROCEDURE ROLLUP_PROGRESS_PVT(
31: p_api_version IN NUMBER :=1.0
32: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
35: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
36: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
29:
30: PROCEDURE ROLLUP_PROGRESS_PVT(
31: p_api_version IN NUMBER :=1.0
32: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
35: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
36: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
37: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
30: PROCEDURE ROLLUP_PROGRESS_PVT(
31: p_api_version IN NUMBER :=1.0
32: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
35: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
36: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
37: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
38: ,p_debug_mode IN VARCHAR2 :='N'
31: p_api_version IN NUMBER :=1.0
32: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
33: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
34: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
35: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
36: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
37: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
38: ,p_debug_mode IN VARCHAR2 :='N'
39: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
82: -- End of comments
83:
84: PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
85: p_api_version IN NUMBER :=1.0
86: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
87: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
88: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
89: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
90: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
83:
84: PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
85: p_api_version IN NUMBER :=1.0
86: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
87: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
88: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
89: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
90: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
91: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
84: PROCEDURE UPDATE_ROLLUP_PROGRESS_PVT(
85: p_api_version IN NUMBER :=1.0
86: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
87: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
88: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
89: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
90: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
91: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
92: ,p_debug_mode IN VARCHAR2 :='N'
85: p_api_version IN NUMBER :=1.0
86: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
87: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
88: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
89: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
90: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
91: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
92: ,p_debug_mode IN VARCHAR2 :='N'
93: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
131: );
132:
133: PROCEDURE program_rollup_pvt(
134: p_api_version IN NUMBER :=1.0
135: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
136: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
137: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
138: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
139: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
132:
133: PROCEDURE program_rollup_pvt(
134: p_api_version IN NUMBER :=1.0
135: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
136: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
137: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
138: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
139: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
140: ,p_debug_mode IN VARCHAR2 :='N'
133: PROCEDURE program_rollup_pvt(
134: p_api_version IN NUMBER :=1.0
135: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
136: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
137: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
138: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
139: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
140: ,p_debug_mode IN VARCHAR2 :='N'
141: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
134: p_api_version IN NUMBER :=1.0
135: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
136: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
137: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
138: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
139: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
140: ,p_debug_mode IN VARCHAR2 :='N'
141: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
142: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
158: -- End of comments
159:
160: PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
161: p_api_version IN NUMBER :=1.0
162: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
163: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
164: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
165: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
166: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
159:
160: PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
161: p_api_version IN NUMBER :=1.0
162: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
163: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
164: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
165: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
166: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
167: ,p_debug_mode IN VARCHAR2 :='N'
160: PROCEDURE ASGN_DLV_TO_TASK_ROLLUP_PVT(
161: p_api_version IN NUMBER :=1.0
162: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
163: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
164: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
165: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
166: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
167: ,p_debug_mode IN VARCHAR2 :='N'
168: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
161: p_api_version IN NUMBER :=1.0
162: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
163: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
164: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
165: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
166: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
167: ,p_debug_mode IN VARCHAR2 :='N'
168: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
169: ,p_project_id IN NUMBER
180: --bug 3935699
181: PROCEDURE convert_task_prog_to_assgn
182: (
183: p_api_version IN NUMBER :=1.0
184: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
185: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
187: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
181: PROCEDURE convert_task_prog_to_assgn
182: (
183: p_api_version IN NUMBER :=1.0
184: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
185: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
187: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 :='N'
182: (
183: p_api_version IN NUMBER :=1.0
184: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
185: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
187: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 :='N'
190: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
183: p_api_version IN NUMBER :=1.0
184: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE -- Since it is a private API so false
185: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
186: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
187: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
188: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
189: ,p_debug_mode IN VARCHAR2 :='N'
190: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
191: ,p_resource_list_mem_id IN NUMBER
221:
222: -- Bug 4575855 : Added rollup_prog_from_subprojs
223: PROCEDURE ROLLUP_PROG_FROM_SUBPROJS(
224: p_api_version IN NUMBER :=1.0
225: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
226: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
227: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
228: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
229: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
222: -- Bug 4575855 : Added rollup_prog_from_subprojs
223: PROCEDURE ROLLUP_PROG_FROM_SUBPROJS(
224: p_api_version IN NUMBER :=1.0
225: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
226: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
227: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
228: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
229: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
230: ,p_debug_mode IN VARCHAR2 :='N'
223: PROCEDURE ROLLUP_PROG_FROM_SUBPROJS(
224: p_api_version IN NUMBER :=1.0
225: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
226: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
227: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
228: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
229: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
230: ,p_debug_mode IN VARCHAR2 :='N'
231: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
224: p_api_version IN NUMBER :=1.0
225: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
226: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
227: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
228: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
229: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
230: ,p_debug_mode IN VARCHAR2 :='N'
231: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
232: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
244: x_msg_data OUT NOCOPY VARCHAR2);
245:
246: PROCEDURE ROLLUP_PVT(
247: p_api_version IN NUMBER :=1.0
248: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
249: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
250: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
251: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
252: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
245:
246: PROCEDURE ROLLUP_PVT(
247: p_api_version IN NUMBER :=1.0
248: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
249: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
250: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
251: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
252: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
253: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
246: PROCEDURE ROLLUP_PVT(
247: p_api_version IN NUMBER :=1.0
248: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
249: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
250: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
251: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
252: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
253: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
254: ,p_debug_mode IN VARCHAR2 :='N'
247: p_api_version IN NUMBER :=1.0
248: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
249: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
250: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
251: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
252: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
253: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
254: ,p_debug_mode IN VARCHAR2 :='N'
255: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
276: );
277:
278: PROCEDURE DEFER_ROLLUP_PVT(
279: p_api_version IN NUMBER :=1.0
280: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
281: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
282: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
283: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
284: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
277:
278: PROCEDURE DEFER_ROLLUP_PVT(
279: p_api_version IN NUMBER :=1.0
280: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
281: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
282: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
283: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
284: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
285: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
278: PROCEDURE DEFER_ROLLUP_PVT(
279: p_api_version IN NUMBER :=1.0
280: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
281: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
282: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
283: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
284: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
285: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
286: ,p_debug_mode IN VARCHAR2 :='N'
279: p_api_version IN NUMBER :=1.0
280: ,p_init_msg_list IN VARCHAR2 :=FND_API.G_TRUE
281: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
282: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
283: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
284: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
285: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
286: ,p_debug_mode IN VARCHAR2 :='N'
287: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM