APPS.PA_PROJ_STRUCTURE_PUB dependencies on PA_CONTROL_ITEMS_UTILS

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

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

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

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

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

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

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

1834: ,ppwa.lifecycle_version_id
1835: ,ppv.TASK_UNPUB_VER_STATUS_CODE
1836: -- Bug 6156686
1837: ,DECODE(l_issue_lines_exist_flag,'Y',
1838: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE'),
1839: 0)
1840: ,to_number(null)
1841: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
1842: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)

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

1842: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
1843: ,ppeph.name
1844: -- Bug 6156686
1845: ,DECODE(l_cr_lines_exist_flag,'Y',
1846: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST'),
1847: 0)
1848: ,DECODE(l_co_lines_exist_flag,'Y',
1849: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER'),
1850: 0)

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

1845: ,DECODE(l_cr_lines_exist_flag,'Y',
1846: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST'),
1847: 0)
1848: ,DECODE(l_co_lines_exist_flag,'Y',
1849: pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER'),
1850: 0)
1851: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
1852: ,pfxat.prj_raw_cost raw_cost
1853: ,pfxat.prj_brdn_cost burdened_cost

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

2654: ,pt.attribute9
2655: ,pt.attribute10
2656: ,ppwa.lifecycle_version_id
2657: ,ppv.TASK_UNPUB_VER_STATUS_CODE
2658: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
2659: ,to_number(null)
2660: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2661: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2662: ,ppeph.name

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

2659: ,to_number(null)
2660: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2661: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2662: ,ppeph.name
2663: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
2664: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
2665: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
2666: ,pfxat.prj_raw_cost raw_cost
2667: ,pfxat.prj_brdn_cost burdened_cost

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

2660: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
2661: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
2662: ,ppeph.name
2663: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
2664: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
2665: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
2666: ,pfxat.prj_raw_cost raw_cost
2667: ,pfxat.prj_brdn_cost burdened_cost
2668: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

3234: ,pt.attribute9
3235: ,pt.attribute10
3236: ,ppwa.lifecycle_version_id
3237: ,ppv.TASK_UNPUB_VER_STATUS_CODE
3238: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
3239: ,to_number(null)
3240: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
3241: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
3242: ,ppeph.name

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

3239: ,to_number(null)
3240: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
3241: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
3242: ,ppeph.name
3243: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
3244: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
3245: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
3246: ,pfxat.prj_raw_cost raw_cost
3247: ,pfxat.prj_brdn_cost burdened_cost

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

3240: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
3241: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
3242: ,ppeph.name
3243: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
3244: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
3245: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
3246: ,pfxat.prj_raw_cost raw_cost
3247: ,pfxat.prj_brdn_cost burdened_cost
3248: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

4109: ,pt.attribute9
4110: ,pt.attribute10
4111: ,ppwa.lifecycle_version_id
4112: ,ppv.TASK_UNPUB_VER_STATUS_CODE
4113: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
4114: ,to_number(null)
4115: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
4116: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
4117: ,ppeph.name

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

4114: ,to_number(null)
4115: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
4116: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
4117: ,ppeph.name
4118: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
4119: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
4120: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
4121: ,pfxat.prj_raw_cost raw_cost
4122: ,pfxat.prj_brdn_cost burdened_cost

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

4115: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
4116: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
4117: ,ppeph.name
4118: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
4119: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
4120: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
4121: ,pfxat.prj_raw_cost raw_cost
4122: ,pfxat.prj_brdn_cost burdened_cost
4123: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

4684: ,pt.attribute9
4685: ,pt.attribute10
4686: ,ppwa.lifecycle_version_id
4687: ,ppv.TASK_UNPUB_VER_STATUS_CODE
4688: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
4689: ,to_number(null)
4690: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
4691: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
4692: ,ppeph.name

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

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

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

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

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

5676: ,pt.attribute9
5677: ,pt.attribute10
5678: ,ppwa.lifecycle_version_id
5679: ,ppv.TASK_UNPUB_VER_STATUS_CODE
5680: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
5681: ,to_number(null)
5682: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
5683: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
5684: ,ppeph.name

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

5681: ,to_number(null)
5682: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
5683: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
5684: ,ppeph.name
5685: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
5686: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
5687: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
5688: ,pfxat.prj_raw_cost raw_cost
5689: ,pfxat.prj_brdn_cost burdened_cost

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

5682: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
5683: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
5684: ,ppeph.name
5685: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
5686: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
5687: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
5688: ,pfxat.prj_raw_cost raw_cost
5689: ,pfxat.prj_brdn_cost burdened_cost
5690: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

6502: ,pt.attribute9
6503: ,pt.attribute10
6504: ,ppwa.lifecycle_version_id
6505: ,ppv.TASK_UNPUB_VER_STATUS_CODE
6506: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
6507: ,to_number(null)
6508: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
6509: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
6510: ,ppeph.name

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

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

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

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

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

