DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PUB dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 26: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL

22: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
23: , p_dlvr_owner_name IN VARCHAR2 := NULL
24: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
25: , p_carrying_out_org_name IN VARCHAR2 := NULL
26: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
27: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
28: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
29: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
30: , p_dlvr_type_name IN VARCHAR2 := NULL

Line 89: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL

85: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
86: , p_dlvr_owner_name IN VARCHAR2 := NULL
87: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
88: , p_carrying_out_org_name IN VARCHAR2 := NULL
89: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
90: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
91: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
92: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
93: , p_dlvr_type_name IN VARCHAR2 := NULL

Line 162: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

158: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
159: ,p_debug_mode IN VARCHAR2 :='N'
160: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
161: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
162: ,p_task_version_id IN pa_proj_element_versions.element_version_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

Line 164: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

160: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
161: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
162: ,p_task_version_id IN pa_proj_element_versions.element_version_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'

Line 222: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

218: ,p_debug_mode IN VARCHAR2 :='N'
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