1 package JTF_AUTH_BULKLOAD_PKG AUTHID CURRENT_USER as
2 /* $Header: JTFSEABS.pls 120.1 2005/07/02 02:10:07 appldev ship $ */
3 /* ASSIGN_ROLE: assigns an existing role to an existing user in the 'CRM_DOMAIN'
4 * USER_NAME userid (case insensitive, lower case is converted to
5 * upper case)
6 * ROLE_NAME role name (case insensitive, lower case is converted
7 * to upper case)
8 */
9 procedure ASSIGN_ROLE (
10 USER_NAME in VARCHAR2,
11 ROLE_NAME in VARCHAR2
12 );
13
14 /* ASSIGN_ROLE: assigns an existing role to an existing user in the 'CRM_DOMAIN' with source table name and source table key
15 * USER_NAME userid (case insensitive, lower case is converted to
16 * upper case)
17 * ROLE_NAME role name (case insensitive, lower case is converted
18 * to upper case)
19 * OWNERTABLE_NAME owner table name, must be in FND_LOOKUPS (case insensit * ive, lower case is converted to upper case)
20 * OWNERTABLE_KEY owner table key
21 */
22 procedure ASSIGN_ROLE (
23 USER_NAME in VARCHAR2,
24 ROLE_NAME in VARCHAR2,
25 OWNERTABLE_NAME in VARCHAR2,
26 OWNERTABLE_KEY in VARCHAR2
27 );
28
29 /* ASSIGN_ROLE: assigns an existing role to an existing user in the 'CRM_DOMAIN'
30 * USER_NAME userid (case insensitive, lower case is converted to
31 * upper case)
32 * ROLE_NAME role name (case insensitive, lower case is converted
33 * to upper case)
34 * APP_ID application id
35 */
36 procedure ASSIGN_ROLE (
37 USER_NAME in VARCHAR2,
38 ROLE_NAME in VARCHAR2,
39 APP_ID in NUMBER
40 );
41
42 /* ASSIGN_ROLE: assigns an existing role to an existing user in the 'CRM_DOMAIN' with source table name and source table key
43 * USER_NAME userid (case insensitive, lower case is converted to
44 * upper case)
45 * ROLE_NAME role name (case insensitive, lower case is converted
46 * to upper case)
47 * OWNERTABLE_NAME owner table name, must be in FND_LOOKUPS (case insensit * ive, lower case is converted to upper case)
48 * OWNERTABLE_KEY owner table key
49 * APP_ID application id
50 */
51 procedure ASSIGN_ROLE (
52 USER_NAME in VARCHAR2,
53 ROLE_NAME in VARCHAR2,
54 OWNERTABLE_NAME in VARCHAR2,
55 OWNERTABLE_KEY in VARCHAR2,
56 APP_ID in NUMBER
57 );
58
59 end JTF_AUTH_BULKLOAD_PKG;