eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROGRESS_PVT dependencies on PA_INTERFACE_UTILS_PUB

Line 44: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

40: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
41: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
42: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
43: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
44: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,p_debug_mode IN VARCHAR2 :='N'
46: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
47: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
48: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 46: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

42: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
43: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
44: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,p_debug_mode IN VARCHAR2 :='N'
46: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
47: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
48: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
49: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 48: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

44: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
45: ,p_debug_mode IN VARCHAR2 :='N'
46: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
47: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
48: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
49: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
52: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 49: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

45: ,p_debug_mode IN VARCHAR2 :='N'
46: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
47: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
48: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
49: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
52: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 50: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

46: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
47: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
48: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
49: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
52: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
54: ,p_lowest_level_task IN VARCHAR2 := 'N'

Line 51: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

47: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
48: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
49: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
52: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
54: ,p_lowest_level_task IN VARCHAR2 := 'N'
55: ,p_process_whole_tree IN VARCHAR2 := 'Y'

Line 52: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

48: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
49: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
52: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
54: ,p_lowest_level_task IN VARCHAR2 := 'N'
55: ,p_process_whole_tree IN VARCHAR2 := 'Y'
56: ,p_structure_version_id IN NUMBER

Line 53: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

49: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
50: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
52: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
53: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
54: ,p_lowest_level_task IN VARCHAR2 := 'N'
55: ,p_process_whole_tree IN VARCHAR2 := 'Y'
56: ,p_structure_version_id IN NUMBER
57: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

Line 1461: IF p_structure_version_id IS NULL OR (p_as_of_date IS NULL OR p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) THEN

1457: END IF;
1458:
1459: -- 20 May : Amit : If Structure_version_id is null, then no rocessing shd be done
1460: -- Bug 3856161 : Added p_as_of_date check also
1461: IF p_structure_version_id IS NULL OR (p_as_of_date IS NULL OR p_as_of_date = PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE ) THEN
1462: return;
1463: END IF;
1464:
1465: --bug 4045979

Line 4021: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710

4017: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4018: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4019: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4020: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4021: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4022: ,p_debug_mode IN VARCHAR2 :='N'
4023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4024: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4025: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4019: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4020: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4021: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4022: ,p_debug_mode IN VARCHAR2 :='N'
4023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4024: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4025: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4026: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4027: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE

Line 4024: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4020: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4021: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4022: ,p_debug_mode IN VARCHAR2 :='N'
4023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4024: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4025: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4026: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4027: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4028: ,p_lowest_level_task IN VARCHAR2 := 'N'

Line 4025: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4021: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4022: ,p_debug_mode IN VARCHAR2 :='N'
4023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4024: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4025: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4026: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4027: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4028: ,p_lowest_level_task IN VARCHAR2 := 'N'
4029: ,p_task_version_id IN NUMBER

Line 4026: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4022: ,p_debug_mode IN VARCHAR2 :='N'
4023: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4024: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4025: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4026: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4027: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4028: ,p_lowest_level_task IN VARCHAR2 := 'N'
4029: ,p_task_version_id IN NUMBER
4030: ,p_structure_version_id IN NUMBER

Line 4100: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4096: raise;
4097: END UPDATE_ROLLUP_PROGRESS_PVT;
4098:
4099: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
4100: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4101: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4102: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4103: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4104: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

Line 4101: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4097: END UPDATE_ROLLUP_PROGRESS_PVT;
4098:
4099: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
4100: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4101: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4102: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4103: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4104: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4105: ,p_lowest_level_task IN VARCHAR2 := 'N'

Line 4102: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4098:
4099: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
4100: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4101: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4102: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4103: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4104: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4105: ,p_lowest_level_task IN VARCHAR2 := 'N'
4106: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

Line 4103: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4099: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
4100: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4101: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4102: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4103: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4104: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4105: ,p_lowest_level_task IN VARCHAR2 := 'N'
4106: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4107: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710

