DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PVT dependencies on PA_PROJ_ELEMENT_VERSIONS

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

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

Line 27: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

23: , p_carrying_out_org_name IN VARCHAR2 := NULL
24: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
25: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
26: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE
27: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
28: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
29: , p_dlvr_type_name IN VARCHAR2 := NULL
30: , p_dlvr_reference IN VARCHAR2 := NULL
31: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL

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

76: , p_dlvr_owner_id IN PA_PROJ_ELEMENTS.MANAGER_PERSON_ID%TYPE := NULL
77: , p_dlvr_owner_name IN VARCHAR2 := NULL
78: , p_carrying_out_org_id IN PA_PROJ_ELEMENTS.CARRYING_OUT_ORGANIZATION_ID%TYPE := NULL
79: , p_carrying_out_org_name IN VARCHAR2 := NULL
80: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
81: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
82: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
83: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
84: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL

Line 83: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE

79: , p_carrying_out_org_name IN VARCHAR2 := NULL
80: , p_dlvr_version_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE := NULL
81: , p_status_code IN PA_PROJ_ELEMENTS.STATUS_CODE%TYPE := NULL
82: , p_parent_structure_id IN PA_PROJ_ELEMENTS.PARENT_STRUCTURE_ID%TYPE := NULL
83: , p_parent_struct_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
84: , p_dlvr_type_id IN PA_PROJ_ELEMENTS.TYPE_ID%TYPE := NULL
85: , p_dlvr_type_name IN VARCHAR2 := NULL
86: , p_progress_weight IN PA_PROJ_ELEMENTS.PROGRESS_WEIGHT%TYPE := NULL
87: , p_scheduled_finish_date IN PA_PROJ_ELEM_VER_SCHEDULE.SCHEDULED_FINISH_DATE%TYPE := NULL

Line 126: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

122: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
123: ,p_debug_mode IN VARCHAR2 :='N'
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

Line 144: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

140: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
141: ,p_debug_mode IN VARCHAR2 :='N'
142: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
144: ,p_task_version_id IN pa_proj_element_versions.element_version_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

Line 146: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

142: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
143: ,p_task_element_id IN pa_proj_elements.proj_element_id%TYPE
144: ,p_task_version_id IN pa_proj_element_versions.element_version_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

Line 167: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

163: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
164: ,p_debug_mode IN VARCHAR2 :='N'
165: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
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

Line 169: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

165: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
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

Line 211: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

207: ,p_debug_mode IN VARCHAR2 :='N'
208: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
209: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
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

Line 213: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE

209: ,p_calling_context IN VARCHAR2 := 'PA_TASKS'
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

Line 246: ,p_task_version_id IN pa_proj_element_versions.element_version_id%TYPE

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