APPS.DOM_WS_INTERFACE_PUB dependencies on FND_PROFILE_OPTION_VALUES

Line 53: SELECT profile_option_value INTO l_profile_option_value FROM fnd_profile_option_values WHERE profile_option_id =

49:
50:
51: BEGIN
52: -- For bug 8401333
53: SELECT profile_option_value INTO l_profile_option_value FROM fnd_profile_option_values WHERE profile_option_id =
54: (select profile_option_id FROM fnd_profile_options WHERE profile_option_name = 'EGO_ENABLE_PLM')
55: AND LEVEL_ID =10001 AND LEVEL_VALUE=0;
56:
57: IF (l_profile_option_value = '1') THEN

Line 64: FROM fnd_profile_option_values vl , FND_PROFILE_OPTIONS pr

60: IF(l_count > 0) THEN
61: -- For bug 8401333
62:
63: SELECT profile_option_value INTO proxy
64: FROM fnd_profile_option_values vl , FND_PROFILE_OPTIONS pr
65: WHERE vl.profile_option_id = pr.profile_option_id
66: AND pr.PROFILE_OPTION_NAME = 'WEB_PROXY_HOST';
67:
68: --proxy := 'http://www-proxy.us.oracle.com';