Line 4104: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4100: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4101: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4102: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4103: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4104: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4105: ,p_lowest_level_task IN VARCHAR2 := 'N'
4106: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4107: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4108: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

Line 4107: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710

4103: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4104: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4105: ,p_lowest_level_task IN VARCHAR2 := 'N'
4106: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4107: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4108: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
4109: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4110: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4111: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 4109: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4105: ,p_lowest_level_task IN VARCHAR2 := 'N'
4106: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4107: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4108: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
4109: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4110: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4111: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4112: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
4113: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4110: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4106: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4107: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4108: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
4109: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4110: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4111: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4112: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
4113: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4114: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4111: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4107: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4108: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
4109: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4110: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4111: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4112: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
4113: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4114: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4115: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4303: Pa_Interface_Utils_Pub.get_messages

4299: l_msg_count := Fnd_Msg_Pub.count_msg;
4300:
4301: IF l_msg_count = 1 AND x_msg_data IS NULL
4302: THEN
4303: Pa_Interface_Utils_Pub.get_messages
4304: ( p_encoded => Fnd_Api.G_FALSE
4305: , p_msg_index => 1
4306: , p_msg_count => l_msg_count
4307: , p_msg_data => l_msg_data

Line 4333: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4329: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4330: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4331: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4332: ,p_debug_mode IN VARCHAR2 :='N'
4333: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4334: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4335: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4336: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4337: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

Line 4334: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4330: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4331: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4332: ,p_debug_mode IN VARCHAR2 :='N'
4333: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4334: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4335: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4336: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4337: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4338: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4335: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

4331: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4332: ,p_debug_mode IN VARCHAR2 :='N'
4333: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4334: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4335: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4336: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4337: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4338: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4339: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4336: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

4332: ,p_debug_mode IN VARCHAR2 :='N'
4333: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4334: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4335: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4336: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4337: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4338: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4339: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4340: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4337: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4333: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4334: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4335: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4336: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4337: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4338: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4339: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4340: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4341: )

Line 5490: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

5486: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5487: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5488: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5489: ,p_debug_mode IN VARCHAR2 :='N'
5490: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5491: ,p_project_id IN NUMBER
5492: ,p_task_id IN NUMBER
5493: ,p_task_version_id IN NUMBER
5494: ,p_as_of_date IN DATE

Line 8991: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

8987: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
8988: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
8989: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
8990: ,p_debug_mode IN VARCHAR2 :='N'
8991: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
8992: ,p_resource_list_mem_id IN NUMBER
8993: ,p_project_id IN NUMBER
8994: ,p_task_id IN NUMBER
8995: ,p_structure_version_id IN NUMBER

Line 10117: PA_INTERFACE_UTILS_PUB.get_messages

10113:
10114: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10115: l_msg_count := FND_MSG_PUB.count_msg;
10116: IF l_msg_count = 1 THEN
10117: PA_INTERFACE_UTILS_PUB.get_messages
10118: (p_encoded => FND_API.G_TRUE
10119: ,p_msg_index => 1
10120: ,p_msg_count => l_msg_count
10121: ,p_msg_data => l_msg_data

Line 10168: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

10164: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
10165: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10166: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10167: ,p_debug_mode IN VARCHAR2 :='N'
10168: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10169: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10170: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10171: ,x_return_status OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
10172: ,x_msg_count OUT NOCOPY NUMBER -- 4565506 Added while merging

Line 10169: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

10165: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10166: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10167: ,p_debug_mode IN VARCHAR2 :='N'
10168: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10169: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10170: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10171: ,x_return_status OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
10172: ,x_msg_count OUT NOCOPY NUMBER -- 4565506 Added while merging
10173: ,x_msg_data OUT NOCOPY VARCHAR2 -- 4565506 Added while merging

Line 10170: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

10166: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10167: ,p_debug_mode IN VARCHAR2 :='N'
10168: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10169: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10170: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10171: ,x_return_status OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
10172: ,x_msg_count OUT NOCOPY NUMBER -- 4565506 Added while merging
10173: ,x_msg_data OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
10174: )