APPS.POS_URL_PKG dependencies on FND_PROFILE_OPTION_VALUES

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 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