[Home] [Help]
2417: 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
2418: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(p_rate_sch_rev_id ,ICS.ORGANIZATION_ID))
2419: , PA_COST_PLUS.CHECK_FOR_EXPLICIT_MULTIPLIER(p_rate_sch_rev_id ,ICS.ORGANIZATION_ID ))=0
2420: )
2421: AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d');
2422: exception
2423: when others then
2424: errbuf := sqlcode;
2425: retcode := sqlerrm;
2482: AND task.cost_ind_sch_fixed_date BETWEEN p_start_date AND
2483: NVL(p_end_date, cost_ind_sch_fixed_date))
2484: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
2485: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <>'Y'
2486: AND pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) = 'D'
2487: AND gms_pa_api2.is_award_closed(ei.encumbrance_item_id,ei.task_id, 'ENC') = 'N';
2488:
2489:
2490: elsif p_mode = 'N' then --Update based on task.cost_ind_sch_fixed_date IS NULL then go by enc_item_date
2509: AND task.cost_ind_sch_fixed_date IS NULL)
2510: AND nvl(ei.net_zero_adjustment_flag, 'N') <>'Y'
2511: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'
2512: AND gms_pa_api2.is_award_closed(ei.encumbrance_item_id,ei.task_id, 'ENC') = 'N'
2513: AND pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) = 'D';
2514:
2515: elsif p_mode = 'O' then --Update based on enc_item_date
2516: UPDATE gms_encumbrance_items_all ei
2517: SET enc_distributed_flag = 'N' ,
2523: WHERE ei.ind_compiled_set_id = p_compiled_set_id
2524: AND ei.encumbrance_item_date between p_start_date and nvl(p_end_date, ei.encumbrance_item_date) --Bug#5989869; Removed TRUNC
2525: AND nvl(ei.net_zero_adjustment_flag, 'N') <> 'Y'
2526: AND pa_project_stus_utils.Is_Project_Closed(ei.project_id) <> 'Y'
2527: --AND pa_utils2.Proj_Type_Burden_Disp_Method(ei.project_id) = 'D' commented for bug#5989869
2528: AND gms_pa_api2.is_award_closed(ei.encumbrance_item_id,ei.task_id, 'ENC') = 'N';
2529: end if;
2530: exception
2531: when others then
2683: and adl.adl_line_num = 1
2684: and adl.award_id = p_award_id )
2685: AND ITEM.encumbrance_item_date between l_start_date_min
2686: and nvl(l_end_date_max,ITEM.encumbrance_item_date) -- dates corresponding to schedule revisions
2687: --bug 7225876 AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2688: AND ITEM.ind_compiled_set_id > 0 -- bug 7225876
2689: AND 1 = decode(p_event, 'INSERT', 1
2690: , (select 1
2691: from pa_ind_compiled_sets ics,
2724: and adl.document_type = 'ENC' -- Added these three conditions for bug 7225876
2725: and adl.adl_status = 'A'
2726: and adl.adl_line_num = 1)
2727: AND ITEM.encumbrance_item_date between l_start_date_min and nvl(l_end_date_max,ITEM.encumbrance_item_date)
2728: -- bug 6967150 AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2729: AND ITEM.ind_compiled_set_id > 0 -- bug 7225876
2730: AND NOT EXISTS
2731: ( select 1
2732: from GMS_OVERRIDE_SCHEDULES GOS,
2790: and adl.document_type = 'ENC' -- Added the three conditions for bug 7225876
2791: and adl.adl_status = 'A'
2792: and adl.adl_line_num = 1
2793: and adl.award_id = p_award_id )
2794: --bug 7225876 AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2795: AND ITEM.ind_compiled_set_id > 0 -- bug 7225876
2796: AND 1 = decode(p_event, 'INSERT', 1
2797: , (select 1
2798: from pa_ind_compiled_sets ics,
2839: and GOS.project_id = ITEM.project_id
2840: and TASK.task_id = item.task_id
2841: and nvl(GOS.task_id, TASK.top_task_id) = TASK.top_task_id);
2842: END IF;
2843: --BUG 7225876 AND pa_utils2.Proj_Type_Burden_Disp_Method(ITEM.project_id) IN ('S','s','D','d')
2844:
2845: end if;
2846: end if;
2847: exception