PACKAGE: APPS.PA_SECURITY

Source

1 PACKAGE pa_security AUTHID CURRENT_USER AS
2 /* $Header: PAPLSECS.pls 120.1.12010000.3 2009/06/08 11:59:42 paljain 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   G_proj_id		   NUMBER := NULL;     --7716514
13   G_allow_result	   NUMBER := NULL;     --7716514
14 
15   FUNCTION view_labor_costs_new ( X_project_id      IN NUMBER) RETURN NUMBER;   --7716514
16   FUNCTION view_labor_costs_new2 ( X_project_id      IN NUMBER) RETURN VARCHAR2; -- 8460451
17   PROCEDURE Initialize ( X_user_id	IN NUMBER
18                        , X_calling_module  IN VARCHAR2 );
19 
20   FUNCTION allow_query ( X_project_id     IN NUMBER) RETURN VARCHAR2;
21   pragma RESTRICT_REFERENCES (allow_query, WNDS, WNPS);
22 
23   FUNCTION allow_update ( X_project_id     IN NUMBER) RETURN VARCHAR2;
24   pragma RESTRICT_REFERENCES (allow_update, WNDS, WNPS);
25 
26   FUNCTION view_labor_costs ( X_project_id     IN NUMBER) RETURN VARCHAR2;
27   pragma RESTRICT_REFERENCES (view_labor_costs, WNDS, WNPS);
28 
29   PROCEDURE set_value ( X_security_level  IN VARCHAR2
30 		      , X_value	          IN VARCHAR2 );
31 
32   FUNCTION check_key_member ( X_person_id    IN NUMBER
33                             , X_project_id   IN NUMBER ) RETURN VARCHAR2;
34   pragma RESTRICT_REFERENCES (check_key_member, WNDS, WNPS);
35 
36   FUNCTION check_key_member_no_dates (X_person_id    IN NUMBER
37                                     , X_project_id   IN NUMBER ) RETURN VARCHAR2;
38   pragma RESTRICT_REFERENCES (check_key_member_no_dates, WNDS, WNPS);
39 
40   FUNCTION check_labor_cost_access ( X_person_id   IN NUMBER
41                                    , X_project_id  IN NUMBER ) RETURN VARCHAR2;
42   pragma RESTRICT_REFERENCES (check_labor_cost_access, WNDS, WNPS);
43 
44   FUNCTION check_project_authority ( X_person_id  IN NUMBER,
45                                      X_project_id IN NUMBER ) RETURN VARCHAR2;
46   pragma RESTRICT_REFERENCES (check_project_authority, WNDS, WNPS, TRUST);
47      /* added trust pragma option to call functions that do not have pragma defined like pa_security_pvt.get_grantee_key */
48 
49 /* Enhancement 6519194*/
50 /*  FUNCTION check_forecast_authority ( X_person_id  IN NUMBER,
51                                       X_project_id IN NUMBER ) RETURN VARCHAR2;*/
52 
53 /*  pragma RESTRICT_REFERENCES (check_forecast_authority, WNDS, WNPS, TRUST);*/
54      /* added trust pragma option to call functions that do not have pragma defined like pa_security_pvt.get_grantee_key */
55 
56 END pa_security;