eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 2744: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,

2740: prg.SUP_PROJECT_ID,
2741: prg.SUP_ID
2742: from
2743: PJI_PJP_WBS_HEADER sub_wbs_hdr,
2744: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,
2745: PJI_XBS_DENORM prg
2746: where
2747: prg.struct_version_id is null and
2748: sub_wbs_hdr.PLAN_VERSION_ID = p_plan_version_id and

Line 2765: PA_PROJ_ELEM_VER_STRUCTURE ppevs1

2761: (
2762: select
2763: 1
2764: from
2765: PA_PROJ_ELEM_VER_STRUCTURE ppevs1
2766: where
2767: ppevs1.PROJECT_ID = sup_wbs_hdr.PROJECT_ID and
2768: ppevs1.ELEMENT_VERSION_ID = sup_wbs_hdr.WBS_VERSION_ID and
2769: ppevs1.LATEST_EFF_PUBLISHED_FLAG = 'Y'

Line 2939: , PA_PROJ_ELEM_VER_STRUCTURE ppevs

2935: FROM PA_PROJ_WORKPLAN_ATTR ppwa
2936: , PA_PROJ_ELEMENTS ppe
2937: , PA_PROJ_STRUCTURE_TYPES ppst
2938: , PA_STRUCTURE_TYPES pst
2939: , PA_PROJ_ELEM_VER_STRUCTURE ppevs
2940: , pji_pjp_wbs_header wh
2941: -- , pa_budget_versions bv -- can't depend on bv in plan delete flow.
2942: WHERE 1=1
2943: AND ppe.project_id = ppwa.project_id

Line 3016: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1

3012: INTO l_num_locked
3013: FROM pji_xbs_denorm den
3014: , pji_pjp_wbs_header hd1 -- SUP
3015: , pji_pjp_wbs_header hd2 -- SUB
3016: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3017: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
3018: WHERE
3019: den.struct_version_id IS NULL
3020: AND hd2.plan_version_id = l_fp_version_ids(l_count)

Line 3017: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2

3013: FROM pji_xbs_denorm den
3014: , pji_pjp_wbs_header hd1 -- SUP
3015: , pji_pjp_wbs_header hd2 -- SUB
3016: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3017: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
3018: WHERE
3019: den.struct_version_id IS NULL
3020: AND hd2.plan_version_id = l_fp_version_ids(l_count)
3021: AND hd2.project_id = l_project_ids(l_count)

Line 3869: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,

3865: prg.SUP_ID
3866: from
3867: PA_PJI_PROJ_EVENTS_LOG log,
3868: PJI_PJP_WBS_HEADER sub_wbs_hdr,
3869: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,
3870: PJI_XBS_DENORM prg
3871: where
3872: prg.STRUCT_VERSION_ID is null and
3873: sub_wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and

Line 3897: PA_PROJ_ELEM_VER_STRUCTURE ppevs1

3893: (
3894: select
3895: 1
3896: from
3897: PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3898: where
3899: ppevs1.PROJECT_ID = sup_wbs_hdr.PROJECT_ID and
3900: ppevs1.ELEMENT_VERSION_ID = sup_wbs_hdr.WBS_VERSION_ID and
3901: ppevs1.STATUS_CODE = 'STRUCTURE_WORKING'

Line 3993: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1

3989: , PA_PROJ_WORKPLAN_ATTR ppwa1
3990: , PA_PROJ_ELEMENTS ppe1
3991: , PA_PROJ_STRUCTURE_TYPES ppst1
3992: , PA_STRUCTURE_TYPES pst1
3993: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3994: , PA_PROJ_WORKPLAN_ATTR ppwa2
3995: , PA_PROJ_ELEMENTS ppe2
3996: , PA_PROJ_STRUCTURE_TYPES ppst2
3997: , PA_STRUCTURE_TYPES pst2

Line 3998: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2

3994: , PA_PROJ_WORKPLAN_ATTR ppwa2
3995: , PA_PROJ_ELEMENTS ppe2
3996: , PA_PROJ_STRUCTURE_TYPES ppst2
3997: , PA_STRUCTURE_TYPES pst2
3998: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
3999: , PA_PJI_PROJ_EVENTS_LOG elog
4000: WHERE
4001: den.struct_version_id IS NULL
4002: AND hd2.wbs_version_id = den.sub_id -- struct_version_id

Line 4691: /*UPDATE pa_proj_elem_ver_structure

4687:
4688: EXCEPTION
4689: WHEN OTHERS THEN
4690:
4691: /*UPDATE pa_proj_elem_ver_structure
4692: SET PROCESS_CODE = 'WUE',
4693: CONC_REQUEST_ID = l_request_id
4694: WHERE ELEMENT_VERSION_ID = l_struct_version_id
4695: AND PROJECT_ID = l_project_id;

Line 5222: UPDATE pa_proj_elem_ver_structure

5218: IF g_debug_mode='Y' THEN
5219: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_LOCK_PVT: l_lock_mode '||l_lock_mode ,null,3);
5220: end if;
5221: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5222: UPDATE pa_proj_elem_ver_structure
5223: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
5224: , 'CONC_PUBLISH', 'PUE'
5225: , 'CONC_UPDATE', 'WUE', null),
5226: process_update_wbs_flag = 'Y', /* 5138049 */

Line 5254: UPDATE pa_proj_elem_ver_structure

5250: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
5251:
5252: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
5253: rollback to process_proj_sum_conc;
5254: UPDATE pa_proj_elem_ver_structure
5255: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
5256: , 'CONC_PUBLISH', 'PUE'
5257: , 'CONC_UPDATE', 'WUE', null),
5258: process_update_wbs_flag = 'Y', /* 5138049 */

Line 5276: UPDATE pa_proj_elem_ver_structure

5272: retcode := 2;
5273: errbuf := SQLERRM;
5274: ELSE
5275: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
5276: UPDATE pa_proj_elem_ver_structure
5277: SET PROCESS_CODE = NULL,
5278: process_update_wbs_flag='N',
5279: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
5280: WHERE ELEMENT_VERSION_ID = l_struct_version_id