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 45: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1470: 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

1466: l_wp_version_enabled_flag := NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id), 'N'); -- Bug#12393400
1467:
1468: -- 20 May : Amit : If Structure_version_id is null, then no rocessing shd be done
1469: -- Bug 3856161 : Added p_as_of_date check also
1470: 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
1471: return;
1472: END IF;
1473:
1474: --bug 4045979

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

4060: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
4061: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4062: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4063: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4064: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4065: ,p_debug_mode IN VARCHAR2 :='N'
4066: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4067: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4068: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

4062: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4063: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4064: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4065: ,p_debug_mode IN VARCHAR2 :='N'
4066: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4067: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4068: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4069: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4070: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE

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

4063: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4064: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4065: ,p_debug_mode IN VARCHAR2 :='N'
4066: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4067: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4068: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4069: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4070: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4071: ,p_lowest_level_task IN VARCHAR2 := 'N'

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

4064: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4065: ,p_debug_mode IN VARCHAR2 :='N'
4066: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4067: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4068: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4069: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4070: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4071: ,p_lowest_level_task IN VARCHAR2 := 'N'
4072: ,p_task_version_id IN NUMBER

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

4065: ,p_debug_mode IN VARCHAR2 :='N'
4066: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4067: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4068: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4069: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4070: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
4071: ,p_lowest_level_task IN VARCHAR2 := 'N'
4072: ,p_task_version_id IN NUMBER
4073: ,p_structure_version_id IN NUMBER

Line 4143: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

4139: raise;
4140: END UPDATE_ROLLUP_PROGRESS_PVT;
4141:
4142: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
4143: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4144: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4145: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4146: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4147: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

4140: END UPDATE_ROLLUP_PROGRESS_PVT;
4141:
4142: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
4143: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4144: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4145: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4146: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4147: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4148: ,p_lowest_level_task IN VARCHAR2 := 'N'

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

4141:
4142: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
4143: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4144: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4145: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4146: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4147: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4148: ,p_lowest_level_task IN VARCHAR2 := 'N'
4149: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'

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

4142: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
4143: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4144: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4145: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4146: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4147: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4148: ,p_lowest_level_task IN VARCHAR2 := 'N'
4149: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4150: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710

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

4143: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4144: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4145: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4146: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4147: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4148: ,p_lowest_level_task IN VARCHAR2 := 'N'
4149: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4150: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4151: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

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

4146: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4147: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4148: ,p_lowest_level_task IN VARCHAR2 := 'N'
4149: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4150: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4151: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
4152: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4153: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4154: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

4148: ,p_lowest_level_task IN VARCHAR2 := 'N'
4149: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4150: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4151: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
4152: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4153: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4154: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4155: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
4156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

4149: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
4150: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4151: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
4152: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4153: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4154: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4155: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
4156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4157: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

4150: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
4151: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
4152: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4153: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4154: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4155: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
4156: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4157: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4158: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4346: Pa_Interface_Utils_Pub.get_messages

4342: l_msg_count := Fnd_Msg_Pub.count_msg;
4343:
4344: IF l_msg_count = 1 AND x_msg_data IS NULL
4345: THEN
4346: Pa_Interface_Utils_Pub.get_messages
4347: ( p_encoded => Fnd_Api.G_FALSE
4348: , p_msg_index => 1
4349: , p_msg_count => l_msg_count
4350: , p_msg_data => l_msg_data

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

4372: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
4373: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4375: ,p_debug_mode IN VARCHAR2 :='N'
4376: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4377: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4378: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4379: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4380: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

4373: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
4374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4375: ,p_debug_mode IN VARCHAR2 :='N'
4376: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4377: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4378: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4379: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4380: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4381: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

4374: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
4375: ,p_debug_mode IN VARCHAR2 :='N'
4376: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4377: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4378: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4379: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4380: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4381: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4382: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

4375: ,p_debug_mode IN VARCHAR2 :='N'
4376: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4377: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4378: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4379: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4380: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4381: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4382: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4383: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

4376: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4377: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4378: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
4379: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
4380: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
4381: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4382: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4383: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4384: )

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

5552: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
5553: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
5554: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
5555: ,p_debug_mode IN VARCHAR2 :='N'
5556: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
5557: ,p_project_id IN NUMBER
5558: ,p_task_id IN NUMBER
5559: ,p_task_version_id IN NUMBER
5560: ,p_as_of_date IN DATE

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

9053: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
9054: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
9055: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
9056: ,p_debug_mode IN VARCHAR2 :='N'
9057: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
9058: ,p_resource_list_mem_id IN NUMBER
9059: ,p_project_id IN NUMBER
9060: ,p_task_id IN NUMBER
9061: ,p_structure_version_id IN NUMBER

Line 10185: PA_INTERFACE_UTILS_PUB.get_messages

