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

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
40: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
41: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

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
40: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
41: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

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
40: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
41: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
44: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
45: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

38: ,p_debug_mode IN VARCHAR2 :='N'
39: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
41: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
44: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
45: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
46: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

39: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
41: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
44: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
45: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
46: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: ,p_lowest_level_task IN VARCHAR2 := 'N'

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

40: ,p_progress_mode IN VARCHAR2 := 'FUTURE'
41: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
44: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
45: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
46: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: ,p_lowest_level_task IN VARCHAR2 := 'N'
48: ,p_process_whole_tree IN VARCHAR2 := 'Y'

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

41: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
42: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
44: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
45: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
46: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: ,p_lowest_level_task IN VARCHAR2 := 'N'
48: ,p_process_whole_tree IN VARCHAR2 := 'Y'
49: ,p_structure_version_id IN NUMBER

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

42: ,p_object_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
43: ,p_object_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
44: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
45: ,p_task_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
46: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
47: ,p_lowest_level_task IN VARCHAR2 := 'N'
48: ,p_process_whole_tree IN VARCHAR2 := 'Y'
49: ,p_structure_version_id IN NUMBER
50: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

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

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
94: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
95: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

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
94: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
95: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
97: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE

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

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
94: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
95: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
97: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
98: ,p_lowest_level_task IN VARCHAR2 := 'N'

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

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
94: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
95: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
97: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
98: ,p_lowest_level_task IN VARCHAR2 := 'N'
99: ,p_task_version_id IN NUMBER

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

92: ,p_debug_mode IN VARCHAR2 :='N'
93: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
94: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
95: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
96: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
97: ,p_rollup_table IN PA_SCHEDULE_OBJECTS_PVT.PA_SCHEDULE_OBJECTS_TBL_TYPE
98: ,p_lowest_level_task IN VARCHAR2 := 'N'
99: ,p_task_version_id IN NUMBER
100: ,p_structure_version_id IN NUMBER

Line 115: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

111: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
112: );
113:
114: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
115: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
116: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
117: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
118: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
119: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE

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

112: );
113:
114: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
115: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
116: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
117: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
118: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
119: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
120: ,p_lowest_level_task IN VARCHAR2 := 'N'

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

113:
114: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
115: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
116: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
117: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
118: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
119: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
120: ,p_lowest_level_task IN VARCHAR2 := 'N'
121: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'

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

114: PROCEDURE ROLLUP_FUTURE_PROGRESS_PVT(
115: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
116: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
117: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
118: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
119: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
120: ,p_lowest_level_task IN VARCHAR2 := 'N'
121: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
122: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710

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

115: p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
116: ,P_OBJECT_TYPE IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
117: ,P_OBJECT_ID IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
118: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
119: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
120: ,p_lowest_level_task IN VARCHAR2 := 'N'
121: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
122: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
123: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'

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

118: ,p_object_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
119: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
120: ,p_lowest_level_task IN VARCHAR2 := 'N'
121: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
122: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
123: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
124: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
125: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
126: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

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

120: ,p_lowest_level_task IN VARCHAR2 := 'N'
121: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
122: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
123: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
124: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
125: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
126: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
127: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
128: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

121: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
122: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
123: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
124: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
125: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
126: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
127: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
128: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

122: ,p_calling_mode IN VARCHAR2 :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR -- Bug 4097710
123: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
124: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
125: ,p_fin_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
126: ,p_wp_rollup_method IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
127: ,p_rollup_entire_wbs IN VARCHAR2 := 'N' -- Bug 3606627
128: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
129: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
130: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

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
143: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
144: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

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
143: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
144: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

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
143: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
144: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
147: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

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
143: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
144: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
147: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
148: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

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
143: ,p_as_of_date IN DATE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_DATE
144: ,p_structure_type IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
145: ,p_structure_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
146: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
147: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
148: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
149: );

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

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
170: ,p_task_id IN NUMBER
171: ,p_task_version_id IN NUMBER
172: ,p_as_of_date IN DATE

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

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
192: ,p_project_id IN NUMBER
193: ,p_task_id IN NUMBER
194: ,p_structure_version_id IN NUMBER

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

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
233: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
234: ,x_return_status OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
235: ,x_msg_count OUT NOCOPY NUMBER -- 4565506 Added while merging

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

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
233: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
234: ,x_return_status OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
235: ,x_msg_count OUT NOCOPY NUMBER -- 4565506 Added while merging
236: ,x_msg_data OUT NOCOPY VARCHAR2 -- 4565506 Added while merging

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

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
233: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
234: ,x_return_status OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
235: ,x_msg_count OUT NOCOPY NUMBER -- 4565506 Added while merging
236: ,x_msg_data OUT NOCOPY VARCHAR2 -- 4565506 Added while merging
237: );