DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PUB dependencies on PA_PROJECTS_ALL

Line 146: ,p_project_id IN pa_projects_all.project_id%TYPE

142: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_rec_ver_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
144: ,p_dlv_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
145: ,p_dlv_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
146: ,p_project_id IN pa_projects_all.project_id%TYPE
147: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
148: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
149: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
150: ) ;

Line 167: ,p_project_id IN pa_projects_all.project_id%TYPE

163: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
164: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
165: ,p_object_relationship_id IN pa_object_relationships.object_relationship_id%TYPE
166: ,p_obj_rec_ver_number IN pa_object_relationships.record_version_number%TYPE
167: ,p_project_id IN pa_projects_all.project_id%TYPE
168: ,p_calling_context IN VARCHAR2 := 'TASKS'
169: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
170: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
171: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 189: ,p_project_id IN pa_projects_all.project_id%TYPE

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

Line 205: ,p_project_id IN pa_projects_all.project_id%TYPE

201: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
202: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
203: ,p_debug_mode IN VARCHAR2 :='N'
204: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
205: ,p_project_id IN pa_projects_all.project_id%TYPE
206: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
207: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
208: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
209: ) ;

Line 223: ,p_project_id IN pa_projects_all.project_id%TYPE

219: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
220: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
221: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
222: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE
223: ,p_project_id IN pa_projects_all.project_id%TYPE
224: ,p_delete_or_validate IN VARCHAR2 := 'B' -- 3955848 V- Validate , D - Delete, B - Validate and Delete
225: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
226: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
227: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895