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 PJI_PJP_WBS_HEADER

Line 1157: FROM pji_pjp_wbs_header

1153: IF (p_plan_wbs_ver_id IS NOT NULL) THEN
1154: BEGIN
1155: SELECT plan_version_id
1156: INTO l_plan_version_id
1157: FROM pji_pjp_wbs_header
1158: WHERE wbs_version_id = p_plan_wbs_ver_id
1159: AND wp_flag = 'Y'; -- AND plan_version_id > 0;
1160: EXCEPTION
1161: WHEN OTHERS THEN

Line 1175: FROM pji_pjp_wbs_header

1171: IF (p_prev_pub_wbs_ver_id IS NOT NULL) THEN
1172: BEGIN
1173: SELECT plan_version_id
1174: INTO l_prev_pub_version_id
1175: FROM pji_pjp_wbs_header
1176: WHERE wbs_version_id = p_prev_pub_wbs_ver_id
1177: AND wp_flag = 'Y'; -- AND plan_version_id > 0;
1178: EXCEPTION
1179: WHEN OTHERS THEN

Line 1768: FROM PJI_PJP_WBS_HEADER wbs_hdr

1764: -------------------------------------------------------------------------
1765: BEGIN
1766: SELECT plan_version_id
1767: INTO l_curr_bl_ver_id
1768: FROM PJI_PJP_WBS_HEADER wbs_hdr
1769: WHERE 1 = 1
1770: AND project_id = l_project_id
1771: AND plan_type_id = l_plan_type_id
1772: AND plan_type_code = l_plan_type_code

Line 1965: UPDATE pji_pjp_wbs_header

1961: ----------------------------------------------------------------------------------------
1962: -- Update the WBS header table with the correct baselined version.
1963: ----------------------------------------------------------------------------------------
1964:
1965: UPDATE pji_pjp_wbs_header
1966: SET cb_flag = DECODE( plan_version_id
1967: , l_old_baseline_version_id, 'N'
1968: , l_new_version_id, 'Y'
1969: , -3, 'Y' )

Line 2073: FROM pji_pjp_wbs_header

2069:
2070: BEGIN
2071: SELECT wp_flag
2072: INTO l_wp_flag
2073: FROM pji_pjp_wbs_header
2074: WHERE plan_version_id = p_original_version_id;
2075: EXCEPTION
2076: WHEN OTHERS THEN
2077: NULL;

Line 2108: FROM PJI_PJP_WBS_HEADER wbs_hdr

2104: --
2105: BEGIN
2106: SELECT plan_version_id
2107: INTO l_curr_or_ver_id
2108: FROM PJI_PJP_WBS_HEADER wbs_hdr
2109: WHERE 1 = 1
2110: AND project_id = l_project_id
2111: AND plan_type_id = l_plan_type_id
2112: AND co_flag = 'Y'

Line 2246: UPDATE pji_pjp_wbs_header

2242: -----------------------------------------------------------------------------------
2243: -- Update header table.
2244: -----------------------------------------------------------------------------------
2245:
2246: UPDATE pji_pjp_wbs_header
2247: SET co_flag = DECODE(plan_version_id
2248: , l_old_orig_ver_id, 'N'
2249: , l_new_orig_ver_id, 'Y'
2250: , -4, 'Y')

Line 2718: FROM pji_pjp_wbs_header

2714:
2715: -- Generic lock for any 1 given plan version.
2716: CURSOR c_wh_generic_lock_cur (p_plan_version_id IN NUMBER) IS
2717: SELECT project_id
2718: FROM pji_pjp_wbs_header
2719: WHERE plan_version_id = p_plan_version_id
2720: AND lock_flag IS NULL
2721: FOR UPDATE NOWAIT;
2722:

Line 2730: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */

