[Home] [Help]
4340: WHERE ((ITEM.cost_ind_compiled_set_id = cs1_row.ind_compiled_set_id AND ITEM.cost_distributed_flag = 'Y')
4341: OR ITEM.tp_ind_compiled_set_id = cs1_row.ind_compiled_set_id)
4342: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4343: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4344: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4345: AND exists (select /*+ PUSH_SUBQ NO_UNNEST */ null
4346: from pa_cost_base_exp_types cbet
4347: --where cbet.cost_base = cost_base_rec.cost_base
4348: where cbet.cost_base = G_IMPACTED_COST_BASES_TAB(i)
4553: ***************************/
4554: WHERE (ITEM.tp_ind_compiled_set_id = cs1_row.ind_compiled_set_id OR
4555: ITEM.cost_ind_compiled_set_id = cs1_row.ind_compiled_set_id )
4556: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4557: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4558: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
4559: AND exists (select /*+ NO_UNNEST */ null
4560: from pa_cost_base_exp_types cbet
4561: -- where cbet.cost_base = cost_base_rec.cost_base -- 4527736
4643: ITEM.program_update_date = SYSDATE
4644: WHERE (ITEM.rev_ind_compiled_set_id = cs1_row.ind_compiled_set_id
4645: OR ITEM.inv_ind_compiled_set_id = cs1_row.ind_compiled_set_id)
4646: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
4647: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ITEM.expenditure_item_id,ITEM.task_id),'N') = 'N'
4648: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y' /* missing condition added for bug 4574721 */
4649: AND EXISTS (select /*+ NO_UNNEST */ 1
4650: from pa_cost_base_exp_types cbet
4651: --where cbet.cost_base = cost_base_rec.cost_base
4867: WHERE t.project_id=p.project_id AND
4868: ei.task_id = t.task_id AND
4869: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4870: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4871: AND decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N'; /*3059344*/
4872:
4873: CURSOR ei2_cursor
4874: IS
4875: SELECT expenditure_item_id
4889: WHERE t.project_id=p.project_id AND
4890: ei.task_id = t.task_id AND
4891: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4892: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4893: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4894:
4895: CURSOR ei3_cursor
4896: IS
4897: SELECT expenditure_item_id
4911: WHERE t.project_id=p.project_id AND
4912: ei.task_id = t.task_id AND
4913: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4914: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4915: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4916:
4917:
4918: CURSOR ei4_cursor
4919: IS
4935: WHERE t.project_id=p.project_id AND
4936: ei.task_id = t.task_id AND
4937: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4938: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4939: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4940:
4941:
4942: CURSOR ei5_cursor
4943: IS
4959: WHERE t.project_id=p.project_id AND
4960: ei.task_id = t.task_id AND
4961: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug# 2933915*/
4962: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4963: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4964:
4965:
4966: CURSOR ei6_cursor
4967: IS
4983: WHERE t.project_id=p.project_id AND
4984: ei.task_id = t.task_id AND
4985: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
4986: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
4987: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
4988:
4989:
4990: CURSOR ei7_cursor
4991: IS
5001: WHERE t.project_id=p.project_id AND
5002: ei.task_id = t.task_id AND
5003: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5004: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5005: AND (decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5006:
5007: CURSOR ei8_cursor
5008: IS
5009: SELECT expenditure_item_id
5019: WHERE t.project_id=p.project_id AND
5020: ei.task_id = t.task_id AND
5021: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5022: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5023: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5024:
5025: CURSOR ei9_cursor
5026: IS
5027: 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 ei10_cursor
5044: IS
5045: SELECT expenditure_item_id
5067: WHERE t.project_id=p.project_id AND
5068: ei.task_id = t.task_id AND
5069: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5070: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5071: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5072:
5073: CURSOR ei11_cursor
5074: IS
5075: 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: CURSOR ei12_cursor
5105: IS
5106: SELECT expenditure_item_id
5128: WHERE t.project_id=p.project_id AND
5129: ei.task_id = t.task_id AND
5130: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5131: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*Added for bug# 2933915*/
5132: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5133:
5134:
5135: /*
5136: * IC related change:
5181: AND ei.system_linkage_function = syslink.function
5182: /*AND task.project_id = proj.project_id 2933915*/
5183: AND task.project_id = ei.project_id /*2933915*/
5184: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
5185: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ) /*3059344*/
5186: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5187: AND ((NVL(task.labor_tp_fixed_date, ei.expenditure_item_date) BETWEEN --Bug 5917245 Removed TRUNC
5188: l_start_date
5189: AND NVL(l_end_date, NVL(task.labor_tp_fixed_date,ei.expenditure_item_date))
5208: /**** AND ei.task_id = task.task_id
5209: AND proj.project_id = task.project_id
5210: AND pa_project_stus_utils.Is_Project_Status_Closed(proj.project_status_code) <> 'Y' ****2933915*/
5211: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
5212: AND ( decode(l_gms_enabled,'Y',gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id),'N') = 'N' ); /*3059344*/
5213:
5214:
5215:
5216: -- Standard who
5319: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for Bug 2933915*/
5320: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y' /*2933915*/
5321: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5322: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
5323: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5324:
5325:
5326: -- consider volume of expenditure items having the same compiled set id
5327: COMMIT;
5404: WHERE t.project_id=p.project_id AND
5405: ei.task_id = t.task_id AND
5406: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commenteed for bug# 2933915*/
5407: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5408: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5409:
5410:
5411: -- consider volume of expenditure items having the same compiled set id
5412: COMMIT;
5472: WHERE t.project_id=p.project_id AND
5473: ei.task_id = t.task_id AND
5474: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5475: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5476: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5477:
5478:
5479: -- consider volume of expenditure items having the same compiled set id
5480: COMMIT;
5545: WHERE t.project_id=p.project_id AND
5546: ei.task_id = t.task_id AND
5547: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
5548: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5549: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5550:
5551: -- consider volume of expenditure items having the same compiled set id
5552: COMMIT;
5553:
5630: WHERE t.project_id=p.project_id AND
5631: ei.task_id = t.task_id AND
5632: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug 2933915*/
5633: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5634: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5635: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
5636: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y')) ;
5637:
5638: COMMIT;
5716: WHERE t.project_id=p.project_id AND
5717: ei.task_id = t.task_id AND
5718: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug2933915*/
5719: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5720: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5721:
5722:
5723: -- consider volume of expenditure items having the same compiled set id
5724: COMMIT;
5784: WHERE t.project_id=p.project_id AND
5785: ei.task_id = t.task_id AND
5786: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5787: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5788: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5789:
5790:
5791: -- consider volume of expenditure items having the same compiled set id
5792: COMMIT;
5863: WHERE t.project_id=p.project_id AND
5864: ei.task_id = t.task_id AND
5865: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5866: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5867: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5868:
5869: ELSE
5870: UPDATE pa_expenditure_items_all ei
5871: SET revenue_distributed_flag = 'N',
5899: WHERE t.project_id=p.project_id AND
5900: ei.task_id = t.task_id AND
5901: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for bug# 2933915*/
5902: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
5903: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' );
5904:
5905: END IF;
5906:
5907: COMMIT;
5981: program_id = x_program_id,
5982: program_update_date = SYSDATE
5983: WHERE tp_ind_compiled_set_id = compiled_set_id
5984: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'
5985: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' )
5986: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
5987: AND EXISTS
5988: (SELECT task_id
5989: FROM pa_tasks task, pa_system_linkages syslink /*, pa_projects_all proj :Redundant :2933915*/
6143: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6144: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6145: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6146: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6147: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6148:
6149: else
6150: UPDATE pa_expenditure_items_all ei
6151: SET cost_distributed_flag = 'N' ,
6174: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6175: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id)<>'Y' /*2933915*/
6176: AND ((pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s','D','d') AND l_burden_profile ='N') /*Added for 2933915*/
6177: OR (pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) IN ('S','s') AND l_burden_profile ='Y'))
6178: AND ( l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6179:
6180: end if;
6181:
6182:
6255: WHERE t.project_id=p.project_id AND
6256: ei.task_id = t.task_id AND
6257: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6258: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6259: AND (l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6260:
6261:
6262: UPDATE pa_expenditure_items_all ei
6263: SET revenue_distributed_flag = 'N',
6279: WHERE t.project_id=p.project_id AND
6280: ei.task_id = t.task_id AND
6281: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6282: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6283: AND (l_gms_enabled = 'N' OR gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6284:
6285: /* 9266246 - End */
6286:
6287: FOR ei8_row IN ei8_cursor LOOP
6377: WHERE t.project_id=p.project_id AND
6378: ei.task_id = t.task_id AND
6379: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6380: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6381: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6382:
6383: -- consider volume of expenditure items having the same compiled set id
6384: COMMIT;
6385:
6413: WHERE t.project_id=p.project_id AND
6414: ei.task_id = t.task_id AND
6415: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6416: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6417: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6418:
6419: END IF;
6420:
6421: FOR ei12_row IN ei12_cursor LOOP
6497: WHERE t.project_id=p.project_id AND
6498: ei.task_id = t.task_id AND
6499: pa_project_stus_utils.Is_Project_Status_Closed(p.project_status_code)='Y') Commented for 2933915*/
6500: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y' /*2933915*/
6501: AND ( gms_pa_api2.is_award_closed(ei.expenditure_item_id,ei.task_id) = 'N' ) ;
6502:
6503:
6504: /***2933915:UPDATE eis for 'BURDEN_RESUMMARIZE' ONLY if cost_distributed_flag ='Y' and profile option is enabled and burdening is
6505: on separate ei */