DBA Data[Home] [Help]

APPS.MSD_PUSH_SETUP_DATA dependencies on FND_PROFILE

Line 283: l_ret_val := fnd_profile.value(p_profile_name);

279: Begin
280: --
281: if p_DP_Server_flag = 'Y' then
282: --
283: l_ret_val := fnd_profile.value(p_profile_name);
284: --
285: else
286: --
287: l_sql := 'Begin :l_ret1 := fnd_profile.value' || G_DBLINK || '(''' || p_profile_name || '''); End;';

Line 287: l_sql := 'Begin :l_ret1 := fnd_profile.value' || G_DBLINK || '(''' || p_profile_name || '''); End;';

283: l_ret_val := fnd_profile.value(p_profile_name);
284: --
285: else
286: --
287: l_sql := 'Begin :l_ret1 := fnd_profile.value' || G_DBLINK || '(''' || p_profile_name || '''); End;';
288: EXECUTE IMMEDIATE l_sql using OUT l_ret_val;
289: end if;
290: --
291: return l_ret_val;