2726: --
2727: cursor c_wh_lock_update_cur (p_plan_version_id IN NUMBER,
2728: p_project_id IN NUMBER) IS
2729: select /*+ use_nl(sup_wbs_hdr)
2730: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
2731: sup_wbs_hdr.PLAN_VERSION_ID pvi
2732: from
2733: PJI_PJP_WBS_HEADER sup_wbs_hdr
2734: where

Line 2733: PJI_PJP_WBS_HEADER sup_wbs_hdr

2729: select /*+ use_nl(sup_wbs_hdr)
2730: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
2731: sup_wbs_hdr.PLAN_VERSION_ID pvi
2732: from
2733: PJI_PJP_WBS_HEADER sup_wbs_hdr
2734: where
2735: (sup_wbs_hdr.PROJECT_ID,
2736: sup_wbs_hdr.WBS_VERSION_ID) in
2737: (

Line 2743: PJI_PJP_WBS_HEADER sub_wbs_hdr,

2739: index(prg PJI_XBS_DENORM_N1) */
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

Line 2779: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */

2775: -- Locks all -3/-4s above striped by plan type id.
2776: --
2777: cursor c_wh_base_orig_lock_cur (p_plan_version_id in number) is
2778: select /*+ use_nl(sup_wbs_hdr)
2779: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
2780: sup_wbs_hdr.PROJECT_ID,
2781: sup_wbs_hdr.PLAN_VERSION_ID,
2782: sup_wbs_hdr.PLAN_TYPE_ID
2783: from

Line 2784: PJI_PJP_WBS_HEADER sup_wbs_hdr

2780: sup_wbs_hdr.PROJECT_ID,
2781: sup_wbs_hdr.PLAN_VERSION_ID,
2782: sup_wbs_hdr.PLAN_TYPE_ID
2783: from
2784: PJI_PJP_WBS_HEADER sup_wbs_hdr
2785: where
2786: (sup_wbs_hdr.PROJECT_ID,
2787: sup_wbs_hdr.WBS_VERSION_ID,
2788: sup_wbs_hdr.PLAN_VERSION_ID,

Line 2801: PJI_PJP_WBS_HEADER sub_wbs_hdr,

2797: ver.FIN_PLAN_TYPE_ID,
2798: sub_wbs_hdr.PLAN_TYPE_CODE
2799: from
2800: PA_BUDGET_VERSIONS ver,
2801: PJI_PJP_WBS_HEADER sub_wbs_hdr,
2802: PJI_XBS_DENORM prg
2803: where
2804: ver.BUDGET_VERSION_ID = p_plan_version_id and
2805: ver.PROJECT_ID = sub_wbs_hdr.PROJECT_ID and

Line 2849: SELECT /+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) / l_count+1

2845: l_count := 0;
2846:
2847: FOR i IN 1..p_fp_version_ids.COUNT LOOP
2848: BEGIN
2849: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ l_count+1
2850: INTO l_count
2851: FROM pji_pjp_wbs_header wbs_hdr
2852: WHERE plan_version_id = p_fp_version_ids(i);
2853: EXCEPTION

Line 2851: FROM pji_pjp_wbs_header wbs_hdr

2847: FOR i IN 1..p_fp_version_ids.COUNT LOOP
2848: BEGIN
2849: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ l_count+1
2850: INTO l_count
2851: FROM pji_pjp_wbs_header wbs_hdr
2852: WHERE plan_version_id = p_fp_version_ids(i);
2853: EXCEPTION
2854: WHEN OTHERS THEN
2855: NULL;

Line 2878: FROM pji_pjp_wbs_header

2874: FOR i IN 1..p_fp_version_ids.COUNT LOOP
2875: BEGIN
2876: SELECT l_count+1
2877: INTO l_count
2878: FROM pji_pjp_wbs_header
2879: WHERE plan_version_id = p_fp_version_ids(i)
2880: AND lock_flag IS NULL;
2881: EXCEPTION
2882: WHEN OTHERS THEN

Line 2940: , pji_pjp_wbs_header wh

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
2944: AND ppe.proj_element_id = ppwa.proj_element_id

Line 3014: , pji_pjp_wbs_header hd1 -- SUP

3010: -- Are any of the relevant WPs locked? Refer Program Reporting Tech Arch for biz rules.
3011: SELECT COUNT(1)
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

Line 3015: , pji_pjp_wbs_header hd2 -- SUB

3011: SELECT COUNT(1)
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

Line 3068: FROM pji_pjp_wbs_header

3064: ) THEN
3065:
3066: SELECT COUNT(1)
3067: INTO l_num_locked
3068: FROM pji_pjp_wbs_header
3069: WHERE plan_version_id = l_fp_version_ids(l_count)
3070: AND lock_flag IS NOT NULL;
3071:
3072: IF (l_num_locked = 0) THEN -- 5

Line 3098: FROM pji_pjp_wbs_header

3094: -- Only working FPs/WPs can be deleted.
3095:
3096: SELECT COUNT(1)
3097: INTO l_num_locked
3098: FROM pji_pjp_wbs_header
3099: WHERE plan_version_id = l_fp_version_ids(l_count)
3100: AND lock_flag IS NOT NULL;
3101:
3102: IF (l_num_locked = 0) THEN -- 3

Line 3124: FROM pji_pjp_wbs_header

3120: -- Only working FPs/WPs can be deleted.
3121:
3122: SELECT COUNT(1)
3123: INTO l_num_locked
3124: FROM pji_pjp_wbs_header
3125: WHERE plan_version_id = l_fp_version_ids(l_count)
3126: AND lock_flag IS NOT NULL;
3127:
3128: IF (l_num_locked = 0) THEN -- 3

Line 3239: , pji_pjp_wbs_header hd1 -- SUB

3235:
3236: SELECT COUNT(1)
3237: INTO l_count1
3238: FROM pji_xbs_denorm den
3239: , pji_pjp_wbs_header hd1 -- SUB
3240: , pji_pjp_wbs_header hd2 -- SUP
3241: , pa_budget_versions hd3 -- to get plan type id
3242: WHERE
3243: den.struct_version_id IS NULL

Line 3240: , pji_pjp_wbs_header hd2 -- SUP

3236: SELECT COUNT(1)
3237: INTO l_count1
3238: FROM pji_xbs_denorm den
3239: , pji_pjp_wbs_header hd1 -- SUB
3240: , pji_pjp_wbs_header hd2 -- SUP
3241: , pa_budget_versions hd3 -- to get plan type id
3242: WHERE
3243: den.struct_version_id IS NULL
3244: AND den.struct_type = 'PRG'

Line 3766: , pji_pjp_wbs_header wh

3762: , rl.CUSTOM15
3763: , rl.PLAN_TYPE_CODE /*4471527 */
3764: FROM
3765: pji_fp_xbs_accum_f rl
3766: , pji_pjp_wbs_header wh
3767: WHERE rl.project_id = wh.project_id
3768: AND rl.project_id = p_project_id
3769: AND rl.plan_type_id = p_plan_type_id
3770: AND wh.plan_version_id = rl.plan_version_id

