[Home] [Help]
PACKAGE: APPS.FND_OID_PLUG
Source
1 PACKAGE FND_OID_PLUG AUTHID CURRENT_USER AS
2 /* $Header: AFSCOPGS.pls 120.0.12010000.6 2009/06/16 16:29:35 rsantis ship $ */
3
4
5
6 /*
7 Pluggin administration functions
8 */
9
10 /*
11 *** PLUGIN TYPES
12 * G_STATIC: realm and user create base are fixed
13 * G_DYNAMIC : realm and user create base depends on the user
14 */
15 --G_STATIC integer := 0;
16 --G_DYNAMIC integer :=1 ;
17 /*
18 ** CONFIG PREFERENCES
19 *
20 */
21 G_CREATE_USER constant pls_integer:=0;
22 G_UPDATE_USER constant pls_integer:=1;
23
24 L_REALM varchar2(30):='REALM';
25
26 L_REPOSITORY varchar2(30):='CREATE_BASE';
27 L_TYPE varchar2(30):='TYPE';
28
29 /*
30 ** Config used to cache values
31 */
32 L_CN_ATT varchar2(30):='CN_ATT_CACHED';
33 L_NICK_ATT varchar2(30):='NICK_ATT_CACHED';
34 L_SEARCH varchar2(30):='SEARCH_BASE_CACHED';
35 L_RDN varchar2(30):='RDN_CACHED';
36
37 CONFIGURATION_ERROR exception;
38
39
40 --type ldap_record is table of dbms_ldap.STRING_COLLECTION index by varchar2(1000);
41
42 user_data FND_LDAP_UTIL.ldap_record_values;
43
44 procedure SetPlugin(
45 p_defaultRealm in varchar2 default null,
46 p_default_user_repository in varchar2 default null,
47 plugin_name in varchar2 default null
48 );
49
50 procedure setPlugin_old(
51 default_realm in varchar2 default null,
52 default_user_repository in varchar2 default null,
53 plugin_name in varchar2 default null);
54
55
56 /**
57 ** FND: ATG Internal: We are plannign to change them in the near future
58 **/
59 /*
60 ** FND: ATG Internal
61 ** Use By: FND_LDAP_USER
62 */
63 function get_realm_dn( p_user_guid in raw default null, p_user_name in varchar2 default null) return varchar2;
64
65 function count_attributes( ldap in out nocopy dbms_ldap.session, dn in varchar2, attName in varchar2)
66 return integer;
67
68 /*
69 ** FND: ATG Internal
70 ** Use By: FND_LDAP_USER
71 */
72 function get_realm_from_user_dn(ldap in out nocopy dbms_ldap.session, user_dn in varchar2 ) return varchar2;
73 /*
74 ** FND: ATG Internal
75 ** Use By: FND_SSO_REGISTRATION
76 */
77 function get_default_realm return varchar2;
78 /*
79 ** FND: ATG Internal
80 ** Use By: FND_SSO_REGISTRATION
81 */
82 function getRealmDN(username in varchar2) return varchar2;
83
84
85
86 /*
87 ** FND: ATG Internal
88 ** DO NOT USE
89 ** Heavy consumer !! Will search first in LDAP to see if the user exists!!
90 ** Use By: FND_LDAP_MAPPER => Need to fix
91 */
92 function getNickNameattr(username in varchar2) return varchar2;
93
94 /*
95 ** FND: ATG Internal
96 ** Use By: FND_LDAP_USER
97 */
98 Procedure completeForCreate(ldap in dbms_ldap.session ,p_ldap_user IN OUT nocopy fnd_ldap_user.ldap_user_type );
99
100 /*
101 ** FND: ATG INTERNAL
102 **
103 */
104 PROCEDURE FixupLDAPUser( p_ldap_user IN OUT nocopy FND_LDAP_USER.ldap_user_type, operation pls_integer);
105
106 FUNCTION Helper_NewEmptyCollection return DBMS_LDAP.STRING_COLLECTION;
107 /*
108 ** FND: ATG Internal
109 ** Use By: FND_SSO_REGISTRATION
110 ** Currently return a list with the default realm
111 */
112
113 function getRealmList return dbms_ldap.string_collection;
114
115
116 -- TEMPLATE
117 -- COPY + PASTE + IMPLEMENT
118 -- remove the '_template' from the name
119 -- DO NOT CHANGE parameter names or its datatypes
120 --procedure getRDN( username in varchar2, userid in pls_integer,
121 -- RDN_attName in out nocopy varchar2, RND_value in out nocopy varchar2, replaceFlag out pls_integer);
122
123 procedure getDefaultRealm_Template(realm out nocopy varchar2);
124 procedure getDefaultCreateBase_Template(realm in varchar2, parentDN out nocopy varchar2 ) ;
125 procedure getCreateBase_Template( user_id in INTEGER, user_name in varchar2,realm in varchar2, parentDn out nocopy varchar2) ;
126 procedure getRealm_Template( user_id in INTEGER, user_name in varchar2, realmDn out nocopy varchar2) ;
127 procedure getRDN_Template( user_name in varchar2, user_id in pls_integer, RDN_attName in out nocopy varchar2,
128 RND_value in out nocopy varchar2, replaceFlag in out nocopy pls_integer);
129 procedure fixupLDAPUser_Template( user_id in INTEGER, user_name in varchar2, operation in pls_integer) ;
130
131 -- Replace = 0 -> no, append it to the record
132 -- Replace = 1 -> yes, replace if the value is present
133 --- or use these values
134
135 G_NO_REPLACE_FLAG pls_integer := 0;
136 G_ADD_FLAG pls_integer := 0;
137 G_REPLACE_FLAG pls_integer := 1;
138
139
140
141
142 END FND_OID_PLUG;