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_PVT dependencies on PA_PROGRESS_ROLLUP

Line 474: pa_progress_rollup ppr,

470: ,'N' create_required
471: ,'N' update_required
472: , ppr.base_percent_complete -- 4392189 : Program Reporting Changes - Phase 2
473: FROM pa_proj_element_versions ppev,
474: pa_progress_rollup ppr,
475: pa_project_statuses pps1,
476: pa_project_statuses pps2,
477: pa_project_statuses pps3 ,
478: pa_proj_rollup_temp temp

Line 597: pa_progress_rollup ppr,

593: FROM
594: pa_object_relationships pobj,
595: pa_proj_element_versions ppev1,
596: pa_proj_element_versions ppev2,
597: pa_progress_rollup ppr,
598: pa_proj_elements ppe,
599: pa_project_statuses pps1,
600: pa_project_statuses pps2,
601: pa_project_statuses pps3,

Line 892: FROM pa_progress_rollup ppr

888: ;
889:
890: CURSOR cur_get_asgn_progress(c_object_id NUMBER, c_proj_element_id NUMBER) IS
891: SELECT ppr.*
892: FROM pa_progress_rollup ppr
893: WHERE ppr.project_id = p_project_id
894: AND ppr.object_id = c_object_id
895: AND ppr.proj_element_id = c_proj_element_id
896: AND ppr.object_type = 'PA_ASSIGNMENTS'

Line 1051: pa_progress_rollup ppr

1047: ))
1048: ) bac_value_in_task_deriv
1049: FROM
1050: pa_task_asgmts_v asgn,
1051: pa_progress_rollup ppr
1052: WHERE asgn.task_version_id = c_task_ver_id
1053: AND asgn.project_id = ppr.project_id
1054: AND asgn.RESOURCE_LIST_MEMBER_ID = ppr.object_id -- Bug 3764224
1055: AND asgn.task_id = ppr.proj_element_id -- Bug 3764224

Line 1190: , pa_progress_rollup ppr

1186: , pps2.project_status_weight override_weight ---override progress status code
1187: , pps3.project_status_weight base_weight --base prog status
1188: FROM pa_proj_elements elem
1189: , pa_object_relationships obj
1190: , pa_progress_rollup ppr
1191: , pa_project_statuses pps2
1192: , pa_project_statuses pps3
1193: WHERE obj.object_id_from2= c_task_proj_elem_id
1194: AND obj.object_type_from = 'PA_TASKS'

Line 1281: , pa_progress_rollup ppr

1277: IS
1278: select ppr.as_of_date, ver2.proj_element_id child_task_id, ver2.element_version_id child_task_ver_id
1279: from pa_object_relationships obj
1280: , pa_proj_element_versions ver
1281: , pa_progress_rollup ppr
1282: , pa_proj_rollup_temp rollup
1283: , pa_proj_element_versions ver2
1284: where rollup.object_id = obj.object_id_to1
1285: AND rollup.process_number = l_process_number_temp

Line 1353: pa_progress_rollup ppr

1349: ,decode(c_task_per_comp_deriv_method,'EFFORT', nvl(ppr.PPL_ACT_EFFORT_TO_DATE,0) + nvl(ppr.estimated_remaining_effort,0) + nvl(ppr.EQPMT_ACT_EFFORT_TO_DATE,0) + nvl(ppr.EQPMT_ETC_EFFORT,0)
1350: , nvl(ppr.OTH_ACT_COST_TO_DATE_PC,0) + nvl(ppr.OTH_ETC_COST_PC,0) + nvl(ppr.PPL_ACT_COST_TO_DATE_PC,0) + nvl(ppr.PPL_ETC_COST_PC,0) + nvl(ppr.EQPMT_ACT_COST_TO_DATE_PC,0) + nvl(ppr.EQPMT_ETC_COST_PC,0)) bac_value
1351: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage --Bug 4506009
1352: FROM
1353: pa_progress_rollup ppr
1354: ,pa_project_statuses pps1
1355: ,pa_project_statuses pps2
1356: ,pa_project_statuses pps3
1357: ,pa_project_statuses pps4

Line 3404: -- Best way is to always retain the existing object_version_id in pa_progress_rollup

