1 package JTF_UM_USERTYPE_CREDENTIALS AUTHID CURRENT_USER as
2 /* $Header: JTFUMUCS.pls 115.7 2002/11/21 22:58:04 kching ship $ */
3
4 PROCEDURE ASSIGN_USERTYPE_CREDENTIALS
5 (
6 X_USER_NAME VARCHAR2,
7 X_USER_ID NUMBER,
8 X_USERTYPE_ID NUMBER
9 );
10
11 PROCEDURE ASSIGN_RESPONSIBILITY
12 (
13 X_USER_ID NUMBER,
14 X_RESPONSIBILITY_ID NUMBER,
15 X_APPLICATION_ID NUMBER
16 );
17
18 PROCEDURE ASSIGN_RESPONSIBILITY
19 (
20 X_USER_ID NUMBER,
21 X_RESPONSIBILITY_KEY VARCHAR2,
22 X_APPLICATION_ID NUMBER
23 );
24 PROCEDURE ASSIGN_DEFAULT_RESPONSIBILITY
25 (
26 X_USER_ID NUMBER,
27 X_RESPONSIBILITY_KEY VARCHAR2,
28 X_APPLICATION_ID NUMBER
29 );
30
31 PROCEDURE REVOKE_RESPONSIBILITY
32 (
33 X_USER_ID NUMBER,
34 X_RESPONSIBILITY_KEY VARCHAR2,
35 X_APPLICATION_ID NUMBER
36 );
37
38 PROCEDURE REVOKE_RESPONSIBILITY
39 (
40 X_USER_ID NUMBER,
41 X_RESPONSIBILITY_ID NUMBER,
42 X_APPLICATION_ID NUMBER
43 );
44
45 PROCEDURE ASSIGN_ACCOUNT
46 (
47 P_PARTY_ID NUMBER,
48 P_USERTYPE_KEY VARCHAR2,
49 P_ORG_PARTY_ID NUMBER:=FND_API.G_MISS_NUM
50 );
51
52 PROCEDURE REJECT_DELETED_PEND_USER (P_USERNAME in VARCHAR2,
53 X_PENDING_USER out NOCOPY VARCHAR2);
54
55 PROCEDURE ASSIGN_DEF_RESP(P_USERNAME in VARCHAR2,
56 P_ACCOUNT_TYPE in VARCHAR2);
57
58 PROCEDURE ASSIGN_DEF_ROLES(P_USERNAME in VARCHAR2,
59 P_ACCOUNT_TYPE in VARCHAR2);
60
61
62 /**
63 * Procedure : get_usertype_resp
64 * Type : Private
65 * Pre_reqs : None
66 * Description : Will determine the responsibility attached to the usertype
67 * Parameters :
68 * input parameters
69 * @param p_usertype_id
70 * description: The usertyp_id
71 * required : Y
72 * validation : Must be a valid usertype_id
73 * output parameters
74 * x_resp_id
75 * description: The responsibility_id associated to the responsibility
76 * associated to the usertype
77 * x_app_id
78 * description: The app_id associated to the responsibility
79 * associated to the usertype
80 **/
81 procedure get_usertype_resp(
82 p_usertype_id in number,
83 p_resp_id out NOCOPY number,
84 p_app_id out NOCOPY number
85 );
86
87 /**
88 * Procedure : grant_roles
89 * Type : Private
90 * Pre_reqs : None
91 * Description : Will grant roles to users
92 * Parameters :
93 * input parameters
94 * p_user_name:
95 * description: The user_name of the user
96 * required : Y
97 * validation : Must be a valid user_name
98 * p_role_id
99 * description: The value of the JTF_AUTH_PRINCIPAL_ID
100 * required : Y
101 * validation : Must exist as a JTF_AUTH_PRONCIPAL_ID
102 * in the table JTF_AUTH_PRINCIPALS_B
103 * p_source_name
104 * description: The value of the name of the source
105 * required : Y
106 * validation : Must be "USERTYPE" or "ENROLLMENT"
107 * p_source_id
108 * description: The value of the id associated with the source
109 * required : Y
110 * validation : Must be a usertype_id or a subscription_id
111 * output parameters
112 * None
113 */
114 procedure grant_roles (
115 p_user_name in varchar2,
116 p_role_id in number,
117 p_source_name in varchar2,
118 p_source_id in varchar2
119 );
120
121
122 /**
123 * Procedure : set_default_login_resp
124 * Type : Private
125 * Pre_reqs : None
126 * Description : Will set the default responsibility of a user
127 * Parameters :
128 * input parameters
129 * @param p_user_id
130 * description: The user_id of a user
131 * validation : Must be a valid user_id
132 * @param p_resp_id
133 * description: The responsibility_id associated to the default logon
134 * responsibility of a user
135 * required : Y
136 * validation : Must be a valid responsibility_id
137 * @param p_app_id
138 * description: The app_id associated to the default logon
139 * responsibility of a user
140 * required : Y
141 * validation: Must be a valid application_id
142 * output parameters
143 * None
144 **/
145
146 procedure set_default_login_resp(
147 p_user_id in number,
148 p_resp_id in number,
149 p_app_id in number
150 );
151
152 /**
153 * Procedure : set_default_login_resp
154 * Type : Private
155 * Pre_reqs : None
156 * Description : Will set the default responsibility of a user
157 * Parameters :
158 * input parameters
159 * @param p_user_name
160 * description: The user_name of a user
161 * validation : Must be a valid user_name
162 * @param p_resp_id
163 * description: The responsibility_id associated to the default logon
164 * responsibility of a user
165 * required : Y
166 * validation : Must be a valid responsibility_id
167 * @param p_app_id
168 * description: The app_id associated to the default logon
169 * responsibility of a user
170 * required : Y
171 * validation: Must be a valid application_id
172 * output parameters
173 * None
174 **/
175
176 procedure set_default_login_resp(
177 p_user_name in varchar2,
178 p_resp_id in number,
179 p_app_id in number
180 );
181
182
183 /**
184 * Procedure : get_default_login_resp
185 * Type : Private
186 * Pre_reqs : None
187 * Description : Will set the default responsibility of a user
188 * Parameters :
189 * input parameters
190 * @param p_user_id
191 * description: The user_name of a user
192 * validation : Must be a valid user_id
193 * output parameters
194 * @param x_resp_id
195 * description: The responsibility_id associated to the default logon
196 * responsibility of a user
197 * @param x_app_id
198 * description: The app_id associated to the default logon
199 * responsibility of a user
200 * @param x_resp_key
201 * description: The responsibility_key associated to the default logon
202 * responsibility of a user
203 * @param x_resp_name
204 * description: The responsibility_name associated to the default logon
205 * responsibility of a user
206 *
207 * None
208 **/
209
210 procedure get_default_login_resp(
211 p_user_id in number,
212 x_resp_id out NOCOPY number,
213 x_app_id out NOCOPY number,
214 x_resp_key out NOCOPY varchar2,
215 x_resp_name out NOCOPY varchar2
216 );
217
218 /**
219 * Procedure : get_default_login_resp
220 * Type : Private
221 * Pre_reqs : None
222 * Description : Will set the default responsibility of a user
223 * Parameters :
224 * input parameters
225 * @param p_user_name
226 * description: The user_name of a user
227 * validation : Must be a valid user_name
228 * output parameters
229 * @param x_resp_id
230 * description: The responsibility_id associated to the default logon
231 * responsibility of a user
232 * @param x_app_id
233 * description: The app_id associated to the default logon
234 * responsibility of a user
235 * @param x_resp_key
236 * description: The responsibility_key associated to the default logon
237 * responsibility of a user
238 * @param x_resp_name
239 * description: The responsibility_name associated to the default logon
240 * responsibility of a user
241 *
242 * None
243 **/
244
245 procedure get_default_login_resp(
246 p_user_name in varchar2,
247 x_resp_id out NOCOPY number,
248 x_app_id out NOCOPY number,
249 x_resp_key out NOCOPY varchar2,
250 x_resp_name out NOCOPY varchar2
251 );
252
253 /**
254 * Procedure : UPGRADE_PRIMARY_USER
255 * Type : Private
256 * Pre_reqs : None
257 * Description : Concurrent program to upgrade primary users
258 * Parameters :
259 * OUT parameters
260 * As required by concurrent program standards
261 **/
262 PROCEDURE UPGRADE_PRIMARY_USER(ERRBUF out NOCOPY VARCHAR2,
263 RETCODE out NOCOPY VARCHAR2
264 );
265
266 END JTF_UM_USERTYPE_CREDENTIALS;