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.

[Home] [Help]

APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_RELATIONSHIP_UTILS

Line 1281: ,DECODE(l_d_lines_exist_flag,'Y',PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id),NULL) Predecessors

1277: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
1278: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
1279: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
1280: -- Bug 6156686
1281: ,DECODE(l_d_lines_exist_flag,'Y',PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id),NULL) Predecessors
1282: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
1283: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
1284: ) percent_Spent_Effort
1285: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 2087: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

2083: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
2084: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
2085: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
2086: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
2087: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
2088: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2089: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
2090: ) percent_Spent_Effort
2091: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 2950: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

2946: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
2947: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
2948: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
2949: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
2950: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
2951: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
2952: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
2953: ) percent_Spent_Effort
2954: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 3882: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

3878: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
3879: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
3880: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
3881: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
3882: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
3883: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
3884: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
3885: ) percent_Spent_Effort
3886: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 4707: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

4703: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
4704: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
4705: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
4706: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
4707: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
4708: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
4709: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
4710: ) percent_Spent_Effort
4711: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 5533: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

5529: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
5530: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
5531: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
5532: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
5533: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
5534: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
5535: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
5536: ) percent_Spent_Effort
5537: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 6518: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors

6514: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
6515: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
6516: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
6517: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
6518: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
6519: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
6520: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
6521: ) percent_Spent_Effort
6522: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 7002: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors

6998: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.
6999: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
7000: , null, null, null) Actual_Effort -- Fix for Bug # 4319171.
7001: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
7002: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv1.element_version_id) Predecessors
7003: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7004: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7005: ) percent_Spent_Effort
7006: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 7907: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

7903: ,null --pfxat.prj_brdn_cost
7904: ,null --NVL(pfxat.prj_brdn_cost,0)
7905: ,nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0) Actual_Effort
7906: ,NVL(ppru.eqpmt_act_effort_to_date,0)
7907: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
7908: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
7909: -- (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
7910: -- ) percent_Spent_Effort
7911: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 8666: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

8662: ,null --pfxat.prj_brdn_cost
8663: ,null --NVL(pfxat.prj_brdn_cost,0)
8664: ,nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0) Actual_Effort
8665: ,NVL(ppru.eqpmt_act_effort_to_date,0)
8666: ,null --PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
8667: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
8668: -- (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
8669: -- ) percent_Spent_Effort
8670: ,null --PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 9481: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

9477: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
9478: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
9479: Actual_Effort -- Fix for Bug # 4319171.
9480: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
9481: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
9482: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
9483: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
9484: ) percent_Spent_Effort
9485: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 10308: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

10304: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
10305: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
10306: Actual_Effort -- Fix for Bug # 4319171.
10307: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
10308: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
10309: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
10310: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
10311: ) percent_Spent_Effort
10312: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 11136: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

11132: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
11133: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
11134: Actual_Effort -- Fix for Bug # 4319171.
11135: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
11136: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
11137: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
11138: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
11139: ) percent_Spent_Effort
11140: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 12099: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

12095: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
12096: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
12097: Actual_Effort -- Fix for Bug # 4319171.
12098: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
12099: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
12100: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12101: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12102: ) percent_Spent_Effort
12103: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 12895: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

12891: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
12892: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
12893: Actual_Effort -- Fix for Bug # 4319171.
12894: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
12895: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
12896: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
12897: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
12898: ) percent_Spent_Effort
12899: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)

Line 13692: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors

13688: ,pa_progress_utils.calc_act(ppru.ppl_act_effort_to_date, ppru.eqpmt_act_effort_to_date, null
13689: , ppru.subprj_ppl_act_effort, ppru.subprj_eqpmt_act_effort, null)
13690: Actual_Effort -- Fix for Bug # 4319171.
13691: ,ppru.eqpmt_act_effort_to_date actual_equip_effort -- Fix for Bug # 4319171.
13692: ,PA_RELATIONSHIP_UTILS.DISPLAY_PREDECESSORS(ppv.element_version_id) Predecessors
13693: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.ppl_act_effort_to_date,0)+nvl(ppru.eqpmt_act_effort_to_date,0)),
13694: (nvl(pfxat.labor_hours,0)+nvl(pfxat.equipment_hours,0))
13695: ) percent_Spent_Effort
13696: ,PA_PROGRESS_UTILS.Percent_Spent_Value ((nvl(ppru.oth_act_cost_to_date_pc,0)+nvl(ppru.ppl_act_cost_to_date_pc,0)