[Home] [Help]
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
4318: where cbet.cost_base = G_IMPACTED_COST_BASES_TAB(i)
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
4531: -- where cbet.cost_base = cost_base_rec.cost_base -- 4527736
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
4621: --where cbet.cost_base = cost_base_rec.cost_base
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
4845: SELECT expenditure_item_id
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
4867: SELECT expenditure_item_id
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
4889: IS
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
4913: IS
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
4937: IS
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
4961: IS
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
4979: SELECT expenditure_item_id
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
4997: SELECT expenditure_item_id
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
5015: SELECT expenditure_item_id
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
5045: SELECT expenditure_item_id
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
5076: SELECT expenditure_item_id
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: /*
5106: * IC related change:
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
5159: AND NVL(l_end_date, NVL(task.labor_tp_fixed_date,ei.expenditure_item_date))
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:
5186: -- Standard who
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:
5295:
5296: -- consider volume of expenditure items having the same compiled set id
5297: COMMIT;
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
5382: COMMIT;
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
5450: COMMIT;
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;
5523:
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:
5608: COMMIT;
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
5694: COMMIT;
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
5762: COMMIT;
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:
5838: ei_count := 0;
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
5918: FROM pa_tasks task, pa_system_linkages syslink /*, pa_projects_all proj :Redundant :2933915*/
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:
6016:
6017: /*2933915 :Added the exists clause in above update to indicate that except profile ='Y' and display_method ='D' -for all cases we will
6018: be marking ei for cost reprocessing */
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
6096:
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;
6193:
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
6278: on separate ei */