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_PROJECT_STATUSES

Line 369: from pa_project_statuses

365:
366: CURSOR cur_task_status( c_status_weight VARCHAR2 )
367: IS
368: select project_status_code
369: from pa_project_statuses
370: where project_status_weight = c_status_weight
371: and status_type = 'TASK'
372: and predefined_flag = 'Y';
373:

Line 475: pa_project_statuses pps1,

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
479: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

Line 476: pa_project_statuses pps2,

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
479: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
480: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 477: pa_project_statuses pps3 ,

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
479: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
480: --element_version_id IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)
481: temp.object_id = ppev.element_version_id

Line 599: pa_project_statuses pps1,

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,
602: pa_project_statuses pps4,
603: pa_task_types ttype ,

Line 600: pa_project_statuses pps2,

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,
602: pa_project_statuses pps4,
603: pa_task_types ttype ,
604: pa_proj_rollup_temp temp

Line 601: pa_project_statuses pps3,

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,
602: pa_project_statuses pps4,
603: pa_task_types ttype ,
604: pa_proj_rollup_temp temp
605: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM

Line 602: pa_project_statuses pps4,

598: pa_proj_elements ppe,
599: pa_project_statuses pps1,
600: pa_project_statuses pps2,
601: pa_project_statuses pps3,
602: pa_project_statuses pps4,
603: pa_task_types ttype ,
604: pa_proj_rollup_temp temp
605: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
606: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 839: pa_project_statuses pps4,

835: pa_object_relationships pobj,
836: pa_proj_element_versions ppev1,
837: pa_proj_element_versions ppev2,
838: pa_proj_elements ppe,
839: pa_project_statuses pps4,
840: pa_task_types ttype ,
841: pa_proj_rollup_temp temp
842: WHERE --BUG 4355204 rtarway, removed in clause and added pa_proj_rollup_temp in FROM
843: --IN (SELECT object_id from pa_proj_rollup_temp where process_number = l_process_number_temp)

Line 1191: , pa_project_statuses pps2

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'
1195: AND obj.object_type_to = 'PA_DELIVERABLES'

Line 1192: , pa_project_statuses pps3

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'
1195: AND obj.object_type_to = 'PA_DELIVERABLES'
1196: AND obj.relationship_type = 'A'

Line 1234: , pa_project_statuses status

1230: CURSOR cur_check_published_version(c_structure_version_id number, c_project_id number)
1231: IS
1232: SELECT decode(status.project_system_status_code, 'STRUCTURE_PUBLISHED','Y','N')
1233: FROM pa_proj_elem_ver_structure str
1234: , pa_project_statuses status
1235: where str.element_version_id = c_structure_version_id
1236: AND str.project_id = c_project_id
1237: AND str.status_code = status.project_status_code;
1238:

Line 1354: ,pa_project_statuses pps1

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
1358: ,pa_proj_elements ppe

Line 1355: ,pa_project_statuses pps2

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
1358: ,pa_proj_elements ppe
1359: WHERE

Line 1356: ,pa_project_statuses pps3

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
1358: ,pa_proj_elements ppe
1359: WHERE
1360: ppr.project_id = c_sub_project_id

Line 1357: ,pa_project_statuses pps4

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
1358: ,pa_proj_elements ppe
1359: WHERE
1360: ppr.project_id = c_sub_project_id
1361: AND ppe.project_id = c_sub_project_id

Line 4460: FROM pa_project_statuses

4456: AND as_of_date = p_as_of_date;
4457:
4458: CURSOR cur_get_status( c_status_weight VARCHAR2, c_status_type VARCHAR2 ) IS
4459: SELECT project_status_code
4460: FROM pa_project_statuses
4461: WHERE project_status_weight = c_status_weight
4462: AND status_type = c_status_type
4463: AND predefined_flag = 'Y';
4464:

Line 4467: FROM pa_project_statuses

4463: AND predefined_flag = 'Y';
4464:
4465: CURSOR cur_get_status_weight(c_status_code VARCHAR2, c_status_type VARCHAR2 ) IS
4466: SELECT project_status_weight
4467: FROM pa_project_statuses
4468: WHERE project_status_code = c_status_code
4469: AND status_type = c_status_type;
4470:
4471: l_child_prog_cycle_id number; ---4701759, 4701727

Line 4526: l_par_progress_status_weight pa_project_statuses.project_status_weight%TYPE;

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;
4530: l_actual_start_date DATE;

Line 4527: l_child_progress_status_weight pa_project_statuses.project_status_weight%TYPE;

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;
4530: l_actual_start_date DATE;
4531: l_actual_finish_date DATE;

Line 4528: l_progress_status_weight pa_project_statuses.project_status_weight%TYPE;

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;
4530: l_actual_start_date DATE;
4531: l_actual_finish_date DATE;
4532: l_estimated_start_date DATE;

Line 5655: pa_project_statuses pps1,

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
5659: WHERE ppev.element_version_id = c_task_ver_id

Line 5656: pa_project_statuses pps2,

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
5659: WHERE ppev.element_version_id = c_task_ver_id
5660: AND ppev.element_version_id = obj.object_id_to1

