DBA Data[Home] [Help]

APPS.PA_ACTIONS_PVT dependencies on PA_PROJECTS_ALL

Line 39: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null

35: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
36: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
37: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
38: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
39: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
40: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE
41: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
42: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
43: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

Line 87: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null

83: ,p_attribute15_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
84: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
85: ,p_proj_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
86: ,p_record_version_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
87: ,p_project_id IN PA_PROJECTS_ALL.PROJECT_ID%TYPE := null
88: ,p_object_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null -- 3578694 added default value
89: ,p_object_version_id IN PA_OBJECT_RELATIONSHIPS.OBJECT_ID_TO1%TYPE := null
90: ,p_object_type IN PA_LOOKUPS.LOOKUP_CODE%TYPE
91: ,p_pm_source_code IN pa_proj_elements.pm_source_code%TYPE := null

Line 132: ,p_project_id IN pa_projects_all.project_id%TYPE

128: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
129: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
130: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
131: ,p_function_code IN pa_proj_elements.function_code%TYPE
132: ,p_project_id IN pa_projects_all.project_id%TYPE
133: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
134: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
135: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
136: ) ;

Line 151: ,p_source_project_id IN pa_projects_all.project_id%TYPE

147: ,p_source_object_id IN pa_object_relationships.object_id_from2%TYPE
148: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
149: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
150: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
151: ,p_source_project_id IN pa_projects_all.project_id%TYPE
152: ,p_target_project_id IN pa_projects_all.project_id%TYPE
153: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
154: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
155: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null

Line 152: ,p_target_project_id IN pa_projects_all.project_id%TYPE

148: ,p_source_object_type IN pa_object_relationships.object_type_from%TYPE
149: ,p_target_object_id IN pa_object_relationships.object_id_from2%TYPE
150: ,p_target_object_type IN pa_object_relationships.object_type_from%TYPE
151: ,p_source_project_id IN pa_projects_all.project_id%TYPE
152: ,p_target_project_id IN pa_projects_all.project_id%TYPE
153: ,p_task_id IN pa_proj_elements.proj_element_id%TYPE := null
154: ,p_task_ver_id IN pa_proj_element_versions.element_version_id%TYPE := null
155: ,p_carrying_out_organization_id IN pa_proj_elements.carrying_out_organization_id%TYPE := null
156: ,p_pm_source_reference IN pa_proj_elements.pm_source_reference%TYPE := null

Line 178: ,p_project_id IN pa_projects_all.project_id%TYPE

174: ,p_action_ver_id IN pa_proj_element_versions.element_version_id%TYPE
175: ,p_dlv_element_id IN pa_proj_elements.proj_element_id%TYPE
176: ,p_dlv_version_id IN pa_proj_element_versions.element_version_id%TYPE
177: ,p_function_code IN pa_proj_elements.function_code%TYPE
178: ,p_project_id IN pa_projects_all.project_id%TYPE
179: ,x_action_del_allowed IN VARCHAR2
180: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
181: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
182: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895