1 package GMS_INSTALL as
2 -- $Header: GMSINSTS.pls 120.2 2005/07/29 13:50:28 bkattupa noship $
3
4 /*---------------------------------------------------------------
5 function ENABLED return boolean
6
7 Function to check the implementation status of OGM
8 from Oracle applications
9 Return values
10 TRUE if OGM is implemented for the login org_id
11 FALSE if OGM is not implemented for login org_id
12 --------------------------------------------------------------- */
13 function ENABLED return boolean;
14 /* PRAGMA RESTRICT_REFERENCES(enabled, WNDS,WNPS); */
15
16 /*---------------------------------------------------------------
17 function ENABLED(x_org_id NUMBER) return boolean
18
19 Function to check the implementation status of OGM
20 for an Organization.
21 Parameter
22 x_org_id : The multi org org_id for which
23 OGM implemention status is requested.
24 Return value
25 TRUE if OGM is implemented for the x_org_id passed.
26 FALSE if OGM is not implemented for the x_org_id passed.
27 --------------------------------------------------------------- */
28 function ENABLED(x_org_id NUMBER) return boolean;
29 PRAGMA RESTRICT_REFERENCES(enabled, WNDS,WNPS);
30
31 /*---------------------------------------------------------------
32 function FAB_ENABLED return boolean
33
34 Function to check the FAB implementation status of OGM.
35 Returns
36 TRUE if OGM FAB is implemented for the Login Responsibility .
37 FALSE if OGM FAB is not implemented for the Login Responsibility .
38 --------------------------------------------------------------- */
39 function FAB_ENABLED return boolean;
40 PRAGMA RESTRICT_REFERENCES(fab_enabled, WNDS,WNPS);
41
42 /*---------------------------------------------------------------
43 function FAB_ENABLED(x_org_id NUMBER) return boolean
44
45 Function to check the FAB implementation status of OGM for an Organization.
46 Returns
47 TRUE if OGM FAB is implemented for the login Responsibility.
48 FALSE if OGM FAB is not implemented for the Login Responsibility.
49 --------------------------------------------------------------- */
50 function FAB_ENABLED(x_org_id NUMBER) return boolean;
51 PRAGMA RESTRICT_REFERENCES(fab_enabled, WNDS,WNPS);
52
53 /*---------------------------------------------------------------
54 function SITE_ENABLED return boolean
55
56 Function to check the installation status of OGM at a Site.
57 Returns
58 TRUE if OGM is implemented for any Organization.
59 FALSE if OGM is not implemented for any Organization.
60 --------------------------------------------------------------- */
61 function SITE_ENABLED return boolean;
62 PRAGMA RESTRICT_REFERENCES(site_enabled, WNDS,WNPS);
63
64
65 -- -----------------------------------------------------------------+
66 -- MOAC changes start .. the following procedure and function is
67 -- accessed from GMS.pld ..
68 -- -----------------------------------------------------------------+
69
70 Type TypeNum is table of number index by binary_integer;
71 t_org_id TypeNum;
72
73 g_sponsored_flag VARCHAR2(1);
74 g_project_id pa_projects_all.project_id%TYPE;
75
76 -- This function will check if the project is sponsored
77 FUNCTION is_sponsored_project ( p_project_id NUMBER )
78 RETURN VARCHAR2 ;
79
80 -- This procedure will build the pl/sql org table .. containing orgs
81 -- where grants is implemented
82
83 PROCEDURE SET_ORG_ARRAY;
84
85 --This procedure will be called from gms.style and gms.event for AP/PO ..
86 FUNCTION GMS_ENABLED_MOAC(p_org_id IN NUMBER) RETURN BOOLEAN;
87
88 -- -----------------------------------------------------------------+
89 -- MOAC changes end
90 -- -----------------------------------------------------------------+
91
92 end GMS_INSTALL;