10181:
10182: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
10183: l_msg_count := FND_MSG_PUB.count_msg;
10184: IF l_msg_count = 1 THEN
10185: PA_INTERFACE_UTILS_PUB.get_messages
10186: (p_encoded => FND_API.G_TRUE
10187: ,p_msg_index => 1
10188: ,p_msg_count => l_msg_count
10189: ,p_msg_data => l_msg_data

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

10232: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
10233: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10234: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10235: ,p_debug_mode IN VARCHAR2 :='N'
10236: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10237: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10238: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10239: ,x_return_status OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
10240: ,x_msg_count OUT NOCOPY NUMBER -- 4565506 Added while merging

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

10233: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10234: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10235: ,p_debug_mode IN VARCHAR2 :='N'
10236: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10237: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10238: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10239: ,x_return_status OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
10240: ,x_msg_count OUT NOCOPY NUMBER -- 4565506 Added while merging
10241: ,x_msg_data OUT NOCOPY VARCHAR2 -- 4565506 Added while merging

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

10234: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10235: ,p_debug_mode IN VARCHAR2 :='N'
10236: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10237: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10238: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10239: ,x_return_status OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
10240: ,x_msg_count OUT NOCOPY NUMBER -- 4565506 Added while merging
10241: ,x_msg_data OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
10242: )

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

10552: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
10553: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
10554: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10555: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10556: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10557: ,p_debug_mode IN VARCHAR2 :='N'
10558: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10559: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
10560: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

10554: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
10555: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
10556: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10557: ,p_debug_mode IN VARCHAR2 :='N'
10558: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10559: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
10560: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10561: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10562: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

10556: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10557: ,p_debug_mode IN VARCHAR2 :='N'
10558: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10559: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
10560: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10561: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10562: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10563: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10564: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

10557: ,p_debug_mode IN VARCHAR2 :='N'
10558: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10559: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
10560: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10561: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10562: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10563: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10564: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10565: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

10558: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10559: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
10560: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10561: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10562: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10563: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10564: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10565: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
10566: ,p_lowest_level_task IN VARCHAR2 := 'N'

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

10559: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
10560: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10561: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10562: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10563: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10564: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10565: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
10566: ,p_lowest_level_task IN VARCHAR2 := 'N'
10567: ,p_process_whole_tree IN VARCHAR2 := 'Y'

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

10560: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10561: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10562: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10563: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10564: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10565: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
10566: ,p_lowest_level_task IN VARCHAR2 := 'N'
10567: ,p_process_whole_tree IN VARCHAR2 := 'Y'
10568: ,p_structure_version_id IN NUMBER

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

10561: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
10562: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10563: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10564: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
10565: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
10566: ,p_lowest_level_task IN VARCHAR2 := 'N'
10567: ,p_process_whole_tree IN VARCHAR2 := 'Y'
10568: ,p_structure_version_id IN NUMBER
10569: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

Line 11763: 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

11759: l_wp_version_enabled_flag := NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id), 'N'); -- Bug#12393400
11760:
11761: -- 20 May : Amit : If Structure_version_id is null, then no rocessing shd be done
11762: -- Bug 3856161 : Added p_as_of_date check also
11763: 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
11764: return;
11765: END IF;
11766:
11767: --bug 4045979

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

14108: ,p_commit IN VARCHAR2 :=FND_API.G_FALSE
14109: ,p_validate_only IN VARCHAR2 :=FND_API.G_TRUE
14110: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
14111: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
14112: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14113: ,p_debug_mode IN VARCHAR2 :='N'
14114: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14115: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
14116: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

14110: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
14111: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
14112: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14113: ,p_debug_mode IN VARCHAR2 :='N'
14114: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14115: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
14116: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14117: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14118: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

14112: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14113: ,p_debug_mode IN VARCHAR2 :='N'
14114: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14115: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
14116: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14117: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14118: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14119: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14120: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

14113: ,p_debug_mode IN VARCHAR2 :='N'
14114: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14115: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
14116: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14117: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14118: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14119: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14120: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14121: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

14114: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14115: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
14116: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14117: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14118: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14119: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14120: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14121: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
14122: ,p_lowest_level_task IN VARCHAR2 := 'N'

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

14115: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
14116: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14117: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14118: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14119: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14120: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14121: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
14122: ,p_lowest_level_task IN VARCHAR2 := 'N'
14123: ,p_process_whole_tree IN VARCHAR2 := 'Y'

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

14116: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14117: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14118: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14119: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14120: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14121: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
14122: ,p_lowest_level_task IN VARCHAR2 := 'N'
14123: ,p_process_whole_tree IN VARCHAR2 := 'Y'
14124: ,p_structure_version_id IN NUMBER

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

14117: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
14118: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14119: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14120: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
14121: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
14122: ,p_lowest_level_task IN VARCHAR2 := 'N'
14123: ,p_process_whole_tree IN VARCHAR2 := 'Y'
14124: ,p_structure_version_id IN NUMBER
14125: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

Line 15333: 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

15329: l_wp_version_enabled_flag := NVL(PA_WORKPLAN_ATTR_UTILS.CHECK_WP_VERSIONING_ENABLED(p_project_id), 'N'); -- Bug#12393400
15330:
15331: -- 20 May : Amit : If Structure_version_id is null, then no rocessing shd be done
15332: -- Bug 3856161 : Added p_as_of_date check also
15333: 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
15334: return;
15335: END IF;
15336:
15337: --bug 4045979