[Home] [Help]
2415: AND DECODE(p_rate_sch_rev_id ,p_g_rate_sch_rev_id ,DECODE(ICS.ORGANIZATION_ID,p_g_org_id ,p_g_org_override
2416: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(p_rate_sch_rev_id ,ICS.ORGANIZATION_ID))
2417: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(p_rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
2418: )
2419: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d');
2420: exception
2421: when others then
2422: errbuf := sqlcode;
2423: retcode := sqlerrm;
2479: AND task.cost_ind_sch_fixed_date BETWEEN p_start_date AND
2480: NVL(p_end_date, cost_ind_sch_fixed_date))
2481: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
2482: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y'
2483: AND pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) = 'D'
2484: AND gms_pa_api2.is_award_closed(ei.encumbrance_item_id,ei.task_id, 'ENC') = 'N';*/
2485: elsif p_mode = 'N' then --Update based on task.cost_ind_sch_fixed_date IS NULL then go by enc_item_date
2486: NULL;
2487: --update commented for the Bug#5989869
2502: AND task.cost_ind_sch_fixed_date IS NULL)
2503: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
2504: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'
2505: AND gms_pa_api2.is_award_closed(ei.encumbrance_item_id,ei.task_id, 'ENC') = 'N'
2506: AND pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) = 'D';*/
2507: elsif p_mode = 'O' then --Update based on enc_item_date
2508: UPDATE gms_encumbrance_items_all ei
2509: SET enc_distributed_flag = 'N' ,
2510: adjustment_type ='BURDEN_RECOMPILE',
2515: WHERE ei.ind_compiled_set_id = p_compiled_set_id
2516: AND ei.encumbrance_item_date between p_start_date and nvl(p_end_date, ei.encumbrance_item_date) --Bug#5989869; Removed TRUNC
2517: AND nvl(ei.net_zero_adjustment_flag, 'N') <> 'Y'
2518: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'
2519: --AND pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) = 'D' commented for bug#5989869
2520: AND gms_pa_api2.is_award_closed(ei.encumbrance_item_id,ei.task_id, 'ENC') = 'N';
2521: end if;
2522: exception
2523: when others then
2653: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2654: and adl.award_id = p_award_id )
2655: AND ITEM.encumbrance_item_date between l_start_date_min
2656: and nvl(l_end_date_max,ITEM.encumbrance_item_date) -- dates corresponding to schedule revisions
2657: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2658: AND ITEM.ind_compiled_set_id is not null
2659: AND 1 = decode(p_event, 'INSERT', 1
2660: , (select 1
2661: from pa_ind_compiled_sets ics,
2688: from gms_award_distributions adl
2689: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2690: and adl.award_id = p_award_id )
2691: AND ITEM.encumbrance_item_date between l_start_date_min and nvl(l_end_date_max,ITEM.encumbrance_item_date)
2692: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2693: AND ITEM.ind_compiled_set_id is not null
2694: AND NOT EXISTS
2695: ( select 1
2696: from GMS_OVERRIDE_SCHEDULES GOS,
2747: AND EXISTS ( select null
2748: from gms_award_distributions adl
2749: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2750: and adl.award_id = p_award_id )
2751: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2752: AND ITEM.ind_compiled_set_id is not null
2753: AND 1 = decode(p_event, 'INSERT', 1
2754: , (select 1
2755: from pa_ind_compiled_sets ics,
2789: where GOS.award_id = p_award_id
2790: and GOS.project_id = ITEM.project_id
2791: and ITEM.task_id = TASK.task_id
2792: and nvl(GOS.task_id, TASK.top_task_id) = TASK.top_task_id)
2793: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d');
2794:
2795: end if;
2796: end if;
2797: exception