APPS.MSD_DEM_PUSH_SETUP_PARAMETERS dependencies on FND_PROFILE

Line 44: x_return_value := fnd_profile.value (p_profile_code);

40: BEGIN
41:
42: IF (p_destination_flag = 'Y')
43: THEN
44: x_return_value := fnd_profile.value (p_profile_code);
45: ELSE
46: x_sql := 'BEGIN :x_ret1 := fnd_profile.value' || g_dblink ||
47: '(''' || p_profile_code || '''); END;';
48: EXECUTE IMMEDIATE x_sql USING OUT x_return_value;

Line 46: x_sql := 'BEGIN :x_ret1 := fnd_profile.value' || g_dblink ||

42: IF (p_destination_flag = 'Y')
43: THEN
44: x_return_value := fnd_profile.value (p_profile_code);
45: ELSE
46: x_sql := 'BEGIN :x_ret1 := fnd_profile.value' || g_dblink ||
47: '(''' || p_profile_code || '''); END;';
48: EXECUTE IMMEDIATE x_sql USING OUT x_return_value;
49: END IF;
50: