APPS.POS_ANON_PKG dependencies on FND_PROFILE

Line 66: l_url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'));

62:
63: END;
64: END IF;
65:
66: l_url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'));
67: fnd_profile.get(
68: name => 'APPS_DATABASE_ID',
69: val => l_dbc);
70:

Line 67: fnd_profile.get(

63: END;
64: END IF;
65:
66: l_url := fnd_web_config.trail_slash(fnd_profile.value('APPS_FRAMEWORK_AGENT'));
67: fnd_profile.get(
68: name => 'APPS_DATABASE_ID',
69: val => l_dbc);
70:
71: IF l_dbc IS null

Line 90: FROM fnd_profile_options

86: PROCEDURE check_guest_resp_fwk_agent IS
87: CURSOR l_hier_cur IS
88: SELECT resp_enabled_flag,
89: hierarchy_type
90: FROM fnd_profile_options
91: WHERE profile_option_name = 'APPS_FRAMEWORK_AGENT'
92: AND Nvl(start_date_active, Sysdate) <= Sysdate
93: AND Nvl(end_date_active, sysdate) >= sysdate;
94:

Line 106: l_value fnd_profile_option_values.profile_option_value%TYPE;

102: (SELECT application_id FROM fnd_application WHERE application_short_name = 'POS');
103:
104: l_resp_rec l_resp_cur%ROWTYPE;
105:
106: l_value fnd_profile_option_values.profile_option_value%TYPE;
107:
108: l_result BOOLEAN;
109:
110: BEGIN

Line 139: l_value = fnd_profile.value_specific

135:
136: --dbms_output.put_line('value ' || l_value);
137:
138: IF l_value IS NULL OR
139: l_value = fnd_profile.value_specific
140: (name => 'APPS_FRAMEWORK_AGENT',
141: user_id => NULL,
142: responsibility_id => l_resp_rec.responsibility_id,
143: application_id => l_resp_rec.application_id,

Line 150: l_result := fnd_profile.save

146: ) THEN
147: NULL;
148: ELSE
149: -- dbms_output.put_line('setting');
150: l_result := fnd_profile.save
151: (x_name => 'APPS_FRAMEWORK_AGENT',
152: x_value => l_value,
153: x_level_name => 'RESP',
154: x_level_value => l_resp_rec.responsibility_id,

Line 292: fnd_profile.get(

288: l_has_resp NUMBER;
289: BEGIN
290: x_enc_session_id := icx_call.encrypt3(p_raw_session_id);
291: x_enc_transaction_id := icx_call.encrypt3(p_raw_transaction_id);
292: fnd_profile.get(
293: name => 'APPS_DATABASE_ID',
294: val => x_dbc_name);
295: IF x_dbc_name IS NULL
296: THEN