3400: -- One solution for this issue could be to pass
3401: -- p_upd_new_elem_ver_id_flag as 'N' from rollup API call in
3402: -- program_rollup_pvt, rollup_future_progress_pvt, and recursive call of Rollup API
3403: -- within Rollup API. This solution works for Case 1 and Case2, but not Case 3
3404: -- Best way is to always retain the existing object_version_id in pa_progress_rollup
3405: -- table in case of update, in case of insert, use the new object version id
3406:
3407: -- Commented below code and added new condition
3408:

Line 3578: UPDATE pa_progress_rollup

3574: l_tsk_prog_gl_period_name_tab(task_index) := l_prog_gl_period_name;
3575:
3576:
3577: IF l_max_rollup_as_of_date2 < p_as_of_date THEN
3578: UPDATE pa_progress_rollup
3579: SET current_flag = 'N'
3580: WHERE project_id = p_project_id
3581: AND object_id = cur_reverse_tree_rec.proj_element_id
3582: AND object_type = l_rollup_table1(i).object_type

Line 3597: UPDATE pa_progress_rollup

3593: END LOOP;
3594: END LOOP;
3595:
3596: FORALL i in 1..l_tsk_object_version_id_tab.count
3597: UPDATE pa_progress_rollup
3598: SET
3599: object_version_id = l_tsk_object_version_id_tab(i)
3600: , last_update_date = sysdate
3601: , last_updated_by = l_user_id

Line 3653: UPDATE pa_progress_rollup

3649:
3650:
3651: IF p_structure_type = 'WORKPLAN' AND l_structure_version_id IS NULL AND p_progress_mode <> 'BACKDATED' THEN
3652: FORALL i in 1..l_tsk_object_version_id_tab.count
3653: UPDATE pa_progress_rollup
3654: SET
3655: object_version_id = l_tsk_object_version_id_tab(i)
3656: , last_update_date = sysdate
3657: , last_updated_by = l_user_id

Line 3717: INSERT INTO pa_progress_rollup

3713: -- We should not create new records if the rollup is called from Future Rollup API
3714: -- It should just update.
3715: IF p_calling_mode <> 'FUTURE_ROLLUP' OR p_calling_mode IS NULL THEN
3716: FORALL i in 1..l_tsk_object_version_id_tab.count
3717: INSERT INTO pa_progress_rollup
3718: (
3719: progress_rollup_id
3720: ,project_id
3721: ,object_id

Line 3790: PA_PROGRESS_ROLLUP_S.nextval

3786: ,prog_gl_period_name
3787: ,base_percent_complete
3788: )
3789: SELECT
3790: PA_PROGRESS_ROLLUP_S.nextval
3791: , p_project_id
3792: , l_tsk_object_id_tab(i)
3793: , l_tsk_object_type_tab(i)
3794: , p_as_of_date

Line 4161: from pa_progress_rollup ppr, pa_percent_completes ppc

4157: -- Bug 3764224 : This cursor deals with tasks only, so no need to add join of proj_element_id
4158: CURSOR cur_tree_rollup_dates
4159: IS
4160: select as_of_date, published_flag, ppc.current_flag
4161: from pa_progress_rollup ppr, pa_percent_completes ppc
4162: where ppr.project_id = p_project_id
4163: and ppr.object_id = l_object_id
4164: and ppr.as_of_Date > p_as_of_date
4165: and ppr.project_id = ppc.project_id(+)

Line 4441: FROM pa_progress_rollup

4437: AND structure_type = 'WORKPLAN';
4438:
4439: CURSOR c_get_sub_proj_rollup IS
4440: SELECT *
4441: FROM pa_progress_rollup
4442: WHERE project_id = p_project_id
4443: AND object_type = 'PA_STRUCTURES'
4444: AND structure_type = 'WORKPLAN'
4445: AND structure_version_id is NULL

Line 4450: FROM pa_progress_rollup

4446: AND as_of_date = p_as_of_date;
4447:
4448: CURSOR c_get_par_task_rollup(c_object_id NUMBER, c_project_id NUMBER) IS
4449: SELECT *
4450: FROM pa_progress_rollup
4451: WHERE object_id = c_object_id
4452: AND project_id = c_project_id
4453: AND object_type = 'PA_TASKS'
4454: AND structure_type = 'WORKPLAN'

Line 4524: l_parent_progress_status pa_progress_rollup.progress_status_code%TYPE;

