[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;
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: --
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
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
2962:
2963: end item_task_validate;
2964: /* Bug 6761516 end */
2965:
2966: END gms_pa_api3;