Line 3816: pji_pjp_wbs_header head,

3812: CURSOR c_plan_versions_online ( l_event_id NUMBER) IS
3813: SELECT
3814: head.PLAN_VERSION_ID
3815: FROM
3816: pji_pjp_wbs_header head,
3817: PA_PJI_PROJ_EVENTS_LOG elog
3818: WHERE
3819: elog.EVENT_ID = l_event_id AND
3820: head.PROJECT_ID = TO_NUMBER(elog.ATTRIBUTE1) AND

Line 3836: pji_pjp_wbs_header head,

3832: CURSOR c_wh_lock_online_str_chng_cur ( l_event_id NUMBER) IS
3833: SELECT
3834: head.PLAN_VERSION_ID
3835: FROM
3836: pji_pjp_wbs_header head,
3837: PA_PJI_PROJ_EVENTS_LOG elog
3838: WHERE
3839: elog.EVENT_ID = l_event_id AND
3840: head.PROJECT_ID = TO_NUMBER(elog.ATTRIBUTE1) AND

Line 3854: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */

3850: -- Handles online locking of
3851: -- a. Published ver and one working ver above for publish.
3852: cursor c_online_pub_wp_cur (l_event_id number) IS
3853: select /*+ use_nl(sup_wbs_hdr)
3854: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
3855: sup_wbs_hdr.PLAN_VERSION_ID
3856: from
3857: PJI_PJP_WBS_HEADER sup_wbs_hdr
3858: where

Line 3857: PJI_PJP_WBS_HEADER sup_wbs_hdr

3853: select /*+ use_nl(sup_wbs_hdr)
3854: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
3855: sup_wbs_hdr.PLAN_VERSION_ID
3856: from
3857: PJI_PJP_WBS_HEADER sup_wbs_hdr
3858: where
3859: (sup_wbs_hdr.PROJECT_ID,
3860: sup_wbs_hdr.WBS_VERSION_ID) in
3861: (

Line 3868: PJI_PJP_WBS_HEADER sub_wbs_hdr,

3864: prg.SUP_PROJECT_ID,
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

Line 3908: select /+ use_nl(sup_wbs_hdr) index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) /

3904:
3905: -- Handles online locking of
3906: -- a. All cb/co for publish.
3907: cursor c_online_pub_cbco_lock_cur (l_event_id number) is
3908: select /*+ use_nl(sup_wbs_hdr) index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
3909: sup_wbs_hdr.PROJECT_ID,
3910: sup_wbs_hdr.PLAN_VERSION_ID,
3911: sup_wbs_hdr.PLAN_TYPE_ID
3912: from

Line 3913: PJI_PJP_WBS_HEADER sup_wbs_hdr

3909: sup_wbs_hdr.PROJECT_ID,
3910: sup_wbs_hdr.PLAN_VERSION_ID,
3911: sup_wbs_hdr.PLAN_TYPE_ID
3912: from
3913: PJI_PJP_WBS_HEADER sup_wbs_hdr
3914: where
3915: (sup_wbs_hdr.PROJECT_ID,
3916: sup_wbs_hdr.WBS_VERSION_ID,
3917: sup_wbs_hdr.PLAN_VERSION_ID,

Line 3930: PJI_PJP_WBS_HEADER wbs_hdr,

3926: sub_wbs_hdr.PLAN_TYPE_ID,
3927: sub_wbs_hdr.PLAN_TYPE_CODE
3928: from
3929: PA_PJI_PROJ_EVENTS_LOG log,
3930: PJI_PJP_WBS_HEADER wbs_hdr,
3931: PJI_PJP_WBS_HEADER sub_wbs_hdr,
3932: PJI_XBS_DENORM prg
3933: where
3934: prg.STRUCT_VERSION_ID is null and

Line 3931: PJI_PJP_WBS_HEADER sub_wbs_hdr,

3927: sub_wbs_hdr.PLAN_TYPE_CODE
3928: from
3929: PA_PJI_PROJ_EVENTS_LOG log,
3930: PJI_PJP_WBS_HEADER wbs_hdr,
3931: PJI_PJP_WBS_HEADER sub_wbs_hdr,
3932: PJI_XBS_DENORM prg
3933: where
3934: prg.STRUCT_VERSION_ID is null and
3935: sub_wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and

Line 3956: pji_pjp_wbs_header head,

3952: CURSOR c_plan_versions_deferred IS
3953: SELECT
3954: head.PLAN_VERSION_ID
3955: FROM
3956: pji_pjp_wbs_header head,
3957: PA_PJI_PROJ_EVENTS_LOG elog
3958: WHERE
3959: head.PROJECT_ID = TO_NUMBER(elog.ATTRIBUTE1) AND
3960: head.WBS_VERSION_ID = TO_NUMBER(elog.ATTRIBUTE2) AND

Line 3972: pji_pjp_wbs_header head,

3968: CURSOR c_wh_lock_sumz_str_chng_cur IS
3969: SELECT
3970: head.PLAN_VERSION_ID
3971: FROM
3972: pji_pjp_wbs_header head,
3973: PA_PJI_PROJ_EVENTS_LOG elog
3974: WHERE
3975: head.PROJECT_ID = TO_NUMBER(elog.ATTRIBUTE1) AND
3976: head.WBS_VERSION_ID = TO_NUMBER(elog.ATTRIBUTE2) AND

Line 3984: FROM pji_pjp_wbs_header hd1 -- SUP

3980: FOR UPDATE;
3981:
3982: CURSOR c_wh_lock_sumz_pub_cur IS
3983: SELECT hd1.plan_version_id
3984: FROM pji_pjp_wbs_header hd1 -- SUP
3985: WHERE EXISTS (
3986: SELECT 1
3987: FROM pji_xbs_denorm den
3988: , pji_pjp_wbs_header hd2 -- SUB

Line 3988: , pji_pjp_wbs_header hd2 -- SUB

3984: FROM pji_pjp_wbs_header hd1 -- SUP
3985: WHERE EXISTS (
3986: SELECT 1
3987: FROM pji_xbs_denorm den
3988: , pji_pjp_wbs_header hd2 -- SUB
3989: , PA_PROJ_WORKPLAN_ATTR ppwa1
3990: , PA_PROJ_ELEMENTS ppe1
3991: , PA_PROJ_STRUCTURE_TYPES ppst1
3992: , PA_STRUCTURE_TYPES pst1

Line 4101: --Need to update PJI_PJP_WBS_HEADER to set LOCK flag = Y

4097:
4098: OPEN c_plan_versions_deferred;
4099: CLOSE c_plan_versions_deferred;
4100:
4101: --Need to update PJI_PJP_WBS_HEADER to set LOCK flag = Y
4102: ------------------------------------
4103: --Below locking is not required
4104: -----------------------------------
4105: /* UPDATE pji_pjp_wbs_header head

Line 4105: /* UPDATE pji_pjp_wbs_header head

4101: --Need to update PJI_PJP_WBS_HEADER to set LOCK flag = Y
4102: ------------------------------------
4103: --Below locking is not required
4104: -----------------------------------
4105: /* UPDATE pji_pjp_wbs_header head
4106: SET LOCK_FLAG = 'P'
4107: WHERE
4108: head.PLAN_VERSION_ID IN (SELECT
4109: TO_NUMBER(elog.ATTRIBUTE3)

Line 4166: FROM pji_pjp_wbs_header

4162: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
4163: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
4164: CURSOR c_pln_ver_list (p_old_struct_ver_id IN NUMBER) IS
4165: SELECT project_id, plan_version_id
4166: FROM pji_pjp_wbs_header
4167: WHERE 1 = 1
4168: AND wbs_version_id = p_old_struct_ver_id
4169: AND plan_version_id > 0;
4170:

Line 4210: pji_pjp_wbs_header

4206: PLAN_VERSION_ID
4207: into
4208: l_plan_version_id
4209: from
4210: pji_pjp_wbs_header
4211: where
4212: PROJECT_ID = l_project_id AND
4213: WBS_VERSION_ID = l_new_wbs_version_id AND
4214: WP_FLAG = 'Y';

Line 4271: UPDATE pji_pjp_wbs_header SET

4267: l_struct_sharing_code := Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);
4268: IF l_old_wbs_version_id IS NULL THEN
4269: -- Fix for bug : 4191390
4270: If l_struct_sharing_code LIKE '%SHARE%' then
4271: UPDATE pji_pjp_wbs_header SET
4272: wbs_version_id = l_new_wbs_version_id
4273: WHERE
4274: wp_flag = 'N' AND
4275: project_id = l_project_id;

Line 4279: UPDATE pji_pjp_wbs_header SET

4275: project_id = l_project_id;
4276:
4277: elsif l_struct_sharing_code LIKE '%SPLIT%' THEN
4278:
4279: UPDATE pji_pjp_wbs_header SET
4280: wbs_version_id = l_new_wbs_version_id
4281: WHERE
4282: wp_flag = 'N' AND
4283: p_struct_type = 'FINANCIAL' AND

Line 4470: UPDATE pji_pjp_wbs_header SET

4466:
4467: IF p_publish_flag = 'Y' THEN
4468: -- Fix for bug : 4191390
4469: If l_struct_sharing_code LIKE '%SHARE%' then
4470: UPDATE pji_pjp_wbs_header SET
4471: wbs_version_id = l_new_wbs_version_id
4472: WHERE
4473: wp_flag = 'N' AND
4474: project_id = l_project_id;

Line 4476: UPDATE pji_pjp_wbs_header SET

4472: WHERE
4473: wp_flag = 'N' AND
4474: project_id = l_project_id;
4475: elsif l_struct_sharing_code LIKE '%SPLIT%' THEN
4476: UPDATE pji_pjp_wbs_header SET
4477: wbs_version_id = l_new_wbs_version_id
4478: WHERE
4479: wp_flag = 'N' AND
4480: p_struct_type = 'FINANCIAL' AND

Line 4827: pji_pjp_wbs_header head

4823: p_project_id,
4824: p_old_struct_ver_id,
4825: head.PLAN_VERSION_ID
4826: FROM
4827: pji_pjp_wbs_header head
4828: WHERE
4829: head.PROJECT_ID = p_project_id AND
4830: head.WBS_VERSION_ID = p_old_struct_ver_id;
4831:

Line 4945: pji_pjp_wbs_header head

4941: p_project_id,
4942: p_old_struct_ver_id,
4943: head.PLAN_VERSION_ID
4944: FROM
4945: pji_pjp_wbs_header head
4946: WHERE
4947: head.PROJECT_ID = p_project_id AND
4948: head.WBS_VERSION_ID = p_old_struct_ver_id AND
4949: head.WP_FLAG = 'Y';

Line 5046: pji_pjp_wbs_header head

5042: p_project_id,
5043: p_old_struct_ver_id,
5044: head.PLAN_VERSION_ID
5045: FROM
5046: pji_pjp_wbs_header head
5047: WHERE
5048: head.PROJECT_ID = p_project_id AND
5049: head.WBS_VERSION_ID = p_old_struct_ver_id AND
5050: head.WP_FLAG = 'N';

Line 5568: pji_pjp_wbs_header head

5564: evt.EVENT_ID,
5565: evt.EVENT_TYPE
5566: FROM
5567: pa_pji_proj_events_log evt,
5568: pji_pjp_wbs_header head
5569: WHERE
5570: evt.EVENT_TYPE IN ( 'WBS_CHANGE',
5571: 'WBS_PUBLISH') AND
5572: evt.EVENT_OBJECT = to_char(head.WBS_VERSION_ID) AND

Line 5613: pji_pjp_wbs_header headr

5609:
5610: SELECT COUNT(*)
5611: INTO l_child_task_check
5612: FROM pa_xbs_denorm denom,
5613: pji_pjp_wbs_header headr
5614: WHERE denom.sup_project_id = p_project_id
5615: AND headr.project_id = denom.sup_project_id
5616: AND headr.plan_version_id = l_plan_version_id
5617: AND headr.wbs_version_id = denom.struct_version_id

Line 5638: FROM pji_pjp_wbs_header

5634: BEGIN
5635: l_wbs_version_id:=NULL;
5636:
5637: SELECT DISTINCT wbs_version_id INTO l_wbs_version_id -- Added distinct for bug # 14757202
5638: FROM pji_pjp_wbs_header
5639: WHERE plan_version_id = l_plan_version_id
5640: AND project_id = p_project_id;
5641: EXCEPTION
5642: WHEN NO_DATA_FOUND THEN

Line 5995: from pji_pjp_wbs_header head

5991: FOR i IN 1..p_plan_version_id_tbl.COUNT LOOP
5992: BEGIN
5993: select distinct head.wbs_version_id,head.plan_version_id,head.plan_type_code BULK COLLECT
5994: into jl_get_wbs_version_id_tbl,jl_get_plan_version_id_tbl,jl_get_plan_type_code_tbl /*4471527 */
5995: from pji_pjp_wbs_header head
5996: where head.plan_version_id = p_plan_version_id_tbl(i)
5997: and head.project_id in (select project_id from pji_pjp_wbs_header head1
5998: where head1.wbs_version_id=p_wbs_version_id );
5999: FOR j IN 1..jl_get_plan_version_id_tbl.COUNT LOOP

