DBA Data[Home] [Help]

APPS.MSD_PUSH_SETUP_DATA dependencies on FND_PROFILE

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

275: Begin
276: --
277: if p_DP_Server_flag = 'Y' then
278: --
279: l_ret_val := fnd_profile.value(p_profile_name);
280: --
281: else
282: --
283: l_sql := 'Begin :l_ret1 := fnd_profile.value' || G_DBLINK || '(''' || p_profile_name || '''); End;';

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

279: l_ret_val := fnd_profile.value(p_profile_name);
280: --
281: else
282: --
283: l_sql := 'Begin :l_ret1 := fnd_profile.value' || G_DBLINK || '(''' || p_profile_name || '''); End;';
284: EXECUTE IMMEDIATE l_sql using OUT l_ret_val;
285: end if;
286: --
287: return l_ret_val;