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_PROJ_STRUCTURE_PUB dependencies on PA_CONTROL_ITEMS_UTILS

Line 1260: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE'),

1256: ,ppwa.lifecycle_version_id
1257: ,ppv.TASK_UNPUB_VER_STATUS_CODE
1258: -- Bug 6156686
1259: ,DECODE(l_issue_lines_exist_flag,'Y',
1260: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE'),
1261: 0)
1262: ,to_number(null)
1263: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
1264: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)

Line 1268: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST'),

1264: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
1265: ,ppeph.name
1266: -- Bug 6156686
1267: ,DECODE(l_cr_lines_exist_flag,'Y',
1268: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST'),
1269: 0)
1270: ,DECODE(l_co_lines_exist_flag,'Y',
1271: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER'),
1272: 0)

Line 1271: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER'),

1267: ,DECODE(l_cr_lines_exist_flag,'Y',
1268: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST'),
1269: 0)
1270: ,DECODE(l_co_lines_exist_flag,'Y',
1271: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER'),
1272: 0)
1273: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
1274: ,pfxat.prj_raw_cost raw_cost
1275: ,pfxat.prj_brdn_cost burdened_cost

Line 2073: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

2069: ,pt.attribute9
2070: ,pt.attribute10
2071: ,ppwa.lifecycle_version_id
2072: ,ppv.TASK_UNPUB_VER_STATUS_CODE
2073: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
2074: ,to_number(null)
2075: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2076: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2077: ,ppeph.name

Line 2078: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

2074: ,to_number(null)
2075: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2076: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2077: ,ppeph.name
2078: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
2079: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
2080: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
2081: ,pfxat.prj_raw_cost raw_cost
2082: ,pfxat.prj_brdn_cost burdened_cost

Line 2079: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

2075: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2076: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2077: ,ppeph.name
2078: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
2079: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
2080: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
2081: ,pfxat.prj_raw_cost raw_cost
2082: ,pfxat.prj_brdn_cost burdened_cost
2083: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 2936: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

2932: ,pt.attribute9
2933: ,pt.attribute10
2934: ,ppwa.lifecycle_version_id
2935: ,ppv.TASK_UNPUB_VER_STATUS_CODE
2936: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
2937: ,to_number(null)
2938: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2939: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2940: ,ppeph.name

Line 2941: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

2937: ,to_number(null)
2938: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2939: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2940: ,ppeph.name
2941: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
2942: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
2943: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
2944: ,pfxat.prj_raw_cost raw_cost
2945: ,pfxat.prj_brdn_cost burdened_cost

Line 2942: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

2938: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2939: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2940: ,ppeph.name
2941: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
2942: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
2943: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
2944: ,pfxat.prj_raw_cost raw_cost
2945: ,pfxat.prj_brdn_cost burdened_cost
2946: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 3868: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

3864: ,pt.attribute9
3865: ,pt.attribute10
3866: ,ppwa.lifecycle_version_id
3867: ,ppv.TASK_UNPUB_VER_STATUS_CODE
3868: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
3869: ,to_number(null)
3870: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
3871: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
3872: ,ppeph.name

Line 3873: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

3869: ,to_number(null)
3870: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
3871: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
3872: ,ppeph.name
3873: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
3874: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
3875: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
3876: ,pfxat.prj_raw_cost raw_cost
3877: ,pfxat.prj_brdn_cost burdened_cost

Line 3874: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

3870: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
3871: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
3872: ,ppeph.name
3873: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
3874: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
3875: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
3876: ,pfxat.prj_raw_cost raw_cost
3877: ,pfxat.prj_brdn_cost burdened_cost
3878: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 4693: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

4689: ,pt.attribute9
4690: ,pt.attribute10
4691: ,ppwa.lifecycle_version_id
4692: ,ppv.TASK_UNPUB_VER_STATUS_CODE
4693: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
4694: ,to_number(null)
4695: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
4696: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
4697: ,ppeph.name

Line 4698: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

4694: ,to_number(null)
4695: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
4696: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
4697: ,ppeph.name
4698: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
4699: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
4700: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
4701: ,pfxat.prj_raw_cost raw_cost
4702: ,pfxat.prj_brdn_cost burdened_cost

Line 4699: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

4695: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
4696: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
4697: ,ppeph.name
4698: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
4699: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
4700: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
4701: ,pfxat.prj_raw_cost raw_cost
4702: ,pfxat.prj_brdn_cost burdened_cost
4703: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 5519: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