4520: l_POU_OTH_RAW_COST NUMBER := null;
4521: l_PRJ_OTH_RAW_COST NUMBER := null;
4522: l_current_flag VARCHAR2(1);
4523: l_dummy VARCHAR2(1);
4524: l_parent_progress_status pa_progress_rollup.progress_status_code%TYPE;
4525: l_child_progress_status pa_progress_rollup.progress_status_code%TYPE;
4526: l_par_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4527: l_child_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4528: l_progress_status_weight pa_project_statuses.project_status_weight%TYPE;

Line 4525: l_child_progress_status pa_progress_rollup.progress_status_code%TYPE;

4521: l_PRJ_OTH_RAW_COST NUMBER := null;
4522: l_current_flag VARCHAR2(1);
4523: l_dummy VARCHAR2(1);
4524: l_parent_progress_status pa_progress_rollup.progress_status_code%TYPE;
4525: l_child_progress_status pa_progress_rollup.progress_status_code%TYPE;
4526: l_par_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4527: l_child_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4528: l_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4529: l_eff_rollup_progress_status pa_progress_rollup.progress_status_code%TYPE;

Line 4529: l_eff_rollup_progress_status pa_progress_rollup.progress_status_code%TYPE;

4525: l_child_progress_status pa_progress_rollup.progress_status_code%TYPE;
4526: l_par_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4527: l_child_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4528: l_progress_status_weight pa_project_statuses.project_status_weight%TYPE;
4529: l_eff_rollup_progress_status pa_progress_rollup.progress_status_code%TYPE;
4530: l_actual_start_date DATE;
4531: l_actual_finish_date DATE;
4532: l_estimated_start_date DATE;
4533: l_estimated_finish_date DATE;

Line 5050: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

5046: IF l_mode = 'U' THEN
5047:
5048: l_parent_as_of_date := l_parent_task_rec.AS_OF_DATE; --bug 4033869
5049:
5050: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
5051: X_PROGRESS_ROLLUP_ID => l_parent_task_rec.PROGRESS_ROLLUP_ID
5052: ,X_PROJECT_ID => l_parent_task_rec.PROJECT_ID
5053: ,X_OBJECT_ID => l_parent_task_rec.OBJECT_ID
5054: ,X_OBJECT_TYPE => l_parent_task_rec.OBJECT_TYPE

Line 5183: FROM pa_progress_rollup

5179: ELSE -- IF l_mode = 'U' THEN
5180: BEGIN
5181: SELECT 'X'
5182: INTO l_dummy
5183: FROM pa_progress_rollup
5184: WHERE project_id = l_c1rec.parent_project_id
5185: AND object_id = l_c1rec.parent_task_id
5186: AND object_type = 'PA_TASKS'
5187: AND structure_type = 'WORKPLAN'

Line 5197: UPDATE pa_progress_rollup

5193: EXCEPTION
5194: WHEN NO_DATA_FOUND THEN
5195: l_current_flag := 'Y';
5196:
5197: UPDATE pa_progress_rollup
5198: SET current_flag = 'N'
5199: WHERE project_id = l_c1rec.parent_project_id
5200: AND object_id = l_c1rec.parent_task_id
5201: AND object_type = 'PA_TASKS'

Line 5213: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

5209: p_project_id => l_c1rec.parent_project_id
5210: ,p_task_id => l_c1rec.parent_task_id
5211: ,p_start_date => p_as_of_date);
5212: --End bug 4033869
5213: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
5214: X_PROGRESS_ROLLUP_ID => l_progress_rollup_id
5215: ,X_PROJECT_ID => l_c1rec.parent_project_id
5216: ,X_OBJECT_ID => l_c1rec.parent_task_id
5217: ,X_OBJECT_TYPE => 'PA_TASKS'

Line 5654: pa_progress_rollup ppr,

5650: -- 4533112 : Added base_progress_status_code
5651: , decode(ppr.base_progress_status_code, 'Y' , 'Y', 'N') base_progress_status_code
5652: FROM pa_proj_element_versions ppev,
5653: pa_object_relationships obj,
5654: pa_progress_rollup ppr,
5655: pa_project_statuses pps1,
5656: pa_project_statuses pps2,
5657: pa_project_statuses pps3,
5658: pa_proj_elements ppe -- 4392189

Line 5672: FROM pa_progress_rollup

