APPS.POS_URL_PKG dependencies on FND_PROFILE

Line 186: -- fnd_profile_option_values table

182: FUNCTION get_external_url RETURN VARCHAR2
183: IS
184: -- the size of l_value is larger than the size 240 of
185: -- the profile_option_value column in
186: -- fnd_profile_option_values table
187: l_value VARCHAR2(500);
188: l_position NUMBER;
189: BEGIN
190: l_value := fnd_profile.value('POS_EXTERNAL_URL');

Line 190: l_value := fnd_profile.value('POS_EXTERNAL_URL');

186: -- fnd_profile_option_values table
187: l_value VARCHAR2(500);
188: l_position NUMBER;
189: BEGIN
190: l_value := fnd_profile.value('POS_EXTERNAL_URL');
191: RETURN get_protocol_host_port(l_value);
192: END get_external_url;
193:
194: FUNCTION get_site_apps_servlet_agent

Line 199: FROM fnd_profile_options fpo,

195: RETURN VARCHAR2
196: IS
197: CURSOR l_cur IS
198: SELECT fpov.profile_option_value
199: FROM fnd_profile_options fpo,
200: fnd_profile_option_values fpov
201: WHERE fpo.application_id = 0
202: AND fpo.profile_option_name = 'APPS_SERVLET_AGENT'
203: AND fpo.profile_option_id = fpov.profile_option_id

Line 200: fnd_profile_option_values fpov

196: IS
197: CURSOR l_cur IS
198: SELECT fpov.profile_option_value
199: FROM fnd_profile_options fpo,
200: fnd_profile_option_values fpov
201: WHERE fpo.application_id = 0
202: AND fpo.profile_option_name = 'APPS_SERVLET_AGENT'
203: AND fpo.profile_option_id = fpov.profile_option_id
204: AND fpov.level_id = 10001

Line 207: l_value fnd_profile_option_values.profile_option_value%TYPE;

203: AND fpo.profile_option_id = fpov.profile_option_id
204: AND fpov.level_id = 10001
205: AND fpov.application_id = 0;
206:
207: l_value fnd_profile_option_values.profile_option_value%TYPE;
208:
209: BEGIN
210: OPEN l_cur;
211: IF l_cur%notfound THEN

Line 228: -- fnd_profile_option_values table

224: FUNCTION get_internal_url RETURN VARCHAR2
225: IS
226: -- the size of l_value is larger than the size 240 of
227: -- the profile_option_value column in
228: -- fnd_profile_option_values table
229: l_value VARCHAR2(500);
230: l_position NUMBER;
231:
232: BEGIN

Line 233: l_value := fnd_profile.value('POS_INTERNAL_URL');

229: l_value VARCHAR2(500);
230: l_position NUMBER;
231:
232: BEGIN
233: l_value := fnd_profile.value('POS_INTERNAL_URL');
234: IF l_value IS NULL THEN
235: l_value := get_site_apps_servlet_agent;
236: END IF;
237:

Line 249: l_path := fnd_profile.value('POS_EXTERNAL_LOGON_PATH');

245: IS
246: l_url VARCHAR2(3000);
247: l_path VARCHAR2(500);
248: BEGIN
249: l_path := fnd_profile.value('POS_EXTERNAL_LOGON_PATH');
250: IF l_path IS NULL THEN
251: l_url := fnd_sso_manager.getloginurl;
252: l_url := regexp_replace(l_url,'https?://[^/]+/',get_external_url);
253: ELSE