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 879: FROM pji_pjp_wbs_header

875: IF (p_plan_wbs_ver_id IS NOT NULL) THEN
876: BEGIN
877: SELECT plan_version_id
878: INTO l_plan_version_id
879: FROM pji_pjp_wbs_header
880: WHERE wbs_version_id = p_plan_wbs_ver_id
881: AND wp_flag = 'Y'; -- AND plan_version_id > 0;
882: EXCEPTION
883: WHEN OTHERS THEN

Line 897: FROM pji_pjp_wbs_header

893: IF (p_prev_pub_wbs_ver_id IS NOT NULL) THEN
894: BEGIN
895: SELECT plan_version_id
896: INTO l_prev_pub_version_id
897: FROM pji_pjp_wbs_header
898: WHERE wbs_version_id = p_prev_pub_wbs_ver_id
899: AND wp_flag = 'Y'; -- AND plan_version_id > 0;
900: EXCEPTION
901: WHEN OTHERS THEN

Line 1427: FROM PJI_PJP_WBS_HEADER wbs_hdr

1423: -------------------------------------------------------------------------
1424: BEGIN
1425: SELECT plan_version_id
1426: INTO l_curr_bl_ver_id
1427: FROM PJI_PJP_WBS_HEADER wbs_hdr
1428: WHERE 1 = 1
1429: AND project_id = l_project_id
1430: AND plan_type_id = l_plan_type_id
1431: AND plan_type_code = l_plan_type_code

Line 1589: UPDATE pji_pjp_wbs_header

1585: ----------------------------------------------------------------------------------------
1586: -- Update the WBS header table with the correct baselined version.
1587: ----------------------------------------------------------------------------------------
1588:
1589: UPDATE pji_pjp_wbs_header
1590: SET cb_flag = DECODE( plan_version_id
1591: , l_old_baseline_version_id, 'N'
1592: , l_new_version_id, 'Y'
1593: , -3, 'Y' )

Line 1697: FROM pji_pjp_wbs_header

1693:
1694: BEGIN
1695: SELECT wp_flag
1696: INTO l_wp_flag
1697: FROM pji_pjp_wbs_header
1698: WHERE plan_version_id = p_original_version_id;
1699: EXCEPTION
1700: WHEN OTHERS THEN
1701: NULL;

Line 1732: FROM PJI_PJP_WBS_HEADER wbs_hdr

1728: --
1729: BEGIN
1730: SELECT plan_version_id
1731: INTO l_curr_or_ver_id
1732: FROM PJI_PJP_WBS_HEADER wbs_hdr
1733: WHERE 1 = 1
1734: AND project_id = l_project_id
1735: AND plan_type_id = l_plan_type_id
1736: AND co_flag = 'Y'

Line 1870: UPDATE pji_pjp_wbs_header

1866: -----------------------------------------------------------------------------------
1867: -- Update header table.
1868: -----------------------------------------------------------------------------------
1869:
1870: UPDATE pji_pjp_wbs_header
1871: SET co_flag = DECODE(plan_version_id
1872: , l_old_orig_ver_id, 'N'
1873: , l_new_orig_ver_id, 'Y'
1874: , -4, 'Y')

Line 2342: FROM pji_pjp_wbs_header

2338:
2339: -- Generic lock for any 1 given plan version.
2340: CURSOR c_wh_generic_lock_cur (p_plan_version_id IN NUMBER) IS
2341: SELECT project_id
2342: FROM pji_pjp_wbs_header
2343: WHERE plan_version_id = p_plan_version_id
2344: AND lock_flag IS NULL
2345: FOR UPDATE NOWAIT;
2346:

Line 2354: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */

2350: --
2351: cursor c_wh_lock_update_cur (p_plan_version_id IN NUMBER,
2352: p_project_id IN NUMBER) IS
2353: select /*+ use_nl(sup_wbs_hdr)
2354: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
2355: sup_wbs_hdr.PLAN_VERSION_ID pvi
2356: from
2357: PJI_PJP_WBS_HEADER sup_wbs_hdr
2358: where

Line 2357: PJI_PJP_WBS_HEADER sup_wbs_hdr

2353: select /*+ use_nl(sup_wbs_hdr)
2354: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
2355: sup_wbs_hdr.PLAN_VERSION_ID pvi
2356: from
2357: PJI_PJP_WBS_HEADER sup_wbs_hdr
2358: where
2359: (sup_wbs_hdr.PROJECT_ID,
2360: sup_wbs_hdr.WBS_VERSION_ID) in
2361: (

Line 2367: PJI_PJP_WBS_HEADER sub_wbs_hdr,

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

Line 2403: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */

2399: -- Locks all -3/-4s above striped by plan type id.
2400: --
2401: cursor c_wh_base_orig_lock_cur (p_plan_version_id in number) is
2402: select /*+ use_nl(sup_wbs_hdr)
2403: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
2404: sup_wbs_hdr.PROJECT_ID,
2405: sup_wbs_hdr.PLAN_VERSION_ID,
2406: sup_wbs_hdr.PLAN_TYPE_ID
2407: from

Line 2408: PJI_PJP_WBS_HEADER sup_wbs_hdr

2404: sup_wbs_hdr.PROJECT_ID,
2405: sup_wbs_hdr.PLAN_VERSION_ID,
2406: sup_wbs_hdr.PLAN_TYPE_ID
2407: from
2408: PJI_PJP_WBS_HEADER sup_wbs_hdr
2409: where
2410: (sup_wbs_hdr.PROJECT_ID,
2411: sup_wbs_hdr.WBS_VERSION_ID,
2412: sup_wbs_hdr.PLAN_VERSION_ID,

Line 2425: PJI_PJP_WBS_HEADER sub_wbs_hdr,

2421: ver.FIN_PLAN_TYPE_ID,
2422: sub_wbs_hdr.PLAN_TYPE_CODE
2423: from
2424: PA_BUDGET_VERSIONS ver,
2425: PJI_PJP_WBS_HEADER sub_wbs_hdr,
2426: PJI_XBS_DENORM prg
2427: where
2428: ver.BUDGET_VERSION_ID = p_plan_version_id and
2429: ver.PROJECT_ID = sub_wbs_hdr.PROJECT_ID and

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

2469: l_count := 0;
2470:
2471: FOR i IN 1..p_fp_version_ids.COUNT LOOP
2472: BEGIN
2473: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ l_count+1
2474: INTO l_count
2475: FROM pji_pjp_wbs_header wbs_hdr
2476: WHERE plan_version_id = p_fp_version_ids(i);
2477: EXCEPTION

Line 2475: FROM pji_pjp_wbs_header wbs_hdr

2471: FOR i IN 1..p_fp_version_ids.COUNT LOOP
2472: BEGIN
2473: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ l_count+1
2474: INTO l_count
2475: FROM pji_pjp_wbs_header wbs_hdr
2476: WHERE plan_version_id = p_fp_version_ids(i);
2477: EXCEPTION
2478: WHEN OTHERS THEN
2479: NULL;

Line 2502: FROM pji_pjp_wbs_header

2498: FOR i IN 1..p_fp_version_ids.COUNT LOOP
2499: BEGIN
2500: SELECT l_count+1
2501: INTO l_count
2502: FROM pji_pjp_wbs_header
2503: WHERE plan_version_id = p_fp_version_ids(i)
2504: AND lock_flag IS NULL;
2505: EXCEPTION
2506: WHEN OTHERS THEN

Line 2564: , pji_pjp_wbs_header wh

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

Line 2638: , pji_pjp_wbs_header hd1 -- SUP

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

Line 2639: , pji_pjp_wbs_header hd2 -- SUB

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

Line 2692: FROM pji_pjp_wbs_header

2688: ) THEN
2689:
2690: SELECT COUNT(1)
2691: INTO l_num_locked
2692: FROM pji_pjp_wbs_header
2693: WHERE plan_version_id = l_fp_version_ids(l_count)
2694: AND lock_flag IS NOT NULL;
2695:
2696: IF (l_num_locked = 0) THEN -- 5

Line 2722: FROM pji_pjp_wbs_header

2718: -- Only working FPs/WPs can be deleted.
2719:
2720: SELECT COUNT(1)
2721: INTO l_num_locked
2722: FROM pji_pjp_wbs_header
2723: WHERE plan_version_id = l_fp_version_ids(l_count)
2724: AND lock_flag IS NOT NULL;
2725:
2726: IF (l_num_locked = 0) THEN -- 3

Line 2748: FROM pji_pjp_wbs_header

2744: -- Only working FPs/WPs can be deleted.
2745:
2746: SELECT COUNT(1)
2747: INTO l_num_locked
2748: FROM pji_pjp_wbs_header
2749: WHERE plan_version_id = l_fp_version_ids(l_count)
2750: AND lock_flag IS NOT NULL;
2751:
2752: IF (l_num_locked = 0) THEN -- 3

Line 2863: , pji_pjp_wbs_header hd1 -- SUB

2859:
2860: SELECT COUNT(1)
2861: INTO l_count1
2862: FROM pji_xbs_denorm den
2863: , pji_pjp_wbs_header hd1 -- SUB
2864: , pji_pjp_wbs_header hd2 -- SUP
2865: , pa_budget_versions hd3 -- to get plan type id
2866: WHERE
2867: den.struct_version_id IS NULL

Line 2864: , pji_pjp_wbs_header hd2 -- SUP

2860: SELECT COUNT(1)
2861: INTO l_count1
2862: FROM pji_xbs_denorm den
2863: , pji_pjp_wbs_header hd1 -- SUB
2864: , pji_pjp_wbs_header hd2 -- SUP
2865: , pa_budget_versions hd3 -- to get plan type id
2866: WHERE
2867: den.struct_version_id IS NULL
2868: AND den.struct_type = 'PRG'

Line 3390: , pji_pjp_wbs_header wh

3386: , rl.CUSTOM15
3387: , rl.PLAN_TYPE_CODE /*4471527 */
3388: FROM
3389: pji_fp_xbs_accum_f rl
3390: , pji_pjp_wbs_header wh
3391: WHERE rl.project_id = wh.project_id
3392: AND rl.project_id = p_project_id
3393: AND rl.plan_type_id = p_plan_type_id
3394: AND wh.plan_version_id = rl.plan_version_id

