APPS.DOM_WS_INTERFACE_PUB dependencies on FND_PROFILE

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 54: (select profile_option_id FROM fnd_profile_options WHERE profile_option_name = 'EGO_ENABLE_PLM')

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
58: SELECT Count(*) INTO l_count FROM dom_repositories WHERE protocol = 'WEBSERVICES';

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

Line 81: v_url := fnd_profile.value('APPS_FRAMEWORK_AGENT');

77: proxy => proxy,
78: no_proxy_domains => '');
79: */
80:
81: v_url := fnd_profile.value('APPS_FRAMEWORK_AGENT');
82: -- v_url := 'http://qapache.us.oracle.com:6482';
83:
84: v_url := v_url || G_DOM_INTERFACE_JSP||'?'||p_param_query_string;
85:

Line 452: -- code_debug('YSIREESH: User id: '+FND_PROFILE.Value('USER_ID'));

448: THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: END IF;
451:
452: -- code_debug('YSIREESH: User id: '+FND_PROFILE.Value('USER_ID'));
453: l_param_query_string:='opName=grantAttachmentsOCSRole&familyId='||p_family_id||'&role='||p_role||'&serviceUrl=' || p_service_url || '&userToRole='||p_user_name||'&loggedInUser='||p_user_login;
454: call_dom_interface_jsp
455: (
456: p_param_query_string =>l_param_query_string