5515: ,pt.attribute9
5516: ,pt.attribute10
5517: ,ppwa.lifecycle_version_id
5518: ,ppv.TASK_UNPUB_VER_STATUS_CODE
5519: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
5520: ,to_number(null)
5521: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
5522: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
5523: ,ppeph.name

Line 5524: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

5520: ,to_number(null)
5521: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
5522: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
5523: ,ppeph.name
5524: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
5525: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
5526: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
5527: ,pfxat.prj_raw_cost raw_cost
5528: ,pfxat.prj_brdn_cost burdened_cost

Line 5525: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

5521: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
5522: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
5523: ,ppeph.name
5524: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
5525: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
5526: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
5527: ,pfxat.prj_raw_cost raw_cost
5528: ,pfxat.prj_brdn_cost burdened_cost
5529: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 6504: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

6500: ,to_char(null)
6501: ,to_char(null)
6502: ,to_number(null)
6503: ,ppv1.TASK_UNPUB_VER_STATUS_CODE
6504: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
6505: ,to_number(null)
6506: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
6507: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
6508: ,to_char(null)

Line 6509: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

6505: ,to_number(null)
6506: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
6507: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
6508: ,to_char(null)
6509: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
6510: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
6511: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
6512: ,pfxat.prj_raw_cost raw_cost
6513: ,pfxat.prj_brdn_cost burdened_cost

Line 6510: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

6506: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
6507: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
6508: ,to_char(null)
6509: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
6510: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
6511: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
6512: ,pfxat.prj_raw_cost raw_cost
6513: ,pfxat.prj_brdn_cost burdened_cost
6514: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 6988: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

6984: ,to_char(null)
6985: ,to_char(null)
6986: ,to_number(null)
6987: ,ppv1.TASK_UNPUB_VER_STATUS_CODE
6988: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
6989: ,to_number(null)
6990: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
6991: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
6992: ,to_char(null)

Line 6993: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

6989: ,to_number(null)
6990: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
6991: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
6992: ,to_char(null)
6993: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
6994: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
6995: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
6996: ,pfxat.prj_raw_cost raw_cost
6997: ,pfxat.prj_brdn_cost burdened_cost

Line 6994: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

6990: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
6991: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
6992: ,to_char(null)
6993: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
6994: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
6995: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
6996: ,pfxat.prj_raw_cost raw_cost
6997: ,pfxat.prj_brdn_cost burdened_cost
6998: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 7894: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

7890: ,pt.attribute9
7891: ,pt.attribute10
7892: ,ppwa.lifecycle_version_id
7893: ,ppv.TASK_UNPUB_VER_STATUS_CODE
7894: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
7895: ,to_number(null)
7896: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
7897: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
7898: ,ppeph.name

Line 7899: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

7895: ,to_number(null)
7896: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
7897: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
7898: ,ppeph.name
7899: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
7900: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
7901: ,null --NVL(pfxat.equipment_hours,0)
7902: ,null --pfxat.prj_raw_cost
7903: ,null --pfxat.prj_brdn_cost

Line 7900: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

7896: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
7897: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
7898: ,ppeph.name
7899: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
7900: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
7901: ,null --NVL(pfxat.equipment_hours,0)
7902: ,null --pfxat.prj_raw_cost
7903: ,null --pfxat.prj_brdn_cost
7904: ,null --NVL(pfxat.prj_brdn_cost,0)

Line 8653: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

8649: ,pt.attribute9
8650: ,pt.attribute10
8651: ,ppwa.lifecycle_version_id
8652: ,ppv.TASK_UNPUB_VER_STATUS_CODE
8653: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
8654: ,to_number(null)
8655: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
8656: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8657: ,ppeph.name

Line 8658: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

8654: ,to_number(null)
8655: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
8656: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8657: ,ppeph.name
8658: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
8659: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
8660: ,null --NVL(pfxat.equipment_hours,0)
8661: ,null --pfxat.prj_raw_cost
8662: ,null --pfxat.prj_brdn_cost

Line 8659: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

8655: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
8656: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8657: ,ppeph.name
8658: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
8659: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
8660: ,null --NVL(pfxat.equipment_hours,0)
8661: ,null --pfxat.prj_raw_cost
8662: ,null --pfxat.prj_brdn_cost
8663: ,null --NVL(pfxat.prj_brdn_cost,0)

Line 9466: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

9462: ,pt.attribute10
9463: --------------------------------------------------------------------
9464: ,to_number(null) -- lifecycle version id
9465: ,ppv.TASK_UNPUB_VER_STATUS_CODE
9466: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
9467: ,to_number(null)
9468: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
9469: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
9470: ,null --current phase name

Line 9471: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