Line 3440: pji_pjp_wbs_header head,

3436: CURSOR c_plan_versions_online ( l_event_id NUMBER) IS
3437: SELECT
3438: head.PLAN_VERSION_ID
3439: FROM
3440: pji_pjp_wbs_header head,
3441: PA_PJI_PROJ_EVENTS_LOG elog
3442: WHERE
3443: elog.EVENT_ID = l_event_id AND
3444: head.PROJECT_ID = TO_NUMBER(elog.ATTRIBUTE1) AND

Line 3460: pji_pjp_wbs_header head,

3456: CURSOR c_wh_lock_online_str_chng_cur ( l_event_id NUMBER) IS
3457: SELECT
3458: head.PLAN_VERSION_ID
3459: FROM
3460: pji_pjp_wbs_header head,
3461: PA_PJI_PROJ_EVENTS_LOG elog
3462: WHERE
3463: elog.EVENT_ID = l_event_id AND
3464: head.PROJECT_ID = TO_NUMBER(elog.ATTRIBUTE1) AND

Line 3478: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */

3474: -- Handles online locking of
3475: -- a. Published ver and one working ver above for publish.
3476: cursor c_online_pub_wp_cur (l_event_id number) IS
3477: select /*+ use_nl(sup_wbs_hdr)
3478: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
3479: sup_wbs_hdr.PLAN_VERSION_ID
3480: from
3481: PJI_PJP_WBS_HEADER sup_wbs_hdr
3482: where

Line 3481: PJI_PJP_WBS_HEADER sup_wbs_hdr

3477: select /*+ use_nl(sup_wbs_hdr)
3478: index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
3479: sup_wbs_hdr.PLAN_VERSION_ID
3480: from
3481: PJI_PJP_WBS_HEADER sup_wbs_hdr
3482: where
3483: (sup_wbs_hdr.PROJECT_ID,
3484: sup_wbs_hdr.WBS_VERSION_ID) in
3485: (

Line 3492: PJI_PJP_WBS_HEADER sub_wbs_hdr,

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

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

3528:
3529: -- Handles online locking of
3530: -- a. All cb/co for publish.
3531: cursor c_online_pub_cbco_lock_cur (l_event_id number) is
3532: select /*+ use_nl(sup_wbs_hdr) index(sup_wbs_hdr PJI_PJP_WBS_HEADER_N1) */
3533: sup_wbs_hdr.PROJECT_ID,
3534: sup_wbs_hdr.PLAN_VERSION_ID,
3535: sup_wbs_hdr.PLAN_TYPE_ID
3536: from

