APPS.MSD_DEM_PUSH_SETUP_PARAMETERS dependencies on FND_PROFILE

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

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

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

46: IF (p_destination_flag = 'Y')
47: THEN
48: x_return_value := fnd_profile.value (p_profile_code);
49: ELSE
50: x_sql := 'BEGIN :x_ret1 := fnd_profile.value' || g_dblink ||
51: '(''' || p_profile_code || '''); END;';
52: EXECUTE IMMEDIATE x_sql USING OUT x_return_value;
53: END IF;
54: