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.PA_PROGRESS_UTILS dependencies on PA_PROGRESS_ROLLUP

Line 347: from pa_progress_rollup

343:
344: ---- bug 5042445
345: CURSOR c_get_prior_percent_complete(l_task_id NUMBER, l_project_id NUMBER, l_as_of_date DATE) IS
346: select nvl(completed_percentage,eff_rollup_percent_comp)
347: from pa_progress_rollup
348: where project_id = l_project_id
349: and object_id = l_task_id
350: and object_type in ('PA_STRUCTURES', 'PA_TASKS')
351: and structure_Type = 'WORKPLAN'

Line 671: FROM pa_progress_rollup

667: l_return_date DATE;
668:
669: CURSOR c_get_max_rollup_dt IS
670: SELECT max(as_of_date)
671: FROM pa_progress_rollup
672: where project_id = X_Project_ID
673: and object_type IN ('PA_TASKS', 'PA_STRUCTURES')
674: and object_id = x_object_id
675: and structure_type = 'WORKPLAN'

Line 1026: FROM pa_progress_rollup ppr, pa_project_statuses pps

1022: BASE_PERCENT_COMPLETE, EFF_ROLLUP_PERCENT_COMP,
1023: ESTIMATED_START_DATE, ESTIMATED_FINISH_DATE,
1024: ACTUAL_START_DATE, ACTUAL_FINISH_DATE,
1025: pps.status_icon_ind, pps.status_icon_active_ind
1026: FROM pa_progress_rollup ppr, pa_project_statuses pps
1027: WHERE object_id = p_task_id
1028: AND project_id = l_project_id
1029: AND ppr.eff_rollup_prog_stat_code = pps.project_status_code(+)
1030: AND as_of_date = ( SELECT max( as_of_date ) from pa_progress_rollup

Line 1030: AND as_of_date = ( SELECT max( as_of_date ) from pa_progress_rollup

1026: FROM pa_progress_rollup ppr, pa_project_statuses pps
1027: WHERE object_id = p_task_id
1028: AND project_id = l_project_id
1029: AND ppr.eff_rollup_prog_stat_code = pps.project_status_code(+)
1030: AND as_of_date = ( SELECT max( as_of_date ) from pa_progress_rollup
1031: WHERE object_id = p_task_id and as_of_date <= p_as_of_date
1032: AND project_id = l_project_id );
1033: BEGIN
1034: --Added for performance improvements bug 2679612

Line 1621: FROM pa_progress_rollup

1617:
1618: CURSOR cur_prog_rollup_id_pub_wp
1619: IS
1620: SELECT progress_rollup_id, record_version_number
1621: FROM pa_progress_rollup
1622: WHERE object_type = p_object_type
1623: AND object_id = p_object_id
1624: AND project_id = p_project_id
1625: -- AND object_version_id = p_object_version_id

Line 1638: FROM pa_progress_rollup

1634:
1635: CURSOR cur_prog_rollup_id_work_wp
1636: IS
1637: SELECT progress_rollup_id, record_version_number
1638: FROM pa_progress_rollup
1639: WHERE object_type = p_object_type
1640: AND object_id = p_object_id
1641: AND project_id = p_project_id
1642: AND structure_type = p_structure_type

Line 1717: FROM pa_progress_rollup

1713: -- 4348710 : Added structure_type and structure_version_id joins
1714: CURSOR cur_cumla
1715: IS
1716: SELECT cumulative_work_quantity
1717: FROM pa_progress_rollup
1718: WHERE project_id = p_project_id
1719: AND object_id = p_object_id
1720: AND object_type = p_object_type
1721: AND structure_type = 'WORKPLAN'

Line 1724: FROM pa_progress_rollup

1720: AND object_type = p_object_type
1721: AND structure_type = 'WORKPLAN'
1722: AND structure_version_id is null
1723: AND as_of_date = ( SELECT max( as_of_date )
1724: FROM pa_progress_rollup
1725: WHERE project_id = p_project_id
1726: AND object_id = p_object_id
1727: AND object_type = p_object_type
1728: AND as_of_date < p_as_of_date

Line 2134: select 'X' from pa_progress_rollup

2130: AND rownum <= 1;
2131:
2132: Cursor c_prog_rollup
2133: is
2134: select 'X' from pa_progress_rollup
2135: where ( progress_status_code = p_status_code
2136: or base_progress_status_code = p_status_code
2137: or eff_rollup_prog_stat_code = p_status_code)
2138: AND rownum <= 1;

Line 2171: -- Check referense in pa_progress_rollup

2167: l_return_value := TRUE;
2168: end if;
2169: close c_percent_complete;
2170:
2171: -- Check referense in pa_progress_rollup
2172: if(NOT l_return_value) then
2173: open c_prog_rollup;
2174: fetch c_prog_rollup into l_dummy;
2175: if(c_prog_rollup%FOUND) then

Line 2392: from pa_progress_rollup

2388: if (((p_object_type = 'PA_TASKS') AND (nvl(PA_PROJ_ELEMENTS_UTILS.IS_LOWEST_TASK(p_task_version_id => p_object_version_id ),'N') = 'N')) OR p_structure_version_id is not null) then
2389:
2390: select max(as_of_date)
2391: into l_rollup_date
2392: from pa_progress_rollup
2393: where project_id = p_project_id
2394: and object_id = p_object_id
2395: and object_type = p_object_type
2396: and structure_type = p_structure_type -- FPM Dev CR 3

Line 2403: from pa_progress_rollup

2399: ;
2400: else
2401: select max(as_of_date)
2402: into l_rollup_date
2403: from pa_progress_rollup
2404: where project_id = p_project_id
2405: and object_id = p_object_id
2406: and object_type = p_object_type
2407: and structure_type = p_structure_type -- FPM Dev CR 3

Line 2420: select /+ INDEX(pa_progress_rollup PA_PROGRESS_ROLLUP_U2)/ max(as_of_date) -- For Bug 9595490

2416: end if;
2417: */
2418:
2419: -- FPM Dev CR 6 : Commented the above code and added this new code to get the date.
2420: select /*+ INDEX(pa_progress_rollup PA_PROGRESS_ROLLUP_U2)*/ max(as_of_date) -- For Bug 9595490
2421: into l_rollup_date
2422: from pa_progress_rollup
2423: where project_id = p_project_id
2424: and object_id = p_object_id

Line 2422: from pa_progress_rollup

2418:
2419: -- FPM Dev CR 6 : Commented the above code and added this new code to get the date.
2420: select /*+ INDEX(pa_progress_rollup PA_PROGRESS_ROLLUP_U2)*/ max(as_of_date) -- For Bug 9595490
2421: into l_rollup_date
2422: from pa_progress_rollup
2423: where project_id = p_project_id
2424: and object_id = p_object_id
2425: and object_type = p_object_type
2426: and structure_type = p_structure_type

Line 2848: FROM pa_progress_rollup

2844:
2845: CURSOR cur_task_effort
2846: IS
2847: SELECT NVL( EQPMT_ACT_EFFORT_TO_DATE, 0 ) + NVL( PPL_ACT_EFFORT_TO_DATE, 0 ) + nvl(oth_quantity_to_date,0)
2848: FROM pa_progress_rollup
2849: WHERE project_id = p_project_id
2850: AND object_id = p_object_id
2851: --Commented by rtarway for BUG 3835474
2852: /*AND as_of_date = ( SELECT max(as_of_date)

Line 2853: from pa_progress_rollup

2849: WHERE project_id = p_project_id
2850: AND object_id = p_object_id
2851: --Commented by rtarway for BUG 3835474
2852: /*AND as_of_date = ( SELECT max(as_of_date)
2853: from pa_progress_rollup
2854: WHERE as_of_date < p_as_of_date
2855: AND project_id = p_project_id
2856: AND object_id = p_object_id
2857: AND object_type = p_object_type

Line 2864: from pa_progress_rollup ppr2

2860: --and proj_element_id = nvl(p_proj_element_id, p_object_id) Modified for IB4 Progress CR.
2861: )*/
2862: --Added by rtarway for BUG 3835474
2863: AND as_of_date = ( SELECT max(as_of_date)
2864: from pa_progress_rollup ppr2
2865: WHERE ppr2.as_of_date <= p_as_of_date
2866: AND ppr2.project_id = p_project_id
2867: AND ppr2.object_id = p_object_id
2868: AND ppr2.object_type = p_object_type

Line 2918: FROM pa_progress_rollup ppr

2914:
2915: CURSOR cur_task_cost
2916: IS
2917: SELECT (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0))
2918: FROM pa_progress_rollup ppr
2919: WHERE ppr.project_id = p_project_id
2920: AND ppr.object_id = p_object_id
2921: AND ppr.as_of_date = ( SELECT max(as_of_date)
2922: from pa_progress_rollup ppr2

Line 2922: from pa_progress_rollup ppr2

2918: FROM pa_progress_rollup ppr
2919: WHERE ppr.project_id = p_project_id
2920: AND ppr.object_id = p_object_id
2921: AND ppr.as_of_date = ( SELECT max(as_of_date)
2922: from pa_progress_rollup ppr2
2923: WHERE ppr2.as_of_date < p_as_of_date
2924: AND ppr2.project_id = p_project_id
2925: AND ppr2.object_id = p_object_id
2926: AND ppr2.object_type = p_object_type

Line 3685: from pa_progress_rollup ppr

3681: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3682: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
3683: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3684: into l_actual_cost
3685: from pa_progress_rollup ppr
3686: where ppr.project_id = p_project_id
3687: and ppr.object_id = p_object_id
3688: and prog_pa_period_name = p_period_name
3689: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3693: from pa_progress_rollup ppr2

3689: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3690: and ppr.structure_version_id IS NULL --bug 3802177
3691: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3692: and ppr.as_of_date = (select max(as_of_date)
3693: from pa_progress_rollup ppr2
3694: where ppr2.project_id = ppr.project_id
3695: and ppr2.object_id = ppr.object_id
3696: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3697: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3711: from pa_progress_rollup ppr

3707: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3708: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
3709: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3710: into l_prev_period_actual_cost
3711: from pa_progress_rollup ppr
3712: where ppr.project_id = p_project_id
3713: and ppr.object_id = p_object_id
3714: and ppr.structure_type = 'WORKPLAN'
3715: and ppr.structure_version_id IS NULL

Line 3718: from pa_progress_rollup ppr1

3714: and ppr.structure_type = 'WORKPLAN'
3715: and ppr.structure_version_id IS NULL
3716: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3717: and ppr.as_of_date = ( select max(ppr1.as_of_date)
3718: from pa_progress_rollup ppr1
3719: where ppr1.project_id = ppr.project_id
3720: and ppr1.object_id = ppr.object_id
3721: and ppr1.structure_type = 'WORKPLAN'
3722: and ppr1.structure_version_id IS NULL --bug 3802177

Line 3725: from pa_progress_rollup ppr2

3721: and ppr1.structure_type = 'WORKPLAN'
3722: and ppr1.structure_version_id IS NULL --bug 3802177
3723: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
3724: and as_of_date < ( select min(as_of_date)
3725: from pa_progress_rollup ppr2
3726: where ppr2.project_id = ppr1.project_id
3727: and ppr2.object_id = ppr1.object_id
3728: and structure_type = 'WORKPLAN'
3729: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3742: from pa_progress_rollup ppr

3738: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3739: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
3740: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3741: into l_actual_cost
3742: from pa_progress_rollup ppr
3743: where ppr.project_id = p_project_id
3744: and ppr.object_id = p_object_id
3745: and prog_gl_period_name = p_period_name
3746: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3750: from pa_progress_rollup ppr2

3746: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3747: and ppr.structure_version_id IS NULL --bug 3802177
3748: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3749: and ppr.as_of_date = (select max(as_of_date)
3750: from pa_progress_rollup ppr2
3751: where ppr2.project_id = ppr.project_id
3752: and ppr2.object_id = ppr.object_id
3753: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3754: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3767: from pa_progress_rollup ppr

3763: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3764: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
3765: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3766: into l_prev_period_actual_cost
3767: from pa_progress_rollup ppr
3768: where ppr.project_id = p_project_id
3769: and ppr.object_id = p_object_id
3770: and ppr.structure_type = 'WORKPLAN'
3771: and ppr.structure_version_id IS NULL

Line 3774: from pa_progress_rollup ppr1

3770: and ppr.structure_type = 'WORKPLAN'
3771: and ppr.structure_version_id IS NULL
3772: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3773: and ppr.as_of_date = ( select max(ppr1.as_of_date)
3774: from pa_progress_rollup ppr1
3775: where ppr1.project_id = ppr.project_id
3776: and ppr1.object_id = ppr.object_id
3777: and ppr1.structure_type = 'WORKPLAN'
3778: and ppr1.structure_version_id IS NULL --bug 3802177

Line 3781: from pa_progress_rollup ppr2

3777: and ppr1.structure_type = 'WORKPLAN'
3778: and ppr1.structure_version_id IS NULL --bug 3802177
3779: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
3780: and as_of_date < ( select min(as_of_date)
3781: from pa_progress_rollup ppr2
3782: where ppr2.project_id = ppr1.project_id
3783: and ppr2.object_id = ppr1.object_id
3784: and structure_type = 'WORKPLAN'
3785: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3797: from pa_progress_rollup ppr

3793: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3794: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
3795: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3796: into l_actual_cost
3797: from pa_progress_rollup ppr
3798: where ppr.project_id = p_project_id
3799: and ppr.object_id = p_object_id
3800: --and ppr.object_version_id = p_object_version_id
3801: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3812: from pa_progress_rollup ppr

3808: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
3809: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
3810: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0))
3811: into l_actual_cost
3812: from pa_progress_rollup ppr
3813: where ppr.project_id = p_project_id
3814: and ppr.object_id = p_object_id
3815: and ppr.structure_version_id = p_structure_version_id
3816: and structure_type = 'WORKPLAN'

Line 3832: from pa_progress_rollup ppr

3828: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3829: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
3830: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3831: into l_actual_cost
3832: from pa_progress_rollup ppr
3833: where ppr.project_id = p_project_id
3834: and ppr.object_id = p_object_id
3835: and prog_pa_period_name = p_period_name
3836: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3840: from pa_progress_rollup ppr2

3836: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3837: and ppr.structure_version_id IS NULL --bug 3802177
3838: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3839: and ppr.as_of_date = (select max(as_of_date)
3840: from pa_progress_rollup ppr2
3841: where ppr2.project_id = ppr.project_id
3842: and ppr2.object_id = ppr.object_id
3843: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3844: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3857: from pa_progress_rollup ppr

3853: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3854: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
3855: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3856: into l_prev_period_actual_cost
3857: from pa_progress_rollup ppr
3858: where ppr.project_id = p_project_id
3859: and ppr.object_id = p_object_id
3860: and ppr.structure_type = 'WORKPLAN'
3861: and ppr.structure_version_id IS NULL

Line 3864: from pa_progress_rollup ppr1

3860: and ppr.structure_type = 'WORKPLAN'
3861: and ppr.structure_version_id IS NULL
3862: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3863: and ppr.as_of_date = ( select max(ppr1.as_of_date)
3864: from pa_progress_rollup ppr1
3865: where ppr1.project_id = ppr.project_id
3866: and ppr1.object_id = ppr.object_id
3867: and ppr1.structure_type = 'WORKPLAN'
3868: and ppr1.structure_version_id IS NULL --bug 3802177

Line 3871: from pa_progress_rollup ppr2

3867: and ppr1.structure_type = 'WORKPLAN'
3868: and ppr1.structure_version_id IS NULL --bug 3802177
3869: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
3870: and as_of_date < ( select min(as_of_date)
3871: from pa_progress_rollup ppr2
3872: where ppr2.project_id = ppr1.project_id
3873: and ppr2.object_id = ppr1.object_id
3874: and structure_type = 'WORKPLAN'
3875: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3889: from pa_progress_rollup ppr

3885: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3886: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
3887: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3888: into l_actual_cost
3889: from pa_progress_rollup ppr
3890: where ppr.project_id = p_project_id
3891: and ppr.object_id = p_object_id
3892: and prog_gl_period_name = p_period_name
3893: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3897: from pa_progress_rollup ppr2

3893: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3894: and ppr.structure_version_id IS NULL --bug 3802177
3895: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3896: and ppr.as_of_date = (select max(as_of_date)
3897: from pa_progress_rollup ppr2
3898: where ppr2.project_id = ppr.project_id
3899: and ppr2.object_id = ppr.object_id
3900: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3901: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3914: from pa_progress_rollup ppr

3910: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3911: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
3912: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3913: into l_prev_period_actual_cost
3914: from pa_progress_rollup ppr
3915: where ppr.project_id = p_project_id
3916: and ppr.object_id = p_object_id
3917: and ppr.structure_type = 'WORKPLAN'
3918: and ppr.structure_version_id IS NULL

Line 3921: from pa_progress_rollup ppr1

3917: and ppr.structure_type = 'WORKPLAN'
3918: and ppr.structure_version_id IS NULL
3919: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3920: and ppr.as_of_date = ( select max(ppr1.as_of_date)
3921: from pa_progress_rollup ppr1
3922: where ppr1.project_id = ppr.project_id
3923: and ppr1.object_id = ppr.object_id
3924: and ppr1.structure_type = 'WORKPLAN'
3925: and ppr1.structure_version_id IS NULL --bug 3802177

Line 3928: from pa_progress_rollup ppr2

3924: and ppr1.structure_type = 'WORKPLAN'
3925: and ppr1.structure_version_id IS NULL --bug 3802177
3926: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
3927: and as_of_date < ( select min(as_of_date)
3928: from pa_progress_rollup ppr2
3929: where ppr2.project_id = ppr1.project_id
3930: and ppr2.object_id = ppr1.object_id
3931: and structure_type = 'WORKPLAN'
3932: and ppr2.structure_version_id IS NULL --bug 3802177

Line 3944: from pa_progress_rollup ppr

3940: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3941: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
3942: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3943: into l_actual_cost
3944: from pa_progress_rollup ppr
3945: where ppr.project_id = p_project_id
3946: and ppr.object_id = p_object_id
3947: and ppr.object_version_id = p_object_version_id
3948: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3959: from pa_progress_rollup ppr

3955: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
3956: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
3957: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
3958: into l_actual_cost
3959: from pa_progress_rollup ppr
3960: where ppr.project_id = p_project_id
3961: and ppr.object_id = p_object_id
3962: and ppr.object_version_id = p_object_version_id
3963: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3978: from pa_progress_rollup ppr

3974: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
3975: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
3976: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
3977: into l_actual_cost
3978: from pa_progress_rollup ppr
3979: where ppr.project_id = p_project_id
3980: and ppr.object_id = p_object_id
3981: and prog_pa_period_name = p_period_name
3982: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 3986: from pa_progress_rollup ppr2

3982: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3983: and ppr.structure_version_id IS NULL --bug 3802177
3984: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
3985: and ppr.as_of_date = (select max(as_of_date)
3986: from pa_progress_rollup ppr2
3987: where ppr2.project_id = ppr.project_id
3988: and ppr2.object_id = ppr.object_id
3989: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
3990: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4003: from pa_progress_rollup ppr

3999: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
4000: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
4001: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
4002: into l_prev_period_actual_cost
4003: from pa_progress_rollup ppr
4004: where ppr.project_id = p_project_id
4005: and ppr.object_id = p_object_id
4006: and ppr.structure_type = 'WORKPLAN'
4007: and ppr.structure_version_id IS NULL

Line 4010: from pa_progress_rollup ppr1

4006: and ppr.structure_type = 'WORKPLAN'
4007: and ppr.structure_version_id IS NULL
4008: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4009: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4010: from pa_progress_rollup ppr1
4011: where ppr1.project_id = ppr.project_id
4012: and ppr1.object_id = ppr.object_id
4013: and ppr1.structure_type = 'WORKPLAN'
4014: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4017: from pa_progress_rollup ppr2

4013: and ppr1.structure_type = 'WORKPLAN'
4014: and ppr1.structure_version_id IS NULL --bug 3802177
4015: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4016: and as_of_date < ( select min(as_of_date)
4017: from pa_progress_rollup ppr2
4018: where ppr2.project_id = ppr1.project_id
4019: and ppr2.object_id = ppr1.object_id
4020: and structure_type = 'WORKPLAN'
4021: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4034: from pa_progress_rollup ppr

4030: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
4031: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
4032: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
4033: into l_actual_cost
4034: from pa_progress_rollup ppr
4035: where ppr.project_id = p_project_id
4036: and ppr.object_id = p_object_id
4037: and prog_gl_period_name = p_period_name
4038: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4042: from pa_progress_rollup ppr2

4038: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4039: and ppr.structure_version_id IS NULL --bug 3802177
4040: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4041: and ppr.as_of_date = (select max(as_of_date)
4042: from pa_progress_rollup ppr2
4043: where ppr2.project_id = ppr.project_id
4044: and ppr2.object_id = ppr.object_id
4045: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4046: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4059: from pa_progress_rollup ppr

4055: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
4056: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
4057: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
4058: into l_prev_period_actual_cost
4059: from pa_progress_rollup ppr
4060: where ppr.project_id = p_project_id
4061: and ppr.object_id = p_object_id
4062: and ppr.structure_type = 'WORKPLAN'
4063: and ppr.structure_version_id IS NULL

Line 4066: from pa_progress_rollup ppr1

4062: and ppr.structure_type = 'WORKPLAN'
4063: and ppr.structure_version_id IS NULL
4064: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4065: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4066: from pa_progress_rollup ppr1
4067: where ppr1.project_id = ppr.project_id
4068: and ppr1.object_id = ppr.object_id
4069: and ppr1.structure_type = 'WORKPLAN'
4070: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4073: from pa_progress_rollup ppr2

4069: and ppr1.structure_type = 'WORKPLAN'
4070: and ppr1.structure_version_id IS NULL --bug 3802177
4071: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4072: and as_of_date < ( select min(as_of_date)
4073: from pa_progress_rollup ppr2
4074: where ppr2.project_id = ppr1.project_id
4075: and ppr2.object_id = ppr1.object_id
4076: and structure_type = 'WORKPLAN'
4077: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4089: from pa_progress_rollup ppr

4085: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
4086: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
4087: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
4088: into l_actual_cost
4089: from pa_progress_rollup ppr
4090: where ppr.project_id = p_project_id
4091: and ppr.object_id = p_object_id
4092: and ppr.object_version_id = p_object_version_id
4093: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4105: from pa_progress_rollup ppr

4101: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)
4102: +nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
4103: +nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
4104: into l_actual_cost
4105: from pa_progress_rollup ppr
4106: where ppr.project_id = p_project_id
4107: and ppr.object_id = p_object_id
4108: and ppr.object_version_id = p_object_version_id
4109: and structure_type = 'WORKPLAN'

Line 4147: from pa_progress_rollup ppr

4143: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4144: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
4145: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4146: into l_actual_rawcost
4147: from pa_progress_rollup ppr
4148: where ppr.project_id = p_project_id
4149: and ppr.object_id = p_object_id
4150: and prog_pa_period_name = p_period_name
4151: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4155: from pa_progress_rollup ppr2

4151: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4152: and ppr.structure_version_id IS NULL --bug 3802177
4153: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4154: and ppr.as_of_date = (select max(as_of_date)
4155: from pa_progress_rollup ppr2
4156: where ppr2.project_id = ppr.project_id
4157: and ppr2.object_id = ppr.object_id
4158: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4159: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4172: from pa_progress_rollup ppr

4168: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4169: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
4170: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4171: into l_prev_period_actual_rawcost
4172: from pa_progress_rollup ppr
4173: where ppr.project_id = p_project_id
4174: and ppr.object_id = p_object_id
4175: and ppr.structure_type = 'WORKPLAN'
4176: and ppr.structure_version_id IS NULL

Line 4179: from pa_progress_rollup ppr1

4175: and ppr.structure_type = 'WORKPLAN'
4176: and ppr.structure_version_id IS NULL
4177: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4178: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4179: from pa_progress_rollup ppr1
4180: where ppr1.project_id = ppr.project_id
4181: and ppr1.object_id = ppr.object_id
4182: and ppr1.structure_type = 'WORKPLAN'
4183: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4186: from pa_progress_rollup ppr2

4182: and ppr1.structure_type = 'WORKPLAN'
4183: and ppr1.structure_version_id IS NULL --bug 3802177
4184: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4185: and as_of_date < ( select min(as_of_date)
4186: from pa_progress_rollup ppr2
4187: where ppr2.project_id = ppr1.project_id
4188: and ppr2.object_id = ppr1.object_id
4189: and structure_type = 'WORKPLAN'
4190: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4203: from pa_progress_rollup ppr

4199: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4200: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
4201: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4202: into l_actual_rawcost
4203: from pa_progress_rollup ppr
4204: where ppr.project_id = p_project_id
4205: and ppr.object_id = p_object_id
4206: and prog_gl_period_name = p_period_name
4207: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4211: from pa_progress_rollup ppr2

4207: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4208: and ppr.structure_version_id IS NULL --bug 3802177
4209: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4210: and ppr.as_of_date = (select max(as_of_date)
4211: from pa_progress_rollup ppr2
4212: where ppr2.project_id = ppr.project_id
4213: and ppr2.object_id = ppr.object_id
4214: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4215: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4228: from pa_progress_rollup ppr

4224: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4225: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
4226: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4227: into l_prev_period_actual_rawcost
4228: from pa_progress_rollup ppr
4229: where ppr.project_id = p_project_id
4230: and ppr.object_id = p_object_id
4231: and ppr.structure_type = 'WORKPLAN'
4232: and ppr.structure_version_id IS NULL

Line 4235: from pa_progress_rollup ppr1

4231: and ppr.structure_type = 'WORKPLAN'
4232: and ppr.structure_version_id IS NULL
4233: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4234: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4235: from pa_progress_rollup ppr1
4236: where ppr1.project_id = ppr.project_id
4237: and ppr1.object_id = ppr.object_id
4238: and ppr1.structure_type = 'WORKPLAN'
4239: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4242: from pa_progress_rollup ppr2

4238: and ppr1.structure_type = 'WORKPLAN'
4239: and ppr1.structure_version_id IS NULL --bug 3802177
4240: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4241: and as_of_date < ( select min(as_of_date)
4242: from pa_progress_rollup ppr2
4243: where ppr2.project_id = ppr1.project_id
4244: and ppr2.object_id = ppr1.object_id
4245: and structure_type = 'WORKPLAN'
4246: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4258: from pa_progress_rollup ppr

4254: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4255: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
4256: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4257: into l_actual_rawcost
4258: from pa_progress_rollup ppr
4259: where ppr.project_id = p_project_id
4260: and ppr.object_id = p_object_id
4261: --and ppr.object_version_id = p_object_version_id
4262: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4273: from pa_progress_rollup ppr

4269: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
4270: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
4271: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
4272: into l_actual_rawcost
4273: from pa_progress_rollup ppr
4274: where ppr.project_id = p_project_id
4275: and ppr.object_id = p_object_id
4276: and ppr.object_version_id = p_object_version_id
4277: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4292: from pa_progress_rollup ppr

4288: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4289: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
4290: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4291: into l_actual_rawcost
4292: from pa_progress_rollup ppr
4293: where ppr.project_id = p_project_id
4294: and ppr.object_id = p_object_id
4295: and prog_pa_period_name = p_period_name
4296: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4300: from pa_progress_rollup ppr2

4296: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4297: and ppr.structure_version_id IS NULL --bug 3802177
4298: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4299: and ppr.as_of_date = (select max(as_of_date)
4300: from pa_progress_rollup ppr2
4301: where ppr2.project_id = ppr.project_id
4302: and ppr2.object_id = ppr.object_id
4303: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4304: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4317: from pa_progress_rollup ppr

4313: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4314: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
4315: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4316: into l_prev_period_actual_rawcost
4317: from pa_progress_rollup ppr
4318: where ppr.project_id = p_project_id
4319: and ppr.object_id = p_object_id
4320: and ppr.structure_type = 'WORKPLAN'
4321: and ppr.structure_version_id IS NULL

Line 4324: from pa_progress_rollup ppr1

4320: and ppr.structure_type = 'WORKPLAN'
4321: and ppr.structure_version_id IS NULL
4322: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4323: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4324: from pa_progress_rollup ppr1
4325: where ppr1.project_id = ppr.project_id
4326: and ppr1.object_id = ppr.object_id
4327: and ppr1.structure_type = 'WORKPLAN'
4328: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4331: from pa_progress_rollup ppr2

4327: and ppr1.structure_type = 'WORKPLAN'
4328: and ppr1.structure_version_id IS NULL --bug 3802177
4329: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4330: and as_of_date < ( select min(as_of_date)
4331: from pa_progress_rollup ppr2
4332: where ppr2.project_id = ppr1.project_id
4333: and ppr2.object_id = ppr1.object_id
4334: and structure_type = 'WORKPLAN'
4335: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4349: from pa_progress_rollup ppr

4345: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4346: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
4347: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4348: into l_actual_rawcost
4349: from pa_progress_rollup ppr
4350: where ppr.project_id = p_project_id
4351: and ppr.object_id = p_object_id
4352: and prog_gl_period_name = p_period_name
4353: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4357: from pa_progress_rollup ppr2

4353: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4354: and ppr.structure_version_id IS NULL --bug 3802177
4355: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4356: and ppr.as_of_date = (select max(as_of_date)
4357: from pa_progress_rollup ppr2
4358: where ppr2.project_id = ppr.project_id
4359: and ppr2.object_id = ppr.object_id
4360: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4361: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4374: from pa_progress_rollup ppr

4370: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4371: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
4372: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4373: into l_prev_period_actual_rawcost
4374: from pa_progress_rollup ppr
4375: where ppr.project_id = p_project_id
4376: and ppr.object_id = p_object_id
4377: and ppr.structure_type = 'WORKPLAN'
4378: and ppr.structure_version_id IS NULL

Line 4381: from pa_progress_rollup ppr1

4377: and ppr.structure_type = 'WORKPLAN'
4378: and ppr.structure_version_id IS NULL
4379: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4380: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4381: from pa_progress_rollup ppr1
4382: where ppr1.project_id = ppr.project_id
4383: and ppr1.object_id = ppr.object_id
4384: and ppr1.structure_type = 'WORKPLAN'
4385: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4388: from pa_progress_rollup ppr2

4384: and ppr1.structure_type = 'WORKPLAN'
4385: and ppr1.structure_version_id IS NULL --bug 3802177
4386: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4387: and as_of_date < ( select min(as_of_date)
4388: from pa_progress_rollup ppr2
4389: where ppr2.project_id = ppr1.project_id
4390: and ppr2.object_id = ppr1.object_id
4391: and structure_type = 'WORKPLAN'
4392: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4404: from pa_progress_rollup ppr

4400: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4401: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
4402: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4403: into l_actual_rawcost
4404: from pa_progress_rollup ppr
4405: where ppr.project_id = p_project_id
4406: and ppr.object_id = p_object_id
4407: and ppr.object_version_id = p_object_version_id
4408: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4419: from pa_progress_rollup ppr

4415: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
4416: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
4417: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
4418: into l_actual_rawcost
4419: from pa_progress_rollup ppr
4420: where ppr.project_id = p_project_id
4421: and ppr.object_id = p_object_id
4422: and ppr.object_version_id = p_object_version_id
4423: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4438: from pa_progress_rollup ppr

4434: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4435: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
4436: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4437: into l_actual_rawcost
4438: from pa_progress_rollup ppr
4439: where ppr.project_id = p_project_id
4440: and ppr.object_id = p_object_id
4441: and prog_pa_period_name = p_period_name
4442: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4446: from pa_progress_rollup ppr2

4442: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4443: and ppr.structure_version_id IS NULL --bug 3802177
4444: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4445: and ppr.as_of_date = (select max(as_of_date)
4446: from pa_progress_rollup ppr2
4447: where ppr2.project_id = ppr.project_id
4448: and ppr2.object_id = ppr.object_id
4449: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4450: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4463: from pa_progress_rollup ppr

4459: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4460: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
4461: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4462: into l_prev_period_actual_rawcost
4463: from pa_progress_rollup ppr
4464: where ppr.project_id = p_project_id
4465: and ppr.object_id = p_object_id
4466: and ppr.structure_type = 'WORKPLAN'
4467: and ppr.structure_version_id IS NULL

Line 4470: from pa_progress_rollup ppr1

4466: and ppr.structure_type = 'WORKPLAN'
4467: and ppr.structure_version_id IS NULL
4468: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4469: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4470: from pa_progress_rollup ppr1
4471: where ppr1.project_id = ppr.project_id
4472: and ppr1.object_id = ppr.object_id
4473: and ppr1.structure_type = 'WORKPLAN'
4474: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4477: from pa_progress_rollup ppr2

4473: and ppr1.structure_type = 'WORKPLAN'
4474: and ppr1.structure_version_id IS NULL --bug 3802177
4475: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4476: and as_of_date < ( select min(as_of_date)
4477: from pa_progress_rollup ppr2
4478: where ppr2.project_id = ppr1.project_id
4479: and ppr2.object_id = ppr1.object_id
4480: and structure_type = 'WORKPLAN'
4481: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4494: from pa_progress_rollup ppr

4490: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4491: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
4492: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4493: into l_actual_rawcost
4494: from pa_progress_rollup ppr
4495: where ppr.project_id = p_project_id
4496: and ppr.object_id = p_object_id
4497: and prog_gl_period_name = p_period_name
4498: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4502: from pa_progress_rollup ppr2

4498: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4499: and ppr.structure_version_id IS NULL --bug 3802177
4500: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4501: and ppr.as_of_date = (select max(as_of_date)
4502: from pa_progress_rollup ppr2
4503: where ppr2.project_id = ppr.project_id
4504: and ppr2.object_id = ppr.object_id
4505: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4506: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4519: from pa_progress_rollup ppr

4515: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4516: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
4517: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4518: into l_prev_period_actual_rawcost
4519: from pa_progress_rollup ppr
4520: where ppr.project_id = p_project_id
4521: and ppr.object_id = p_object_id
4522: and ppr.structure_type = 'WORKPLAN'
4523: and ppr.structure_version_id IS NULL

Line 4526: from pa_progress_rollup ppr1

4522: and ppr.structure_type = 'WORKPLAN'
4523: and ppr.structure_version_id IS NULL
4524: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4525: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4526: from pa_progress_rollup ppr1
4527: where ppr1.project_id = ppr.project_id
4528: and ppr1.object_id = ppr.object_id
4529: and ppr1.structure_type = 'WORKPLAN'
4530: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4533: from pa_progress_rollup ppr2

4529: and ppr1.structure_type = 'WORKPLAN'
4530: and ppr1.structure_version_id IS NULL --bug 3802177
4531: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4532: and as_of_date < ( select min(as_of_date)
4533: from pa_progress_rollup ppr2
4534: where ppr2.project_id = ppr1.project_id
4535: and ppr2.object_id = ppr1.object_id
4536: and structure_type = 'WORKPLAN'
4537: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4549: from pa_progress_rollup ppr

4545: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4546: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
4547: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4548: into l_actual_rawcost
4549: from pa_progress_rollup ppr
4550: where ppr.project_id = p_project_id
4551: and ppr.object_id = p_object_id
4552: and ppr.object_version_id = p_object_version_id
4553: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4564: from pa_progress_rollup ppr

4560: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
4561: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
4562: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
4563: into l_actual_rawcost
4564: from pa_progress_rollup ppr
4565: where ppr.project_id = p_project_id
4566: and ppr.object_id = p_object_id
4567: and ppr.object_version_id = p_object_version_id
4568: and structure_type = 'WORKPLAN'

Line 4600: from pa_progress_rollup ppr

4596: --maansari6/15 3694031
4597: begin
4598: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4599: into l_actual_effort
4600: from pa_progress_rollup ppr
4601: where ppr.project_id = p_project_id
4602: and ppr.object_id = p_object_id
4603: and prog_pa_period_name = p_period_name
4604: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4608: from pa_progress_rollup ppr2

4604: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4605: and ppr.structure_version_id IS NULL --bug 3802177
4606: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4607: and ppr.as_of_date = (select max(as_of_date)
4608: from pa_progress_rollup ppr2
4609: where ppr2.project_id = ppr.project_id
4610: and ppr2.object_id = ppr.object_id
4611: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4612: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4623: from pa_progress_rollup ppr

4619:
4620: begin
4621: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4622: into l_prev_period_actual_effort
4623: from pa_progress_rollup ppr
4624: where ppr.project_id = p_project_id
4625: and ppr.object_id = p_object_id
4626: and ppr.structure_type = 'WORKPLAN'
4627: and ppr.structure_version_id IS NULL

Line 4630: from pa_progress_rollup ppr1

4626: and ppr.structure_type = 'WORKPLAN'
4627: and ppr.structure_version_id IS NULL
4628: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4629: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4630: from pa_progress_rollup ppr1
4631: where ppr1.project_id = ppr.project_id
4632: and ppr1.object_id = ppr.object_id
4633: and ppr1.structure_type = 'WORKPLAN'
4634: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4637: from pa_progress_rollup ppr2

4633: and ppr1.structure_type = 'WORKPLAN'
4634: and ppr1.structure_version_id IS NULL --bug 3802177
4635: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4636: and as_of_date < ( select min(as_of_date)
4637: from pa_progress_rollup ppr2
4638: where ppr2.project_id = ppr1.project_id
4639: and ppr2.object_id = ppr1.object_id
4640: and structure_type = 'WORKPLAN'
4641: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4654: from pa_progress_rollup ppr

4650: --maansari6/15 3694031
4651: begin
4652: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4653: into l_actual_effort
4654: from pa_progress_rollup ppr
4655: where ppr.project_id = p_project_id
4656: and ppr.object_id = p_object_id
4657: and prog_gl_period_name = p_period_name
4658: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4662: from pa_progress_rollup ppr2

4658: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4659: and ppr.structure_version_id IS NULL --bug 3802177
4660: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4661: and ppr.as_of_date = (select max(as_of_date)
4662: from pa_progress_rollup ppr2
4663: where ppr2.project_id = ppr.project_id
4664: and ppr2.object_id = ppr.object_id
4665: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4666: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4677: from pa_progress_rollup ppr

4673:
4674: begin
4675: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4676: into l_prev_period_actual_effort
4677: from pa_progress_rollup ppr
4678: where ppr.project_id = p_project_id
4679: and ppr.object_id = p_object_id
4680: and ppr.structure_type = 'WORKPLAN'
4681: and ppr.structure_version_id IS NULL

Line 4684: from pa_progress_rollup ppr1

4680: and ppr.structure_type = 'WORKPLAN'
4681: and ppr.structure_version_id IS NULL
4682: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
4683: and ppr.as_of_date = ( select max(ppr1.as_of_date)
4684: from pa_progress_rollup ppr1
4685: where ppr1.project_id = ppr.project_id
4686: and ppr1.object_id = ppr.object_id
4687: and ppr1.structure_type = 'WORKPLAN'
4688: and ppr1.structure_version_id IS NULL --bug 3802177

Line 4691: from pa_progress_rollup ppr2

4687: and ppr1.structure_type = 'WORKPLAN'
4688: and ppr1.structure_version_id IS NULL --bug 3802177
4689: and ppr1.proj_element_id = ppr.proj_element_id /* Modified for IB4 Progress CR. */
4690: and as_of_date < ( select min(as_of_date)
4691: from pa_progress_rollup ppr2
4692: where ppr2.project_id = ppr1.project_id
4693: and ppr2.object_id = ppr1.object_id
4694: and structure_type = 'WORKPLAN'
4695: and ppr2.structure_version_id IS NULL --bug 3802177

Line 4707: from pa_progress_rollup ppr

4703:
4704: elsif (pgn_flag = 'N') then
4705: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4706: into l_actual_effort
4707: from pa_progress_rollup ppr
4708: where ppr.project_id = p_project_id
4709: and ppr.object_id = p_object_id
4710: and ppr.object_version_id = p_object_version_id
4711: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4721: from pa_progress_rollup ppr

4717: ELSIF p_structure_version_id IS NOT NULL
4718: THEN
4719: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
4720: into l_actual_effort
4721: from pa_progress_rollup ppr
4722: where ppr.project_id = p_project_id
4723: and ppr.object_id = p_object_id
4724: and ppr.object_version_id = p_object_version_id
4725: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4753: from pa_progress_rollup ppr

4749: cursor c_prev_prog_rec is
4750: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
4751: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
4752: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0)) act_cost_to_date
4753: from pa_progress_rollup ppr
4754: where ppr.project_id = p_project_id
4755: and ppr.object_id = p_object_id
4756: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4757: and ppr.structure_version_id is null -- Bug 3764224

Line 4767: from pa_progress_rollup ppr

4763: cursor c_this_prog_rec is
4764: select (nvl(ppr.oth_act_cost_to_date_pc,0)+nvl(ppr.ppl_act_cost_to_date_pc,0)
4765: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
4766: +nvl(ppr.subprj_ppl_act_cost_pc,0)+nvl(ppr.subprj_eqpmt_act_cost_pc,0)) act_cost_to_date
4767: from pa_progress_rollup ppr
4768: where ppr.project_id = p_project_id
4769: and ppr.object_id = p_object_id
4770: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4771: and ppr.structure_version_id is null -- Bug 3764224

Line 4811: from pa_progress_rollup ppr

4807:
4808: /*
4809: cursor c1 is
4810: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4811: from pa_progress_rollup ppr
4812: where ppr.project_id = p_project_id
4813: and ppr.object_id = p_object_id
4814: -- and ppr.object_version_id = p_object_version_id
4815: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4818: from pa_progress_rollup ppr2

4814: -- and ppr.object_version_id = p_object_version_id
4815: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
4816: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Modified for IB4 Progress CR.
4817: and ppr.as_of_date = (select max(ppr2.as_of_date)
4818: from pa_progress_rollup ppr2
4819: where ppr2.project_id = p_project_id
4820: and ppr2.object_id = p_object_id
4821: -- and ppr2.object_version_id = p_object_version_id
4822: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4831: from pa_progress_rollup ppr

4827:
4828: /* BEGIN: Commenting code for Bug # 3808127.
4829: cursor c_prev_prog_rec is
4830: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4831: from pa_progress_rollup ppr
4832: where ppr.project_id = p_project_id
4833: and ppr.object_id = p_object_id
4834: -- and ppr.object_version_id = p_object_version_id
4835: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4839: from pa_progress_rollup ppr2

4835: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4836: and ppr.structure_version_id is null -- Bug 3764224
4837: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
4838: and ppr.as_of_date = (select max(ppr2.as_of_date)
4839: from pa_progress_rollup ppr2
4840: where ppr2.project_id = p_project_id
4841: and ppr2.object_id = p_object_id
4842: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4843: and ppr2.structure_version_id is null -- Bug 3764224

Line 4849: from pa_progress_rollup ppr

4845: and ppr2.as_of_date < p_as_of_date);
4846:
4847: cursor c_this_prog_rec is
4848: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4849: from pa_progress_rollup ppr
4850: where ppr.project_id = p_project_id
4851: and ppr.object_id = p_object_id
4852: -- and ppr.object_version_id = p_object_version_id
4853: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 4857: from pa_progress_rollup ppr2

4853: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4854: and ppr.structure_version_id is null -- Bug 3764224
4855: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
4856: and ppr.as_of_date = (select max(ppr2.as_of_date)
4857: from pa_progress_rollup ppr2
4858: where ppr2.project_id = p_project_id
4859: and ppr2.object_id = p_object_id
4860: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
4861: and ppr2.structure_version_id is null -- Bug 3764224

Line 4873: from pa_progress_rollup ppr

4869: cursor c_prev_prog_rec is
4870: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
4871: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
4872: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4873: from pa_progress_rollup ppr
4874: where ppr.project_id = p_project_id
4875: and ppr.object_id = p_object_id
4876: AND NVL(ppr.cbs_element_id,-1) = NVL(p_cbs_element_id,-1) --Added for CBS phase 2 16200605
4877: -- and ppr.object_version_id = p_object_version_id

Line 4888: from pa_progress_rollup ppr

4884: cursor c_this_prog_rec is
4885: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)
4886: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
4887: +nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_cost_to_date
4888: from pa_progress_rollup ppr
4889: -- Bug 3879461 : No need to have percent complete table join now we can directly check current_flag as W
4890: -- ,pa_percent_completes ppc
4891: where ppr.project_id = p_project_id
4892: and ppr.object_id = p_object_id

Line 4921: from pa_progress_rollup ppr,pa_percent_completes ppc

4917: fetch c1 into l_c1rec;
4918: if c1%found then
4919: select (nvl(ppr.oth_act_cost_to_date_tc,0)+nvl(ppr.ppl_act_cost_to_date_tc,0)+nvl(ppr.eqpmt_act_cost_to_date_tc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)+nvl(ppr.subprj_ppl_act_cost_tc,0)+nvl(ppr.subprj_eqpmt_act_cost_tc,0))
4920: into l_act_cost_pub
4921: from pa_progress_rollup ppr,pa_percent_completes ppc
4922: where ppr.project_id = ppc.project_id
4923: and ppr.object_id = ppc.object_id
4924: and ppr.object_version_id = ppc.object_version_id
4925: and ppr.as_of_date = ppc.date_computed (+)

Line 5025: FROM pa_progress_rollup ppr

5021: (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0))--+nvl(ppr.oth_quantity_to_date,0))Oth quantity is not required as it can be in diffrent UOM
5022: +nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0) act_effort,
5023: (nvl(ppr.estimated_remaining_effort,0)+nvl(ppr.eqpmt_etc_effort,0))--+nvl(ppr.oth_etc_quantity,0))Oth quantity is not required as it can be in diffrent UOM
5024: +nvl(ppr.subprj_ppl_etc_effort,0)+nvl(ppr.subprj_eqpmt_etc_effort,0) etc_effort
5025: FROM pa_progress_rollup ppr
5026: WHERE ppr.project_id = p_project_id
5027: AND ppr.object_id = p_object_id
5028: AND ppr.object_type = p_object_type
5029: AND ppr.structure_version_id = p_structure_version_id

Line 5062: FROM pa_progress_rollup ppr

5058: (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0))--+nvl(ppr.oth_quantity_to_date,0))Oth quantity is not required as it can be in diffrent UOM
5059: +nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0) act_effort,
5060: (nvl(ppr.estimated_remaining_effort,0)+nvl(ppr.eqpmt_etc_effort,0))--+nvl(ppr.oth_etc_quantity,0))Oth quantity is not required as it can be in diffrent UOM
5061: +nvl(ppr.subprj_ppl_etc_effort,0)+nvl(ppr.subprj_eqpmt_etc_effort,0) etc_effort
5062: FROM pa_progress_rollup ppr
5063: WHERE ppr.project_id = p_project_id
5064: AND ppr.object_id = p_object_id
5065: AND ppr.object_type = p_object_type
5066: AND ppr.structure_version_id is null

Line 5072: FROM pa_progress_rollup ppr2

5068: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
5069: AND ppr.current_flag <> 'W' -- Bug 3879461
5070: AND trunc(as_of_date) = (
5071: SELECT trunc(max(as_of_date))
5072: FROM pa_progress_rollup ppr2
5073: WHERE ppr2.project_id = p_project_id
5074: AND ppr2.object_id = p_object_id
5075: AND ppr2.object_type = p_object_type
5076: AND ppr2.structure_version_id is null

Line 5185: from pa_progress_rollup ppr

5181:
5182: /*
5183: cursor c1 is
5184: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)+nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0)) act_cost_to_date
5185: from pa_progress_rollup ppr
5186: where ppr.project_id = p_project_id
5187: and ppr.object_id = p_object_id
5188: -- and ppr.object_version_id = p_object_version_id
5189: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5192: from pa_progress_rollup ppr2

5188: -- and ppr.object_version_id = p_object_version_id
5189: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
5190: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) --Modified for IB4 Progress CR.
5191: and ppr.as_of_date = (select max(ppr2.as_of_date)
5192: from pa_progress_rollup ppr2
5193: where ppr2.project_id = p_project_id
5194: and ppr2.object_id = p_object_id
5195: -- and ppr2.object_version_id = p_object_version_id
5196: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5204: from pa_progress_rollup ppr

5200: */
5201:
5202: cursor c_prev_prog_rec is
5203: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)+nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0)) act_cost_to_date
5204: from pa_progress_rollup ppr
5205: where ppr.project_id = p_project_id
5206: and ppr.object_id = p_object_id
5207: -- and ppr.object_version_id = p_object_version_id
5208: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5212: from pa_progress_rollup ppr2

5208: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5209: and ppr.structure_version_id is null -- Bug 3764224
5210: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
5211: and ppr.as_of_date = (select max(ppr2.as_of_date)
5212: from pa_progress_rollup ppr2
5213: where ppr2.project_id = p_project_id
5214: and ppr2.object_id = p_object_id
5215: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5216: and ppr2.structure_version_id is null -- Bug 3764224

Line 5222: from pa_progress_rollup ppr

5218: and ppr2.as_of_date < p_as_of_date);
5219:
5220: cursor c_this_prog_rec is
5221: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)+nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0)) act_cost_to_date
5222: from pa_progress_rollup ppr
5223: where ppr.project_id = p_project_id
5224: and ppr.object_id = p_object_id
5225: -- and ppr.object_version_id = p_object_version_id
5226: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5230: from pa_progress_rollup ppr2

5226: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5227: and ppr.structure_version_id is null -- Bug 3764224
5228: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
5229: and ppr.as_of_date = (select max(ppr2.as_of_date)
5230: from pa_progress_rollup ppr2
5231: where ppr2.project_id = p_project_id
5232: and ppr2.object_id = p_object_id
5233: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5234: and ppr2.structure_version_id is null -- Bug 3764224

Line 5249: from pa_progress_rollup ppr,pa_percent_completes ppc

5245: fetch c1 into l_c1rec;
5246: if c1%found then
5247: select (nvl(ppr.oth_act_cost_to_date_fc,0)+nvl(ppr.ppl_act_cost_to_date_fc,0)+nvl(ppr.eqpmt_act_cost_to_date_fc,0)+nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)+nvl(ppr.subprj_ppl_act_cost_fc,0)+nvl(ppr.subprj_eqpmt_act_cost_fc,0))
5248: into l_act_cost_pub
5249: from pa_progress_rollup ppr,pa_percent_completes ppc
5250: where ppr.project_id = ppc.project_id
5251: and ppr.object_id = ppc.object_id
5252: and ppr.object_version_id = ppc.object_version_id
5253: and ppr.as_of_date = ppc.date_computed (+)

Line 5311: from pa_progress_rollup ppr

5307:
5308: /*
5309: cursor c1 is
5310: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0)) act_effort_to_date
5311: from pa_progress_rollup ppr
5312: where ppr.project_id = p_project_id
5313: and ppr.object_id = p_object_id
5314: -- and ppr.object_version_id = p_object_version_id
5315: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5317: from pa_progress_rollup ppr2

5313: and ppr.object_id = p_object_id
5314: -- and ppr.object_version_id = p_object_version_id
5315: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5316: and ppr.as_of_date = (select max(ppr2.as_of_date)
5317: from pa_progress_rollup ppr2
5318: where ppr2.project_id = p_project_id
5319: and ppr2.object_id = p_object_id
5320: -- and ppr2.object_version_id = p_object_version_id
5321: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5327: from pa_progress_rollup ppr

5323: */
5324:
5325: cursor c_prev_prog_rec is
5326: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0)) act_effort_to_date
5327: from pa_progress_rollup ppr
5328: where ppr.project_id = p_project_id
5329: and ppr.object_id = p_object_id
5330: -- and ppr.object_version_id = p_object_version_id
5331: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 5338: from pa_progress_rollup ppr2

5334: and current_flag = 'Y'
5335: ;
5336: /* commented by maansari7/25
5337: and ppr.as_of_date = (select max(ppr2.as_of_date)
5338: from pa_progress_rollup ppr2
5339: where ppr2.project_id = p_project_id
5340: and ppr2.object_id = p_object_id
5341: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5342: and ppr2.structure_version_id is null -- Bug 3764224

Line 5349: from pa_progress_rollup ppr

5345: */
5346:
5347: cursor c_this_prog_rec is
5348: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0)) act_effort_to_date
5349: from pa_progress_rollup ppr
5350: -- Bug 3879461 : Now percent complete join is not required. current_flag = W can be used
5351: -- ,pa_percent_completes ppc
5352: where ppr.project_id = p_project_id
5353: and ppr.object_id = p_object_id

Line 5370: from pa_progress_rollup ppr2

5366: and ppr.current_flag= 'W'
5367: ;
5368: /* commented by maansari7/25
5369: and ppr.as_of_date = (select max(ppr2.as_of_date)
5370: from pa_progress_rollup ppr2
5371: where ppr2.project_id = p_project_id
5372: and ppr2.object_id = p_object_id
5373: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
5374: and ppr2.structure_version_id is null -- Bug 3764224

Line 5386: -- from pa_progress_rollup ppr,pa_percent_completes ppc

5382: -- Bug 3764224 : RLM Changes : This code is commented, the earlier cusrsor code c1 was fine expept instead of greater than it should have been less than sign
5383: -- cursor cur_effort_this_period
5384: -- is
5385: -- select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
5386: -- from pa_progress_rollup ppr,pa_percent_completes ppc
5387: -- where ppr.project_id = ppc.project_id
5388: -- and ppr.object_id = ppc.object_id
5389: -- and ppr.as_of_date = ppc.date_computed
5390: -- and ppr.project_id = p_project_id

Line 5412: from pa_progress_rollup ppr,pa_percent_completes ppc

5408: fetch c1 into l_c1rec;
5409: if c1%found then
5410: select (nvl(ppr.ppl_act_effort_to_date,0)+nvl(ppr.eqpmt_act_effort_to_date,0)+nvl(ppr.subprj_ppl_act_effort,0)+nvl(ppr.subprj_eqpmt_act_effort,0)+nvl(ppr.oth_quantity_to_date,0))
5411: into l_act_effort_pub
5412: from pa_progress_rollup ppr,pa_percent_completes ppc
5413: where ppr.project_id = ppc.project_id
5414: and ppr.object_id = ppc.object_id
5415: and ppr.object_version_id = ppc.object_version_id
5416: and ppr.as_of_date = ppc.date_computed (+)

Line 5492: from pa_progress_rollup ppr

5488: and ppevs.element_version_id = p_structure_version_id
5489: and ppevs.date_prog_applied_on_wver < (select max(l_update_date)
5490: from (
5491: select max(last_update_date) l_update_date
5492: from pa_progress_rollup ppr
5493: where ppr.project_id = p_project_id
5494: and object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')
5495: and structure_type = 'WORKPLAN'
5496: and current_flag = 'Y'

Line 5512: from pa_progress_rollup ppr

5508: where ppevs.project_id = p_project_id
5509: and ppevs.element_version_id = p_structure_version_id
5510: and ppevs.date_prog_applied_on_wver is null
5511: and exists (select '1'
5512: from pa_progress_rollup ppr
5513: where ppr.project_id = p_project_id
5514: and object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')
5515: and structure_type = 'WORKPLAN'
5516: and current_flag = 'Y'

Line 5559: FROM pa_progress_rollup ppr

5555: If nvl(l_program_flag,'N') = 'Y' then
5556: SELECT
5557: MAX(ppr.last_update_date)
5558: INTO l_last_update_date
5559: FROM pa_progress_rollup ppr
5560: WHERE ppr.project_id = p_project_id
5561: AND ppr.object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')
5562: AND ppr.structure_type = 'WORKPLAN'
5563: AND ppr.current_flag = 'Y'

Line 5569: FROM pa_progress_rollup ppr, pa_proj_elem_ver_structure ppevs

5565: else
5566: SELECT
5567: MAX(ppr.last_update_date)
5568: INTO l_last_update_date
5569: FROM pa_progress_rollup ppr, pa_proj_elem_ver_structure ppevs
5570: WHERE ppr.project_id = p_project_id
5571: AND ppr.object_id = ppevs.PROJ_ELEMENT_ID
5572: AND ppr.object_type ='PA_STRUCTURES'
5573: AND ppr.structure_type = 'WORKPLAN'

Line 5612: FROM pa_progress_rollup ppr

5608: SELECT 'N'
5609: INTO l_return_value
5610: FROM DUAL
5611: WHERE EXISTS ( SELECT '1'
5612: FROM pa_progress_rollup ppr
5613: WHERE ppr.project_id = p_project_id
5614: AND object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')
5615: AND structure_type = 'WORKPLAN'
5616: AND current_flag = 'Y'

Line 5874: from pa_progress_rollup ppr

5870: l_return_status VARCHAR2(1) := 'N';
5871: -- FPM Dev CR 7 : Note that p_proj_element_id is not needed, but keeping it to avoid impacts to other code
5872: CURSOR myCursor is
5873: select 'Y'
5874: from pa_progress_rollup ppr
5875: where ppr.project_id = p_project_id
5876: and ppr.object_id = p_object_id
5877: and ppr.object_type = p_object_type
5878: and ppr.structure_type = p_structure_type

Line 5886: from pa_progress_rollup ppr

5882: ;
5883:
5884: CURSOR myCursor_pub is
5885: select 'Y'
5886: from pa_progress_rollup ppr
5887: where ppr.project_id = p_project_id
5888: and ppr.object_id = p_object_id
5889: and ppr.object_type = p_object_type
5890: and ppr.structure_type = p_structure_type

Line 6003: From PA_Progress_Rollup

5999: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6000: 'FINANCIAL_PLANNING',
6001: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6002: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6003: From PA_Progress_Rollup
6004: Where Project_ID = P_Project_ID
6005: AND Object_ID = P_Proj_Element_ID
6006: AND Object_Type = p_object_type
6007: AND current_flag <> 'W' --bug 3879461

Line 6008: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

6004: Where Project_ID = P_Project_ID
6005: AND Object_ID = P_Proj_Element_ID
6006: AND Object_Type = p_object_type
6007: AND current_flag <> 'W' --bug 3879461
6008: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup
6009: where Project_ID = P_Project_ID
6010: AND Object_ID = P_Proj_Element_ID
6011: AND Object_Type = p_object_type
6012: AND structure_version_id IS NULL

Line 6029: From PA_Progress_Rollup

6025: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6026: 'FINANCIAL_PLANNING',
6027: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6028: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6029: From PA_Progress_Rollup
6030: Where Project_ID = P_Project_ID
6031: AND Object_Type = p_object_type
6032: AND current_flag <> 'W' --bug 3879461
6033: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

Line 6033: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

6029: From PA_Progress_Rollup
6030: Where Project_ID = P_Project_ID
6031: AND Object_Type = p_object_type
6032: AND current_flag <> 'W' --bug 3879461
6033: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup
6034: where Project_ID = P_Project_ID
6035: AND Object_Type = p_object_type
6036: AND structure_version_id IS NULL
6037: AND current_flag <> 'W' --bug 3879461

Line 6055: From PA_Progress_Rollup

6051: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6052: 'FINANCIAL_PLANNING',
6053: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6054: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6055: From PA_Progress_Rollup
6056: Where Project_ID = P_Project_ID
6057: AND Object_ID = P_Proj_Element_ID
6058: AND Object_Type = p_object_type
6059: AND current_flag = 'W' --bug 3879461

Line 6060: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

6056: Where Project_ID = P_Project_ID
6057: AND Object_ID = P_Proj_Element_ID
6058: AND Object_Type = p_object_type
6059: AND current_flag = 'W' --bug 3879461
6060: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup
6061: where Project_ID = P_Project_ID
6062: AND Object_ID = P_Proj_Element_ID
6063: AND Object_Type = p_object_type
6064: AND structure_version_id IS NULL

Line 6081: From PA_Progress_Rollup

6077: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6078: 'FINANCIAL_PLANNING',
6079: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6080: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6081: From PA_Progress_Rollup
6082: Where Project_ID = P_Project_ID
6083: AND Object_Type = p_object_type
6084: AND current_flag = 'W' --bug 3879461
6085: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

Line 6085: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup

6081: From PA_Progress_Rollup
6082: Where Project_ID = P_Project_ID
6083: AND Object_Type = p_object_type
6084: AND current_flag = 'W' --bug 3879461
6085: AND As_Of_Date = ( select max(As_Of_Date) from pa_progress_rollup
6086: where Project_ID = P_Project_ID
6087: AND Object_Type = p_object_type
6088: AND structure_version_id IS NULL
6089: AND current_flag = 'W' --bug 3879461

Line 6110: From PA_Progress_Rollup

6106: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6107: 'FINANCIAL_PLANNING',
6108: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6109: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6110: From PA_Progress_Rollup
6111: Where Project_ID = P_Project_ID
6112: AND Object_ID = P_Proj_Element_ID
6113: AND Object_Type = p_object_type
6114: --AND As_Of_Date = p_As_Of_Date

Line 6128: From PA_Progress_Rollup

6124: Select decode( p_calling_context, 'PROGRESS', NVL(EFF_ROLLUP_PERCENT_COMP,completed_percentage),
6125: 'FINANCIAL_PLANNING',
6126: decode(p_structure_type, 'FINANCIAL', NVL(completed_percentage,EFF_ROLLUP_PERCENT_COMP)
6127: , NVL(completed_percentage,BASE_PERCENT_COMPLETE)))
6128: From PA_Progress_Rollup
6129: Where Project_ID = P_Project_ID
6130: AND Object_Type = p_object_type
6131: --AND As_Of_Date = p_As_Of_Date
6132: AND structure_version_id = p_structure_version_id

Line 6327: From PA_Progress_Rollup

6323:
6324: --Select (l_Planned_Amount*P_Overide_Percent_Complete)/100
6325: /*
6326: INTO x_BCWP -- Earned Value
6327: From PA_Progress_Rollup
6328: Where Project_ID = P_Project_ID
6329: AND Proj_Element_ID = P_Proj_Element_ID
6330: AND object_id = P_Proj_Element_ID
6331: --AND Object_Type = 'PA_ASSIGNMENTS'

Line 6505: FROM PA_Progress_Rollup

6501: IS
6502: Cursor CUR_Est_Sch_Dates
6503: IS
6504: Select MIN(Estimated_Start_Date), MAX(Estimated_Finish_Date), MIN(Actual_Start_Date), MAX(Actual_Finish_Date)
6505: FROM PA_Progress_Rollup
6506: Where Project_ID = P_Project_ID
6507: AND Proj_Element_ID = P_Proj_Element_ID
6508: AND Object_Type = 'PA_ASSIGNMENTS'
6509: AND As_Of_Date = p_As_Of_Date

Line 6902: from pa_progress_rollup

6898: l_rollup_date date;
6899: CURSOR cur_rollupdate
6900: IS
6901: select max(as_of_date)
6902: from pa_progress_rollup
6903: where project_id = p_project_id
6904: and object_id = p_object_id
6905: and object_type = p_object_type
6906: and structure_type = p_structure_type -- FPM Dev CR 4

Line 7139: from pa_progress_rollup ppr1

7135: eqpmt_act_effort_to_date, ppl_act_cost_to_date_tc, eqpmt_act_cost_to_date_tc, oth_act_cost_to_date_tc,
7136: txn_currency_code, ppl_act_rawcost_to_date_pc, eqpmt_act_rawcost_to_date_pc, oth_act_rawcost_to_date_pc,
7137: ppl_act_rawcost_to_date_fc, eqpmt_act_rawcost_to_date_fc, oth_act_rawcost_to_date_fc,
7138: ppl_act_rawcost_to_date_tc, eqpmt_act_rawcost_to_date_tc, oth_act_rawcost_to_date_tc, oth_quantity_to_date
7139: from pa_progress_rollup ppr1
7140: where ppr1.project_id = p_project_id
7141: and ppr1.object_id = p_object_id
7142: and ppr1.structure_version_id is null
7143: AND ppr1.current_flag <> 'W' -- Bug 3879461

Line 7145: from pa_progress_rollup ppr2

7141: and ppr1.object_id = p_object_id
7142: and ppr1.structure_version_id is null
7143: AND ppr1.current_flag <> 'W' -- Bug 3879461
7144: and ppr1.as_of_date = ( SELECT max(ppr2.as_of_date)
7145: from pa_progress_rollup ppr2
7146: WHERE ppr2.as_of_date <= p_as_of_date
7147: AND ppr2.object_id = p_object_id
7148: AND ppr2.project_id = p_project_id
7149: and ppr2.structure_type = 'WORKPLAN'

Line 7163: from pa_progress_rollup ppr1

7159: eqpmt_act_effort_to_date, ppl_act_cost_to_date_tc, eqpmt_act_cost_to_date_tc, oth_act_cost_to_date_tc,
7160: txn_currency_code, ppl_act_rawcost_to_date_pc, eqpmt_act_rawcost_to_date_pc, oth_act_rawcost_to_date_pc,
7161: ppl_act_rawcost_to_date_fc, eqpmt_act_rawcost_to_date_fc, oth_act_rawcost_to_date_fc,
7162: ppl_act_rawcost_to_date_tc, eqpmt_act_rawcost_to_date_tc, oth_act_rawcost_to_date_tc, oth_quantity_to_date
7163: from pa_progress_rollup ppr1
7164: where ppr1.project_id = p_project_id
7165: and ppr1.object_id = p_object_id
7166: and ppr1.proj_element_id = p_proj_element_id
7167: and ppr1.structure_version_id is null

Line 7170: from pa_progress_rollup ppr2

7166: and ppr1.proj_element_id = p_proj_element_id
7167: and ppr1.structure_version_id is null
7168: AND ppr1.current_flag <> 'W' -- Bug 3879461
7169: and ppr1.as_of_date = ( SELECT max(ppr2.as_of_date)
7170: from pa_progress_rollup ppr2
7171: WHERE ppr2.as_of_date <= p_as_of_date
7172: AND ppr2.object_id = p_object_id
7173: AND ppr2.proj_element_id = p_proj_element_id
7174: AND ppr2.project_id = p_project_id

Line 7206: from pa_progress_rollup ppr1

7202: cursor c1_proj_level IS
7203: select cumulative_work_quantity, ppl_act_cost_to_date_pc, eqpmt_act_cost_to_date_pc, oth_act_cost_to_date_pc,
7204: ppl_act_cost_to_date_fc, eqpmt_act_cost_to_date_fc, oth_act_cost_to_date_fc, ppl_act_effort_to_date,
7205: eqpmt_act_effort_to_date
7206: from pa_progress_rollup ppr1
7207: where ppr1.project_id = p_project_id
7208: and ppr1.object_type = 'PA_STRUCTURES'
7209: and ppr1.structure_version_id is null
7210: AND ppr1.current_flag <> 'W' -- Bug 3879461

Line 7212: from pa_progress_rollup ppr2

7208: and ppr1.object_type = 'PA_STRUCTURES'
7209: and ppr1.structure_version_id is null
7210: AND ppr1.current_flag <> 'W' -- Bug 3879461
7211: and ppr1.as_of_date = ( SELECT max(ppr2.as_of_date)
7212: from pa_progress_rollup ppr2
7213: WHERE ppr2.as_of_date <= p_as_of_date
7214: AND ppr2.object_type = 'PA_STRUCTURES'
7215: AND ppr2.project_id = p_project_id
7216: and ppr2.structure_type = 'WORKPLAN'

Line 7472: FROM pa_progress_rollup

7468:
7469: CURSOR cur_task_etc_effort
7470: IS
7471: SELECT NVL( ESTIMATED_REMAINING_EFFORT, 0 ) + NVL( EQPMT_ETC_EFFORT, 0 )
7472: FROM pa_progress_rollup
7473: WHERE project_id = p_project_id
7474: AND object_id = p_object_id
7475: and proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7476: --Commented by rtarway for BUG 3835474

Line 7478: from pa_progress_rollup

7474: AND object_id = p_object_id
7475: and proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7476: --Commented by rtarway for BUG 3835474
7477: /*AND as_of_date = ( SELECT max(as_of_date)
7478: from pa_progress_rollup
7479: WHERE as_of_date < p_as_of_date
7480: AND project_id = p_project_id
7481: AND object_id = p_object_id
7482: AND object_type = p_object_type

Line 7488: from pa_progress_rollup ppr2

7484: and proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR.
7485: )*/
7486: --Added by rtarway for BUG 3835474
7487: AND as_of_date = ( SELECT max(as_of_date)
7488: from pa_progress_rollup ppr2
7489: WHERE ppr2.as_of_date <= p_as_of_date
7490: AND ppr2.project_id = p_project_id
7491: AND ppr2.object_id = p_object_id
7492: AND ppr2.object_type = p_object_type

Line 7535: FROM pa_progress_rollup ppr

7531:
7532: CURSOR cur_task_etc_cost
7533: IS
7534: SELECT (nvl(ppr.oth_etc_cost_tc,0)+nvl(ppr.ppl_etc_cost_tc,0)+nvl(ppr.eqpmt_etc_cost_tc,0))
7535: FROM pa_progress_rollup ppr
7536: WHERE ppr.project_id = p_project_id
7537: AND ppr.object_id = p_object_id
7538: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7539: AND ppr.as_of_date = ( SELECT max(as_of_date)

Line 7540: from pa_progress_rollup ppr2

7536: WHERE ppr.project_id = p_project_id
7537: AND ppr.object_id = p_object_id
7538: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7539: AND ppr.as_of_date = ( SELECT max(as_of_date)
7540: from pa_progress_rollup ppr2
7541: WHERE ppr2.as_of_date < p_as_of_date
7542: AND ppr2.project_id = p_project_id
7543: AND ppr2.object_id = p_object_id
7544: AND ppr2.object_type = p_object_type

Line 7599: FROM pa_progress_rollup ppr

7595: ,(nvl(ppr.oth_etc_cost_tc,0)+nvl(ppr.ppl_etc_cost_tc,0)+nvl(ppr.eqpmt_etc_cost_tc,0)) etc_txn_bur_cost_last_subm
7596: ,(nvl(ppr.oth_etc_cost_pc,0)+nvl(ppr.ppl_etc_cost_pc,0)+nvl(ppr.eqpmt_etc_cost_pc,0)) etc_prj_bur_cost_last_subm
7597: ,(nvl(ppr.oth_etc_cost_fc,0)+nvl(ppr.ppl_etc_cost_fc,0)+nvl(ppr.eqpmt_etc_cost_fc,0)) etc_pfc_bur_cost_last_subm
7598: , (NVL( ESTIMATED_REMAINING_EFFORT, 0 ) + NVL( EQPMT_ETC_EFFORT, 0 )) etc_effort_last_subm
7599: FROM pa_progress_rollup ppr
7600: WHERE ppr.project_id = p_project_id
7601: AND ppr.object_id = p_object_id
7602: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id)
7603: --Commented by rtarway for BUG 3835474

Line 7605: -- from pa_progress_rollup ppr2

7601: AND ppr.object_id = p_object_id
7602: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id)
7603: --Commented by rtarway for BUG 3835474
7604: --AND ppr.as_of_date = ( SELECT max(as_of_date)
7605: -- from pa_progress_rollup ppr2
7606: -- WHERE ppr2.as_of_date < p_as_of_date
7607: -- AND ppr2.project_id = p_project_id
7608: -- AND ppr2.object_id = p_object_id
7609: -- AND ppr2.object_type = p_object_type

Line 7615: from pa_progress_rollup ppr2

7611: --and ppr2.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Modified for IB4 Progress CR.
7612: -- )
7613: --Added by rtarway for BUG 3835474
7614: AND ppr.as_of_date = ( SELECT max(as_of_date)
7615: from pa_progress_rollup ppr2
7616: WHERE ppr2.as_of_date <= p_as_of_date
7617: AND ppr2.project_id = p_project_id
7618: AND ppr2.object_id = p_object_id
7619: AND ppr2.object_type = p_object_type

Line 7704: FROM pa_progress_rollup ppr

7700: ,ppr.oth_etc_cost_fc ) etc_pfc_bur_cost_last_subm
7701: ,decode(p_resource_class_code, 'PEOPLE', ESTIMATED_REMAINING_EFFORT
7702: ,'EQUIPMENT', EQPMT_ETC_EFFORT
7703: , ppr.OTH_ETC_QUANTITY) etc_effort_last_subm
7704: FROM pa_progress_rollup ppr
7705: WHERE ppr.project_id = p_project_id
7706: AND ppr.object_id = p_object_id
7707: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7708: AND ppr.as_of_date = ( SELECT max(as_of_date)

Line 7709: from pa_progress_rollup ppr2

7705: WHERE ppr.project_id = p_project_id
7706: AND ppr.object_id = p_object_id
7707: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) /* Modified for IB4 Progress CR. */
7708: AND ppr.as_of_date = ( SELECT max(as_of_date)
7709: from pa_progress_rollup ppr2
7710: WHERE ppr2.as_of_date <= p_as_of_date--Added eqaulity condition, 4091457, rtarway
7711: AND ppr2.project_id = p_project_id
7712: AND ppr2.object_id = p_object_id
7713: AND ppr2.object_type = p_object_type

Line 7829: from pa_progress_rollup ppr

7825: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7826: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
7827: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7828: act_rawcost_to_date
7829: from pa_progress_rollup ppr
7830: where ppr.project_id = p_project_id
7831: and ppr.object_id = p_object_id
7832: -- and ppr.object_version_id = p_object_version_id
7833: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7836: from pa_progress_rollup ppr2

7832: -- and ppr.object_version_id = p_object_version_id
7833: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
7834: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id)-- Modified for IB4 Progress CR.
7835: and ppr.as_of_date = (select max(ppr2.as_of_date)
7836: from pa_progress_rollup ppr2
7837: where ppr2.project_id = p_project_id
7838: and ppr2.object_id = p_object_id
7839: -- and ppr2.object_version_id = p_object_version_id
7840: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7851: from pa_progress_rollup ppr

7847: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7848: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
7849: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7850: act_rawcost_to_date
7851: from pa_progress_rollup ppr
7852: where ppr.project_id = p_project_id
7853: and ppr.object_id = p_object_id
7854: -- and ppr.object_version_id = p_object_version_id
7855: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7859: from pa_progress_rollup ppr2

7855: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7856: and ppr.structure_version_id is null -- Bug 3764224
7857: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
7858: and ppr.as_of_date = (select max(ppr2.as_of_date)
7859: from pa_progress_rollup ppr2
7860: where ppr2.project_id = p_project_id
7861: and ppr2.object_id = p_object_id
7862: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7863: and ppr2.structure_version_id is null -- Bug 3764224

Line 7872: from pa_progress_rollup ppr

7868: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7869: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
7870: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7871: act_rawcost_to_date
7872: from pa_progress_rollup ppr
7873: where ppr.project_id = p_project_id
7874: and ppr.object_id = p_object_id
7875: -- and ppr.object_version_id = p_object_version_id
7876: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7880: from pa_progress_rollup ppr2

7876: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7877: and ppr.structure_version_id is null -- Bug 3764224
7878: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
7879: and ppr.as_of_date = (select max(ppr2.as_of_date)
7880: from pa_progress_rollup ppr2
7881: where ppr2.project_id = p_project_id
7882: and ppr2.object_id = p_object_id
7883: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
7884: and ppr2.structure_version_id is null -- Bug 3764224

Line 7901: from pa_progress_rollup ppr,pa_percent_completes ppc

7897: select (nvl(ppr.oth_act_rawcost_to_date_pc,0)+nvl(ppr.ppl_act_rawcost_to_date_pc,0)
7898: +nvl(ppr.eqpmt_act_rawcost_to_date_pc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_PC,0)
7899: +nvl(ppr.subprj_ppl_act_rawcost_pc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_pc,0))
7900: into l_act_rawcost_pub
7901: from pa_progress_rollup ppr,pa_percent_completes ppc
7902: where ppr.project_id = ppc.project_id
7903: and ppr.object_id = ppc.object_id
7904: and ppr.object_version_id = ppc.object_version_id
7905: and ppr.as_of_date = ppc.date_computed (+)

Line 7968: from pa_progress_rollup ppr

7964: cursor c1 is
7965: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
7966: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
7967: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
7968: from pa_progress_rollup ppr
7969: where ppr.project_id = p_project_id
7970: and ppr.object_id = p_object_id
7971: -- and ppr.object_version_id = p_object_version_id
7972: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7974: from pa_progress_rollup ppr2

7970: and ppr.object_id = p_object_id
7971: -- and ppr.object_version_id = p_object_version_id
7972: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
7973: and ppr.as_of_date = (select max(ppr2.as_of_date)
7974: from pa_progress_rollup ppr2
7975: where ppr2.project_id = p_project_id
7976: and ppr2.object_id = p_object_id
7977: -- and ppr2.object_version_id = p_object_version_id
7978: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 7989: from pa_progress_rollup ppr,pa_percent_completes ppc

7985: is
7986: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
7987: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
7988: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
7989: from pa_progress_rollup ppr,pa_percent_completes ppc
7990: where ppr.project_id = ppc.project_id
7991: and ppr.object_id = ppc.object_id
7992: and ppr.as_of_date = ppc.date_computed
7993: and ppr.project_id = p_project_id

Line 8010: from pa_progress_rollup ppr

8006: cursor c_prev_prog_rec is
8007: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8008: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
8009: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
8010: from pa_progress_rollup ppr
8011: where ppr.project_id = p_project_id
8012: and ppr.object_id = p_object_id
8013: -- and ppr.object_version_id = p_object_version_id
8014: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8026: from pa_progress_rollup ppr

8022: cursor c_prev_prog_rec is
8023: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8024: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
8025: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
8026: from pa_progress_rollup ppr
8027: where ppr.project_id = p_project_id
8028: and ppr.object_id = p_object_id
8029: -- and ppr.object_version_id = p_object_version_id
8030: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8034: from pa_progress_rollup ppr2

8030: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8031: and ppr.structure_version_id is null -- Bug 3764224
8032: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
8033: and ppr.as_of_date = (select max(ppr2.as_of_date)
8034: from pa_progress_rollup ppr2
8035: where ppr2.project_id = p_project_id
8036: and ppr2.object_id = p_object_id
8037: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8038: and ppr2.structure_version_id is null -- Bug 3764224

Line 8048: from pa_progress_rollup ppr

8044: cursor c_this_prog_rec is
8045: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8046: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
8047: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
8048: from pa_progress_rollup ppr
8049: where ppr.project_id = p_project_id
8050: and ppr.object_id = p_object_id
8051: -- and ppr.object_version_id = p_object_version_id
8052: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8056: from pa_progress_rollup ppr2

8052: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8053: and ppr.structure_version_id is null -- Bug 3764224
8054: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
8055: and ppr.as_of_date = (select max(ppr2.as_of_date)
8056: from pa_progress_rollup ppr2
8057: where ppr2.project_id = p_project_id
8058: and ppr2.object_id = p_object_id
8059: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8060: and ppr2.structure_version_id is null -- Bug 3764224

Line 8069: from pa_progress_rollup ppr

8065: cursor c_this_prog_rec is
8066: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8067: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
8068: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_rawcost_to_date
8069: from pa_progress_rollup ppr
8070: -- Bug 3879461 : percemnt compete join is not required. current_flag = W is sufficient
8071: -- ,pa_percent_completes ppc
8072: where ppr.project_id = p_project_id
8073: and ppr.object_id = p_object_id

Line 8105: from pa_progress_rollup ppr,pa_percent_completes ppc

8101: select (nvl(ppr.oth_act_rawcost_to_date_tc,0)+nvl(ppr.ppl_act_rawcost_to_date_tc,0)
8102: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
8103: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_tc,0))
8104: into l_act_rawcost_pub
8105: from pa_progress_rollup ppr,pa_percent_completes ppc
8106: where ppr.project_id = ppc.project_id
8107: and ppr.object_id = ppc.object_id
8108: and ppr.object_version_id = ppc.object_version_id
8109: and ppr.as_of_date = ppc.date_computed (+)

Line 8193: from pa_progress_rollup ppr

8189: cursor c1 is
8190: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8191: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
8192: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0)) act_rawcost_to_date
8193: from pa_progress_rollup ppr
8194: where ppr.project_id = p_project_id
8195: and ppr.object_id = p_object_id
8196: -- and ppr.object_version_id = p_object_version_id
8197: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Modified for IB4 Progress CR.

Line 8200: from pa_progress_rollup ppr2

8196: -- and ppr.object_version_id = p_object_version_id
8197: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Modified for IB4 Progress CR.
8198: and structure_type = 'WORKPLAN' -- FPM Dev CR 3
8199: and ppr.as_of_date = (select max(ppr2.as_of_date)
8200: from pa_progress_rollup ppr2
8201: where ppr2.project_id = p_project_id
8202: and ppr2.object_id = p_object_id
8203: -- and ppr2.object_version_id = p_object_version_id
8204: and structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8214: from pa_progress_rollup ppr

8210: cursor c_prev_prog_rec is
8211: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8212: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
8213: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0)) act_rawcost_to_date
8214: from pa_progress_rollup ppr
8215: where ppr.project_id = p_project_id
8216: and ppr.object_id = p_object_id
8217: -- and ppr.object_version_id = p_object_version_id
8218: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8222: from pa_progress_rollup ppr2

8218: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8219: and ppr.structure_version_id is null -- Bug 3764224
8220: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
8221: and ppr.as_of_date = (select max(ppr2.as_of_date)
8222: from pa_progress_rollup ppr2
8223: where ppr2.project_id = p_project_id
8224: and ppr2.object_id = p_object_id
8225: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8226: and ppr2.structure_version_id is null -- Bug 3764224

Line 8234: from pa_progress_rollup ppr

8230: cursor c_this_prog_rec is
8231: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8232: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
8233: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0)) act_rawcost_to_date
8234: from pa_progress_rollup ppr
8235: where ppr.project_id = p_project_id
8236: and ppr.object_id = p_object_id
8237: -- and ppr.object_version_id = p_object_version_id
8238: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3

Line 8242: from pa_progress_rollup ppr2

8238: and ppr.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8239: and ppr.structure_version_id is null -- Bug 3764224
8240: and ppr.proj_element_id = nvl(p_proj_element_id, p_object_id) -- Bug 3764224
8241: and ppr.as_of_date = (select max(ppr2.as_of_date)
8242: from pa_progress_rollup ppr2
8243: where ppr2.project_id = p_project_id
8244: and ppr2.object_id = p_object_id
8245: and ppr2.structure_type = 'WORKPLAN' -- FPM Dev CR 3
8246: and ppr2.structure_version_id is null -- Bug 3764224

Line 8265: from pa_progress_rollup ppr,pa_percent_completes ppc

8261: select (nvl(ppr.oth_act_rawcost_to_date_fc,0)+nvl(ppr.ppl_act_rawcost_to_date_fc,0)
8262: +nvl(ppr.eqpmt_act_rawcost_to_date_fc,0)+nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_FC,0)
8263: +nvl(ppr.subprj_ppl_act_rawcost_fc,0)+nvl(ppr.subprj_eqpmt_act_rawcost_fc,0))
8264: into l_act_rawcost_pub
8265: from pa_progress_rollup ppr,pa_percent_completes ppc
8266: where ppr.project_id = ppc.project_id
8267: and ppr.object_id = ppc.object_id
8268: and ppr.object_version_id = ppc.object_version_id
8269: and ppr.as_of_date = ppc.date_computed (+)

Line 10003: from pa_progress_rollup ppr

9999: l_last_submitted_perc_comp NUMBER ;
10000: Cursor c_get_last_submitted_perc_comp
10001: is
10002: select ppr.completed_percentage
10003: from pa_progress_rollup ppr
10004: where ppr.project_id = p_project_id
10005: and ppr.object_id = p_object_id
10006: and ppr.structure_type = 'WORKPLAN'
10007: and ppr.structure_version_id is null

Line 10013: from pa_progress_rollup ppr2

10009: and ppr.current_flag <> 'W' -- Bug 3879461
10010: and ppr.as_of_date =
10011: (
10012: select max(ppr2.as_of_date)
10013: from pa_progress_rollup ppr2
10014: where ppr2.project_id = p_project_id
10015: and ppr2.object_id = p_object_id
10016: and ppr2.structure_type = 'WORKPLAN'
10017: and ppr2.structure_version_id is null

Line 10149: pa_progress_rollup pr

10145: pa_proj_elements pe,
10146: pa_resource_assignments ra,
10147: pa_resource_list_members rlm,
10148: pa_budget_lines bl,
10149: pa_progress_rollup pr
10150: WHERE
10151: pev.parent_structure_version_id = p_struct_ver_id AND
10152: pe.proj_element_id = pev.proj_element_id AND
10153: ra.wbs_element_version_id = pev.element_version_id AND

Line 10290: pa_progress_rollup pr

10286: FROM
10287: pa_res_asgmts_temp rat,
10288: pa_resource_assignments ra,
10289: pa_proj_element_versions pev,
10290: pa_progress_rollup pr
10291: WHERE
10292: ra.resource_assignment_id = rat.resource_assignment_id AND
10293: pev.element_version_id = ra.wbs_element_version_id AND
10294: pr.project_id = ra.project_id AND

Line 10993: from pa_progress_rollup

10989: */
10990: --- Bug 4652132 always return latest as_of_date for the project/program.
10991: select as_of_date
10992: into l_prog_act_summ_date
10993: from pa_progress_rollup
10994: where project_id = p_project_id
10995: and object_type = 'PA_STRUCTURES'
10996: and structure_type = 'WORKPLAN'
10997: and structure_version_id is null

Line 11106: SELECT /+ INDEX(PA_PROGRESS_ROLLUP PA_PROGRESS_ROLLUP_N3)/ 'Y' --Added hint for 15876400

11102:
11103: CURSOR cur_ppr_assgn(c_object_id NUMBER, c_task_id NUMBER, c_object_type VARCHAR2
11104: , c_project_id NUMBER, c_structure_type VARCHAR2)
11105: IS
11106: SELECT /*+ INDEX(PA_PROGRESS_ROLLUP PA_PROGRESS_ROLLUP_N3)*/ 'Y' --Added hint for 15876400
11107: FROM pa_progress_rollup ppr
11108: WHERE ppr.object_id = c_object_id
11109: AND ppr.proj_element_id = c_task_id
11110: AND ppr.object_type = c_object_type

Line 11107: FROM pa_progress_rollup ppr

11103: CURSOR cur_ppr_assgn(c_object_id NUMBER, c_task_id NUMBER, c_object_type VARCHAR2
11104: , c_project_id NUMBER, c_structure_type VARCHAR2)
11105: IS
11106: SELECT /*+ INDEX(PA_PROGRESS_ROLLUP PA_PROGRESS_ROLLUP_N3)*/ 'Y' --Added hint for 15876400
11107: FROM pa_progress_rollup ppr
11108: WHERE ppr.object_id = c_object_id
11109: AND ppr.proj_element_id = c_task_id
11110: AND ppr.object_type = c_object_type
11111: AND ppr.project_id = c_project_id

Line 11144: SELECT /+ INDEX(PA_PROGRESS_ROLLUP PA_PROGRESS_ROLLUP_N3)/ 'Y' --Added hint for 15876400

11140:
11141: CURSOR cur_ppr_task(c_task_id NUMBER, c_object_type VARCHAR2
11142: , c_project_id NUMBER, c_structure_type VARCHAR2)
11143: IS
11144: SELECT /*+ INDEX(PA_PROGRESS_ROLLUP PA_PROGRESS_ROLLUP_N3)*/ 'Y' --Added hint for 15876400
11145: FROM pa_progress_rollup ppr
11146: WHERE ppr.proj_element_id = c_task_id
11147: AND ppr.object_type = c_object_type
11148: AND ppr.project_id = c_project_id

Line 11145: FROM pa_progress_rollup ppr

11141: CURSOR cur_ppr_task(c_task_id NUMBER, c_object_type VARCHAR2
11142: , c_project_id NUMBER, c_structure_type VARCHAR2)
11143: IS
11144: SELECT /*+ INDEX(PA_PROGRESS_ROLLUP PA_PROGRESS_ROLLUP_N3)*/ 'Y' --Added hint for 15876400
11145: FROM pa_progress_rollup ppr
11146: WHERE ppr.proj_element_id = c_task_id
11147: AND ppr.object_type = c_object_type
11148: AND ppr.project_id = c_project_id
11149: AND ppr.structure_type = p_structure_type

Line 11206: DELETE FROM pa_progress_rollup ppr

11202: -- the rollup records for the assignment.
11203:
11204: if ((l_return_value = 'N') and (p_delete_progress_flag = 'Y')) then -- fix for Bug # 4140984.
11205:
11206: DELETE FROM pa_progress_rollup ppr
11207: WHERE ppr.object_id = p_object_id
11208: AND ppr.proj_element_id = p_task_id
11209: AND ppr.object_type = p_object_type
11210: AND ppr.project_id = p_project_id

Line 11248: DELETE /+ INDEX(PA_PROGRESS_ROLLUP PA_PROGRESS_ROLLUP_N3)/ FROM pa_progress_rollup ppr --Added hint for 15876400

11244: -- on the latest published or working rollup records for all the assignments then
11245: -- delete all the rollup records for all the assignments for the given task.
11246:
11247: if ((l_return_value = 'N') and (p_delete_progress_flag = 'Y')) then -- Fix for Bug # 4140984.
11248: DELETE /*+ INDEX(PA_PROGRESS_ROLLUP PA_PROGRESS_ROLLUP_N3)*/ FROM pa_progress_rollup ppr --Added hint for 15876400
11249: WHERE ppr.proj_element_id = p_task_id
11250: AND ppr.object_type = 'PA_ASSIGNMENTS'
11251: AND ppr.project_id = p_project_id
11252: AND ppr.structure_type = p_structure_type;

Line 11732: , pa_progress_rollup ppr

11728: nvl(asgn.planned_bur_cost_proj_cur,0)
11729: ))) bac_value_in_task_deriv
11730: FROM
11731: pa_task_asgmts_v asgn
11732: , pa_progress_rollup ppr
11733: WHERE asgn.task_version_id = c_task_ver_id
11734: AND asgn.project_id = p_project_id ---4871809
11735: AND asgn.task_id = p_proj_element_id
11736: AND asgn.ta_display_flag = 'Y'

Line 11805: FROM pa_progress_rollup

11801: , c_structure_version_id NUMBER
11802: , c_as_of_date DATE)
11803: IS
11804: SELECT max(as_of_date)
11805: FROM pa_progress_rollup
11806: WHERE project_id = c_project_id
11807: AND object_id = c_object_id
11808: AND object_type = c_object_type
11809: AND structure_type = c_structure_type

Line 11824: FROM pa_progress_rollup ppr, pa_proj_element_versions ppev -- Bug # 4658185.

11820: , c_published_structure VARCHAR2
11821: , c_structure_version_id NUMBER)
11822: IS
11823: SELECT max(as_of_date)
11824: FROM pa_progress_rollup ppr, pa_proj_element_versions ppev -- Bug # 4658185.
11825: WHERE ppr.project_id = c_project_id
11826: AND ppr.object_id = c_object_id
11827: AND ppr.object_type = c_object_type
11828: AND ppr.structure_type = c_structure_type

Line 11848: FROM pa_progress_rollup ppr

11844: )
11845: IS
11846: SELECT nvl(ppr.completed_percentage,decode(nvl(c_program_flag,'Y'),'Y', ppr.eff_rollup_percent_comp, ppr.base_percent_complete))
11847: -- 4392189 : Program Reporting Changes - Phase 2 : Added Decode above
11848: FROM pa_progress_rollup ppr
11849: WHERE ppr.project_id = c_project_id
11850: and ppr.object_id = c_object_id
11851: and ppr.object_type = c_object_type
11852: and ppr.structure_type = c_structure_type

Line 11905: -- then use the max as_of_date in the pa_progress_rollup_table less than or equal to

11901: FETCH cur_check_published_version INTO l_published_structure;
11902: CLOSE cur_check_published_version;
11903:
11904: -- 2.1). If the input structure_type is 'FINANCIAL' and input as_of_date is not null
11905: -- then use the max as_of_date in the pa_progress_rollup_table less than or equal to
11906: -- the input as_of_date.
11907:
11908: if ((p_structure_type = 'FINANCIAL') and (p_as_of_date is not null)) then
11909:

Line 11916: -- 2.2). Else use the latest as_of_date in the pa_progress_rollup table for the

11912: , p_structure_version_id, p_as_of_date);
11913: fetch cur_max_as_of_date_leq into l_as_of_date;
11914: close cur_max_as_of_date_leq;
11915:
11916: -- 2.2). Else use the latest as_of_date in the pa_progress_rollup table for the
11917: -- given task or structure.
11918:
11919: else
11920:

Line 11931: -- from the pa_progress_rollup table for the above determined as_of_date.

11927: end if;
11928:
11929: -- 3.1). If the p_include_sub_tasks_flag = 'Y' or if the input proj_element_id
11930: -- is a structure_id then return the rolled-up percent complete for the task
11931: -- from the pa_progress_rollup table for the above determined as_of_date.
11932:
11933: if ((p_include_sub_tasks_flag = 'Y') or (p_object_type = 'PA_STRUCTURES')) then
11934:
11935: open cur_percent_comp(p_project_id, p_proj_element_id, p_object_type

Line 12028: from pa_progress_rollup ppr

12024: +nvl(ppr.eqpmt_act_effort_to_date,0)
12025: +nvl(ppr.subprj_ppl_act_effort,0)
12026: +nvl(ppr.subprj_eqpmt_act_effort,0)
12027: +nvl(ppr.oth_quantity_to_date,0)) act_effort_prev_asofdate
12028: from pa_progress_rollup ppr
12029: where ppr.project_id = p_project_id
12030: and ppr.object_id = p_object_id
12031: and ppr.structure_type = 'WORKPLAN'
12032: and ppr.proj_element_id = p_proj_element_id

Line 12036: from pa_progress_rollup ppr2

12032: and ppr.proj_element_id = p_proj_element_id
12033: and nvl(ppr.cbs_element_id,-1) = nvl(p_cbs_element_id,-1) --16820685
12034: and ppr.structure_version_id is null
12035: and ppr.as_of_date = (select max(ppr2.as_of_date)
12036: from pa_progress_rollup ppr2
12037: where ppr2.project_id = p_project_id
12038: and ppr2.object_id = p_object_id
12039: and ppr2.structure_type = 'WORKPLAN'
12040: and ppr2.proj_element_id = p_proj_element_id

Line 12058: from pa_progress_rollup ppr

12054: +nvl(ppr.eqpmt_act_cost_to_date_tc,0)
12055: +nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_TC,0)
12056: +nvl(ppr.subprj_ppl_act_cost_tc,0)
12057: +nvl(ppr.subprj_eqpmt_act_cost_tc,0)) act_bur_cost_tc_prev_asofdate
12058: from pa_progress_rollup ppr
12059: where ppr.project_id = p_project_id
12060: and ppr.object_id = p_object_id
12061: and ppr.structure_type = 'WORKPLAN'
12062: and ppr.proj_element_id = p_proj_element_id

Line 12066: from pa_progress_rollup ppr2

12062: and ppr.proj_element_id = p_proj_element_id
12063: and nvl(ppr.cbs_element_id,-1) = nvl(p_cbs_element_id,-1) --16820685
12064: and ppr.structure_version_id is null
12065: and ppr.as_of_date = (select max(ppr2.as_of_date)
12066: from pa_progress_rollup ppr2
12067: where ppr2.project_id = p_project_id
12068: and ppr2.object_id = p_object_id
12069: and ppr2.structure_type = 'WORKPLAN'
12070: and ppr2.proj_element_id = p_proj_element_id

Line 12086: from pa_progress_rollup ppr

12082: +nvl(ppr.eqpmt_act_cost_to_date_pc,0)
12083: +nvl(ppr.SUBPRJ_OTH_ACT_COST_TO_DT_FC,0)
12084: +nvl(ppr.subprj_ppl_act_cost_pc,0)
12085: +nvl(ppr.subprj_eqpmt_act_cost_pc,0)) act_bur_cost_pc_prev_asofdate
12086: from pa_progress_rollup ppr
12087: where ppr.project_id = p_project_id
12088: and ppr.object_id = p_object_id
12089: and ppr.structure_type = 'WORKPLAN'
12090: and ppr.proj_element_id = p_proj_element_id

Line 12094: from pa_progress_rollup ppr2

12090: and ppr.proj_element_id = p_proj_element_id
12091: and nvl(ppr.cbs_element_id,-1) = nvl(p_cbs_element_id,-1) --16820685
12092: and ppr.structure_version_id is null
12093: and ppr.as_of_date = (select max(ppr2.as_of_date)
12094: from pa_progress_rollup ppr2
12095: where ppr2.project_id = p_project_id
12096: and ppr2.object_id = p_object_id
12097: and ppr2.structure_type = 'WORKPLAN'
12098: and ppr2.proj_element_id = p_proj_element_id

Line 12115: from pa_progress_rollup ppr

12111: +nvl(ppr.eqpmt_act_rawcost_to_date_tc,0)
12112: +nvl(ppr.SPJ_OTH_ACT_RAWCOST_TO_DT_TC,0)
12113: +nvl(ppr.subprj_ppl_act_rawcost_tc,0)
12114: +nvl(ppr.subprj_eqpmt_act_rawcost_tc,0)) act_raw_cost_tc_prev_asofdate
12115: from pa_progress_rollup ppr
12116: where ppr.project_id = p_project_id
12117: and ppr.object_id = p_object_id
12118: and ppr.structure_type = 'WORKPLAN'
12119: and ppr.proj_element_id = p_proj_element_id

Line 12123: from pa_progress_rollup ppr2

12119: and ppr.proj_element_id = p_proj_element_id
12120: and nvl(ppr.cbs_element_id,-1) = nvl(p_cbs_element_id,-1) --16820685
12121: and ppr.structure_version_id is null
12122: and ppr.as_of_date = (select max(ppr2.as_of_date)
12123: from pa_progress_rollup ppr2
12124: where ppr2.project_id = p_project_id
12125: and ppr2.object_id = p_object_id
12126: and ppr2.structure_type = 'WORKPLAN'
12127: and ppr2.proj_element_id = p_proj_element_id

Line 12413: from pa_progress_rollup ppr

12409: select nvl(ppl_act_effort_to_date,0) asgn_act_eff
12410: ,nvl(ppl_act_cost_to_date_pc,0) asgn_act_cost
12411: ,nvl(estimated_remaining_effort,0) asgn_etc_eff
12412: ,nvl(ppl_etc_cost_pc,0) agn_etc_cost
12413: from pa_progress_rollup ppr
12414: where ppr.project_id = p_project_id
12415: and ppr.proj_element_id = p_proj_element_id
12416: and ppr.structure_type = 'WORKPLAN'
12417: and ppr.structure_version_id is null

Line 12523: FROM pa_progress_rollup

12519: p_chk_task IN varchar2 default 'Y',
12520: p_cbs_element_id in number :=null) return number is
12521: cursor get_work_prog_rollupid is
12522: select progress_rollup_id
12523: FROM pa_progress_rollup
12524: WHERE project_id = p_project_id
12525: AND object_id = p_object_id
12526: AND decode(p_chk_task,'Y',proj_element_id,p_task_id) = p_task_id
12527: AND object_type = p_object_type

Line 12537: from pa_progress_rollup ppr

12533: --16820685
12534:
12535: cursor get_pub_prog_rollupid is
12536: select progress_rollup_id
12537: from pa_progress_rollup ppr
12538: WHERE ppr.project_id = p_project_id
12539: AND ppr.object_id = p_object_id
12540: AND decode(p_chk_task,'Y',ppr.proj_element_id,p_task_id) = p_task_id
12541: AND ppr.object_type = p_object_Type

Line 12546: from pa_progress_rollup

12542: AND ppr.structure_type = 'WORKPLAN'
12543: AND ppr.structure_version_id is null
12544: and nvl(ppr.cbs_element_id,-1) = nvl(p_cbs_element_id,-1) --16820685
12545: AND ppr.as_of_date = (select max(as_of_date)
12546: from pa_progress_rollup
12547: where project_id = p_project_id
12548: AND object_id = p_object_id
12549: AND decode(p_chk_task,'Y',proj_element_id,p_task_id) = p_task_id
12550: AND object_type = p_object_Type

Line 12585: FROM pa_progress_rollup

12581: p_task_id IN number,
12582: p_chk_task IN varchar2 default 'N') return varchar2 is
12583: cursor get_w_pub_currflag is
12584: select current_flag
12585: FROM pa_progress_rollup
12586: WHERE project_id = p_project_id
12587: AND object_id = p_object_id
12588: AND object_type = p_object_type
12589: AND decode(p_chk_task,'Y',proj_element_id,nvl(p_task_id,-99)) = nvl(p_task_id,-99)

Line 12613: pa_progress_rollup ppr

12609: cursor C_TA_PROG_CURSOR is
12610: select 'Y'
12611: from
12612: pa_resource_assignments pra,
12613: pa_progress_rollup ppr
12614: where pra.ta_display_flag = 'N'
12615: and pra.wbs_element_version_id = p_element_ver_id
12616: and pra.project_id = p_project_id
12617: and ppr.project_id = p_project_id

Line 12646: -- Bug 7259306 - Outer join added to the inner inline view for all 6 cursors on pa_progress_rollup table.

12642: PROCEDURE get_plan_value(p_project_id number, p_structure_version_id number, p_element_id number, p_as_of_date date)
12643:
12644: IS
12645:
12646: -- Bug 7259306 - Outer join added to the inner inline view for all 6 cursors on pa_progress_rollup table.
12647:
12648: -- Working as of date
12649:
12650: --This cursor retrieves the accumulated amounts for the periods before each task before as of date period

Line 12672: from pa_progress_rollup ppr,

12668: PJI_TIME_CAL_PERIOD_V ptcpv,
12669: (
12670: select ppv.proj_element_id proj_element_id,
12671: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12672: from pa_progress_rollup ppr,
12673: pa_proj_element_versions ppv
12674: where ppv.parent_structure_version_id=p_structure_version_id
12675: and ppv.project_id=p_project_id
12676: and ppv.proj_element_id=p_proj_element_id

Line 12725: from pa_progress_rollup ppr,

12721: PJI_TIME_CAL_PERIOD_V ptcpv,
12722: (
12723: select ppv.proj_element_id proj_element_id,
12724: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12725: from pa_progress_rollup ppr,
12726: pa_proj_element_versions ppv
12727: where ppv.parent_structure_version_id=p_structure_version_id
12728: and ppv.project_id=p_project_id
12729: and ppv.proj_element_id=p_proj_element_id

Line 12779: from pa_progress_rollup ppr,

12775: PJI_TIME_CAL_PERIOD_V ptcpv,
12776: (
12777: select ppv.proj_element_id proj_element_id,
12778: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12779: from pa_progress_rollup ppr,
12780: pa_proj_element_versions ppv
12781: where ppv.parent_structure_version_id=p_structure_version_id
12782: and ppv.project_id=p_project_id
12783: and ppv.proj_element_id=p_proj_element_id

Line 12833: from pa_progress_rollup ppr,

12829: PJI_TIME_CAL_PERIOD_V ptcpv,
12830: (
12831: select ppv.proj_element_id proj_element_id,
12832: nvl(p_as_of_date,(ppr.as_of_date)) as_of_date
12833: from pa_progress_rollup ppr,
12834: pa_proj_element_versions ppv
12835: where ppv.parent_structure_version_id=p_structure_version_id
12836: and ppv.project_id=p_project_id
12837: and ppv.proj_element_id=p_proj_element_id

Line 12890: from pa_progress_rollup ppr,

12886: (
12887: select ppv.proj_element_id proj_element_id,
12888: max(ppv.parent_structure_version_id) parent_structure_id,
12889: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date
12890: from pa_progress_rollup ppr,
12891: pa_proj_element_versions ppv
12892: where ppv.parent_structure_version_id<=p_structure_version_id
12893: and ppv.project_id=p_project_id
12894: and ppv.proj_element_id=p_proj_element_id

Line 12945: from pa_progress_rollup ppr,

12941: (
12942: select ppv.proj_element_id proj_element_id,
12943: max(ppv.parent_structure_version_id) parent_structure_id,
12944: nvl(p_as_of_date,max(ppr.as_of_date)) as_of_date
12945: from pa_progress_rollup ppr,
12946: pa_proj_element_versions ppv
12947: where ppv.parent_structure_version_id<=p_structure_version_id
12948: and ppv.project_id=p_project_id
12949: and ppv.proj_element_id=p_proj_element_id

Line 13291: p_project_id pa_progress_rollup.project_id%TYPE,

13287: -- Bug 7259306
13288: -- Returns the date displayed in the Progress Report tab
13289: -- Cursor is based on the VO - ProgressAsOfDatesVO which is used to populate the 'as of date' poplist
13290: FUNCTION get_def_as_of_date_prog_report(
13291: p_project_id pa_progress_rollup.project_id%TYPE,
13292: p_proj_element_id pa_progress_rollup.proj_element_id%TYPE,
13293: p_object_type pa_progress_rollup.object_type%TYPE := 'PA_TASKS'
13294: ) RETURN DATE IS
13295: l_return_date DATE;

Line 13292: p_proj_element_id pa_progress_rollup.proj_element_id%TYPE,

13288: -- Returns the date displayed in the Progress Report tab
13289: -- Cursor is based on the VO - ProgressAsOfDatesVO which is used to populate the 'as of date' poplist
13290: FUNCTION get_def_as_of_date_prog_report(
13291: p_project_id pa_progress_rollup.project_id%TYPE,
13292: p_proj_element_id pa_progress_rollup.proj_element_id%TYPE,
13293: p_object_type pa_progress_rollup.object_type%TYPE := 'PA_TASKS'
13294: ) RETURN DATE IS
13295: l_return_date DATE;
13296:

Line 13293: p_object_type pa_progress_rollup.object_type%TYPE := 'PA_TASKS'

13289: -- Cursor is based on the VO - ProgressAsOfDatesVO which is used to populate the 'as of date' poplist
13290: FUNCTION get_def_as_of_date_prog_report(
13291: p_project_id pa_progress_rollup.project_id%TYPE,
13292: p_proj_element_id pa_progress_rollup.proj_element_id%TYPE,
13293: p_object_type pa_progress_rollup.object_type%TYPE := 'PA_TASKS'
13294: ) RETURN DATE IS
13295: l_return_date DATE;
13296:
13297: CURSOR cur_get_def_as_of_date

Line 13367: from pa_progress_rollup ppr,

13363:
13364: cursor get_act_eff_to_date is
13365: select decode(ptav.resource_class_code, 'PEOPLE', ppr.PPL_ACT_EFFORT_TO_DATE, 'EQUIPMENT', ppr.EQPMT_ACT_EFFORT_TO_DATE,
13366: ppr.oth_quantity_to_date)
13367: from pa_progress_rollup ppr,
13368: pa_task_asgmts_v ptav
13369: where ptav.project_id = p_project_id
13370: and ptav.task_id = p_proj_element_id
13371: and ptav.project_id = ppr.project_id

Line 13384: and not exists (select 1 from pa_progress_rollup ppc1 where ppc1.project_id = p_project_id

13380: and trunc(ppr.as_of_date) = trunc(p_as_of_date)
13381: and ppr.structure_type = 'WORKPLAN'
13382: and ppr.structure_version_id IS NULL
13383: and (nvl(ppr.current_flag,'N') = 'W' or (ppr.current_flag IN ('Y', 'N')
13384: and not exists (select 1 from pa_progress_rollup ppc1 where ppc1.project_id = p_project_id
13385: and ppc1.object_id = ptav.resource_list_member_id
13386: AND NVL(ppc1.cbs_element_id,-1) = NVL(p_cbs_element_id,-1) --Added for CBS phase 2 16200605
13387: and ppc1.proj_element_id = ptav.task_id and ppc1.object_Type = 'PA_ASSIGNMENTS'
13388: and ppc1.structure_type = 'WORKPLAN'

Line 13399: from pa_progress_rollup ppr

13395: +nvl(ppr.eqpmt_act_effort_to_date,0)
13396: +nvl(ppr.subprj_ppl_act_effort,0)
13397: +nvl(ppr.subprj_eqpmt_act_effort,0)
13398: +nvl(ppr.oth_quantity_to_date,0)) act_effort_prev_asofdate
13399: from pa_progress_rollup ppr
13400: where ppr.project_id = p_project_id
13401: and ppr.object_id = p_object_id
13402: AND NVL(ppr.cbs_element_id,-1) = NVL(p_cbs_element_id,-1) --Added for CBS phase 2 16200605
13403: and ppr.structure_type = 'WORKPLAN'

Line 13407: from pa_progress_rollup ppr2

13403: and ppr.structure_type = 'WORKPLAN'
13404: and ppr.proj_element_id = p_proj_element_id
13405: and ppr.structure_version_id is null
13406: and ppr.as_of_date = (select max(ppr2.as_of_date)
13407: from pa_progress_rollup ppr2
13408: where ppr2.project_id = p_project_id
13409: and ppr2.object_id = p_object_id
13410: AND NVL(ppr2.cbs_element_id,-1) = NVL(p_cbs_element_id,-1) --Added for CBS phase 2 16200605
13411: and ppr2.structure_type = 'WORKPLAN'