1036: --Bug 3010538
1037: PROCEDURE GET_CONC_REQUEST_DETAILS(
1038: p_project_id IN pa_projects_all.project_id%TYPE
1039: ,p_structure_type IN pa_structure_types.structure_type%TYPE
1040: ,x_request_id OUT NOCOPY pa_proj_elem_ver_structure.conc_request_id%TYPE --File.Sql.39 bug 4440895
1041: ,x_process_code OUT NOCOPY pa_proj_elem_ver_structure.process_code%TYPE --File.Sql.39 bug 4440895
1042: ,x_structure_version_id OUT NOCOPY pa_proj_elem_ver_structure.element_version_id%TYPE --File.Sql.39 bug 4440895
1043: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1044: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1037: PROCEDURE GET_CONC_REQUEST_DETAILS(
1038: p_project_id IN pa_projects_all.project_id%TYPE
1039: ,p_structure_type IN pa_structure_types.structure_type%TYPE
1040: ,x_request_id OUT NOCOPY pa_proj_elem_ver_structure.conc_request_id%TYPE --File.Sql.39 bug 4440895
1041: ,x_process_code OUT NOCOPY pa_proj_elem_ver_structure.process_code%TYPE --File.Sql.39 bug 4440895
1042: ,x_structure_version_id OUT NOCOPY pa_proj_elem_ver_structure.element_version_id%TYPE --File.Sql.39 bug 4440895
1043: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1044: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1045: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1038: p_project_id IN pa_projects_all.project_id%TYPE
1039: ,p_structure_type IN pa_structure_types.structure_type%TYPE
1040: ,x_request_id OUT NOCOPY pa_proj_elem_ver_structure.conc_request_id%TYPE --File.Sql.39 bug 4440895
1041: ,x_process_code OUT NOCOPY pa_proj_elem_ver_structure.process_code%TYPE --File.Sql.39 bug 4440895
1042: ,x_structure_version_id OUT NOCOPY pa_proj_elem_ver_structure.element_version_id%TYPE --File.Sql.39 bug 4440895
1043: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1044: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1045: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1046: );