APPS.DOM_WS_INTERFACE_PUB dependencies on FND_PROFILE

Line 49: FROM fnd_profile_option_values vl , FND_PROFILE_OPTIONS pr

45:
46:
47: BEGIN
48: SELECT profile_option_value INTO proxy
49: FROM fnd_profile_option_values vl , FND_PROFILE_OPTIONS pr
50: WHERE vl.profile_option_id = pr.profile_option_id
51: AND pr.PROFILE_OPTION_NAME = 'WEB_PROXY_HOST';
52:
53: --proxy := 'http://www-proxy.us.oracle.com';

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

62: proxy => proxy,
63: no_proxy_domains => '');
64: */
65:
66: v_url := fnd_profile.value('APPS_FRAMEWORK_AGENT');
67: -- v_url := 'http://qapache.us.oracle.com:6482';
68:
69: v_url := v_url || G_DOM_INTERFACE_JSP||'?'||p_param_query_string;
70:

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

373: THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:
377: -- code_debug('YSIREESH: User id: '+FND_PROFILE.Value('USER_ID'));
378: 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;
379: call_dom_interface_jsp
380: (
381: p_param_query_string =>l_param_query_string