Line 3537: PJI_PJP_WBS_HEADER sup_wbs_hdr

3533: sup_wbs_hdr.PROJECT_ID,
3534: sup_wbs_hdr.PLAN_VERSION_ID,
3535: sup_wbs_hdr.PLAN_TYPE_ID
3536: from
3537: PJI_PJP_WBS_HEADER sup_wbs_hdr
3538: where
3539: (sup_wbs_hdr.PROJECT_ID,
3540: sup_wbs_hdr.WBS_VERSION_ID,
3541: sup_wbs_hdr.PLAN_VERSION_ID,

Line 3554: PJI_PJP_WBS_HEADER wbs_hdr,

3550: sub_wbs_hdr.PLAN_TYPE_ID,
3551: sub_wbs_hdr.PLAN_TYPE_CODE
3552: from
3553: PA_PJI_PROJ_EVENTS_LOG log,
3554: PJI_PJP_WBS_HEADER wbs_hdr,
3555: PJI_PJP_WBS_HEADER sub_wbs_hdr,
3556: PJI_XBS_DENORM prg
3557: where
3558: prg.STRUCT_VERSION_ID is null and

Line 3555: PJI_PJP_WBS_HEADER sub_wbs_hdr,

3551: sub_wbs_hdr.PLAN_TYPE_CODE
3552: from
3553: PA_PJI_PROJ_EVENTS_LOG log,
3554: PJI_PJP_WBS_HEADER wbs_hdr,
3555: PJI_PJP_WBS_HEADER sub_wbs_hdr,
3556: PJI_XBS_DENORM prg
3557: where
3558: prg.STRUCT_VERSION_ID is null and
3559: sub_wbs_hdr.WBS_VERSION_ID = prg.SUB_ID and

Line 3580: pji_pjp_wbs_header head,

3576: CURSOR c_plan_versions_deferred IS
3577: SELECT
3578: head.PLAN_VERSION_ID
3579: FROM
3580: pji_pjp_wbs_header head,
3581: PA_PJI_PROJ_EVENTS_LOG elog
3582: WHERE
3583: head.PROJECT_ID = TO_NUMBER(elog.ATTRIBUTE1) AND
3584: head.WBS_VERSION_ID = TO_NUMBER(elog.ATTRIBUTE2) AND

Line 3596: pji_pjp_wbs_header head,

3592: CURSOR c_wh_lock_sumz_str_chng_cur IS
3593: SELECT
3594: head.PLAN_VERSION_ID
3595: FROM
3596: pji_pjp_wbs_header head,
3597: PA_PJI_PROJ_EVENTS_LOG elog
3598: WHERE
3599: head.PROJECT_ID = TO_NUMBER(elog.ATTRIBUTE1) AND
3600: head.WBS_VERSION_ID = TO_NUMBER(elog.ATTRIBUTE2) AND

Line 3608: FROM pji_pjp_wbs_header hd1 -- SUP

3604: FOR UPDATE;
3605:
3606: CURSOR c_wh_lock_sumz_pub_cur IS
3607: SELECT hd1.plan_version_id
3608: FROM pji_pjp_wbs_header hd1 -- SUP
3609: WHERE EXISTS (
3610: SELECT 1
3611: FROM pji_xbs_denorm den
3612: , pji_pjp_wbs_header hd2 -- SUB

Line 3612: , pji_pjp_wbs_header hd2 -- SUB

3608: FROM pji_pjp_wbs_header hd1 -- SUP
3609: WHERE EXISTS (
3610: SELECT 1
3611: FROM pji_xbs_denorm den
3612: , pji_pjp_wbs_header hd2 -- SUB
3613: , PA_PROJ_WORKPLAN_ATTR ppwa1
3614: , PA_PROJ_ELEMENTS ppe1
3615: , PA_PROJ_STRUCTURE_TYPES ppst1
3616: , PA_STRUCTURE_TYPES pst1

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

3721:
3722: OPEN c_plan_versions_deferred;
3723: CLOSE c_plan_versions_deferred;
3724:
3725: --Need to update PJI_PJP_WBS_HEADER to set LOCK flag = Y
3726: ------------------------------------
3727: --Below locking is not required
3728: -----------------------------------
3729: /* UPDATE pji_pjp_wbs_header head

Line 3729: /* UPDATE pji_pjp_wbs_header head

3725: --Need to update PJI_PJP_WBS_HEADER to set LOCK flag = Y
3726: ------------------------------------
3727: --Below locking is not required
3728: -----------------------------------
3729: /* UPDATE pji_pjp_wbs_header head
3730: SET LOCK_FLAG = 'P'
3731: WHERE
3732: head.PLAN_VERSION_ID IN (SELECT
3733: TO_NUMBER(elog.ATTRIBUTE3)

Line 3790: FROM pji_pjp_wbs_header

3786: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
3787: l_struct_sharing_code pa_projects_all.structure_sharing_code%TYPE;
3788: CURSOR c_pln_ver_list (p_old_struct_ver_id IN NUMBER) IS
3789: SELECT project_id, plan_version_id
3790: FROM pji_pjp_wbs_header
3791: WHERE 1 = 1
3792: AND wbs_version_id = p_old_struct_ver_id
3793: AND plan_version_id > 0;
3794:

Line 3834: pji_pjp_wbs_header

3830: PLAN_VERSION_ID
3831: into
3832: l_plan_version_id
3833: from
3834: pji_pjp_wbs_header
3835: where
3836: PROJECT_ID = l_project_id AND
3837: WBS_VERSION_ID = l_new_wbs_version_id AND
3838: WP_FLAG = 'Y';

Line 3895: UPDATE pji_pjp_wbs_header SET

3891: l_struct_sharing_code := Pa_Project_Structure_Utils.get_structure_sharing_code (l_project_id);
3892: IF l_old_wbs_version_id IS NULL THEN
3893: -- Fix for bug : 4191390
3894: If l_struct_sharing_code LIKE '%SHARE%' then
3895: UPDATE pji_pjp_wbs_header SET
3896: wbs_version_id = l_new_wbs_version_id
3897: WHERE
3898: wp_flag = 'N' AND
3899: project_id = l_project_id;

Line 3903: UPDATE pji_pjp_wbs_header SET

3899: project_id = l_project_id;
3900:
3901: elsif l_struct_sharing_code LIKE '%SPLIT%' THEN
3902:
3903: UPDATE pji_pjp_wbs_header SET
3904: wbs_version_id = l_new_wbs_version_id
3905: WHERE
3906: wp_flag = 'N' AND
3907: p_struct_type = 'FINANCIAL' AND

Line 4093: UPDATE pji_pjp_wbs_header SET

4089:
4090: IF p_publish_flag = 'Y' THEN
4091: -- Fix for bug : 4191390
4092: If l_struct_sharing_code LIKE '%SHARE%' then
4093: UPDATE pji_pjp_wbs_header SET
4094: wbs_version_id = l_new_wbs_version_id
4095: WHERE
4096: wp_flag = 'N' AND
4097: project_id = l_project_id;

Line 4099: UPDATE pji_pjp_wbs_header SET

4095: WHERE
4096: wp_flag = 'N' AND
4097: project_id = l_project_id;
4098: elsif l_struct_sharing_code LIKE '%SPLIT%' THEN
4099: UPDATE pji_pjp_wbs_header SET
4100: wbs_version_id = l_new_wbs_version_id
4101: WHERE
4102: wp_flag = 'N' AND
4103: p_struct_type = 'FINANCIAL' AND

Line 4449: pji_pjp_wbs_header head

4445: p_project_id,
4446: p_old_struct_ver_id,
4447: head.PLAN_VERSION_ID
4448: FROM
4449: pji_pjp_wbs_header head
4450: WHERE
4451: head.PROJECT_ID = p_project_id AND
4452: head.WBS_VERSION_ID = p_old_struct_ver_id;
4453:

Line 4567: pji_pjp_wbs_header head

4563: p_project_id,
4564: p_old_struct_ver_id,
4565: head.PLAN_VERSION_ID
4566: FROM
4567: pji_pjp_wbs_header head
4568: WHERE
4569: head.PROJECT_ID = p_project_id AND
4570: head.WBS_VERSION_ID = p_old_struct_ver_id AND
4571: head.WP_FLAG = 'Y';

Line 4668: pji_pjp_wbs_header head

4664: p_project_id,
4665: p_old_struct_ver_id,
4666: head.PLAN_VERSION_ID
4667: FROM
4668: pji_pjp_wbs_header head
4669: WHERE
4670: head.PROJECT_ID = p_project_id AND
4671: head.WBS_VERSION_ID = p_old_struct_ver_id AND
4672: head.WP_FLAG = 'N';

Line 5190: pji_pjp_wbs_header head

5186: evt.EVENT_ID,
5187: evt.EVENT_TYPE
5188: FROM
5189: pa_pji_proj_events_log evt,
5190: pji_pjp_wbs_header head
5191: WHERE
5192: evt.EVENT_TYPE IN ( 'WBS_CHANGE',
5193: 'WBS_PUBLISH') AND
5194: evt.EVENT_OBJECT = to_char(head.WBS_VERSION_ID) AND

Line 5235: pji_pjp_wbs_header headr

5231:
5232: SELECT COUNT(*)
5233: INTO l_child_task_check
5234: FROM pa_xbs_denorm denom,
5235: pji_pjp_wbs_header headr
5236: WHERE denom.sup_project_id = p_project_id
5237: AND headr.project_id = denom.sup_project_id
5238: AND headr.plan_version_id = l_plan_version_id
5239: AND headr.wbs_version_id = denom.struct_version_id

Line 5260: FROM pji_pjp_wbs_header

5256: BEGIN
5257: l_wbs_version_id:=NULL;
5258:
5259: SELECT wbs_version_id INTO l_wbs_version_id
5260: FROM pji_pjp_wbs_header
5261: WHERE plan_version_id = l_plan_version_id
5262: AND project_id = p_project_id;
5263: EXCEPTION
5264: WHEN NO_DATA_FOUND THEN

Line 5475: from pji_pjp_wbs_header head

5471: FOR i IN 1..p_plan_version_id_tbl.COUNT LOOP
5472: BEGIN
5473: select distinct head.wbs_version_id,head.plan_version_id,head.plan_type_code BULK COLLECT
5474: into jl_get_wbs_version_id_tbl,jl_get_plan_version_id_tbl,jl_get_plan_type_code_tbl /*4471527 */
5475: from pji_pjp_wbs_header head
5476: where head.plan_version_id = p_plan_version_id_tbl(i)
5477: and head.project_id in (select project_id from pji_pjp_wbs_header head1
5478: where head1.wbs_version_id=p_wbs_version_id );
5479: FOR j IN 1..jl_get_plan_version_id_tbl.COUNT LOOP

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

5473: select distinct head.wbs_version_id,head.plan_version_id,head.plan_type_code BULK COLLECT
5474: into jl_get_wbs_version_id_tbl,jl_get_plan_version_id_tbl,jl_get_plan_type_code_tbl /*4471527 */
5475: from pji_pjp_wbs_header head
5476: where head.plan_version_id = p_plan_version_id_tbl(i)
5477: and head.project_id in (select project_id from pji_pjp_wbs_header head1
5478: where head1.wbs_version_id=p_wbs_version_id );
5479: FOR j IN 1..jl_get_plan_version_id_tbl.COUNT LOOP
5480: l_get_plan_version_id_tbl.EXTEND;
5481: l_get_plan_version_id_tbl(validcount) := jl_get_plan_version_id_tbl(j);

Line 5519: ,pji_pjp_wbs_header head

5515: SELECT distinct head.plan_version_id,head.project_id ,pji.sub_id wbs_version_id,head.plan_type_code BULK COLLECT
5516: into il_plan_version_id_tbl, il_project_id_tbl,il_wbs_version_id_tbl,il_plan_type_code_tbl /*4471527 */
5517: FROM pji_xbs_Denorm pji
5518: ,pa_proj_element_versions pa
5519: ,pji_pjp_wbs_header head
5520: WHERE pji.struct_type='PRG'
5521: and pji.sup_level<>pji.sub_level
5522: 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)
5523: ,l_get_wbs_version_id_tbl(4),l_get_wbs_version_id_tbl(5),l_get_wbs_version_id_tbl(6)

Line 5862: pji_pjp_wbs_header head

5858: fact.CUSTOM15,
5859: fact.PLAN_TYPE_CODE /*4471527 */
5860: FROM
5861: pji_fp_xbs_accum_f fact,
5862: pji_pjp_wbs_header head
5863: WHERE
5864: fact.RBS_AGGR_LEVEL = 'L' AND
5865: fact.WBS_ROLLUP_FLAG = 'N' AND
5866: fact.PRG_ROLLUP_FLAG in ('Y', 'N') AND

Line 6040: pji_pjp_wbs_header head,

6036: SUM(fact.CUSTOM15),
6037: fact.PLAN_TYPE_CODE /*4471527 */
6038: FROM
6039: pji_fp_aggr_pjp1_t fact,
6040: pji_pjp_wbs_header head,
6041: pji_xbs_denorm xbs
6042: WHERE
6043: xbs.STRUCT_VERSION_ID = head.WBS_VERSION_ID AND
6044: xbs.STRUCT_TYPE = 'WBS' AND

Line 6234: pji_pjp_wbs_header head,

6230: SUM(fact.CUSTOM15),
6231: fact.PLAN_TYPE_CODE /*4471527 */
6232: FROM
6233: pji_fp_aggr_pjp1_t fact,
6234: pji_pjp_wbs_header head,
6235: pji_xbs_denorm xbs
6236:
6237: WHERE
6238: xbs.STRUCT_VERSION_ID = head.WBS_VERSION_ID AND

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

6539: END;
6540:
6541: BEGIN
6542:
6543: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ PROJECT_ID
6544: INTO l_project_id
6545: FROM pji_pjp_wbs_header wbs_hdr
6546: WHERE plan_version_id = p_fp_version_ids(i);
6547:

Line 6545: FROM pji_pjp_wbs_header wbs_hdr

6541: BEGIN
6542:
6543: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ PROJECT_ID
6544: INTO l_project_id
6545: FROM pji_pjp_wbs_header wbs_hdr
6546: WHERE plan_version_id = p_fp_version_ids(i);
6547:
6548: print_time ( ' plan version id # ' || i || ' is ' || p_fp_version_ids(i) || ' exists in budget versions.');
6549: