DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PVT dependencies on PA_PROJECTS_ALL

Line 128: ,p_project_id IN pa_projects_all.project_id%TYPE

124: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
125: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
126: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
127: ,p_rec_ver_number IN pa_proj_elements.record_version_number%TYPE
128: ,p_project_id IN pa_projects_all.project_id%TYPE
129: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
130: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
131: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
132: ) ;

Line 149: ,p_project_id IN pa_projects_all.project_id%TYPE

145: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
146: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
147: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
148: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
149: ,p_project_id IN pa_projects_all.project_id%TYPE
150: ,p_calling_context IN VARCHAR2
151: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
152: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
153: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 170: ,p_project_id IN pa_projects_all.project_id%TYPE

166: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
167: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
168: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
169: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
170: ,p_project_id IN pa_projects_all.project_id%TYPE
171: ,p_calling_context IN VARCHAR2
172: ,x_disassociation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
173: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
174: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 193: ,p_project_id IN pa_projects_all.project_id%TYPE

189: ,p_element_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
190: ,p_element_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
191: ,p_task_or_dlv_elt_id IN NUMBER
192: ,p_task_or_dlv_ver_id IN NUMBER
193: ,p_project_id IN pa_projects_all.project_id%TYPE
194: ,p_task_or_dlv IN VARCHAR2 := 'PA_TASKS'
195: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
196: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
197: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 214: ,p_project_id IN pa_projects_all.project_id%TYPE

210: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
211: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
212: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
213: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
214: ,p_project_id IN pa_projects_all.project_id%TYPE
215: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
216: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
217: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
218: ) ;

Line 229: ,p_project_id IN pa_projects_all.project_id%TYPE

225: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
226: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
227: ,p_debug_mode IN VARCHAR2 :='N'
228: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
229: ,p_project_id IN pa_projects_all.project_id%TYPE
230: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
231: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
232: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
233: ) ;

Line 247: ,p_project_id IN pa_projects_all.project_id%TYPE

243: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
244: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
245: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
246: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
247: ,p_project_id IN pa_projects_all.project_id%TYPE
248: ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete
249: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
250: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
251: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895