APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_STRUCTURE_TYPES

Line 1030: ,p_structure_type IN pa_structure_types.structure_type%TYPE

1026:
1027: --Bug 3010538
1028: FUNCTION GET_PROCESS_STATUS_CODE(
1029: p_project_id IN pa_projects_all.project_id%TYPE
1030: ,p_structure_type IN pa_structure_types.structure_type%TYPE
1031: )
1032: return VARCHAR2;
1033:
1034: function GET_FIN_STRUC_VER_ID(p_project_id IN NUMBER) return NUMBER;

Line 1039: ,p_structure_type IN pa_structure_types.structure_type%TYPE

1035:
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

Line 1053: ,p_structure_type IN pa_structure_types.structure_type%TYPE

1049:
1050: --Below function is added for bug#3049157
1051: FUNCTION GET_CONC_REQUEST_ID(
1052: p_project_id IN pa_projects_all.project_id%TYPE
1053: ,p_structure_type IN pa_structure_types.structure_type%TYPE
1054: )
1055: return NUMBER;
1056:
1057: FUNCTION GET_STRUCT_CONC_ID(

Line 1234: , p_structure_type IN pa_structure_types.structure_type%TYPE := NULL

1230: -- Begin fix for Bug # 4373055.
1231:
1232: PROCEDURE GET_PROCESS_STATUS_MSG(
1233: p_project_id IN pa_projects_all.project_id%TYPE
1234: , p_structure_type IN pa_structure_types.structure_type%TYPE := NULL
1235: , p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE := NULL
1236: , p_context IN VARCHAR2 := NULL
1237: , x_message_name OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1238: , x_message_type OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895