DBA Data[Home] [Help]

PACKAGE: APPS.PA_SECURITY

Source


1 PACKAGE pa_security AS
2 /* $Header: PAPLSECS.pls 120.1 2007/10/24 04:22:54 rballamu ship $ */
3 
4   G_user_id		   NUMBER;
5   G_person_id		   NUMBER;
6   G_module_name		   VARCHAR2(30);
7   G_query_allowed	   VARCHAR2(1);
8   G_update_allowed     	   VARCHAR2(1);
9   G_view_labor_costs	   VARCHAR2(1);
10   G_cross_project_user     VARCHAR2(1);
11   G_cross_project_view     VARCHAR2(1);
12 
13   PROCEDURE Initialize ( X_user_id	IN NUMBER
14                        , X_calling_module  IN VARCHAR2 );
15 
16   FUNCTION allow_query ( X_project_id     IN NUMBER) RETURN VARCHAR2;
17   pragma RESTRICT_REFERENCES (allow_query, WNDS, WNPS);
18 
19   FUNCTION allow_update ( X_project_id     IN NUMBER) RETURN VARCHAR2;
20   pragma RESTRICT_REFERENCES (allow_update, WNDS, WNPS);
21 
22   FUNCTION view_labor_costs ( X_project_id     IN NUMBER) RETURN VARCHAR2;
23   pragma RESTRICT_REFERENCES (view_labor_costs, WNDS, WNPS);
24 
25   PROCEDURE set_value ( X_security_level  IN VARCHAR2
26 		      , X_value	          IN VARCHAR2 );
27 
28   FUNCTION check_key_member ( X_person_id    IN NUMBER
29                             , X_project_id   IN NUMBER ) RETURN VARCHAR2;
30   pragma RESTRICT_REFERENCES (check_key_member, WNDS, WNPS);
31 
32   FUNCTION check_key_member_no_dates (X_person_id    IN NUMBER
33                                     , X_project_id   IN NUMBER ) RETURN VARCHAR2;
34   pragma RESTRICT_REFERENCES (check_key_member_no_dates, WNDS, WNPS);
35 
36   FUNCTION check_labor_cost_access ( X_person_id   IN NUMBER
37                                    , X_project_id  IN NUMBER ) RETURN VARCHAR2;
38   pragma RESTRICT_REFERENCES (check_labor_cost_access, WNDS, WNPS);
39 
40   FUNCTION check_project_authority ( X_person_id  IN NUMBER,
41                                      X_project_id IN NUMBER ) RETURN VARCHAR2;
42   pragma RESTRICT_REFERENCES (check_project_authority, WNDS, WNPS, TRUST);
43      /* added trust pragma option to call functions that do not have pragma defined like pa_security_pvt.get_grantee_key */
44 
45 /* Enhancement 6519194*/
46 /*  FUNCTION check_forecast_authority ( X_person_id  IN NUMBER,
47                                       X_project_id IN NUMBER ) RETURN VARCHAR2;*/
48 
49 /*  pragma RESTRICT_REFERENCES (check_forecast_authority, WNDS, WNPS, TRUST);*/
50      /* added trust pragma option to call functions that do not have pragma defined like pa_security_pvt.get_grantee_key */
51 
52 END pa_security;