9467: ,to_number(null)
9468: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
9469: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
9470: ,null --current phase name
9471: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
9472: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
9473: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
9474: ,pfxat.prj_raw_cost raw_cost
9475: ,pfxat.prj_brdn_cost burdened_cost

Line 9472: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

9468: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
9469: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
9470: ,null --current phase name
9471: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
9472: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
9473: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
9474: ,pfxat.prj_raw_cost raw_cost
9475: ,pfxat.prj_brdn_cost burdened_cost
9476: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 10293: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

10289: ,pt.attribute10
10290: --------------------------------------------------------------------
10291: ,to_number(null) -- lifecycle version id
10292: ,ppv.TASK_UNPUB_VER_STATUS_CODE
10293: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
10294: ,to_number(null)
10295: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10296: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10297: ,null --current phase name

Line 10298: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

10294: ,to_number(null)
10295: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10296: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10297: ,null --current phase name
10298: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
10299: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
10300: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
10301: ,pfxat.prj_raw_cost raw_cost
10302: ,pfxat.prj_brdn_cost burdened_cost

Line 10299: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

10295: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10296: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10297: ,null --current phase name
10298: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
10299: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
10300: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
10301: ,pfxat.prj_raw_cost raw_cost
10302: ,pfxat.prj_brdn_cost burdened_cost
10303: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 11121: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

11117: ,pt.attribute10
11118: --------------------------------------------------------------------
11119: ,to_number(null) -- lifecycle version id
11120: ,ppv.TASK_UNPUB_VER_STATUS_CODE
11121: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
11122: ,to_number(null)
11123: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
11124: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
11125: ,null --current phase name

Line 11126: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

11122: ,to_number(null)
11123: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
11124: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
11125: ,null --current phase name
11126: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
11127: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
11128: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
11129: ,pfxat.prj_raw_cost raw_cost
11130: ,pfxat.prj_brdn_cost burdened_cost

Line 11127: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

11123: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
11124: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
11125: ,null --current phase name
11126: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
11127: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
11128: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
11129: ,pfxat.prj_raw_cost raw_cost
11130: ,pfxat.prj_brdn_cost burdened_cost
11131: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 12084: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

12080: ,pt.attribute10
12081: --------------------------------------------------------------------
12082: ,to_number(null) -- lifecycle version id
12083: ,ppv.TASK_UNPUB_VER_STATUS_CODE
12084: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
12085: ,to_number(null)
12086: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12087: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12088: ,null --current phase name

Line 12089: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

12085: ,to_number(null)
12086: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12087: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12088: ,null --current phase name
12089: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
12090: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
12091: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
12092: ,pfxat.prj_raw_cost raw_cost
12093: ,pfxat.prj_brdn_cost burdened_cost

Line 12090: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

12086: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12087: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12088: ,null --current phase name
12089: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
12090: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
12091: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
12092: ,pfxat.prj_raw_cost raw_cost
12093: ,pfxat.prj_brdn_cost burdened_cost
12094: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 12880: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

12876: ,pt.attribute10
12877: --------------------------------------------------------------------
12878: ,to_number(null) -- lifecycle version id
12879: ,ppv.TASK_UNPUB_VER_STATUS_CODE
12880: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
12881: ,to_number(null)
12882: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12883: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12884: ,null --current phase name

Line 12885: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

12881: ,to_number(null)
12882: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12883: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12884: ,null --current phase name
12885: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
12886: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
12887: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
12888: ,pfxat.prj_raw_cost raw_cost
12889: ,pfxat.prj_brdn_cost burdened_cost

Line 12886: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

12882: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12883: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12884: ,null --current phase name
12885: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
12886: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
12887: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
12888: ,pfxat.prj_raw_cost raw_cost
12889: ,pfxat.prj_brdn_cost burdened_cost
12890: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

Line 13677: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')

13673: ,pt.attribute10
13674: --------------------------------------------------------------------
13675: ,to_number(null) -- lifecycle version id
13676: ,ppv.TASK_UNPUB_VER_STATUS_CODE
13677: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
13678: ,to_number(null)
13679: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
13680: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
13681: ,null --current phase name

Line 13682: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')

13678: ,to_number(null)
13679: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
13680: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
13681: ,null --current phase name
13682: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
13683: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
13684: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
13685: ,pfxat.prj_raw_cost raw_cost
13686: ,pfxat.prj_brdn_cost burdened_cost

Line 13683: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')

13679: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
13680: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
13681: ,null --current phase name
13682: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
13683: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
13684: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
13685: ,pfxat.prj_raw_cost raw_cost
13686: ,pfxat.prj_brdn_cost burdened_cost
13687: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.