[Home] [Help]
PACKAGE: APPS.PA_CI_SECURITY_PKG
Source
1 PACKAGE pa_ci_security_pkg AUTHID CURRENT_USER AS
2 /* $Header: PACISECS.pls 120.1.12020000.2 2012/07/19 09:31:20 admarath ship $ */
3
4 FUNCTION check_proj_auth_ci(
5 p_project_id NUMBER,
6 p_user_id NUMBER,
7 p_resp_id NUMBER)
8 RETURN VARCHAR2;
9
10 FUNCTION check_view_access(
11 p_ci_id NUMBER,
12 p_user_id NUMBER DEFAULT fnd_global.user_id,
13 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
14 RETURN VARCHAR2;
15
16 FUNCTION check_view_access(
17 p_ci_id NUMBER,
18 p_project_id NUMBER,
19 p_sys_stat_code VARCHAR2,
20 p_ci_type_class_code VARCHAR2,
21 p_user_id NUMBER DEFAULT fnd_global.user_id,
22 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
23 RETURN VARCHAR2;
24
25 FUNCTION check_update_access(
26 p_ci_id NUMBER,
27 p_user_id NUMBER DEFAULT fnd_global.user_id,
28 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
29 RETURN VARCHAR2;
30
31 FUNCTION check_update_access1(
32 p_ci_id NUMBER,
33 p_project_id NUMBER,
34 p_proj_org_id NUMBER,
35 p_user_id NUMBER DEFAULT fnd_global.user_id,
36 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
37 RETURN VARCHAR2;
38
39 FUNCTION check_change_owner_access(
40 p_ci_id NUMBER,
41 p_user_id NUMBER DEFAULT fnd_global.user_id,
42 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
43 RETURN VARCHAR2;
44
45 FUNCTION check_change_status_access(
46 p_ci_id NUMBER,
47 p_user_id NUMBER DEFAULT fnd_global.user_id,
48 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
49 RETURN VARCHAR2;
50
51 FUNCTION check_highlight_access(
52 p_ci_id NUMBER,
53 p_user_id NUMBER DEFAULT fnd_global.user_id,
54 p_resp_id NUMBER DEFAULT fnd_global.resp_id,
55 p_project_id NUMBER DEFAULT NULL)
56 RETURN VARCHAR2;
57
58 FUNCTION check_implement_impact_access(
59 p_ci_id NUMBER,
60 p_user_id NUMBER DEFAULT fnd_global.user_id,
61 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
62 RETURN VARCHAR2;
63
64 FUNCTION check_item_owner_project_auth(
65 p_ci_id in NUMBER,
66 p_user_id IN NUMBER DEFAULT fnd_global.user_id)
67 RETURN VARCHAR2;
68
69 FUNCTION check_open_action_assigned_to(
70 p_ci_action_id IN NUMBER,
71 p_user_id IN NUMBER DEFAULT fnd_global.user_id)
72 RETURN VARCHAR2;
73
74 FUNCTION check_create_action(
75 p_ci_id IN NUMBER,
76 p_user_id IN NUMBER DEFAULT fnd_global.user_id,
77 p_calling_context IN VARCHAR2 DEFAULT 'UI') --bug 5676037.
78 RETURN VARCHAR2;
79
80 FUNCTION check_updatable_comment(
81 p_ci_comment_id IN NUMBER,
82 p_user_id IN NUMBER DEFAULT fnd_global.user_id)
83 RETURN varchar2;
84
85 FUNCTION check_create_CI(
86 p_ci_type_id NUMBER,
87 p_project_id NUMBER,
88 p_user_id NUMBER DEFAULT fnd_global.user_id,
89 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
90 RETURN VARCHAR2;
91
92 FUNCTION check_view_project(
93 p_project_id NUMBER,
94 p_ci_id NUMBER,
95 p_user_id NUMBER DEFAULT fnd_global.user_id,
96 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
97 RETURN VARCHAR2;
98
99 FUNCTION check_view_project(
100 p_project_id NUMBER,
101 p_ci_id NUMBER,
102 p_ci_type_class_code VARCHAR2,
103 p_user_id NUMBER DEFAULT fnd_global.user_id,
104 p_resp_id NUMBER DEFAULT fnd_global.resp_id)
105 RETURN VARCHAR2;
106
107 FUNCTION is_to_owner_allowed(
108 p_ci_id NUMBER,
109 p_owner_id NUMBER)
110 RETURN VARCHAR2;
111
112 -- This procedure loops through all the responsibilities that the user is
113 -- assigned with and check if he has access to a page. If he does, return
114 -- resp_key and appl_short_name
115 -- Bug#13683760
116 Procedure get_resp_with_access
117 (
118 p_privilege IN VARCHAR2,
119 p_project_id IN NUMBER,
120 x_has_access out NOCOPY varchar2,
121 x_resp_key out NOCOPY VARCHAR2,
122 x_appl_short_name out NOCOPY VARCHAR2,
123 x_return_status out NOCOPY varchar2,
124 x_msg_count out NOCOPY number,
125 x_msg_data out NOCOPY varchar2);
126
127 END pa_ci_security_pkg;