1: PACKAGE BODY FND_SOS_SERVICE AS
2: /* $Header: fndsosb.pls 120.0.12010000.1 2009/08/17 03:07:14 snellepa noship $ */
3: installed_languages VARCHAR2(3000);
4: database_id VARCHAR2(4500);
5:
13:
14: BEGIN
15: FOR t1 IN c1
16: LOOP
17: FND_SOS_SERVICE.installed_languages := t1.LANGUAGE_CODE || ':'|| FND_SOS_SERVICE.installed_languages ;
18: END LOOP;
19: END getAllInstalledlanguages;
20:
21:
93: IF installed_languages IS NULL THEN
94: getAllInstalledlanguages;
95: END IF;
96: languages:=languages
97: ||':'|| FND_SOS_SERVICE.installed_languages;
98:
99: --+++get database id
100: If FND_SOS_SERVICE.database_id is Null Then
101: getDatabaseID;
96: languages:=languages
97: ||':'|| FND_SOS_SERVICE.installed_languages;
98:
99: --+++get database id
100: If FND_SOS_SERVICE.database_id is Null Then
101: getDatabaseID;
102: End If;
103: apps_database_id:=FND_SOS_SERVICE.database_id;
104:
99: --+++get database id
100: If FND_SOS_SERVICE.database_id is Null Then
101: getDatabaseID;
102: End If;
103: apps_database_id:=FND_SOS_SERVICE.database_id;
104:
105:
106:
107: END authenticate;
137: RETURN retval;
138: END validate_user_cookie;
139:
140:
141: END fnd_sos_service;