DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_PROJ_ELEMENT_VERSIONS

Line 310: -- p_structure_version_id pa_proj_element_versions.element_version_id%TYPE

306: -- N is not locked,
307: -- O is locked by other user.
308: -- Parameters
309: -- p_user_id fnd_user.user_id%TYPE
310: -- p_structure_version_id pa_proj_element_versions.element_version_id%TYPE
311: --
312: --
313: -- History
314: --

Line 319: p_structure_version_id pa_proj_element_versions.element_version_id%TYPE)

315: -- 20-may-03 mrajput -Created
316: -- Added For bug 2964237
317:
318: function IS_STRUC_VER_LOCKED_BY_USER1(p_user_id fnd_user.user_id%TYPE,
319: p_structure_version_id pa_proj_element_versions.element_version_id%TYPE)
320: return VARCHAR2;
321:
322:
323:

Line 1009: ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE

1005:
1006: --Bug 3010538
1007: FUNCTION GET_UPDATE_WBS_FLAG(
1008: p_project_id IN pa_projects_all.project_id%TYPE
1009: ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
1010: )
1011: return VARCHAR2;
1012:
1013: --Bug 3010538

Line 1016: ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE

1012:
1013: --Bug 3010538
1014: FUNCTION GET_PROCESS_STATUS_CODE(
1015: p_project_id IN pa_projects_all.project_id%TYPE
1016: ,p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE
1017: )
1018: return VARCHAR2;
1019:
1020: --Bug 3010538

Line 1058: p_structure_version_id IN pa_proj_element_versions.parent_structure_version_id%TYPE

1054: )
1055: return NUMBER;
1056:
1057: FUNCTION GET_STRUCT_CONC_ID(
1058: p_structure_version_id IN pa_proj_element_versions.parent_structure_version_id%TYPE
1059: ,p_project_id IN pa_projects_all.project_id%TYPE -- Included for Perf. Bug fix 3968091
1060: )
1061: return NUMBER ;
1062:

Line 1235: , p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE := NULL

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
1239: , x_structure_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895