APPS.GMS_PA_API3 dependencies on PA_PROJECT_STUS_UTILS

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

2397: ITEM.request_id = x_request_id
2398: WHERE (ITEM.ind_compiled_set_id = p_ind_compiled_set_id
2399: AND ITEM.enc_distributed_flag = 'Y')
2400: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
2401: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
2402: AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2403: AND exists (select /*+ NO_UNNEST */ null
2404: from pa_cost_base_exp_types cbet
2405: where cbet.cost_base = p_g_impacted_cost_bases

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

2481: WHERE task.task_id = ei.task_id
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:

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

2507: FROM pa_tasks task
2508: WHERE task.task_id = ei.task_id
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

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

2522: request_id = x_request_id
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

Line 2644: l_project_closed := pa_project_stus_utils.Is_Project_Closed(p_project_id);

2640: END IF;
2641:
2642: IF l_award_status <> 'CLOSED' AND l_close_date >= trunc (sysdate ) then /* bug 7225876 */
2643:
2644: l_project_closed := pa_project_stus_utils.Is_Project_Closed(p_project_id);
2645:
2646: UPDATE gms_encumbrance_items_all ITEM
2647: SET ITEM.enc_distributed_flag = 'N',
2648: ITEM.adjustment_type = 'BURDEN_RECALC',

Line 2717: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y' -- bug 7225876

2713: ITEM.last_update_login = x_last_update_login,
2714: ITEM.request_id = x_request_id
2715: WHERE ITEM.enc_distributed_flag = 'Y'
2716: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
2717: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y' -- bug 7225876
2718: -- bug 7225876 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2719: AND EXISTS
2720: ( select null
2721: from gms_award_distributions adl

Line 2753: l_project_closed := pa_project_stus_utils.Is_Project_Closed(p_project_id);

2749: END IF;
2750:
2751: IF l_award_status <> 'CLOSED' AND l_close_date >= trunc (sysdate ) then -- bug 7225876
2752:
2753: l_project_closed := pa_project_stus_utils.Is_Project_Closed(p_project_id);
2754:
2755: UPDATE gms_encumbrance_items_all ITEM
2756: SET ITEM.enc_distributed_flag = 'N',
2757: ITEM.adjustment_type = 'BURDEN_RECALC',

Line 2824: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y' --BUG 7225876

2820: ITEM.last_update_login = x_last_update_login,
2821: ITEM.request_id = x_request_id
2822: WHERE ITEM.enc_distributed_flag = 'Y'
2823: AND NVL(ITEM.net_zero_adjustment_flag,'N') <> 'Y'
2824: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y' --BUG 7225876
2825: --BUG 6967150 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2826: AND EXISTS ( select null
2827: from gms_award_distributions adl
2828: where adl.expenditure_item_id = ITEM.encumbrance_item_id