Line 5997: and head.project_id in (select project_id from pji_pjp_wbs_header head1

5993: select distinct head.wbs_version_id,head.plan_version_id,head.plan_type_code BULK COLLECT
5994: into jl_get_wbs_version_id_tbl,jl_get_plan_version_id_tbl,jl_get_plan_type_code_tbl /*4471527 */
5995: from pji_pjp_wbs_header head
5996: where head.plan_version_id = p_plan_version_id_tbl(i)
5997: and head.project_id in (select project_id from pji_pjp_wbs_header head1
5998: where head1.wbs_version_id=p_wbs_version_id );
5999: FOR j IN 1..jl_get_plan_version_id_tbl.COUNT LOOP
6000: l_get_plan_version_id_tbl.EXTEND;
6001: l_get_plan_version_id_tbl(validcount) := jl_get_plan_version_id_tbl(j);

Line 6039: ,pji_pjp_wbs_header head

6035: SELECT distinct head.plan_version_id,head.project_id ,pji.sub_id wbs_version_id,head.plan_type_code BULK COLLECT
6036: into il_plan_version_id_tbl, il_project_id_tbl,il_wbs_version_id_tbl,il_plan_type_code_tbl /*4471527 */
6037: FROM pji_xbs_Denorm pji
6038: ,pa_proj_element_versions pa
6039: ,pji_pjp_wbs_header head
6040: WHERE pji.struct_type='PRG'
6041: and pji.sup_level<>pji.sub_level
6042: and pji.sup_id in (l_get_wbs_version_id_tbl(1),l_get_wbs_version_id_tbl(2),l_get_wbs_version_id_tbl(3)
6043: ,l_get_wbs_version_id_tbl(4),l_get_wbs_version_id_tbl(5),l_get_wbs_version_id_tbl(6)

Line 6382: pji_pjp_wbs_header head

6378: fact.CUSTOM15,
6379: fact.PLAN_TYPE_CODE /*4471527 */
6380: FROM
6381: pji_fp_xbs_accum_f fact,
6382: pji_pjp_wbs_header head
6383: WHERE
6384: fact.RBS_AGGR_LEVEL = 'L' AND
6385: fact.WBS_ROLLUP_FLAG = 'N' AND
6386: fact.PRG_ROLLUP_FLAG in ('Y', 'N') AND

Line 6560: pji_pjp_wbs_header head,

6556: SUM(fact.CUSTOM15),
6557: fact.PLAN_TYPE_CODE /*4471527 */
6558: FROM
6559: pji_fp_aggr_pjp1_t fact,
6560: pji_pjp_wbs_header head,
6561: pji_xbs_denorm xbs
6562: WHERE
6563: xbs.STRUCT_VERSION_ID = head.WBS_VERSION_ID AND
6564: xbs.STRUCT_TYPE = 'WBS' AND

Line 6754: pji_pjp_wbs_header head,

6750: SUM(fact.CUSTOM15),
6751: fact.PLAN_TYPE_CODE /*4471527 */
6752: FROM
6753: pji_fp_aggr_pjp1_t fact,
6754: pji_pjp_wbs_header head,
6755: pji_xbs_denorm xbs
6756:
6757: WHERE
6758: xbs.STRUCT_VERSION_ID = head.WBS_VERSION_ID AND

Line 7063: SELECT /+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) / PROJECT_ID

7059: END;
7060:
7061: BEGIN
7062:
7063: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ PROJECT_ID
7064: INTO l_project_id
7065: FROM pji_pjp_wbs_header wbs_hdr
7066: WHERE plan_version_id = p_fp_version_ids(i);
7067:

Line 7065: FROM pji_pjp_wbs_header wbs_hdr

7061: BEGIN
7062:
7063: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ PROJECT_ID
7064: INTO l_project_id
7065: FROM pji_pjp_wbs_header wbs_hdr
7066: WHERE plan_version_id = p_fp_version_ids(i);
7067:
7068: print_time ( ' plan version id # ' || i || ' is ' || p_fp_version_ids(i) || ' exists in budget versions.');
7069: