[Home] [Help]
1: PACKAGE BODY gms_pa_api3 AS
2: /* $Header: gmspax3b.pls 120.11 2010/08/27 14:11:57 prabsing ship $ */
3:
4: /* added as part of bug 6761516 */
5: TYPE t_numb_tab is table of number index by binary_integer;
85: IF p_tran_item_id is NULL THEN
86: return ;
87: END IF ;
88:
89: gms_pa_api.Override_Rate_Rev_Id(
90: p_tran_item_id,
91: p_tran_type ,
92: p_task_id ,
93: p_schedule_type ,
2301: -- p_project_type varchar2
2302: -- End of comments
2303: -- ===============
2304: -- bug reference : 3596872
2305: -- problem : Please put the SELECT statement in the api :- GMS_PA_API3.IS_PROJECT_TYPE_SPONSORED in a cursor.
2306: -- If no record is found, the api should return 'N'.
2307: -- Otherwise, it is throwing a NO-DATA-FOUND error.
2308: -- Situation : When new project type is being created and not saved yet.
2309: --
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
2406: AND cbet.cost_plus_structure = p_g_cp_structure
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
2491:
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
2516: UPDATE gms_encumbrance_items_all ei
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
2532: errbuf := sqlcode;
2671: ,decode((select top_task_id
2672: from pa_tasks
2673: where task_id = ITEM.task_id), p_task_id ,1
2674: ,2))*/
2675: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2676: AND l_project_closed <>'Y' --bug 7225876
2677: --bug 6967150 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2678: AND EXISTS ( select null
2679: from gms_award_distributions adl
2673: where task_id = ITEM.task_id), p_task_id ,1
2674: ,2))*/
2675: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2676: AND l_project_closed <>'Y' --bug 7225876
2677: --bug 6967150 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2678: AND EXISTS ( select null
2679: from gms_award_distributions adl
2680: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2681: and adl.document_type = 'ENC' -- Added these three checks for bug 7225876
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
2722: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2780: ,decode((select top_task_id
2781: from pa_tasks
2782: where task_id = ITEM.task_id), p_task_id ,1
2783: ,2))*/
2784: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2785: AND l_project_closed <>'Y' --bug 7225876
2786: --bug6967150 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2787: AND EXISTS ( select null
2788: from gms_award_distributions adl
2782: where task_id = ITEM.task_id), p_task_id ,1
2783: ,2))*/
2784: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2785: AND l_project_closed <>'Y' --bug 7225876
2786: --bug6967150 AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2787: AND EXISTS ( select null
2788: from gms_award_distributions adl
2789: where adl.expenditure_item_id = ITEM.encumbrance_item_id
2790: and adl.document_type = 'ENC' -- Added the three conditions for bug 7225876
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
2829: and adl.document_type = 'ENC' -- Added following three condition for bug 7225876
2962:
2963: end item_task_validate;
2964: /* Bug 6761516 end */
2965:
2966: END gms_pa_api3;