[Home] [Help]
1: PACKAGE BODY gms_pa_api3 AS
2: /* $Header: gmspax3b.pls 120.8 2008/01/24 09:00:32 prabsing ship $ */
3:
4: /* added as part of bug 6761516 */
5: TYPE t_numb_tab is table of number index by binary_integer;
2299: -- p_project_type varchar2
2300: -- End of comments
2301: -- ===============
2302: -- bug reference : 3596872
2303: -- problem : Please put the SELECT statement in the api :- GMS_PA_API3.IS_PROJECT_TYPE_SPONSORED in a cursor.
2304: -- If no record is found, the api should return 'N'.
2305: -- Otherwise, it is throwing a NO-DATA-FOUND error.
2306: -- Situation : When new project type is being created and not saved yet.
2307: --
2644: ,decode((select top_task_id
2645: from pa_tasks
2646: where task_id = ITEM.task_id), p_task_id ,1
2647: ,2))*/
2648: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2649: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
2650: AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2651: AND EXISTS ( select null
2652: from gms_award_distributions adl
2740: ,decode((select top_task_id
2741: from pa_tasks
2742: where task_id = ITEM.task_id), p_task_id ,1
2743: ,2))*/
2744: AND gms_pa_api3.item_task_validate(p_award_id, p_project_id, p_task_id, ITEM.task_id) = 'Y'
2745: AND pa_project_stus_utils.Is_Project_Closed(ITEM.project_id) <>'Y'
2746: AND gms_pa_api2.is_award_closed(ITEM.encumbrance_item_id,ITEM.task_id, 'ENC') = 'N'
2747: AND EXISTS ( select null
2748: from gms_award_distributions adl
2912:
2913: end item_task_validate;
2914: /* Bug 6761516 end */
2915:
2916: END gms_pa_api3;