[Home] [Help]
119: SELECT p_project_id ,'N',p_project_id,-1,struct_ver.proj_element_id,
120: 'N',struct_ver.NAME,'Y','Y' ,
121: SYSDATE, SYSDATE, 1, 1,
122: 0 ,t_element_version_id, -1,t_element_version_id, 'WF'
123: FROM pa_proj_elem_ver_structure struct_ver
124: WHERE 1=1
125: AND struct_ver.project_id = p_project_id
126: AND struct_ver.element_version_id = t_element_version_id;
127:
133: SELECT p_project_id,'N',p_project_id,struct_ver.proj_element_id,
134: struct_ver.proj_element_id,'N',struct_ver.NAME,'N','N' ,
135: SYSDATE, SYSDATE, 1, 1,
136: 0 ,t_element_version_id, 0, t_element_version_id, 'WF'
137: FROM pa_proj_elem_ver_structure struct_ver
138: WHERE 1=1
139: AND struct_ver.project_id = p_project_id
140: AND struct_ver.element_version_id = t_element_version_id;
141:
222: , last_updated_by, creation_date, created_by, last_update_login, attribute1, attribute2)
223: SELECT 'STRUCT_CHANGE',pa_pji_proj_events_log_s.NEXTVAL,'-99','X','X',SYSDATE,
224: Fnd_Global.USER_ID,SYSDATE,Fnd_Global.USER_ID,Fnd_Global.LOGIN_ID,p_wbs_version_id_tbl(l_i),'N'
225: FROM dual WHERE exists (
226: SELECT ppa.project_id from PA_PROJECTS_ALL ppa, PA_PROJ_ELEM_VER_STRUCTURE ppevs WHERE
227: ppa.project_id = ppevs.project_id AND
228: ppevs.ELEMENT_VERSION_ID = p_wbs_version_id_tbl(l_i) AND
229: ppa.template_flag <> 'Y'
230: )
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
507: SELECT p_project_id,'N',p_project_id,-1,struct_ver.proj_element_id,
508: 'N',struct_ver.NAME,'Y','Y' ,
509: SYSDATE, SYSDATE, 1, 1,
510: 0 ,p_element_version_id, -1, p_element_version_id, 'WF'
511: FROM pa_proj_elem_ver_structure struct_ver
512: WHERE 1=1
513: AND struct_ver.project_id = p_project_id
514: AND struct_ver.element_version_id = p_element_version_id;
515:
524: SELECT p_project_id,'N',p_project_id,struct_ver.proj_element_id,
525: struct_ver.proj_element_id,'N',struct_ver.NAME,'N','N' ,
526: SYSDATE, SYSDATE, 1, 1,
527: 0 ,p_element_version_id, 0, p_element_version_id, 'WF'
528: FROM pa_proj_elem_ver_structure struct_ver
529: WHERE 1=1
530: AND struct_ver.project_id = p_project_id
531: AND struct_ver.element_version_id = p_element_version_id;
532:
641: ,p_element_version_id
642: , -1
643: ,p_element_version_id
644: , 'WF'
645: FROM pa_proj_elem_ver_structure struct_ver
646: WHERE 1=1
647: AND struct_ver.project_id = p_project_id
648: AND struct_ver.element_version_id = p_element_version_id;
649:
673: ,p_element_version_id
674: , 0
675: , denorm.sup_id
676: , 'WF'
677: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver, pa_proj_elements emt
678: WHERE 1=1
679: AND denorm.sup_project_id = p_project_id
680: AND denorm.sup_id = p_element_version_id
681: AND denorm.struct_version_id IS NULL
806: ,p_element_version_id
807: , -1
808: , sub_id
809: , denorm.relationship_type
810: FROM pji_xbs_denorm denorm, pa_proj_elem_ver_structure struct_ver,pa_proj_elements emt
811: , (SELECT sub_id wbs_version_id, sub_leaf_flag
812: FROM pji_xbs_denorm
813: WHERE 1=1
814: AND sup_project_id = p_project_id
2152: IS
2153: CURSOR c_wbs_params IS
2154: SELECT element_version_id, proj_element_id
2155: FROM
2156: pa_proj_elem_ver_structure
2157: WHERE
2158: project_id = p_project_id
2159: ORDER BY NVL(Latest_eff_published_flag,'N') DESC, NVL(current_working_flag,'N') DESC;
2160: BEGIN
4570: IS
4571: CURSOR get_baselined_version(c_project_id pa_projects_all.project_id%TYPE)
4572: IS
4573: SELECT header.plan_version_id
4574: FROM pa_proj_elem_ver_structure str,
4575: pji_pjp_wbs_header header
4576: WHERE str.project_id = c_project_id
4577: AND str.current_flag = 'Y'
4578: AND header.project_id = str.project_id
4597: IS
4598: CURSOR get_latest_published_version(c_project_id pa_projects_all.project_id%TYPE)
4599: IS
4600: SELECT header.plan_version_id
4601: FROM pa_proj_elem_ver_structure str,
4602: pji_pjp_wbs_header header
4603: WHERE str.project_id = c_project_id
4604: AND str.latest_eff_published_flag = 'Y'
4605: AND header.project_id = str.project_id
5805:
5806: CURSOR struct_list(c_structure_version_id pa_proj_element_versions.element_version_id%TYPE
5807: , c_structure_type VARCHAR2) IS
5808: SELECT vs.element_version_id, vs.project_id
5809: FROM pa_proj_elem_ver_structure vs
5810: , pji_xbs_denorm denorm
5811: WHERE denorm.struct_version_id IS NULL
5812: AND denorm.struct_type = 'PRG'
5813: AND NVL(denorm.relationship_type,'WF') IN ('WF',c_structure_type)
5910:
5911: SELECT COUNT(DISTINCT UPPER(pt.project_type_class_code))
5912: INTO l_proj_type_count
5913: FROM pji_xbs_denorm denorm
5914: ,pa_proj_elem_ver_structure vs
5915: ,pa_projects_all proj
5916: ,pa_project_types_all pt
5917: WHERE struct_type = 'PRG'
5918: AND sup_project_id = p_project_id
6164: INTO l_count
6165: FROM
6166: pji_xbs_denorm denorm
6167: , pa_proj_elements elem
6168: , pa_proj_elem_ver_structure ppevs
6169: WHERE 1=1
6170: AND denorm.sup_project_id = p_project_id
6171: AND denorm.sup_id = p_structure_version_id
6172: AND denorm.struct_type = 'PRG'
6325:
6326: FROM pji_fp_xbs_accum_f f,
6327: pa_projects_all p,
6328: pa_rbs_prj_assignments r,
6329: pa_proj_elem_ver_structure s,
6330: pa_proj_element_versions ppev,
6331: pji_pjp_wbs_header h
6332: WHERE p.project_id=f.project_id
6333: AND p.project_id=r.project_id
6380: SELECT Sum(f.brdn_cost) BASELINE_COST
6381: FROM
6382: pji_fp_xbs_accum_f f,
6383: pa_projects_all p,
6384: PA_PROJ_ELEM_VER_STRUCTURE ppev,
6385: pji_pjp_wbs_header h
6386: WHERE
6387: p.project_id = p_project_id AND
6388: p.project_id=f.project_id AND