1 PACKAGE ICX_User_Sec_Attr_PVT AUTHID CURRENT_USER AS
2 -- $Header: ICXVTUSS.pls 120.3 2005/10/26 14:06:46 tshort noship $
3
4 -- Global constants holding the package and file names to be used by
5 -- messaging routines in the case of an unexpected error.
6
7 G_PKG_NAME CONSTANT VARCHAR2(30) := 'ICX_User_Sec_Attr_PVT';
8 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ICXVTUSB.pls';
9
10 -- Start of Comments
11 -- API name : Create_User_Sec_Attr
12 -- Type : Private.
13 -- Function : Create Securing Attribute Value information in
14 -- AK_WEB_USER_SEC_ATTR_VALUES
15 -- Pre-reqs : None.
16 -- Paramaeters :
17 -- IN :
18 -- p_api_version_number IN NUMBER Required
19 -- p_init_msg_list IN VARCHAR2 Optional
20 -- Default = FND_API.G_FALSE
21 -- p_simulate IN VARCHAR2 Optional
22 -- Default = FND_API.G_FALSE
23 -- p_commit IN VARCHAR2 Optional
24 -- Default = FND_API.G_FALSE
25 -- p_validation_level IN NUMBER Optional
26 -- Default = FND_API.G_VALID_LEVEL_FULL
27 -- p_web_user_id IN NUMBER Required
28 -- p_attribute_code IN VARCHAR2(30) Required
29 -- p_attribute_appl_id IN NUMBER Required
30 -- p_varchar2_value IN VARCHAR2(240) Required
31 -- p_date_value IN DATE Required
32 -- p_number_value IN NUMBER Required
33 -- p_created_by IN NUMBER Required
34 -- p_creation_date IN DATE Required
35 -- p_last_updated_by IN NUMBER Required
36 -- p_last_update_date IN DATE Required
37 -- p_last_update_login IN NUMBER Required
38 --
39 -- OUT :
40 -- p_return_status OUT VARCHAR2(1)
41 -- p_msg_count OUT NUMBER
42 -- p_msg_data OUT VARCHAR2(2000)
43 -- .
44 -- Version : Current version 1.0
45 -- Initial version 1.0
46 --
47 -- Notes : Note text
48 --
49 --
50 --
51 --
52 -- API name : Delete_Resp_Sec_Attr
53 -- Type : Private.
54 -- Function : Delete Securing Attribute Value information in
55 -- AK_WEB_USER_SEC_ATTR_VALUES
56 -- Pre-reqs : None.
57 -- Paramaeters :
58 -- IN :
59 -- p_api_version_number IN NUMBER Required
60 -- p_init_msg_list IN VARCHAR2 Optional
61 -- Default = FND_API.G_FALSE
62 -- p_simulate IN VARCHAR2 Optional
63 -- Default = FND_API.G_FALSE
64 -- p_commit IN VARCHAR2 Optional
65 -- Default = FND_API.G_FALSE
66 -- p_validation_level IN NUMBER Optional
67 -- Default = FND_API.G_VALID_LEVEL_FULL
68 -- p_web_user_id IN NUMBER Required
69 -- p_attribute_code IN VARCHAR2(30) Required
70 -- p_attribute_appl_id IN NUMBER Required
71 -- p_varchar2_value IN VARCHAR2(240) Required
72 -- p_date_value IN DATE Required
73 -- p_number_value IN NUMBER Required
74 --
75 -- OUT :
76 -- p_return_status OUT VARCHAR2
77 -- p_msg_count OUT NUMBER
78 -- p_msg_data OUT VARCHAR2
79 -- .
80 -- Version : Current version 1.0
81 -- Initial version 1.0
82 --
83 -- Notes : Note text
84 --
85 --
86 --
87 --
88 -- API name : Create_Def_User_Sec_Attr
89 -- Type : Private.
90 -- Function : Create default Securing Attribute Value information
91 -- in AK_WEB_USER_SEC_ATTR_VALUES.
92 -- Pre-reqs : None.
93 -- Paramaeters :
94 -- IN :
95 -- p_api_version_number IN NUMBER Required
96 -- p_init_msg_list IN VARCHAR2 Optional
97 -- Default = FND_API.G_FALSE
98 -- p_simulate IN VARCHAR2 Optional
99 -- Default = FND_API.G_FALSE
100 -- p_commit IN VARCHAR2 Optional
101 -- Default = FND_API.G_FALSE
102 -- p_validation_level IN NUMBER Optional
103 -- Default = FND_API.G_VALID_LEVEL_FULL
104 -- p_web_user_id IN NUMBER Required
105 -- p_responsibility_id IN NUMBER Required
106 -- p_created_by IN NUMBER Required
107 -- p_creation_date IN DATE Required
108 -- p_last_updated_by IN NUMBER Required
109 -- p_last_update_date IN DATE Required
110 -- p_last_update_login IN NUMBER Required
111 --
112 -- OUT :
113 -- p_return_status OUT VARCHAR2(1)
114 -- p_msg_count OUT NUMBER
115 -- p_msg_data OUT VARCHAR2(2000)
116 -- .
117 -- Version : Current version 1.0
118 -- Initial version 1.0
119 --
120 -- Notes : Note text
121 --
122 -- End Of Comments
123
124 PROCEDURE Create_User_Sec_Attr
125 ( p_api_version_number IN NUMBER,
126 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
127 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
128 p_commit IN VARCHAR2 := FND_API.G_FALSE,
129 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130 p_return_status OUT NOCOPY VARCHAR2,
131 p_msg_count OUT NOCOPY NUMBER,
132 p_msg_data OUT NOCOPY VARCHAR2,
133 -- p_msg_entity OUT VARCHAR2,
134 -- p_msg_entity_index OUT NUMBER,
135 p_web_user_id IN NUMBER,
136 p_attribute_code IN VARCHAR2,
137 p_attribute_appl_id IN NUMBER,
138 p_varchar2_value IN VARCHAR2,
139 p_date_value IN DATE,
140 p_number_value IN NUMBER,
141 p_created_by IN NUMBER,
142 p_creation_date IN DATE,
143 p_last_updated_by IN NUMBER,
144 p_last_update_date IN DATE,
145 p_last_update_login IN NUMBER
146 );
147
148
149
150 PROCEDURE Delete_User_Sec_Attr
151 ( p_api_version_number IN NUMBER,
152 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
154 p_commit IN VARCHAR2 := FND_API.G_FALSE,
155 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
156 p_return_status OUT NOCOPY VARCHAR2,
157 p_msg_count OUT NOCOPY NUMBER,
158 p_msg_data OUT NOCOPY VARCHAR2,
159 -- p_msg_entity OUT VARCHAR2,
160 -- p_msg_entity_index OUT NUMBER,
161 p_web_user_id IN NUMBER,
162 p_attribute_code IN VARCHAR2,
163 p_attribute_appl_id IN NUMBER,
164 p_varchar2_value IN VARCHAR2,
165 p_date_value IN DATE,
166 p_number_value IN NUMBER
167 );
168
169 PROCEDURE Create_Def_User_Sec_Attr
170 ( p_api_version_number IN NUMBER,
171 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
172 p_simulate IN VARCHAR2 := FND_API.G_FALSE,
173 p_commit IN VARCHAR2 := FND_API.G_FALSE,
174 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175 p_web_user_id IN NUMBER,
176 p_resp_application_id IN NUMBER,
177 p_responsibility_id IN NUMBER,
178 p_created_by IN NUMBER,
179 p_creation_date IN DATE,
180 p_last_updated_by IN NUMBER,
181 p_last_update_date IN DATE,
182 p_last_update_login IN NUMBER,
183 p_return_status OUT NOCOPY VARCHAR2,
184 p_msg_count OUT NOCOPY NUMBER,
185 p_msg_data OUT NOCOPY VARCHAR2
186 );
187
188
189 END ICX_User_Sec_Attr_PVT;