7329: ,pt.attribute9
7330: ,pt.attribute10
7331: ,ppwa.lifecycle_version_id
7332: ,ppv.TASK_UNPUB_VER_STATUS_CODE
7333: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
7334: ,to_number(null)
7335: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
7336: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
7337: ,ppeph.name

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

7334: ,to_number(null)
7335: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
7336: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
7337: ,ppeph.name
7338: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
7339: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
7340: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
7341: ,pfxat.prj_raw_cost raw_cost
7342: ,pfxat.prj_brdn_cost burdened_cost

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

7335: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
7336: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
7337: ,ppeph.name
7338: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
7339: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
7340: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
7341: ,pfxat.prj_raw_cost raw_cost
7342: ,pfxat.prj_brdn_cost burdened_cost
7343: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

8315: ,to_char(null)
8316: ,to_char(null)
8317: ,to_number(null)
8318: ,ppv1.TASK_UNPUB_VER_STATUS_CODE
8319: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
8320: ,to_number(null)
8321: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
8322: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8323: ,to_char(null)

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

8320: ,to_number(null)
8321: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
8322: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8323: ,to_char(null)
8324: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
8325: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
8326: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
8327: ,pfxat.prj_raw_cost raw_cost
8328: ,pfxat.prj_brdn_cost burdened_cost

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

8321: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
8322: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8323: ,to_char(null)
8324: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
8325: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
8326: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
8327: ,pfxat.prj_raw_cost raw_cost
8328: ,pfxat.prj_brdn_cost burdened_cost
8329: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

8800: ,to_char(null)
8801: ,to_char(null)
8802: ,to_number(null)
8803: ,ppv1.TASK_UNPUB_VER_STATUS_CODE
8804: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
8805: ,to_number(null)
8806: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
8807: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8808: ,to_char(null)

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

8805: ,to_number(null)
8806: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
8807: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8808: ,to_char(null)
8809: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
8810: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
8811: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
8812: ,pfxat.prj_raw_cost raw_cost
8813: ,pfxat.prj_brdn_cost burdened_cost

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

8806: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
8807: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
8808: ,to_char(null)
8809: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
8810: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
8811: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
8812: ,pfxat.prj_raw_cost raw_cost
8813: ,pfxat.prj_brdn_cost burdened_cost
8814: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

9308: ,to_char(null)
9309: ,to_char(null)
9310: ,to_number(null)
9311: ,ppv1.TASK_UNPUB_VER_STATUS_CODE
9312: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
9313: ,to_number(null)
9314: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
9315: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
9316: ,to_char(null)

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

9313: ,to_number(null)
9314: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
9315: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
9316: ,to_char(null)
9317: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
9318: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
9319: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
9320: ,pfxat.prj_raw_cost raw_cost
9321: ,pfxat.prj_brdn_cost burdened_cost

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

9314: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv1.element_version_id)
9315: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
9316: ,to_char(null)
9317: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
9318: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
9319: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
9320: ,pfxat.prj_raw_cost raw_cost
9321: ,pfxat.prj_brdn_cost burdened_cost
9322: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

10220: ,pt.attribute9
10221: ,pt.attribute10
10222: ,ppwa.lifecycle_version_id
10223: ,ppv.TASK_UNPUB_VER_STATUS_CODE
10224: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
10225: ,to_number(null)
10226: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10227: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10228: ,ppeph.name

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

10225: ,to_number(null)
10226: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10227: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10228: ,ppeph.name
10229: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
10230: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
10231: ,null --NVL(pfxat.equipment_hours,0)
10232: ,null --pfxat.prj_raw_cost
10233: ,null --pfxat.prj_brdn_cost

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

10226: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10227: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10228: ,ppeph.name
10229: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
10230: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
10231: ,null --NVL(pfxat.equipment_hours,0)
10232: ,null --pfxat.prj_raw_cost
10233: ,null --pfxat.prj_brdn_cost
10234: ,null --NVL(pfxat.prj_brdn_cost,0)

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

10979: ,pt.attribute9
10980: ,pt.attribute10
10981: ,ppwa.lifecycle_version_id
10982: ,ppv.TASK_UNPUB_VER_STATUS_CODE
10983: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
10984: ,to_number(null)
10985: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10986: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10987: ,ppeph.name

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

10984: ,to_number(null)
10985: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10986: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10987: ,ppeph.name
10988: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
10989: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
10990: ,null --NVL(pfxat.equipment_hours,0)
10991: ,null --pfxat.prj_raw_cost
10992: ,null --pfxat.prj_brdn_cost

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

10985: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
10986: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
10987: ,ppeph.name
10988: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
10989: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
10990: ,null --NVL(pfxat.equipment_hours,0)
10991: ,null --pfxat.prj_raw_cost
10992: ,null --pfxat.prj_brdn_cost
10993: ,null --NVL(pfxat.prj_brdn_cost,0)

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

11793: ,pt.attribute10
11794: --------------------------------------------------------------------
11795: ,to_number(null) -- lifecycle version id
11796: ,ppv.TASK_UNPUB_VER_STATUS_CODE
11797: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
11798: ,to_number(null)
11799: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
11800: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
11801: ,null --current phase name

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

