APPS.PJI_FM_XBS_ACCUM_MAINT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 2368: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,

2364: prg.SUP_PROJECT_ID,
2365: prg.SUP_ID
2366: from
2367: PJI_PJP_WBS_HEADER sub_wbs_hdr,
2368: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,
2369: PJI_XBS_DENORM prg
2370: where
2371: prg.struct_version_id is null and
2372: sub_wbs_hdr.PLAN_VERSION_ID = p_plan_version_id and

Line 2389: PA_PROJ_ELEM_VER_STRUCTURE ppevs1

2385: (
2386: select
2387: 1
2388: from
2389: PA_PROJ_ELEM_VER_STRUCTURE ppevs1
2390: where
2391: ppevs1.PROJECT_ID = sup_wbs_hdr.PROJECT_ID and
2392: ppevs1.ELEMENT_VERSION_ID = sup_wbs_hdr.WBS_VERSION_ID and
2393: ppevs1.LATEST_EFF_PUBLISHED_FLAG = 'Y'

Line 2563: , PA_PROJ_ELEM_VER_STRUCTURE ppevs

2559: FROM PA_PROJ_WORKPLAN_ATTR ppwa
2560: , PA_PROJ_ELEMENTS ppe
2561: , PA_PROJ_STRUCTURE_TYPES ppst
2562: , PA_STRUCTURE_TYPES pst
2563: , PA_PROJ_ELEM_VER_STRUCTURE ppevs
2564: , pji_pjp_wbs_header wh
2565: -- , pa_budget_versions bv -- can't depend on bv in plan delete flow.
2566: WHERE 1=1
2567: AND ppe.project_id = ppwa.project_id

Line 2640: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1

2636: INTO l_num_locked
2637: FROM pji_xbs_denorm den
2638: , pji_pjp_wbs_header hd1 -- SUP
2639: , pji_pjp_wbs_header hd2 -- SUB
2640: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
2641: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
2642: WHERE
2643: den.struct_version_id IS NULL
2644: AND hd2.plan_version_id = l_fp_version_ids(l_count)

Line 2641: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2

2637: FROM pji_xbs_denorm den
2638: , pji_pjp_wbs_header hd1 -- SUP
2639: , pji_pjp_wbs_header hd2 -- SUB
2640: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
2641: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
2642: WHERE
2643: den.struct_version_id IS NULL
2644: AND hd2.plan_version_id = l_fp_version_ids(l_count)
2645: AND hd2.project_id = l_project_ids(l_count)

Line 3493: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,

3489: prg.SUP_ID
3490: from
3491: PA_PJI_PROJ_EVENTS_LOG log,
3492: PJI_PJP_WBS_HEADER sub_wbs_hdr,
3493: PA_PROJ_ELEM_VER_STRUCTURE ppevs2,
3494: PJI_XBS_DENORM prg
3495: where
3496: prg.STRUCT_VERSION_ID is null and
3497: sub_wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and

Line 3521: PA_PROJ_ELEM_VER_STRUCTURE ppevs1

3517: (
3518: select
3519: 1
3520: from
3521: PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3522: where
3523: ppevs1.PROJECT_ID = sup_wbs_hdr.PROJECT_ID and
3524: ppevs1.ELEMENT_VERSION_ID = sup_wbs_hdr.WBS_VERSION_ID and
3525: ppevs1.STATUS_CODE = 'STRUCTURE_WORKING'

Line 3617: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1

3613: , PA_PROJ_WORKPLAN_ATTR ppwa1
3614: , PA_PROJ_ELEMENTS ppe1
3615: , PA_PROJ_STRUCTURE_TYPES ppst1
3616: , PA_STRUCTURE_TYPES pst1
3617: , PA_PROJ_ELEM_VER_STRUCTURE ppevs1
3618: , PA_PROJ_WORKPLAN_ATTR ppwa2
3619: , PA_PROJ_ELEMENTS ppe2
3620: , PA_PROJ_STRUCTURE_TYPES ppst2
3621: , PA_STRUCTURE_TYPES pst2

Line 3622: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2

3618: , PA_PROJ_WORKPLAN_ATTR ppwa2
3619: , PA_PROJ_ELEMENTS ppe2
3620: , PA_PROJ_STRUCTURE_TYPES ppst2
3621: , PA_STRUCTURE_TYPES pst2
3622: , PA_PROJ_ELEM_VER_STRUCTURE ppevs2
3623: , PA_PJI_PROJ_EVENTS_LOG elog
3624: WHERE
3625: den.struct_version_id IS NULL
3626: AND hd2.wbs_version_id = den.sub_id -- struct_version_id

Line 4313: /*UPDATE pa_proj_elem_ver_structure

4309:
4310: EXCEPTION
4311: WHEN OTHERS THEN
4312:
4313: /*UPDATE pa_proj_elem_ver_structure
4314: SET PROCESS_CODE = 'WUE',
4315: CONC_REQUEST_ID = l_request_id
4316: WHERE ELEMENT_VERSION_ID = l_struct_version_id
4317: AND PROJECT_ID = l_project_id;

Line 4844: UPDATE pa_proj_elem_ver_structure

4840: IF g_debug_mode='Y' THEN
4841: Pji_Utils.write2log( 'PROCESS_PROJ_SUM_CHANGES :call to WBS_LOCK_PVT: l_lock_mode '||l_lock_mode ,null,3);
4842: end if;
4843: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4844: UPDATE pa_proj_elem_ver_structure
4845: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
4846: , 'CONC_PUBLISH', 'PUE'
4847: , 'CONC_UPDATE', 'WUE', null),
4848: process_update_wbs_flag = 'Y', /* 5138049 */

Line 4876: UPDATE pa_proj_elem_ver_structure

4872: IF l_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
4873:
4874: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
4875: rollback to process_proj_sum_conc;
4876: UPDATE pa_proj_elem_ver_structure
4877: SET PROCESS_CODE =decode(l_calling_context, 'APPLY_PROGRESS', 'APE'
4878: , 'CONC_PUBLISH', 'PUE'
4879: , 'CONC_UPDATE', 'WUE', null),
4880: process_update_wbs_flag = 'Y', /* 5138049 */

Line 4898: UPDATE pa_proj_elem_ver_structure

4894: retcode := 2;
4895: errbuf := SQLERRM;
4896: ELSE
4897: IF Fnd_Global.CONC_REQUEST_ID IS NOT NULL THEN
4898: UPDATE pa_proj_elem_ver_structure
4899: SET PROCESS_CODE = NULL,
4900: process_update_wbs_flag='N',
4901: CONC_REQUEST_ID = Fnd_Global.CONC_REQUEST_ID
4902: WHERE ELEMENT_VERSION_ID = l_struct_version_id