APPS.PA_COST_PLUS dependencies on PA_PROJECT_STUS_UTILS

Line 4313: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'

4309: NULL, ITEM.tp_rule_percentage)
4310: WHERE ((ITEM.cost_ind_compiled_set_id = cs1_row.ind_compiled_set_id AND ITEM.cost_distributed_flag = 'Y')
4311: OR ITEM.tp_ind_compiled_set_id = cs1_row.ind_compiled_set_id)
4312: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4313: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4314: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4315: AND exists (select /*+ NO_UNNEST */ null
4316: from pa_cost_base_exp_types cbet
4317: --where cbet.cost_base = cost_base_rec.cost_base

Line 4526: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'

4522: ITEM.burden_cost)
4523: ***************************/
4524: WHERE (ITEM.tp_ind_compiled_set_id = cs1_row.ind_compiled_set_id OR
4525: ITEM.cost_ind_compiled_set_id = cs1_row.ind_compiled_set_id )
4526: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4527: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4528: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4529: AND exists (select /*+ NO_UNNEST */ null
4530: from pa_cost_base_exp_types cbet

Line 4616: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'

4612: ITEM.program_id = x_program_id,
4613: ITEM.program_update_date = SYSDATE
4614: WHERE (ITEM.rev_ind_compiled_set_id = cs1_row.ind_compiled_set_id
4615: OR ITEM.inv_ind_compiled_set_id = cs1_row.ind_compiled_set_id)
4616: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4617: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4618: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y' /* missing condition added for bug 4574721 */
4619: AND EXISTS (select /*+ NO_UNNEST */ 1
4620: from pa_cost_base_exp_types cbet

Line 4839: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4835: (select t.task_id
4836: FROM pa_projects_all p, pa_tasks t
4837: WHERE t.project_id=p.project_id AND
4838: ei.task_id = t.task_id AND
4839: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4840: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4841: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N'; /*3059344*/
4842:
4843: CURSOR ei2_cursor

Line 4840: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4836: FROM pa_projects_all p, pa_tasks t
4837: WHERE t.project_id=p.project_id AND
4838: ei.task_id = t.task_id AND
4839: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4840: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4841: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N'; /*3059344*/
4842:
4843: CURSOR ei2_cursor
4844: IS

Line 4861: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4857: (select t.task_id
4858: FROM pa_projects_all p, pa_tasks t
4859: WHERE t.project_id=p.project_id AND
4860: ei.task_id = t.task_id AND
4861: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4862: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4863: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4864:
4865: CURSOR ei3_cursor

Line 4862: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4858: FROM pa_projects_all p, pa_tasks t
4859: WHERE t.project_id=p.project_id AND
4860: ei.task_id = t.task_id AND
4861: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4862: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4863: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4864:
4865: CURSOR ei3_cursor
4866: IS

Line 4883: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4879: (select t.task_id
4880: FROM pa_projects_all p, pa_tasks t
4881: WHERE t.project_id=p.project_id AND
4882: ei.task_id = t.task_id AND
4883: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4884: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4885: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4886:
4887:

Line 4884: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4880: FROM pa_projects_all p, pa_tasks t
4881: WHERE t.project_id=p.project_id AND
4882: ei.task_id = t.task_id AND
4883: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4884: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4885: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4886:
4887:
4888: CURSOR ei4_cursor

Line 4907: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4903: (select t.task_id
4904: FROM pa_projects_all p, pa_tasks t
4905: WHERE t.project_id=p.project_id AND
4906: ei.task_id = t.task_id AND
4907: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4908: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4909: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4910:
4911:

Line 4908: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4904: FROM pa_projects_all p, pa_tasks t
4905: WHERE t.project_id=p.project_id AND
4906: ei.task_id = t.task_id AND
4907: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4908: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4909: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4910:
4911:
4912: CURSOR ei5_cursor

Line 4931: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/

4927: (select t.task_id
4928: FROM pa_projects_all p, pa_tasks t
4929: WHERE t.project_id=p.project_id AND
4930: ei.task_id = t.task_id AND
4931: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4932: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4933: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4934:
4935:

Line 4932: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4928: FROM pa_projects_all p, pa_tasks t
4929: WHERE t.project_id=p.project_id AND
4930: ei.task_id = t.task_id AND
4931: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4932: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4933: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4934:
4935:
4936: CURSOR ei6_cursor

Line 4955: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/

4951: (select t.task_id
4952: FROM pa_projects_all p, pa_tasks t
4953: WHERE t.project_id=p.project_id AND
4954: ei.task_id = t.task_id AND
4955: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
4956: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4957: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4958:
4959:

Line 4956: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4952: FROM pa_projects_all p, pa_tasks t
4953: WHERE t.project_id=p.project_id AND
4954: ei.task_id = t.task_id AND
4955: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
4956: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4957: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4958:
4959:
4960: CURSOR ei7_cursor

Line 4973: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

4969: (select t.task_id
4970: FROM pa_projects_all p, pa_tasks t
4971: WHERE t.project_id=p.project_id AND
4972: ei.task_id = t.task_id AND
4973: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
4974: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4975: AND (decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4976:
4977: CURSOR ei8_cursor

Line 4974: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4970: FROM pa_projects_all p, pa_tasks t
4971: WHERE t.project_id=p.project_id AND
4972: ei.task_id = t.task_id AND
4973: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
4974: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4975: AND (decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4976:
4977: CURSOR ei8_cursor
4978: IS

Line 4991: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/

4987: (select t.task_id
4988: FROM pa_projects_all p, pa_tasks t
4989: WHERE t.project_id=p.project_id AND
4990: ei.task_id = t.task_id AND
4991: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
4992: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4993: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4994:
4995: CURSOR ei9_cursor

Line 4992: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

4988: FROM pa_projects_all p, pa_tasks t
4989: WHERE t.project_id=p.project_id AND
4990: ei.task_id = t.task_id AND
4991: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
4992: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4993: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4994:
4995: CURSOR ei9_cursor
4996: IS

Line 5009: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915 */

5005: (select t.task_id
5006: FROM pa_projects_all p, pa_tasks t
5007: WHERE t.project_id=p.project_id AND
5008: ei.task_id = t.task_id AND
5009: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915 */
5010: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5011: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5012:
5013: CURSOR ei10_cursor

Line 5010: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5006: FROM pa_projects_all p, pa_tasks t
5007: WHERE t.project_id=p.project_id AND
5008: ei.task_id = t.task_id AND
5009: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915 */
5010: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5011: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5012:
5013: CURSOR ei10_cursor
5014: IS

Line 5039: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/

5035: (select t.task_id
5036: FROM pa_projects_all p, pa_tasks t
5037: WHERE t.project_id=p.project_id AND
5038: ei.task_id = t.task_id AND
5039: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5040: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5041: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5042:
5043: CURSOR ei11_cursor

Line 5040: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5036: FROM pa_projects_all p, pa_tasks t
5037: WHERE t.project_id=p.project_id AND
5038: ei.task_id = t.task_id AND
5039: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5040: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5041: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5042:
5043: CURSOR ei11_cursor
5044: IS

Line 5070: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/

5066: (select t.task_id
5067: FROM pa_projects_all p, pa_tasks t
5068: WHERE t.project_id=p.project_id AND
5069: ei.task_id = t.task_id AND
5070: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5071: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5072: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5073:
5074: CURSOR ei12_cursor

Line 5071: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5067: FROM pa_projects_all p, pa_tasks t
5068: WHERE t.project_id=p.project_id AND
5069: ei.task_id = t.task_id AND
5070: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5071: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5072: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5073:
5074: CURSOR ei12_cursor
5075: IS

Line 5100: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

5096: (select t.task_id
5097: FROM pa_projects_all p, pa_tasks t
5098: WHERE t.project_id=p.project_id AND
5099: ei.task_id = t.task_id AND
5100: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5101: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5102: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5103:
5104:

Line 5101: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/

5097: FROM pa_projects_all p, pa_tasks t
5098: WHERE t.project_id=p.project_id AND
5099: ei.task_id = t.task_id AND
5100: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5101: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5102: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5103:
5104:
5105: /*

Line 5139: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y';*/

5135: syslink.labor_non_labor_flag = 'N')
5136: )
5137: AND nvl(ei.net_zero_adjustment_flag, 'N') <> 'Y'
5138: AND proj.project_id = task.project_id
5139: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y';*/
5140:
5141: /*Bug# 2164590:Changed ei13_cursor for performance*/
5142: CURSOR ei13_cursor
5143: IS

Line 5154: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

5150: WHERE task.task_id = ei.task_id
5151: AND ei.system_linkage_function = syslink.function
5152: /*AND task.project_id = proj.project_id 2933915*/
5153: AND task.project_id = ei.project_id /*2933915*/
5154: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
5155: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ) /*3059344*/
5156: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5157: AND ((NVL(task.labor_tp_fixed_date, ei.expenditure_item_date) BETWEEN --Bug 5917245 Removed TRUNC
5158: l_start_date

Line 5180: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y' ****2933915*/

5176: NVL(l_end_date, ei.expenditure_item_date)
5177: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5178: /**** AND ei.task_id = task.task_id
5179: AND proj.project_id = task.project_id
5180: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y' ****2933915*/
5181: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
5182: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5183:
5184:

Line 5181: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

5177: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5178: /**** AND ei.task_id = task.task_id
5179: AND proj.project_id = task.project_id
5180: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y' ****2933915*/
5181: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
5182: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5183:
5184:
5185:

Line 5289: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/

5285: (select t.task_id
5286: FROM pa_projects_all p, pa_tasks t
5287: WHERE t.project_id=p.project_id AND
5288: ei.task_id = t.task_id AND
5289: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5290: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/
5291: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5292: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
5293: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );

Line 5290: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/

5286: FROM pa_projects_all p, pa_tasks t
5287: WHERE t.project_id=p.project_id AND
5288: ei.task_id = t.task_id AND
5289: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5290: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/
5291: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5292: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
5293: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5294:

Line 5376: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commenteed for bug# 2933915*/

5372: (select t.task_id
5373: FROM pa_projects_all p, pa_tasks t
5374: WHERE t.project_id=p.project_id AND
5375: ei.task_id = t.task_id AND
5376: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commenteed for bug# 2933915*/
5377: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5378: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5379:
5380:

Line 5377: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5373: FROM pa_projects_all p, pa_tasks t
5374: WHERE t.project_id=p.project_id AND
5375: ei.task_id = t.task_id AND
5376: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commenteed for bug# 2933915*/
5377: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5378: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5379:
5380:
5381: -- consider volume of expenditure items having the same compiled set id

Line 5444: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

5440: (select t.task_id
5441: FROM pa_projects_all p, pa_tasks t
5442: WHERE t.project_id=p.project_id AND
5443: ei.task_id = t.task_id AND
5444: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5445: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5446: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5447:
5448:

Line 5445: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5441: FROM pa_projects_all p, pa_tasks t
5442: WHERE t.project_id=p.project_id AND
5443: ei.task_id = t.task_id AND
5444: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5445: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5446: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5447:
5448:
5449: -- consider volume of expenditure items having the same compiled set id

Line 5517: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

5513: (select t.task_id
5514: FROM pa_projects_all p, pa_tasks t
5515: WHERE t.project_id=p.project_id AND
5516: ei.task_id = t.task_id AND
5517: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
5518: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5519: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5520:
5521: -- consider volume of expenditure items having the same compiled set id

Line 5518: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5514: FROM pa_projects_all p, pa_tasks t
5515: WHERE t.project_id=p.project_id AND
5516: ei.task_id = t.task_id AND
5517: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
5518: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5519: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5520:
5521: -- consider volume of expenditure items having the same compiled set id
5522: COMMIT;

Line 5602: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/

5598: (select t.task_id
5599: FROM pa_projects_all p, pa_tasks t
5600: WHERE t.project_id=p.project_id AND
5601: ei.task_id = t.task_id AND
5602: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5603: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5604: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5605: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5606: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;

Line 5603: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5599: FROM pa_projects_all p, pa_tasks t
5600: WHERE t.project_id=p.project_id AND
5601: ei.task_id = t.task_id AND
5602: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5603: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5604: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5605: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5606: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;
5607:

Line 5688: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/

5684: (select t.task_id
5685: FROM pa_projects_all p, pa_tasks t
5686: WHERE t.project_id=p.project_id AND
5687: ei.task_id = t.task_id AND
5688: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
5689: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5690: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5691:
5692:

Line 5689: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5685: FROM pa_projects_all p, pa_tasks t
5686: WHERE t.project_id=p.project_id AND
5687: ei.task_id = t.task_id AND
5688: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
5689: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5690: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5691:
5692:
5693: -- consider volume of expenditure items having the same compiled set id

Line 5756: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

5752: (select t.task_id
5753: FROM pa_projects_all p, pa_tasks t
5754: WHERE t.project_id=p.project_id AND
5755: ei.task_id = t.task_id AND
5756: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5757: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5758: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5759:
5760:

Line 5757: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5753: FROM pa_projects_all p, pa_tasks t
5754: WHERE t.project_id=p.project_id AND
5755: ei.task_id = t.task_id AND
5756: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5757: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5758: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5759:
5760:
5761: -- consider volume of expenditure items having the same compiled set id

Line 5832: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/

5828: (select t.task_id
5829: FROM pa_projects_all p, pa_tasks t
5830: WHERE t.project_id=p.project_id AND
5831: ei.task_id = t.task_id AND
5832: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5833: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5834: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5835:
5836: COMMIT;

Line 5833: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

5829: FROM pa_projects_all p, pa_tasks t
5830: WHERE t.project_id=p.project_id AND
5831: ei.task_id = t.task_id AND
5832: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5833: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5834: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5835:
5836: COMMIT;
5837:

Line 5913: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'

5909: program_application_id = x_program_application_id,
5910: program_id = x_program_id,
5911: program_update_date = SYSDATE
5912: WHERE tp_ind_compiled_set_id = compiled_set_id
5913: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'
5914: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5915: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5916: AND EXISTS
5917: (SELECT task_id

Line 6010: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6006: (select t.task_id
6007: FROM pa_projects_all p, pa_tasks t
6008: WHERE t.project_id=p.project_id AND
6009: ei.task_id = t.task_id AND
6010: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6011: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6012: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6013: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6014: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;

Line 6011: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/

6007: FROM pa_projects_all p, pa_tasks t
6008: WHERE t.project_id=p.project_id AND
6009: ei.task_id = t.task_id AND
6010: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6011: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6012: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6013: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6014: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6015:

Line 6090: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6086: (select t.task_id
6087: FROM pa_projects_all p, pa_tasks t
6088: WHERE t.project_id=p.project_id AND
6089: ei.task_id = t.task_id AND
6090: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6091: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6092: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6093:
6094:

Line 6091: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

6087: FROM pa_projects_all p, pa_tasks t
6088: WHERE t.project_id=p.project_id AND
6089: ei.task_id = t.task_id AND
6090: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6091: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6092: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6093:
6094:
6095: FOR ei8_row IN ei8_cursor LOOP

Line 6187: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6183: (select t.task_id
6184: FROM pa_projects_all p, pa_tasks t
6185: WHERE t.project_id=p.project_id AND
6186: ei.task_id = t.task_id AND
6187: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6188: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6189: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6190:
6191: -- consider volume of expenditure items having the same compiled set id

Line 6188: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

6184: FROM pa_projects_all p, pa_tasks t
6185: WHERE t.project_id=p.project_id AND
6186: ei.task_id = t.task_id AND
6187: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6188: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6189: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6190:
6191: -- consider volume of expenditure items having the same compiled set id
6192: COMMIT;

Line 6272: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/

6268: (select t.task_id
6269: FROM pa_projects_all p, pa_tasks t
6270: WHERE t.project_id=p.project_id AND
6271: ei.task_id = t.task_id AND
6272: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6273: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6274: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6275:
6276:

Line 6273: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/

6269: FROM pa_projects_all p, pa_tasks t
6270: WHERE t.project_id=p.project_id AND
6271: ei.task_id = t.task_id AND
6272: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6273: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6274: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6275:
6276:
6277: /***2933915:UPDATE eis for 'BURDEN_RESUMMARIZE' ONLY if cost_distributed_flag ='Y' and profile option is enabled and burdening is