5668: -- AND ppr.as_of_date = trunc(p_as_of_date)
5669: -- Bug 3879461 : After discussion with Sameer Realeraskar, Majid
5670: -- It is to select only the rollup record till passed as of date
5671: AND ppr.as_of_date = (SELECT max(as_of_date)
5672: FROM pa_progress_rollup
5673: WHERE project_id = p_project_id
5674: AND object_id = ppev.proj_element_id
5675: AND proj_element_id = ppev.proj_element_id
5676: AND object_type = 'PA_TASKS'

Line 5684: from pa_progress_rollup ppc1

5680: )
5681: AND (ppr.current_flag = 'W'
5682: OR (ppr.current_flag IN( 'Y', 'N') -- Bug 4336720 : Added Y and N Both
5683: AND NOT EXISTS (select 1
5684: from pa_progress_rollup ppc1
5685: where ppc1.project_id = p_project_id
5686: and ppc1.object_id = ppev.proj_element_id
5687: and ppc1.proj_element_id = ppev.proj_element_id
5688: and ppc1.object_Type = 'PA_TASKS'

Line 5825: FROM pa_progress_rollup

5821: WHERE ppev.element_version_id = c_task_ver_id
5822: AND ppev.object_type = 'PA_TASKS'
5823: -- Bug 3879461 Begin
5824: AND NOT EXISTS (SELECT 1
5825: FROM pa_progress_rollup
5826: WHERE project_id = p_project_id
5827: AND object_id = ppev.proj_element_id
5828: AND proj_element_id = ppev.proj_element_id
5829: AND object_type = 'PA_TASKS'

Line 5959: pa_progress_rollup ppr,

5955: , decode(ppr.base_progress_status_code,'Y','Y','N') base_progress_status_code
5956: FROM pa_proj_element_versions ppev1,
5957: pa_proj_element_versions ppev2,
5958: pa_object_relationships obj,
5959: pa_progress_rollup ppr,
5960: pa_project_statuses pps1,
5961: pa_project_statuses pps2,
5962: pa_project_statuses pps3,
5963: pa_proj_elements ppe -- 4392189

Line 5976: FROM pa_progress_rollup

5972: AND ppr.project_id = ppev2.project_id
5973: AND ppr.object_id = ppev2.proj_element_id
5974: AND ppr.proj_element_id = ppev2.proj_element_id
5975: AND ppr.as_of_date = (SELECT max(as_of_date)
5976: FROM pa_progress_rollup
5977: WHERE project_id = p_project_id
5978: AND object_id = ppev2.proj_element_id
5979: AND proj_element_id = ppev2.proj_element_id
5980: AND object_type = 'PA_TASKS'

Line 5988: from pa_progress_rollup ppc1

5984: )
5985: AND (ppr.current_flag = 'W'
5986: OR (ppr.current_flag IN( 'Y', 'N') -- Bug 4336720 : Added Y and N Both
5987: AND NOT EXISTS (select 1
5988: from pa_progress_rollup ppc1
5989: where ppc1.project_id = p_project_id
5990: and ppc1.object_id = ppev2.proj_element_id
5991: and ppc1.proj_element_id = ppev2.proj_element_id
5992: and ppc1.object_Type = 'PA_TASKS'

Line 6143: FROM pa_progress_rollup

6139: AND pfxat.calendar_type(+) = 'A'
6140: AND pfxat.plan_version_id(+) > 0
6141: AND pfxat.txn_currency_code(+) is null
6142: AND NOT EXISTS (SELECT 1
6143: FROM pa_progress_rollup
6144: WHERE project_id = p_project_id
6145: AND object_id = ppev2.proj_element_id
6146: AND proj_element_id = ppev2.proj_element_id
6147: AND object_type = 'PA_TASKS'

Line 6374: pa_progress_rollup ppr

6370: , ppr.Oth_quantity_to_date
6371: , ppr.Oth_etc_quantity
6372: FROM
6373: pa_task_asgmts_v asgn,
6374: pa_progress_rollup ppr
6375: WHERE asgn.task_version_id = c_task_ver_id
6376: AND asgn.task_id = c_task_id
6377: AND asgn.project_id = p_project_id
6378: AND asgn.project_id = ppr.project_id(+)

Line 6390: FROM pa_progress_rollup

6386: AND ppr.as_of_date(+) <= p_as_of_date
6387: AND nvl(ppr.progress_rollup_id,-99) = pa_progress_utils.get_w_pub_prupid_asofdate(p_project_id,asgn.RESOURCE_LIST_MEMBER_ID,'PA_ASSIGNMENTS',asgn.task_id,p_as_of_date);
6388:
6389: /* (SELECT nvl(max(progress_rollup_id),-99)
6390: FROM pa_progress_rollup
6391: WHERE project_id = p_project_id
6392: AND object_id = asgn.RESOURCE_LIST_MEMBER_ID
6393: AND proj_element_id = asgn.task_id
6394: AND object_type = 'PA_ASSIGNMENTS'

Line 6402: from pa_progress_rollup ppc1

6398: AND (ppr.current_flag = 'W'
6399: --OR (ppr.current_flag ='Y' --bug 4183176
6400: OR (ppr.current_flag IN ('Y', 'N')
6401: AND NOT EXISTS (select 1
6402: from pa_progress_rollup ppc1
6403: where ppc1.project_id = p_project_id
6404: and ppc1.object_id = asgn.RESOURCE_LIST_MEMBER_ID
6405: and ppc1.proj_element_id = asgn.task_id
6406: and ppc1.object_Type = 'PA_ASSIGNMENTS'

Line 6440: , pa_progress_rollup ppr

6436: , pps2.project_status_weight override_weight ---override progress status code
6437: , pps3.project_status_weight base_weight --base prog status
6438: FROM pa_proj_elements elem
6439: , pa_object_relationships obj
6440: , pa_progress_rollup ppr
6441: , pa_project_statuses pps2
6442: , pa_project_statuses pps3
6443: WHERE obj.object_id_from2= c_task_proj_elem_id
6444: ---AND obj.object_id_from1 = c_task_ver_id ---to get delv for specific task ver , object_id_from1 is not populated in this case

Line 6463: FROM pa_progress_rollup

6459: AND ppr.base_progress_status_code = pps3.project_status_code(+)
6460: AND ppr.progress_status_code = pps2.project_status_code(+);
6461:
6462: /* (SELECT nvl(max(progress_rollup_id),-99)
6463: FROM pa_progress_rollup
6464: WHERE project_id = p_project_id
6465: AND object_id = obj.object_id_to2
6466: --bug 4250623, do not check for proj_element_id as deliverable may not be associated with task
6467: --AND proj_element_id = obj.object_id_from2

Line 6476: from pa_progress_rollup ppc1

6472: --bug 4182870, added for selecting only one record
6473: AND (ppr.current_flag = 'W'
6474: OR (ppr.current_flag IN ('Y', 'N')
6475: AND NOT EXISTS (select 1
6476: from pa_progress_rollup ppc1
6477: where ppc1.project_id = p_project_id
6478: and ppc1.object_id = obj.object_id_to2
6479: --bug 4250623, do not check for proj_element_id as deliverable may not be associated with task
6480: --and ppc1.proj_element_id = obj.object_id_from2

Line 6526: SELECT * from pa_progress_rollup

6522: and predefined_flag = 'Y';
6523:
6524: CURSOR cur_rollup( c_progress_rollup_id NUMBER )
6525: IS
6526: SELECT * from pa_progress_rollup
6527: WHERE progress_rollup_id = c_progress_rollup_id;
6528:
6529: CURSOR cur_pa_rollup1( c_proj_element_id NUMBER )
6530: IS

Line 6532: FROM pa_progress_rollup

6528:
6529: CURSOR cur_pa_rollup1( c_proj_element_id NUMBER )
6530: IS
6531: SELECT *
6532: FROM pa_progress_rollup
6533: WHERE project_id = p_project_id
6534: AND object_id = c_proj_element_id
6535: AND structure_type = 'WORKPLAN'
6536: AND structure_version_id is null

Line 6538: FROM pa_progress_rollup

6534: AND object_id = c_proj_element_id
6535: AND structure_type = 'WORKPLAN'
6536: AND structure_version_id is null
6537: AND as_of_date = ( SELECT max( as_of_date )
6538: FROM pa_progress_rollup
6539: WHERE project_id = p_project_id
6540: AND object_id = c_proj_element_id
6541: AND structure_type = 'WORKPLAN'
6542: AND structure_version_id is null

Line 6779: pa_progress_rollup ppr

6775: , decode(nvl(ppr.OTH_ACT_COST_TO_DATE_PC,0) + nvl(ppr.OTH_ETC_COST_PC,0) + nvl(ppr.PPL_ACT_COST_TO_DATE_PC,0) + nvl(ppr.PPL_ETC_COST_PC,0) + nvl(ppr.EQPMT_ACT_COST_TO_DATE_PC,0) + nvl(ppr.EQPMT_ETC_COST_PC,0),0,
6776: nvl(pfxat.ETC_PRJ_BRDN_COST,0), nvl(ppr.OTH_ACT_COST_TO_DATE_PC,0) + nvl(ppr.OTH_ETC_COST_PC,0) + nvl(ppr.PPL_ACT_COST_TO_DATE_PC,0) + nvl(ppr.PPL_ETC_COST_PC,0) + nvl(ppr.EQPMT_ACT_COST_TO_DATE_PC,0) + nvl(ppr.EQPMT_ETC_COST_PC,0))) bac_value
6777: , nvl(ppr.completed_percentage, ppr.eff_rollup_percent_comp) completed_percentage -- Bug 4506009
6778: FROM
6779: pa_progress_rollup ppr
6780: ,pa_project_statuses pps1
6781: ,pa_project_statuses pps2
6782: ,pa_project_statuses pps3
6783: ,pa_project_statuses pps4

Line 8523: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(

8519:
8520:
8521: /* if etc values are null, set them as planned - actual. */
8522:
8523: PA_PROGRESS_ROLLUP_PKG.UPDATE_ROW(
8524: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
8525: ,X_PROJECT_ID => p_project_id
8526: ,X_OBJECT_ID => p_task_id
8527: ,X_OBJECT_TYPE => l_rollup_table1(i).object_type

Line 8720: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(

8716: -- Bug 3879461 End
8717:
8718: -- This code is not required if we do not do partail rollup from assignmnet progress details page
8719:
8720: PA_PROGRESS_ROLLUP_PKG.INSERT_ROW(
8721: X_PROGRESS_ROLLUP_ID => l_PROGRESS_ROLLUP_ID
8722: ,X_PROJECT_ID => p_project_id
8723: ,X_OBJECT_ID => p_task_id
8724: ,X_OBJECT_TYPE => l_rollup_table1(i).object_type

Line 8851: UPDATE pa_progress_rollup

8847: /*
8848: --update all previous record current flag to 'N'
8849: IF l_max_rollup_as_of_date2 < p_as_of_date --creating a new progress record.
8850: THEN
8851: UPDATE pa_progress_rollup
8852: SET current_flag = 'N'
8853: WHERE progress_rollup_id <> l_progress_rollup_id
8854: AND project_id = p_project_id
8855: AND object_id = p_task_id

Line 9027: FROM pa_progress_rollup

9023: /*
9024: CURSOR cur_chk_asgn
9025: IS
9026: SELECT 'x'
9027: FROM pa_progress_rollup
9028: WHERE object_id = p_resource_list_mem_id
9029: and structure_version_id = p_structure_version_id
9030: and proj_element_id = p_task_id
9031: and structure_type = 'WORKPLAN'

Line 9173: delete from pa_progress_rollup

9169: and published_flag = 'N'
9170: and structure_type = 'WORKPLAN'
9171: ;
9172:
9173: delete from pa_progress_rollup
9174: where project_id= p_project_id
9175: and proj_element_id = p_task_id
9176: and object_id = p_resource_list_mem_id
9177: and current_flag = 'W'

Line 9206: delete from pa_progress_rollup

9202: and object_type = 'PA_ASSIGNMENTS'
9203: and published_flag = 'Y';
9204:
9205:
9206: delete from pa_progress_rollup
9207: where project_id= p_project_id
9208: and proj_element_id = p_task_id
9209: and object_id = p_resource_list_mem_id
9210: and object_type = 'PA_ASSIGNMENTS'

Line 9217: delete from pa_progress_rollup

9213: and structure_type = 'WORKPLAN'
9214: and structure_version_id is null
9215: ;
9216:
9217: delete from pa_progress_rollup
9218: WHERE project_id = p_project_id
9219: and object_id = p_resource_list_mem_id
9220: and structure_version_id is null
9221: and proj_element_id = p_task_id

Line 9246: UPDATE pa_progress_rollup

9242: AND task_id = p_task_id
9243: AND current_flag = 'Y'
9244: AND object_type = 'PA_ASSIGNMENTS';
9245:
9246: UPDATE pa_progress_rollup
9247: SET current_flag = 'N'
9248: WHERE project_id = p_project_id
9249: AND object_id = p_resource_list_mem_id
9250: AND proj_element_id = p_task_id

Line 9317: select PA_PROGRESS_ROLLUP_S.nextval

9313: select PA_PERCENT_COMPLETES_S.nextval
9314: into x_percent_complete_id
9315: from dual;
9316:
9317: select PA_PROGRESS_ROLLUP_S.nextval
9318: into X_PROGRESS_ROLLUP_ID
9319: from dual;
9320: IF g1_debug_mode = 'Y' THEN
9321: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Before Inserting into pa_percent_completes', x_Log_Level=> 3);

Line 9431: INSERT INTO pa_progress_rollup(

9427: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Done Inserting into pa_percent_completes', x_Log_Level=> 3);
9428: END IF;
9429: -- Bug 4490532 : Subtracting the subproject amounts if available.
9430: -- Bug 4661350 : Using newly introduced local variable to store subprojects sum value
9431: INSERT INTO pa_progress_rollup(
9432: PROGRESS_ROLLUP_ID
9433: ,PERCENT_COMPLETE_ID
9434: ,PROJECT_ID
9435: ,OBJECT_ID

Line 9600: FROM pa_progress_rollup

9596: ,EQPMT_ACT_RAWCOST_TO_DATE_PC- nvl(sp_EQPMT_ACT_RAWCOST_TODATE_PC,0)
9597: ,EQPMT_ETC_RAWCOST_TC
9598: ,EQPMT_ETC_RAWCOST_FC- nvl(sp_EQPMT_ETC_RAWCOST_FC,0)
9599: ,EQPMT_ETC_RAWCOST_PC- nvl(sp_EQPMT_ETC_RAWCOST_PC,0)
9600: FROM pa_progress_rollup
9601: WHERE project_id = p_project_id
9602: and object_id = p_task_id
9603: and structure_version_id is NULL
9604: and proj_element_id = p_task_id

Line 9613: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Done Inserting into pa_progress_rollup', x_Log_Level=> 3);

9609: or (p_action = 'PUBLISH' and current_flag in ('Y', 'N')));
9610:
9611:
9612: IF g1_debug_mode = 'Y' THEN
9613: pa_debug.write(x_Module=>'PA_PROGRESS_PVT.convert_task_prog_to_assgn', x_Msg => 'Done Inserting into pa_progress_rollup', x_Log_Level=> 3);
9614: END IF;
9615:
9616: -- END IF;
9617:

Line 9757: from pa_progress_rollup ppr

9753: /* Begin code to fix Bug # 4141850. */
9754:
9755: cursor cur_as_of_date(p_project_id NUMBER) is
9756: select max(as_of_date)
9757: from pa_progress_rollup ppr
9758: where ppr.project_id = p_project_id
9759: and ppr.structure_version_id is null
9760: and ppr.structure_type = 'WORKPLAN'
9761: and ppr.current_flag <> 'W';

Line 10197: pa_progress_rollup ppr

10193: FROM pa_proj_element_versions a,
10194: pa_proj_elem_ver_structure b,
10195: pa_proj_structure_types ppst,
10196: pa_proj_element_versions c,
10197: pa_progress_rollup ppr
10198: WHERE
10199: c.project_id = p_project_id
10200: AND c.element_version_id = p_structure_version_id ---5095632
10201: AND c.prg_group = a.prg_group

Line 10406: --- update pa_progress_rollup table with new object_version_ids

10402: and task_id = l_proj_element_id_tab(i)
10403: and structure_type = 'WORKPLAN'
10404: and object_version_id = l_old_element_version_id_tab(i);
10405:
10406: --- update pa_progress_rollup table with new object_version_ids
10407: Forall i in l_new_element_version_id_tab.first..l_new_element_version_id_tab.last
10408: update pa_progress_rollup ppr
10409: set object_version_id = l_new_element_version_id_tab(i)
10410: where project_id = p_project_id

Line 10408: update pa_progress_rollup ppr

10404: and object_version_id = l_old_element_version_id_tab(i);
10405:
10406: --- update pa_progress_rollup table with new object_version_ids
10407: Forall i in l_new_element_version_id_tab.first..l_new_element_version_id_tab.last
10408: update pa_progress_rollup ppr
10409: set object_version_id = l_new_element_version_id_tab(i)
10410: where project_id = p_project_id
10411: and proj_element_id = l_proj_element_id_tab(i)
10412: and structure_type = 'WORKPLAN'