APPS.PA_PROJECT_STRUCTURE_UTILS dependencies on PA_PROJECTS_ALL

Line 1008: p_project_id IN pa_projects_all.project_id%TYPE

1004: ) return VARCHAR2;
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:

Line 1015: p_project_id IN pa_projects_all.project_id%TYPE

1011: return VARCHAR2;
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:

Line 1029: p_project_id IN pa_projects_all.project_id%TYPE

1025: return VARCHAR2;
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:

Line 1038: p_project_id IN pa_projects_all.project_id%TYPE

1034: function GET_FIN_STRUC_VER_ID(p_project_id IN NUMBER) return NUMBER;
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

Line 1052: p_project_id IN pa_projects_all.project_id%TYPE

1048: --Bug 3010538
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:

Line 1059: ,p_project_id IN pa_projects_all.project_id%TYPE -- Included for Perf. Bug fix 3968091

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:
1063: -- API name : CHECK_DELIVERABLE_ENABLED

Line 1233: p_project_id IN pa_projects_all.project_id%TYPE

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

Line 1308: -- Return Value : This API returns sys_program_flag from pa_projects_all table for a given project.

1304: -- bug 4597323
1305: -- API name : check_program_flag_enable
1306: -- Type : Utils API
1307: -- Pre-reqs : None
1308: -- Return Value : This API returns sys_program_flag from pa_projects_all table for a given project.
1309: -- It's created to use from Projects Form.
1310: --
1311: -- Parameters
1312: -- p_project_id IN NUMBER