11798: ,to_number(null)
11799: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
11800: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
11801: ,null --current phase name
11802: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
11803: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
11804: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
11805: ,pfxat.prj_raw_cost raw_cost
11806: ,pfxat.prj_brdn_cost burdened_cost

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

11799: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
11800: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
11801: ,null --current phase name
11802: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
11803: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
11804: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
11805: ,pfxat.prj_raw_cost raw_cost
11806: ,pfxat.prj_brdn_cost burdened_cost
11807: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

12621: ,pt.attribute10
12622: --------------------------------------------------------------------
12623: ,to_number(null) -- lifecycle version id
12624: ,ppv.TASK_UNPUB_VER_STATUS_CODE
12625: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
12626: ,to_number(null)
12627: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12628: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12629: ,null --current phase name

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

12626: ,to_number(null)
12627: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12628: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12629: ,null --current phase name
12630: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
12631: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
12632: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
12633: ,pfxat.prj_raw_cost raw_cost
12634: ,pfxat.prj_brdn_cost burdened_cost

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

12627: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
12628: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
12629: ,null --current phase name
12630: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
12631: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
12632: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
12633: ,pfxat.prj_raw_cost raw_cost
12634: ,pfxat.prj_brdn_cost burdened_cost
12635: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

13450: ,pt.attribute10
13451: --------------------------------------------------------------------
13452: ,to_number(null) -- lifecycle version id
13453: ,ppv.TASK_UNPUB_VER_STATUS_CODE
13454: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
13455: ,to_number(null)
13456: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
13457: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
13458: ,null --current phase name

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

13455: ,to_number(null)
13456: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
13457: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
13458: ,null --current phase name
13459: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
13460: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
13461: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
13462: ,pfxat.prj_raw_cost raw_cost
13463: ,pfxat.prj_brdn_cost burdened_cost

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

13456: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
13457: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
13458: ,null --current phase name
13459: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
13460: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
13461: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
13462: ,pfxat.prj_raw_cost raw_cost
13463: ,pfxat.prj_brdn_cost burdened_cost
13464: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

14414: ,pt.attribute10
14415: --------------------------------------------------------------------
14416: ,to_number(null) -- lifecycle version id
14417: ,ppv.TASK_UNPUB_VER_STATUS_CODE
14418: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
14419: ,to_number(null)
14420: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
14421: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
14422: ,null --current phase name

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

14419: ,to_number(null)
14420: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
14421: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
14422: ,null --current phase name
14423: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
14424: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
14425: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
14426: ,pfxat.prj_raw_cost raw_cost
14427: ,pfxat.prj_brdn_cost burdened_cost

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

14420: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
14421: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
14422: ,null --current phase name
14423: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
14424: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
14425: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
14426: ,pfxat.prj_raw_cost raw_cost
14427: ,pfxat.prj_brdn_cost burdened_cost
14428: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

15211: ,pt.attribute10
15212: --------------------------------------------------------------------
15213: ,to_number(null) -- lifecycle version id
15214: ,ppv.TASK_UNPUB_VER_STATUS_CODE
15215: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
15216: ,to_number(null)
15217: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
15218: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
15219: ,null --current phase name

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

15216: ,to_number(null)
15217: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
15218: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
15219: ,null --current phase name
15220: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
15221: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
15222: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
15223: ,pfxat.prj_raw_cost raw_cost
15224: ,pfxat.prj_brdn_cost burdened_cost

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

15217: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
15218: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
15219: ,null --current phase name
15220: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
15221: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
15222: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
15223: ,pfxat.prj_raw_cost raw_cost
15224: ,pfxat.prj_brdn_cost burdened_cost
15225: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.

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

16009: ,pt.attribute10
16010: --------------------------------------------------------------------
16011: ,to_number(null) -- lifecycle version id
16012: ,ppv.TASK_UNPUB_VER_STATUS_CODE
16013: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'ISSUE')
16014: ,to_number(null)
16015: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
16016: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
16017: ,null --current phase name

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

16014: ,to_number(null)
16015: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
16016: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
16017: ,null --current phase name
16018: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
16019: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
16020: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
16021: ,pfxat.prj_raw_cost raw_cost
16022: ,pfxat.prj_brdn_cost burdened_cost

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

16015: ,PA_PROJ_ELEMENTS_UTILS.check_child_element_exist(ppv.element_version_id)
16016: ,trunc(ppvsch.scheduled_finish_date) - trunc(sysdate)
16017: ,null --current phase name
16018: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_REQUEST')
16019: ,pa_control_items_utils.get_open_control_items(ppe.project_id,ppe.object_Type,ppe.proj_element_id,'CHANGE_ORDER')
16020: ,pfxat.equipment_hours planned_equip_effort -- Fix for Bug # 4319171.
16021: ,pfxat.prj_raw_cost raw_cost
16022: ,pfxat.prj_brdn_cost burdened_cost
16023: ,pfxat.prj_brdn_cost planned_cost -- Fix for Bug # 4319171.