Line 5657: pa_project_statuses pps3,

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
5659: WHERE ppev.element_version_id = c_task_ver_id
5660: AND ppev.element_version_id = obj.object_id_to1
5661: AND obj.relationship_type = 'S'

Line 5960: pa_project_statuses pps1,

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
5964: WHERE obj.object_id_from1 = c_task_ver_id

Line 5961: pa_project_statuses pps2,

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
5964: WHERE obj.object_id_from1 = c_task_ver_id
5965: AND obj.object_id_from1 = ppev1.element_version_id

Line 5962: pa_project_statuses pps3,

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
5964: WHERE obj.object_id_from1 = c_task_ver_id
5965: AND obj.object_id_from1 = ppev1.element_version_id
5966: AND obj.object_id_to1 = ppev2.element_version_id

Line 6441: , pa_project_statuses pps2

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
6445: AND obj.object_type_from = 'PA_TASKS'

Line 6442: , pa_project_statuses pps3

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
6445: AND obj.object_type_from = 'PA_TASKS'
6446: AND obj.object_type_to = 'PA_DELIVERABLES'

Line 6500: , pa_project_statuses stat

6496: IS
6497: SELECT elem.status_code, stat.project_system_status_code, decode(elem.base_percent_comp_deriv_code, null, ttype.base_percent_comp_deriv_code,'^',ttype.base_percent_comp_deriv_code,elem.base_percent_comp_deriv_code), ttype.prog_entry_enable_flag
6498: FROM pa_proj_elements elem
6499: , pa_task_types ttype
6500: , pa_project_statuses stat
6501: where elem.proj_element_id = c_task_proj_elem_id
6502: AND elem.project_id = c_project_id
6503: AND elem.object_type ='PA_TASKS'
6504: AND elem.type_id = ttype.task_type_id

Line 6519: from pa_project_statuses

6515:
6516: CURSOR cur_task_status( c_status_weight VARCHAR2 )
6517: IS
6518: select project_status_code
6519: from pa_project_statuses
6520: where project_status_weight = c_status_weight
6521: and status_type = 'TASK'
6522: and predefined_flag = 'Y';
6523:

Line 6626: L_TASK_STATUS_CODE pa_project_statuses.project_status_code%TYPE ;

6622: l_POU_LABOR_RAW_COST NUMBER ;
6623: l_PRJ_LABOR_RAW_COST NUMBER ;
6624: l_POU_EQUIP_RAW_COST NUMBER ;
6625: l_PRJ_EQUIP_RAW_COST NUMBER ;
6626: L_TASK_STATUS_CODE pa_project_statuses.project_status_code%TYPE ;
6627: l_task_system_status_code pa_project_statuses.project_system_status_code%TYPE;
6628: L_TASK_WEIGHTING_PERCENTAGE NUMBER ;
6629: L_PROG_ENTRY_ENABLE_FLAG VARCHAR2(1) ;
6630: l_BASE_PERCENT_COMP_DERIV_CODE VARCHAR2(30) ;

Line 6627: l_task_system_status_code pa_project_statuses.project_system_status_code%TYPE;

6623: l_PRJ_LABOR_RAW_COST NUMBER ;
6624: l_POU_EQUIP_RAW_COST NUMBER ;
6625: l_PRJ_EQUIP_RAW_COST NUMBER ;
6626: L_TASK_STATUS_CODE pa_project_statuses.project_status_code%TYPE ;
6627: l_task_system_status_code pa_project_statuses.project_system_status_code%TYPE;
6628: L_TASK_WEIGHTING_PERCENTAGE NUMBER ;
6629: L_PROG_ENTRY_ENABLE_FLAG VARCHAR2(1) ;
6630: l_BASE_PERCENT_COMP_DERIV_CODE VARCHAR2(30) ;
6631: -- Bug 5675437

Line 6644: L_EXISTING_OBJECT_STATUS pa_project_statuses.project_status_code%TYPE ;

6640: FROM PA_PROJ_ELEMENTS
6641: WHERE PROJ_ELEMENT_ID=l_proj_element_id
6642: AND PROJECT_ID = l_project_id;
6643:
6644: L_EXISTING_OBJECT_STATUS pa_project_statuses.project_status_code%TYPE ;
6645: l_Oth_quantity_to_date NUMBER;
6646: l_Oth_etc_quantity NUMBER;
6647:
6648: -- Bug 3879461 End

Line 6780: ,pa_project_statuses pps1

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
6784: ,pa_proj_elements ppe

Line 6781: ,pa_project_statuses pps2

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
6784: ,pa_proj_elements ppe
6785: ,pji_fm_xbs_accum_tmp1 pfxat

Line 6782: ,pa_project_statuses pps3

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
6784: ,pa_proj_elements ppe
6785: ,pji_fm_xbs_accum_tmp1 pfxat
6786: WHERE

Line 6783: ,pa_project_statuses pps4

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
6784: ,pa_proj_elements ppe
6785: ,pji_fm_xbs_accum_tmp1 pfxat
6786: WHERE
6787: ppr.project_id = c_sub_project_id