DBA Data[Home] [Help]

PACKAGE BODY: APPS.GMS_PA_API2

Source


1 PACKAGE BODY gms_pa_api2 AS
2 -- $Header: gmspax2b.pls 120.2 2007/02/06 09:51:44 rshaik ship $
3 -- -----------------------------------
4 -- Function to check the award status .
5 -- -----------------------------------
6   FUNCTION IS_AWARD_CLOSED (x_expenditure_item_id IN NUMBER ,x_task_id IN NUMBER, x_doc_type in varchar2 default 'EXP' ) RETURN VARCHAR2 IS --Bug 5726575
7 
8     x_return VARCHAR2(1) := 'N' ;
9    BEGIN
10     If gms_install.enabled THEN
11        x_return := gms_pa_api.is_award_closed (x_expenditure_item_id ,x_task_id , x_doc_type) ; --Bug 5726575
12     End if ;
13 
14      RETURN x_return ;
15 
16    END IS_AWARD_CLOSED ;
17 
18 
19    -- ====================================================================
20    -- bug : 2733355 Is_grants_enabled function was added.
21    -- This will be used in pa_cdl_burden_detail_v view definition.
22    -- ====================================================================
23    -- return value : Y - Grants enabled.
24    --                N - Grants not enabled.
25 
26    function is_grants_enabled return varchar2 is
27    begin
28 	if gms_install.enabled then
29 		return 'Y' ;
30 	ELSE
31 		return 'N' ;
32 	end if ;
33    end is_grants_enabled ;
34 
35 END gms_pa_api2;