DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_STRUCTURE_TYPES

Line 354: from pa_projects_all p , pa_proj_elem_ver_structure s, pa_proj_structure_types ppst, pa_structure_types pst

350: else -- Bug 16507592 START
351:
352: /*select nvl(p.pjt_rollup_enabled_flag,'N'), s.proj_element_id , s.element_version_id
353: into l_pjt_rollup_flag, l_new_elem_id , l_struct_ver_id
354: from pa_projects_all p , pa_proj_elem_ver_structure s, pa_proj_structure_types ppst, pa_structure_types pst
355: where p.project_id = p_project_id
356: and s.project_id = p.project_id
357: and s.proj_element_id = ppst.proj_element_id
358: and ppst.structure_type_id = pst.structure_type_id

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

5790: END Chk_plan_vers_have_same_RBS;
5791:
5792: PROCEDURE GET_PROCESS_STATUS_MSG(
5793: p_project_id IN pa_projects_all.project_id%TYPE
5794: , p_structure_type IN pa_structure_types.structure_type%TYPE := NULL
5795: , p_structure_version_id IN pa_proj_element_versions.element_version_id%TYPE := NULL
5796: , p_prg_flag IN VARCHAR2 := NULL
5797: , x_message_name OUT NOCOPY VARCHAR2
5798: , x_message_type OUT NOCOPY VARCHAR2