eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_OID_PLUG dependencies on DBMS_LDAP

Line 292: datatypes dbms_ldap.string_collection;

288: exp_precision DBMS_DESCRIBE.NUMBER_TABLE;
289: exp_scale DBMS_DESCRIBE.NUMBER_TABLE;
290: exp_radix DBMS_DESCRIBE.NUMBER_TABLE;
291: exp_spare DBMS_DESCRIBE.NUMBER_TABLE;
292: datatypes dbms_ldap.string_collection;
293: idx INTEGER := 0;
294:
295: BEGIN
296: DBMS_DESCRIBE.DESCRIBE_PROCEDURE(name, null, null,prop_overload,prop_position,prop_c_level,prop_arg_name,

Line 334: --ldap dbms_ldap.session;

330:
331:
332: function getRealmNickNameattr(realm in varchar2) return varchar2
333: is
334: --ldap dbms_ldap.session;
335: ret varchar2(80):= null;
336: realm_idx pls_integer;
337: --flag pls_integer;
338: l_module_source varchar2(1000) ;

Line 576: ldap dbms_ldap.session;

572: val varchar2(4000);
573: realm varchar2(4000);
574: usePlugin boolean := false;
575: idx pls_integer;
576: ldap dbms_ldap.session;
577: flag pls_integer ;
578: guid varchar2(4000);
579: testing_mode pls_integer := 1;
580: l_session_flag boolean := false;

Line 843: ldap dbms_ldap.session;

839: procedure setPlugin_old(
840: default_realm in varchar2 default null,
841: default_user_repository in varchar2 default null,
842: plugin_name in varchar2 default null) AS
843: ldap dbms_ldap.session;
844: res pls_integer;
845: flag pls_integer;
846: l_module_source varchar2(1000) ;
847: isDynamic boolean:= false;

Line 982: ldap dbms_ldap.session;

978: PROCEDURE upgrade_preferences is
979:
980: l_realm varchar2(4000);
981: l_repo varchar2(4000);
982: ldap dbms_ldap.session;
983: flag pls_integer;
984: l_module_source varchar2(1000);
985: l_session_flag boolean := false;
986: BEGIN

Line 1227: baseList dbms_ldap.string_collection;

1223: function getUserRepository(p_ldap_user IN OUT nocopy fnd_ldap_user.ldap_user_type ) return varchar2 AS
1224: result varchar2(4000);
1225: l_module_source varchar2(1000) ;
1226: opt option_type_rec;
1227: baseList dbms_ldap.string_collection;
1228: BEGIN
1229: l_module_source := G_MODULE_SOURCE || 'getUserRepository: ';
1230: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1231: then

Line 1367: ldap dbms_ldap.session;

1363:
1364: /*
1365: function getSearchBase(username in varchar2) return varchar2 AS
1366: res varchar2(1000);
1367: ldap dbms_ldap.session;
1368: dummy pls_integer;
1369: result varchar2(4000);
1370: l_module_source varchar2(1000) ;
1371: BEGIN

Line 1443: ldap dbms_ldap.session;

1439:
1440: function getNickNameAttributeFromRealm(realmDn in varchar2) return varchar2
1441: is
1442:
1443: ldap dbms_ldap.session;
1444: dummy pls_integer;
1445: result varchar2(4000);
1446: l_module_source varchar2(1000) ;
1447: l_session_flag boolean := false;

Line 1553: function get_entry_dn(ldap in out nocopy dbms_ldap.session, p_guid IN raw ) return varchar2

1549: raise;
1550:
1551: end getUsernameFromEntry;
1552:
1553: function get_entry_dn(ldap in out nocopy dbms_ldap.session, p_guid IN raw ) return varchar2
1554: is
1555: result pls_integer;
1556: entry_dn varchar(4000);
1557: l_message dbms_ldap.message ;

Line 1557: l_message dbms_ldap.message ;

1553: function get_entry_dn(ldap in out nocopy dbms_ldap.session, p_guid IN raw ) return varchar2
1554: is
1555: result pls_integer;
1556: entry_dn varchar(4000);
1557: l_message dbms_ldap.message ;
1558: l_attrs dbms_ldap.string_collection;
1559: l_entry dbms_ldap.message;
1560:
1561: l_module_source varchar2(1000) ;

Line 1558: l_attrs dbms_ldap.string_collection;

1554: is
1555: result pls_integer;
1556: entry_dn varchar(4000);
1557: l_message dbms_ldap.message ;
1558: l_attrs dbms_ldap.string_collection;
1559: l_entry dbms_ldap.message;
1560:
1561: l_module_source varchar2(1000) ;
1562: BEGIN

Line 1559: l_entry dbms_ldap.message;

1555: result pls_integer;
1556: entry_dn varchar(4000);
1557: l_message dbms_ldap.message ;
1558: l_attrs dbms_ldap.string_collection;
1559: l_entry dbms_ldap.message;
1560:
1561: l_module_source varchar2(1000) ;
1562: BEGIN
1563: l_module_source := G_MODULE_SOURCE || 'get_entry_dn: ';

Line 1571: result := dbms_ldap.search_s(ld => ldap

1567: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin');
1568: end if;
1569:
1570: l_attrs(0) := 'dn'; -- NO_ATTRS
1571: result := dbms_ldap.search_s(ld => ldap
1572: , base => ''
1573: , scope => dbms_ldap.SCOPE_SUBTREE
1574: , filter => 'orclguid='||p_guid
1575: , attrs => l_attrs

Line 1573: , scope => dbms_ldap.SCOPE_SUBTREE

1569:
1570: l_attrs(0) := 'dn'; -- NO_ATTRS
1571: result := dbms_ldap.search_s(ld => ldap
1572: , base => ''
1573: , scope => dbms_ldap.SCOPE_SUBTREE
1574: , filter => 'orclguid='||p_guid
1575: , attrs => l_attrs
1576: , attronly => 0
1577: , res => l_message);

Line 1578: l_entry := dbms_ldap.first_entry(ldap, l_message);

1574: , filter => 'orclguid='||p_guid
1575: , attrs => l_attrs
1576: , attronly => 0
1577: , res => l_message);
1578: l_entry := dbms_ldap.first_entry(ldap, l_message);
1579: entry_dn := dbms_ldap.get_dn(ldap,l_entry);
1580: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1581: then
1582: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||entry_dn);

Line 1579: entry_dn := dbms_ldap.get_dn(ldap,l_entry);

1575: , attrs => l_attrs
1576: , attronly => 0
1577: , res => l_message);
1578: l_entry := dbms_ldap.first_entry(ldap, l_message);
1579: entry_dn := dbms_ldap.get_dn(ldap,l_entry);
1580: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1581: then
1582: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'END ->'||entry_dn);
1583: end if;

Line 1595: function get_realm_from_user_dn(ldap in out nocopy dbms_ldap.session, user_dn in varchar2 )

1591: raise;
1592:
1593: end get_entry_dn;
1594:
1595: function get_realm_from_user_dn(ldap in out nocopy dbms_ldap.session, user_dn in varchar2 )
1596: return varchar2
1597:
1598: is
1599: cn_list dbms_ldap.STRING_COLLECTION;

Line 1599: cn_list dbms_ldap.STRING_COLLECTION;

1595: function get_realm_from_user_dn(ldap in out nocopy dbms_ldap.session, user_dn in varchar2 )
1596: return varchar2
1597:
1598: is
1599: cn_list dbms_ldap.STRING_COLLECTION;
1600: len pls_integer;
1601: i pls_integer;
1602: j pls_integer;
1603: dn varchar2(4000);

Line 1620: cn_list := dbms_ldap.explode_dn(user_dn,0);

1616: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'Begin '||dev_version);
1617: end if;
1618:
1619: if (dev_version>=1.0 and dev_version<2.0) THEN
1620: cn_list := dbms_ldap.explode_dn(user_dn,0);
1621: len := cn_list.count;
1622: i:= 0;
1623: while (i 1624:

Line 1638: WHEN DBMS_LDAP.general_error THEN

1634: if (dev_version>=1.1) THEN -- we check something more
1635: g := FND_LDAP_UTIL.getLDAPAttribute(ldap,'cn=Common,cn=Products,cn=OracleContext,'||dn,'orclcommonnicknameattribute','objectclass=*');
1636: END IF;
1637: EXCEPTION
1638: WHEN DBMS_LDAP.general_error THEN
1639: g:= null;
1640: WHEN OTHERS THEN
1641: g:=null;
1642: END;

Line 1683: ldap dbms_ldap.session;

1679:
1680:
1681: function get_username_from_guid(p_user_guid IN fnd_user.user_guid%type ) return varchar2
1682: is
1683: ldap dbms_ldap.session;
1684: dummy pls_integer;
1685: user_dn varchar2(4000);
1686: realm_dn varchar2(4000);
1687: user_name varchar2(1000);

Line 1820: ldap dbms_ldap.session;

1816:
1817: function get_default_realm return varchar2
1818: is
1819: res varchar2(1000);
1820: ldap dbms_ldap.session;
1821: dummy pls_integer;
1822: result varchar2(4000);
1823: l_module_source varchar2(1000) ;
1824: BEGIN

Line 1855: ldap dbms_ldap.session;

1851: ( p_user_guid IN raw DEFAULT NULL,
1852: p_user_name IN VARCHAR2 DEFAULT NULL)
1853: RETURN VARCHAR2
1854: IS
1855: ldap dbms_ldap.session;
1856: flag pls_integer;
1857: result VARCHAR2(4000);
1858: l_module_source VARCHAR2(1000) ;
1859: l_dn VARCHAR2(4000);

Line 1946: function count_attributes(ldap in out nocopy dbms_ldap.session, dn in varchar2, attName in varchar2)

1942: END IF;
1943: raise;
1944: END get_realm_dn;
1945:
1946: function count_attributes(ldap in out nocopy dbms_ldap.session, dn in varchar2, attName in varchar2)
1947: return integer
1948: is
1949: l_result pls_integer;
1950: l_attrs dbms_ldap.string_collection;

Line 1950: l_attrs dbms_ldap.string_collection;

1946: function count_attributes(ldap in out nocopy dbms_ldap.session, dn in varchar2, attName in varchar2)
1947: return integer
1948: is
1949: l_result pls_integer;
1950: l_attrs dbms_ldap.string_collection;
1951: l_message dbms_ldap.message := NULL;
1952: l_entry dbms_ldap.message := NULL;
1953: l_module_source varchar2(4000);
1954: begin

Line 1951: l_message dbms_ldap.message := NULL;

1947: return integer
1948: is
1949: l_result pls_integer;
1950: l_attrs dbms_ldap.string_collection;
1951: l_message dbms_ldap.message := NULL;
1952: l_entry dbms_ldap.message := NULL;
1953: l_module_source varchar2(4000);
1954: begin
1955: l_module_source := G_MODULE_SOURCE || 'count_attributes: ';

Line 1952: l_entry dbms_ldap.message := NULL;

1948: is
1949: l_result pls_integer;
1950: l_attrs dbms_ldap.string_collection;
1951: l_message dbms_ldap.message := NULL;
1952: l_entry dbms_ldap.message := NULL;
1953: l_module_source varchar2(4000);
1954: begin
1955: l_module_source := G_MODULE_SOURCE || 'count_attributes: ';
1956:

Line 1967: l_result := dbms_ldap.search_s(ld => ldap

1963: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'attribute:'||attName);
1964: end if;
1965: end if;
1966: l_attrs(0):= attName;
1967: l_result := dbms_ldap.search_s(ld => ldap
1968: , base => dn
1969: , scope => dbms_ldap.SCOPE_BASE
1970: , filter => 'objectclass=*'
1971: , attrs => l_attrs

Line 1969: , scope => dbms_ldap.SCOPE_BASE

1965: end if;
1966: l_attrs(0):= attName;
1967: l_result := dbms_ldap.search_s(ld => ldap
1968: , base => dn
1969: , scope => dbms_ldap.SCOPE_BASE
1970: , filter => 'objectclass=*'
1971: , attrs => l_attrs
1972: , attronly => 0
1973: , res => l_message);

Line 1974: l_entry := dbms_ldap.first_entry(ldap, l_message);

1970: , filter => 'objectclass=*'
1971: , attrs => l_attrs
1972: , attronly => 0
1973: , res => l_message);
1974: l_entry := dbms_ldap.first_entry(ldap, l_message);
1975: if (l_entry is null ) then
1976: if (fnd_log.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1977: then
1978: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End(not found)');

Line 1982: l_attrs := dbms_ldap.get_values(ldap, l_entry, attName);

1978: fnd_log.string(fnd_log.LEVEL_PROCEDURE, l_module_source, 'End(not found)');
1979: end if;
1980: return 0;
1981: end if;
1982: l_attrs := dbms_ldap.get_values(ldap, l_entry, attName);
1983: l_result := l_attrs.count;
1984: if (fnd_log.LEVEL_STATEMENT >= fnd_log.G_CURRENT_RUNTIME_LEVEL)
1985: then
1986: fnd_log.string(fnd_log.LEVEL_STATEMENT, l_module_source, 'result:'||l_result);

Line 2103: function Helper_NewEmptyCollection return dbms_ldap.STRING_COLLECTION

2099: end if;
2100: raise;
2101: END getDN;
2102:
2103: function Helper_NewEmptyCollection return dbms_ldap.STRING_COLLECTION
2104: is
2105: t dbms_ldap.STRING_COLLECTION ;
2106: begin
2107: return t;

Line 2105: t dbms_ldap.STRING_COLLECTION ;

2101: END getDN;
2102:
2103: function Helper_NewEmptyCollection return dbms_ldap.STRING_COLLECTION
2104: is
2105: t dbms_ldap.STRING_COLLECTION ;
2106: begin
2107: return t;
2108: end Helper_NewEmptyCollection;
2109:

Line 2131: Procedure completeForCreate(ldap in dbms_ldap.session ,p_ldap_user IN OUT nocopy fnd_ldap_user.ldap_user_type )

2127: end loop;
2128: end copyData;
2129:
2130:
2131: Procedure completeForCreate(ldap in dbms_ldap.session ,p_ldap_user IN OUT nocopy fnd_ldap_user.ldap_user_type )
2132: is
2133: replaceFlag boolean;
2134: rdn varchar2(200);
2135: val varchar2(4000);

Line 2201: function getRealmList return dbms_ldap.string_collection

2197: raise;
2198: end completeForCreate;
2199:
2200:
2201: function getRealmList return dbms_ldap.string_collection
2202: IS
2203: ret dbms_ldap.string_collection;
2204: l_module_source varchar2(200) := G_MODULE_SOURCE || 'getRealmList: ';
2205:

Line 2203: ret dbms_ldap.string_collection;

2199:
2200:
2201: function getRealmList return dbms_ldap.string_collection
2202: IS
2203: ret dbms_ldap.string_collection;
2204: l_module_source varchar2(200) := G_MODULE_SOURCE || 'getRealmList: ';
2205:
2206: /*
2207: * 1.0: just return the default realm